eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_DTC_PREPAYMENTS_PKG dependencies on JAI_AP_DTC_GENERATION_PKG

Line 555: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

551: EXIT WHEN c_tds_details_apply%NOTFOUND ;
552:
553: ln_temp_threshold_grp_id := r_tds_details_apply.tds_threshold_grp_id;
554: /*Updated by Wenqiong for bug 13359892
555: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
556: --jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
557: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
558: p_invoice_id => p_invoice_id,
559: p_prepay_distribution_id => p_prepay_distribution_id,

Line 556: --jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

552:
553: ln_temp_threshold_grp_id := r_tds_details_apply.tds_threshold_grp_id;
554: /*Updated by Wenqiong for bug 13359892
555: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
556: --jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
557: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
558: p_invoice_id => p_invoice_id,
559: p_prepay_distribution_id => p_prepay_distribution_id,
560: p_threshold_grp_id => ln_temp_threshold_grp_id,

Line 557: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

553: ln_temp_threshold_grp_id := r_tds_details_apply.tds_threshold_grp_id;
554: /*Updated by Wenqiong for bug 13359892
555: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
556: --jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
557: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
558: p_invoice_id => p_invoice_id,
559: p_prepay_distribution_id => p_prepay_distribution_id,
560: p_threshold_grp_id => ln_temp_threshold_grp_id,
561: p_threshold_hdr_id => ln_temp_threshold_hdr_id,

Line 575: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

571:
572:
573: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
574: /*Updated by Wenqiong for bug 13359892
575: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
576: --jai_ap_tds_generation_pkg.maintain_thhold_grps
577: jai_ap_dtc_generation_pkg.maintain_thhold_grps
578: (
579: p_threshold_grp_id => ln_threshold_grp_id,

Line 577: jai_ap_dtc_generation_pkg.maintain_thhold_grps

573: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
574: /*Updated by Wenqiong for bug 13359892
575: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
576: --jai_ap_tds_generation_pkg.maintain_thhold_grps
577: jai_ap_dtc_generation_pkg.maintain_thhold_grps
578: (
579: p_threshold_grp_id => ln_threshold_grp_id,
580: p_trx_invoice_unapply_amount => r_tds_details_apply.tds_taxable_basis,/*5751783*/
581: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 620: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

616: * Changed from p_invoice_id to ln_parent_pp_invoice_id ie,
617: * invoice_id of the prepayment application.
618: */
619: /*Updated by Wenqiong for bug 13359892
620: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
621: ln_tax_category_id := r_tds_details_apply.tax_category_id;
622: lv_section_code := r_tds_details_apply.section_code;
623: ln_tot_tds_amt := r_tds_details_apply.tds_amount;--Update to function tds amount for bug13833254 .
624: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));

Line 624: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));

620: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
621: ln_tax_category_id := r_tds_details_apply.tax_category_id;
622: lv_section_code := r_tds_details_apply.section_code;
623: ln_tot_tds_amt := r_tds_details_apply.tds_amount;--Update to function tds amount for bug13833254 .
624: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));
625:
626:
627: --jai_ap_tds_generation_pkg.generate_tds_invoices
628: jai_ap_dtc_generation_pkg.generate_dtc_invoices

Line 628: jai_ap_dtc_generation_pkg.generate_dtc_invoices

624: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));
625:
626:
627: --jai_ap_tds_generation_pkg.generate_tds_invoices
628: jai_ap_dtc_generation_pkg.generate_dtc_invoices
629: (
630: pn_invoice_id => ln_parent_pp_invoice_id ,
631: pn_invoice_distribution_id => p_invoice_distribution_id ,
632: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 670: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

666:
667: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
668: if p_event = 'INSERT' then /*Added for Bug 8431516*/
669: /*Updated by Wenqiong for bug 13359892
670: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
671: --jai_ap_tds_generation_pkg.maintain_thhold_grps
672: jai_ap_dtc_generation_pkg.maintain_thhold_grps
673: (
674: p_threshold_grp_id => ln_threshold_grp_id,

Line 672: jai_ap_dtc_generation_pkg.maintain_thhold_grps

668: if p_event = 'INSERT' then /*Added for Bug 8431516*/
669: /*Updated by Wenqiong for bug 13359892
670: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
671: --jai_ap_tds_generation_pkg.maintain_thhold_grps
672: jai_ap_dtc_generation_pkg.maintain_thhold_grps
673: (
674: p_threshold_grp_id => ln_threshold_grp_id,
675: --p_trx_tax_paid => r_get_total_prepayment_tax.tds_amount, --Commented by Zhiwei Hou for DTC enhancement Bug#13828149 on 20120312
676: p_trx_tax_paid => ln_tot_tds_amt,--Added by Zhiwei Hou for DTC enhancement Bug#13828149 on 20120312

Line 740: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

736: * Store the current Threshold slab and type
737: * After PP Unapplication
738: */
739: /*Updated by Wenqiong for bug 13359892
740: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
741: --jai_ap_tds_generation_pkg.get_tds_threshold_slab(
742: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
743: p_invoice_id => p_invoice_id,
744: p_prepay_distribution_id => p_prepay_distribution_id,

Line 742: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

738: */
739: /*Updated by Wenqiong for bug 13359892
740: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
741: --jai_ap_tds_generation_pkg.get_tds_threshold_slab(
742: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
743: p_invoice_id => p_invoice_id,
744: p_prepay_distribution_id => p_prepay_distribution_id,
745: p_threshold_grp_id => ln_temp_threshold_grp_id,
746: p_threshold_hdr_id => ln_temp_threshold_hdr_id,

Line 767: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

763: lv_slab_transition_tds_event :=
764: 'THRESHOLD TRANSITION-PPUA(from slab id -' || ln_threshold_slab_id ||
765: 'to slab id - ' || ln_after_threshold_slab_id || ')';
766: /*Updated by Wenqiong for bug 13359892
767: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
768: --jai_ap_tds_generation_pkg.process_threshold_transition
769: jai_ap_dtc_generation_pkg.process_threshold_transition
770: (
771: p_threshold_grp_id => ln_temp_threshold_grp_id,

Line 769: jai_ap_dtc_generation_pkg.process_threshold_transition

765: 'to slab id - ' || ln_after_threshold_slab_id || ')';
766: /*Updated by Wenqiong for bug 13359892
767: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
768: --jai_ap_tds_generation_pkg.process_threshold_transition
769: jai_ap_dtc_generation_pkg.process_threshold_transition
770: (
771: p_threshold_grp_id => ln_temp_threshold_grp_id,
772: p_threshold_slab_id => ln_after_threshold_slab_id,
773: p_invoice_id => ln_parent_pp_invoice_id,

Line 836: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

832: * Changed from p_invoice_id to ln_parent_pp_invoice_id ie,
833: * invoice_id of the prepayment application.
834: */
835: /*Updated by Wenqiong for bug 13359892
836: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
837: ln_tax_category_id := r_wct_details_apply.tax_category_id;
838: lv_section_code := r_wct_details_apply.section_code;
839: ln_tot_tds_amt := r_wct_details_apply.wct_amount;
840: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));

Line 840: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));

836: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
837: ln_tax_category_id := r_wct_details_apply.tax_category_id;
838: lv_section_code := r_wct_details_apply.section_code;
839: ln_tot_tds_amt := r_wct_details_apply.wct_amount;
840: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));
841:
842: --jai_ap_tds_generation_pkg.generate_tds_invoices
843: jai_ap_dtc_generation_pkg.generate_dtc_invoices
844: (

Line 843: jai_ap_dtc_generation_pkg.generate_dtc_invoices

839: ln_tot_tds_amt := r_wct_details_apply.wct_amount;
840: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));
841:
842: --jai_ap_tds_generation_pkg.generate_tds_invoices
843: jai_ap_dtc_generation_pkg.generate_dtc_invoices
844: (
845: pn_invoice_id => ln_parent_pp_invoice_id ,
846: pn_invoice_distribution_id => p_invoice_distribution_id ,
847: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 927: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

923: * Changed from p_invoice_id to ln_parent_pp_invoice_id ie,
924: * invoice_id of the prepayment application.
925: */
926: /*Updated by Wenqiong for bug 13359892
927: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
928:
929: ln_tax_category_id := r_essi_details_apply.tax_category_id;
930: lv_section_code := r_essi_details_apply.section_code;
931: ln_tot_tds_amt := r_essi_details_apply.essi_amount;

Line 932: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));

928:
929: ln_tax_category_id := r_essi_details_apply.tax_category_id;
930: lv_section_code := r_essi_details_apply.section_code;
931: ln_tot_tds_amt := r_essi_details_apply.essi_amount;
932: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));
933:
934: --jai_ap_tds_generation_pkg.generate_tds_invoices
935: jai_ap_dtc_generation_pkg.generate_dtc_invoices
936: (

Line 935: jai_ap_dtc_generation_pkg.generate_dtc_invoices

931: ln_tot_tds_amt := r_essi_details_apply.essi_amount;
932: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_pp_invoice_id));
933:
934: --jai_ap_tds_generation_pkg.generate_tds_invoices
935: jai_ap_dtc_generation_pkg.generate_dtc_invoices
936: (
937: pn_invoice_id => ln_parent_pp_invoice_id ,
938: pn_invoice_distribution_id => p_invoice_distribution_id ,
939: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 999: Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg /

995: where invoice_id = p_invoice_id;
996:
997: if ln_start_threshold_trx_id is not null then
998: /*Updated by Wenqiong for bug 13359892
999: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
1000: --jai_ap_tds_generation_pkg.import_and_approve
1001: jai_ap_dtc_generation_pkg.import_and_approve
1002: (
1003: p_invoice_id => ln_parent_pp_invoice_id, /*Bug 5751783*/

Line 1001: jai_ap_dtc_generation_pkg.import_and_approve

997: if ln_start_threshold_trx_id is not null then
998: /*Updated by Wenqiong for bug 13359892
999: *Changed the package jai_ap_tds_generation_pkg to jai_ap_dtc_generation_pkg */
1000: --jai_ap_tds_generation_pkg.import_and_approve
1001: jai_ap_dtc_generation_pkg.import_and_approve
1002: (
1003: p_invoice_id => ln_parent_pp_invoice_id, /*Bug 5751783*/
1004: p_start_thhold_trx_id => ln_start_threshold_trx_id,
1005: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 3422: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

3418:
3419: --Added by Chong.Lei for bug#13802244 begin
3420: -----------------------------------------------------------------------------------------------------
3421: --Call to procedure - get_tds_threshold_slab, Store the current Threshold slab and type before PP application
3422: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
3423: p_invoice_id => p_invoice_id, -- added by Chong.lei for DTC #13359892 20120206
3424: p_prepay_distribution_id => p_prepay_distribution_id,
3425: p_threshold_grp_id => ln_si_thgrp_id,
3426: p_threshold_hdr_id => ln_temp_threshold_hdr_id,

Line 3439: jai_ap_dtc_generation_pkg.maintain_thhold_grps(

3435: END IF;
3436: -----------------------------------------------------------------------------------------------------
3437: --Added by Chong.Lei for bug#13802244 begin
3438:
3439: jai_ap_dtc_generation_pkg.maintain_thhold_grps(
3440: p_threshold_grp_id => ln_si_thgrp_id,
3441: p_trx_invoice_apply_amount => r_get_tax_sec_det.application_amount,
3442: p_tds_event => 'PREPAYMENT APPLICATION',
3443: p_invoice_id => p_invoice_id,

Line 3525: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

3521: ln_threshold_grp_id := ln_temp_threshold_grp_id;
3522:
3523: /* --Commented by Chong for issue120920-66 2012/10/09
3524: --Call to procedure - get_tds_threshold_slab, Store the current Threshold slab and type before PP application
3525: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
3526: p_invoice_id => p_invoice_id, -- added by Chong.lei for DTC #13359892 20120206
3527: p_prepay_distribution_id => p_prepay_distribution_id,
3528: p_threshold_grp_id => ln_temp_threshold_grp_id,
3529: p_threshold_hdr_id => ln_temp_threshold_hdr_id,

Line 3544: jai_ap_dtc_generation_pkg.maintain_thhold_grps

3540:
3541: if r_get_total_prepayment_tax.tds_amount > 0 THEN
3542: /* --Commented by Chong for issue120920-66 2012/10/09
3543: \* update the threshold with the tds amount that will be impacted because of this application *\
3544: jai_ap_dtc_generation_pkg.maintain_thhold_grps
3545: (
3546: p_threshold_grp_id => ln_threshold_grp_id,
3547: p_trx_invoice_apply_amount => get_si_det.tds_taxable_basis,
3548: p_tds_event => 'PREPAYMENT APPLICATION',

Line 3612: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

3608: end if ;
3609:
3610:
3611: --Call to procedure - get_tds_threshold_slab. Store the current Threshold slab and type After PP application
3612: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
3613: p_invoice_id => p_invoice_id, -- added by Chong.lei for DTC #13359892 20120206
3614: p_prepay_distribution_id => p_prepay_distribution_id,
3615: p_threshold_grp_id => ln_temp_threshold_grp_id,
3616: p_threshold_hdr_id => ln_temp_threshold_hdr_id,

Line 3666: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));

3662: ln_tax_category_id := r_get_tds_group_amt.tax_category_id;
3663: --Added by Wenqiong for bug13787605 end
3664: ln_tot_appln_amt := r_get_tds_group_amt.amount;
3665: ln_tot_tds_amt := r_get_tds_group_amt.tds_amount;
3666: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));
3667:
3668: if p_event = 'INSERT' then
3669:
3670: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@@@in loop generate_dtc_invoices lv_invoice_num_prepay_apply: '|| lv_invoice_num_prepay_apply);

Line 3672: jai_ap_dtc_generation_pkg.generate_dtc_invoices

3668: if p_event = 'INSERT' then
3669:
3670: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@@@in loop generate_dtc_invoices lv_invoice_num_prepay_apply: '|| lv_invoice_num_prepay_apply);
3671:
3672: jai_ap_dtc_generation_pkg.generate_dtc_invoices
3673: (
3674: pn_invoice_id => ln_parent_invoice_id ,
3675: pn_invoice_distribution_id => p_invoice_distribution_id ,
3676: pv_invoice_num_prepay_apply=> lv_invoice_num_prepay_apply ,

Line 3705: jai_ap_dtc_generation_pkg.maintain_thhold_grps

3701: ln_start_threshold_trx_id := ln_threshold_trx_id_tds;
3702: END IF ;
3703:
3704: /* Update the threshold group */
3705: jai_ap_dtc_generation_pkg.maintain_thhold_grps
3706: ( p_threshold_grp_id => ln_threshold_grp_id,
3707: p_trx_tax_paid => (-1 * ln_tot_tds_amt),
3708: p_tds_event => 'PREPAYMENT APPLICATION',
3709: p_invoice_id => p_invoice_id,

Line 3753: jai_ap_dtc_generation_pkg.process_threshold_rollback

3749: * Parent invoice_id should be depending on the TDS invoice
3750: * created.
3751: *\
3752:
3753: jai_ap_dtc_generation_pkg.process_threshold_rollback
3754: ( p_invoice_id => ln_parent_invoice_id,
3755: p_before_threshold_type => lv_threshold_type,
3756: p_after_threshold_type => lv_after_threshold_type,
3757: p_before_threshold_slab_id => ln_threshold_slab_id,

Line 3806: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(

3802: if p_event = 'INSERT' then
3803: ln_temp_threshold_grp_id := NVL(ln_temp_threshold_grp_id,ln_si_thgrp_id);
3804:
3805: --Call to procedure - get_tds_threshold_slab. Store the current Threshold slab and type After PP application
3806: jai_ap_dtc_generation_pkg.get_tds_threshold_slab(
3807: p_invoice_id => p_invoice_id, -- added by Chong.lei for DTC #13359892 20120206
3808: p_prepay_distribution_id => p_prepay_distribution_id,
3809: p_threshold_grp_id => ln_temp_threshold_grp_id,
3810: p_threshold_hdr_id => ln_temp_threshold_hdr_id,

Line 3827: jai_ap_dtc_generation_pkg.process_threshold_rollback

3823:
3824: ln_parent_invoice_id := p_invoice_id;
3825: END IF; /* ln_parent_invoice_id IS NULL THEN */
3826:
3827: jai_ap_dtc_generation_pkg.process_threshold_rollback
3828: ( p_invoice_id => ln_parent_invoice_id,
3829: p_before_threshold_type => lv_threshold_type,
3830: p_after_threshold_type => lv_after_threshold_type,
3831: p_before_threshold_slab_id => ln_threshold_slab_id,

Line 3886: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));

3882: --Added by Wenqiong for bug13787605 end
3883:
3884: ln_tot_appln_amt := r_get_wct_group_amt.amount;
3885: ln_tot_tds_amt := r_get_wct_group_amt.wct_amount;
3886: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));
3887: if p_event = 'INSERT' then
3888:
3889: jai_ap_dtc_generation_pkg.generate_dtc_invoices
3890: (

Line 3889: jai_ap_dtc_generation_pkg.generate_dtc_invoices

3885: ln_tot_tds_amt := r_get_wct_group_amt.wct_amount;
3886: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));
3887: if p_event = 'INSERT' then
3888:
3889: jai_ap_dtc_generation_pkg.generate_dtc_invoices
3890: (
3891: pn_invoice_id => ln_parent_invoice_id ,
3892: pn_invoice_distribution_id => p_invoice_distribution_id ,
3893: pv_invoice_num_prepay_apply=> lv_invoice_num_prepay_apply ,

Line 3967: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));

3963: --Added by Wenqiong for bug13787605 end
3964:
3965: ln_tot_appln_amt := r_get_essi_group_amt.amount;
3966: ln_tot_tds_amt := r_get_essi_group_amt.essi_amount;
3967: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));
3968: if p_event = 'INSERT' then
3969:
3970: jai_ap_dtc_generation_pkg.generate_dtc_invoices
3971: (

Line 3970: jai_ap_dtc_generation_pkg.generate_dtc_invoices

3966: ln_tot_tds_amt := r_get_essi_group_amt.essi_amount;
3967: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));
3968: if p_event = 'INSERT' then
3969:
3970: jai_ap_dtc_generation_pkg.generate_dtc_invoices
3971: (
3972: pn_invoice_id => ln_parent_invoice_id ,
3973: pn_invoice_distribution_id => p_invoice_distribution_id ,
3974: pv_invoice_num_prepay_apply=> lv_invoice_num_prepay_apply ,

Line 4024: jai_ap_dtc_generation_pkg.import_and_approve

4020: /*
4021: Records are inserted into AP Interface tables using Standard Invoice, but import_and_approve
4022: was called using the Prepayment Invoice ID. Hence wrong group_id was getting passed and no
4023: Invoices were getting improved*/
4024: jai_ap_dtc_generation_pkg.import_and_approve
4025: (
4026: p_invoice_id => ln_parent_invoice_id,
4027: p_start_thhold_trx_id => ln_start_threshold_trx_id,
4028: p_tds_event => 'PREPAYMENT APPLICATION',