Calling Stored procedure through Forms Personalization
Calling Stored procedure through Forms 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
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'${item.BLOCK_NAME.ITEM_NAME.value}||');
No comments:
Post a Comment