DBA Data[Home] [Help]

APPS.MSC_PHUB_BUDGET_PKG dependencies on FND_GLOBAL

Line 83: fnd_global.user_id,

79: t.budget_value,
80: t.budget_value * decode(t.currency_code,
81: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),
82: 1, nvl(mcc.conv_rate,0)) budget_value2,
83: fnd_global.user_id,
84: sysdate,
85: fnd_global.user_id,
86: sysdate,
87: fnd_global.login_id,

Line 85: fnd_global.user_id,

81: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),
82: 1, nvl(mcc.conv_rate,0)) budget_value2,
83: fnd_global.user_id,
84: sysdate,
85: fnd_global.user_id,
86: sysdate,
87: fnd_global.login_id,
88: fnd_global.conc_program_id,
89: fnd_global.conc_login_id,

Line 87: fnd_global.login_id,

83: fnd_global.user_id,
84: sysdate,
85: fnd_global.user_id,
86: sysdate,
87: fnd_global.login_id,
88: fnd_global.conc_program_id,
89: fnd_global.conc_login_id,
90: fnd_global.prog_appl_id,
91: fnd_global.conc_request_id

Line 88: fnd_global.conc_program_id,

84: sysdate,
85: fnd_global.user_id,
86: sysdate,
87: fnd_global.login_id,
88: fnd_global.conc_program_id,
89: fnd_global.conc_login_id,
90: fnd_global.prog_appl_id,
91: fnd_global.conc_request_id
92: from

Line 89: fnd_global.conc_login_id,

85: fnd_global.user_id,
86: sysdate,
87: fnd_global.login_id,
88: fnd_global.conc_program_id,
89: fnd_global.conc_login_id,
90: fnd_global.prog_appl_id,
91: fnd_global.conc_request_id
92: from
93: (select

Line 90: fnd_global.prog_appl_id,

86: sysdate,
87: fnd_global.login_id,
88: fnd_global.conc_program_id,
89: fnd_global.conc_login_id,
90: fnd_global.prog_appl_id,
91: fnd_global.conc_request_id
92: from
93: (select
94: -- budget_level: 0:plan 1:org 2:cat 3:org-cat

Line 91: fnd_global.conc_request_id

87: fnd_global.login_id,
88: fnd_global.conc_program_id,
89: fnd_global.conc_login_id,
90: fnd_global.prog_appl_id,
91: fnd_global.conc_request_id
92: from
93: (select
94: -- budget_level: 0:plan 1:org 2:cat 3:org-cat
95: decode(sign(b.organization_id), -1,

Line 151: fnd_global.user_id,

147: budget_value,
148: budget_value * decode(currency_code,
149: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),
150: 1, nvl(mcc.conv_rate,0)) budget_value2,
151: fnd_global.user_id,
152: sysdate,
153: fnd_global.user_id,
154: sysdate,
155: fnd_global.login_id,

Line 153: fnd_global.user_id,

149: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),
150: 1, nvl(mcc.conv_rate,0)) budget_value2,
151: fnd_global.user_id,
152: sysdate,
153: fnd_global.user_id,
154: sysdate,
155: fnd_global.login_id,
156: fnd_global.conc_program_id,
157: fnd_global.conc_login_id,

Line 155: fnd_global.login_id,

151: fnd_global.user_id,
152: sysdate,
153: fnd_global.user_id,
154: sysdate,
155: fnd_global.login_id,
156: fnd_global.conc_program_id,
157: fnd_global.conc_login_id,
158: fnd_global.prog_appl_id,
159: fnd_global.conc_request_id

Line 156: fnd_global.conc_program_id,

152: sysdate,
153: fnd_global.user_id,
154: sysdate,
155: fnd_global.login_id,
156: fnd_global.conc_program_id,
157: fnd_global.conc_login_id,
158: fnd_global.prog_appl_id,
159: fnd_global.conc_request_id
160: from

Line 157: fnd_global.conc_login_id,

153: fnd_global.user_id,
154: sysdate,
155: fnd_global.login_id,
156: fnd_global.conc_program_id,
157: fnd_global.conc_login_id,
158: fnd_global.prog_appl_id,
159: fnd_global.conc_request_id
160: from
161: (select

Line 158: fnd_global.prog_appl_id,

154: sysdate,
155: fnd_global.login_id,
156: fnd_global.conc_program_id,
157: fnd_global.conc_login_id,
158: fnd_global.prog_appl_id,
159: fnd_global.conc_request_id
160: from
161: (select
162: l_budget_value budget_value,

Line 159: fnd_global.conc_request_id

155: fnd_global.login_id,
156: fnd_global.conc_program_id,
157: fnd_global.conc_login_id,
158: fnd_global.prog_appl_id,
159: fnd_global.conc_request_id
160: from
161: (select
162: l_budget_value budget_value,
163: l_owning_currency_code currency_code

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

224: ' c.category_name,'||
225: ' f.budget_level,'||
226: ' f.budget_value,'||
227: ' f.budget_value2,'||
228: ' fnd_global.user_id, sysdate,'||
229: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
230: ' from'||
231: ' '||l_apps_schema||'.msc_budgets_f'||l_suffix||' f,'||
232: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

225: ' f.budget_level,'||
226: ' f.budget_value,'||
227: ' f.budget_value2,'||
228: ' fnd_global.user_id, sysdate,'||
229: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
230: ' from'||
231: ' '||l_apps_schema||'.msc_budgets_f'||l_suffix||' f,'||
232: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
233: ' '||l_apps_schema||'.msc_phub_categories_mv'||l_suffix||' c,'||

Line 314: fnd_global.user_id, sysdate,

310: nvl(sr_category_id, -1),
311: budget_level,
312: budget_value,
313: budget_value2,
314: fnd_global.user_id, sysdate,
315: fnd_global.user_id, sysdate, fnd_global.login_id
316: from msc_st_budgets_f
317: where st_transaction_id=p_st_transaction_id and error_code=0;
318:

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

311: budget_level,
312: budget_value,
313: budget_value2,
314: fnd_global.user_id, sysdate,
315: fnd_global.user_id, sysdate, fnd_global.login_id
316: from msc_st_budgets_f
317: where st_transaction_id=p_st_transaction_id and error_code=0;
318:
319: msc_phub_util.log('msc_phub_budget_pkg.import_budgets_f: inserted='||sql%rowcount);