APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on JTF_UM_APPROVAL_REQUESTS_PVT

Line 1: PACKAGE BODY JTF_UM_APPROVAL_REQUESTS_PVT as

1: PACKAGE BODY JTF_UM_APPROVAL_REQUESTS_PVT as
2: /* $Header: JTFVAPRB.pls 120.11 2009/11/24 15:36:25 dbowles ship $ */
3: TYPE APPR_REQ_CUR is REF CURSOR;
4: /**
5: * Procedure : PENDING_APPROVAL_SYSADMIN

Line 35: JTF_UM_APPROVAL_REQUESTS_PVT.getWorkflowActivityStatus(WF_ITEM_TYPE,REG_ID) ERROR_ACTIVITY

31: FROM (
32: SELECT sys_requests.REG_ID, sys_requests.REG_LAST_UPDATE_DATE, sys_requests.USER_NAME,
33: sys_requests.PARTY_TYPE, sys_requests.PARTY_ID, sys_requests.ENTITY_SOURCE,
34: sys_requests.ENTITY_NAME, sys_requests.WF_ITEM_TYPE, sys_requests.APPROVER,
35: JTF_UM_APPROVAL_REQUESTS_PVT.getWorkflowActivityStatus(WF_ITEM_TYPE,REG_ID) ERROR_ACTIVITY
36: FROM (
37: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
38: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
39: ''USERTYPE'' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,

Line 159: JTF_UM_APPROVAL_REQUESTS_PVT.getWorkflowActivityStatus(WF_ITEM_TYPE,REG_ID) ERROR_ACTIVITY

155: APPR_REQ APPR_REQ_CUR;
156: qry varchar2(4000) := 'SELECT * FROM
157: (SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, ENTITY_SOURCE,
158: ENTITY_NAME, WF_ITEM_TYPE,
159: JTF_UM_APPROVAL_REQUESTS_PVT.getWorkflowActivityStatus(WF_ITEM_TYPE,REG_ID) ERROR_ACTIVITY
160: FROM (
161: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
162: FU.USER_NAME USER_NAME, ''USERTYPE'' ENTITY_SOURCE,
163: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE

Line 297: JTF_UM_APPROVAL_REQUESTS_PVT.getWorkflowActivityStatus(WF_ITEM_TYPE, REG_ID) ERROR_ACTIVITY

293: APPR_REQ APPR_REQ_CUR;
294: qry varchar2(4000) := 'SELECT * FROM
295: (SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, PARTY_TYPE, PARTY_ID,
296: ENTITY_SOURCE, ENTITY_NAME, WF_ITEM_TYPE,
297: JTF_UM_APPROVAL_REQUESTS_PVT.getWorkflowActivityStatus(WF_ITEM_TYPE, REG_ID) ERROR_ACTIVITY
298: FROM (
299: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE
300: REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME,
301: PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,

Line 436: end JTF_UM_APPROVAL_REQUESTS_PVT;

432: ret_val := -3;
433: end;
434: return ret_val;
435: end;
436: end JTF_UM_APPROVAL_REQUESTS_PVT;