APPS.GMS_OIE_INT_PKG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 238: v_adl_rec gms_award_distributions%ROWTYPE;

234: FUNCTION CreateACGenADL(p_award_id IN NUMBER,
235: p_project_id IN NUMBER,
236: p_task_id IN NUMBER)
237: RETURN NUMBER IS
238: v_adl_rec gms_award_distributions%ROWTYPE;
239: BEGIN
240: v_adl_rec.award_set_id := GMS_AWARDS_DIST_PKG.get_award_set_id;
241: v_adl_rec.award_id := p_award_id;
242: v_adl_rec.project_id := p_project_id;

Line 266: delete from gms_award_distributions

262: RETURN BOOLEAN IS
263:
264: BEGIN
265:
266: delete from gms_award_distributions
267: where award_set_id = p_award_set_id;
268:
269: return TRUE;
270:

Line 384: from gms_awards_all aw, gms_award_distributions adl

380: forall i in cur_project_id.FIRST..cur_project_id.LAST
381:
382: update ap_expense_report_lines_all aerl
383: set (award_id, award_number) = (select aw.award_id, aw.award_number
384: from gms_awards_all aw, gms_award_distributions adl
385: where aw.award_id = adl.award_id
386: and adl.expenditure_item_id = aerl.reference_1
387: and adl.document_type = 'EXP'
388: and adl.adl_status = 'A'

Line 441: from gms_award_distributions

437: select ind_compiled_set_id, burdenable_raw_cost,
438: resource_list_member_id, bud_task_id
439: into t_ind_compiled_set_id(i), t_burdenable_cost(i),
440: t_rlmi_id(i), t_bud_task_id(i)
441: from gms_award_distributions
442: where expenditure_item_id = t_reference_1(i)
443: and cdl_line_num = t_reference_2(i)
444: and adl_status = 'A'
445: and document_type = 'EXP'

Line 451: insert into gms_award_distributions (

447: end loop;
448: end if;
449:
450: forall i in t_distribution_line_number.first..t_distribution_line_number.last
451: insert into gms_award_distributions (
452: AWARD_SET_ID,
453: ADL_LINE_NUM,
454: FUNDING_PATTERN_ID,
455: DISTRIBUTION_VALUE,