DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 824: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;

820: --End Bug#10241241
821:
822: FOR i in nvl(X_dist_tab.FIRST, 0) .. nvl(X_dist_tab.LAST, -1) LOOP
823:
824: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;
825:
826: INSERT INTO ap_invoice_distributions (
827: batch_id,
828: invoice_id,

Line 1220: -- AP_INVOICE_DISTRIBUTIONS such as match_status_flag, base_amount,

1216:
1217:
1218: -----------------------------------------------------------------------
1219: -- PROCEDURE update_distributions updates columns in
1220: -- AP_INVOICE_DISTRIBUTIONS such as match_status_flag, base_amount,
1221: -- type_1099, income_tax_region.
1222: -- PRECONDITION: Procedure is called during POST-FORMS-COMMIT
1223: -----------------------------------------------------------------------
1224:

Line 4815: ap_invoice_distributions_s.nextval, -- invoice_distribution_id

4811: pay_awt_group_id)
4812: VALUES (X_batch_id, -- batch_id
4813: l_invoice_line_rec.invoice_id, -- invoice_id
4814: l_invoice_line_rec.line_number, -- invoice_line_number
4815: ap_invoice_distributions_s.nextval, -- invoice_distribution_id
4816: 1, -- distribution_line_number
4817: l_invoice_line_rec.line_type_lookup_code, -- line_type_lookup_code
4818: l_distribution_class, -- distribution_class
4819: l_invoice_line_rec.description, -- description

Line 5747: , ap_invoice_distributions_s.nextval invoice_distribution_id

5743: )
5744: SELECT X_batch_id batch_id
5745: , l_invoice_line_rec.invoice_id invoice_id
5746: , l_invoice_line_rec.line_number invoice_line_number
5747: , ap_invoice_distributions_s.nextval invoice_distribution_id
5748: , rownum distribution_line_number
5749: , 'AWT' line_type_lookup_code
5750: , l_distribution_class distribution_class
5751: , l_invoice_line_rec.description description

Line 7655: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;

7651: -- Bug 13841774. End.
7652:
7653: FOR i in nvl(l_dist_tab.FIRST, 0) .. nvl(l_dist_tab.LAST, -1) LOOP
7654:
7655: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;
7656:
7657: INSERT INTO ap_invoice_distributions(
7658: batch_id,
7659: invoice_id,