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_VENDOR_SITES_ALL

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 110: 1) Moved the Cursor - c_ja_in_tax_codes, up from below the cursor c_po_vendor_sites_all

106: In generate_tds_invoices procedure:
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:

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 965: po_vendor_sites_all b,

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
969: and b.vendor_id = c.vendor_id

Line 1969: cursor c_po_vendor_sites_all(cp_vendor_id number, cp_vendor_site_id number) is

1965: accts_pay_code_combination_id -- Bug 9759709
1966: from ap_invoices_all
1967: where invoice_id = cp_invoice_id;
1968:
1969: cursor c_po_vendor_sites_all(cp_vendor_id number, cp_vendor_site_id number) is
1970: select terms_id,
1971: --payment_method_lookup_code, --commented by Sanjikum for Bug#4482462
1972: pay_group_lookup_code
1973: from po_vendor_sites_all

Line 1973: from po_vendor_sites_all

1969: cursor c_po_vendor_sites_all(cp_vendor_id number, cp_vendor_site_id number) is
1970: select terms_id,
1971: --payment_method_lookup_code, --commented by Sanjikum for Bug#4482462
1972: pay_group_lookup_code
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

Line 2013: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;

2009: where invoice_id = p_invoice_id;
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:

Line 2102: || moved this up from the under the cursor - c_po_vendor_sites_all by Ramananda for Bug#4562793

2098: fetch c_ap_invoices_all into r_ap_invoices_all;
2099: close c_ap_invoices_all;
2100:
2101: /*
2102: || moved this up from the under the cursor - c_po_vendor_sites_all by Ramananda for Bug#4562793
2103: */
2104: open c_ja_in_tax_codes(pn_tax_id);
2105: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
2106: close c_ja_in_tax_codes;

Line 2117: || open c_po_vendor_sites_all(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_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
2119: */
2120: open c_po_vendor_sites_all(r_ja_in_tax_codes.vendor_id, r_ja_in_tax_codes.vendor_site_id);
2121: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;

Line 2120: open c_po_vendor_sites_all(r_ja_in_tax_codes.vendor_id, r_ja_in_tax_codes.vendor_site_id);

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
2119: */
2120: open c_po_vendor_sites_all(r_ja_in_tax_codes.vendor_id, r_ja_in_tax_codes.vendor_site_id);
2121: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;
2122: close c_po_vendor_sites_all;
2123:
2124: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);

Line 2121: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;

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
2119: */
2120: open c_po_vendor_sites_all(r_ja_in_tax_codes.vendor_id, r_ja_in_tax_codes.vendor_site_id);
2121: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;
2122: close c_po_vendor_sites_all;
2123:
2124: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);
2125: fetch c_gl_sets_of_books into r_gl_sets_of_books;

Line 2122: close c_po_vendor_sites_all;

2118: || Commented the above and added the below by sanjikum for Bug#4562793
2119: */
2120: open c_po_vendor_sites_all(r_ja_in_tax_codes.vendor_id, r_ja_in_tax_codes.vendor_site_id);
2121: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;
2122: close c_po_vendor_sites_all;
2123:
2124: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);
2125: fetch c_gl_sets_of_books into r_gl_sets_of_books;
2126: close c_gl_sets_of_books;

Line 2139: ln_terms_id := r_po_vendor_sites_all.terms_id;

2135: end if;
2136: /*Bug # 7410219 - End*/
2137:
2138: /* Get the payment details from the vendor site */
2139: ln_terms_id := r_po_vendor_sites_all.terms_id;
2140: -- lv_payment_method_lookup_code := r_po_vendor_sites_all.payment_method_lookup_code;--commented by Sanjikum for Bug#4482462
2141: lv_pay_group_lookup_code := r_po_vendor_sites_all.pay_group_lookup_code;
2142:
2143:

Line 2140: -- lv_payment_method_lookup_code := r_po_vendor_sites_all.payment_method_lookup_code;--commented by Sanjikum for Bug#4482462

2136: /*Bug # 7410219 - End*/
2137:
2138: /* Get the payment details from the vendor site */
2139: ln_terms_id := r_po_vendor_sites_all.terms_id;
2140: -- lv_payment_method_lookup_code := r_po_vendor_sites_all.payment_method_lookup_code;--commented by Sanjikum for Bug#4482462
2141: lv_pay_group_lookup_code := r_po_vendor_sites_all.pay_group_lookup_code;
2142:
2143:
2144: if (

Line 2141: lv_pay_group_lookup_code := r_po_vendor_sites_all.pay_group_lookup_code;

2137:
2138: /* Get the payment details from the vendor site */
2139: ln_terms_id := r_po_vendor_sites_all.terms_id;
2140: -- lv_payment_method_lookup_code := r_po_vendor_sites_all.payment_method_lookup_code;--commented by Sanjikum for Bug#4482462
2141: lv_pay_group_lookup_code := r_po_vendor_sites_all.pay_group_lookup_code;
2142:
2143:
2144: if (
2145: ln_terms_id is null or