APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on RCV_TRANSACTIONS

Line 519: cursor c_rcv_transactions(p_rcv_transaction_id number) is

515: p_codepath in out nocopy varchar2
516: )
517: is
518:
519: cursor c_rcv_transactions(p_rcv_transaction_id number) is
520: select shipment_header_id,
521: shipment_line_id
522: from rcv_transactions
523: where transaction_id = p_rcv_transaction_id;

Line 522: from rcv_transactions

518:
519: cursor c_rcv_transactions(p_rcv_transaction_id number) is
520: select shipment_header_id,
521: shipment_line_id
522: from rcv_transactions
523: where transaction_id = p_rcv_transaction_id;
524:
525: 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
526: select jtc.section_code section_code,

Line 537: c_rec_rcv_transactions c_rcv_transactions%rowtype;

533: and jrtl.shipment_header_id = p_shipment_header_id
534: and jrtl.shipment_line_id = p_shipment_line_id
535: order by jrtl.tax_line_no asc;
536:
537: c_rec_rcv_transactions c_rcv_transactions%rowtype;
538: c_rec_check_receipt_tds_tax c_check_receipt_tds_tax%rowtype;
539:
540: begin
541:

Line 544: open c_rcv_transactions(p_rcv_transaction_id);

540: begin
541:
542: /* Get Receipt Details */
543: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */
544: open c_rcv_transactions(p_rcv_transaction_id);
545: fetch c_rcv_transactions into c_rec_rcv_transactions;
546: close c_rcv_transactions;
547:
548: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 545: fetch c_rcv_transactions into c_rec_rcv_transactions;

541:
542: /* Get Receipt Details */
543: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */
544: open c_rcv_transactions(p_rcv_transaction_id);
545: fetch c_rcv_transactions into c_rec_rcv_transactions;
546: close c_rcv_transactions;
547:
548: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
549: /* Check if TDS type of tax exists against the shipment line in Receipt taxes */

Line 546: close c_rcv_transactions;

542: /* Get Receipt Details */
543: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */
544: open c_rcv_transactions(p_rcv_transaction_id);
545: fetch c_rcv_transactions into c_rec_rcv_transactions;
546: close c_rcv_transactions;
547:
548: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
549: /* Check if TDS type of tax exists against the shipment line in Receipt taxes */
550: open c_check_receipt_tds_tax

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

547:
548: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
549: /* Check if TDS type of tax exists against the shipment line in Receipt taxes */
550: open c_check_receipt_tds_tax
551: (c_rec_rcv_transactions.shipment_header_id, c_rec_rcv_transactions.shipment_line_id,'TDS_SECTION');--rchandan for bug#4428980
552: fetch c_check_receipt_tds_tax into c_rec_check_receipt_tds_tax;
553: close c_check_receipt_tds_tax;
554:
555: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */