APPS.CSM_QUERY_EVENT_PKG dependencies on CSM_QUERY_B

Line 23: TYPE QUERY_LIST IS TABLE OF CSM_QUERY_B.QUERY_ID%TYPE INDEX BY BINARY_INTEGER;

19: PROCEDURE REFRESH_ACC(p_status OUT NOCOPY VARCHAR2,
20: p_message OUT NOCOPY VARCHAR2)
21: IS
22: PRAGMA AUTONOMOUS_TRANSACTION;
23: TYPE QUERY_LIST IS TABLE OF CSM_QUERY_B.QUERY_ID%TYPE INDEX BY BINARY_INTEGER;
24: TYPE VARIABLE_LIST IS TABLE OF CSM_QUERY_VARIABLES_B.VARIABLE_ID%TYPE INDEX BY BINARY_INTEGER;
25:
26: l_run_date DATE;
27: l_sqlerrno VARCHAR2(20);

Line 43: FROM CSM_QUERY_B b,

39: IS
40: SELECT CSM_QUERY_ACC_S.NEXTVAL,
41: au.USER_ID,
42: b.QUERY_ID
43: FROM CSM_QUERY_B b,
44: ASG_USER au
45: WHERE ( (b.LEVEL_ID = 10003 AND b.LEVEL_VALUE = au.responsibility_id)--Support for Responsiblity
46: OR (b.LEVEL_ID = 10004 AND b.LEVEL_VALUE = au.USER_ID)
47: OR (b.LEVEL_ID = 10001 AND b.LEVEL_VALUE =0) )

Line 84: CSM_QUERY_B b

80: IS
81: SELECT acc.ACCESS_ID,
82: acc.USER_ID
83: FROM CSM_QUERY_ACC acc,
84: CSM_QUERY_B b
85: WHERE acc.QUERY_ID = b.QUERY_ID
86: AND b.LAST_UPDATE_DATE >= p_lastrundate;
87:
88: CURSOR c_query_var_upd(p_lastrundate IN date)

Line 107: FROM CSM_QUERY_B b

103: acc.USER_ID
104: FROM CSM_QUERY_ACC acc
105: WHERE EXISTS
106: (SELECT 1
107: FROM CSM_QUERY_B b
108: WHERE b.QUERY_ID = acc.QUERY_ID
109: AND NVL(b.DELETE_FLAG,'N') ='Y'
110: );
111: --Delete Query Variables from the ACC

Line 117: CSM_QUERY_B b

113: IS
114: SELECT acc.ACCESS_ID,
115: acc.USER_ID
116: FROM CSM_QUERY_VARIABLES_ACC acc,
117: CSM_QUERY_B b
118: WHERE b.QUERY_ID = acc.QUERY_ID
119: AND NVL(b.DELETE_FLAG,'N') ='Y';
120:
121: --Delete Query Instances from the ACC

Line 127: CSM_QUERY_B b

123: IS
124: SELECT acc.ACCESS_ID,
125: acc.USER_ID
126: FROM CSM_QUERY_INSTANCES_ACC acc,
127: CSM_QUERY_B b
128: WHERE b.QUERY_ID = acc.QUERY_ID
129: AND ( NVL(b.DELETE_FLAG,'N') ='Y'
130: OR ( UPPER(b.RETENTION_POLICY) = 'AUTOMATIC'
131: AND acc.LAST_UPDATE_DATE < (SYSDATE-nvl(b.RETENTION_DAYS,1000))

Line 499: DELETE FROM CSM_QUERY_B

495: CLOSE c_query_var_ins;
496: CSM_UTIL_PKG.LOG('Completed Query Variable Inserts', 'CSM_QUERY_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
497:
498: --Delete Saved Queries that are deleted as part of Parent Query
499: DELETE FROM CSM_QUERY_B
500: WHERE LEVEL_ID =10004
501: AND SAVED_QUERY ='Y'
502: AND DELETE_FLAG ='Y';
503:

Line 531: TYPE QUERY_LIST IS TABLE OF CSM_QUERY_B.QUERY_ID%TYPE INDEX BY BINARY_INTEGER;

527: END REFRESH_ACC;
528:
529: PROCEDURE REFRESH_USER(p_user_id NUMBER)
530: IS
531: TYPE QUERY_LIST IS TABLE OF CSM_QUERY_B.QUERY_ID%TYPE INDEX BY BINARY_INTEGER;
532: TYPE VARIABLE_LIST IS TABLE OF CSM_QUERY_VARIABLES_B.VARIABLE_ID%TYPE INDEX BY BINARY_INTEGER;
533: l_sqlerrno VARCHAR2(20);
534: l_sqlerrmsg VARCHAR2(2000);
535: l_mark_dirty boolean;

Line 547: FROM CSM_QUERY_B b,

543: IS
544: SELECT CSM_QUERY_ACC_S.NEXTVAL,
545: au.USER_ID,
546: b.QUERY_ID
547: FROM CSM_QUERY_B b,
548: ASG_USER au
549: WHERE ( (b.LEVEL_ID = 10003 AND b.LEVEL_VALUE = au.responsibility_id)--Support for Responsiblity
550: OR (b.LEVEL_ID = 10004 AND b.LEVEL_VALUE = au.USER_ID)--Saved Query
551: OR (b.LEVEL_ID = 10001 AND b.LEVEL_VALUE =0) )--Site level