14:
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDRTGAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_Routing_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:
21: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDRTGAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_Routing_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:
21: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
85:
86: -- get values to be stored into the workflow item
87: SELECT USER_NAME , DESCRIPTION
88: INTO l_performer_name ,l_performer_display_name
89: FROM FND_USER
90: WHERE USER_ID = p_Requester;
91:
92: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
93: aname => 'GMDRTGAP_REQUSTER',
100: WHERE ROUTING_ID = P_ROUTING_ID;
101:
102: SELECT USER_NAME , DESCRIPTION
103: INTO l_performer_name ,l_performer_display_name
104: FROM FND_USER
105: WHERE USER_ID = l_owner_id;
106:
107: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
108: aname => 'GMDRTGAP_OWNER_ID',