APPS.IGW_REPORT_PROCESSING dependencies on FND_GLOBAL

Line 179: l_item_budget_justification := rec_itemized_budget.budget_justification||fnd_global.local_chr(10);

175: for rec_itemized_budget in c_itemized_budget
176: LOOP
177: if rec_itemized_budget.budget_justification is not null then
178: if c_itemized_budget%ROWCOUNT = 1 then
179: l_item_budget_justification := rec_itemized_budget.budget_justification||fnd_global.local_chr(10);
180: else
181: if l_item_budget_justification is not null then
182: l_item_budget_justification := l_item_budget_justification||fnd_global.local_chr(10)||rec_itemized_budget.budget_justification||fnd_global.local_chr(10);
183: else

Line 182: l_item_budget_justification := l_item_budget_justification||fnd_global.local_chr(10)||rec_itemized_budget.budget_justification||fnd_global.local_chr(10);

178: if c_itemized_budget%ROWCOUNT = 1 then
179: l_item_budget_justification := rec_itemized_budget.budget_justification||fnd_global.local_chr(10);
180: else
181: if l_item_budget_justification is not null then
182: l_item_budget_justification := l_item_budget_justification||fnd_global.local_chr(10)||rec_itemized_budget.budget_justification||fnd_global.local_chr(10);
183: else
184: l_item_budget_justification := rec_itemized_budget.budget_justification;
185: end if;
186: end if;

Line 194: l_category_budget_just := l_category_budget_just||fnd_global.local_chr(10)||l_item_budget_justification;

190: if c_budget_category%ROWCOUNT = 1 then
191: l_category_budget_just := l_item_budget_justification;
192: else
193: if l_category_budget_just is not null then
194: l_category_budget_just := l_category_budget_just||fnd_global.local_chr(10)||l_item_budget_justification;
195: else
196: l_category_budget_just := l_item_budget_justification;
197: end if;
198: end if;

Line 226: fnd_global.local_chr(10)||rec_report_justification.justification;

222: /*
223: for rec_report_justification in c_report_justification
224: LOOP
225: l_proposal_budget_just := l_proposal_budget_just||rec_report_justification.proposal_budget_category||
226: fnd_global.local_chr(10)||rec_report_justification.justification;
227: END LOOP; --rec_report_justification
228:
229: l_proposal_budget_just := nvl(substr(l_proposal_budget_just,1,4000),'NULL');
230: insert into igw_prop_abstracts(

Line 246: ,fnd_global.user_id

242: ,'C.1'
243: ,l_proposal_budget_just
244: ,'IGW_ABSTRACT_TYPES'
245: ,sysdate
246: ,fnd_global.user_id
247: ,sysdate
248: ,fnd_global.user_id
249: ,fnd_global.login_id);
250: */

Line 248: ,fnd_global.user_id

244: ,'IGW_ABSTRACT_TYPES'
245: ,sysdate
246: ,fnd_global.user_id
247: ,sysdate
248: ,fnd_global.user_id
249: ,fnd_global.login_id);
250: */
251: x_return_status := 'S';
252: EXCEPTION

Line 249: ,fnd_global.login_id);

245: ,sysdate
246: ,fnd_global.user_id
247: ,sysdate
248: ,fnd_global.user_id
249: ,fnd_global.login_id);
250: */
251: x_return_status := 'S';
252: EXCEPTION
253: when FND_API.G_EXC_ERROR then

Line 293: fnd_global.local_chr(10)||rec_report_justification.justification;

289:
290: for rec_report_justification in c_report_justification
291: LOOP
292: l_proposal_budget_just := l_proposal_budget_just||rec_report_justification.proposal_budget_category||
293: fnd_global.local_chr(10)||rec_report_justification.justification;
294: END LOOP; --rec_report_justification
295:
296: l_proposal_budget_just := nvl(substr(l_proposal_budget_just,1,4000),'NULL');
297: insert into igw_prop_abstracts(

Line 313: ,fnd_global.user_id

309: ,'C.1'
310: ,l_proposal_budget_just
311: ,'IGW_ABSTRACT_TYPES'
312: ,sysdate
313: ,fnd_global.user_id
314: ,sysdate
315: ,fnd_global.user_id
316: ,fnd_global.login_id);
317:

Line 315: ,fnd_global.user_id

311: ,'IGW_ABSTRACT_TYPES'
312: ,sysdate
313: ,fnd_global.user_id
314: ,sysdate
315: ,fnd_global.user_id
316: ,fnd_global.login_id);
317:
318: x_return_status := 'S';
319:

Line 316: ,fnd_global.login_id);

312: ,sysdate
313: ,fnd_global.user_id
314: ,sysdate
315: ,fnd_global.user_id
316: ,fnd_global.login_id);
317:
318: x_return_status := 'S';
319:
320: EXCEPTION