APPS.AP_RETAINAGE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 24: TYPE retDistType IS TABLE OF ap_invoice_distributions_all%rowtype INDEX BY PLS_INTEGER;

20: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
21: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
22: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RETAINAGE_PKG.';
23:
24: TYPE retDistType IS TABLE OF ap_invoice_distributions_all%rowtype INDEX BY PLS_INTEGER;
25:
26: x_retainage_dist_tab retDistType;
27:
28: Procedure Insert_Distributions (x_invoice_id IN NUMBER,

Line 154: ap_invoice_distributions_s.nextval retainage_distribution_id,

150: aid.batch_id,
151: aid.invoice_id,
152: aid.invoice_line_number,
153: aid.invoice_distribution_id invoice_distribution_id,
154: ap_invoice_distributions_s.nextval retainage_distribution_id,
155: aid.distribution_line_number + c_max_dist_line_number retainage_dist_line_number,
156: 'RETAINAGE' line_type_lookup_code,
157: aid.description,
158: aid.dist_match_type,

Line 260: ap_invoice_distributions aid

256: aid.global_attribute19,
257: aid.global_attribute20,
258: aid.intended_use
259: FROM ap_invoice_lines ail,
260: ap_invoice_distributions aid
261: WHERE ail.invoice_id = aid.invoice_id
262: AND ail.line_number = aid.invoice_line_number
263: AND ail.invoice_id = c_invoice_id
264: AND ail.line_number = c_invoice_line_number

Line 273: TYPE invDistType IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%type INDEX BY PLS_INTEGER;

269: aid.line_type_lookup_code = 'IPV')
270: );
271:
272: TYPE itemDistType IS TABLE OF c_invoice_distributions%rowtype INDEX BY PLS_INTEGER;
273: TYPE invDistType IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%type INDEX BY PLS_INTEGER;
274:
275: item_dist_tab itemDistType;
276: inv_dist_tab invDistType;
277:

Line 278: l_max_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;

274:
275: item_dist_tab itemDistType;
276: inv_dist_tab invDistType;
277:
278: l_max_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
279: l_retainage_rate number;
280:
281: l_sum_amount number;
282: l_sum_base_amount number;

Line 479: INSERT INTO ap_invoice_distributions VALUES x_retainage_dist_tab(j);

475: -----------------------------------------------------------------
476:
477: FORALL j in x_retainage_dist_tab.first .. x_retainage_dist_tab.last
478:
479: INSERT INTO ap_invoice_distributions VALUES x_retainage_dist_tab(j);
480:
481: -----------------------------------------------------------------
482: l_debug_info := 'Step 5: Update related_retainage_dist_id on parent distributions';
483: Print (l_api_name, l_debug_info);

Line 488: UPDATE ap_invoice_distributions_all

484: -----------------------------------------------------------------
485:
486: FORALL k in inv_dist_tab.first .. inv_dist_tab.last
487:
488: UPDATE ap_invoice_distributions_all
489: SET related_retainage_dist_id = inv_dist_tab(k)
490: WHERE invoice_distribution_id = inv_dist_tab(k);
491:
492: -----------------------------------------------------------------