DBA Data[Home] [Help]

APPS.MSC_X_CUST_FACING_RELEASE dependencies on FND_GLOBAL

Line 59: l_user_name := FND_GLOBAL.USER_NAME;

55: lv_timeout NUMBER:= 120.0; /* minutes */
56: BEGIN
57: LOG_MESSAGE( 'Started the Release program on Source instance');
58:
59: l_user_name := FND_GLOBAL.USER_NAME;
60: l_resp_name := FND_GLOBAL.RESP_NAME;
61: l_application_name := FND_GLOBAL.APPLICATION_NAME;
62:
63: v_sql_stmt:=

Line 60: l_resp_name := FND_GLOBAL.RESP_NAME;

56: BEGIN
57: LOG_MESSAGE( 'Started the Release program on Source instance');
58:
59: l_user_name := FND_GLOBAL.USER_NAME;
60: l_resp_name := FND_GLOBAL.RESP_NAME;
61: l_application_name := FND_GLOBAL.APPLICATION_NAME;
62:
63: v_sql_stmt:=
64: 'BEGIN MSC_X_VMI_POREQ.START_RELEASE_PROGRAM'||p_dblink||'('

Line 61: l_application_name := FND_GLOBAL.APPLICATION_NAME;

57: LOG_MESSAGE( 'Started the Release program on Source instance');
58:
59: l_user_name := FND_GLOBAL.USER_NAME;
60: l_resp_name := FND_GLOBAL.RESP_NAME;
61: l_application_name := FND_GLOBAL.APPLICATION_NAME;
62:
63: v_sql_stmt:=
64: 'BEGIN MSC_X_VMI_POREQ.START_RELEASE_PROGRAM'||p_dblink||'('
65: ||' :lv_errbuf,'

Line 488: SELECT FND_GLOBAL.USER_ID,

484: l_END_ORDER_LINE_NUMBER VARCHAR2(20);
485:
486: BEGIN
487:
488: SELECT FND_GLOBAL.USER_ID,
489: FND_GLOBAL.USER_NAME,
490: FND_GLOBAL.RESP_NAME,
491: FND_GLOBAL.APPLICATION_NAME
492: INTO l_user_id,

Line 489: FND_GLOBAL.USER_NAME,

485:
486: BEGIN
487:
488: SELECT FND_GLOBAL.USER_ID,
489: FND_GLOBAL.USER_NAME,
490: FND_GLOBAL.RESP_NAME,
491: FND_GLOBAL.APPLICATION_NAME
492: INTO l_user_id,
493: l_user_name,

Line 490: FND_GLOBAL.RESP_NAME,

486: BEGIN
487:
488: SELECT FND_GLOBAL.USER_ID,
489: FND_GLOBAL.USER_NAME,
490: FND_GLOBAL.RESP_NAME,
491: FND_GLOBAL.APPLICATION_NAME
492: INTO l_user_id,
493: l_user_name,
494: l_resp_name,

Line 491: FND_GLOBAL.APPLICATION_NAME

487:
488: SELECT FND_GLOBAL.USER_ID,
489: FND_GLOBAL.USER_NAME,
490: FND_GLOBAL.RESP_NAME,
491: FND_GLOBAL.APPLICATION_NAME
492: INTO l_user_id,
493: l_user_name,
494: l_resp_name,
495: l_application_name

Line 500: /*SELECT FND_GLOBAL.USER_ID,

496: FROM dual;
497:
498: IF (pDestination = SYS_YES) then
499:
500: /*SELECT FND_GLOBAL.USER_ID,
501: FND_GLOBAL.USER_NAME,
502: FND_GLOBAL.RESP_NAME,
503: FND_GLOBAL.APPLICATION_NAME
504: INTO l_user_id,

Line 501: FND_GLOBAL.USER_NAME,

497:
498: IF (pDestination = SYS_YES) then
499:
500: /*SELECT FND_GLOBAL.USER_ID,
501: FND_GLOBAL.USER_NAME,
502: FND_GLOBAL.RESP_NAME,
503: FND_GLOBAL.APPLICATION_NAME
504: INTO l_user_id,
505: l_user_name,

Line 502: FND_GLOBAL.RESP_NAME,

498: IF (pDestination = SYS_YES) then
499:
500: /*SELECT FND_GLOBAL.USER_ID,
501: FND_GLOBAL.USER_NAME,
502: FND_GLOBAL.RESP_NAME,
503: FND_GLOBAL.APPLICATION_NAME
504: INTO l_user_id,
505: l_user_name,
506: l_resp_name,

Line 503: FND_GLOBAL.APPLICATION_NAME

499:
500: /*SELECT FND_GLOBAL.USER_ID,
501: FND_GLOBAL.USER_NAME,
502: FND_GLOBAL.RESP_NAME,
503: FND_GLOBAL.APPLICATION_NAME
504: INTO l_user_id,
505: l_user_name,
506: l_resp_name,
507: l_application_name

Line 849: FND_GLOBAL.USER_ID,

845: lv_atp_override, --- atp override
846: lv_transaction_type,
847: l_cust_organization_id, --- For cons. advice , pass the cust model org
848: sysdate,
849: FND_GLOBAL.USER_ID,
850: sysdate,
851: FND_GLOBAL.USER_ID,
852: -1,
853: l_ORDER_NUMBER ,

Line 851: FND_GLOBAL.USER_ID,

847: l_cust_organization_id, --- For cons. advice , pass the cust model org
848: sysdate,
849: FND_GLOBAL.USER_ID,
850: sysdate,
851: FND_GLOBAL.USER_ID,
852: -1,
853: l_ORDER_NUMBER ,
854: l_RELEASE_NUMBER ,
855: l_LINE_NUMBER ,