APPS.CSM_HTML5_PKG dependencies on CSM_QUERY_PKG

Line 895: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 5, NULL, 'REUSABLE_SCHEMA', l_id, l_ch, l_dt,NULL, instId, ret, m);

891: WHEN Others THEN
892: instId:=-1;
893: END;
894:
895: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 5, NULL, 'REUSABLE_SCHEMA', l_id, l_ch, l_dt,NULL, instId, ret, m);
896:
897: CSM_UTIL_PKG.LOG('Instance Insert Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);
898:
899: IF (ret=fnd_api.g_ret_sts_success) THEN

Line 936: l_instance NUMBER:=CSM_QUERY_PKG.G_INST_IN_PROCESS;

932: FUNCTION create_session(p_user_name IN VARCHAR2,p_mode IN VARCHAR2,p_full_sync IN VARCHAR2 :='N') return NUMBER
933: IS
934: PRAGMA AUTONOMOUS_TRANSACTION;
935: l_session_id NUMBER;
936: l_instance NUMBER:=CSM_QUERY_PKG.G_INST_IN_PROCESS;
937: l_cnt NUMBER:=0;
938: BEGIN
939:
940: SELECT csm_html5_sync_s.NEXTVAL INTO l_session_id FROM DUAL;

Line 2366: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 16, NULL, 'SYNCHRONOUS_UPLOAD', l_id, l_ch, l_dt,NULL, instId, ret, m);

2362: l_id(1):=1; l_ch(1):=p_user_name;
2363:
2364: l_id(2):=2; l_ch(2):=l_session_id;
2365:
2366: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 16, NULL, 'SYNCHRONOUS_UPLOAD', l_id, l_ch, l_dt,NULL, instId, ret, m);
2367:
2368: IF (ret=fnd_api.g_ret_sts_success) THEN
2369: CSM_UTIL_PKG.LOG('Created Instance -:'||instId, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2370:

Line 2409: CSM_QUERY_PKG.EXECUTE_QUERY(p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, RETCODE, errbuf);

2405: p_INSTANCE_ID IN NUMBER
2406: )
2407: IS
2408: BEGIN
2409: CSM_QUERY_PKG.EXECUTE_QUERY(p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, RETCODE, errbuf);
2410: END CONC_EXECUTE_QUERY;
2411:
2412: FUNCTION SUBMIT_CON_QUERY(p_USER_ID IN NUMBER,
2413: p_QUERY_ID IN NUMBER,

Line 2597: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 12, NULL, 'GENERATE_USER_DATA', l_id, l_ch, l_dt,NULL, instId, ret, m);

2593: begin
2594: l_id.extend(1);l_ch.extend(1);l_dt.extend(1);
2595: l_id(1):=1;
2596: l_ch(1):=p_user_name;
2597: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 12, NULL, 'GENERATE_USER_DATA', l_id, l_ch, l_dt,NULL, instId, ret, m);
2598:
2599: IF (ret=fnd_api.g_ret_sts_success) THEN
2600: CSM_UTIL_PKG.LOG('Created Instance -:'||instId, 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);
2601: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 12, instId);