DBA Data[Home] [Help]

APPS.MSC_RELEASE_PK dependencies on FND_GLOBAL

Line 737: SELECT FND_GLOBAL.USER_NAME,

733:
734: --Fix for the bug#2538765. This enables the auto-release to use the user level
735: --profile value defined in the source instance.
736:
737: SELECT FND_GLOBAL.USER_NAME,
738: FND_GLOBAL.RESP_NAME,
739: FND_GLOBAL.APPLICATION_NAME
740: INTO var_user_name,
741: var_resp_name,

Line 738: FND_GLOBAL.RESP_NAME,

734: --Fix for the bug#2538765. This enables the auto-release to use the user level
735: --profile value defined in the source instance.
736:
737: SELECT FND_GLOBAL.USER_NAME,
738: FND_GLOBAL.RESP_NAME,
739: FND_GLOBAL.APPLICATION_NAME
740: INTO var_user_name,
741: var_resp_name,
742: var_application_name

Line 739: FND_GLOBAL.APPLICATION_NAME

735: --profile value defined in the source instance.
736:
737: SELECT FND_GLOBAL.USER_NAME,
738: FND_GLOBAL.RESP_NAME,
739: FND_GLOBAL.APPLICATION_NAME
740: INTO var_user_name,
741: var_resp_name,
742: var_application_name
743: FROM dual;

Line 765: 'SELECT FND_GLOBAL.USER_ID,'

761: OUT v_po_batch_number;
762:
763:
764: var_sql_stmt:=
765: 'SELECT FND_GLOBAL.USER_ID,'
766: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
767: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
768: ||' FROM DUAL';
769: