Oracle Applications: Submitting Concurrent Request Using FND_CONCURRENT.WAIT_FOR_REQUEST Sample Code

Posted by Jiltin     Tags: , 15 May, 2009    10,053 views    (0) Comment

When submitting concurrent requests using PL/SQL, it is often desired to have the parent process wait until all the child processes have completed before completing itself. The following describes the function used to accomplish this. Refer Metalink 1021956.6: The following describes how to submit concurrent requests using PL/SQL and have the parent request ‘wait’ until each of the child processes have completed before it completes. Use the FND_CONCURRENT.WAIT_FOR_REQUEST Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL Tags : ,

Workflow API – function activity is usually defined by a PL/SQL stored procedure

Posted by Jiltin     Tags: , , 16 March, 2009    1,061 views    (0) Comment

A function activity is usually defined by a PL/SQL stored procedure that performs some automated processing within a workflow process. •The PL/SQL procedure for a function activity must follow a standard API. All PL/SQL stored procedures called by function activities in a workflow process must follow the standard API format so that the Workflow Engine can properly execute the activity. procedure (itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, resultout out Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags : , ,

The MD4, MD5 using PLSQL hashing algorithms

Posted by Jiltin     Tags: , , 11 November, 2008    3,641 views    (0) Comment

Long back, around 2001, I download the script from http://www.gt.ed.net/keith/plsql/. This link is dead as of date. They are working plsql scripts that I have tested long back. Introduction MD4 and MD5 are one-way hashing algorithms designed to create compact, fixed-length (256 bit) digital signatures (checksums/fingerprints) by generating hashes that are unique and not reversible. They are also useful to provide secure hashing of passwords, especially when robust password validation is used Read Full Article (Click here)...

Categories : Scripts Oracle Tags : , ,