APPS.CSM_QUERY_EVENT_PKG dependencies on CSM_QUERY_VARIABLES_ACC

Line 61: SELECT CSM_QUERY_VARIABLES_ACC_S.NEXTVAL,

57: );
58:
59: CURSOR c_query_var_ins
60: IS
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,

Line 71: FROM CSM_QUERY_VARIABLES_ACC vacc

67: WHERE qacc.QUERY_ID = b.QUERY_ID
68: AND NOT EXISTS
69: (
70: SELECT 1
71: FROM CSM_QUERY_VARIABLES_ACC vacc
72: WHERE vacc.QUERY_ID = qacc.QUERY_ID
73: AND vacc.USER_ID = qacc.USER_ID
74: AND b.VARIABLE_ID = vacc.VARIABLE_ID
75: );

Line 92: FROM CSM_QUERY_VARIABLES_ACC acc,

88: CURSOR c_query_var_upd(p_lastrundate IN date)
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;

Line 116: FROM CSM_QUERY_VARIABLES_ACC acc,

112: CURSOR c_query_variables_del
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:

Line 235: DELETE FROM csm_query_variables_acc WHERE access_id = l_access_list(i);

231: p_timestamp => l_run_date);
232:
233: END LOOP;
234: FORALL i IN 1..l_access_list.count
235: DELETE FROM csm_query_variables_acc WHERE access_id = l_access_list(i);
236:
237: COMMIT;
238:
239: END LOOP;

Line 469: INSERT INTO CSM_QUERY_VARIABLES_ACC

465: p_timestamp => l_run_date);
466:
467: END LOOP;
468: FORALL i IN 1..l_access_list.count
469: INSERT INTO CSM_QUERY_VARIABLES_ACC
470: (ACCESS_ID,
471: USER_ID,
472: QUERY_ID,
473: VARIABLE_ID,

Line 565: SELECT CSM_QUERY_VARIABLES_ACC_S.NEXTVAL,

561: );
562:
563: CURSOR c_query_var_ins(c_user_id NUMBER)
564: IS
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,

Line 576: FROM CSM_QUERY_VARIABLES_ACC vacc

572: AND qacc.USER_ID = c_user_id
573: AND NOT EXISTS
574: (
575: SELECT 1
576: FROM CSM_QUERY_VARIABLES_ACC vacc
577: WHERE vacc.QUERY_ID = qacc.QUERY_ID
578: AND vacc.USER_ID = qacc.USER_ID
579: AND b.VARIABLE_ID = vacc.VARIABLE_ID
580: );

Line 654: INSERT INTO CSM_QUERY_VARIABLES_ACC

650: FETCH c_query_var_ins BULK COLLECT INTO l_access_list,l_user_list,l_query_id_list,l_variable_id_list LIMIT 100;
651: EXIT WHEN l_access_list.count = 0;
652:
653: FORALL i IN 1..l_access_list.count
654: INSERT INTO CSM_QUERY_VARIABLES_ACC
655: (ACCESS_ID,
656: USER_ID,
657: QUERY_ID,
658: VARIABLE_ID,