APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on RCV_TRANSACTIONS

Line 466: cursor c_rcv_transactions(p_rcv_transaction_id number) is

462: p_codepath in out nocopy varchar2
463: )
464: is
465:
466: cursor c_rcv_transactions(p_rcv_transaction_id number) is
467: select shipment_header_id,
468: shipment_line_id
469: from rcv_transactions
470: where transaction_id = p_rcv_transaction_id;

Line 469: from rcv_transactions

465:
466: cursor c_rcv_transactions(p_rcv_transaction_id number) is
467: select shipment_header_id,
468: shipment_line_id
469: from rcv_transactions
470: where transaction_id = p_rcv_transaction_id;
471:
472: cursor c_check_receipt_tds_tax(p_shipment_header_id number, p_shipment_line_id number,p_section_type jai_cmn_taxes_all.section_type%type) is--rchandan for bug#4428980
473: select jtc.section_code section_code,

Line 484: c_rec_rcv_transactions c_rcv_transactions%rowtype;

480: and jrtl.shipment_header_id = p_shipment_header_id
481: and jrtl.shipment_line_id = p_shipment_line_id
482: order by jrtl.tax_line_no asc;
483:
484: c_rec_rcv_transactions c_rcv_transactions%rowtype;
485: c_rec_check_receipt_tds_tax c_check_receipt_tds_tax%rowtype;
486:
487: begin
488:

Line 491: open c_rcv_transactions(p_rcv_transaction_id);

487: begin
488:
489: /* Get Receipt Details */
490: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */
491: open c_rcv_transactions(p_rcv_transaction_id);
492: fetch c_rcv_transactions into c_rec_rcv_transactions;
493: close c_rcv_transactions;
494:
495: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 492: fetch c_rcv_transactions into c_rec_rcv_transactions;

488:
489: /* Get Receipt Details */
490: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */
491: open c_rcv_transactions(p_rcv_transaction_id);
492: fetch c_rcv_transactions into c_rec_rcv_transactions;
493: close c_rcv_transactions;
494:
495: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
496: /* Check if TDS type of tax exists against the shipment line in Receipt taxes */

Line 493: close c_rcv_transactions;

489: /* Get Receipt Details */
490: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */
491: open c_rcv_transactions(p_rcv_transaction_id);
492: fetch c_rcv_transactions into c_rec_rcv_transactions;
493: close c_rcv_transactions;
494:
495: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
496: /* Check if TDS type of tax exists against the shipment line in Receipt taxes */
497: open c_check_receipt_tds_tax

Line 498: (c_rec_rcv_transactions.shipment_header_id, c_rec_rcv_transactions.shipment_line_id,'TDS_SECTION');--rchandan for bug#4428980

494:
495: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
496: /* Check if TDS type of tax exists against the shipment line in Receipt taxes */
497: open c_check_receipt_tds_tax
498: (c_rec_rcv_transactions.shipment_header_id, c_rec_rcv_transactions.shipment_line_id,'TDS_SECTION');--rchandan for bug#4428980
499: fetch c_check_receipt_tds_tax into c_rec_check_receipt_tds_tax;
500: close c_check_receipt_tds_tax;
501:
502: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */