APPS.CSM_QUERY_PKG dependencies on CSM_QUERY_VARIABLE_VALUES_ACC

Line 836: CSM_QUERY_VARIABLE_VALUES_ACC vacc,

832: vb.VARIABLE_TYPE,
833: vb.VARIABLE_NAME
834: FROM
835: CSM_QUERY_INSTANCES_ACC iacc,
836: CSM_QUERY_VARIABLE_VALUES_ACC vacc,
837: CSM_QUERY_VARIABLES_B vb
838: WHERE iacc.USER_ID = vacc.USER_ID
839: AND iacc.QUERY_ID = vacc.QUERY_ID
840: AND iacc.INSTANCE_ID = vacc.INSTANCE_ID

Line 1393: INSERT INTO CSM_QUERY_VARIABLE_VALUES_ACC(ACCESS_ID , USER_ID , QUERY_ID ,

1389: CLOSE c_get_next_qvariableid;
1390:
1391: l_VARIABLE_VALUE_CHAR := SUBSTR(p_VARIABLE_VALUE_CHAR(i),1, 4000);
1392:
1393: INSERT INTO CSM_QUERY_VARIABLE_VALUES_ACC(ACCESS_ID , USER_ID , QUERY_ID ,
1394: INSTANCE_ID , VARIABLE_ID,VARIABLE_VALUE_CHAR,VARIABLE_VALUE_DATE,
1395: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,GEN_PK)
1396: VALUES (l_qvariable_id, p_USER_ID, p_QUERY_ID,
1397: l_instance_id, i, l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),

Line 1624: FROM CSM_QUERY_VARIABLE_VALUES_ACC

1620:
1621: CURSOR c_get_ins_varval (c_USER_ID NUMBER, c_QUERY_ID NUMBER, c_INSTANCE_ID NUMBER )
1622: IS
1623: SELECT ACCESS_ID
1624: FROM CSM_QUERY_VARIABLE_VALUES_ACC
1625: WHERE QUERY_ID = c_QUERY_ID
1626: AND USER_ID = c_USER_ID
1627: AND INSTANCE_ID = c_INSTANCE_ID;
1628:

Line 1677: DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC WHERE ACCESS_ID = l_access_id_list(i);

1673: FETCH c_get_ins_varval BULK COLLECT INTO l_access_id_list;
1674: CLOSE c_get_ins_varval;
1675:
1676: FORALL i in 1..l_access_id_list.COUNT
1677: DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC WHERE ACCESS_ID = l_access_id_list(i);
1678:
1679: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1680: FOR i in 1..l_access_id_list.COUNT LOOP
1681: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,