Monday, December 18, 2017

1) Calling a Package procedure in personalization:

Go To personalization, Type required event , go to actions, Action Type--> Builtin -->
Builtin Type--> Execute a Procedure

Syntax:

='BEGIN apps.xxcust_pkg_name.proc_name('''||${ITEM.DLVY.NAME.value}||''','''||${ITEM.DLVY.ATTRIBUTE1.value}||''','||${ITEM.DLVY.DELIVERY_ID.VALUE} ||','||'FND_PROFILE.VALUE('||'''ORG_ID'''||'),'||'NULL'||','||'''STDFRM'''||','||'NULL'||');  END'



use below sql query in plsql/toad  to insert actual fields:

SELECT
'BEGIN apps.xxcust_vat_exmp_pkg.XXTAJ_INSERT_TABLE1('||&Avalue||','||&Bvalue||','||&CVALUE||','||'FND_PROFILE.VALUE('||'''ORG_ID'''||'),'||'''  '''||');  END'
FROM DUAL

Once this show properly in toad, replace &value with syntax like : ${ITEM.DLVY.NAME.value}

To see personalization to enable on which event:

Go to Help--> Diagnostics--> custom Code--> show custom events

No comments:

Post a Comment