APPS.AP_RETAINAGE_PKG dependencies on AP_INVOICE_LINES

Line 34: Procedure Update_PO_Shipment_Dists (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,

30: x_retainage_dist_tab OUT NOCOPY retDistType);
31:
32: Procedure Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type);
33:
34: Procedure Update_PO_Shipment_Dists (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
35: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
36: x_retainage_dist_tab IN retDistType);
37:
38: Procedure Print (x_api_name IN Varchar2, x_debug_info IN Varchar2);

Line 35: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,

31:
32: Procedure Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type);
33:
34: Procedure Update_PO_Shipment_Dists (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
35: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
36: x_retainage_dist_tab IN retDistType);
37:
38: Procedure Print (x_api_name IN Varchar2, x_debug_info IN Varchar2);
39:

Line 42: c_invoice_line_number IN ap_invoice_lines.line_number%type) IS

38: Procedure Print (x_api_name IN Varchar2, x_debug_info IN Varchar2);
39:
40:
41: CURSOR c_invoice_info(c_invoice_id IN ap_invoices.invoice_id%type,
42: c_invoice_line_number IN ap_invoice_lines.line_number%type) IS
43: Select ai.invoice_amount invoice_amount,
44: ai.exchange_rate exchange_rate,
45: ai.invoice_currency_code invoice_currency_code,
46: ai.payment_currency_code payment_currency_code,

Line 64: ap_invoice_lines ail,

60: fc.precision precision,
61: fc.minimum_accountable_unit minimum_accountable_unit,
62: fsp.retainage_code_combination_id retainage_code_combination_id
63: From ap_invoices ai,
64: ap_invoice_lines ail,
65: ap_system_parameters asp,
66: financials_system_parameters fsp,
67: fnd_currencies fc
68: Where ail.invoice_id = c_invoice_id

Line 80: x_invoice_line_number IN ap_invoice_lines.line_number%type) AS

76: g_user_id NUMBER;
77: g_login_id NUMBER;
78:
79: PROCEDURE Create_Retainage_Distributions(x_invoice_id IN ap_invoices.invoice_id%type,
80: x_invoice_line_number IN ap_invoice_lines.line_number%type) AS
81:
82: l_debug_info Varchar2(240);
83: l_api_name Constant Varchar2(100) := 'Create_Retainage_Distributions';
84:

Line 146: c_invoice_line_number IN ap_invoice_lines.line_number%type,

142: x_invoice_line_number IN NUMBER,
143: x_retainage_dist_tab OUT NOCOPY retDistType) AS
144:
145: CURSOR c_invoice_distributions (c_invoice_id IN ap_invoices.invoice_id%type,
146: c_invoice_line_number IN ap_invoice_lines.line_number%type,
147: c_max_dist_line_number IN ap_invoice_lines.line_number%type,
148: c_retainage_rate IN number) IS
149: SELECT
150: aid.batch_id,

Line 147: c_max_dist_line_number IN ap_invoice_lines.line_number%type,

143: x_retainage_dist_tab OUT NOCOPY retDistType) AS
144:
145: CURSOR c_invoice_distributions (c_invoice_id IN ap_invoices.invoice_id%type,
146: c_invoice_line_number IN ap_invoice_lines.line_number%type,
147: c_max_dist_line_number IN ap_invoice_lines.line_number%type,
148: c_retainage_rate IN number) IS
149: SELECT
150: aid.batch_id,
151: aid.invoice_id,

Line 259: FROM ap_invoice_lines ail,

255: aid.global_attribute18,
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

Line 300: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(x_invoice_id, x_invoice_line_number);

296: -----------------------------------------------------------------
297:
298: l_retainage_rate := g_invoice_info.retained_amount / g_invoice_info.line_amount;
299:
300: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(x_invoice_id, x_invoice_line_number);
301:
302: OPEN c_invoice_distributions (x_invoice_id,
303: x_invoice_line_number,
304: l_max_dist_line_number,

Line 523: l_retained_amount ap_invoice_lines_all.retained_amount%type

519:
520: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;
521: l_invoice_amount ap_invoices_all.invoice_amount%type
522: := g_invoice_info.invoice_amount;
523: l_retained_amount ap_invoice_lines_all.retained_amount%type
524: := g_invoice_info.retained_amount;
525: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
526: := g_invoice_info.invoice_currency_code;
527: l_payment_currency_code ap_invoices_all.payment_currency_code%type

Line 673: (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,

669:
670: END Update_Payment_Schedules;
671:
672: Procedure Update_PO_Shipment_Dists
673: (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
674: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
675: x_retainage_dist_tab IN retDistType) AS
676:
677: l_po_ap_dist_rec PO_AP_DIST_REC_TYPE;

Line 674: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,

670: END Update_Payment_Schedules;
671:
672: Procedure Update_PO_Shipment_Dists
673: (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
674: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
675: x_retainage_dist_tab IN retDistType) AS
676:
677: l_po_ap_dist_rec PO_AP_DIST_REC_TYPE;
678: l_po_ap_line_loc_rec PO_AP_LINE_LOC_REC_TYPE;