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 399: cursor c_po_vendors(p_vendor_id number) is

395: and actual_section_code is not null
396: group by actual_section_code
397: having sum(tax_amount) <> 0;
398:
399: cursor c_po_vendors(p_vendor_id number) is
400: select tds_vendor_type_lookup_code
401: from JAI_AP_TDS_VNDR_TYPE_V
402: where vendor_id = p_vendor_id;
403:

Line 487: from po_vendors a,

483:
484: cursor c_get_vendor_pan_tan(p_vendor_id number , p_vendor_site_id number) is
485: select c.pan_no pan_no,
486: d.org_tan_num tan_no
487: from po_vendors a,
488: po_vendor_sites_all b,
489: JAI_AP_TDS_VENDOR_HDRS c,
490: jai_ap_tds_org_tan_v d --rchandan for bug#4323338
491: where a.vendor_id = b.vendor_id

Line 545: lv_vendor_type_lookup_code po_vendors.vendor_type_lookup_code%type;

541: ln_cnt_already_processed number:= 0;
542: ln_tax_id number;
543: ln_tax_amount number;
544: ln_threshold_grp_id number;
545: lv_vendor_type_lookup_code po_vendors.vendor_type_lookup_code%type;
546: ln_threshold_hdr_id number;
547: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
548: ln_total_invoice_amount number;
549: ln_threshold_slab_id_before number;

Line 699: open c_po_vendors(p_vendor_id);

695:
696:
697: /* Get vendor_type_lookup_code */
698: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
699: open c_po_vendors(p_vendor_id);
700: fetch c_po_vendors into lv_vendor_type_lookup_code;
701: close c_po_vendors;
702:
703: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);

Line 700: fetch c_po_vendors into lv_vendor_type_lookup_code;

696:
697: /* Get vendor_type_lookup_code */
698: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
699: open c_po_vendors(p_vendor_id);
700: fetch c_po_vendors into lv_vendor_type_lookup_code;
701: close c_po_vendors;
702:
703: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
704: /* Get Pan number and Tan number for the vendor */

Line 701: close c_po_vendors;

697: /* Get vendor_type_lookup_code */
698: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
699: open c_po_vendors(p_vendor_id);
700: fetch c_po_vendors into lv_vendor_type_lookup_code;
701: close c_po_vendors;
702:
703: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
704: /* Get Pan number and Tan number for the vendor */
705: open c_get_vendor_pan_tan(p_vendor_id, p_vendor_site_id);

Line 1244: cursor c_po_vendors(cp_vendor_id number) is

1240: from po_vendor_sites_all
1241: where vendor_id = cp_vendor_id
1242: and vendor_site_id = cp_vendor_site_id;
1243:
1244: cursor c_po_vendors(cp_vendor_id number) is
1245: select terms_id,
1246: --payment_method_lookup_code, --commented by Sanjikum for Bug#4482462
1247: pay_group_lookup_code
1248: from po_vendors

Line 1248: from po_vendors

1244: cursor c_po_vendors(cp_vendor_id number) is
1245: select terms_id,
1246: --payment_method_lookup_code, --commented by Sanjikum for Bug#4482462
1247: pay_group_lookup_code
1248: from po_vendors
1249: where vendor_id = cp_vendor_id;
1250:
1251:
1252: cursor c_ja_in_tax_codes (pn_tax_id number) is

Line 1281: r_po_vendors c_po_vendors%rowtype;

1277:
1278: r_ap_invoices_all c_ap_invoices_all%rowtype;
1279: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1280: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
1281: r_po_vendors c_po_vendors%rowtype;
1282: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
1283: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
1284:
1285:

Line 1309: ln_terms_id po_vendors.terms_id%type;

1305:
1306: ln_exchange_rate number;
1307: lv_this_procedure varchar2(50); --File.Sql.35 Cbabu := 'jaiap.generate_tds_invoice';
1308:
1309: ln_terms_id po_vendors.terms_id%type;
1310: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462
1311: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
1312:
1313: lv_ja_in_ap_inv_id varchar2(15);

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

1306: ln_exchange_rate number;
1307: lv_this_procedure varchar2(50); --File.Sql.35 Cbabu := 'jaiap.generate_tds_invoice';
1308:
1309: ln_terms_id po_vendors.terms_id%type;
1310: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462
1311: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
1312:
1313: lv_ja_in_ap_inv_id varchar2(15);
1314: ld_accounting_date date;

Line 1311: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;

1307: lv_this_procedure varchar2(50); --File.Sql.35 Cbabu := 'jaiap.generate_tds_invoice';
1308:
1309: ln_terms_id po_vendors.terms_id%type;
1310: -- lv_payment_method_lookup_code po_vendors.payment_method_lookup_code%type; --commented by Sanjikum for Bug#4482462
1311: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
1312:
1313: lv_ja_in_ap_inv_id varchar2(15);
1314: ld_accounting_date date;
1315: lv_open_period ap_invoice_distributions_all.period_name%type;

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

1369: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
1370: close c_ja_in_tax_codes;
1371:
1372: /*
1373: || open c_po_vendors(r_ap_invoices_all.vendor_id);
1374: || Commented the above and added the below by Ramananda for Bug#4562793
1375: */
1376: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
1377: fetch c_po_vendors into r_po_vendors;

Line 1376: open c_po_vendors(r_ja_in_tax_codes.vendor_id);

1372: /*
1373: || open c_po_vendors(r_ap_invoices_all.vendor_id);
1374: || Commented the above and added the below by Ramananda for Bug#4562793
1375: */
1376: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
1377: fetch c_po_vendors into r_po_vendors;
1378: close c_po_vendors;
1379:
1380: /*

Line 1377: fetch c_po_vendors into r_po_vendors;

1373: || open c_po_vendors(r_ap_invoices_all.vendor_id);
1374: || Commented the above and added the below by Ramananda for Bug#4562793
1375: */
1376: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
1377: fetch c_po_vendors into r_po_vendors;
1378: close c_po_vendors;
1379:
1380: /*
1381: || open c_po_vendor_sites_all(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);

Line 1378: close c_po_vendors;

1374: || Commented the above and added the below by Ramananda for Bug#4562793
1375: */
1376: open c_po_vendors(r_ja_in_tax_codes.vendor_id);
1377: fetch c_po_vendors into r_po_vendors;
1378: close c_po_vendors;
1379:
1380: /*
1381: || open c_po_vendor_sites_all(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);
1382: || Commented the above and added the below by sanjikum for Bug#4562793

Line 1407: ln_terms_id := r_po_vendors.terms_id;

1403: )
1404: then
1405:
1406: /* Get the payment details from the vendor as it has been not defined for the site */
1407: ln_terms_id := r_po_vendors.terms_id;
1408: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462
1409: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;
1410:
1411: end if;

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

1404: then
1405:
1406: /* Get the payment details from the vendor as it has been not defined for the site */
1407: ln_terms_id := r_po_vendors.terms_id;
1408: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462
1409: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;
1410:
1411: end if;
1412:

Line 1409: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;

1405:
1406: /* Get the payment details from the vendor as it has been not defined for the site */
1407: ln_terms_id := r_po_vendors.terms_id;
1408: -- lv_payment_method_lookup_code := r_po_vendors.payment_method_lookup_code; --commented by Sanjikum for Bug#4482462
1409: lv_pay_group_lookup_code := r_po_vendors.pay_group_lookup_code;
1410:
1411: end if;
1412:
1413: