APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on PO_DISTRIBUTIONS_ALL

Line 547: cursor c_po_distributions_all(p_po_distribution_id number) is

543: p_codepath in out nocopy varchar2
544: )
545: is
546:
547: cursor c_po_distributions_all(p_po_distribution_id number) is
548: select po_header_id,
549: po_line_id,
550: line_location_id
551: from po_distributions_all

Line 551: from po_distributions_all

547: cursor c_po_distributions_all(p_po_distribution_id number) is
548: select po_header_id,
549: po_line_id,
550: line_location_id
551: from po_distributions_all
552: where po_distribution_id = p_po_distribution_id;
553:
554:
555: 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 570: c_rec_po_distributions_all c_po_distributions_all%rowtype;

566: and jtc.section_type = p_section_type--rchandan for bug#4428980
567: order by jpllt.tax_line_no asc;
568:
569:
570: c_rec_po_distributions_all c_po_distributions_all%rowtype;
571: lv_last_section_type JAI_CMN_TAXES_ALL.section_type%type;
572: c_rec_po_taxes c_po_taxes%rowtype;
573:
574: begin

Line 577: open c_po_distributions_all(p_po_distribution_id);

573:
574: begin
575:
576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */
577: open c_po_distributions_all(p_po_distribution_id);
578: fetch c_po_distributions_all into c_rec_po_distributions_all;
579: close c_po_distributions_all;
580:
581: /* Check if TDS type of tax exists against if PO taxes */

Line 578: fetch c_po_distributions_all into c_rec_po_distributions_all;

574: begin
575:
576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */
577: open c_po_distributions_all(p_po_distribution_id);
578: fetch c_po_distributions_all into c_rec_po_distributions_all;
579: close c_po_distributions_all;
580:
581: /* Check if TDS type of tax exists against if PO taxes */
582: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 579: close c_po_distributions_all;

575:
576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */
577: open c_po_distributions_all(p_po_distribution_id);
578: fetch c_po_distributions_all into c_rec_po_distributions_all;
579: close c_po_distributions_all;
580:
581: /* Check if TDS type of tax exists against if PO taxes */
582: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
583: open c_po_taxes

Line 585: c_rec_po_distributions_all.po_header_id,

581: /* Check if TDS type of tax exists against if PO taxes */
582: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
583: open c_po_taxes
584: (
585: c_rec_po_distributions_all.po_header_id,
586: c_rec_po_distributions_all.po_line_id,
587: c_rec_po_distributions_all.line_location_id,
588: 'TDS_SECTION' --rchandan for bug#4428980
589: );

Line 586: c_rec_po_distributions_all.po_line_id,

582: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
583: open c_po_taxes
584: (
585: c_rec_po_distributions_all.po_header_id,
586: c_rec_po_distributions_all.po_line_id,
587: c_rec_po_distributions_all.line_location_id,
588: 'TDS_SECTION' --rchandan for bug#4428980
589: );
590: fetch c_po_taxes into c_rec_po_taxes;

Line 587: c_rec_po_distributions_all.line_location_id,

583: open c_po_taxes
584: (
585: c_rec_po_distributions_all.po_header_id,
586: c_rec_po_distributions_all.po_line_id,
587: c_rec_po_distributions_all.line_location_id,
588: 'TDS_SECTION' --rchandan for bug#4428980
589: );
590: fetch c_po_taxes into c_rec_po_taxes;
591: close c_po_taxes;