APPS.CSM_QUERY_EVENT_PKG dependencies on CSM_QUERY_VARIABLES_B

Line 24: TYPE VARIABLE_LIST IS TABLE OF CSM_QUERY_VARIABLES_B.VARIABLE_ID%TYPE INDEX BY BINARY_INTEGER;

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);
28: l_sqlerrmsg VARCHAR2(2000);

Line 65: FROM CSM_QUERY_VARIABLES_B b,

61: SELECT CSM_QUERY_VARIABLES_ACC_S.NEXTVAL,
62: qacc.USER_ID,
63: b.QUERY_ID,
64: b.VARIABLE_ID
65: FROM CSM_QUERY_VARIABLES_B b,
66: CSM_QUERY_ACC qacc
67: WHERE qacc.QUERY_ID = b.QUERY_ID
68: AND NOT EXISTS
69: (

Line 93: CSM_QUERY_VARIABLES_B b

89: IS
90: SELECT acc.ACCESS_ID,
91: acc.USER_ID
92: FROM CSM_QUERY_VARIABLES_ACC acc,
93: CSM_QUERY_VARIABLES_B b
94: WHERE acc.QUERY_ID = b.QUERY_ID
95: AND acc.VARIABLE_ID = b.VARIABLE_ID
96: AND b.LAST_UPDATE_DATE >= p_lastrundate;
97:

Line 532: TYPE VARIABLE_LIST IS TABLE OF CSM_QUERY_VARIABLES_B.VARIABLE_ID%TYPE INDEX BY BINARY_INTEGER;

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;
536: l_access_list asg_download.access_list;

Line 569: FROM CSM_QUERY_VARIABLES_B b,

565: SELECT CSM_QUERY_VARIABLES_ACC_S.NEXTVAL,
566: qacc.USER_ID,
567: b.QUERY_ID,
568: b.VARIABLE_ID
569: FROM CSM_QUERY_VARIABLES_B b,
570: CSM_QUERY_ACC qacc
571: WHERE qacc.QUERY_ID = b.QUERY_ID
572: AND qacc.USER_ID = c_user_id
573: AND NOT EXISTS