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,
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,
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
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
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
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
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,
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,
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,
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
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
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
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,
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
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,'||
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,'||
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:
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);