APPS.CSM_QUERY_INSTANCE_PKG dependencies on CSM_QUERY_INSTANCES_ACC

Line 69: SELECT CSM_QUERY_INSTANCES_ACC_S.NEXTVAL

65: AND vb.INSTANCE_ID = c_instance_id;
66:
67: CURSOR c_get_next_instance
68: IS
69: SELECT CSM_QUERY_INSTANCES_ACC_S.NEXTVAL
70: FROM DUAL;
71:
72: CURSOR c_get_user(c_user_name VARCHAR2)
73: IS

Line 168: INSERT INTO CSM_QUERY_INSTANCES_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , INSTANCE_NAME,STATUS,

164: FETCH c_get_next_instance INTO l_instance_id;
165: CLOSE c_get_next_instance;
166: END IF;
167: --Insert the Instance
168: INSERT INTO CSM_QUERY_INSTANCES_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , INSTANCE_NAME,STATUS,
169: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
170: VALUES (l_instance_id, l_user_id, l_query_id, l_instance_id,l_instance_name,'OPEN',
171: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
172:

Line 332: FROM CSM_QUERY_INSTANCES_ACC

328:
329: CURSOR c_get_queryid (c_instance_id NUMBER)
330: IS
331: SELECT QUERY_ID
332: FROM CSM_QUERY_INSTANCES_ACC
333: WHERE INSTANCE_ID = c_instance_id;
334:
335: --Variable Declarations
336: l_msg_count NUMBER;