APPS.GMS_OIE_INT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 285: -- and update the award_id column on AP_INVOICE_DISTRIBUTIONS_ALL table with award_set_id of the

281: -- (OIE) only.
282: -- * For source of 'Oracle Project Accounting' update the expense report lines records with the
283: -- award_id and award_number for sponsored projects. Award information is obtained from ADL table.
284: -- * Common processing for both the above sources is to create ADLs with document_type = 'AP'
285: -- and update the award_id column on AP_INVOICE_DISTRIBUTIONS_ALL table with award_set_id of the
286: -- new ADLs.
287: --
288: procedure create_award_distributions(p_invoice_id IN gms_oie_int_pkg.invoice_id_tab) is
289:

Line 331: from ap_invoice_distributions_all aid,

327: null, -- ind_compiled_set_id
328: null, -- burdenable_raw_cost
329: null, -- rlmi_id
330: null -- bud_task_id
331: from ap_invoice_distributions_all aid,
332: ap_expense_report_headers_all aerh,
333: ap_expense_report_lines_all aerl,
334: gms_project_types gpt,
335: pa_projects_all pp

Line 551: update ap_invoice_distributions_all

547: returning award_set_id bulk collect
548: into t_award_set_id;
549:
550: forall asi in t_award_set_id.first..t_award_set_id.last
551: update ap_invoice_distributions_all
552: set award_id = t_award_set_id(asi)
553: where invoice_id = p_invoice_id(inv_index)
554: and distribution_line_number = t_distribution_line_number(asi);
555: