APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on PO_DISTRIBUTIONS_ALL

Line 600: cursor c_po_distributions_all(p_po_distribution_id number) is

596: p_codepath in out nocopy varchar2
597: )
598: is
599:
600: cursor c_po_distributions_all(p_po_distribution_id number) is
601: select po_header_id,
602: po_line_id,
603: line_location_id
604: from po_distributions_all

Line 604: from po_distributions_all

600: cursor c_po_distributions_all(p_po_distribution_id number) is
601: select po_header_id,
602: po_line_id,
603: line_location_id
604: from po_distributions_all
605: where po_distribution_id = p_po_distribution_id;
606:
607:
608: cursor c_po_taxes(p_po_header_id number, p_po_line_id number, p_line_location_id number,p_section_type jai_cmn_taxes_all.section_type%type)--rchandan for bug#4428980

Line 623: c_rec_po_distributions_all c_po_distributions_all%rowtype;

619: and jtc.section_type = p_section_type--rchandan for bug#4428980
620: order by jpllt.tax_line_no asc;
621:
622:
623: c_rec_po_distributions_all c_po_distributions_all%rowtype;
624: lv_last_section_type JAI_CMN_TAXES_ALL.section_type%type;
625: c_rec_po_taxes c_po_taxes%rowtype;
626:
627: begin

Line 630: open c_po_distributions_all(p_po_distribution_id);

626:
627: begin
628:
629: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */
630: open c_po_distributions_all(p_po_distribution_id);
631: fetch c_po_distributions_all into c_rec_po_distributions_all;
632: close c_po_distributions_all;
633:
634: /* Check if TDS type of tax exists against if PO taxes */

Line 631: fetch c_po_distributions_all into c_rec_po_distributions_all;

627: begin
628:
629: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */
630: open c_po_distributions_all(p_po_distribution_id);
631: fetch c_po_distributions_all into c_rec_po_distributions_all;
632: close c_po_distributions_all;
633:
634: /* Check if TDS type of tax exists against if PO taxes */
635: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 632: close c_po_distributions_all;

628:
629: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */
630: open c_po_distributions_all(p_po_distribution_id);
631: fetch c_po_distributions_all into c_rec_po_distributions_all;
632: close c_po_distributions_all;
633:
634: /* Check if TDS type of tax exists against if PO taxes */
635: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
636: open c_po_taxes

Line 638: c_rec_po_distributions_all.po_header_id,

634: /* Check if TDS type of tax exists against if PO taxes */
635: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
636: open c_po_taxes
637: (
638: c_rec_po_distributions_all.po_header_id,
639: c_rec_po_distributions_all.po_line_id,
640: c_rec_po_distributions_all.line_location_id,
641: 'TDS_SECTION' --rchandan for bug#4428980
642: );

Line 639: c_rec_po_distributions_all.po_line_id,

635: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
636: open c_po_taxes
637: (
638: c_rec_po_distributions_all.po_header_id,
639: c_rec_po_distributions_all.po_line_id,
640: c_rec_po_distributions_all.line_location_id,
641: 'TDS_SECTION' --rchandan for bug#4428980
642: );
643: fetch c_po_taxes into c_rec_po_taxes;

Line 640: c_rec_po_distributions_all.line_location_id,

636: open c_po_taxes
637: (
638: c_rec_po_distributions_all.po_header_id,
639: c_rec_po_distributions_all.po_line_id,
640: c_rec_po_distributions_all.line_location_id,
641: 'TDS_SECTION' --rchandan for bug#4428980
642: );
643: fetch c_po_taxes into c_rec_po_taxes;
644: close c_po_taxes;