DBA Data[Home] [Help]

APPS.MSC_RELEASE_PK dependencies on FND_GLOBAL

Line 590: SELECT FND_GLOBAL.USER_NAME,

586:
587: --Fix for the bug#2538765. This enables the auto-release to use the user level
588: --profile value defined in the source instance.
589:
590: SELECT FND_GLOBAL.USER_NAME,
591: FND_GLOBAL.RESP_NAME,
592: FND_GLOBAL.APPLICATION_NAME
593: INTO var_user_name,
594: var_resp_name,

Line 591: FND_GLOBAL.RESP_NAME,

587: --Fix for the bug#2538765. This enables the auto-release to use the user level
588: --profile value defined in the source instance.
589:
590: SELECT FND_GLOBAL.USER_NAME,
591: FND_GLOBAL.RESP_NAME,
592: FND_GLOBAL.APPLICATION_NAME
593: INTO var_user_name,
594: var_resp_name,
595: var_application_name

Line 592: FND_GLOBAL.APPLICATION_NAME

588: --profile value defined in the source instance.
589:
590: SELECT FND_GLOBAL.USER_NAME,
591: FND_GLOBAL.RESP_NAME,
592: FND_GLOBAL.APPLICATION_NAME
593: INTO var_user_name,
594: var_resp_name,
595: var_application_name
596: FROM dual;

Line 618: 'SELECT FND_GLOBAL.USER_ID,'

614: OUT v_po_batch_number;
615:
616:
617: var_sql_stmt:=
618: 'SELECT FND_GLOBAL.USER_ID,'
619: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
620: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
621: ||' FROM DUAL';
622: