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 148: c_invoice_line_number IN ap_invoice_lines.line_number%type,

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

Line 149: c_max_dist_line_number IN ap_invoice_lines.line_number%type,

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

Line 262: FROM ap_invoice_lines ail,

258: aid.global_attribute19,
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

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

302: -----------------------------------------------------------------
303:
304: l_retainage_rate := g_invoice_info.retained_amount / g_invoice_info.line_amount;
305:
306: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(x_invoice_id, x_invoice_line_number);
307:
308: -- start bug13090879
309: select
310: substr(patch_level, 8, 1)

Line 553: l_retained_amount ap_invoice_lines_all.retained_amount%type

549:
550: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;
551: l_invoice_amount ap_invoices_all.invoice_amount%type
552: := g_invoice_info.invoice_amount;
553: l_retained_amount ap_invoice_lines_all.retained_amount%type
554: := g_invoice_info.retained_amount;
555: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
556: := g_invoice_info.invoice_currency_code;
557: l_payment_currency_code ap_invoices_all.payment_currency_code%type

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

731:
732: END Update_Payment_Schedules;
733:
734: Procedure Update_PO_Shipment_Dists
735: (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
736: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
737: x_retainage_dist_tab IN retDistType) AS
738:
739: l_po_ap_dist_rec PO_AP_DIST_REC_TYPE;

Line 736: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,

732: END Update_Payment_Schedules;
733:
734: Procedure Update_PO_Shipment_Dists
735: (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
736: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
737: x_retainage_dist_tab IN retDistType) AS
738:
739: l_po_ap_dist_rec PO_AP_DIST_REC_TYPE;
740: l_po_ap_line_loc_rec PO_AP_LINE_LOC_REC_TYPE;