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