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.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_REC_NREC_DIST_GT

Line 981: INSERT INTO zx_rec_nrec_dist_gt VALUES l_rec_nrec_dist_tbl(ctr);

977: RETURN;
978: END IF;
979:
980: FORALL ctr IN NVL(l_rec_nrec_dist_tbl.FIRST,0) .. NVL(l_rec_nrec_dist_tbl.LAST,-1)
981: INSERT INTO zx_rec_nrec_dist_gt VALUES l_rec_nrec_dist_tbl(ctr);
982:
983: -- when is tax_variance_calc_flag is 'Y', calculate variance factors for all
984: -- the tax distributions in global table zx_rec_nrec_dist_gt
985:

Line 984: -- the tax distributions in global table zx_rec_nrec_dist_gt

980: FORALL ctr IN NVL(l_rec_nrec_dist_tbl.FIRST,0) .. NVL(l_rec_nrec_dist_tbl.LAST,-1)
981: INSERT INTO zx_rec_nrec_dist_gt VALUES l_rec_nrec_dist_tbl(ctr);
982:
983: -- when is tax_variance_calc_flag is 'Y', calculate variance factors for all
984: -- the tax distributions in global table zx_rec_nrec_dist_gt
985:
986: IF l_exist_frozen_tax_dist_flag = 'Y' THEN
987:
988: delete_unnecessary_tax_dists(p_event_class_rec => p_event_class_rec,

Line 1272: INSERT INTO zx_rec_nrec_dist_gt VALUES l_rec_nrec_dist_tbl(ctr);

1268:
1269: END IF;
1270:
1271: FORALL ctr IN NVL(l_rec_nrec_dist_tbl.FIRST,0) .. NVL(l_rec_nrec_dist_tbl.LAST,-1)
1272: INSERT INTO zx_rec_nrec_dist_gt VALUES l_rec_nrec_dist_tbl(ctr);
1273:
1274: -- bug fix 3313938: add tax_variance_calc_flag check.
1275: IF g_variance_calc_flag = 'Y' THEN
1276: -- when is tax_variance_calc_flag is 'Y', calculate variance factors for

Line 1277: -- all the tax distributions in global table zx_rec_nrec_dist_gt

1273:
1274: -- bug fix 3313938: add tax_variance_calc_flag check.
1275: IF g_variance_calc_flag = 'Y' THEN
1276: -- when is tax_variance_calc_flag is 'Y', calculate variance factors for
1277: -- all the tax distributions in global table zx_rec_nrec_dist_gt
1278:
1279: ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors(
1280: x_return_status,
1281: p_error_buffer

Line 4135: | PL/SQL table to the global tempoarary table zx_rec_nrec_dist_gt when there |

4131: | PRIVATE PROCEDURE insert_global_table |
4132: | |
4133: | DESCRIPTION |
4134: | This procedure is used to insert rec/non-rec tax distributions from the |
4135: | PL/SQL table to the global tempoarary table zx_rec_nrec_dist_gt when there |
4136: | are more than 1000 records in the PL/SQL table |
4137: |
4138: * =============================================================================*/
4139:

Line 4181: INSERT INTO zx_rec_nrec_dist_gt VALUES p_rec_nrec_dist_tbl(ctr);

4177: END IF;
4178:
4179:
4180: FORALL ctr IN NVL(p_rec_nrec_dist_tbl.FIRST,0) .. NVL(p_rec_nrec_dist_tbl.LAST,-1)
4181: INSERT INTO zx_rec_nrec_dist_gt VALUES p_rec_nrec_dist_tbl(ctr);
4182:
4183: -- reinitialize the PL/SQL table.
4184: p_rec_nrec_dist_tbl.delete;
4185: p_rec_nrec_dist_end_index := 0;

Line 5810: | lines is 'Y' after tax dists are inserted into zx_rec_nrec_dist_gt. |

5806: | PUBLIC PROCEDURE delete_unnecessary_tax_dists |
5807: | |
5808: | DESCRIPTION: |
5809: | This procedure is called if associate_child_frozen_flag on detail tax |
5810: | lines is 'Y' after tax dists are inserted into zx_rec_nrec_dist_gt. |
5811: | If there is no change on tax_line and item distribution, the reversed |
5812: | tax_distributions and the new created tax distributions, which are |
5813: | created for the frozen taxdistributions, will be deleted. |
5814: | |

Line 5904: FROM ZX_REC_NREC_DIST_GT gt

5900: -- are not created for Historical Invoices on re-validation.
5901:
5902: SELECT REC_NREC_TAX_DIST_ID, REVERSED_TAX_DIST_ID
5903: BULK COLLECT INTO l_rec_nrec_tax_Dist_id_tbl1, l_reversed_tax_dist_id_tbl
5904: FROM ZX_REC_NREC_DIST_GT gt
5905: WHERE ( reversed_tax_dist_id IS NOT NULL
5906: AND EXISTS
5907: (SELECT 1 FROM ZX_REC_NREC_DIST_GT gt1
5908: WHERE gt1.tax_line_id = gt.tax_line_id

Line 5907: (SELECT 1 FROM ZX_REC_NREC_DIST_GT gt1

5903: BULK COLLECT INTO l_rec_nrec_tax_Dist_id_tbl1, l_reversed_tax_dist_id_tbl
5904: FROM ZX_REC_NREC_DIST_GT gt
5905: WHERE ( reversed_tax_dist_id IS NOT NULL
5906: AND EXISTS
5907: (SELECT 1 FROM ZX_REC_NREC_DIST_GT gt1
5908: WHERE gt1.tax_line_id = gt.tax_line_id
5909: AND gt1.trx_line_dist_id = gt.trx_line_dist_id
5910: AND gt1.tax_status_id = gt.tax_status_id
5911: AND gt1.tax_rate_id = gt.tax_rate_id

Line 5962: FROM ZX_REC_NREC_DIST_GT gt

5958: IF l_rec_nrec_tax_Dist_id_tbl1.count > 0 THEN
5959:
5960: SELECT rec_nrec_tax_dist_id
5961: BULK COLLECT INTO l_rec_nrec_tax_Dist_id_tbl2
5962: FROM ZX_REC_NREC_DIST_GT gt
5963: WHERE ( gt.freeze_flag = 'N'
5964: AND gt.reverse_flag = 'N'
5965: AND EXISTS
5966: (SELECT 1 FROM ZX_REC_NREC_DIST_GT gt1

Line 5966: (SELECT 1 FROM ZX_REC_NREC_DIST_GT gt1

5962: FROM ZX_REC_NREC_DIST_GT gt
5963: WHERE ( gt.freeze_flag = 'N'
5964: AND gt.reverse_flag = 'N'
5965: AND EXISTS
5966: (SELECT 1 FROM ZX_REC_NREC_DIST_GT gt1
5967: WHERE gt1.tax_line_id = gt.tax_line_id
5968: AND gt1.trx_line_dist_id = gt.trx_line_dist_id
5969: AND gt1.tax_status_id = gt.tax_status_id
5970: AND gt1.tax_rate_id = gt.tax_rate_id

Line 6024: DELETE FROM zx_rec_nrec_dist_gt

6020:
6021: IF l_rec_nrec_tax_Dist_id_tbl1.COUNT > 0 AND l_rec_nrec_tax_Dist_id_tbl2.COUNT > 0 THEN
6022:
6023: FORALL j in l_rec_nrec_tax_Dist_id_tbl1.FIRST .. l_rec_nrec_tax_Dist_id_tbl1.LAST
6024: DELETE FROM zx_rec_nrec_dist_gt
6025: WHERE rec_nrec_tax_dist_id IN l_rec_nrec_tax_Dist_id_tbl1(j);
6026:
6027: FORALL j in l_rec_nrec_tax_Dist_id_tbl2.FIRST .. l_rec_nrec_tax_Dist_id_tbl2.LAST
6028: DELETE FROM zx_rec_nrec_dist_gt

Line 6028: DELETE FROM zx_rec_nrec_dist_gt

6024: DELETE FROM zx_rec_nrec_dist_gt
6025: WHERE rec_nrec_tax_dist_id IN l_rec_nrec_tax_Dist_id_tbl1(j);
6026:
6027: FORALL j in l_rec_nrec_tax_Dist_id_tbl2.FIRST .. l_rec_nrec_tax_Dist_id_tbl2.LAST
6028: DELETE FROM zx_rec_nrec_dist_gt
6029: WHERE rec_nrec_tax_dist_id IN l_rec_nrec_tax_Dist_id_tbl2(j);
6030:
6031: END IF;
6032:

Line 6037: UPDATE zx_rec_nrec_dist_gt gt

6033: IF l_reversed_tax_dist_id_tbl.COUNT > 0 AND l_rec_nrec_tax_Dist_id_tbl1.count > 0
6034: AND l_rec_nrec_tax_Dist_id_tbl2.COUNT > 0 THEN
6035:
6036: FORALL i IN l_reversed_tax_dist_id_tbl.FIRST .. l_reversed_tax_dist_id_tbl.LAST
6037: UPDATE zx_rec_nrec_dist_gt gt
6038: SET reverse_flag = 'N'
6039: WHERE rec_nrec_tax_dist_id = l_reversed_tax_dist_id_tbl(i);
6040:
6041: END IF;