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_SUMMARY

Line 1122: | ZX_LINES_SUMMARY for a given transaction details |

1118: END Delete_Detail_Lines;
1119:
1120: /* ===========================================================================*
1121: | PROCEDURE Delete_Summary_TaxLines: Deletes the transaction from |
1122: | ZX_LINES_SUMMARY for a given transaction details |
1123: * ===========================================================================*/
1124: PROCEDURE Delete_Summary_Lines
1125: (x_return_status OUT NOCOPY VARCHAR2,
1126: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

Line 1148: DELETE FROM ZX_LINES_SUMMARY

1144: x_return_status := FND_API.G_RET_STS_SUCCESS;
1145:
1146: -- rewrote the following query for bug fix 5417887
1147: /*
1148: DELETE FROM ZX_LINES_SUMMARY
1149: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1150: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1151: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1152: AND TRX_ID = p_event_class_rec.TRX_ID;

Line 1155: DELETE FROM zx_lines_summary tax

1151: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1152: AND TRX_ID = p_event_class_rec.TRX_ID;
1153: */
1154:
1155: DELETE FROM zx_lines_summary tax
1156: WHERE EXISTS (SELECT 1
1157: FROM zx_lines_det_factors line
1158: WHERE tax.application_id = line.application_id
1159: AND tax.event_class_code = line.event_class_code

Line 1473: DELETE FROM ZX_LINES_SUMMARY

1469:
1470: IF p_event_class_rec.summarization_flag = 'Y' THEN
1471: -- Delete the summary lines
1472:
1473: DELETE FROM ZX_LINES_SUMMARY
1474: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1475: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1476: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1477: AND TRX_ID = p_event_class_rec.TRX_ID;

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

1478:
1479: IF (g_level_statement >= g_current_runtime_level ) THEN
1480: FND_LOG.STRING(g_level_statement,
1481: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Transaction',
1482: 'Number of rows deleted from zx_lines_summary = '||l_row_count);
1483: END IF;
1484:
1485: END IF;
1486:

Line 1630: UPDATE ZX_LINES_SUMMARY

1626: END IF;
1627:
1628: IF p_event_class_rec.summarization_flag = 'Y' THEN
1629:
1630: UPDATE ZX_LINES_SUMMARY
1631: SET Cancel_Flag = 'Y'
1632: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1633: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1634: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE

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

1638:
1639: IF (g_level_statement >= g_current_runtime_level ) THEN
1640: FND_LOG.STRING(g_level_statement,
1641: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Cancel_Transaction',
1642: 'Number of rows updated in zx_lines_summary = '||l_row_count);
1643: END IF;
1644:
1645: END IF;
1646:

Line 3074: UPDATE ZX_LINES_SUMMARY S

3070: ;
3071:
3072: IF p_event_class_rec.summarization_flag = 'Y' THEN
3073:
3074: UPDATE ZX_LINES_SUMMARY S
3075: SET (total_rec_tax_amt,
3076: total_nrec_tax_amt,
3077: total_rec_tax_amt_funcl_curr,
3078: total_nrec_tax_amt_funcl_curr,

Line 3204: DELETE FROM ZX_LINES_SUMMARY

3200:
3201: --
3202: -- delete all summary tax lines for this document
3203: --
3204: DELETE FROM ZX_LINES_SUMMARY
3205: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
3206: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3207: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
3208: AND TRX_ID IN(SELECT ZD.trx_id

Line 3493: UPDATE zx_lines_summary

3489: END IF;
3490:
3491: IF p_event_class_rec.summarization_flag = 'Y' THEN
3492:
3493: UPDATE zx_lines_summary
3494: SET TAX_AMT = 0,
3495: TAX_AMT_TAX_CURR = 0,
3496: TAX_AMT_FUNCL_CURR = 0,
3497: TOTAL_REC_TAX_AMT = 0,

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

3510:
3511: IF (g_level_statement >= g_current_runtime_level ) THEN
3512: FND_LOG.STRING(g_level_statement,
3513: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Discard_Tax_Only_Lines',
3514: 'Number of rows updated in zx_lines_summary = '||l_row_count);
3515: END IF;
3516:
3517: END IF;
3518:

Line 4088: UPDATE ZX_LINES_SUMMARY S

4084: END IF;
4085:
4086: IF p_event_class_rec.summarization_flag = 'Y' THEN
4087:
4088: UPDATE ZX_LINES_SUMMARY S
4089: SET (tax_amt_funcl_curr,
4090: total_rec_tax_amt_funcl_curr,
4091: total_nrec_tax_amt_funcl_curr
4092: ) =

Line 4136: | zx_lines_summary |

4132: /* ===========================================================================*
4133: | PROCEDURE update_exist_summary_line_id: |
4134: | Preserve old summary_tax_line_id in g_detail_tax_lines_gt for |
4135: | UPDATE case, if the same summarization criteria exists in |
4136: | zx_lines_summary |
4137: * ===========================================================================*/
4138: PROCEDURE update_exist_summary_line_id(
4139: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4140: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4166: FROM zx_lines_summary summ

4162: --
4163: UPDATE zx_detail_tax_lines_gt zlgt
4164: SET summary_tax_line_id =
4165: ( SELECT summary_tax_line_id
4166: FROM zx_lines_summary summ
4167: -- bug fix 5417887
4168: --WHERE summ.application_id = p_event_class_rec.application_id
4169: -- AND summ.entity_code = p_event_class_rec.entity_code
4170: -- AND summ.event_class_code = p_event_class_rec.event_class_code

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

4386: -- PRIVATE PROCEDURE
4387: -- create_summary_lines_crt_evnt
4388: --
4389: -- DESCRIPTION
4390: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
4391: -- for tax_event_type of 'CREATE' or for tax_event_type of 'UPDATE'/'OVERRIDE'
4392: -- with retain_summ_tax_line_id_flag on event_class_rec of 'N'
4393: ------------------------------------------------------------------------------
4394: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 4433: zx_lines_summary_s.NEXTVAL,

4429: entity_code,
4430: event_class_code,
4431: trx_id,
4432: internal_organization_id,
4433: zx_lines_summary_s.NEXTVAL,
4434: count_detail_tax_line,
4435: trx_number,
4436: applied_from_application_id,
4437: applied_from_event_class_code,

Line 4940: INSERT INTO zx_lines_summary(

4936: WHERE tax_line_id = pg_tax_line_id_tbl(i);
4937:
4938: -- insert the newly created summary tax lines
4939: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT
4940: INSERT INTO zx_lines_summary(
4941: summary_tax_line_id,
4942: object_version_number,
4943: created_by,
4944: creation_date,

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

5118: IF (g_level_statement >= g_current_runtime_level ) THEN
5119:
5120: FND_LOG.STRING(g_level_statement,
5121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_summary_lines_crt_evnt',
5122: 'Number of Rows Inserted in zx_lines_summary = ' || to_char(SQL%ROWCOUNT));
5123: END IF;
5124:
5125: IF (g_level_procedure >= g_current_runtime_level ) THEN
5126:

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

5146: -- PRIVATE PROCEDURE
5147: -- create_summary_lines_upd_evnt
5148: --
5149: -- DESCRIPTION
5150: -- Private procedure to create zx_lines_summary from zx_detail_tax_lines_gt
5151: -- for tax_event_type of 'UPDATE' or 'OVERRIDE' with
5152: -- retain_summ_tax_line_id_flag on event_class_rec of 'Y'
5153: ------------------------------------------------------------------------------
5154: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines

Line 5239: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,

5235: event_class_code,
5236: trx_id,
5237: internal_organization_id,
5238: NVL(summary_tax_line_id,
5239: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
5240: count_detail_tax_line,
5241: trx_number,
5242: applied_from_application_id,
5243: applied_from_event_class_code,

Line 5705: zx_lines_summary_s.NEXTVAL,

5701: entity_code,
5702: event_class_code,
5703: trx_id,
5704: internal_organization_id,
5705: zx_lines_summary_s.NEXTVAL,
5706: count_detail_tax_line,
5707: trx_number,
5708: applied_from_application_id,
5709: applied_from_event_class_code,

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

6209: UPDATE zx_lines
6210: SET summary_tax_line_id = pg_detail_tax_smry_line_id_tbl(i)
6211: WHERE tax_line_id = pg_tax_line_id_tbl(i);
6212:
6213: -- insert the summary tax lines in the zx_lines_summary table.
6214: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT
6215: INSERT INTO zx_lines_summary(
6216: summary_tax_line_id,
6217: object_version_number,

Line 6215: INSERT INTO zx_lines_summary(

6211: WHERE tax_line_id = pg_tax_line_id_tbl(i);
6212:
6213: -- insert the summary tax lines in the zx_lines_summary table.
6214: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT
6215: INSERT INTO zx_lines_summary(
6216: summary_tax_line_id,
6217: object_version_number,
6218: created_by,
6219: creation_date,

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

6393: IF (g_level_statement >= g_current_runtime_level ) THEN
6394:
6395: FND_LOG.STRING(g_level_statement,
6396: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_summary_lines_upd_evnt',
6397: 'Number of Rows Inserted in zx_lines_summary for update = ' || to_char(SQL%ROWCOUNT));
6398: END IF;
6399:
6400: IF (g_level_procedure >= g_current_runtime_level ) THEN
6401:

Line 6477: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,

6473: -- retain the summary tax line id, then need to update the new summary
6474: -- tax line id back to zx_lines.
6475:
6476: SELECT NVL(summary_tax_line_id,
6477: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
6478: trx_number,
6479: applied_from_application_id,
6480: applied_from_event_class_code,
6481: applied_from_entity_code,

Line 6836: INSERT INTO zx_lines_summary

6832: END LOOP;
6833:
6834:
6835: FORALL i IN 1..pg_summary_tax_line_id_tbl.COUNT
6836: INSERT INTO zx_lines_summary
6837: ( summary_tax_line_id,
6838: object_version_number,
6839: created_by,
6840: creation_date,

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

7003: IF (g_level_statement >= g_current_runtime_level ) THEN
7004:
7005: FND_LOG.STRING(g_level_statement,
7006: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_summary_lines_del_evnt',
7007: 'NON-MRC Lines: Number of Rows Inserted into zx_lines_summary retain summary tax line id: '||to_char(SQL%ROWCOUNT));
7008: END IF;
7009:
7010: IF (g_level_procedure >= g_current_runtime_level ) THEN
7011: