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.5.12010000.3 2008/11/25 11:03:56 mbremkum 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.5.12010000.3 2008/11/25 11:03:56 mbremkum 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 111: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_invoice', 'START'); /* 1 */

107:
108:
109: begin
110:
111: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_invoice', 'START'); /* 1 */
112: /* Check if defaulting can happen for the invoice */
113:
114: validate_status_for_default
115: (

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

384: lv_tds_process_status varchar2(1);
385:
386: begin
387:
388: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.validate_status_for_default', 'START'); /* 1 */
389: open c_check_tds_already_processed(p_invoice_id,'P');--rchandan for bug#4428980
390: fetch c_check_tds_already_processed into lv_tds_process_status;
391: close c_check_tds_already_processed;
392:

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

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

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

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

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

643:
644: begin
645:
646: /* Check from setup for vendor and site */
647: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.default_tds_from_setup', 'START'); /* 1 */
648: p_default_from := 'Vendor Site Setup';
649: open c_ja_in_vendor_tds_info_hdr(p_vendor_id, p_vendor_site_id);
650: fetch c_ja_in_vendor_tds_info_hdr into crec_ja_in_vendor_tds_info_hdr;
651: close c_ja_in_vendor_tds_info_hdr;

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

737: lv_check_section_applicable varchar2(1);
738:
739: begin
740:
741: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.validate_default_tds', 'START'); /* 1 */
742: open c_ja_in_vendor_tds_info_hdr(p_vendor_id, p_vendor_site_id);
743: fetch c_ja_in_vendor_tds_info_hdr into lv_confirm_pan_flag;
744: close c_ja_in_vendor_tds_info_hdr;
745:

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

843: ln_check_if_tax_is_input :=0;
844: lv_consider_for_redefault := 'N';
845: lv_user_deleted_tax_flag := 'N';
846:
847: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.populate_localization_inv_tax', 'START'); /* 2 */
848:
849: ln_default_tax_id := p_default_tax_id;
850: ln_actual_tax_id := to_number(p_input_dff_value);
851:

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

1195:
1196:
1197: begin
1198:
1199: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.get_default_tax_from_section', 'START'); /* 1 */
1200:
1201: ln_amount := p_amount * nvl(p_exchange_rate, 1);
1202:
1203:

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

1356:
1357: begin
1358:
1359: p_codepath :=
1360: jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_tax_defaultation.process_input_dff_tds', 'START'); /* 1 */
1361:
1362: p_output_tds_dff_value := p_input_tds_dff_value;
1363:
1364: open c_get_existing_dff_values(p_invoice_id, p_invoice_line_number, p_invoice_distribution_id,'TDS_SECTION');--rchandan for bug#4428980

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

1400:
1401: exception
1402: when others then
1403: p_process_flag := 'E';
1404: P_process_message := 'Error from jai_ap_tds_tax_defaultation.process_input_dff_tds :' || sqlerrm;
1405: return;
1406: end process_input_dff_tds;
1407:
1408: /* ********************************************* process_input_dff_tds ********************************************* */

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

1445:
1446: exception
1447: when others then
1448: p_process_flag := 'E';
1449: P_process_message := 'Error from jai_ap_tds_tax_defaultation.process_delete :' || sqlerrm;
1450: return;
1451: end process_delete;
1452:
1453: /* ********************************************* process_delete ********************************************* */

Line 1510: END jai_ap_tds_tax_defaultation;

1506:
1507:
1508: /* ********************************************* check_old_transaction ********************************************* */
1509:
1510: END jai_ap_tds_tax_defaultation;