APPS.IGC_CC_INT_CC_REL_PUB dependencies on AP_INVOICES_ALL

Line 107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,

103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,
110: p_user_id IN igc_cc_headers.created_by%TYPE,
111: p_login_id IN igc_cc_headers.last_update_login%TYPE,

Line 108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,

104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,
110: p_user_id IN igc_cc_headers.created_by%TYPE,
111: p_login_id IN igc_cc_headers.last_update_login%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,

Line 123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;

119: l_api_version CONSTANT NUMBER := 1.0;
120: l_cc_headers_rec igc_cc_headers%ROWTYPE;
121: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;
123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;
124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
127: := 0;

Line 131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;

127: := 0;
128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
129: := 0;
130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;
131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;
132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;
133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;

Line 132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;

128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
129: := 0;
130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;
131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;
132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;
133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;

Line 133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;

129: := 0;
130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;
131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;
132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;
133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;
137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;

Line 179: FROM ap_invoices_all ap

175:
176: CURSOR c_inv_csr
177: IS
178: SELECT *
179: FROM ap_invoices_all ap
180: WHERE ap.set_of_books_id = p_sob_id
181: AND ap.org_id = p_org_id
182: AND ap.invoice_id = p_invoice_id;
183:

Line 358: FROM ap_invoices_all ap

354: THEN
355: BEGIN
356: SELECT ap.invoice_currency_code, ap.exchange_rate
357: INTO l_ap_currency_code, l_ap_conversion_rate
358: FROM ap_invoices_all ap
359: WHERE ap.invoice_id = p_invoice_id
360: AND ap.org_id = p_org_id
361: AND ap.set_of_books_id = p_sob_id;
362: EXCEPTION