Calling Stored procedure through Forms Personalization

This post describes how to call stored procedure through Form Personalization.

Calling stored procedure through Forms Personalization in Oracle apps for the user entered values.

Following are the steps to be followed :


Conditions :

Trigger Event : WHEN-VALIDATE-RECORD

Trigger Object : As appropriate

Condition : As appropriate

Actions :

Seq : 10

Type : Builtin

Description : Calling Stored procedure

Language : All

Builtin Type : Execute a Procedure

Argument :

='DECLARE
l_retcode NUMBER
l_errbuf   VARCHAR2(2000);
BEGIN

xx_custom_package.main_procedure(l_retcode,l_errbuf,'||${item.BLOCK_NAME.ITEM_NAME.value}||','||
${item.BLOCK_NAME.ITEM_NAME.value}||');

END'