DBA Data[Home] [Help]

APPS.AP_RETAINAGE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

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 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 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: -----------------------------------------------------------------