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_PREPAYMENTS_PKG dependencies on JAI_AP_TDS_GENERATION_PKG

Line 40: jai_ap_tds_generation_pkg.generate_tds_invoices

36: b) Code Added to open and Fetch the details from the
37: above 2 cursors
38: c) Changed the value of parameter pn_tax_amount,
39: while calling
40: jai_ap_tds_generation_pkg.generate_tds_invoices
41: d) Changed the value of parameter p_trx_tax_paid,
42: while calling
43: jai_ap_tds_generation_pkg.maintain_thhold_grps
44:

Line 43: jai_ap_tds_generation_pkg.maintain_thhold_grps

39: while calling
40: jai_ap_tds_generation_pkg.generate_tds_invoices
41: d) Changed the value of parameter p_trx_tax_paid,
42: while calling
43: jai_ap_tds_generation_pkg.maintain_thhold_grps
44:
45: Dependencies (Functional)
46: -------------------------
47: jai_ap_tds_gen.plb Version 120.3

Line 356: jai_ap_tds_generation_pkg.maintain_thhold_grps

352: fetch c_tds_details_apply into r_tds_details_apply;
353: close c_tds_details_apply;
354:
355: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
356: jai_ap_tds_generation_pkg.maintain_thhold_grps
357: (
358: p_threshold_grp_id => ln_threshold_grp_id,
359: p_trx_invoice_unapply_amount => r_get_total_prepayment_tax.tds_taxable_basis,
360: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 391: jai_ap_tds_generation_pkg.generate_tds_invoices

387: open c_get_tds_tax_id(p_invoice_id, p_parent_distribution_id);
388: fetch c_get_tds_tax_id into ln_tax_id;
389: close c_get_tds_tax_id;
390:
391: jai_ap_tds_generation_pkg.generate_tds_invoices
392: (
393: pn_invoice_id => p_invoice_id ,
394: pn_invoice_distribution_id => p_invoice_distribution_id ,
395: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 425: jai_ap_tds_generation_pkg.maintain_thhold_grps

421:
422: /* Update the threshold group */
423:
424: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
425: jai_ap_tds_generation_pkg.maintain_thhold_grps
426: (
427: p_threshold_grp_id => ln_threshold_grp_id,
428: p_trx_tax_paid => r_get_total_prepayment_tax.tds_amount,
429: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 485: jai_ap_tds_generation_pkg.generate_tds_invoices

481: open c_get_wct_tax_id(p_invoice_id, p_parent_distribution_id);
482: fetch c_get_wct_tax_id into ln_tax_id;
483: close c_get_wct_tax_id;
484:
485: jai_ap_tds_generation_pkg.generate_tds_invoices
486: (
487: pn_invoice_id => p_invoice_id ,
488: pn_invoice_distribution_id => p_invoice_distribution_id ,
489: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 549: jai_ap_tds_generation_pkg.generate_tds_invoices

545: open c_get_essi_tax_id(p_invoice_id, p_parent_distribution_id);
546: fetch c_get_essi_tax_id into ln_tax_id;
547: close c_get_essi_tax_id;
548:
549: jai_ap_tds_generation_pkg.generate_tds_invoices
550: (
551: pn_invoice_id => p_invoice_id ,
552: pn_invoice_distribution_id => p_invoice_distribution_id ,
553: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 598: jai_ap_tds_generation_pkg.import_and_approve

594: and invoice_distribution_id_prepay = p_parent_distribution_id;
595:
596: if ln_start_threshold_trx_id is not null then
597:
598: jai_ap_tds_generation_pkg.import_and_approve
599: (
600: p_invoice_id => p_invoice_id,
601: p_start_thhold_trx_id => ln_start_threshold_trx_id,
602: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 1105: jai_ap_tds_generation_pkg.g_inr_currency_rounding);

1101: ln_tds_tmp_amt := 0;
1102: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1103: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1104: * (r_ja_in_tax_codes.tax_rate/100),
1105: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1106: else
1107: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1108: * (r_ja_in_tax_codes.tax_rate/100),
1109: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

Line 1109: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

1105: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1106: else
1107: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1108: * (r_ja_in_tax_codes.tax_rate/100),
1109: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1110: end if;
1111: IF trunc(p_creation_date) >=
1112: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1113: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

Line 1112: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1108: * (r_ja_in_tax_codes.tax_rate/100),
1109: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1110: end if;
1111: IF trunc(p_creation_date) >=
1112: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1113: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1114: END IF;
1115: -- End for bug 5722028
1116:

Line 1113: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

1109: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1110: end if;
1111: IF trunc(p_creation_date) >=
1112: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1113: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1114: END IF;
1115: -- End for bug 5722028
1116:
1117:

Line 1140: jai_ap_tds_generation_pkg.g_inr_currency_rounding);

1136: ln_tds_tmp_amt := 0;
1137: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1138: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1139: * (r_ja_in_tax_codes.tax_rate/100),
1140: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1141: else
1142: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1143: * (r_ja_in_tax_codes.tax_rate/100),
1144: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

Line 1144: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

1140: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1141: else
1142: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1143: * (r_ja_in_tax_codes.tax_rate/100),
1144: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1145: end if;
1146:
1147: /* Bug 7280925. Commented by Lakshmi Gopalsami
1148: * Rounding to 10 is applicable only for TDS.

Line 1151: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1147: /* Bug 7280925. Commented by Lakshmi Gopalsami
1148: * Rounding to 10 is applicable only for TDS.
1149: * WCT and ESSI should be rounded to Re. 1
1150: IF trunc(p_creation_date) >=
1151: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1152: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1153: END IF;
1154: */
1155: -- End for bug 5722028

Line 1152: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

1148: * Rounding to 10 is applicable only for TDS.
1149: * WCT and ESSI should be rounded to Re. 1
1150: IF trunc(p_creation_date) >=
1151: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1152: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1153: END IF;
1154: */
1155: -- End for bug 5722028
1156:

Line 1179: jai_ap_tds_generation_pkg.g_inr_currency_rounding);

1175: ln_tds_tmp_amt := 0;
1176: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1177: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1178: * (r_ja_in_tax_codes.tax_rate/100),
1179: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1180: else
1181: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1182: * (r_ja_in_tax_codes.tax_rate/100),
1183: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

Line 1183: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

1179: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1180: else
1181: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1182: * (r_ja_in_tax_codes.tax_rate/100),
1183: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1184: end if;
1185: /* Bug 7280925. Commented by Lakshmi Gopalsami
1186: * Rounding to 10 is applicable only for TDS.
1187: * WCT and ESSI should be rounded to Re. 1

Line 1189: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1185: /* Bug 7280925. Commented by Lakshmi Gopalsami
1186: * Rounding to 10 is applicable only for TDS.
1187: * WCT and ESSI should be rounded to Re. 1
1188: IF trunc(p_creation_date) >=
1189: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1190: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1191: END IF;
1192: */
1193: -- End for bug 5722028

Line 1190: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

1186: * Rounding to 10 is applicable only for TDS.
1187: * WCT and ESSI should be rounded to Re. 1
1188: IF trunc(p_creation_date) >=
1189: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1190: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1191: END IF;
1192: */
1193: -- End for bug 5722028
1194:

Line 1210: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

1206: close c_get_total_prepayment_tax;
1207:
1208: --Call to procedure - get_tds_threshold_slab, added by Sanjikum for Bug#5131075(4718907)
1209: --Store the current Threshold slab and type before PP application
1210: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
1211: p_prepay_distribution_id => p_prepay_distribution_id,
1212: p_threshold_grp_id => ln_temp_threshold_grp_id,
1213: p_threshold_hdr_id => ln_temp_threshold_hdr_id,
1214: p_threshold_slab_id => ln_threshold_slab_id,

Line 1241: jai_ap_tds_generation_pkg.maintain_thhold_grps

1237: goto exit_from_procedure;
1238: end if;
1239:
1240: /* update the threshold with the tds amount that will be impacted because of this application */
1241: jai_ap_tds_generation_pkg.maintain_thhold_grps
1242: (
1243: p_threshold_grp_id => ln_threshold_grp_id,
1244: p_trx_invoice_apply_amount => r_get_total_prepayment_tax.tds_taxable_basis,
1245: p_tds_event => 'PREPAYMENT APPLICATION',

Line 1322: jai_ap_tds_generation_pkg.generate_tds_invoices

1318: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1319: close c_ap_invoices_all;
1320: end if;
1321:
1322: jai_ap_tds_generation_pkg.generate_tds_invoices
1323: (
1324: pn_invoice_id => p_invoice_id ,
1325: pn_invoice_distribution_id => p_invoice_distribution_id ,
1326: pv_invoice_num_prepay_apply => lv_invoice_num_prepay_apply ,

Line 1359: jai_ap_tds_generation_pkg.maintain_thhold_grps

1355: ln_start_threshold_trx_id := ln_threshold_trx_id_tds;
1356: end if;
1357:
1358: /* Update the threshold group */
1359: jai_ap_tds_generation_pkg.maintain_thhold_grps
1360: (
1361: p_threshold_grp_id => ln_threshold_grp_id,
1362: /* Bug 4522507. Added by Lakshmi Gopalsami
1363: Commented the following and added different assginment

Line 1404: jai_ap_tds_generation_pkg.generate_tds_invoices

1400: open c_get_pp_section_tax_id(p_prepay_distribution_id, 'WCT_SECTION');
1401: fetch c_get_pp_section_tax_id into ln_pp_section_tax_id;
1402: close c_get_pp_section_tax_id;
1403:
1404: jai_ap_tds_generation_pkg.generate_tds_invoices
1405: (
1406: pn_invoice_id => p_invoice_id ,
1407: pn_invoice_distribution_id => p_invoice_distribution_id ,
1408: pn_taxable_amount => r_get_total_prepayment_tax.wct_taxable_basis ,

Line 1448: jai_ap_tds_generation_pkg.generate_tds_invoices

1444: open c_get_pp_section_tax_id(p_prepay_distribution_id, 'ESSI_SECTION');
1445: fetch c_get_pp_section_tax_id into ln_pp_section_tax_id;
1446: close c_get_pp_section_tax_id;
1447:
1448: jai_ap_tds_generation_pkg.generate_tds_invoices
1449: (
1450: pn_invoice_id => p_invoice_id ,
1451: pn_invoice_distribution_id => p_invoice_distribution_id ,
1452: pn_taxable_amount => r_get_total_prepayment_tax.essi_taxable_basis ,

Line 1484: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

1480: end if; /* ESSI */
1481:
1482: --Call to procedure - get_tds_threshold_slab, added by Sanjikum for Bug#5131075(4718907)
1483: --Store the current Threshold slab and type After PP application
1484: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
1485: p_prepay_distribution_id => p_prepay_distribution_id,
1486: p_threshold_grp_id => ln_temp_threshold_grp_id,
1487: p_threshold_hdr_id => ln_temp_threshold_hdr_id,
1488: p_threshold_slab_id => ln_after_threshold_slab_id,

Line 1499: jai_ap_tds_generation_pkg.process_threshold_rollback(

1495: goto exit_from_procedure;
1496: END IF;
1497:
1498: --Call below made to check, if there is any threshold rollback processing required
1499: jai_ap_tds_generation_pkg.process_threshold_rollback(
1500: p_invoice_id => p_invoice_id,
1501: p_before_threshold_type => lv_threshold_type,
1502: p_after_threshold_type => lv_after_threshold_type,
1503: p_before_threshold_slab_id => ln_threshold_slab_id,

Line 1522: jai_ap_tds_generation_pkg.import_and_approve

1518: --End by Sanjikum for Bug#5131075(4718907)
1519:
1520: if ln_start_threshold_trx_id is not null then
1521:
1522: jai_ap_tds_generation_pkg.import_and_approve
1523: (
1524: p_invoice_id => p_invoice_id,
1525: p_start_thhold_trx_id => ln_start_threshold_trx_id,
1526: p_tds_event => 'PREPAYMENT APPLICATION',