[Home] [Help]
599: BEGIN
600: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y'
601: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO
602: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='INDXREF' AND PRF_VALUE=p_idx)
603: AND EXISTS(SELECT 1 FROM CSM_HTML5_SYNC_INFO WHERE USER_NAME =au.USER_NAME)
604: )
605: LOOP
606: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'INDXREF',p_idx);
607: END LOOP;
614: BEGIN
615: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y' AND USER_NAME=p_USER_NAME
616: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO
617: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='INDXREF' AND PRF_VALUE=p_idx)
618: AND EXISTS(SELECT 1 FROM CSM_HTML5_SYNC_INFO WHERE USER_NAME =au.USER_NAME)
619: )
620: LOOP
621: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'INDXREF',p_idx);
622: END LOOP;
938: BEGIN
939:
940: SELECT csm_html5_sync_s.NEXTVAL INTO l_session_id FROM DUAL;
941:
942: INSERT INTO csm_html5_sync_info(SESSION_ID,USER_NAME,START_DATE,FULL_SYNC,STATUS,STATUS_DESC,SYNC_TYPE,Q_INSTANCE_ID)
943: VALUES(l_session_id,p_user_name,SYSDATE,p_full_sync,'IN_PROGRESS','Sync has started successfuly',p_mode,l_instance);
944:
945: create_ajax_session(p_user_name,'Sync thru Ajax succeeded',l_session_id);
946:
958: values(p_session_id,p_pi,p_count,p_comp_ref);
959:
960: IF(p_dummy) THEN
961: p_dummy := false;
962: UPDATE csm_html5_sync_info SET STATUS_DESC=STATUS_DESC||' :Processed pi-s :'||p_pi
963: WHERE SESSION_ID=p_session_id;
964: ELSE
965: UPDATE csm_html5_sync_info SET STATUS_DESC=STATUS_DESC||' ,'||p_pi
966: WHERE SESSION_ID=p_session_id;
961: p_dummy := false;
962: UPDATE csm_html5_sync_info SET STATUS_DESC=STATUS_DESC||' :Processed pi-s :'||p_pi
963: WHERE SESSION_ID=p_session_id;
964: ELSE
965: UPDATE csm_html5_sync_info SET STATUS_DESC=STATUS_DESC||' ,'||p_pi
966: WHERE SESSION_ID=p_session_id;
967: END IF;
968:
969: COMMIT;
973: IS
974: PRAGMA AUTONOMOUS_TRANSACTION;
975: BEGIN
976:
977: UPDATE csm_html5_sync_info SET END_DATE=SYSDATE ,STATUS =p_status,STATUS_DESC=NVL(p_status_desc,STATUS_DESC||' : Sync Ended Successfully.')
978: WHERE SESSION_ID=p_session_id;
979:
980: COMMIT;
981: END end_session;
1979: OPEN c_purge_days;
1980: FETCH c_purge_days INTO l_days;
1981: IF c_purge_days%FOUND AND l_days IS NOT NULL AND l_days>0 THEN
1982: delete from csm_html5_ajax_info where creation_date < (sysdate-l_days);
1983: delete from csm_html5_sync_info where start_date < (sysdate-l_days);
1984: delete from csm_html5_sync_details a where not exists(select 1 from csm_html5_sync_info b where a.session_id=b.session_id);
1985: delete from csm_query_instances_acc
1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1980: FETCH c_purge_days INTO l_days;
1981: IF c_purge_days%FOUND AND l_days IS NOT NULL AND l_days>0 THEN
1982: delete from csm_html5_ajax_info where creation_date < (sysdate-l_days);
1983: delete from csm_html5_sync_info where start_date < (sysdate-l_days);
1984: delete from csm_html5_sync_details a where not exists(select 1 from csm_html5_sync_info b where a.session_id=b.session_id);
1985: delete from csm_query_instances_acc
1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1988: and instance_id not in (select to_number(prf_value) from csm_html5_clients_info WHERE PRF_NAME='SCHEMA_REUSE' OR PRF_NAME like 'REUSABLE%' OR PRF_NAME LIKE 'USER_CREAT%')
1985: delete from csm_query_instances_acc
1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1988: and instance_id not in (select to_number(prf_value) from csm_html5_clients_info WHERE PRF_NAME='SCHEMA_REUSE' OR PRF_NAME like 'REUSABLE%' OR PRF_NAME LIKE 'USER_CREAT%')
1989: and not exists (select 1 from csm_html5_sync_info where instance_id=q_instance_id);
1990: delete from csm_query_results_acc where instance_id not in ( select instance_id from csm_query_instances_acc where query_id between 1 and 99 );
1991: END IF;
1992: CLOSE c_purge_days;
1993:
2218: IS
2219: cnt number:=0;
2220: trnid VARCHAR2(4000):='';
2221: BEGIN
2222: For rec IN (select a.session_id from csm_html5_upload_data a, csm_html5_sync_info c
2223: where a.status<>'PARSED' and a.session_id=c.session_id
2224: and c.useR_name=p_user_name order by session_id asc)
2225: loop
2226: CSM_HTML5_PKG.HTML5_PARSE_XML(rec.SESSION_ID,x_return_status,x_error_message);
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:
2371: UPDATE csm_html5_sync_info SET Q_INSTANCE_ID=instId WHERE SESSION_ID=l_session_id;
2372:
2373: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 16, instId);
2374: IF req_id=0 THEN
2375: CSM_UTIL_PKG.LOG('Sorry, this user -'||p_user_name||' does not have the responsibility/request group to submit request', 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2677:
2678: CURSOR c_get_sync_uname(sync_id NUMBER)
2679: IS
2680: SELECT au.USER_NAME, USER_ID, RESPONSIBILITY_ID, APP_ID
2681: FROM CSM_HTML5_SYNC_INFO si, ASG_USER au
2682: WHERE SESSION_ID =SYNC_ID
2683: AND au.USER_NAME =si.USER_NAME;
2684:
2685:
3576: IS
3577: l_uname VARCHAR2(500):=NULL;
3578: l_list VARCHAR2(4000):=NULL;
3579: BEGIN
3580: FOR rec IN (select a.session_id,c.user_name from csm_html5_upload_data a,asg_user b, csm_html5_sync_info c
3581: where a.status<>'PARSED' and a.session_id=c.session_id
3582: and nvl(fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',b.user_id,b.responsibility_id,b.app_id),'N')='N'
3583: and b.user_name=c.user_name and b.multi_platform='Y' and b.enabled='Y' ORDER BY c.USER_NAME,a.SESSION_ID ASC)
3584: LOOP