eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_HTML5_PKG dependencies on CSM_HTML5_CLIENTS_INFO

Line 363: select prf_value into l_str from csm_html5_clients_info where user_name=p_user_name and prf_name=p_in_prof;

359: IF p_in_prof='RSA_KEY' THEN
360: l_str:=handle_vault('GET','RSA_KEY_'||asg_base.get_user_id(p_user_name));
361: --CSM_UTIL_PKG.LOG('vault get:'||l_str, 'CSM_HTML5_PKG.set_rsa_keys', FND_LOG.LEVEL_PROCEDURE);
362: ELSE
363: select prf_value into l_str from csm_html5_clients_info where user_name=p_user_name and prf_name=p_in_prof;
364: END IF;
365:
366: l_t1:=instr(l_str,':',1,1);
367: l_t2:=instr(l_str,':',1,2);

Line 499: UPDATE csm_html5_clients_info SET PRF_VALUE=pvalue

495: IF pname='RSA_KEY' THEN
496: x:=handle_vault('PUT','RSA_KEY_'||asg_base.get_user_id(p_uname),pvalue); --key size max is 30
497: --CSM_UTIL_PKG.LOG('vault put:'||x, 'CSM_HTML5_PKG.set_user_profile', FND_LOG.LEVEL_PROCEDURE);
498: ELSE
499: UPDATE csm_html5_clients_info SET PRF_VALUE=pvalue
500: WHERE PRF_NAME=pname AND USER_NAME=p_uname;
501:
502: IF SQL%ROWCOUNT= 0 THEN
503: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_uname,pname, pvalue);

Line 503: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_uname,pname, pvalue);

499: UPDATE csm_html5_clients_info SET PRF_VALUE=pvalue
500: WHERE PRF_NAME=pname AND USER_NAME=p_uname;
501:
502: IF SQL%ROWCOUNT= 0 THEN
503: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_uname,pname, pvalue);
504: END IF;
505:
506: END IF;
507: COMMIT;

Line 538: SELECT PRF_VALUE INTO l_temp FROM csm_html5_clients_info

534: l_sub varchar2(4000);
535: l_sub2 varchar2(4000);
536: BEGIN
537: BEGIN
538: SELECT PRF_VALUE INTO l_temp FROM csm_html5_clients_info
539: WHERE USER_NAME=p_user_name
540: AND PRF_NAME='XML_ERROR';
541:
542: IF length(l_temp)>3000 THEN

Line 543: UPDATE csm_html5_clients_info

539: WHERE USER_NAME=p_user_name
540: AND PRF_NAME='XML_ERROR';
541:
542: IF length(l_temp)>3000 THEN
543: UPDATE csm_html5_clients_info
544: SET PRF_VALUE=l_temp||'.'
545: WHERE USER_NAME=p_user_name
546: AND PRF_NAME='XML_ERROR';
547: CSM_UTIL_PKG.LOG('No more space to MARK_ERROR' , 'CSM_HTML5_PKG.MARK_ERROR', FND_LOG.LEVEL_PROCEDURE);

Line 582: UPDATE csm_html5_clients_info

578: ELSE
579: l_temp:=l_temp||p_PI_NAME||':'||p_pk_value||';';
580: END IF;
581:
582: UPDATE csm_html5_clients_info
583: SET PRF_VALUE=l_temp
584: WHERE USER_NAME=p_user_name
585: AND PRF_NAME='XML_ERROR';
586:

Line 589: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_user_name,'XML_ERROR',p_PI_NAME||':'||p_pk_value||';');

585: AND PRF_NAME='XML_ERROR';
586:
587: EXCEPTION
588: WHEN no_data_found THEN
589: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_user_name,'XML_ERROR',p_PI_NAME||':'||p_pk_value||';');
590: END;
591: EXCEPTION
592: WHEN OTHERS THEN
593: CSM_UTIL_PKG.LOG('Exception occurred in MARK_ERROR: ' || substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.MARK_ERROR', FND_LOG.LEVEL_PROCEDURE);

Line 601: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO

597: PROCEDURE set_indx_ref(p_idx IN VARCHAR2)
598: IS
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

Line 606: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'INDXREF',p_idx);

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;
608:
609: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME='APPLICATION' AND PI_NAME=(SELECT ITEM_ID FROM ASG_PUB_ITEM_INDEX WHERE INDEX_ID=p_idx) ;
610: END set_indx_ref;

Line 616: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO

612: PROCEDURE set_indx_ref(p_user_name IN VARCHAR2,p_idx IN VARCHAR2)
613: IS
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

Line 621: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'INDXREF',p_idx);

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;
623:
624: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME='APPLICATION' AND PI_NAME=(SELECT ITEM_ID FROM ASG_PUB_ITEM_INDEX WHERE INDEX_ID=p_idx) ;
625: END set_indx_ref;

Line 630: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME AND PRF_NAME like 'INDXREF%';

626:
627: PROCEDURE remove_indx_ref(p_USER_NAME IN VARCHAR2)
628: IS
629: BEGIN
630: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME AND PRF_NAME like 'INDXREF%';
631: END remove_indx_ref;
632:
633: PROCEDURE remove_indx_ref(p_user_name IN VARCHAR2,p_pi IN VARCHAR2)
634: IS

Line 637: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE PRF_NAME='INDXREF' AND PRF_VALUE IN (SELECT INDEX_ID FROM ASG_PUB_ITEM_INDEX WHERE ITEM_ID=p_pi);

633: PROCEDURE remove_indx_ref(p_user_name IN VARCHAR2,p_pi IN VARCHAR2)
634: IS
635: BEGIN
636: IF p_user_name is NULL THEN
637: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE PRF_NAME='INDXREF' AND PRF_VALUE IN (SELECT INDEX_ID FROM ASG_PUB_ITEM_INDEX WHERE ITEM_ID=p_pi);
638: ELSE
639: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME
640: AND PRF_NAME='INDXREF' AND PRF_VALUE IN (SELECT INDEX_ID FROM ASG_PUB_ITEM_INDEX WHERE ITEM_ID=p_pi);
641: END IF;

Line 639: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME

635: BEGIN
636: IF p_user_name is NULL THEN
637: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE PRF_NAME='INDXREF' AND PRF_VALUE IN (SELECT INDEX_ID FROM ASG_PUB_ITEM_INDEX WHERE ITEM_ID=p_pi);
638: ELSE
639: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME
640: AND PRF_NAME='INDXREF' AND PRF_VALUE IN (SELECT INDEX_ID FROM ASG_PUB_ITEM_INDEX WHERE ITEM_ID=p_pi);
641: END IF;
642: END remove_indx_ref;
643:

Line 647: DELETE FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';

643:
644: PROCEDURE mark_pi_altered(p_pi IN VARCHAR2)
645: IS
646: BEGIN
647: DELETE FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';
648: csm_html5_pkg.set_comp_ref(p_pi);
649: DELETE_CACHE(p_pi);
650: END mark_pi_altered;
651:

Line 656: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO

652: PROCEDURE set_comp_ref(p_pi IN VARCHAR2)
653: IS
654: BEGIN
655: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y'
656: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO
657: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi)
658: AND NOT EXISTS(SELECT 1 FROM ASG_PURGE_SDQ WHERE USER_NAME =au.USER_NAME AND pub_name = 'SERVICEP' AND TRANSACTION_ID IS NULL)
659: )
660: LOOP

Line 661: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'COMPREF',p_pi);

657: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi)
658: AND NOT EXISTS(SELECT 1 FROM ASG_PURGE_SDQ WHERE USER_NAME =au.USER_NAME AND pub_name = 'SERVICEP' AND TRANSACTION_ID IS NULL)
659: )
660: LOOP
661: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'COMPREF',p_pi);
662: END LOOP;
663: remove_indx_ref(null,p_pi);
664: END set_comp_ref;
665:

Line 670: AND MULTI_PLATFORM='Y' AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO

666: PROCEDURE set_comp_ref(p_user_name IN VARCHAR2,p_pi IN VARCHAR2) --any arbitrary pi_name as well
667: IS
668: BEGIN
669: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y' AND USER_NAME=p_user_name
670: AND MULTI_PLATFORM='Y' AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO
671: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi))
672: LOOP
673: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_USER_NAME,'COMPREF',p_pi);
674: END LOOP;

Line 673: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_USER_NAME,'COMPREF',p_pi);

669: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y' AND USER_NAME=p_user_name
670: AND MULTI_PLATFORM='Y' AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO
671: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi))
672: LOOP
673: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_USER_NAME,'COMPREF',p_pi);
674: END LOOP;
675: remove_indx_ref(p_user_name,p_pi);
676: END set_comp_ref;
677:

Line 681: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME

677:
678: PROCEDURE remove_comp_ref(p_user_name IN VARCHAR2,p_pi IN VARCHAR2)
679: IS
680: BEGIN
681: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME
682: AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi;
683: END remove_comp_ref;
684:
685: PROCEDURE remove_comp_ref(p_user_name IN VARCHAR2)

Line 688: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME AND PRF_NAME like 'COMPREF%';

684:
685: PROCEDURE remove_comp_ref(p_user_name IN VARCHAR2)
686: IS
687: BEGIN
688: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_USER_NAME AND PRF_NAME like 'COMPREF%';
689: remove_indx_ref(p_user_name);
690: END remove_comp_ref;
691:
692: FUNCTION blob_to_clob (blob_in IN BLOB) RETURN CLOB

Line 742: FROM CSM_HTML5_CLIENTS_INFO a, ASG_PUB_ITEM_INDEX b

738: IS
739: l_stmt CLOB:='';
740: BEGIN
741: FOR rec IN (SELECT item_id ,index_name,index_columns,enabled
742: FROM CSM_HTML5_CLIENTS_INFO a, ASG_PUB_ITEM_INDEX b
743: WHERE a.USER_NAME=p_user_name AND a.PRF_NAME='INDXREF'
744: AND a.PRF_VALUE=b.index_id)
745: LOOP
746: l_stmt:=l_stmt||'appsdb.doDDL("DROP INDEX '||rec.index_name||'",[],";",";");'||g_nl_chr;

Line 884: SELECT to_number(PRF_VALUE) into instId FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';

880: x_return_status:=fnd_api.g_ret_sts_success;
881: x_error_message:='Success';
882:
883: BEGIN
884: SELECT to_number(PRF_VALUE) into instId FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';
885:
886: select result into l_blob from csm_query_results_acc where instance_id = instId and query_id=5;
887: p_result:=blob_to_clob(l_blob);
888: CSM_UTIL_PKG.LOG('Schema Reused from instance:'||instId, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);

Line 1177: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';

1173: query_schema_js(p_user_name,l_stmt,x_return_status,x_error_message);
1174:
1175: IF(x_return_status = fnd_api.g_ret_sts_error) THEN
1176: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1177: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';
1178: END_SESSION(l_session_id,'ERROR',x_error_message);
1179: RETURN;
1180: END IF;
1181:

Line 1322: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';

1318: ELSE
1319: M:=false;
1320: l_final:=l_final||' display_alert(''csm_auth_error'',10); '||g_nl_chr||'}'||g_nl_chr;
1321: CREATE_AJAX_SESSION(p_user_name,'csm_auth_error: Invalid password');
1322: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';
1323: END IF;
1324:
1325: l_final:=l_final||g_nl_chr||' $("#mfs_sync").click(function(){ '||g_nl_chr
1326: || ' mfs_synch_data();'||g_nl_chr

Line 1340: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';

1336: /* M:=asg_download.purgeSdq(p_user_name); -- Replaced with delete at PI processing*/
1337: UPDATE asg_purge_sdq set TRANSACTION_ID=NVL(l_session_id,1) WHERE user_name = p_user_name; --first sync over
1338: UPDATE asg_complete_refresh set synch_completed='Y' WHERE user_name = p_user_name;
1339: remove_comp_ref(p_user_name);
1340: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';
1341: IF l_warning THEN
1342: END_SESSION(l_session_id,'SUCCESS_W');
1343: ELSE
1344: END_SESSION(l_session_id,'SUCCESS');

Line 1353: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';

1349: WHEN others THEN
1350: x_return_status := fnd_api.g_ret_sts_error;
1351: x_error_message := 'Exception occurred in query_sync_data_js: ' || substr(sqlerrm,1,3900);
1352: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1353: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';
1354: END_SESSION(l_session_id,'ERROR',x_error_message);
1355: END query_sync_data_js;
1356:
1357: FUNCTION is_complete_ref(p_user_name IN VARCHAR2,p_pi IN VARCHAR2) return BOOLEAN

Line 1362: SELECT PRF_VALUE INTO l_t FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name

1358: IS
1359: l_t VARCHAR2(100);
1360: BEGIN
1361: BEGIN
1362: SELECT PRF_VALUE INTO l_t FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1363: AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi;
1364: RETURN TRUE;
1365: EXCEPTION
1366: WHEN Others THEN

Line 1593: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name

1589: ELSE --purge old data if last sync is applied
1590:
1591: /*****COMPLETE REFRESH***********/
1592: --if comp ref is also set in current TXN
1593: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name
1594: AND PRF_NAME LIKE 'COMPREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='COMPREF' AND a.PRF_VALUE=b.PRF_VALUE) ;
1595:
1596: --if last comp ref is successful
1597: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name

Line 1594: AND PRF_NAME LIKE 'COMPREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='COMPREF' AND a.PRF_VALUE=b.PRF_VALUE) ;

1590:
1591: /*****COMPLETE REFRESH***********/
1592: --if comp ref is also set in current TXN
1593: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name
1594: AND PRF_NAME LIKE 'COMPREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='COMPREF' AND a.PRF_VALUE=b.PRF_VALUE) ;
1595:
1596: --if last comp ref is successful
1597: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1598: AND PRF_NAME LIKE 'COMPREF-TID-%' AND TO_NUMBER(SUBSTR(PRF_NAME,13))

Line 1597: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name

1593: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name
1594: AND PRF_NAME LIKE 'COMPREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='COMPREF' AND a.PRF_VALUE=b.PRF_VALUE) ;
1595:
1596: --if last comp ref is successful
1597: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1598: AND PRF_NAME LIKE 'COMPREF-TID-%' AND TO_NUMBER(SUBSTR(PRF_NAME,13)) 1599:
1600: --if last comp ref not successful
1601: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='COMPREF' WHERE USER_NAME=p_user_name

Line 1601: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='COMPREF' WHERE USER_NAME=p_user_name

1597: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1598: AND PRF_NAME LIKE 'COMPREF-TID-%' AND TO_NUMBER(SUBSTR(PRF_NAME,13)) 1599:
1600: --if last comp ref not successful
1601: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='COMPREF' WHERE USER_NAME=p_user_name
1602: AND PRF_NAME LIKE 'COMPREF-TID-%';
1603:
1604:
1605: /*****INDEX REFRESH***********/

Line 1607: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name

1603:
1604:
1605: /*****INDEX REFRESH***********/
1606: --if indx ref is also set in current TXN
1607: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name
1608: AND PRF_NAME LIKE 'INDXREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='INDXREF' AND a.PRF_VALUE=b.PRF_VALUE) ;
1609:
1610: --if last indx ref is successful
1611: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name

Line 1608: AND PRF_NAME LIKE 'INDXREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='INDXREF' AND a.PRF_VALUE=b.PRF_VALUE) ;

1604:
1605: /*****INDEX REFRESH***********/
1606: --if indx ref is also set in current TXN
1607: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name
1608: AND PRF_NAME LIKE 'INDXREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='INDXREF' AND a.PRF_VALUE=b.PRF_VALUE) ;
1609:
1610: --if last indx ref is successful
1611: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1612: AND PRF_NAME LIKE 'INDXREF-TID-%' AND TO_NUMBER(SUBSTR(PRF_NAME,13))

Line 1611: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name

1607: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME=p_user_name
1608: AND PRF_NAME LIKE 'INDXREF-TID-%' AND EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO b WHERE a.USER_NAME=b.USER_NAME AND b.PRF_NAME='INDXREF' AND a.PRF_VALUE=b.PRF_VALUE) ;
1609:
1610: --if last indx ref is successful
1611: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1612: AND PRF_NAME LIKE 'INDXREF-TID-%' AND TO_NUMBER(SUBSTR(PRF_NAME,13)) 1613:
1614: --if last indx ref not successful
1615: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='INDXREF' WHERE USER_NAME=p_user_name

Line 1615: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='INDXREF' WHERE USER_NAME=p_user_name

1611: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name
1612: AND PRF_NAME LIKE 'INDXREF-TID-%' AND TO_NUMBER(SUBSTR(PRF_NAME,13)) 1613:
1614: --if last indx ref not successful
1615: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='INDXREF' WHERE USER_NAME=p_user_name
1616: AND PRF_NAME LIKE 'INDXREF-TID-%';
1617:
1618:
1619: /*****ASG SDQ***********/

Line 1661: for pi in (SELECT a.NAME FROM ASG_PUB_ITEM a,CSM_HTML5_CLIENTS_INFO b

1657: asg_base.init_debug(l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date);
1658:
1659:
1660: /*****COMPLETE REFRESH***********/
1661: for pi in (SELECT a.NAME FROM ASG_PUB_ITEM a,CSM_HTML5_CLIENTS_INFO b
1662: WHERE nvl(html5_offline,'N')='Y'
1663: AND PRF_NAME='COMPREF'
1664: AND PRF_VALUE=a.NAME
1665: AND b.USER_NAME=p_user_name ORDER BY a.NAME)

Line 1672: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='COMPREF-TID-'||p_tranid

1668:
1669:
1670: remove_indx_ref(p_user_name,pi.name);
1671:
1672: UPDATE CSM_HTML5_CLIENTS_INFO SET PRF_NAME='COMPREF-TID-'||p_tranid
1673: WHERE USER_NAME=p_user_name AND PRF_NAME='COMPREF' AND PRF_VALUE= pi.name; --check and clear in next sync
1674:
1675: l_comp_ref_list(pi.name):='1';
1676: end loop;

Line 1681: UPDATE CSM_HTML5_CLIENTS_INFO

1677:
1678:
1679: /*****INDEX REFRESH***********/
1680: l_final:=l_final||get_index_refresh(p_user_name);
1681: UPDATE CSM_HTML5_CLIENTS_INFO
1682: SET PRF_NAME='INDXREF-TID-'||p_tranid
1683: WHERE USER_NAME=p_user_name AND PRF_NAME='INDXREF'; --check and clear in next sync
1684:
1685:

Line 1865: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_user_name AND PRF_NAME like 'REUSABLE%';

1861:
1862: IF(M) THEN l_final :=l_final||' total_sync_rec_count= 0; ';
1863: ELSE
1864: l_final :=l_final||' total_sync_rec_count= tc; ';
1865: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_user_name AND PRF_NAME like 'REUSABLE%';
1866: END IF;
1867:
1868: IF (l_refresh_all) THEN l_final :=l_final||' sync.logSyncSession('||to_char(l_session_id)||',false,"Y"); ' ||g_nl_chr;
1869: ELSE l_final :=l_final||' sync.logSyncSession('||to_char(l_session_id)||',false,"N"); ' ||g_nl_chr;

Line 1886: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_9';

1882: l_final :=g_nl_chr||'function mfs_synch_data(){ '||g_nl_chr || l_final||' }' ||g_nl_chr;
1883: M:=true; --to avoid get Tasks
1884: CREATE_AJAX_SESSION(p_user_name,'csm_auth_error: Invalid password');
1885: IF l_refresh_all THEN --case of plsql exception followed by call to query Id 9 with wrong password
1886: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_9';
1887: END IF;
1888: END IF;
1889:
1890: l_final:=l_final||g_nl_chr||' $("#mfs_sync").click(function(){ '||g_nl_chr

Line 1917: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_9';

1913: x_return_status := fnd_api.g_ret_sts_error;
1914: x_error_message := 'Exception occurred in q_inc_sync_data_js: '||length(l_final)||'::'|| substr(sqlerrm,0,2000);
1915: CSM_UTIL_PKG.LOG( x_error_message,'CSM_HTML5_PKG.q_inc_sync_data_js',FND_LOG.LEVEL_PROCEDURE);
1916: IF l_refresh_all THEN
1917: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_9';
1918: END IF;
1919: END_SESSION(l_session_id,'ERROR',x_error_message);
1920: END q_inc_sync_data_js;
1921:

Line 1935: DELETE FROM csm_html5_clients_info WHERE PRF_NAME like 'REUSABLE%' OR PRF_NAME like 'SCHEMA%REUSE%';

1931: IS
1932: BEGIN
1933: UPDATE ASG_PUB_ITEM SET HTML5_OFFLINE='Y' WHERE ITEM_ID=p_pi;
1934: set_comp_ref(p_pi);
1935: DELETE FROM csm_html5_clients_info WHERE PRF_NAME like 'REUSABLE%' OR PRF_NAME like 'SCHEMA%REUSE%';
1936: END enable_pi;
1937:
1938: PROCEDURE disable_pi(p_pi IN VARCHAR2)
1939: IS

Line 1942: DELETE FROM csm_html5_clients_info WHERE PRF_NAME like 'REUSABLE%';

1938: PROCEDURE disable_pi(p_pi IN VARCHAR2)
1939: IS
1940: BEGIN
1941: UPDATE ASG_PUB_ITEM SET HTML5_OFFLINE='N' WHERE ITEM_ID=p_pi;
1942: DELETE FROM csm_html5_clients_info WHERE PRF_NAME like 'REUSABLE%';
1943: remove_comp_ref(p_pi);
1944: END disable_pi;
1945:
1946: PROCEDURE PURGE_HTML5_DATA(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)

Line 1977: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME<>'APPLICATION' AND NOT EXISTS (SELECT 1 FROM ASG_USER au WHERE au.USER_NAME=a.USER_NAME);

1973: BEGIN
1974:
1975: l_last_run_date := SYSDATE;
1976:
1977: DELETE FROM CSM_HTML5_CLIENTS_INFO a WHERE USER_NAME<>'APPLICATION' AND NOT EXISTS (SELECT 1 FROM ASG_USER au WHERE au.USER_NAME=a.USER_NAME);
1978:
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

Line 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%')

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%')
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;

Line 2129: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pubitem);

2125: FROM asg_system_dirty_queue a, CSM_HTML5_PARSED_DATA b
2126: WHERE client_id = p_user_name AND pub_item = p_pubitem AND
2127: transaction_id is NULL AND a.dml_type = 2
2128: AND b.session_id=p_upload_tranid AND b.piv_name=a.pub_item AND a.access_id=b.pk_value AND b.dml_type='U'
2129: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pubitem);
2130:
2131: l_conf_count := SQL%ROWCOUNT;
2132:
2133: CSM_UTIL_PKG.LOG('Number of possible conflicts: ' || l_conf_count

Line 2451: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)

2447: l_cur_version VARCHAR2(100):=get_app_revision;
2448: BEGIN
2449:
2450: IF l_cur_version IS NULL THEN
2451: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)
2452: VALUES('APPLICATION','REVISION',p_version);
2453: ELSIF to_number(p_version)> to_number(l_cur_version) THEN
2454: UPDATE csm_html5_clients_info SET PRF_VALUE=p_version
2455: WHERE USER_NAME='APPLICATION' AND PRF_NAME='REVISION';

Line 2454: UPDATE csm_html5_clients_info SET PRF_VALUE=p_version

2450: IF l_cur_version IS NULL THEN
2451: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)
2452: VALUES('APPLICATION','REVISION',p_version);
2453: ELSIF to_number(p_version)> to_number(l_cur_version) THEN
2454: UPDATE csm_html5_clients_info SET PRF_VALUE=p_version
2455: WHERE USER_NAME='APPLICATION' AND PRF_NAME='REVISION';
2456:
2457: UPDATE csm_html5_clients_info SET PRF_VALUE=p_force_update
2458: WHERE USER_NAME='APPLICATION' AND PRF_NAME='FORCE_UPDATE';

Line 2457: UPDATE csm_html5_clients_info SET PRF_VALUE=p_force_update

2453: ELSIF to_number(p_version)> to_number(l_cur_version) THEN
2454: UPDATE csm_html5_clients_info SET PRF_VALUE=p_version
2455: WHERE USER_NAME='APPLICATION' AND PRF_NAME='REVISION';
2456:
2457: UPDATE csm_html5_clients_info SET PRF_VALUE=p_force_update
2458: WHERE USER_NAME='APPLICATION' AND PRF_NAME='FORCE_UPDATE';
2459: IF SQL%ROWCOUNT=0 THEN
2460: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)
2461: VALUES('APPLICATION','FORCE_UPDATE',p_force_update);

Line 2460: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)

2456:
2457: UPDATE csm_html5_clients_info SET PRF_VALUE=p_force_update
2458: WHERE USER_NAME='APPLICATION' AND PRF_NAME='FORCE_UPDATE';
2459: IF SQL%ROWCOUNT=0 THEN
2460: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)
2461: VALUES('APPLICATION','FORCE_UPDATE',p_force_update);
2462: END IF;
2463: END IF;
2464:

Line 2471: SELECT MAX(PRF_VALUE) into x FROM csm_html5_clients_info

2467: FUNCTION get_app_revision(p_u IN VARCHAR2:=NULL,p_v IN VARCHAR2:=NULL) RETURN VARCHAR2
2468: IS
2469: x varchar2(1000);
2470: BEGIN
2471: SELECT MAX(PRF_VALUE) into x FROM csm_html5_clients_info
2472: WHERE USER_NAME='APPLICATION' AND PRF_NAME='REVISION';
2473:
2474: IF p_u IS NOT NULL AND p_v IS NOT NULL THEN
2475: UPDATE csm_html5_clients_info SET PRF_VALUE=p_v

Line 2475: UPDATE csm_html5_clients_info SET PRF_VALUE=p_v

2471: SELECT MAX(PRF_VALUE) into x FROM csm_html5_clients_info
2472: WHERE USER_NAME='APPLICATION' AND PRF_NAME='REVISION';
2473:
2474: IF p_u IS NOT NULL AND p_v IS NOT NULL THEN
2475: UPDATE csm_html5_clients_info SET PRF_VALUE=p_v
2476: WHERE USER_NAME=P_U AND PRF_NAME='LAST_SYNC_APP_VERSION';
2477: IF SQL%ROWCOUNT=0 THEN
2478: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)
2479: VALUES(P_U,'LAST_SYNC_APP_VERSION',p_v);

Line 2478: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)

2474: IF p_u IS NOT NULL AND p_v IS NOT NULL THEN
2475: UPDATE csm_html5_clients_info SET PRF_VALUE=p_v
2476: WHERE USER_NAME=P_U AND PRF_NAME='LAST_SYNC_APP_VERSION';
2477: IF SQL%ROWCOUNT=0 THEN
2478: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE)
2479: VALUES(P_U,'LAST_SYNC_APP_VERSION',p_v);
2480: END IF;
2481: END IF;
2482:

Line 2491: SELECT PRF_VALUE into x FROM csm_html5_clients_info

2487: IS
2488: x VARCHAR2(1000);
2489: BEGIN
2490: IF (p_version IS NULL) THEN
2491: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2492: WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';
2493:
2494: DELETE FROM csm_html5_clients_info
2495: WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';

Line 2494: DELETE FROM csm_html5_clients_info

2490: IF (p_version IS NULL) THEN
2491: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2492: WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';
2493:
2494: DELETE FROM csm_html5_clients_info
2495: WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';
2496:
2497: RETURN TRUE;
2498: ELSE

Line 2499: SELECT PRF_VALUE into x FROM csm_html5_clients_info

2495: WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';
2496:
2497: RETURN TRUE;
2498: ELSE
2499: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2500: WHERE USER_NAME='APPLICATION' AND PRF_NAME='REVISION';
2501:
2502: if (trim(X) <> trim(p_version)) THEN return TRUE; END IF;
2503: END IF;

Line 2538: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_USER_NAME AND PRF_NAME like 'REUSABLE%';

2534: BEGIN
2535: SELECT '1' INTO x FROM ASG_SYSTEM_DIRTY_QUEUE sdq WHERE CLIENT_ID=p_USER_NAME AND ROWNUM<2
2536: AND EXISTS(SELECT 1 FROM ASG_PUB_ITEM pi WHERE pi.item_id=sdq.pub_item and nvl(html5_offline,'N')='Y');
2537:
2538: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_USER_NAME AND PRF_NAME like 'REUSABLE%';
2539: RETURN '-1';
2540: EXCEPTION
2541: WHEN OTHERS THEN
2542: NULL;

Line 2546: SELECT PRF_VALUE into x FROM csm_html5_clients_info

2542: NULL;
2543: END;
2544:
2545: BEGIN
2546: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2547: WHERE USER_NAME=p_USER_NAME AND PRF_NAME='USER_CREATION_DATA';
2548: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_USER_NAME AND PRF_NAME='USER_CREATION_DATA';
2549: RETURN (-1*x);
2550: EXCEPTION

Line 2548: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_USER_NAME AND PRF_NAME='USER_CREATION_DATA';

2544:
2545: BEGIN
2546: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2547: WHERE USER_NAME=p_USER_NAME AND PRF_NAME='USER_CREATION_DATA';
2548: DELETE FROM csm_html5_clients_info WHERE USER_NAME=p_USER_NAME AND PRF_NAME='USER_CREATION_DATA';
2549: RETURN (-1*x);
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: NULL;

Line 2556: SELECT PRF_VALUE into x FROM csm_html5_clients_info

2552: NULL;
2553: END;
2554:
2555: BEGIN
2556: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2557: WHERE USER_NAME=p_USER_NAME AND PRF_NAME='REUSABLE_'||p_QUERY_ID;
2558: EXCEPTION
2559: WHEN OTHERS THEN
2560: select '-2' into x from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;

Line 2560: select '-2' into x from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;

2556: SELECT PRF_VALUE into x FROM csm_html5_clients_info
2557: WHERE USER_NAME=p_USER_NAME AND PRF_NAME='REUSABLE_'||p_QUERY_ID;
2558: EXCEPTION
2559: WHEN OTHERS THEN
2560: select '-2' into x from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;
2561: END ;
2562:
2563: RETURN x;
2564:

Line 2576: select 1 into x from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;

2572: x NUMBER;
2573: BEGIN
2574:
2575: BEGIN
2576: select 1 into x from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;
2577: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;
2578: set_user_profile(p_USER_NAME,'REUSABLE_'||p_QUERY_ID,to_char(p_INSTANCE_ID));
2579: EXCEPTION
2580: WHEN OTHERS THEN

Line 2577: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;

2573: BEGIN
2574:
2575: BEGIN
2576: select 1 into x from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;
2577: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;
2578: set_user_profile(p_USER_NAME,'REUSABLE_'||p_QUERY_ID,to_char(p_INSTANCE_ID));
2579: EXCEPTION
2580: WHEN OTHERS THEN
2581: CSM_UTIL_PKG.LOG('Unable to set reusable since the authentication failed', 'CSM_HTML5_PKG.SET_REUSABLE', FND_LOG.LEVEL_PROCEDURE);

Line 3631: DELETE FROM csm_html5_clients_info WHERE PRF_NAME='FORCE_LOCAL_LOGIN' AND USER_NAME=p_user_name;

3627: IS
3628: BEGIN
3629: CSM_UTIL_PKG.LOG('Local Login set to :'||p_v||' for user:'||p_user_name, 'CSM_HTML5_PKG.setForceLocalLogin', FND_LOG.LEVEL_PROCEDURE);
3630: IF p_v<>'Y' THEN
3631: DELETE FROM csm_html5_clients_info WHERE PRF_NAME='FORCE_LOCAL_LOGIN' AND USER_NAME=p_user_name;
3632: ELSE
3633: set_user_profile(p_user_name,'FORCE_LOCAL_LOGIN','Y');
3634: END IF;
3635:

Line 3650: FROM CSM_HTML5_CLIENTS_INFO

3646: --note: other ajax queries might also set force login to Y. stopForceLogin from client only can set it back to N
3647: --add if block with profile later to turn this feature off completely
3648: BEGIN
3649: SELECT PRF_VALUE INTO l_local
3650: FROM CSM_HTML5_CLIENTS_INFO
3651: WHERE USER_NAME=p_user_name
3652: AND PRF_NAME='FORCE_LOCAL_LOGIN'
3653: AND PRF_VALUE='Y';
3654:

Line 3691: DELETE FROM csm_html5_clients_info WHERE USER_NAME=(SELECT USER_NAME

3687: end delete_user_vault;
3688:
3689: PROCEDURE DROP_USER(p_user_id IN NUMBER)
3690: IS BEGIN
3691: DELETE FROM csm_html5_clients_info WHERE USER_NAME=(SELECT USER_NAME
3692: FROM ASG_USER WHERE USER_ID=p_user_id) AND PRF_NAME NOT IN ('REVISION','FORCE_UPDATE'); --if any user has name as APPLICATION
3693:
3694: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME=(SELECT USER_NAME
3695: FROM ASG_USER WHERE USER_ID=p_user_id);

Line 3719: SELECT (SELECT NVL(MAX(PRF_VALUE),'N') FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME='APPLICATION' AND PRF_NAME='FORCE_UPDATE')

3715: FUNCTION get_app_upg_info(p_user_name IN VARCHAR2) RETURN VARCHAR2
3716: IS
3717: l_store VARCHAR2(4000);
3718: BEGIN
3719: SELECT (SELECT NVL(MAX(PRF_VALUE),'N') FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME='APPLICATION' AND PRF_NAME='FORCE_UPDATE')
3720: ||';'|| fnd_profile.value_specific('CSM_MULTI_APP_STORE_URL',USER_ID,RESPONSIBILITY_ID)
3721: INTO l_store
3722: FROM ASG_USER WHERE USER_NAME=p_user_name;
3723: