DBA Data[Home] [Help]

APPS.GMDOPLAP_WF_PKG dependencies on FND_USER

Line 18: l_performer_name FND_USER.USER_NAME%TYPE ;

14:
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDOPLAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_operation_id)||'-'||to_char(p_last_update_date,'dd-MON-yyyy HH24:mi:ss');
17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
21:
22: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */

Line 19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDOPLAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_operation_id)||'-'||to_char(p_last_update_date,'dd-MON-yyyy HH24:mi:ss');
17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
21:
22: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
23: l_oprn_desc GMD_OPERATIONS.OPRN_DESC%TYPE;

Line 86: FROM FND_USER

82:
83: -- get values to be stored into the workflow item
84: SELECT USER_NAME , DESCRIPTION
85: INTO l_performer_name ,l_performer_display_name
86: FROM FND_USER
87: WHERE USER_ID = p_Requester;
88:
89: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
90: aname => 'GMDOPLAP_REQUSTER',