DBA Data[Home] [Help]

APPS.MSC_CL_PULL dependencies on FND_GLOBAL

Line 357: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

353: IF v_cp_enabled= MSC_UTIL.SYS_NO THEN
354: RETURN MSC_UTIL.SYS_YES;
355: END IF;
356:
357: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
358:
359: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS
360: ( l_request_id,
361: NULL,

Line 570: FND_GLOBAL.USER_NAME,

566:
567: BEGIN
568:
569: SELECT
570: FND_GLOBAL.USER_NAME,
571: FND_GLOBAL.RESP_NAME,
572: FND_GLOBAL.APPLICATION_NAME
573: INTO lv_user_name,
574: lv_resp_name,

Line 571: FND_GLOBAL.RESP_NAME,

567: BEGIN
568:
569: SELECT
570: FND_GLOBAL.USER_NAME,
571: FND_GLOBAL.RESP_NAME,
572: FND_GLOBAL.APPLICATION_NAME
573: INTO lv_user_name,
574: lv_resp_name,
575: lv_application_name

Line 572: FND_GLOBAL.APPLICATION_NAME

568:
569: SELECT
570: FND_GLOBAL.USER_NAME,
571: FND_GLOBAL.RESP_NAME,
572: FND_GLOBAL.APPLICATION_NAME
573: INTO lv_user_name,
574: lv_resp_name,
575: lv_application_name
576: FROM dual;

Line 624: /* SELECT FND_GLOBAL.USER_NAME,

620: savepoint start_of_submission;
621:
622: -- agmcont:
623:
624: /* SELECT FND_GLOBAL.USER_NAME,
625: FND_GLOBAL.RESP_NAME,
626: FND_GLOBAL.APPLICATION_NAME
627: INTO lv_user_name,
628: lv_resp_name,

Line 625: FND_GLOBAL.RESP_NAME,

621:
622: -- agmcont:
623:
624: /* SELECT FND_GLOBAL.USER_NAME,
625: FND_GLOBAL.RESP_NAME,
626: FND_GLOBAL.APPLICATION_NAME
627: INTO lv_user_name,
628: lv_resp_name,
629: lv_application_name

Line 626: FND_GLOBAL.APPLICATION_NAME

622: -- agmcont:
623:
624: /* SELECT FND_GLOBAL.USER_NAME,
625: FND_GLOBAL.RESP_NAME,
626: FND_GLOBAL.APPLICATION_NAME
627: INTO lv_user_name,
628: lv_resp_name,
629: lv_application_name
630: FROM dual;

Line 633: lv_user_name := FND_GLOBAL.USER_NAME;

629: lv_application_name
630: FROM dual;
631: */
632:
633: lv_user_name := FND_GLOBAL.USER_NAME;
634: lv_resp_name := FND_GLOBAL.RESP_NAME;
635: lv_application_name := FND_GLOBAL.APPLICATION_NAME;
636:
637: SELECT APPLICATION_ID

Line 634: lv_resp_name := FND_GLOBAL.RESP_NAME;

630: FROM dual;
631: */
632:
633: lv_user_name := FND_GLOBAL.USER_NAME;
634: lv_resp_name := FND_GLOBAL.RESP_NAME;
635: lv_application_name := FND_GLOBAL.APPLICATION_NAME;
636:
637: SELECT APPLICATION_ID
638: INTO lv_application_id

Line 635: lv_application_name := FND_GLOBAL.APPLICATION_NAME;

631: */
632:
633: lv_user_name := FND_GLOBAL.USER_NAME;
634: lv_resp_name := FND_GLOBAL.RESP_NAME;
635: lv_application_name := FND_GLOBAL.APPLICATION_NAME;
636:
637: SELECT APPLICATION_ID
638: INTO lv_application_id
639: FROM FND_APPLICATION_VL

Line 1260: IF fnd_global.conc_request_id > 0 THEN

1256: v_monitor_request_id := pMONITOR_REQUEST_ID;
1257:
1258: -- SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
1259:
1260: IF fnd_global.conc_request_id > 0 THEN
1261: v_cp_enabled:= MSC_UTIL.SYS_YES;
1262: ELSE
1263: v_cp_enabled:= MSC_UTIL.SYS_NO;
1264: END IF;

Line 1991: IF fnd_global.conc_request_id > 0 THEN

1987: lv_inv_ctp_val NUMBER := NVL(FND_PROFILE.Value('INV_CTP'),0);
1988:
1989: BEGIN
1990: v_instance_id := pINSTANCE_ID;
1991: IF fnd_global.conc_request_id > 0 THEN
1992: v_cp_enabled:= MSC_UTIL.SYS_YES;
1993: ELSE
1994: v_cp_enabled:= MSC_UTIL.SYS_NO;
1995: END IF;

Line 2344: SELECT FND_GLOBAL.USER_ID

2340: RETURN;
2341: END;
2342:
2343:
2344: SELECT FND_GLOBAL.USER_ID
2345: INTO v_current_user
2346: FROM MSC_APPS_INSTANCES
2347: WHERE INSTANCE_ID= pINSTANCE_ID;
2348:

Line 2487: -- IF fnd_global.conc_request_id > 0 THEN

2483:
2484: --- PREPLACE CHANGE END ---
2485:
2486: /* check if this procedure is launched as a concurrent program */
2487: -- IF fnd_global.conc_request_id > 0 THEN
2488: -- v_cp_enabled:= MSC_UTIL.SYS_YES;
2489: -- ELSE
2490: -- v_cp_enabled:= MSC_UTIL.SYS_NO;
2491: -- END IF;

Line 2917: FND_GLOBAL.CONC_REQUEST_ID,

2913: lv_worker_prg,
2914: NULL, -- description
2915: NULL, -- start date
2916: FALSE, -- TRUE,
2917: FND_GLOBAL.CONC_REQUEST_ID,
2918: pINSTANCE_ID,
2919: pTIMEOUT,
2920: pLANG,
2921: pRTYPE,

Line 3037: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);

3033: SET PULL_WRKR_START_TIME = lv_src_time
3034: WHERE INSTANCE_ID = pINSTANCE_ID;
3035: END;
3036:
3037: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
3038: -- ============ Send Tasks to Task Que 'v_pipe_task_que' =============
3039:
3040: FOR lc_i IN 1..lv_total_task_number LOOP
3041:

Line 4345: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,

4341: MSC_UTIL.SYS_YES)
4342: )
4343: ,MSC_UTIL.SYS_YES),
4344: LAST_UPDATE_DATE= SYSDATE,
4345: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4346: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4347: WHERE INSTANCE_ID= pINSTANCE_ID;
4348:
4349: RETCODE := MSC_UTIL.G_SUCCESS;

Line 4346: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4342: )
4343: ,MSC_UTIL.SYS_YES),
4344: LAST_UPDATE_DATE= SYSDATE,
4345: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4346: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4347: WHERE INSTANCE_ID= pINSTANCE_ID;
4348:
4349: RETCODE := MSC_UTIL.G_SUCCESS;
4350:

Line 4392: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,

4388:
4389: UPDATE MSC_APPS_INSTANCES
4390: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
4391: LAST_UPDATE_DATE= SYSDATE,
4392: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4393: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4394: WHERE INSTANCE_ID= pINSTANCE_ID;
4395:
4396: RETCODE:= MSC_UTIL.G_SUCCESS;

Line 4393: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4389: UPDATE MSC_APPS_INSTANCES
4390: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
4391: LAST_UPDATE_DATE= SYSDATE,
4392: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4393: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4394: WHERE INSTANCE_ID= pINSTANCE_ID;
4395:
4396: RETCODE:= MSC_UTIL.G_SUCCESS;
4397: RETURN TRUE;

Line 4405: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,

4401:
4402: UPDATE MSC_APPS_INSTANCES
4403: SET ST_STATUS= MSC_UTIL.G_ST_READY,
4404: LAST_UPDATE_DATE= SYSDATE,
4405: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4406: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4407: WHERE INSTANCE_ID= pINSTANCE_ID;
4408:
4409: RETCODE:= MSC_UTIL.G_SUCCESS;

Line 4406: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4402: UPDATE MSC_APPS_INSTANCES
4403: SET ST_STATUS= MSC_UTIL.G_ST_READY,
4404: LAST_UPDATE_DATE= SYSDATE,
4405: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4406: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4407: WHERE INSTANCE_ID= pINSTANCE_ID;
4408:
4409: RETCODE:= MSC_UTIL.G_SUCCESS;
4410: RETURN TRUE;

Line 4452: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,

4448: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4449: LRID= msc_cl_refresh_s.currval,
4450: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4451: LAST_UPDATE_DATE= SYSDATE,
4452: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4453: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,
4454: LR_SOURCING_FLAG = pSOURCING_ENABLED
4455: WHERE INSTANCE_ID= pINSTANCE_ID;
4456: */

Line 4453: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,

4449: LRID= msc_cl_refresh_s.currval,
4450: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4451: LAST_UPDATE_DATE= SYSDATE,
4452: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4453: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,
4454: LR_SOURCING_FLAG = pSOURCING_ENABLED
4455: WHERE INSTANCE_ID= pINSTANCE_ID;
4456: */
4457:

Line 4468: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,

4464: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, DECODE(pRTYPE,MSC_UTIL.G_INCREMENTAL,'I', 'C'), 'I'),
4465: LRID= msc_cl_refresh_s.currval,
4466: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4467: LAST_UPDATE_DATE= SYSDATE,
4468: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4469: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,
4470: LR_SOURCING_FLAG = pSOURCING_ENABLED
4471: WHERE INSTANCE_ID= pINSTANCE_ID;
4472:

Line 4469: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,

4465: LRID= msc_cl_refresh_s.currval,
4466: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4467: LAST_UPDATE_DATE= SYSDATE,
4468: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4469: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,
4470: LR_SOURCING_FLAG = pSOURCING_ENABLED
4471: WHERE INSTANCE_ID= pINSTANCE_ID;
4472:
4473: --- PREPLACE CHANGE END ---

Line 5057: IF fnd_global.conc_request_id > 0 THEN

5053:
5054: BEGIN
5055:
5056:
5057: IF fnd_global.conc_request_id > 0 THEN
5058: v_cp_enabled:= MSC_UTIL.SYS_YES;
5059: ELSE
5060: v_cp_enabled:= MSC_UTIL.SYS_NO;
5061: END IF;

Line 5157: FND_GLOBAL.USER_ID,

5153: INSTANCE_CODE||':',
5154: APPS_VER,
5155: GMT_DIFFERENCE/24.0,
5156: SYSDATE,
5157: FND_GLOBAL.USER_ID,
5158: SYSDATE,
5159: INSTANCE_TYPE
5160: INTO v_dblink,
5161: v_icode,