DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AR_TCS_REP_PKG

Line 595: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

591: /*
592: || Insert repository reference for the document to be generated
593: */
594:
595: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
596: jai_ar_tcs_rep_pkg.insert_repository_references
597: ( p_regime_id => r_thhold_info.regime_id
598: , p_transaction_id => ln_transaction_id
599: , p_source_ref_document_id => r_ref_dtls.source_ref_document_id

Line 596: jai_ar_tcs_rep_pkg.insert_repository_references

592: || Insert repository reference for the document to be generated
593: */
594:
595: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
596: jai_ar_tcs_rep_pkg.insert_repository_references
597: ( p_regime_id => r_thhold_info.regime_id
598: , p_transaction_id => ln_transaction_id
599: , p_source_ref_document_id => r_ref_dtls.source_ref_document_id
600: , p_source_ref_document_type => r_ref_dtls.source_ref_document_type

Line 619: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);

615: , p_trx_ref_id => ln_trx_ref_id
616: , p_process_flag => p_process_flag
617: , p_process_message => p_process_message
618: );
619: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);
620: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
621:
622: if p_process_flag <> jai_constants.successful then
623: return;

Line 637: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

633: /*
634: Insert surcharge type of tax
635: */
636:
637: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
638: jai_ar_tcs_rep_pkg.insert_repository_taxes
639: (
640: p_trx_ref_id => ln_trx_ref_id
641: , p_tax_id => ln_surcharge_tax_id

Line 638: jai_ar_tcs_rep_pkg.insert_repository_taxes

634: Insert surcharge type of tax
635: */
636:
637: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
638: jai_ar_tcs_rep_pkg.insert_repository_taxes
639: (
640: p_trx_ref_id => ln_trx_ref_id
641: , p_tax_id => ln_surcharge_tax_id
642: , p_tax_type => jai_constants.tax_type_tcs_surcharge

Line 650: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

646: , p_currency_code => ln_currency_code
647: , p_process_flag => p_process_flag
648: , p_process_message => p_process_message
649: );
650: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
651: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
652:
653: if p_process_flag <> jai_constants.successful then
654: return;

Line 657: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

653: if p_process_flag <> jai_constants.successful then
654: return;
655: end if;
656:
657: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
658: /* Insert surcharge cess type of tax */
659: jai_ar_tcs_rep_pkg.insert_repository_taxes
660: (
661: p_trx_ref_id => ln_trx_ref_id

Line 659: jai_ar_tcs_rep_pkg.insert_repository_taxes

655: end if;
656:
657: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
658: /* Insert surcharge cess type of tax */
659: jai_ar_tcs_rep_pkg.insert_repository_taxes
660: (
661: p_trx_ref_id => ln_trx_ref_id
662: , p_tax_id => ln_surcharge_cess_tax_id
663: , p_tax_type => jai_constants.tax_type_tcs_cess

Line 671: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

667: , p_currency_code => ln_currency_code
668: , p_process_flag => p_process_flag
669: , p_process_message => p_process_message
670: );
671: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
672: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
673:
674: if p_process_flag <> jai_constants.successful then
675: return;

Line 680: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Secondary and higher Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

676: end if;
677:
678: -- start Bgowrava for forward porting bug#5989740
679:
680: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Secondary and higher Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
681: /* Insert surcharge cess type of tax */
682: jai_ar_tcs_rep_pkg.insert_repository_taxes
683: (
684: p_trx_ref_id => ln_trx_ref_id

Line 682: jai_ar_tcs_rep_pkg.insert_repository_taxes

678: -- start Bgowrava for forward porting bug#5989740
679:
680: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Secondary and higher Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
681: /* Insert surcharge cess type of tax */
682: jai_ar_tcs_rep_pkg.insert_repository_taxes
683: (
684: p_trx_ref_id => ln_trx_ref_id
685: , p_tax_id => ln_surcharge_cess_tax_id
686: , p_tax_type => jai_constants.tax_type_sh_tcs_edu_cess

Line 694: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

690: , p_currency_code => ln_currency_code
691: , p_process_flag => p_process_flag
692: , p_process_message => p_process_message
693: );
694: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
695: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);
696:
697: if p_process_flag <> jai_constants.successful then
698: return;

Line 705: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

701: -- end Bgowrava for forward porting bug#5989740
702:
703: /** Generate document */
704:
705: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
706:
707: /*
708: || Get Repository Reference for consolidated document record inserted above
709: */

Line 714: jai_ar_tcs_rep_pkg.generate_document

710: open c_get_ref_dtls (cp_trx_ref_id => ln_trx_ref_id) ;
711: fetch c_get_ref_dtls into r_ref_dtls;
712: close c_get_ref_dtls;
713:
714: jai_ar_tcs_rep_pkg.generate_document
715: ( p_rgm_ref => r_ref_dtls
716: , p_total_tax_amt => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt ) --Bgowrava for forward porting bug#5989740
717: , p_process_flag => p_process_flag
718: , p_process_message => p_process_message

Line 720: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);

716: , p_total_tax_amt => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt ) --Bgowrava for forward porting bug#5989740
717: , p_process_flag => p_process_flag
718: , p_process_message => p_process_message
719: );
720: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);
721: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
722:
723: if p_process_flag <> jai_constants.successful then
724: return;

Line 940: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id

936: if p_org_id is not null then
937: /** Fin_year is not given but org_id is available. Hence derive fin_year using org_id and trx_date */
938: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 begin
939: /*--Commented by Chong for DTC ER 2012/09/11 Get TCS calendar from regime start
940: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id
941: , cp_trx_date => p_source_trx_date
942: );
943: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;
944: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;*/

Line 943: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;

939: /*--Commented by Chong for DTC ER 2012/09/11 Get TCS calendar from regime start
940: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id
941: , cp_trx_date => p_source_trx_date
942: );
943: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;
944: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;*/
945: ln_fin_year := get_tcs_fin_year('TCS_CALENDAR','TCS', p_source_trx_date); ----Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime start
946: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
947:

Line 944: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;*/

940: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id
941: , cp_trx_date => p_source_trx_date
942: );
943: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;
944: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;*/
945: ln_fin_year := get_tcs_fin_year('TCS_CALENDAR','TCS', p_source_trx_date); ----Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime start
946: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
947:
948: else