APPS.CSM_QUERY_PKG dependencies on CSM_QUERY_B

Line 118: SELECT CSM_QUERY_B_S.NEXTVAL

114: )
115: AS
116: CURSOR c_get_query_id --get query_id
117: IS
118: SELECT CSM_QUERY_B_S.NEXTVAL
119: FROM DUAL;
120:
121: l_query_id NUMBER;
122: l_variable_count NUMBER;

Line 240: INSERT INTO CSM_QUERY_B ( QUERY_ID, QUERY_NAME, QUERY_TYPE,

236: FETCH c_get_query_id INTO l_query_id;
237: CLOSE c_get_query_id;
238:
239: --Insert the Basic Query Definition into the base table
240: INSERT INTO CSM_QUERY_B ( QUERY_ID, QUERY_NAME, QUERY_TYPE,
241: QUERY_TEXT1, QUERY_TEXT2, LEVEL_ID,
242: LEVEL_VALUE, PARENT_QUERY_ID, SAVED_QUERY,
243: QUERY_OUTPUT_FORMAT, MIME_TYPE, WORK_FLOW,
244: RETENTION_POLICY, RETENTION_DAYS, TEMPLATE,

Line 351: FROM CSM_QUERY_B

347:
348: CURSOR c_get_query(c_query_id NUMBER) --get the existing query data
349: IS
350: SELECT LEVEL_VALUE
351: FROM CSM_QUERY_B
352: WHERE QUERY_ID = c_query_id ;
353:
354:
355: l_Existing_variable_count NUMBER;

Line 519: UPDATE CSM_QUERY_B

515: END IF;
516: END IF; --level value check
517:
518: --Update the Query Definition in the base table
519: UPDATE CSM_QUERY_B
520: SET QUERY_NAME = p_QUERY_NAME, QUERY_TYPE = p_QUERY_TYPE,
521: QUERY_TEXT1 = p_QUERY_TEXT1, QUERY_TEXT2 = p_QUERY_TEXT2,
522: LEVEL_ID = p_LEVEL_ID, LEVEL_VALUE = p_LEVEL_VALUE,
523: PARENT_QUERY_ID = p_PARENT_QUERY_ID, SAVED_QUERY = p_SAVED_QUERY,

Line 662: UPDATE CSM_QUERY_B

658: ( 'Entering DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,'CSM_QUERY_PKG.DELETE_QUERY',
659: FND_LOG.LEVEL_ERROR);
660:
661: --Update the Query Definition in the base table
662: UPDATE CSM_QUERY_B
663: SET DELETE_FLAG = 'Y',
664: LAST_UPDATE_DATE = sysdate,
665: LAST_UPDATED_BY = fnd_global.user_id,
666: LAST_UPDATE_LOGIN = fnd_global.login_id

Line 670: UPDATE CSM_QUERY_B

666: LAST_UPDATE_LOGIN = fnd_global.login_id
667: WHERE QUERY_ID = p_QUERY_ID;
668:
669: --Update the Query Definition in the base table for parent queries
670: UPDATE CSM_QUERY_B
671: SET DELETE_FLAG = 'Y',
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATED_BY = fnd_global.user_id,
674: LAST_UPDATE_LOGIN = fnd_global.login_id

Line 717: FROM CSM_QUERY_B

713:
714: CURSOR c_get_query_txt (c_QUERY_ID NUMBER)
715: IS
716: SELECT QUERY_TEXT1,QUERY_TEXT2
717: FROM CSM_QUERY_B
718: WHERE QUERY_ID = c_QUERY_ID;
719: BEGIN
720: CSM_UTIL_PKG.LOG
721: ( 'Entering VALIDATE_QUERY for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_QUERY',

Line 816: FROM CSM_QUERY_B

812: QUERY_TEXT2,
813: QUERY_TYPE,
814: WORK_FLOW,
815: PROCEDURE_NAME
816: FROM CSM_QUERY_B
817: WHERE QUERY_ID =c_QUERY_ID;
818:
819: CURSOR c_check_instance(c_USER_ID NUMBER,c_QUERY_ID NUMBER,c_INSTANCE_ID NUMBER)
820: IS

Line 1195: FROM CSM_QUERY_B

1191: AS
1192: CURSOR c_check_query(c_QUERY_ID NUMBER)
1193: IS
1194: SELECT QUERY_NAME,LEVEL_ID,LEVEL_VALUE,QUERY_TYPE
1195: FROM CSM_QUERY_B
1196: WHERE QUERY_ID =c_QUERY_ID
1197: AND NVL(DELETE_FLAG,'N') = 'N';
1198:
1199: CURSOR c_check_query_acc(c_QUERY_ID NUMBER, c_USER_ID NUMBER)

Line 1469: FROM CSM_QUERY_B

1465: l_temp_query_clob CLOB;
1466: CURSOR c_get_query_txt (c_QUERY_ID NUMBER)
1467: IS
1468: SELECT QUERY_TEXT1,QUERY_TEXT2
1469: FROM CSM_QUERY_B
1470: WHERE QUERY_ID = c_QUERY_ID;
1471:
1472: CURSOR c_check_table_access (c_schema VARCHAR2,c_object_name VARCHAR2)
1473: IS

Line 1748: FROM CSM_QUERY_B

1744: l_TEMP_VARIABLE VARCHAR2(30);
1745: CURSOR c_get_wf (c_query_id NUMBER)
1746: IS
1747: SELECT WORK_FLOW
1748: FROM CSM_QUERY_B
1749: WHERE QUERY_ID = c_query_id;
1750:
1751: CURSOR c_get_item_type (c_work_flow VARCHAR2)
1752: IS

Line 1855: FROM CSM_QUERY_B

1851:
1852: CURSOR c_get_procedure (c_query_id NUMBER)
1853: IS
1854: SELECT procedure_name
1855: FROM CSM_QUERY_B
1856: WHERE QUERY_ID = c_query_id;
1857:
1858: CURSOR c_is_package_valid (c_package_name VARCHAR2, p_schema_name VARCHAR2)
1859: IS