DBA Data[Home] [Help]

APPS.GMS_EXP_ADJUSTMENT_PKG dependencies on GMS_PA_API

Line 89: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then

85: select project_id into x_project_id
86: from pa_tasks
87: where task_id = x_task_id ;
88:
89: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then
90: -- Fix ends for bug number : 1708977
91:
92: Begin
93: select distinct(adl.project_id), adl.award_id into x_project_id , x_award_id

Line 140: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check

136:
137: gms_awards_dist_pkg.create_adls(x_adl_rec);
138: EXIT ; -- Fix for bug : 2642650
139: -- Fix for bug number: 1708977
140: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check
141:
142: ELSE
143:
144: DELETE from pa_expenditure_items_all

Line 188: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then

184: -- Fix starts for bug number : 1708977
185: select project_id into x_project_id
186: from pa_tasks
187: where task_id = rev_rec.task_id ;
188: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then
189: -- Fix ends for bug number : 1708977
190:
191: begin
192: select distinct(project_id), award_id into x_project_id ,x_award_id

Line 315: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then

311: select project_id into x_project_id
312: from pa_tasks
313: where task_id = x_task_id ;
314:
315: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then
316:
317: -- Fix ends for bug number : 1708977
318:
319: Begin

Line 373: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check

369:
370: gms_awards_dist_pkg.create_adls(x_adl_rec);
371: EXIT ; -- Fix for bug : 2642650
372:
373: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check
374:
375: End if ;
376: END LOOP;
377: END LOOP;

Line 417: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then

413: select project_id into x_project_id
414: from pa_tasks
415: where task_id = rev_rec.task_id ;
416:
417: IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) then
418:
419: -- Fix ends for bug number : 1708977
420: Begin
421: select distinct(adl.project_id), adl.award_id into x_project_id , x_award_id

Line 455: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check

451: x_adl_rec.last_update_login := rev_rec.last_update_login;
452:
453: gms_awards_dist_pkg.create_adls(x_adl_rec);
454:
455: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check
456:
457: END LOOP;
458: EXCEPTION
459: when others then