APPS.CSM_MOBILE_QUERY_PKG dependencies on CSM_QUERY_B

Line 65: SELECT CSM_QUERY_B_S.NEXTVAL

61: )
62: AS
63: CURSOR c_get_query_id --get query_id
64: IS
65: SELECT CSM_QUERY_B_S.NEXTVAL
66: FROM DUAL;
67:
68: CURSOR c_get_resp_id (c_parent_query_id NUMBER)
69: IS

Line 71: FROM CSM_QUERY_B

67:
68: CURSOR c_get_resp_id (c_parent_query_id NUMBER)
69: IS
70: SELECT LEVEL_ID, LEVEL_VALUE
71: FROM CSM_QUERY_B
72: WHERE QUERY_ID = c_parent_query_id;
73:
74: l_query_id NUMBER;
75: l_variable_count NUMBER;

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

180: ELSE
181: l_query_id:= p_QUERY_ID;
182: END IF;
183: --Insert the Basic Query Definition into the base table
184: INSERT INTO CSM_QUERY_B ( QUERY_ID, QUERY_NAME, QUERY_TYPE,
185: QUERY_TEXT1, QUERY_TEXT2, LEVEL_ID,
186: LEVEL_VALUE, PARENT_QUERY_ID, SAVED_QUERY,
187: QUERY_OUTPUT_FORMAT, MIME_TYPE, WORK_FLOW,
188: RETENTION_POLICY, RETENTION_DAYS, TEMPLATE,

Line 259: FROM CSM_QUERY_B

255: IS
256: SELECT QUERY_NAME, QUERY_TYPE, QUERY_TEXT1, QUERY_TEXT2,
257: QUERY_OUTPUT_FORMAT, MIME_TYPE, WORK_FLOW, RETENTION_POLICY,
258: RETENTION_DAYS, TEMPLATE, TEMPLATE_FILE, EXECUTION_MODE
259: FROM CSM_QUERY_B
260: WHERE QUERY_ID =c_QUERY_ID
261: AND NVL(DELETE_FLAG,'N') = 'N';
262:
263: CURSOR c_get_variables (c_QUERY_ID NUMBER)

Line 425: FROM CSM_QUERY_B

421: IS
422: CURSOR c_check_query(c_QUERY_ID NUMBER, c_USER_ID NUMBER)
423: IS
424: SELECT NVL(DELETE_FLAG,'N')
425: FROM CSM_QUERY_B
426: WHERE QUERY_ID = c_QUERY_ID
427: AND LEVEL_ID = 10004 --user level
428: AND LEVEL_VALUE = c_USER_ID
429: AND SAVED_QUERY = 'Y'

Line 468: UPDATE CSM_QUERY_B

464: x_return_status := FND_API.G_RET_STS_ERROR;
465: RETURN;
466: END IF;
467: --Update the Query Definition in the base table
468: UPDATE CSM_QUERY_B
469: SET DELETE_FLAG = 'Y',
470: LAST_UPDATE_DATE = sysdate,
471: LAST_UPDATED_BY = fnd_global.user_id,
472: LAST_UPDATE_LOGIN = fnd_global.login_id