APPS.JAI_AP_OI_PROCESSING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 49: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,

45: end auto_approval_inv;
46:
47: PROCEDURE pre_data_for_ap_line
48: (
49: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,
50: pn_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,
51: pv_return_code OUT NOCOPY VARCHAR2,
52: pv_return_message OUT NOCOPY VARCHAR2
53: ) IS

Line 50: pn_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,

46:
47: PROCEDURE pre_data_for_ap_line
48: (
49: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,
50: pn_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,
51: pv_return_code OUT NOCOPY VARCHAR2,
52: pv_return_message OUT NOCOPY VARCHAR2
53: ) IS
54:

Line 55: CURSOR c_inv_lines( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE, cp_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE ) IS

51: pv_return_code OUT NOCOPY VARCHAR2,
52: pv_return_message OUT NOCOPY VARCHAR2
53: ) IS
54:
55: CURSOR c_inv_lines( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE, cp_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE ) IS
56: select *
57: from ap_invoice_lines_all
58: where invoice_id = cp_invoice_id
59: and line_number = cp_line_number;

Line 57: from ap_invoice_lines_all

53: ) IS
54:
55: CURSOR c_inv_lines( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE, cp_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE ) IS
56: select *
57: from ap_invoice_lines_all
58: where invoice_id = cp_invoice_id
59: and line_number = cp_line_number;
60:
61: CURSOR c_invs( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE) IS

Line 61: CURSOR c_invs( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE) IS

57: from ap_invoice_lines_all
58: where invoice_id = cp_invoice_id
59: and line_number = cp_line_number;
60:
61: CURSOR c_invs( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE) IS
62: Select *
63: from ap_invoices_all
64: where invoice_id = cp_invoice_id;
65:

Line 98: ln_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE;

94: and po_header_id = cp_po_header_id
95: and po_line_id = cp_po_line_id
96: and tax_id = cp_tax_id;
97:
98: ln_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE;
99: ln_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
100: lv_match_type VARCHAR2(20);
101: lv_trx_id VARCHAR2(30);
102: lv_receipt_code VARCHAR2(20);

Line 99: ln_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

95: and po_line_id = cp_po_line_id
96: and tax_id = cp_tax_id;
97:
98: ln_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE;
99: ln_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
100: lv_match_type VARCHAR2(20);
101: lv_trx_id VARCHAR2(30);
102: lv_receipt_code VARCHAR2(20);
103: ln_shipment_line_id NUMBER;

Line 108: inv_lines_rec ap_invoice_lines_all%rowtype;

104: ln_shipment_header_id NUMBER;
105: lv_shipment_num rcv_headers_interface.shipment_num%type;
106: lb_result BOOLEAN := FALSE ;
107: invs_rec ap_invoices_all%rowtype;
108: inv_lines_rec ap_invoice_lines_all%rowtype;
109: ln_vendor_id NUMBER;
110: ln_index number := 1;
111: l_tax_line_tbl jai_ap_match_tax_proc_pkg.l_tax_line_tbl_type;
112: ln_vendor_id NUMBER;