DBA Data[Home] [Help]

APPS.GMS_AWARDS_DIST_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 262: -- Create a link between ap_invoice_distributions_all

258: IPV distribution the new award_set_id is stamped on the IPV distribution. */
259: ELSIF ((p_doc_type = 'AP') and (p_called_from = 'MISC_SYNCH_ADLS')) THEN
260: -- 3478028 11.5.10 grants accounting patch.
261: -- --------------------------------------------------
262: -- Create a link between ap_invoice_distributions_all
263: -- and ADL.
264: -- --------------------------------------------------
265: -- BUG: 3517362 forward port funds check related changes.
266:

Line 271: UPDATE ap_invoice_distributions_all

267: -- In r12, FC mode is always autonomous ...
268:
269: -- IF NVL(PSA_FUNDS_CHECKER_PKG.g_fc_autonomous_flag,'N') <> 'Y' THEN
270:
271: UPDATE ap_invoice_distributions_all
272: set award_id = x_new_award_set_id
273: WHERE invoice_id = p_invoice_id
274: and invoice_distribution_id = p_dist_id
275: and exists ( select 'X'

Line 284: from ap_invoice_distributions_all

280: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly
281: on gms_award_distributions. */
282: UPDATE gms_award_distributions
283: set distribution_line_number = (select distribution_line_number
284: from ap_invoice_distributions_all
285: where invoice_id = p_invoice_id
286: and invoice_distribution_id = p_dist_id
287: and award_id = x_new_award_set_id )
288: where award_set_id = x_new_award_set_id