eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on PO_VENDORS

Line 52: from cursors - c_po_vendor_sites_all, c_po_vendors

48: Modified the object to remove literals from DML statements and CURSORS.
49:
50: 8. 08-Jul-2005 Sanjikum for Bug#4482462
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:

Line 111: 2) Changed the parameters being passed to cursor - c_po_vendors and c_po_vendor_sites_all

107: Added the WHO columns in the 'insert into JAI_AP_TDS_INVOICES' statement
108:
109: 15. 19-Aug-2005 Ramananda for bug#4562793. File Version 120.6
110: 1) Moved the Cursor - c_ja_in_tax_codes, up from below the cursor c_po_vendor_sites_all
111: 2) Changed the parameters being passed to cursor - c_po_vendors and c_po_vendor_sites_all
112: 3) In the procedure maintain_thhold_grps, while updating the table - jai_ap_tds_thhold_grps,
113: changed the update for column - current_threshold_slab_id
114:
115: Dependency Due to this Bug

Line 855: cursor c_po_vendors(p_vendor_id number) is

851: and actual_section_code is not null
852: group by actual_section_code;
853: --having sum(tax_amount) <> 0; --Commented by Bgowrava for Bug#8254510
854:
855: cursor c_po_vendors(p_vendor_id number) is
856: select tds_vendor_type_lookup_code
857: from JAI_AP_TDS_VNDR_TYPE_V
858: where vendor_id = p_vendor_id;
859:

Line 964: from po_vendors a,

960: cursor c_get_vendor_pan_tan(p_vendor_id number , p_vendor_site_id number) is
961: select c.pan_no pan_no,
962: d.org_tan_num tan_no,
963: c.confirm_pan_flag confirm_pan_flag /*Fixing QA Bug 12431997 - Included in 11896260*/
964: from po_vendors a,
965: po_vendor_sites_all b,
966: JAI_AP_TDS_VENDOR_HDRS c,
967: jai_ap_tds_org_tan_v d --rchandan for bug#4323338
968: where a.vendor_id = b.vendor_id

Line 1112: lv_vendor_type_lookup_code po_vendors.vendor_type_lookup_code%type;

1108: ln_cnt_already_processed number:= 0;
1109: ln_tax_id number;
1110: ln_tax_amount number;
1111: ln_threshold_grp_id number;
1112: lv_vendor_type_lookup_code po_vendors.vendor_type_lookup_code%type;
1113: ln_threshold_hdr_id number;
1114: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1115: ln_total_invoice_amount number;
1116: ln_threshold_slab_id_before number;

Line 1395: open c_po_vendors(p_vendor_id);

1391:
1392:
1393: /* Get vendor_type_lookup_code */
1394: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1395: open c_po_vendors(p_vendor_id);
1396: fetch c_po_vendors into lv_vendor_type_lookup_code;
1397: close c_po_vendors;
1398:
1399: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);

Line 1396: fetch c_po_vendors into lv_vendor_type_lookup_code;

1392:
1393: /* Get vendor_type_lookup_code */
1394: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1395: open c_po_vendors(p_vendor_id);
1396: fetch c_po_vendors into lv_vendor_type_lookup_code;
1397: close c_po_vendors;
1398:
1399: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
1400:

Line 1397: close c_po_vendors;

1393: /* Get vendor_type_lookup_code */
1394: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1395: open c_po_vendors(p_vendor_id);
1396: fetch c_po_vendors into lv_vendor_type_lookup_code;
1397: close c_po_vendors;
1398:
1399: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
1400:
1401:

Line 1977: cursor c_po_vendors(cp_vendor_id number) is

1973: from po_vendor_sites_all
1974: where vendor_id = cp_vendor_id
1975: and vendor_site_id = cp_vendor_site_id;
1976:
1977: cursor c_po_vendors(cp_vendor_id number) is
1978: select terms_id,
1979: --payment_method_lookup_code, --commented by Sanjikum for Bug#4482462
1980: pay_group_lookup_code
1981: from po_vendors

Line 1981: from po_vendors

1977: cursor c_po_vendors(cp_vendor_id number) is
1978: select terms_id,
1979: --payment_method_lookup_code, --commented by Sanjikum for Bug#4482462
1980: pay_group_lookup_code
1981: from po_vendors
1982: where vendor_id = cp_vendor_id;
1983:
1984:
1985: cursor c_ja_in_tax_codes (pn_tax_id number) is

Line 2014: r_po_vendors c_po_vendors%rowtype;

2010:
2011: r_ap_invoices_all c_ap_invoices_all%rowtype;
2012: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
2013: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
2014: r_po_vendors c_po_vendors%rowtype;
2015: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
2016: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
2017:
2018:

Line 2042: ln_terms_id po_vendors.terms_id%type;

2038:
2039: ln_exchange_rate number;
2040: lv_this_procedure varchar2(50); --File.Sql.35 Cbabu := 'jaiap.generate_tds_invoice';
2041:
2042: ln_terms_id po_vendors.terms_id%type;
2043: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462
2044: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
2045:
2046: lv_ja_in_ap_inv_id varchar2(15);

Line 2043: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462

2039: ln_exchange_rate number;
2040: lv_this_procedure varchar2(50); --File.Sql.35 Cbabu := 'jaiap.generate_tds_invoice';
2041:
2042: ln_terms_id po_vendors.terms_id%type;
2043: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462
2044: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
2045:
2046: lv_ja_in_ap_inv_id varchar2(15);
2047: ld_accounting_date date;

Line 2044: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;

2040: lv_this_procedure varchar2(50); --File.Sql.35 Cbabu := 'jaiap.generate_tds_invoice';
2041:
2042: ln_terms_id po_vendors.terms_id%type;
2043: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462
2044: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
2045:
2046: lv_ja_in_ap_inv_id varchar2(15);
2047: ld_accounting_date date;
2048: lv_open_period ap_invoice_distributions_all.period_name%type;

Line 2109: || open c_po_vendors(r_ap_invoices_all.vendor_id);

2105: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
2106: close c_ja_in_tax_codes;
2107:
2108: /*
2109: || open c_po_vendors(r_ap_invoices_all.vendor_id);
2110: || Commented the above and added the below by Ramananda for Bug#4562793
2111: */
2112: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
2113: fetch c_po_vendors into r_po_vendors;

Line 2112: open c_po_vendors(r_ja_in_tax_codes.vendor_id);

2108: /*
2109: || open c_po_vendors(r_ap_invoices_all.vendor_id);
2110: || Commented the above and added the below by Ramananda for Bug#4562793
2111: */
2112: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
2113: fetch c_po_vendors into r_po_vendors;
2114: close c_po_vendors;
2115:
2116: /*

Line 2113: fetch c_po_vendors into r_po_vendors;

2109: || open c_po_vendors(r_ap_invoices_all.vendor_id);
2110: || Commented the above and added the below by Ramananda for Bug#4562793
2111: */
2112: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
2113: fetch c_po_vendors into r_po_vendors;
2114: close c_po_vendors;
2115:
2116: /*
2117: || open c_po_vendor_sites_all(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);

Line 2114: close c_po_vendors;

2110: || Commented the above and added the below by Ramananda for Bug#4562793
2111: */
2112: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
2113: fetch c_po_vendors into r_po_vendors;
2114: close c_po_vendors;
2115:
2116: /*
2117: || open c_po_vendor_sites_all(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);
2118: || Commented the above and added the below by sanjikum for Bug#4562793

Line 2152: ln_terms_id := r_po_vendors.terms_id;

2148: )
2149: then
2150:
2151: /* Get the payment details from the vendor as it has been not defined for the site */
2152: ln_terms_id := r_po_vendors.terms_id;
2153: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462
2154: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;
2155:
2156: end if;

Line 2153: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462

2149: then
2150:
2151: /* Get the payment details from the vendor as it has been not defined for the site */
2152: ln_terms_id := r_po_vendors.terms_id;
2153: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462
2154: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;
2155:
2156: end if;
2157:

Line 2154: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;

2150:
2151: /* Get the payment details from the vendor as it has been not defined for the site */
2152: ln_terms_id := r_po_vendors.terms_id;
2153: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462
2154: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;
2155:
2156: end if;
2157:
2158: