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_TDS_POP_RPST_PKG dependencies on JAI_AP_TDS_REPO_LINES

Line 604: ,jai_ap_tds_repo_lines jatrl

600: And not exists ( --make sure under surcharge slab
601: Select 1
602: From jai_cmn_tax_ctg_lines jctcl
603: ,jai_cmn_taxes_all jcta
604: ,jai_ap_tds_repo_lines jatrl
605: Where jctcl.tax_id = jcta.tax_id
606: And jctcl.tax_category_id = jatr.tax_category_id
607: AND jatrl.invoice_id = jatr.invoice_id
608: AND jatrl.tax_id = jcta.tax_id

Line 618: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;

614: ln_proportion NUMBER;
615: ln_taxable_amount NUMBER;
616: ln_surcharge_tax_amount NUMBER;
617: ln_tax_rounding_rule NUMBER;
618: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;
619:
620: l_api_name CONSTANT VARCHAR2(50) := 'process_surcharge()';
621: BEGIN
622: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');

Line 627: UPDATE jai_ap_tds_repo_lines jatrl

623:
624:
625: IF pv_event = G_SURCHARGE_ROLLBACK THEN
626: --Process Surcharge rollback, mark all surcharge tax code to surcharge_rollback = 'Y'
627: UPDATE jai_ap_tds_repo_lines jatrl
628: SET jatrl.surcharge_rollback = G_Y
629: WHERE jatrl.tax_type= G_TDS_SURCHARGE
630: AND NVL(jatrl.surcharge_rollback, G_N) =G_N
631: AND EXISTS(

Line 644: r_jai_ap_tds_repo_lines := NULL;

640: --Process surcharge calculate
641: ln_proportion := 0;
642: ln_taxable_amount := pn_taxable_amount;
643: ln_surcharge_tax_amount := pn_tax_amount;
644: r_jai_ap_tds_repo_lines := NULL;
645: ln_tax_rounding_rule := jai_ap_dtc_generation_pkg.get_tax_rounding(pn_source_invoice_id);
646:
647: --Surcharge calculation, split surcharge amount into each invoice below surcharge slab.
648: FOR r_get_reocrds_nosur IN c_get_reocrds_nosur (pn_threshold_grp_id)

Line 653: r_jai_ap_tds_repo_lines.invoice_id := r_get_reocrds_nosur.invoice_id;

649: LOOP
650:
651: ln_proportion := r_get_reocrds_nosur.tds_inv_tax_amount / ln_taxable_amount;
652:
653: r_jai_ap_tds_repo_lines.invoice_id := r_get_reocrds_nosur.invoice_id;
654: r_jai_ap_tds_repo_lines.tax_id := pn_surcharge_tax_id;
655: --r_jai_ap_tds_repo_lines.tax_name := derive tax_name by tax_id (or have no need to save tax name here)
656: r_jai_ap_tds_repo_lines.tax_type := G_TDS_SURCHARGE;
657:

Line 654: r_jai_ap_tds_repo_lines.tax_id := pn_surcharge_tax_id;

650:
651: ln_proportion := r_get_reocrds_nosur.tds_inv_tax_amount / ln_taxable_amount;
652:
653: r_jai_ap_tds_repo_lines.invoice_id := r_get_reocrds_nosur.invoice_id;
654: r_jai_ap_tds_repo_lines.tax_id := pn_surcharge_tax_id;
655: --r_jai_ap_tds_repo_lines.tax_name := derive tax_name by tax_id (or have no need to save tax name here)
656: r_jai_ap_tds_repo_lines.tax_type := G_TDS_SURCHARGE;
657:
658: --calculate the proportion surcharge amount and round it by TDS rounding rule

Line 655: --r_jai_ap_tds_repo_lines.tax_name := derive tax_name by tax_id (or have no need to save tax name here)

651: ln_proportion := r_get_reocrds_nosur.tds_inv_tax_amount / ln_taxable_amount;
652:
653: r_jai_ap_tds_repo_lines.invoice_id := r_get_reocrds_nosur.invoice_id;
654: r_jai_ap_tds_repo_lines.tax_id := pn_surcharge_tax_id;
655: --r_jai_ap_tds_repo_lines.tax_name := derive tax_name by tax_id (or have no need to save tax name here)
656: r_jai_ap_tds_repo_lines.tax_type := G_TDS_SURCHARGE;
657:
658: --calculate the proportion surcharge amount and round it by TDS rounding rule
659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);

Line 656: r_jai_ap_tds_repo_lines.tax_type := G_TDS_SURCHARGE;

652:
653: r_jai_ap_tds_repo_lines.invoice_id := r_get_reocrds_nosur.invoice_id;
654: r_jai_ap_tds_repo_lines.tax_id := pn_surcharge_tax_id;
655: --r_jai_ap_tds_repo_lines.tax_name := derive tax_name by tax_id (or have no need to save tax name here)
656: r_jai_ap_tds_repo_lines.tax_type := G_TDS_SURCHARGE;
657:
658: --calculate the proportion surcharge amount and round it by TDS rounding rule
659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);
660:

Line 659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);

655: --r_jai_ap_tds_repo_lines.tax_name := derive tax_name by tax_id (or have no need to save tax name here)
656: r_jai_ap_tds_repo_lines.tax_type := G_TDS_SURCHARGE;
657:
658: --calculate the proportion surcharge amount and round it by TDS rounding rule
659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);
660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;

Line 661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;

657:
658: --calculate the proportion surcharge amount and round it by TDS rounding rule
659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);
660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;

Line 662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;

658: --calculate the proportion surcharge amount and round it by TDS rounding rule
659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);
660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:

Line 663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;

659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);
660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:
667: --Insert one repository line

Line 664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;

660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:
667: --Insert one repository line
668: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

Line 665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;

661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:
667: --Insert one repository line
668: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
669: END LOOP;

Line 668: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:
667: --Insert one repository line
668: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
669: END LOOP;
670: END IF;
671:
672:

Line 890: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;

886: r_chk_threshold_rollback c_chk_threshold_rollback%rowtype;
887: r_threshold_tran_inv c_threshold_tran_inv%rowtype;
888: r_tds_payment_check_id c_tds_payment_check_id%rowtype;
889: r_tax_rates c_tax_rates%rowtype;
890: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;
891: ln_transition_count NUMBER;
892: ln_tax_category_id NUMBER;
893:
894: ln_calculated_inv_amt NUMBER;

Line 2054: r_jai_ap_tds_repo_lines := NULL;

2050: )
2051: LOOP
2052: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type: ' ||r_c_get_taxes_info.tax_type || ' tax_id: ' || r_c_get_taxes_info.tax_id);
2053:
2054: r_jai_ap_tds_repo_lines := NULL;
2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;

Line 2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;

2051: LOOP
2052: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type: ' ||r_c_get_taxes_info.tax_type || ' tax_id: ' || r_c_get_taxes_info.tax_id);
2053:
2054: r_jai_ap_tds_repo_lines := NULL;
2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);

Line 2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;

2052: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type: ' ||r_c_get_taxes_info.tax_type || ' tax_id: ' || r_c_get_taxes_info.tax_id);
2053:
2054: r_jai_ap_tds_repo_lines := NULL;
2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;

Line 2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;

2053:
2054: r_jai_ap_tds_repo_lines := NULL;
2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;

Line 2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;

2054: r_jai_ap_tds_repo_lines := NULL;
2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;

Line 2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);

2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;

Line 2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;

2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;

Line 2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;

2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:

Line 2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;

2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:
2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

Line 2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;

2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:
2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2067: END LOOP;

Line 2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;

2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:
2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2067: END LOOP;
2068:

Line 2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:
2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2067: END LOOP;
2068:
2069: END IF;
2070:

Line 2114: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;

2110: AND jcta.tax_id = p_tax_id
2111: ;
2112:
2113: r_c_get_taxes_info c_get_taxes_info%rowtype;
2114: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;
2115: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_tds_repository()';
2116: BEGIN
2117: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
2118:

Line 2272: r_jai_ap_tds_repo_lines := NULL;

2268: );
2269: FETCH c_get_taxes_info INTO r_c_get_taxes_info;
2270: CLOSE c_get_taxes_info;
2271:
2272: r_jai_ap_tds_repo_lines := NULL;
2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;

Line 2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;

2270: CLOSE c_get_taxes_info;
2271:
2272: r_jai_ap_tds_repo_lines := NULL;
2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;

Line 2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;

2271:
2272: r_jai_ap_tds_repo_lines := NULL;
2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;

Line 2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;

2272: r_jai_ap_tds_repo_lines := NULL;
2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;

Line 2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;

2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;

Line 2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;

2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;

Line 2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;

2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;

Line 2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;

2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:

Line 2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;

2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

Line 2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;

2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2286: END LOOP;

Line 2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;

2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2286: END LOOP;
2287:

Line 2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2286: END LOOP;
2287:
2288: END IF;
2289:

Line 2301: --Procedure to insert one line into jai_ap_tds_repo_lines table.

2297: END insert_jai_tds_repository;
2298:
2299:
2300: /*---------------------------------------------------------------------
2301: --Procedure to insert one line into jai_ap_tds_repo_lines table.
2302: ---------------------------------------------------------------------*/
2303: PROCEDURE insert_jai_ap_tds_repo_lines(pr_jai_ap_tds_repo_lines IN jai_ap_tds_repo_lines%rowtype)
2304: IS
2305: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_tds_repo_lines()';

Line 2303: PROCEDURE insert_jai_ap_tds_repo_lines(pr_jai_ap_tds_repo_lines IN jai_ap_tds_repo_lines%rowtype)

2299:
2300: /*---------------------------------------------------------------------
2301: --Procedure to insert one line into jai_ap_tds_repo_lines table.
2302: ---------------------------------------------------------------------*/
2303: PROCEDURE insert_jai_ap_tds_repo_lines(pr_jai_ap_tds_repo_lines IN jai_ap_tds_repo_lines%rowtype)
2304: IS
2305: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_tds_repo_lines()';
2306: BEGIN
2307: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');

Line 2305: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_tds_repo_lines()';

2301: --Procedure to insert one line into jai_ap_tds_repo_lines table.
2302: ---------------------------------------------------------------------*/
2303: PROCEDURE insert_jai_ap_tds_repo_lines(pr_jai_ap_tds_repo_lines IN jai_ap_tds_repo_lines%rowtype)
2304: IS
2305: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_tds_repo_lines()';
2306: BEGIN
2307: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
2308:
2309: INSERT INTO jai_ap_tds_repo_lines

Line 2309: INSERT INTO jai_ap_tds_repo_lines

2305: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_tds_repo_lines()';
2306: BEGIN
2307: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
2308:
2309: INSERT INTO jai_ap_tds_repo_lines
2310: (INVOICE_ID
2311: ,TAX_ID
2312: ,TAX_NAME
2313: ,TAX_TYPE

Line 2323: (pr_jai_ap_tds_repo_lines.INVOICE_ID

2319: ,LAST_UPDATE_LOGIN
2320: ,LAST_UPDATED_BY
2321: )
2322: VALUES
2323: (pr_jai_ap_tds_repo_lines.INVOICE_ID
2324: ,pr_jai_ap_tds_repo_lines.TAX_ID
2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT

Line 2324: ,pr_jai_ap_tds_repo_lines.TAX_ID

2320: ,LAST_UPDATED_BY
2321: )
2322: VALUES
2323: (pr_jai_ap_tds_repo_lines.INVOICE_ID
2324: ,pr_jai_ap_tds_repo_lines.TAX_ID
2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK

Line 2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME

2321: )
2322: VALUES
2323: (pr_jai_ap_tds_repo_lines.INVOICE_ID
2324: ,pr_jai_ap_tds_repo_lines.TAX_ID
2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE

Line 2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE

2322: VALUES
2323: (pr_jai_ap_tds_repo_lines.INVOICE_ID
2324: ,pr_jai_ap_tds_repo_lines.TAX_ID
2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY

Line 2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT

2323: (pr_jai_ap_tds_repo_lines.INVOICE_ID
2324: ,pr_jai_ap_tds_repo_lines.TAX_ID
2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE

Line 2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK

2324: ,pr_jai_ap_tds_repo_lines.TAX_ID
2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE
2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN

Line 2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE

2325: ,pr_jai_ap_tds_repo_lines.TAX_NAME
2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE
2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN
2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY

Line 2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY

2326: ,pr_jai_ap_tds_repo_lines.TAX_TYPE
2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE
2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN
2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY
2334: );

Line 2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE

2327: ,pr_jai_ap_tds_repo_lines.TAX_AMOUNT
2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE
2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN
2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY
2334: );
2335:

Line 2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN

2328: ,pr_jai_ap_tds_repo_lines.SURCHARGE_ROLLBACK
2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE
2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN
2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY
2334: );
2335:
2336: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');

Line 2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY

2329: ,pr_jai_ap_tds_repo_lines.CREATION_DATE
2330: ,pr_jai_ap_tds_repo_lines.CREATED_BY
2331: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_DATE
2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN
2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY
2334: );
2335:
2336: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2337: EXCEPTION

Line 2343: END insert_jai_ap_tds_repo_lines;

2339: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2340: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2341: ,SQLCODE || ':' || SQLERRM);
2342: RAISE;
2343: END insert_jai_ap_tds_repo_lines;
2344:
2345: end jai_ap_tds_pop_rpst_pkg;