[Home] [Help]
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
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;
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
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;
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:
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
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:
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,
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
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,
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:
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: ) =
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
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
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
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,
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,
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:
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
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,
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,
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,
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,
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:
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,
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,
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:
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: ------------------------------------------------------------------------------