eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 41: TYPE relDistType IS TABLE OF ap_invoice_distributions_all%rowtype INDEX BY PLS_INTEGER;

37: g_user_id NUMBER;
38: g_login_id NUMBER;
39:
40: TYPE releaseLinesType IS TABLE OF ap_invoice_lines_all%rowtype INDEX BY PLS_INTEGER;
41: TYPE relDistType IS TABLE OF ap_invoice_distributions_all%rowtype INDEX BY PLS_INTEGER;
42:
43: Procedure Lock_Retained_Invoices (x_retained_lines_tab IN retainedLinesType,
44: x_lock_status OUT NOCOPY BOOLEAN);
45:

Line 480: Cursor c_retained_distributions (c_invoice_id in ap_invoice_distributions_all.invoice_id%type,

476: Procedure create_release_distributions (x_release_amount IN number,
477: x_release_amount_remaining IN number,
478: x_released_lines_tab IN releaseLinesType) As
479:
480: Cursor c_retained_distributions (c_invoice_id in ap_invoice_distributions_all.invoice_id%type,
481: c_line_number in ap_invoice_distributions_all.invoice_line_number%type) Is
482: select aid.*,
483: ap_invoice_distributions_s.nextval released_invoice_dist_id
484: from ap_invoice_distributions aid

Line 481: c_line_number in ap_invoice_distributions_all.invoice_line_number%type) Is

477: x_release_amount_remaining IN number,
478: x_released_lines_tab IN releaseLinesType) As
479:
480: Cursor c_retained_distributions (c_invoice_id in ap_invoice_distributions_all.invoice_id%type,
481: c_line_number in ap_invoice_distributions_all.invoice_line_number%type) Is
482: select aid.*,
483: ap_invoice_distributions_s.nextval released_invoice_dist_id
484: from ap_invoice_distributions aid
485: where invoice_id = c_invoice_id

Line 494: Type invDistIDType IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%type INDEX BY PLS_INTEGER;

490:
491: retained_dist_tab retDistType;
492: released_dist_tab relDistType;
493:
494: Type invDistIDType IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%type INDEX BY PLS_INTEGER;
495: Type relAmtType IS TABLE OF ap_invoice_distributions_all.amount%type INDEX BY PLS_INTEGER;
496:
497: retained_inv_dist_id_tab invDistIDType;
498: release_amount_tab relAmtType;

Line 495: Type relAmtType IS TABLE OF ap_invoice_distributions_all.amount%type INDEX BY PLS_INTEGER;

491: retained_dist_tab retDistType;
492: released_dist_tab relDistType;
493:
494: Type invDistIDType IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%type INDEX BY PLS_INTEGER;
495: Type relAmtType IS TABLE OF ap_invoice_distributions_all.amount%type INDEX BY PLS_INTEGER;
496:
497: retained_inv_dist_id_tab invDistIDType;
498: release_amount_tab relAmtType;
499:

Line 732: INSERT INTO ap_invoice_distributions_all VALUES released_dist_tab(k);

728: IF released_dist_tab.count > 0 THEN
729:
730: FORALL k in released_dist_tab.first .. released_dist_tab.last
731:
732: INSERT INTO ap_invoice_distributions_all VALUES released_dist_tab(k);
733:
734: END IF;
735:
736: -----------------------------------------------------------------

Line 745: UPDATE ap_invoice_distributions_all

741: IF retained_inv_dist_id_tab.count > 0 THEN
742:
743: FORALL i in retained_inv_dist_id_tab.first .. retained_inv_dist_id_tab.last
744:
745: UPDATE ap_invoice_distributions_all
746: SET retained_amount_remaining = (abs(retained_amount_remaining) - abs(release_amount_tab(i)))
747: WHERE invoice_distribution_id = retained_inv_dist_id_tab(i);
748:
749: END IF;