DBA Data[Home] [Help]

APPS.MSC_EXCEPTION_PKG dependencies on FND_GLOBAL

Line 96: fnd_global.user_id,

92: exception_value2,
93: exception_tbl.exception_days,
94: exception_tbl.exception_quantity,
95: exception_tbl.exception_ratio,
96: fnd_global.user_id,
97: sysdate,
98: sysdate,
99: fnd_global.user_id,
100: fnd_global.login_id,

Line 99: fnd_global.user_id,

95: exception_tbl.exception_ratio,
96: fnd_global.user_id,
97: sysdate,
98: sysdate,
99: fnd_global.user_id,
100: fnd_global.login_id,
101: fnd_global.conc_program_id,
102: fnd_global.conc_login_id,
103: fnd_global.prog_appl_id,

Line 100: fnd_global.login_id,

96: fnd_global.user_id,
97: sysdate,
98: sysdate,
99: fnd_global.user_id,
100: fnd_global.login_id,
101: fnd_global.conc_program_id,
102: fnd_global.conc_login_id,
103: fnd_global.prog_appl_id,
104: fnd_global.conc_request_id

Line 101: fnd_global.conc_program_id,

97: sysdate,
98: sysdate,
99: fnd_global.user_id,
100: fnd_global.login_id,
101: fnd_global.conc_program_id,
102: fnd_global.conc_login_id,
103: fnd_global.prog_appl_id,
104: fnd_global.conc_request_id
105: from (

Line 102: fnd_global.conc_login_id,

98: sysdate,
99: fnd_global.user_id,
100: fnd_global.login_id,
101: fnd_global.conc_program_id,
102: fnd_global.conc_login_id,
103: fnd_global.prog_appl_id,
104: fnd_global.conc_request_id
105: from (
106: select

Line 103: fnd_global.prog_appl_id,

99: fnd_global.user_id,
100: fnd_global.login_id,
101: fnd_global.conc_program_id,
102: fnd_global.conc_login_id,
103: fnd_global.prog_appl_id,
104: fnd_global.conc_request_id
105: from (
106: select
107: med.plan_id,

Line 104: fnd_global.conc_request_id

100: fnd_global.login_id,
101: fnd_global.conc_program_id,
102: fnd_global.conc_login_id,
103: fnd_global.prog_appl_id,
104: fnd_global.conc_request_id
105: from (
106: select
107: med.plan_id,
108: decode(sign(nvl(med.organization_id, -23453)),

Line 669: fnd_global.user_id, sysdate,

665: sum(f.exception_value2),
666: sum(f.exception_days),
667: sum(f.exception_quantity),
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from

Line 670: sysdate, fnd_global.user_id, fnd_global.login_id,

666: sum(f.exception_days),
667: sum(f.exception_quantity),
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,

Line 671: fnd_global.conc_program_id, fnd_global.conc_login_id,

667: sum(f.exception_quantity),
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,
675: msc_phub_item_categories_mv q

Line 672: fnd_global.prog_appl_id, fnd_global.conc_request_id

668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,
675: msc_phub_item_categories_mv q
676: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 744: fnd_global.user_id, sysdate,

740: sum(f.exception_value2),
741: sum(f.exception_days),
742: sum(f.exception_quantity),
743: sum(f.exception_ratio),
744: fnd_global.user_id, sysdate,
745: sysdate, fnd_global.user_id, fnd_global.login_id,
746: fnd_global.conc_program_id, fnd_global.conc_login_id,
747: fnd_global.prog_appl_id, fnd_global.conc_request_id
748: from

Line 745: sysdate, fnd_global.user_id, fnd_global.login_id,

741: sum(f.exception_days),
742: sum(f.exception_quantity),
743: sum(f.exception_ratio),
744: fnd_global.user_id, sysdate,
745: sysdate, fnd_global.user_id, fnd_global.login_id,
746: fnd_global.conc_program_id, fnd_global.conc_login_id,
747: fnd_global.prog_appl_id, fnd_global.conc_request_id
748: from
749: msc_exceptions_f f,

Line 746: fnd_global.conc_program_id, fnd_global.conc_login_id,

742: sum(f.exception_quantity),
743: sum(f.exception_ratio),
744: fnd_global.user_id, sysdate,
745: sysdate, fnd_global.user_id, fnd_global.login_id,
746: fnd_global.conc_program_id, fnd_global.conc_login_id,
747: fnd_global.prog_appl_id, fnd_global.conc_request_id
748: from
749: msc_exceptions_f f,
750: msc_phub_dates_mv d

Line 747: fnd_global.prog_appl_id, fnd_global.conc_request_id

743: sum(f.exception_ratio),
744: fnd_global.user_id, sysdate,
745: sysdate, fnd_global.user_id, fnd_global.login_id,
746: fnd_global.conc_program_id, fnd_global.conc_login_id,
747: fnd_global.prog_appl_id, fnd_global.conc_request_id
748: from
749: msc_exceptions_f f,
750: msc_phub_dates_mv d
751: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 892: ' fnd_global.user_id, sysdate,'||

888: ' f.exception_value2,'||
889: ' f.exception_days,'||
890: ' f.exception_quantity,'||
891: ' f.exception_ratio,'||
892: ' fnd_global.user_id, sysdate,'||
893: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
894: ' from'||
895: ' '||l_apps_schema||'.msc_exceptions_f'||l_suffix||' f,'||
896: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

Line 893: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

889: ' f.exception_days,'||
890: ' f.exception_quantity,'||
891: ' f.exception_ratio,'||
892: ' fnd_global.user_id, sysdate,'||
893: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
894: ' from'||
895: ' '||l_apps_schema||'.msc_exceptions_f'||l_suffix||' f,'||
896: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
897: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 1066: fnd_global.user_id, sysdate,

1062: exception_days,
1063: exception_quantity,
1064: exception_ratio,
1065: 0, -23453, -23453,
1066: fnd_global.user_id, sysdate,
1067: fnd_global.user_id, sysdate, fnd_global.login_id
1068: from msc_st_exceptions_f
1069: where st_transaction_id=p_st_transaction_id and error_code=0;
1070:

Line 1067: fnd_global.user_id, sysdate, fnd_global.login_id

1063: exception_quantity,
1064: exception_ratio,
1065: 0, -23453, -23453,
1066: fnd_global.user_id, sysdate,
1067: fnd_global.user_id, sysdate, fnd_global.login_id
1068: from msc_st_exceptions_f
1069: where st_transaction_id=p_st_transaction_id and error_code=0;
1070:
1071: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: inserted='||sql%rowcount);