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 156: ap_invoice_distributions_s.nextval retainage_distribution_id,

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

Line 263: ap_invoice_distributions aid

259: aid.global_attribute20,
260: aid.intended_use,
261: aid.pay_awt_group_id /*bug13090879 */
262: FROM ap_invoice_lines ail,
263: ap_invoice_distributions aid
264: WHERE ail.invoice_id = aid.invoice_id
265: AND ail.line_number = aid.invoice_line_number
266: AND ail.invoice_id = c_invoice_id
267: AND ail.line_number = c_invoice_line_number

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

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

Line 281: l_max_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;

277:
278: item_dist_tab itemDistType;
279: inv_dist_tab invDistType;
280:
281: l_max_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
282: l_retainage_rate number;
283:
284: l_sum_amount number;
285: l_sum_base_amount number;

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

505: -----------------------------------------------------------------
506:
507: FORALL j in x_retainage_dist_tab.first .. x_retainage_dist_tab.last
508:
509: INSERT INTO ap_invoice_distributions VALUES x_retainage_dist_tab(j);
510:
511: -----------------------------------------------------------------
512: l_debug_info := 'Step 5: Update related_retainage_dist_id on parent distributions';
513: Print (l_api_name, l_debug_info);

Line 518: UPDATE ap_invoice_distributions_all

514: -----------------------------------------------------------------
515:
516: FORALL k in inv_dist_tab.first .. inv_dist_tab.last
517:
518: UPDATE ap_invoice_distributions_all
519: SET related_retainage_dist_id = inv_dist_tab(k)
520: WHERE invoice_distribution_id = inv_dist_tab(k);
521:
522: -----------------------------------------------------------------