APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_UTILS_PKG

Line 55: while calling procedure - jai_ap_utils_pkg.insert_ap_inv_interface

51: 1) In the procedure - generate_tds_invoices, removed the column payment_method_lookup_code
52: from cursors - c_po_vendor_sites_all, c_po_vendors
53: 2) In the procedure generate_tds_invoices, commented the if condition of payment_method_lookup_code
54: 3) In the procedure generate_tds_invoices, commented the value of parameter - p_payment_method_lookup_code
55: while calling procedure - jai_ap_utils_pkg.insert_ap_inv_interface
56:
57: Ramananda for bug# 4407184
58: Re-Done: SQL Bind variable compliance is done
59:

Line 130: called the jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id) to get the batch_name.

126:
127: 18. 02-Sep-2005 Ramananda for Bug#4584221, File Version 120.8
128: Made the following changes -
129: 1) Before submitting the request - APXIIMPT,
130: called the jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id) to get the batch_name.
131: 2) In submitting the request - APXIIMPT,
132: changed the parameter batch_name from hardcoded value to variable - lv_batch_name
133:
134: Dependency Due to this Bug (Functional)

Line 2337: jai_ap_utils_pkg.insert_ap_inv_interface

2333: if lv_invoice_to_tds_num is not null and lv_invoice_to_tds_type is not null and NVL(ln_invoice_to_tds_amount,0) <> 0 then
2334:
2335: /* Generate the Invoice for the TDS authority - always in functional currency - INR */
2336:
2337: jai_ap_utils_pkg.insert_ap_inv_interface
2338: (
2339: p_jai_source => lv_this_procedure,
2340: p_invoice_id => ln_invoice_to_tds_id,
2341: p_invoice_num => lv_invoice_to_tds_num,

Line 2372: jai_ap_utils_pkg.insert_ap_inv_lines_interface

2368: p_group_id => lv_group_id -- Bug# 6119216, changed to lv_group_id instead of to_char(p_invoice_id)
2369: );
2370:
2371: /* Lines Interface */
2372: jai_ap_utils_pkg.insert_ap_inv_lines_interface
2373: (
2374: p_jai_source => lv_this_procedure,
2375: p_invoice_id => ln_invoice_to_tds_id,
2376: p_invoice_line_id => ln_invoice_to_tds_line_id,

Line 2464: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default

2460: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
2461:
2462: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice
2463: If it is not present, then it needs to be defaulted from Vendor Site Setup. Passing NULL to
2464: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default
2465: from setup*/
2466: if (r_ap_invoices_all.accts_pay_code_combination_id is not NULL) then
2467: ln_accts_pay_ccid := r_ap_invoices_all.accts_pay_code_combination_id;
2468: else

Line 2474: jai_ap_utils_pkg.insert_ap_inv_interface

2470: end if;
2471:
2472: IF NVL(ln_invoice_to_vendor_amount,0) <> 0 THEN --condition added by bgowrava for bug#4549019
2473: /* Invoices Interface */
2474: jai_ap_utils_pkg.insert_ap_inv_interface
2475: (
2476: p_jai_source => lv_this_procedure,
2477: p_invoice_id => ln_invoice_to_vendor_id,
2478: p_invoice_num => lv_invoice_to_vendor_num,

Line 2513: jai_ap_utils_pkg.insert_ap_inv_lines_interface

2509: p_accts_pay_ccid => ln_accts_pay_ccid /*Bug 9759709*/
2510: );
2511:
2512: /* Lines Interface */
2513: jai_ap_utils_pkg.insert_ap_inv_lines_interface
2514: (
2515: p_jai_source => lv_this_procedure,
2516: p_invoice_id => ln_invoice_to_vendor_id,
2517: p_invoice_line_id => ln_invoice_to_vendor_line_id,

Line 3328: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id, r_ap_invoices_all.org_id); --Ramananda for bug#4584221 --added org_id parameter for Bug#9149941

3324: open c_ap_invoices_all(p_invoice_id);
3325: fetch c_ap_invoices_all into r_ap_invoices_all;
3326: close c_ap_invoices_all;
3327:
3328: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id, r_ap_invoices_all.org_id); --Ramananda for bug#4584221 --added org_id parameter for Bug#9149941
3329:
3330: ln_import_request_id :=
3331: fnd_request.submit_request
3332: (