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_TRL_MANAGE_TAX_PKG dependencies on ZX_REC_NREC_DIST

Line 949: FROM ZX_REC_NREC_DIST ZD,

945: WHERE SUMMARY_TAX_LINE_ID IN
946: (SELECT summary_tax_line_id
947: FROM ZX_LINES
948: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
949: FROM ZX_REC_NREC_DIST ZD,
950: ZX_TAX_DIST_ID_GT ZGT
951: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID))
952: AND Associated_Child_Frozen_Flag = 'N';
953:

Line 961: FROM ZX_REC_NREC_DIST ZD,

957:
958: UPDATE ZX_LINES
959: SET SUMMARY_TAX_LINE_ID = NULL
960: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
961: FROM ZX_REC_NREC_DIST ZD,
962: ZX_TAX_DIST_ID_GT ZGT
963: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID)
964: AND ASSOCIATED_CHILD_FROZEN_FLAG = 'N';
965: --

Line 1276: | ZX_REC_NREC_DIST for given tax line |

1272: END Delete_Summary_Lines;
1273:
1274: /* ===========================================================================*
1275: | PROCEDURE Delete_Loose_Tax_Distributions: Deletes tax distributions from |
1276: | ZX_REC_NREC_DIST for given tax line |
1277: * ===========================================================================*/
1278:
1279: PROCEDURE Delete_Loose_Tax_Distributions
1280: (x_return_status OUT NOCOPY VARCHAR2,

Line 1307: FROM zx_rec_nrec_dist zd

1303: OR NVL(aid.match_status_flag,'N') IN ('A','T')
1304: OR NVL(aid.posted_flag,'N') = 'Y'
1305: OR NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
1306: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions'
1307: FROM zx_rec_nrec_dist zd
1308: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id
1309: AND NVL(zd.self_assessed_flag, 'N') = 'N');
1310:
1311: -- bug 14198788 driving queries from zx_trx_headers_gt

Line 1329: FROM zx_rec_nrec_dist zd

1325: OR NVL(asad.match_status_flag,'N') IN ('A','T')
1326: OR NVL(asad.posted_flag,'N') = 'Y'
1327: OR NVL(asad.encumbered_flag, 'N') IN ('Y','D','W','X'))
1328: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions'
1329: FROM zx_rec_nrec_dist zd
1330: WHERE zd.rec_nrec_tax_dist_id = asad.detail_tax_dist_id
1331: AND NVL(zd.self_assessed_flag, 'N') = 'Y');
1332:
1333: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1379: DELETE FROM ZX_REC_NREC_DIST

1375: END IF;
1376:
1377: -- rewrote the following query for bug fix 5417887
1378: /*
1379: DELETE FROM ZX_REC_NREC_DIST
1380: WHERE APPLICATION_ID = p_event_class_rec.application_id
1381: AND ENTITY_CODE = p_event_class_rec.entity_code
1382: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
1383: AND TRX_ID = p_event_class_rec.trx_id

Line 1393: DELETE FROM zx_rec_nrec_dist dist

1389: AND zx_lines.event_class_code = p_event_class_rec.event_class_code
1390: AND zx_lines.trx_id = p_event_class_rec.trx_id);
1391: */
1392:
1393: DELETE FROM zx_rec_nrec_dist dist
1394: WHERE EXISTS (
1395: SELECT 1
1396: FROM zx_lines_det_factors
1397: WHERE application_id = dist.application_id

Line 1451: 'Following frozen tax distributions deleted from ZX_REC_NREC_DIST:');

1447: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions',
1448: 'ERROR: '||l_error_buffer);
1449: FND_LOG.STRING(g_level_unexpected,
1450: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions',
1451: 'Following frozen tax distributions deleted from ZX_REC_NREC_DIST:');
1452: END IF;
1453:
1454: FOR i IN NVL(l_trx_id_tbl.FIRST,0)..NVL(l_trx_id_tbl.LAST,-99) LOOP
1455: IF l_prev_trx_id <> l_trx_id_tbl(i) THEN

Line 1499: 'Following self-assessed frozen tax distributions deleted from ZX_REC_NREC_DIST:');

1495: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions',
1496: 'ERROR: '||l_error_buffer);
1497: FND_LOG.STRING(g_level_unexpected,
1498: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions',
1499: 'Following self-assessed frozen tax distributions deleted from ZX_REC_NREC_DIST:');
1500: END IF;
1501:
1502: FOR i IN NVL(l_trx_id_tbl.FIRST,0)..NVL(l_trx_id_tbl.LAST,-99) LOOP
1503: IF l_prev_trx_id <> l_trx_id_tbl(i) THEN

Line 1569: | ZX_REC_NREC_DIST when new tax distributions are created in |

1565: END Delete_Loose_Tax_Distributions;
1566:
1567: /* ===========================================================================*
1568: | PROCEDURE Delete_Tax_Distributions: Deletes old tax distributions from |
1569: | ZX_REC_NREC_DIST when new tax distributions are created in |
1570: | ZX_REC_NREC_DIST_GT |
1571: * ===========================================================================*/
1572:
1573: PROCEDURE Delete_Tax_Distributions(

Line 1570: | ZX_REC_NREC_DIST_GT |

1566:
1567: /* ===========================================================================*
1568: | PROCEDURE Delete_Tax_Distributions: Deletes old tax distributions from |
1569: | ZX_REC_NREC_DIST when new tax distributions are created in |
1570: | ZX_REC_NREC_DIST_GT |
1571: * ===========================================================================*/
1572:
1573: PROCEDURE Delete_Tax_Distributions(
1574: x_return_status OUT NOCOPY VARCHAR2,

Line 1595: DELETE FROM zx_rec_nrec_dist

1591:
1592: -- Initialize API return status to success
1593: x_return_status := FND_API.G_RET_STS_SUCCESS;
1594:
1595: DELETE FROM zx_rec_nrec_dist
1596: WHERE application_id = p_event_class_rec.application_id
1597: AND entity_code = p_event_class_rec.entity_code
1598: AND event_class_code = p_event_class_rec.event_class_code
1599: AND trx_id = p_event_class_rec.trx_id

Line 1761: DELETE FROM ZX_REC_NREC_DIST

1757: END IF;
1758:
1759: END IF;
1760:
1761: DELETE FROM ZX_REC_NREC_DIST
1762: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1763: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1764: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1765: AND TRX_ID = p_event_class_rec.TRX_ID;

Line 1770: 'Number of rows deleted from zx_rec_nrec_dist = '||l_row_count);

1766:
1767: IF (g_level_statement >= g_current_runtime_level ) THEN
1768: FND_LOG.STRING(g_level_statement,
1769: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Transaction',
1770: 'Number of rows deleted from zx_rec_nrec_dist = '||l_row_count);
1771: END IF;
1772:
1773: IF (g_level_procedure >= g_current_runtime_level ) THEN
1774: FND_LOG.STRING(g_level_procedure,

Line 1852: FROM zx_rec_nrec_dist

1848: CURSOR get_max_tax_dist_num_csr(
1849: c_tax_line_id NUMBER,
1850: c_trx_line_dist_id NUMBER) IS
1851: SELECT max(rec_nrec_tax_dist_number)
1852: FROM zx_rec_nrec_dist
1853: WHERE tax_line_id = c_tax_line_id
1854: AND trx_line_dist_id = c_trx_line_dist_id;
1855:
1856: CURSOR get_frozen_tax_dists_csr IS

Line 1863: FROM zx_rec_nrec_dist

1859: trx_line_dist_id,
1860: rec_nrec_tax_dist_number,
1861: internal_organization_id,
1862: gl_date
1863: FROM zx_rec_nrec_dist
1864: WHERE freeze_flag = 'Y'
1865: AND NVL(reverse_flag, 'N') = 'N'
1866: AND application_id = p_event_class_rec.application_id
1867: AND entity_code = p_event_class_rec.entity_code

Line 1972: INSERT INTO ZX_REC_NREC_DIST(

1968:
1969: FORALL i IN NVL(l_rec_nrec_tax_dist_id_tbl.FIRST, 0) ..
1970: NVL(l_rec_nrec_tax_dist_id_tbl.LAST, -1)
1971:
1972: INSERT INTO ZX_REC_NREC_DIST(
1973: REC_NREC_TAX_DIST_ID,
1974: APPLICATION_ID,
1975: ENTITY_CODE,
1976: EVENT_CLASS_CODE,

Line 2142: SELECT ZX_REC_NREC_DIST_S.NEXTVAL,

2138: INTERNAL_ORGANIZATION_ID,
2139: DEF_REC_SETTLEMENT_OPTION_CODE,
2140: TAX_JURISDICTION_ID,
2141: ACCOUNT_SOURCE_TAX_RATE_ID)
2142: SELECT ZX_REC_NREC_DIST_S.NEXTVAL,
2143: APPLICATION_ID,
2144: ENTITY_CODE,
2145: EVENT_CLASS_CODE,
2146: EVENT_TYPE_CODE,

Line 2311: FROM ZX_REC_NREC_DIST

2307: INTERNAL_ORGANIZATION_ID,
2308: DEF_REC_SETTLEMENT_OPTION_CODE,
2309: TAX_JURISDICTION_ID,
2310: ACCOUNT_SOURCE_TAX_RATE_ID
2311: FROM ZX_REC_NREC_DIST
2312: WHERE rec_nrec_tax_dist_id = l_rec_nrec_tax_dist_id_tbl(i);
2313:
2314: l_row_count := SQL%ROWCOUNT;
2315:

Line 2319: 'Number of rows updated in zx_rec_nrec_dist = '||l_row_count);

2315:
2316: IF (g_level_statement >= g_current_runtime_level ) THEN
2317: FND_LOG.STRING(g_level_statement,
2318: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Cancel_Transaction',
2319: 'Number of rows updated in zx_rec_nrec_dist = '||l_row_count);
2320: END IF;
2321:
2322: FORALL i IN NVL(l_rec_nrec_tax_dist_id_tbl.FIRST, 0) ..
2323: NVL(l_rec_nrec_tax_dist_id_tbl.LAST, -1)

Line 2324: UPDATE zx_rec_nrec_dist

2320: END IF;
2321:
2322: FORALL i IN NVL(l_rec_nrec_tax_dist_id_tbl.FIRST, 0) ..
2323: NVL(l_rec_nrec_tax_dist_id_tbl.LAST, -1)
2324: UPDATE zx_rec_nrec_dist
2325: SET reverse_flag = 'Y'
2326: WHERE rec_nrec_tax_dist_id = l_rec_nrec_tax_dist_id_tbl(i);
2327:
2328: l_row_count := SQL%ROWCOUNT;

Line 2333: 'Number of rows updated in zx_rec_nrec_dist = '||l_row_count);

2329:
2330: IF (g_level_statement >= g_current_runtime_level ) THEN
2331: FND_LOG.STRING(g_level_statement,
2332: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Cancel_Transaction',
2333: 'Number of rows updated in zx_rec_nrec_dist = '||l_row_count);
2334: END IF;
2335:
2336: END IF; -- _rec_nrec_tax_dist_id_tbl.COUNT > 0
2337:

Line 2466: FROM ZX_REC_NREC_DIST

2462: l_error_buffer VARCHAR2(100);
2463:
2464: CURSOR check_dist IS
2465: SELECT count(*) frozen_rec
2466: FROM ZX_REC_NREC_DIST
2467: WHERE application_id = p_transaction_line_rec.application_id
2468: AND entity_code = p_transaction_line_rec.entity_code
2469: AND event_class_code = p_transaction_line_rec.event_class_code
2470: AND trx_id = p_transaction_line_rec.trx_id

Line 2586: | ZX_REC_NREC_DIST table. |

2582: END Mark_Detail_Tax_Lines_Delete;
2583:
2584: /*============================================================================*
2585: | PROCEDURE Create_Tax_Distributions: Inserts distribution lines into |
2586: | ZX_REC_NREC_DIST table. |
2587: *============================================================================*/
2588:
2589: PROCEDURE Create_Tax_Distributions
2590: (x_return_status OUT NOCOPY VARCHAR2) IS

Line 2607: INSERT INTO ZX_REC_NREC_DIST (REC_NREC_TAX_DIST_ID,

2603:
2604: -- Initialize API return status to success
2605: x_return_status := FND_API.G_RET_STS_SUCCESS;
2606:
2607: INSERT INTO ZX_REC_NREC_DIST (REC_NREC_TAX_DIST_ID,
2608: APPLICATION_ID,
2609: ENTITY_CODE,
2610: EVENT_CLASS_CODE,
2611: EVENT_TYPE_CODE,

Line 2945: FROM ZX_REC_NREC_DIST_GT;

2941: INTERNAL_ORGANIZATION_ID,
2942: DEF_REC_SETTLEMENT_OPTION_CODE,
2943: TAX_JURISDICTION_ID,
2944: ACCOUNT_SOURCE_TAX_RATE_ID
2945: FROM ZX_REC_NREC_DIST_GT;
2946:
2947: IF (g_level_statement >= g_current_runtime_level ) THEN
2948: FND_LOG.STRING(g_level_statement,
2949: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions',

Line 2958: FROM zx_rec_nrec_dist_gt

2954: UPDATE zx_lines
2955: SET associated_child_frozen_flag = 'Y'
2956: WHERE tax_line_id IN
2957: (SELECT tax_line_id
2958: FROM zx_rec_nrec_dist_gt
2959: WHERE tax_only_line_flag = 'Y'
2960: );
2961: EXCEPTION
2962: WHEN OTHERS THEN

Line 3013: | ZX_REC_NREC_DIST that are associated with tax lines whose |

3009: END Create_Tax_Distributions;
3010:
3011: /*============================================================================*
3012: | Delete_Dist_Marked_For_Delete: Deletes all the tax distributions from |
3013: | ZX_REC_NREC_DIST that are associated with tax lines whose |
3014: | Process_For_Recovery_Flag is 'Y' or Item_Dist_Changed_Flag is 'Y'. |
3015: *============================================================================*/
3016:
3017: PROCEDURE Delete_Dist_Marked_For_Delete

Line 3087: -- DELETE FROM ZX_REC_NREC_DIST

3083:
3084: -- Commented the following DELETE statement for Bug#16313915 --
3085: -- and added new performance tuned DELETE statement below --
3086: --
3087: -- DELETE FROM ZX_REC_NREC_DIST
3088: -- WHERE NVL(Reverse_Flag,'N') = 'N'
3089: -- AND TAX_LINE_ID IN (SELECT TAX_LINE_ID
3090: -- FROM ZX_LINES L
3091: -- WHERE APPLICATION_ID = p_event_class_rec.application_id

Line 3109: DELETE FROM ZX_REC_NREC_DIST DIST

3105: -- AND EVENT_ID = p_event_class_rec.event_id
3106: -- )
3107: -- );
3108:
3109: DELETE FROM ZX_REC_NREC_DIST DIST
3110: WHERE NVL(Reverse_Flag,'N') = 'N'
3111: AND application_id = p_event_class_rec.application_id
3112: AND entity_code = p_event_class_rec.entity_code
3113: AND event_class_code = p_event_class_rec.event_class_code

Line 3140: UPDATE zx_rec_nrec_dist zd

3136: -- bug6890360: synchronize tax_line_number for reversed tax dustributions,
3137: -- which are not fetched back for processing
3138: --
3139: BEGIN
3140: UPDATE zx_rec_nrec_dist zd
3141: SET tax_line_number =
3142: (SELECT tax_line_number
3143: FROM zx_lines
3144: WHERE tax_line_id = zd.tax_line_id

Line 3181: UPDATE zx_rec_nrec_dist zd

3177: END;
3178:
3179:
3180: BEGIN
3181: UPDATE zx_rec_nrec_dist zd
3182: SET summary_tax_line_id =
3183: (SELECT summary_tax_line_id
3184: FROM zx_rec_nrec_dist_gt gt
3185: WHERE gt.tax_line_id = zd.tax_line_id

Line 3184: FROM zx_rec_nrec_dist_gt gt

3180: BEGIN
3181: UPDATE zx_rec_nrec_dist zd
3182: SET summary_tax_line_id =
3183: (SELECT summary_tax_line_id
3184: FROM zx_rec_nrec_dist_gt gt
3185: WHERE gt.tax_line_id = zd.tax_line_id
3186: AND gt.trx_line_dist_id = zd.trx_line_dist_id
3187: AND ROWNUM = 1
3188: )

Line 3214: FROM ZX_REC_NREC_DIST_GT GT);

3210: )
3211: AND (ZD.TAX_LINE_ID, ZD.TRX_LINE_DIST_ID) IN (
3212: SELECT /*+ LEADING(GT) CARDINALITY(GT 1) */
3213: GT.TAX_LINE_ID, GT.TRX_LINE_DIST_ID
3214: FROM ZX_REC_NREC_DIST_GT GT);
3215:
3216: IF (g_level_statement >= g_current_runtime_level ) THEN
3217: FND_LOG.STRING(g_level_statement,
3218: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Dist_Marked_For_Delete',

Line 3313: FROM ZX_REC_NREC_DIST D

3309: SUM(decode(Recoverable_Flag,'N',rec_nrec_tax_amt_tax_curr)) nrec_tax_amt_tax_curr,
3310: SUM(decode(Recoverable_Flag,'N',rec_nrec_tax_amt_funcl_curr)) nrec_tax_amt_funcl_curr,
3311: 'N' Process_For_Recovery_Flag,
3312: 'N' Item_Dist_Changed_Flag
3313: FROM ZX_REC_NREC_DIST D
3314: WHERE D.tax_line_id = L.tax_line_id
3315: AND D.application_id = L.application_id
3316: AND D.entity_code = L.entity_code
3317: AND D.event_class_code = L.event_class_code

Line 3427: /*UPDATE ZX_REC_NREC_DIST

3423:
3424: -- Initialize API return status to success
3425: x_return_status := FND_API.G_RET_STS_SUCCESS;
3426:
3427: /*UPDATE ZX_REC_NREC_DIST
3428: SET Freeze_Flag = 'Y',
3429: event_type_code = p_event_class_rec.event_type_code,
3430: tax_event_type_code = p_event_class_rec.tax_event_type_code
3431: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID

Line 3435: -- Bug 6335649, In cases where Recovery is 100% Recoverable, in ZX_REC_NREC_DIST we have both REC and NONREC(0 amount)lines.

3431: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID
3432: FROM ZX_TAX_DIST_ID_GT);
3433:
3434: */
3435: -- Bug 6335649, In cases where Recovery is 100% Recoverable, in ZX_REC_NREC_DIST we have both REC and NONREC(0 amount)lines.
3436: -- When we call ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist for the second time computation,
3437: -- freeze_flag is checked for both the REC and NONREC lines, popualting the p_rec_nrec_tbl for them.
3438: -- But for the non rec lines, freeze flag is NULL. Below code, updates the freeze flags of the REC/NONREC lines with 0 rec_nrec_rate
3439:

Line 3440: UPDATE ZX_REC_NREC_DIST

3436: -- When we call ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist for the second time computation,
3437: -- freeze_flag is checked for both the REC and NONREC lines, popualting the p_rec_nrec_tbl for them.
3438: -- But for the non rec lines, freeze flag is NULL. Below code, updates the freeze flags of the REC/NONREC lines with 0 rec_nrec_rate
3439:
3440: UPDATE ZX_REC_NREC_DIST
3441: SET freeze_flag = 'Y',
3442: event_type_code = p_event_class_rec.event_type_code,
3443: tax_event_type_code = p_event_class_rec.tax_event_type_code
3444: WHERE tax_line_id IN (SELECT tax_line_id

Line 3445: FROM zx_rec_nrec_dist

3441: SET freeze_flag = 'Y',
3442: event_type_code = p_event_class_rec.event_type_code,
3443: tax_event_type_code = p_event_class_rec.tax_event_type_code
3444: WHERE tax_line_id IN (SELECT tax_line_id
3445: FROM zx_rec_nrec_dist
3446: WHERE rec_nrec_tax_dist_id IN
3447: (SELECT TAX_DIST_ID FROM ZX_TAX_DIST_ID_GT)
3448: )
3449: AND application_id = p_event_class_rec.application_id;

Line 3457: FROM ZX_REC_NREC_DIST ZD ,

3453: event_type_code = p_event_class_rec.event_type_code,
3454: tax_event_type_code = p_event_class_rec.tax_event_type_code,
3455: doc_event_status = p_event_class_rec.doc_status_code
3456: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
3457: FROM ZX_REC_NREC_DIST ZD ,
3458: ZX_TAX_DIST_ID_GT ZGT
3459: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID);
3460:
3461: -- Bug 6456915: Associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 3475: FROM ZX_REC_NREC_DIST ZD ,

3471: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
3472: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3473: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
3474: AND TRX_ID IN(SELECT ZD.trx_id
3475: FROM ZX_REC_NREC_DIST ZD ,
3476: ZX_TAX_DIST_ID_GT ZGT
3477: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID);
3478:
3479: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN

Line 3685: FROM zx_rec_nrec_dist

3681: CURSOR get_max_tax_dist_num_csr(
3682: c_tax_line_id NUMBER,
3683: c_trx_line_dist_id NUMBER) IS
3684: SELECT max(rec_nrec_tax_dist_number)
3685: FROM zx_rec_nrec_dist
3686: WHERE tax_line_id = c_tax_line_id
3687: AND trx_line_dist_id = c_trx_line_dist_id;
3688:
3689: CURSOR get_tax_dists_csr IS

Line 3696: FROM zx_rec_nrec_dist zd

3692: trx_line_dist_id,
3693: rec_nrec_tax_dist_number,
3694: internal_organization_id,
3695: gl_date
3696: FROM zx_rec_nrec_dist zd
3697: WHERE zd.trx_id = p_event_class_rec.trx_id
3698: AND zd.application_id = p_event_class_rec.application_id
3699: AND zd.entity_code = p_event_class_rec.entity_code
3700: AND zd.event_class_code = p_event_class_rec.event_class_code

Line 3838: INSERT INTO ZX_REC_NREC_DIST(

3834: END LOOP;
3835:
3836: FORALL i IN l_rec_nrec_tax_dist_id_tbl.FIRST .. l_rec_nrec_tax_dist_id_tbl.LAST
3837:
3838: INSERT INTO ZX_REC_NREC_DIST(
3839: REC_NREC_TAX_DIST_ID,
3840: APPLICATION_ID,
3841: ENTITY_CODE,
3842: EVENT_CLASS_CODE,

Line 4008: SELECT ZX_REC_NREC_DIST_S.NEXTVAL, -- REC_NREC_TAX_DIST_ID,

4004: INTERNAL_ORGANIZATION_ID,
4005: DEF_REC_SETTLEMENT_OPTION_CODE,
4006: TAX_JURISDICTION_ID,
4007: ACCOUNT_SOURCE_TAX_RATE_ID)
4008: SELECT ZX_REC_NREC_DIST_S.NEXTVAL, -- REC_NREC_TAX_DIST_ID,
4009: ZD.APPLICATION_ID,
4010: ZD.ENTITY_CODE,
4011: ZD.EVENT_CLASS_CODE,
4012: ZD.EVENT_TYPE_CODE,

Line 4177: FROM ZX_REC_NREC_DIST ZD

4173: ZD.INTERNAL_ORGANIZATION_ID,
4174: ZD.DEF_REC_SETTLEMENT_OPTION_CODE,
4175: ZD.TAX_JURISDICTION_ID,
4176: ZD.ACCOUNT_SOURCE_TAX_RATE_ID
4177: FROM ZX_REC_NREC_DIST ZD
4178: WHERE rec_nrec_tax_dist_id = l_rec_nrec_tax_dist_id_tbl(i);
4179:
4180: l_row_count := SQL%ROWCOUNT;
4181:

Line 4185: 'Number of rows created in zx_rec_nrec_dist = '||l_row_count);

4181:
4182: IF (g_level_statement >= g_current_runtime_level ) THEN
4183: FND_LOG.STRING(g_level_statement,
4184: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
4185: 'Number of rows created in zx_rec_nrec_dist = '||l_row_count);
4186: END IF;
4187:
4188: FORALL i IN NVL(l_rec_nrec_tax_dist_id_tbl.FIRST, 0) ..
4189: NVL(l_rec_nrec_tax_dist_id_tbl.LAST, -1)

Line 4190: UPDATE zx_rec_nrec_dist

4186: END IF;
4187:
4188: FORALL i IN NVL(l_rec_nrec_tax_dist_id_tbl.FIRST, 0) ..
4189: NVL(l_rec_nrec_tax_dist_id_tbl.LAST, -1)
4190: UPDATE zx_rec_nrec_dist
4191: SET reverse_flag = 'Y'
4192: WHERE rec_nrec_tax_dist_id = l_rec_nrec_tax_dist_id_tbl(i);
4193:
4194: l_row_count := SQL%ROWCOUNT;

Line 4199: 'Number of rows updated in zx_rec_nrec_dist = '||l_row_count);

4195:
4196: IF (g_level_statement >= g_current_runtime_level ) THEN
4197: FND_LOG.STRING(g_level_statement,
4198: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
4199: 'Number of rows updated in zx_rec_nrec_dist = '||l_row_count);
4200: END IF;
4201:
4202: END IF; -- _rec_nrec_tax_dist_id_tbl.COUNT > 0
4203:

Line 4208: * 'Update ZX_REC_NREC_DIST set reverse flag to Y (+)');

4204: /*
4205: * IF (g_level_procedure >= g_current_runtime_level ) THEN
4206: * FND_LOG.STRING(g_level_procedure,
4207: * 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
4208: * 'Update ZX_REC_NREC_DIST set reverse flag to Y (+)');
4209: * END IF;
4210: *
4211: * UPDATE ZX_REC_NREC_DIST
4212: * SET Reverse_Flag = 'Y'

Line 4211: * UPDATE ZX_REC_NREC_DIST

4207: * 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
4208: * 'Update ZX_REC_NREC_DIST set reverse flag to Y (+)');
4209: * END IF;
4210: *
4211: * UPDATE ZX_REC_NREC_DIST
4212: * SET Reverse_Flag = 'Y'
4213: * WHERE APPLICATION_ID = p_event_class_rec.application_id
4214: * AND ENTITY_CODE = p_event_class_rec.entity_code
4215: * AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code

Line 4223: * 'Update ZX_REC_NREC_DIST set reverse flag to Y (-)');

4219: *
4220: * IF (g_level_procedure >= g_current_runtime_level ) THEN
4221: * FND_LOG.STRING(g_level_procedure,
4222: * 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
4223: * 'Update ZX_REC_NREC_DIST set reverse flag to Y (-)');
4224: * END IF;
4225: */
4226:
4227: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4271: UPDATE zx_rec_nrec_dist

4267:
4268: -- Initialize API return status to success
4269: x_return_status := FND_API.G_RET_STS_SUCCESS;
4270:
4271: UPDATE zx_rec_nrec_dist
4272: SET gl_date = p_gl_date,
4273: orig_gl_date = gl_date
4274: WHERE rec_nrec_tax_dist_id IN
4275: (SELECT tax_dist_id FROM zx_tax_dist_id_gt);

Line 4338: FROM ZX_REC_NREC_DIST D

4334: SUM(decode(Recoverable_Flag,
4335: 'N',
4336: rec_nrec_tax_amt_funcl_curr)
4337: ) nrec_tax_amt_funcl_curr
4338: FROM ZX_REC_NREC_DIST D
4339: WHERE L.tax_line_id = D.tax_line_id
4340: AND L.application_id = D.application_id
4341: AND L.entity_code = D.entity_code
4342: AND L.event_class_code = D.event_class_code