APPS.CSM_QUERY_EVENT_PKG dependencies on CSM_QUERY_ACC

Line 40: SELECT CSM_QUERY_ACC_S.NEXTVAL,

36:
37: -- Cursor Declaration
38: CURSOR c_query_ins
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

Line 54: FROM CSM_QUERY_ACC acc

50: AND NVL(b.DELETE_FLAG,'N') = 'N'
51: AND NOT EXISTS
52: (
53: SELECT 1
54: FROM CSM_QUERY_ACC acc
55: WHERE acc.QUERY_ID = b.QUERY_ID
56: AND acc.USER_ID = au.USER_ID
57: );
58:

Line 66: CSM_QUERY_ACC qacc

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: (
70: SELECT 1

Line 83: FROM CSM_QUERY_ACC acc,

79: CURSOR c_query_upd(p_lastrundate IN date)
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:

Line 104: FROM CSM_QUERY_ACC acc

100: CURSOR c_query_del
101: IS
102: SELECT acc.ACCESS_ID,
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

Line 205: DELETE FROM csm_query_acc WHERE access_id = l_access_list(i);

201: p_timestamp => l_run_date);
202:
203: END LOOP;
204: FORALL i IN 1..l_access_list.count
205: DELETE FROM csm_query_acc WHERE access_id = l_access_list(i);
206:
207: COMMIT;
208:
209: END LOOP;

Line 417: INSERT INTO CSM_QUERY_ACC

413: p_timestamp => l_run_date);
414:
415: END LOOP;
416: FORALL i IN 1..l_access_list.count
417: INSERT INTO CSM_QUERY_ACC
418: (ACCESS_ID,
419: USER_ID,
420: QUERY_ID,
421: CREATED_BY, CREATION_DATE,

Line 544: SELECT CSM_QUERY_ACC_S.NEXTVAL,

540:
541: -- Cursor Declaration
542: CURSOR c_query_ins (c_user_id NUMBER)
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

Line 558: FROM CSM_QUERY_ACC acc

554: AND NVL(b.DELETE_FLAG,'N') = 'N'
555: AND NOT EXISTS
556: (
557: SELECT 1
558: FROM CSM_QUERY_ACC acc
559: WHERE acc.QUERY_ID = b.QUERY_ID
560: AND acc.USER_ID = au.user_ID
561: );
562:

Line 570: CSM_QUERY_ACC qacc

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
574: (

Line 602: INSERT INTO CSM_QUERY_ACC

598: FETCH c_query_ins BULK COLLECT INTO l_access_list,l_user_list,l_query_id_list LIMIT 100;
599: EXIT WHEN l_access_list.count = 0;
600:
601: FORALL i IN 1..l_access_list.count
602: INSERT INTO CSM_QUERY_ACC
603: (ACCESS_ID,
604: USER_ID,
605: QUERY_ID,
606: CREATED_BY, CREATION_DATE,