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_PREPAYMENTS_PKG dependencies on AP_INVOICES_ALL

Line 315: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;

311: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
312: r_tds_details_apply c_tds_details_apply%rowtype;
313: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
314:
315: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
316: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
317: ln_threshold_trx_id_apply number;
318: ln_threshold_trx_id_tds number;
319: ln_threshold_trx_id_wct number;

Line 316: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;

312: r_tds_details_apply c_tds_details_apply%rowtype;
313: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
314:
315: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
316: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
317: ln_threshold_trx_id_apply number;
318: ln_threshold_trx_id_tds number;
319: ln_threshold_trx_id_wct number;
320: ln_threshold_trx_id_essi number;

Line 326: lv_invoice_num_to_tds_apply ap_invoices_all.invoice_num%type;

322: ln_exchange_rate number;
323: ln_tax_id number;
324: ln_threshold_grp_id number;
325: ln_threshold_grp_audit_id number;
326: lv_invoice_num_to_tds_apply ap_invoices_all.invoice_num%type;
327: lv_invoice_num_to_vendor_apply ap_invoices_all.invoice_num%type;
328:
329: begin
330: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */

Line 327: lv_invoice_num_to_vendor_apply ap_invoices_all.invoice_num%type;

323: ln_tax_id number;
324: ln_threshold_grp_id number;
325: ln_threshold_grp_audit_id number;
326: lv_invoice_num_to_tds_apply ap_invoices_all.invoice_num%type;
327: lv_invoice_num_to_vendor_apply ap_invoices_all.invoice_num%type;
328:
329: begin
330: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
331:

Line 980: cursor c_ap_invoices_all (p_invoice_distribution_id number) is

976: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
977: from jai_ap_tds_thhold_grps
978: where threshold_grp_id = p_threshold_grp_id;
979:
980: cursor c_ap_invoices_all (p_invoice_distribution_id number) is
981: select invoice_num
982: from ap_invoices_all
983: where invoice_id in
984: ( select invoice_id

Line 982: from ap_invoices_all

978: where threshold_grp_id = p_threshold_grp_id;
979:
980: cursor c_ap_invoices_all (p_invoice_distribution_id number) is
981: select invoice_num
982: from ap_invoices_all
983: where invoice_id in
984: ( select invoice_id
985: from jai_ap_tds_inv_taxes /* ap_invoice_distributions not used for mutation problem */
986: where invoice_distribution_id = p_invoice_distribution_id);

Line 1036: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;

1032: ln_total_tds_amount number;
1033: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;
1034: ln_prepay_tax_id number;
1035:
1036: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
1037: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
1038: lv_invoice_num_prepay_apply ap_invoices_all.invoice_num%type;
1039: ln_threshold_trx_id_tds number;
1040: ln_threshold_trx_id_wct number;

Line 1037: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;

1033: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;
1034: ln_prepay_tax_id number;
1035:
1036: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
1037: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
1038: lv_invoice_num_prepay_apply ap_invoices_all.invoice_num%type;
1039: ln_threshold_trx_id_tds number;
1040: ln_threshold_trx_id_wct number;
1041: ln_threshold_trx_id_essi number;

Line 1038: lv_invoice_num_prepay_apply ap_invoices_all.invoice_num%type;

1034: ln_prepay_tax_id number;
1035:
1036: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
1037: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
1038: lv_invoice_num_prepay_apply ap_invoices_all.invoice_num%type;
1039: ln_threshold_trx_id_tds number;
1040: ln_threshold_trx_id_wct number;
1041: ln_threshold_trx_id_essi number;
1042: ln_start_threshold_trx_id number;

Line 1312: open c_ap_invoices_all(p_invoice_distribution_id);

1308: or else against the standard invoice */
1309:
1310: if lv_application_basis = 'STANDARD INVOICE' then
1311: /* get the standard invoice number */
1312: open c_ap_invoices_all(p_invoice_distribution_id);
1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1314: close c_ap_invoices_all;
1315: else
1316: /* Get the prepayment number */

Line 1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;

1309:
1310: if lv_application_basis = 'STANDARD INVOICE' then
1311: /* get the standard invoice number */
1312: open c_ap_invoices_all(p_invoice_distribution_id);
1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1314: close c_ap_invoices_all;
1315: else
1316: /* Get the prepayment number */
1317: open c_ap_invoices_all(p_prepay_distribution_id);

Line 1314: close c_ap_invoices_all;

1310: if lv_application_basis = 'STANDARD INVOICE' then
1311: /* get the standard invoice number */
1312: open c_ap_invoices_all(p_invoice_distribution_id);
1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1314: close c_ap_invoices_all;
1315: else
1316: /* Get the prepayment number */
1317: open c_ap_invoices_all(p_prepay_distribution_id);
1318: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;

Line 1317: open c_ap_invoices_all(p_prepay_distribution_id);

1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1314: close c_ap_invoices_all;
1315: else
1316: /* Get the prepayment number */
1317: open c_ap_invoices_all(p_prepay_distribution_id);
1318: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1319: close c_ap_invoices_all;
1320: end if;
1321:

Line 1318: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;

1314: close c_ap_invoices_all;
1315: else
1316: /* Get the prepayment number */
1317: open c_ap_invoices_all(p_prepay_distribution_id);
1318: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1319: close c_ap_invoices_all;
1320: end if;
1321:
1322: jai_ap_tds_generation_pkg.generate_tds_invoices

Line 1319: close c_ap_invoices_all;

1315: else
1316: /* Get the prepayment number */
1317: open c_ap_invoices_all(p_prepay_distribution_id);
1318: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1319: close c_ap_invoices_all;
1320: end if;
1321:
1322: jai_ap_tds_generation_pkg.generate_tds_invoices
1323: (