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_LINES

Line 131: | PROCEDURE Create_Detail_Lines : Insert tax lines into ZX_LINES table. |

127: p_event_class_code IN VARCHAR2,
128: p_trx_id IN NUMBER);
129:
130: /* ===========================================================================*
131: | PROCEDURE Create_Detail_Lines : Insert tax lines into ZX_LINES table. |
132: * ===========================================================================*/
133:
134: PROCEDURE Create_Detail_Lines (
135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

Line 183: -- Check : Trx Line should exist in ZX_Lines_Det_Factors --

179: l_trx_line_exist := 'N';
180:
181: -- Run the preventive check for Payables only Application_Id 200
182: IF p_event_class_rec.application_id = 200 THEN
183: -- Check : Trx Line should exist in ZX_Lines_Det_Factors --
184: IF (g_level_statement >= g_current_runtime_level ) THEN
185: FND_LOG.STRING(g_level_statement,
186: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines',
187: 'Executing Trx Line Exists Validation : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MM:SS'));

Line 199: FROM zx_lines_det_factors zldf

195: INTO l_trx_line_exist,
196: l_trx_id
197: FROM zx_detail_tax_lines_gt zlgt
198: WHERE NOT EXISTS (SELECT /*first_rows(1)*/ 1
199: FROM zx_lines_det_factors zldf
200: WHERE zldf.application_id = zlgt.application_id
201: AND zldf.entity_code = zlgt.entity_code
202: AND zldf.event_class_code = zlgt.event_class_code
203: AND zldf.trx_id = zlgt.trx_id

Line 243: INSERT INTO ZX_LINES (TAX_LINE_ID,

239:
240: END IF; -- application_id = 200
241: -- End : Preventive check added to avoid data corruption --
242:
243: INSERT INTO ZX_LINES (TAX_LINE_ID,
244: INTERNAL_ORGANIZATION_ID,
245: APPLICATION_ID,
246: ENTITY_CODE,
247: EVENT_CLASS_CODE,

Line 937: -- set SUMMARY_TAX_LINE_ID to NULL in ZX_LINES for

933:
934: -- Set summary_tax_line id to Null for unfrozen tax lines who share the same
935: -- summary tax_line id as the one who has associated children frozen flag as 'Y'.
936: --
937: -- set SUMMARY_TAX_LINE_ID to NULL in ZX_LINES for
938: -- those tax lines have Associated_Child_Frozen_Flag = 'N'
939: -- belonged to the same summary line
940: --
941:

Line 943: /* UPDATE ZX_LINES

939: -- belonged to the same summary line
940: --
941:
942: -- Performance Bug 5908610 - Query has been modified
943: /* UPDATE ZX_LINES
944: SET SUMMARY_TAX_LINE_ID = NULL
945: WHERE SUMMARY_TAX_LINE_ID IN
946: (SELECT summary_tax_line_id
947: FROM ZX_LINES

Line 947: FROM ZX_LINES

943: /* UPDATE ZX_LINES
944: SET SUMMARY_TAX_LINE_ID = NULL
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))

Line 958: UPDATE ZX_LINES

954: */
955:
956: -- NEW query for the above
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

Line 1021: | PROCEDURE Delete_Detail_TaxLines: Deletes the transaction from ZX_LINES for|

1017: END IF;
1018: END Summarization_For_Freeze_Event;
1019:
1020: /*============================================================================*
1021: | PROCEDURE Delete_Detail_TaxLines: Deletes the transaction from ZX_LINES for|
1022: | given transaction details |
1023: *============================================================================*/
1024:
1025: PROCEDURE Delete_Detail_Lines

Line 1052: DELETE FROM ZX_LINES

1048: -- IF p_event_class_rec.tax_event_type_code = 'UPDATE' THEN
1049: IF ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag = 'Y' THEN
1050:
1051: /* -- rewrote for bug fix 5417887
1052: DELETE FROM ZX_LINES
1053: WHERE APPLICATION_ID = p_event_class_rec.application_id
1054: AND ENTITY_CODE = p_event_class_rec.entity_code
1055: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
1056: AND TRX_ID = p_event_class_rec.trx_id

Line 1060: FROM zx_lines_det_factors

1056: AND TRX_ID = p_event_class_rec.trx_id
1057: AND (DELETE_FLAG = 'Y' OR
1058: (TRX_LINE_ID, trx_level_type) IN
1059: (SELECT TRX_LINE_ID, trx_level_type
1060: FROM zx_lines_det_factors
1061: WHERE application_id = p_event_class_rec.application_id
1062: AND entity_code = p_event_class_rec.entity_code
1063: AND event_class_code = p_event_class_rec.event_class_code
1064: AND trx_id = p_event_class_rec.trx_id

Line 1070: DELETE FROM ZX_LINES tax

1066: AND line_level_action NOT IN ('SYNCHRONIZE', 'NO_CHANGE')
1067: )
1068: ); */
1069: -- bug fix 5417887
1070: DELETE FROM ZX_LINES tax
1071: WHERE EXISTS (SELECT 1
1072: FROM zx_lines_det_factors
1073: WHERE application_id = tax.application_id
1074: AND entity_code = tax.entity_code

Line 1072: FROM zx_lines_det_factors

1068: ); */
1069: -- bug fix 5417887
1070: DELETE FROM ZX_LINES tax
1071: WHERE EXISTS (SELECT 1
1072: FROM zx_lines_det_factors
1073: WHERE application_id = tax.application_id
1074: AND entity_code = tax.entity_code
1075: AND event_class_code = tax.event_class_code
1076: AND trx_id = tax.trx_id

Line 1082: FROM zx_lines_det_factors

1078: )
1079: AND (tax.DELETE_FLAG = 'Y' OR
1080: (tax.TRX_LINE_ID, tax.trx_level_type) IN
1081: (SELECT TRX_LINE_ID, trx_level_type
1082: FROM zx_lines_det_factors
1083: WHERE application_id = tax.application_id
1084: AND entity_code = tax.entity_code
1085: AND event_class_code = tax.event_class_code
1086: AND trx_id = tax.trx_id

Line 1096: DELETE FROM zx_lines

1092: l_row_count := SQL%ROWCOUNT;
1093:
1094: ELSIF p_event_class_rec.tax_event_type_code = 'OVERRIDE_TAX' THEN
1095:
1096: DELETE FROM zx_lines
1097: WHERE application_id = p_event_class_rec.application_id
1098: AND entity_code = p_event_class_rec.entity_code
1099: AND event_class_code = p_event_class_rec.event_class_code
1100: AND trx_id = p_event_class_rec.trx_id

Line 1118: DELETE FROM zx_lines

1114:
1115: IF p_event_class_rec.allow_offset_tax_calc_flag ='Y' THEN
1116: -- delete old offset tax lines
1117: --
1118: DELETE FROM zx_lines
1119: WHERE application_id = p_event_class_rec.application_id
1120: AND entity_code = p_event_class_rec.entity_code
1121: AND event_class_code = p_event_class_rec.event_class_code
1122: AND trx_id = p_event_class_rec.trx_id

Line 1142: DELETE FROM zx_lines zl

1138: --
1139: -- Delete old MRC related detail tax lines
1140: --
1141: IF p_event_class_rec.enable_mrc_flag = 'Y' THEN
1142: DELETE FROM zx_lines zl
1143: WHERE application_id = p_event_class_rec.application_id
1144: AND entity_code = p_event_class_rec.entity_code
1145: AND event_class_code = p_event_class_rec.event_class_code
1146: AND trx_id = p_event_class_rec.trx_id

Line 1193: | ZX_LINES_SUMMARY for a given transaction details |

1189: END Delete_Detail_Lines;
1190:
1191: /* ===========================================================================*
1192: | PROCEDURE Delete_Summary_TaxLines: Deletes the transaction from |
1193: | ZX_LINES_SUMMARY for a given transaction details |
1194: * ===========================================================================*/
1195: PROCEDURE Delete_Summary_Lines
1196: (x_return_status OUT NOCOPY VARCHAR2,
1197: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

Line 1220: DELETE FROM ZX_LINES_SUMMARY

1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:
1218: -- rewrote the following query for bug fix 5417887
1219: /*
1220: DELETE FROM ZX_LINES_SUMMARY
1221: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1222: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1223: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1224: AND TRX_ID = p_event_class_rec.TRX_ID;

Line 1227: DELETE FROM zx_lines_summary tax

1223: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1224: AND TRX_ID = p_event_class_rec.TRX_ID;
1225: */
1226:
1227: DELETE FROM zx_lines_summary tax
1228: WHERE EXISTS (SELECT 1
1229: FROM zx_lines_det_factors line
1230: WHERE tax.application_id = line.application_id
1231: AND tax.event_class_code = line.event_class_code

Line 1229: FROM zx_lines_det_factors line

1225: */
1226:
1227: DELETE FROM zx_lines_summary tax
1228: WHERE EXISTS (SELECT 1
1229: FROM zx_lines_det_factors line
1230: WHERE tax.application_id = line.application_id
1231: AND tax.event_class_code = line.event_class_code
1232: AND tax.entity_code = line.entity_code
1233: AND tax.trx_id = line.trx_id

Line 1385: (SELECT ZX_LINES.TAX_LINE_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
1384: AND TAX_LINE_ID NOT IN
1385: (SELECT ZX_LINES.TAX_LINE_ID
1386: FROM ZX_LINES
1387: WHERE zx_lines.application_id = p_event_class_rec.application_id
1388: AND zx_lines.entity_code = p_event_class_rec.entity_code
1389: AND zx_lines.event_class_code = p_event_class_rec.event_class_code

Line 1386: FROM ZX_LINES

1382: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
1383: AND TRX_ID = p_event_class_rec.trx_id
1384: AND TAX_LINE_ID NOT IN
1385: (SELECT ZX_LINES.TAX_LINE_ID
1386: FROM ZX_LINES
1387: WHERE zx_lines.application_id = p_event_class_rec.application_id
1388: AND zx_lines.entity_code = p_event_class_rec.entity_code
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);

Line 1387: WHERE zx_lines.application_id = p_event_class_rec.application_id

1383: AND TRX_ID = p_event_class_rec.trx_id
1384: AND TAX_LINE_ID NOT IN
1385: (SELECT ZX_LINES.TAX_LINE_ID
1386: FROM ZX_LINES
1387: WHERE zx_lines.application_id = p_event_class_rec.application_id
1388: AND zx_lines.entity_code = p_event_class_rec.entity_code
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: */

Line 1388: AND zx_lines.entity_code = p_event_class_rec.entity_code

1384: AND TAX_LINE_ID NOT IN
1385: (SELECT ZX_LINES.TAX_LINE_ID
1386: FROM ZX_LINES
1387: WHERE zx_lines.application_id = p_event_class_rec.application_id
1388: AND zx_lines.entity_code = p_event_class_rec.entity_code
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:

Line 1389: AND zx_lines.event_class_code = p_event_class_rec.event_class_code

1385: (SELECT ZX_LINES.TAX_LINE_ID
1386: FROM ZX_LINES
1387: WHERE zx_lines.application_id = p_event_class_rec.application_id
1388: AND zx_lines.entity_code = p_event_class_rec.entity_code
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

Line 1390: AND zx_lines.trx_id = p_event_class_rec.trx_id);

1386: FROM ZX_LINES
1387: WHERE zx_lines.application_id = p_event_class_rec.application_id
1388: AND zx_lines.entity_code = p_event_class_rec.entity_code
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 (

Line 1396: FROM zx_lines_det_factors

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
1398: AND entity_code = dist.entity_code
1399: AND event_class_code = dist.event_class_code
1400: AND trx_id = dist.trx_id

Line 1404: FROM zx_lines zx_lines

1400: AND trx_id = dist.trx_id
1401: AND event_id = p_event_class_rec.event_id )
1402: AND tax_line_id NOT IN
1403: (SELECT tax_line_id
1404: FROM zx_lines zx_lines
1405: WHERE zx_lines.application_id = dist.application_id
1406: AND zx_lines.entity_code = dist.entity_code
1407: AND zx_lines.event_class_code = dist.event_class_code
1408: AND zx_lines.trx_id = dist.trx_id);

Line 1405: WHERE zx_lines.application_id = dist.application_id

1401: AND event_id = p_event_class_rec.event_id )
1402: AND tax_line_id NOT IN
1403: (SELECT tax_line_id
1404: FROM zx_lines zx_lines
1405: WHERE zx_lines.application_id = dist.application_id
1406: AND zx_lines.entity_code = dist.entity_code
1407: AND zx_lines.event_class_code = dist.event_class_code
1408: AND zx_lines.trx_id = dist.trx_id);
1409:

Line 1406: AND zx_lines.entity_code = dist.entity_code

1402: AND tax_line_id NOT IN
1403: (SELECT tax_line_id
1404: FROM zx_lines zx_lines
1405: WHERE zx_lines.application_id = dist.application_id
1406: AND zx_lines.entity_code = dist.entity_code
1407: AND zx_lines.event_class_code = dist.event_class_code
1408: AND zx_lines.trx_id = dist.trx_id);
1409:
1410: l_row_count := SQL%ROWCOUNT;

Line 1407: AND zx_lines.event_class_code = dist.event_class_code

1403: (SELECT tax_line_id
1404: FROM zx_lines zx_lines
1405: WHERE zx_lines.application_id = dist.application_id
1406: AND zx_lines.entity_code = dist.entity_code
1407: AND zx_lines.event_class_code = dist.event_class_code
1408: AND zx_lines.trx_id = dist.trx_id);
1409:
1410: l_row_count := SQL%ROWCOUNT;
1411:

Line 1408: AND zx_lines.trx_id = dist.trx_id);

1404: FROM zx_lines zx_lines
1405: WHERE zx_lines.application_id = dist.application_id
1406: AND zx_lines.entity_code = dist.entity_code
1407: AND zx_lines.event_class_code = dist.event_class_code
1408: AND zx_lines.trx_id = dist.trx_id);
1409:
1410: l_row_count := SQL%ROWCOUNT;
1411:
1412: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1604: FROM zx_lines

1600: AND NVL(freeze_flag, 'N') = 'N'
1601: AND NVL(reverse_flag, 'N') = 'N'
1602: AND tax_line_id IN
1603: (SELECT tax_line_id
1604: FROM zx_lines
1605: WHERE trx_id = p_event_class_rec.trx_id
1606: AND application_id = p_event_class_rec.application_id
1607: AND entity_code = p_event_class_rec.entity_code
1608: AND event_class_code = p_event_class_rec.event_class_code

Line 1667: FROM ZX_LINES

1663:
1664: -- This cursor will check if any tax lines has frozen distributions
1665: CURSOR check_frozen_child IS
1666: SELECT TAX_LINE_ID
1667: FROM ZX_LINES
1668: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1669: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1670: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1671: AND TRX_ID = p_event_class_rec.TRX_ID

Line 1674: l_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;

1670: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1671: AND TRX_ID = p_event_class_rec.TRX_ID
1672: AND Associated_Child_Frozen_Flag = 'Y';
1673:
1674: l_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;
1675:
1676: BEGIN
1677:
1678: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1732: DELETE FROM ZX_LINES

1728: END IF;
1729: CLOSE check_frozen_child;
1730: END IF;
1731:
1732: DELETE FROM ZX_LINES
1733: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1734: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1735: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1736: AND TRX_ID = p_event_class_rec.TRX_ID;

Line 1741: 'Number of rows deleted from zx_lines = '||l_row_count);

1737:
1738: IF (g_level_statement >= g_current_runtime_level ) THEN
1739: FND_LOG.STRING(g_level_statement,
1740: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Transaction',
1741: 'Number of rows deleted from zx_lines = '||l_row_count);
1742: END IF;
1743:
1744: IF p_event_class_rec.summarization_flag = 'Y' THEN
1745: -- Delete the summary lines

Line 1747: DELETE FROM ZX_LINES_SUMMARY

1743:
1744: IF p_event_class_rec.summarization_flag = 'Y' THEN
1745: -- Delete the summary lines
1746:
1747: DELETE FROM ZX_LINES_SUMMARY
1748: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1749: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1750: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1751: AND TRX_ID = p_event_class_rec.TRX_ID;

Line 1756: 'Number of rows deleted from zx_lines_summary = '||l_row_count);

1752:
1753: IF (g_level_statement >= g_current_runtime_level ) THEN
1754: FND_LOG.STRING(g_level_statement,
1755: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Transaction',
1756: 'Number of rows deleted from zx_lines_summary = '||l_row_count);
1757: END IF;
1758:
1759: END IF;
1760:

Line 1885: UPDATE ZX_LINES

1881:
1882: -- Initialize API return status to success
1883: x_return_status := FND_API.G_RET_STS_SUCCESS;
1884:
1885: UPDATE ZX_LINES
1886: SET Cancel_Flag = 'Y'
1887: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1888: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1889: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE

Line 1899: 'Number of rows updated in zx_lines = '||l_row_count);

1895:
1896: IF (g_level_statement >= g_current_runtime_level ) THEN
1897: FND_LOG.STRING(g_level_statement,
1898: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Cancel_Transaction',
1899: 'Number of rows updated in zx_lines = '||l_row_count);
1900: END IF;
1901:
1902: IF p_event_class_rec.summarization_flag = 'Y' THEN
1903:

Line 1904: UPDATE ZX_LINES_SUMMARY

1900: END IF;
1901:
1902: IF p_event_class_rec.summarization_flag = 'Y' THEN
1903:
1904: UPDATE ZX_LINES_SUMMARY
1905: SET Cancel_Flag = 'Y'
1906: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1907: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1908: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE

Line 1916: 'Number of rows updated in zx_lines_summary = '||l_row_count);

1912:
1913: IF (g_level_statement >= g_current_runtime_level ) THEN
1914: FND_LOG.STRING(g_level_statement,
1915: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Cancel_Transaction',
1916: 'Number of rows updated in zx_lines_summary = '||l_row_count);
1917: END IF;
1918:
1919: END IF;
1920:

Line 2499: UPDATE ZX_LINES

2495: APP_EXCEPTION.Raise_Exception;
2496: RAISE FND_API.G_EXC_ERROR;
2497: END IF;
2498:
2499: UPDATE ZX_LINES
2500: SET Delete_Flag = 'Y'
2501: WHERE APPLICATION_ID = p_transaction_line_rec.APPLICATION_ID
2502: AND ENTITY_CODE = p_transaction_line_rec.ENTITY_CODE
2503: AND EVENT_CLASS_CODE = p_transaction_line_rec.EVENT_CLASS_CODE

Line 2513: 'Number of rows updated in zx_lines = '||l_row_count);

2509:
2510: IF (g_level_statement >= g_current_runtime_level ) THEN
2511: FND_LOG.STRING(g_level_statement,
2512: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Mark_Detail_Tax_Lines_Delete',
2513: 'Number of rows updated in zx_lines = '||l_row_count);
2514: END IF;
2515:
2516: IF (g_level_procedure >= g_current_runtime_level ) THEN
2517: FND_LOG.STRING(g_level_procedure,

Line 2954: UPDATE zx_lines

2950: 'Number of Rows Inserted: '||SQL%ROWCOUNT);
2951: END IF;
2952:
2953: BEGIN
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

Line 3090: -- FROM ZX_LINES L

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
3092: -- AND ENTITY_CODE = p_event_class_rec.entity_code
3093: -- AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3094: -- AND (Process_For_Recovery_Flag = 'Y' OR

Line 3098: -- FROM zx_lines_det_factors

3094: -- AND (Process_For_Recovery_Flag = 'Y' OR
3095: -- Item_Dist_Changed_Flag = 'Y')
3096: -- AND EXISTS
3097: -- (SELECT 1
3098: -- FROM zx_lines_det_factors
3099: -- WHERE APPLICATION_ID = L.application_id
3100: -- AND ENTITY_CODE = L.entity_code
3101: -- AND EVENT_CLASS_CODE = L.event_class_code
3102: -- AND TRX_ID = L.trx_id

Line 3115: (SELECT /+ use_hash(ZX_LINES_DET_FACTORS) / TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE

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
3114: AND (trx_id, trx_line_id, trx_level_type) IN
3115: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3116: FROM zx_lines_det_factors
3117: WHERE application_id = p_event_class_rec.application_id
3118: AND entity_code = p_event_class_rec.entity_code
3119: AND event_class_code = p_event_class_rec.event_class_code

Line 3116: FROM zx_lines_det_factors

3112: AND entity_code = p_event_class_rec.entity_code
3113: AND event_class_code = p_event_class_rec.event_class_code
3114: AND (trx_id, trx_line_id, trx_level_type) IN
3115: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3116: FROM zx_lines_det_factors
3117: WHERE application_id = p_event_class_rec.application_id
3118: AND entity_code = p_event_class_rec.entity_code
3119: AND event_class_code = p_event_class_rec.event_class_code
3120: AND event_id = p_event_class_rec.event_id

Line 3123: (SELECT 1 FROM zx_lines

3119: AND event_class_code = p_event_class_rec.event_class_code
3120: AND event_id = p_event_class_rec.event_id
3121: )
3122: AND EXISTS
3123: (SELECT 1 FROM zx_lines
3124: WHERE tax_line_id = dist.tax_line_id
3125: AND (Process_For_Recovery_Flag = 'Y' OR
3126: Item_Dist_Changed_Flag = 'Y'));
3127:

Line 3143: FROM zx_lines

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
3145: AND tax_line_number <> zd.tax_line_number
3146: )
3147: WHERE NVL(reverse_flag,'N') = 'Y'

Line 3152: (SELECT /+ use_hash(ZX_LINES_DET_FACTORS) / TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE

3148: AND application_id = p_event_class_rec.application_id
3149: AND entity_code = p_event_class_rec.entity_code
3150: AND event_class_code = p_event_class_rec.event_class_code
3151: AND (trx_id, trx_line_id, trx_level_type) IN
3152: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3153: FROM zx_lines_det_factors
3154: WHERE application_id = p_event_class_rec.application_id
3155: AND entity_code = p_event_class_rec.entity_code
3156: AND event_class_code = p_event_class_rec.event_class_code

Line 3153: FROM zx_lines_det_factors

3149: AND entity_code = p_event_class_rec.entity_code
3150: AND event_class_code = p_event_class_rec.event_class_code
3151: AND (trx_id, trx_line_id, trx_level_type) IN
3152: (SELECT /*+ use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE
3153: FROM zx_lines_det_factors
3154: WHERE application_id = p_event_class_rec.application_id
3155: AND entity_code = p_event_class_rec.entity_code
3156: AND event_class_code = p_event_class_rec.event_class_code
3157: AND event_id = p_event_class_rec.event_id

Line 3161: FROM zx_lines

3157: AND event_id = p_event_class_rec.event_id
3158: )
3159: AND EXISTS
3160: (SELECT tax_line_number
3161: FROM zx_lines
3162: WHERE tax_line_id = zd.tax_line_id
3163: AND tax_line_number <> zd.tax_line_number
3164: );
3165:

Line 3192: FROM zx_lines zl

3188: )
3189: WHERE reverse_flag = 'Y'
3190: AND EXISTS
3191: (SELECT 'x'
3192: FROM zx_lines zl
3193: WHERE zl.tax_line_id = zd.tax_line_id
3194: AND application_id = p_event_class_rec.application_id
3195: AND entity_code = p_event_class_rec.entity_code
3196: AND event_class_code = p_event_class_rec.event_class_code

Line 3201: FROM zx_lines_det_factors

3197: AND (process_for_recovery_flag = 'Y' OR
3198: item_dist_changed_flag = 'Y')
3199: AND EXISTS
3200: (SELECT 1
3201: FROM zx_lines_det_factors
3202: WHERE application_id = zl.application_id
3203: AND entity_code = zl.entity_code
3204: AND event_class_code = zl.event_class_code
3205: AND trx_id = zl.trx_id

Line 3288: from zx_lines_det_factors

3284: x_return_status := FND_API.G_RET_STS_SUCCESS;
3285:
3286: select trx_id, trx_line_id, trx_level_type
3287: bulk collect into pg_trx_id_tab, pg_trx_line_id_tab ,pg_trx_level_type_tab
3288: from zx_lines_det_factors
3289: where application_id = p_event_class_rec.application_id
3290: and entity_code = p_event_class_rec.entity_code
3291: and event_class_code = p_event_class_rec.event_class_code
3292: and event_id = p_event_class_rec.event_id;

Line 3295: UPDATE ZX_LINES L

3291: and event_class_code = p_event_class_rec.event_class_code
3292: and event_id = p_event_class_rec.event_id;
3293:
3294: FORALL i in nvl(pg_trx_id_tab.FIRST,0)..nvl(pg_trx_id_tab.LAST,-99)
3295: UPDATE ZX_LINES L
3296: SET (rec_tax_amt,
3297: rec_tax_amt_tax_curr,
3298: rec_tax_amt_funcl_curr,
3299: nrec_tax_amt,

Line 3326: ( select 1 from zx_lines_det_factors

3322: WHERE application_id = p_event_class_rec.application_id
3323: AND entity_code = p_event_class_rec.entity_code
3324: AND event_class_code = p_event_class_rec.event_class_code
3325: /*AND exists
3326: ( select 1 from zx_lines_det_factors
3327: where application_id = l.application_id
3328: and entity_code = l.entity_code
3329: and event_class_code = l.event_class_code
3330: and trx_id = l.trx_id

Line 3341: UPDATE ZX_LINES_SUMMARY S

3337: AND trx_level_type = pg_trx_level_type_tab(i);
3338:
3339: IF p_event_class_rec.summarization_flag = 'Y' THEN
3340:
3341: UPDATE ZX_LINES_SUMMARY S
3342: SET (total_rec_tax_amt,
3343: total_nrec_tax_amt,
3344: total_rec_tax_amt_funcl_curr,
3345: total_nrec_tax_amt_funcl_curr,

Line 3356: FROM ZX_LINES L

3352: SUM(rec_tax_amt_funcl_curr) total_rec_tax_amt_funcl_curr,
3353: SUM(nrec_tax_amt_funcl_curr) total_nrec_tax_amt_funcl_curr,
3354: SUM(rec_tax_amt_tax_curr) total_rec_tax_amt_tax_curr,
3355: SUM(nrec_tax_amt_tax_curr) total_nrec_tax_amt_tax_curr
3356: FROM ZX_LINES L
3357: WHERE L.summary_tax_line_id = S.summary_tax_line_id
3358: AND L.application_id = S.application_id
3359: AND L.entity_code = S.entity_code
3360: AND L.event_class_code = S.event_class_code

Line 3367: ( select 1 from zx_lines_det_factors

3363: WHERE application_id = p_event_class_rec.application_id
3364: AND entity_code = p_event_class_rec.entity_code
3365: AND event_class_code = p_event_class_rec.event_class_code
3366: AND exists
3367: ( select 1 from zx_lines_det_factors
3368: where application_id = S.application_id
3369: and entity_code = S.entity_code
3370: and event_class_code = S.event_class_code
3371: and trx_id = S.trx_id

Line 3400: | Update_Freeze_Flag: Freezes distributions and updates ZX_LINES |

3396: END IF;
3397: END Update_TaxLine_Rec_Nrec_Amt;
3398:
3399: /*============================================================================*
3400: | Update_Freeze_Flag: Freezes distributions and updates ZX_LINES |
3401: | Associated_Child_Frozen_Flag flag to indicate that the associated |
3402: | children are frozen. |
3403: *============================================================================*/
3404:

Line 3451: UPDATE ZX_LINES ZL

3447: (SELECT TAX_DIST_ID FROM ZX_TAX_DIST_ID_GT)
3448: )
3449: AND application_id = p_event_class_rec.application_id;
3450:
3451: UPDATE ZX_LINES ZL
3452: SET Associated_Child_Frozen_Flag ='Y',
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

Line 3470: DELETE FROM ZX_LINES_SUMMARY

3466:
3467: --
3468: -- delete all summary tax lines for this document
3469: --
3470: DELETE FROM ZX_LINES_SUMMARY
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

Line 3488: -- create summary lines from zx_lines without

3484: p_event_class_rec,
3485: l_return_status);
3486: ELSE
3487: --
3488: -- create summary lines from zx_lines without
3489: -- retain the current summary_tax_line_id
3490: --
3491: create_summary_lines_upd_evnt(
3492: p_event_class_rec => p_event_class_rec,

Line 3596: | Update_Item_Dist_Changed_Flag: This procedure updates tax lines (ZX_LINES) |

3592: END IF;
3593: END Update_Freeze_Flag;
3594:
3595: /*============================================================================*
3596: | Update_Item_Dist_Changed_Flag: This procedure updates tax lines (ZX_LINES) |
3597: | with changed status for given transaction line distributions. |
3598: *============================================================================*/
3599:
3600: PROCEDURE Update_Item_Dist_Changed_Flag

Line 3619: UPDATE ZX_LINES ZL

3615:
3616: -- Initialize API return status to success
3617: x_return_status := FND_API.G_RET_STS_SUCCESS;
3618:
3619: UPDATE ZX_LINES ZL
3620: SET Item_Dist_Changed_Flag = 'Y'
3621: WHERE APPLICATION_ID = p_event_class_rec.application_id
3622: AND ENTITY_CODE = p_event_class_rec.entity_code
3623: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code

Line 3719: UPDATE ZX_LINES

3715:
3716: -- Initialize API return status to success
3717: x_return_status := FND_API.G_RET_STS_SUCCESS;
3718:
3719: UPDATE ZX_LINES
3720: SET ORIG_TAXABLE_AMT = NVL(orig_taxable_amt, taxable_amt),
3721: ORIG_TAXABLE_AMT_TAX_CURR = NVL(orig_taxable_amt_tax_curr, taxable_amt_tax_curr),
3722: ORIG_TAX_AMT = NVL(orig_tax_amt, tax_amt),
3723: ORIG_TAX_AMT_TAX_CURR = NVL(orig_tax_amt_tax_curr, tax_amt_tax_curr),

Line 3754: 'Number of rows updated in zx_lines = '||l_row_count);

3750:
3751: IF (g_level_statement >= g_current_runtime_level ) THEN
3752: FND_LOG.STRING(g_level_statement,
3753: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
3754: 'Number of rows updated in zx_lines = '||l_row_count);
3755: END IF;
3756:
3757: IF p_event_class_rec.summarization_flag = 'Y' THEN
3758:

Line 3759: UPDATE zx_lines_summary

3755: END IF;
3756:
3757: IF p_event_class_rec.summarization_flag = 'Y' THEN
3758:
3759: UPDATE zx_lines_summary
3760: SET TAX_AMT = 0,
3761: TAX_AMT_TAX_CURR = 0,
3762: TAX_AMT_FUNCL_CURR = 0,
3763: TOTAL_REC_TAX_AMT = 0,

Line 3780: 'Number of rows updated in zx_lines_summary = '||l_row_count);

3776:
3777: IF (g_level_statement >= g_current_runtime_level ) THEN
3778: FND_LOG.STRING(g_level_statement,
3779: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
3780: 'Number of rows updated in zx_lines_summary = '||l_row_count);
3781: END IF;
3782:
3783: END IF;
3784:

Line 4326: UPDATE ZX_LINES L

4322: x_return_status := FND_API.G_RET_STS_SUCCESS;
4323:
4324: IF p_event_class_rec.tax_recovery_flag = 'Y' THEN
4325:
4326: UPDATE ZX_LINES L
4327: SET (rec_tax_amt_funcl_curr,
4328: nrec_tax_amt_funcl_curr
4329: ) =
4330: (SELECT SUM(decode(Recoverable_Flag,

Line 4355: UPDATE ZX_LINES_SUMMARY S

4351: END IF;
4352:
4353: IF p_event_class_rec.summarization_flag = 'Y' THEN
4354:
4355: UPDATE ZX_LINES_SUMMARY S
4356: SET (tax_amt_funcl_curr,
4357: total_rec_tax_amt_funcl_curr,
4358: total_nrec_tax_amt_funcl_curr
4359: ) =

Line 4363: FROM ZX_LINES L

4359: ) =
4360: (SELECT SUM(L.tax_amt_funcl_curr) tax_amt_funcl_curr,
4361: SUM(rec_tax_amt_funcl_curr) total_rec_tax_amt_funcl_curr ,
4362: SUM(nrec_tax_amt_funcl_curr) total_nrec_tax_amt_funcl_curr
4363: FROM ZX_LINES L
4364: WHERE L.summary_tax_line_id = S.summary_tax_line_id
4365: AND L.application_id = S.application_id
4366: AND L.entity_code = S.entity_code
4367: AND L.event_class_code = S.event_class_code

Line 4403: | zx_lines_summary |

4399: /* ===========================================================================*
4400: | PROCEDURE update_exist_summary_line_id: |
4401: | Preserve old summary_tax_line_id in g_detail_tax_lines_gt for |
4402: | UPDATE case, if the same summarization criteria exists in |
4403: | zx_lines_summary |
4404: * ===========================================================================*/
4405: PROCEDURE update_exist_summary_line_id(
4406: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4407: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4433: FROM zx_lines_summary summ

4429: --
4430: UPDATE zx_detail_tax_lines_gt zlgt
4431: SET summary_tax_line_id =
4432: ( SELECT summary_tax_line_id
4433: FROM zx_lines_summary summ
4434: -- bug fix 5417887
4435: --WHERE summ.application_id = p_event_class_rec.application_id
4436: -- AND summ.entity_code = p_event_class_rec.entity_code
4437: -- AND summ.event_class_code = p_event_class_rec.event_class_code

Line 4534: | the document level by updating TAX_HOLD_RELEASED_CODE in zx_lines based on |

4530: END update_exist_summary_line_id;
4531:
4532: /* ===========================================================================*
4533: | PROCEDURE RELEASE_DOCUMENT_TAX_HOLD : public API to release the tax hold at|
4534: | the document level by updating TAX_HOLD_RELEASED_CODE in zx_lines based on |
4535: | the input release tax code table. |
4536: | Bug Fix: 3339364 by lxzhang |
4537: * ===========================================================================*/
4538:

Line 4572: UPDATE ZX_LINES

4568: l_tax_hold_release_mask := l_tax_hold_release_mask + l_tax_hold_release_value;
4569: END LOOP;
4570:
4571: -- update the tax_hold_release_code
4572: UPDATE ZX_LINES
4573: SET TAX_HOLD_RELEASED_CODE = BITAND(TAX_HOLD_CODE, l_tax_hold_release_mask )
4574: WHERE TAX_LINE_ID in (
4575: SELECT TAX_LINE_ID
4576: FROM ZX_LINES

Line 4576: FROM ZX_LINES

4572: UPDATE ZX_LINES
4573: SET TAX_HOLD_RELEASED_CODE = BITAND(TAX_HOLD_CODE, l_tax_hold_release_mask )
4574: WHERE TAX_LINE_ID in (
4575: SELECT TAX_LINE_ID
4576: FROM ZX_LINES
4577: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
4578: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
4579: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
4580: AND TRX_ID = p_event_class_rec.TRX_ID );

Line 4620: UPDATE ZX_LINES

4616: RETURN;
4617: END IF;
4618:
4619: -- update the tax_hold_release_code
4620: UPDATE ZX_LINES
4621: SET TAX_HOLD_RELEASED_CODE = BITAND(TAX_HOLD_CODE, l_tax_hold_release_mask )
4622: WHERE TAX_LINE_ID in (
4623: SELECT TAX_LINE_ID
4624: FROM ZX_LINES

Line 4624: FROM ZX_LINES

4620: UPDATE ZX_LINES
4621: SET TAX_HOLD_RELEASED_CODE = BITAND(TAX_HOLD_CODE, l_tax_hold_release_mask )
4622: WHERE TAX_LINE_ID in (
4623: SELECT TAX_LINE_ID
4624: FROM ZX_LINES
4625: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
4626: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
4627: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
4628: AND TRX_ID = p_event_class_rec.TRX_ID );

Line 4657: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt

4653: -- PRIVATE PROCEDURE
4654: -- create_summary_lines_crt_evnt
4655: --
4656: -- DESCRIPTION
4657: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
4658: -- for tax_event_type of 'CREATE' or for tax_event_type of 'UPDATE'/'OVERRIDE'
4659: -- with retain_summ_tax_line_id_flag on event_class_rec of 'N'
4660: ------------------------------------------------------------------------------
4661: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 4700: zx_lines_summary_s.NEXTVAL,

4696: entity_code,
4697: event_class_code,
4698: trx_id,
4699: internal_organization_id,
4700: zx_lines_summary_s.NEXTVAL,
4701: count_detail_tax_line,
4702: count_detail_cancel_flag,
4703: trx_number,
4704: applied_from_application_id,

Line 5218: INSERT INTO zx_lines_summary(

5214: WHERE tax_line_id = pg_tax_line_id_tbl(i);
5215:
5216: -- insert the newly created summary tax lines
5217: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT
5218: INSERT INTO zx_lines_summary(
5219: summary_tax_line_id,
5220: object_version_number,
5221: created_by,
5222: creation_date,

Line 5400: 'Number of Rows Inserted in zx_lines_summary = ' || to_char(SQL%ROWCOUNT));

5396: IF (g_level_statement >= g_current_runtime_level ) THEN
5397:
5398: FND_LOG.STRING(g_level_statement,
5399: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_summary_lines_crt_evnt',
5400: 'Number of Rows Inserted in zx_lines_summary = ' || to_char(SQL%ROWCOUNT));
5401: END IF;
5402:
5403: IF (g_level_procedure >= g_current_runtime_level ) THEN
5404:

Line 5428: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt

5424: -- PRIVATE PROCEDURE
5425: -- create_summary_lines_upd_evnt
5426: --
5427: -- DESCRIPTION
5428: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
5429: -- for tax_event_type of 'UPDATE' or 'OVERRIDE' with
5430: -- retain_summ_tax_line_id_flag on event_class_rec of 'Y'
5431: ------------------------------------------------------------------------------
5432: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 5479: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,

5475: event_class_code,
5476: trx_id,
5477: internal_organization_id,
5478: NVL(summary_tax_line_id,
5479: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
5480: count_detail_tax_line,
5481: count_detail_cancel_flag,
5482: trx_number,
5483: applied_from_application_id,

Line 5708: FROM ZX_LINES tax

5704: tax_exception_id,
5705: -- exception_rate,
5706: mrc_tax_line_flag,
5707: tax_only_line_flag
5708: FROM ZX_LINES tax
5709: WHERE -- bug fix 5417887
5710: -- application_id = p_event_class_rec.application_id
5711: -- AND entity_code = p_event_class_rec.entity_code
5712: -- AND event_class_code = p_event_class_rec.event_class_code

Line 5715: FROM zx_lines_det_factors line

5711: -- AND entity_code = p_event_class_rec.entity_code
5712: -- AND event_class_code = p_event_class_rec.event_class_code
5713: -- AND trx_id = p_event_class_rec.trx_id
5714: EXISTS (SELECT 1
5715: FROM zx_lines_det_factors line
5716: WHERE tax.application_id = line.application_id
5717: AND tax.event_class_code = line.event_class_code
5718: AND tax.entity_code = line.entity_code
5719: AND tax.trx_id = line.trx_id

Line 5853: FROM zx_lines tax

5849: tax_only_line_flag );
5850:
5851: -- get the tax line id in the same order of the summary tax line as in the first query.
5852: SELECT tax_line_id BULK COLLECT INTO pg_tax_line_id_tbl
5853: FROM zx_lines tax
5854: -- bug fix 5417887
5855: -- WHERE application_id = p_event_class_rec.application_id
5856: -- AND entity_code = p_event_class_rec.entity_code
5857: -- AND event_class_code = p_event_class_rec.event_class_code

Line 5861: FROM zx_lines_det_factors line

5857: -- AND event_class_code = p_event_class_rec.event_class_code
5858: -- AND trx_id = p_event_class_rec.trx_id
5859: WHERE EXISTS (
5860: SELECT 1
5861: FROM zx_lines_det_factors line
5862: WHERE tax.application_id = line.application_id
5863: AND tax.event_class_code = line.event_class_code
5864: AND tax.entity_code = line.entity_code
5865: AND tax.trx_id = line.trx_id

Line 5942: zx_lines_summary_s.NEXTVAL,

5938: entity_code,
5939: event_class_code,
5940: trx_id,
5941: internal_organization_id,
5942: zx_lines_summary_s.NEXTVAL,
5943: count_detail_tax_line,
5944: count_detail_cancel_flag,
5945: trx_number,
5946: applied_from_application_id,

Line 6171: FROM ZX_LINES tax

6167: tax_exception_id,
6168: -- exception_rate,
6169: mrc_tax_line_flag,
6170: tax_only_line_flag
6171: FROM ZX_LINES tax
6172: -- bug fix 5417887
6173: -- WHERE application_id = p_event_class_rec.application_id
6174: -- AND entity_code = p_event_class_rec.entity_code
6175: -- AND event_class_code = p_event_class_rec.event_class_code

Line 6179: FROM zx_lines_det_factors line

6175: -- AND event_class_code = p_event_class_rec.event_class_code
6176: -- AND trx_id = p_event_class_rec.trx_id
6177: WHERE EXISTS (
6178: SELECT 1
6179: FROM zx_lines_det_factors line
6180: WHERE tax.application_id = line.application_id
6181: AND tax.event_class_code = line.event_class_code
6182: AND tax.entity_code = line.entity_code
6183: AND tax.trx_id = line.trx_id

Line 6317: FROM zx_lines tax

6313: tax_only_line_flag );
6314:
6315: -- get the tax line id IN the same order of the summary tax line as IN the first query.
6316: SELECT tax_line_id BULK COLLECT INTO pg_tax_line_id_tbl
6317: FROM zx_lines tax
6318: -- bug fix 5417887
6319: -- WHERE application_id = p_event_class_rec.application_id
6320: -- AND entity_code = p_event_class_rec.entity_code
6321: -- AND event_class_code = p_event_class_rec.event_class_code

Line 6325: FROM zx_lines_det_factors line

6321: -- AND event_class_code = p_event_class_rec.event_class_code
6322: -- AND trx_id = p_event_class_rec.trx_id
6323: WHERE EXISTS (
6324: SELECT 1
6325: FROM zx_lines_det_factors line
6326: WHERE tax.application_id = line.application_id
6327: AND tax.event_class_code = line.event_class_code
6328: AND tax.entity_code = line.entity_code
6329: AND tax.trx_id = line.trx_id

Line 6453: UPDATE zx_lines

6449: END LOOP;
6450:
6451: -- update the summary_tax_line_id column in the detail tax line table
6452: FORALL i IN 1.. pg_tax_line_id_tbl.COUNT
6453: UPDATE zx_lines
6454: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
6455: WHERE tax_line_id = pg_tax_line_id_tbl(i);
6456:
6457: -- insert the summary tax lines in the zx_lines_summary table.

Line 6457: -- insert the summary tax lines in the zx_lines_summary table.

6453: UPDATE zx_lines
6454: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
6455: WHERE tax_line_id = pg_tax_line_id_tbl(i);
6456:
6457: -- insert the summary tax lines in the zx_lines_summary table.
6458: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT SAVE EXCEPTIONS
6459: INSERT INTO zx_lines_summary(
6460: summary_tax_line_id,
6461: object_version_number,

Line 6459: INSERT INTO zx_lines_summary(

6455: WHERE tax_line_id = pg_tax_line_id_tbl(i);
6456:
6457: -- insert the summary tax lines in the zx_lines_summary table.
6458: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT SAVE EXCEPTIONS
6459: INSERT INTO zx_lines_summary(
6460: summary_tax_line_id,
6461: object_version_number,
6462: created_by,
6463: creation_date,

Line 6641: 'Number of Rows Inserted in zx_lines_summary for update = ' || to_char(SQL%ROWCOUNT));

6637: IF (g_level_statement >= g_current_runtime_level ) THEN
6638:
6639: FND_LOG.STRING(g_level_statement,
6640: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_summary_lines_upd_evnt',
6641: 'Number of Rows Inserted in zx_lines_summary for update = ' || to_char(SQL%ROWCOUNT));
6642: END IF;
6643:
6644: IF (g_level_procedure >= g_current_runtime_level ) THEN
6645:

Line 6712: -- Public procedure to recreate summary tax lines from zx_lines after detleting

6708: -- PUBLIC PROCEDURE
6709: -- create_summary_lines_del_evnt
6710: --
6711: -- DESCRIPTION
6712: -- Public procedure to recreate summary tax lines from zx_lines after detleting
6713: -- the detail tax lines based on the passed-in transaction line information
6714: --
6715: -- NOTE
6716: -- 1. At present, we always regard the retain_summ_tax_line_id_flag as 'Y' due

Line 6719: -- tax line id back to zx_lines.

6715: -- NOTE
6716: -- 1. At present, we always regard the retain_summ_tax_line_id_flag as 'Y' due
6717: -- to coding consideration. If later function requirement identified for not
6718: -- retain the summary tax line id, then need to update the new summary
6719: -- tax line id back to zx_lines.
6720: --
6721: -- 2. This API only used for deleting trx lines event, so that are cases that
6722: -- some summary tax lines for this trx is no need to recreate. The current
6723: -- approach is to delete all th original summary tax lines and recreate.

Line 6761: -- tax line id back to zx_lines.

6757:
6758: -- At present, we always regard the retain_summ_tax_line_id_flag as 'Y' due
6759: -- to coding consideration. If later function requirement identified for not
6760: -- retain the summary tax line id, then need to update the new summary
6761: -- tax line id back to zx_lines.
6762:
6763: SELECT NVL(summary_tax_line_id,
6764: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
6765: count_detail_tax_line,

Line 6764: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,

6760: -- retain the summary tax line id, then need to update the new summary
6761: -- tax line id back to zx_lines.
6762:
6763: SELECT NVL(summary_tax_line_id,
6764: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
6765: count_detail_tax_line,
6766: count_detail_cancel_flag,
6767: trx_number,
6768: applied_from_application_id,

Line 6930: FROM ZX_LINES

6926: exempt_reason_code,
6927: tax_exception_id,
6928: mrc_tax_line_flag,
6929: tax_only_line_flag
6930: FROM ZX_LINES
6931: WHERE application_id = p_application_id
6932: AND entity_code = p_entity_code
6933: AND event_class_code = p_event_class_code
6934: AND trx_id = p_trx_id

Line 7047: INSERT INTO zx_lines_summary

7043: END LOOP;
7044:
7045:
7046: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT
7047: INSERT INTO zx_lines_summary
7048: ( summary_tax_line_id,
7049: object_version_number,
7050: created_by,
7051: creation_date,

Line 7186: 'NON-MRC Lines: Number of Rows Inserted into zx_lines_summary retain summary tax line id: '||to_char(SQL%ROWCOUNT));

7182: IF (g_level_statement >= g_current_runtime_level ) THEN
7183:
7184: FND_LOG.STRING(g_level_statement,
7185: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_summary_lines_del_evnt',
7186: 'NON-MRC Lines: Number of Rows Inserted into zx_lines_summary retain summary tax line id: '||to_char(SQL%ROWCOUNT));
7187: END IF;
7188:
7189: IF (g_level_procedure >= g_current_runtime_level ) THEN
7190:

Line 7215: -- ZX_LINES_SUMMARY_U1 error for debug purpose

7211: -- print_summary_columns
7212: --
7213: -- DESCRIPTION
7214: -- This private procedure to print the summarization columns in case of
7215: -- ZX_LINES_SUMMARY_U1 error for debug purpose
7216: --
7217: -- HISTORY
7218: -- Added by Simranjeet Sohal on 6-Aug-2010
7219: ------------------------------------------------------------------------------

Line 7228: -- Cursor to fetch summarization columns from ZX_LINES --

7224: p_event_class_code IN VARCHAR2,
7225: p_trx_id IN NUMBER)
7226: IS
7227:
7228: -- Cursor to fetch summarization columns from ZX_LINES --
7229: CURSOR get_summary_columns IS
7230: SELECT tax_line_id,
7231: summary_tax_line_id,
7232: application_id,

Line 7279: FROM zx_lines

7275: exempt_certificate_number,
7276: exempt_reason_code,
7277: tax_exception_id,
7278: mrc_tax_line_flag
7279: FROM zx_lines
7280: WHERE application_id = p_application_id
7281: AND event_class_code = p_event_class_code
7282: AND entity_code = p_entity_code
7283: AND trx_id = p_trx_id