DBA Data[Home] [Help]

APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_TAX_DEFAULTATION

Line 1: PACKAGE BODY jai_ap_tds_tax_defaultation AS

1: PACKAGE BODY jai_ap_tds_tax_defaultation AS
2: /* $Header: jai_ap_tds_dflt.plb 120.28.12020000.2 2012/07/16 11:23:08 nkodakan ship $ */
3:
4: /* ----------------------------------------------------------------------------
5: FILENAME : jai_ap_tds_tax_defaultation_pkg_b.sql

Line 5: FILENAME : jai_ap_tds_tax_defaultation_pkg_b.sql

1: PACKAGE BODY jai_ap_tds_tax_defaultation AS
2: /* $Header: jai_ap_tds_dflt.plb 120.28.12020000.2 2012/07/16 11:23:08 nkodakan ship $ */
3:
4: /* ----------------------------------------------------------------------------
5: FILENAME : jai_ap_tds_tax_defaultation_pkg_b.sql
6:
7: Created By : Aparajita
8:
9: Created Date : 24-dec-2004

Line 153: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_invoice', 'START'); /* 1 */

149:
150:
151: begin
152:
153: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_invoice', 'START'); /* 1 */
154: /* Check if defaulting can happen for the invoice */
155:
156: validate_status_for_default
157: (

Line 441: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.validate_status_for_default', 'START'); /* 1 */

437: lv_tds_process_status varchar2(1);
438:
439: begin
440:
441: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.validate_status_for_default', 'START'); /* 1 */
442: open c_check_tds_already_processed(p_invoice_id,'P');--rchandan for bug#4428980
443: fetch c_check_tds_already_processed into lv_tds_process_status;
444: close c_check_tds_already_processed;
445:

Line 543: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_receipt', 'START'); /* 1 */

539:
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:

Line 629: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_po', 'START'); /* 1 */

625: c_rec_po_taxes c_po_taxes%rowtype;
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:

Line 700: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_setup', 'START'); /* 1 */

696:
697: begin
698:
699: /* Check from setup for vendor and site */
700: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_setup', 'START'); /* 1 */
701: p_default_from := 'Vendor Site Setup';
702: open c_ja_in_vendor_tds_info_hdr(p_vendor_id, p_vendor_site_id);
703: fetch c_ja_in_vendor_tds_info_hdr into crec_ja_in_vendor_tds_info_hdr;
704: close c_ja_in_vendor_tds_info_hdr;

Line 794: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.validate_default_tds', 'START'); /* 1 */

790: lv_check_section_applicable varchar2(1);
791:
792: begin
793:
794: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.validate_default_tds', 'START'); /* 1 */
795: open c_ja_in_vendor_tds_info_hdr(p_vendor_id, p_vendor_site_id);
796: fetch c_ja_in_vendor_tds_info_hdr into lv_confirm_pan_flag;
797: close c_ja_in_vendor_tds_info_hdr;
798:

Line 1052: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.populate_localization_inv_tax', 'START'); /* 2 */

1048: ln_check_if_tax_is_input :=0;
1049: lv_consider_for_redefault := 'N';
1050: lv_user_deleted_tax_flag := 'N';
1051:
1052: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.populate_localization_inv_tax', 'START'); /* 2 */
1053:
1054: ln_default_tax_id := p_default_tax_id;
1055: ln_actual_tax_id := to_number(p_input_dff_value);
1056: ln_actual_dff_tax_id := 0; --Added by Bgowrava for Bug#5911913

Line 1495: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.get_default_tax_from_section', 'START'); /* 1 */

1491:
1492:
1493: begin
1494:
1495: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.get_default_tax_from_section', 'START'); /* 1 */
1496:
1497: ln_amount := p_amount * nvl(p_exchange_rate, 1);
1498:
1499:

Line 1662: jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_input_dff_tds', 'START'); /* 1 */

1658:
1659: begin
1660:
1661: p_codepath :=
1662: jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_input_dff_tds', 'START'); /* 1 */
1663:
1664: p_output_tds_dff_value := p_input_tds_dff_value;
1665:
1666: open c_get_existing_dff_values(p_invoice_id, p_invoice_line_number, p_invoice_distribution_id,'TDS_SECTION');--rchandan for bug#4428980

Line 1713: P_process_message := 'Error from jai_ap_tds_tax_defaultation.process_input_dff_tds :' || sqlerrm;

1709:
1710: exception
1711: when others then
1712: p_process_flag := 'E';
1713: P_process_message := 'Error from jai_ap_tds_tax_defaultation.process_input_dff_tds :' || sqlerrm;
1714: return;
1715: end process_input_dff_tds;
1716:
1717: /* ********************************************* process_input_dff_tds ********************************************* */

Line 1758: P_process_message := 'Error from jai_ap_tds_tax_defaultation.process_delete :' || sqlerrm;

1754:
1755: exception
1756: when others then
1757: p_process_flag := 'E';
1758: P_process_message := 'Error from jai_ap_tds_tax_defaultation.process_delete :' || sqlerrm;
1759: return;
1760: end process_delete;
1761:
1762: /* ********************************************* process_delete ********************************************* */

Line 1819: END jai_ap_tds_tax_defaultation;

1815:
1816:
1817: /* ********************************************* check_old_transaction ********************************************* */
1818:
1819: END jai_ap_tds_tax_defaultation;