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 ASG_USER

Line 600: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y'

596:
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: )

Line 615: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y' AND USER_NAME=p_USER_NAME

611:
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: )

Line 655: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y'

651:
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: )

Line 669: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y' AND USER_NAME=p_user_name

665:
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);

Line 987: SELECT USER_ID INTO x FROM ASG_USER

983: FUNCTION hasHTML5Enabled(p_user_name IN VARCHAR2) return BOOLEAN
984: IS
985: x NUMBER;
986: BEGIN
987: SELECT USER_ID INTO x FROM ASG_USER
988: WHERE USER_NAME=p_user_name
989: AND ENABLED='Y'
990: AND MULTI_PLATFORM='Y';
991:

Line 1197: into l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date from asg_user where user_name=upper(p_user_name);

1193:
1194: CSM_UTIL_PKG.LOG('Beginning PI download', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1195:
1196: select useR_name,language,resource_id,useR_id,responsibility_id,app_id,lasT_synch_date_end
1197: into l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date from asg_user where user_name=upper(p_user_name);
1198: asg_base.init_debug(l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date);
1199:
1200:
1201: for rec in (select item_id,base_objecT_name from asg_pub_item where pub_name='SERVICEP' and enabled='Y'

Line 1656: into l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date from asg_user where user_name=upper(p_user_name);

1652:
1653: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT=''RRRR-MM-DD HH24:MI:SS''';
1654:
1655: select useR_name,language,resource_id,useR_id,responsibility_id,app_id,lasT_synch_date_end
1656: into l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date from asg_user where user_name=upper(p_user_name);
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***********/

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 2024: SELECT USER_ID INTO x FROM ASG_USER

2020: FUNCTION isHTML5User(p_user_name IN VARCHAR2) return BOOLEAN
2021: Is
2022: x NUMBER;
2023: BEGIN
2024: SELECT USER_ID INTO x FROM ASG_USER
2025: WHERE USER_NAME=p_user_name
2026: AND ENABLED='Y'
2027: AND MULTI_PLATFORM='Y';
2028:

Line 2061: FROM asg_user

2057: sub:=inp; n:=instr(sub,':'); seq(cnt):=substr(sub,1,n-1); cval(cnt):=substr(sub,n+1);
2058: end if;
2059:
2060: SELECT client_number INTO l_client_num
2061: FROM asg_user
2062: WHERE user_name = p_user_name;
2063:
2064: FOR i in 1..cnt
2065: loop

Line 2306: SELECT USER_ID,RESPONSIBILITY_ID,APP_ID INTO l_user_id,l_resp_id,l_app_id FROM ASG_USER WHERE USER_NAME=p_user_name;

2302:
2303: CSM_UTIL_PKG.LOG('Dumping Uploaded data for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2304:
2305:
2306: SELECT USER_ID,RESPONSIBILITY_ID,APP_ID INTO l_user_id,l_resp_id,l_app_id FROM ASG_USER WHERE USER_NAME=p_user_name;
2307:
2308: IF fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',l_user_id,l_resp_id,l_app_id)='Y' THEN
2309: is_synchronous:=true;
2310: END IF;

Line 2681: FROM CSM_HTML5_SYNC_INFO si, ASG_USER au

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:

Line 2856: UPDATE asg_user SET hwm_tranid = P_SYNC_ID WHERE user_name = L_SYNC_USER_NAME;

2852: COMMENTS = 'Uploaded Data Parsed Successfully'
2853: WHERE SESSION_ID = P_SYNC_ID;
2854:
2855: setup_inq_info(L_SYNC_USER_NAME,P_SYNC_ID,X_RETURN_STATUS);
2856: UPDATE asg_user SET hwm_tranid = P_SYNC_ID WHERE user_name = L_SYNC_USER_NAME;
2857:
2858: x_return_status := FND_API.G_RET_STS_SUCCESS;
2859: x_error_message := 'XML Parsing Successfully completed ';
2860: CSM_UTIL_PKG.LOG

Line 2904: FROM asg_user

2900: l_pubitems_1 VARCHAR2(4000);
2901: l_pubitems_2 VARCHAR2(4000);
2902: CURSOR c_resource_id (p_user_name VARCHAR2) IS
2903: SELECT resource_id
2904: FROM asg_user
2905: WHERE user_name = p_user_name;
2906: BEGIN
2907: x_return_status := FND_API.G_RET_STS_SUCCESS;
2908: curr_tranid := p_tranid;

Line 2915: 'AND NOT EXISTS (SELECT 1 FROM asg_users_inqinfo ' ||

2911: 'SELECT count(*) FROM CSM_HTML5_INQ ci ' ||
2912: 'WHERE user_name = :1 AND ' ||
2913: ' sync_id = :2 AND ' ||
2914: ' pi_name in (select item_id from asg_pub_item) ' ||
2915: 'AND NOT EXISTS (SELECT 1 FROM asg_users_inqinfo ' ||
2916: ' WHERE device_user_name = ci.user_name AND TRANID =ci.sync_id) ' ;
2917:
2918: EXECUTE IMMEDIATE l_select_inqcnt_sqlstring INTO l_inq_count USING p_user_name, p_tranid;
2919:

Line 2926: csm_util_pkg.log('Did not find the user: '|| p_user_name || ' in asg_user table', 'CSM_HTML5_PKG.setup_inq_info',FND_LOG.LEVEL_PROCEDURE);

2922: OPEN c_resource_id(p_user_name);
2923: FETCH c_resource_id into l_resource_id;
2924: CLOSE c_resource_id;
2925: IF l_resource_id IS NULL THEN
2926: csm_util_pkg.log('Did not find the user: '|| p_user_name || ' in asg_user table', 'CSM_HTML5_PKG.setup_inq_info',FND_LOG.LEVEL_PROCEDURE);
2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: return;
2929: END IF;
2930:

Line 2931: INSERT INTO asg_users_inqinfo (device_user_name,

2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: return;
2929: END IF;
2930:
2931: INSERT INTO asg_users_inqinfo (device_user_name,
2932: resource_id,
2933: tranid,
2934: sync_date,
2935: processed,

Line 2966: ' AND NOT EXISTS (SELECT 1 FROM asg_users_inqarchive ' ||

2962: 'SELECT pi_name FROM CSM_HTML5_INQ ci '||
2963: 'WHERE user_name = :1 AND ' ||
2964: ' sync_id = :2 AND ' ||
2965: ' pi_name in (select item_id from asg_pub_item) '||
2966: ' AND NOT EXISTS (SELECT 1 FROM asg_users_inqarchive ' ||
2967: ' WHERE device_user_name = ci.user_name AND TRANID =ci.sync_id) '||
2968: ' ORDER BY pi_name';
2969:
2970: l_cursor_id1 := DBMS_SQL.OPEN_CURSOR;

Line 3011: -- Replace with call to table-handler for asg_users_inqarchive

3007: counter2 := counter2 +1;
3008: END IF;
3009: END LOOP;
3010:
3011: -- Replace with call to table-handler for asg_users_inqarchive
3012: INSERT INTO asg_users_inqarchive (device_user_name,
3013: resource_id,
3014: tranid,
3015: sync_date,

Line 3012: INSERT INTO asg_users_inqarchive (device_user_name,

3008: END IF;
3009: END LOOP;
3010:
3011: -- Replace with call to table-handler for asg_users_inqarchive
3012: INSERT INTO asg_users_inqarchive (device_user_name,
3013: resource_id,
3014: tranid,
3015: sync_date,
3016: processed,

Line 3064: FROM asg_user

3060: l_seq NUMBER;
3061:
3062: CURSOR c_resource_id (p_user_name VARCHAR2) IS
3063: SELECT resource_id
3064: FROM asg_user
3065: WHERE user_name = p_user_name;
3066:
3067: CURSOR c_pk(b_pi VARCHAR2)
3068: IS --currently only one pk col supported

Line 3095: CSM_UTIL_PKG.log('purge_pubitems: User: ' ||p_user_name||' not found in asg_user table', 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);

3091: OPEN c_resource_id(p_user_name);
3092: FETCH c_resource_id INTO l_resource_id;
3093: IF c_resource_id%NOTFOUND THEN
3094: CLOSE c_resource_id;
3095: CSM_UTIL_PKG.log('purge_pubitems: User: ' ||p_user_name||' not found in asg_user table', 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3096: x_return_status := FND_API.G_RET_STS_ERROR;
3097: return;
3098: END IF;
3099: CLOSE c_resource_id;

Line 3164: UPDATE asg_users_inqinfo

3160:
3161: END LOOP;
3162:
3163: IF (l_deferred_trans = TRUE) THEN
3164: UPDATE asg_users_inqinfo
3165: SET deferred = 'Y', processed = 'I',
3166: last_update_date = SYSDATE, last_updated_by = 1
3167: WHERE device_user_name = p_user_name AND
3168: tranid = p_tranid;

Line 3201: UPDATE asg_users_inqinfo

3197: purge_pubitems(p_user_name, p_tranid, l_pubitems_tbl, x_return_status);
3198: END IF;
3199:
3200: -- If no deferred rows, set processed = 'Y'
3201: UPDATE asg_users_inqinfo
3202: SET processed = 'Y', last_update_date=SYSDATE, last_updated_by=1
3203: WHERE device_user_name = p_user_name AND
3204: tranid = p_tranid AND
3205: tranid not IN

Line 3223: SELECT tranid FROM asg_users_inqinfo

3219: counter PLS_INTEGER;
3220: curr_tranid NUMBER;
3221: l_tranid_tbl asg_apply.num_tbl_type;
3222: cursor c_tranids (p_user_name VARCHAR2, p_max_tranid NUMBER) IS
3223: SELECT tranid FROM asg_users_inqinfo
3224: WHERE device_user_name = p_user_name AND
3225: tranid <= p_max_tranid;
3226: BEGIN
3227: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

Line 3269: CURSOR c_archive_asg_users(p_user_name VARCHAR2) IS

3265: curr_tranid NUMBER;
3266: curr_tran_processed VARCHAR2(1);
3267: curr_tran_deferred VARCHAR2(1);
3268: curr_tran_archive VARCHAR2(1);
3269: CURSOR c_archive_asg_users(p_user_name VARCHAR2) IS
3270: SELECT tranid, processed, deferred, archive
3271: FROM asg_users_inqinfo
3272: WHERE device_user_name = p_user_name;
3273: BEGIN

Line 3271: FROM asg_users_inqinfo

3267: curr_tran_deferred VARCHAR2(1);
3268: curr_tran_archive VARCHAR2(1);
3269: CURSOR c_archive_asg_users(p_user_name VARCHAR2) IS
3270: SELECT tranid, processed, deferred, archive
3271: FROM asg_users_inqinfo
3272: WHERE device_user_name = p_user_name;
3273: BEGIN
3274:
3275: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

Line 3284: FOR caau in c_archive_asg_users(p_user_name) LOOP

3280: x_return_status := FND_API.G_RET_STS_SUCCESS;
3281:
3282: purge_pubitems(p_user_name, x_return_status);
3283:
3284: FOR caau in c_archive_asg_users(p_user_name) LOOP
3285: curr_tranid := caau.tranid;
3286: curr_tran_processed := caau.processed;
3287: curr_tran_deferred := caau.deferred;
3288: curr_tran_archive := caau.archive;

Line 3290: UPDATE asg_users_inqarchive

3286: curr_tran_processed := caau.processed;
3287: curr_tran_deferred := caau.deferred;
3288: curr_tran_archive := caau.archive;
3289: IF (curr_tran_processed = 'Y') AND (curr_tran_archive = 'Y') THEN
3290: UPDATE asg_users_inqarchive
3291: SET processed = 'Y', deferred = curr_tran_deferred,
3292: last_update_date = SYSDATE, last_updated_by = 1
3293: WHERE device_user_name = p_user_name AND
3294: tranid = curr_tranid;

Line 3298: DELETE FROM asg_users_inqinfo

3294: tranid = curr_tranid;
3295: END IF;
3296: END LOOP;
3297:
3298: DELETE FROM asg_users_inqinfo
3299: WHERE device_user_name = p_user_name AND processed = 'Y';
3300:
3301: --COMMIT;
3302:

Line 3311: FROM asg_users_inqinfo a

3307: x_return_status OUT NOCOPY VARCHAR2)
3308: IS
3309: CURSOR c_first_tran (p_user_name VARCHAR2) IS
3310: SELECT min(tranid) tran_id
3311: FROM asg_users_inqinfo a
3312: WHERE a.device_user_name = p_user_name AND
3313: a.deferred='N'
3314: AND a.tranid <=
3315: (SELECT nvl(hwm_tranid,1000000000000)

Line 3316: FROM asg_user

3312: WHERE a.device_user_name = p_user_name AND
3313: a.deferred='N'
3314: AND a.tranid <=
3315: (SELECT nvl(hwm_tranid,1000000000000)
3316: FROM asg_user
3317: WHERE user_name=a.device_user_name);
3318:
3319: BEGIN
3320:

Line 3344: FROM asg_users_inqinfo a

3340: x_return_status OUT NOCOPY VARCHAR2)
3341: IS
3342: CURSOR c_next_tran (p_user_name VARCHAR2, p_tranid VARCHAR2) IS
3343: SELECT min(tranid) tran_id
3344: FROM asg_users_inqinfo a
3345: WHERE tranid > p_tranid
3346: AND a.device_user_name = p_user_name AND a.deferred='N'
3347: AND a.tranid <= (SELECT nvl(hwm_tranid,1000000000000)
3348: FROM asg_user WHERE user_name=a.device_user_name);

Line 3348: FROM asg_user WHERE user_name=a.device_user_name);

3344: FROM asg_users_inqinfo a
3345: WHERE tranid > p_tranid
3346: AND a.device_user_name = p_user_name AND a.deferred='N'
3347: AND a.tranid <= (SELECT nvl(hwm_tranid,1000000000000)
3348: FROM asg_user WHERE user_name=a.device_user_name);
3349:
3350: BEGIN
3351:
3352: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3402: FROM asg_user_pub_resps pr ,asg_user au

3398: END IF;
3399:
3400: SELECT au.user_id,pr.responsibility_id, pr.app_id
3401: INTO l_userid,l_respid,l_appid
3402: FROM asg_user_pub_resps pr ,asg_user au
3403: WHERE pr.user_name = upper(p_user_name)
3404: AND au.user_name=pr.user_name
3405: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3406:

Line 3541: FROM asg_user_pub_resps pr ,asg_user au

3537: l_orig_app_id := fnd_global.resp_appl_id();
3538:
3539: SELECT au.user_id,pr.responsibility_id, pr.app_id
3540: INTO l_user_id,l_resp_id,l_app_id
3541: FROM asg_user_pub_resps pr ,asg_user au
3542: WHERE pr.user_name = upper(p_user_name)
3543: AND au.user_name=pr.user_name
3544: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3545:

Line 3562: UPDATE asg_users_inqinfo

3558: FETCH c_deferred_processed INTO l_def_count;
3559: CLOSE c_deferred_processed;
3560: -- All the deferred records are processed
3561: IF l_def_count = 0 THEN
3562: UPDATE asg_users_inqinfo
3563: SET deferred = 'S'
3564: WHERE device_user_name = p_user_name AND
3565: tranid = p_tranid;
3566: END IF;

Line 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

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

Line 3665: FROM asg_user WHERE user_name=p_user_name;

3661:
3662:
3663: SELECT user_id,responsibility_id, app_id
3664: INTO l_user_id,l_resp_id,l_app_id
3665: FROM asg_user WHERE user_name=p_user_name;
3666:
3667: IF (instr(NVL(fnd_profile.value('APPS_SSO'),'NULL'),'SSO')>0)
3668: AND (NVL(fnd_profile.value_specific('APPS_SSO_LOCAL_LOGIN',l_user_id,l_resp_id,l_app_id),'BOTH')<>'LOCAL') THEN
3669: RETURN TRUE;

Line 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

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);
3696:

Line 3695: FROM ASG_USER WHERE USER_ID=p_user_id);

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);
3696:
3697: CSM_HTML5_PKG.DELETE_USER_VAULT(p_user_id);
3698: END DROP_USER;
3699:

Line 3722: FROM ASG_USER WHERE USER_NAME=p_user_name;

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:
3724: RETURN l_store;
3725: END get_app_upg_info;
3726: