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_SUMMARY_OVERRIDE_PKG dependencies on ZX_LINES_SUMMARY

Line 139: FROM ZX_LINES_SUMMARY

135: p_last_update_login NUMBER) IS
136:
137: CURSOR C IS
138: SELECT rowid
139: FROM ZX_LINES_SUMMARY
140: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
141:
142: BEGIN
143: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 154: 'Insert into zx_lines_summary (+)');

150:
151: IF (g_level_procedure >= g_current_runtime_level ) THEN
152: FND_LOG.STRING(g_level_procedure,
153: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
154: 'Insert into zx_lines_summary (+)');
155: END IF;
156:
157: INSERT INTO ZX_LINES_SUMMARY
158: (SUMMARY_TAX_LINE_ID,

Line 157: INSERT INTO ZX_LINES_SUMMARY

153: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
154: 'Insert into zx_lines_summary (+)');
155: END IF;
156:
157: INSERT INTO ZX_LINES_SUMMARY
158: (SUMMARY_TAX_LINE_ID,
159: INTERNAL_ORGANIZATION_ID,
160: APPLICATION_ID,
161: ENTITY_CODE,

Line 408: 'Insert into zx_lines_summary (-)');

404:
405: IF (g_level_procedure >= g_current_runtime_level ) THEN
406: FND_LOG.STRING(g_level_procedure,
407: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
408: 'Insert into zx_lines_summary (-)');
409:
410: FND_LOG.STRING(g_level_procedure,
411: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.END',
412: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (-)');

Line 665: FROM ZX_LINES_SUMMARY

661: CREATION_DATE,
662: LAST_UPDATED_BY,
663: LAST_UPDATE_DATE,
664: LAST_UPDATE_LOGIN
665: FROM ZX_LINES_SUMMARY
666: WHERE ROWID = X_Rowid;
667:
668: Recinfo summary_lines_csr%ROWTYPE;
669: l_transaction_rec ZX_API_PUB.transaction_rec_type;

Line 1559: FROM zx_lines_summary

1555: ORDER by associated_child_frozen_flag DESC NULLS LAST;
1556:
1557: CURSOR existing_summary_tax_line(l_tax_rate NUMBER) IS
1558: SELECT summary_tax_line_id
1559: FROM zx_lines_summary
1560: WHERE application_id = p_application_id
1561: AND entity_code = p_entity_code
1562: AND event_class_code = p_event_class_code
1563: AND trx_id = p_trx_id

Line 1649: FROM zx_lines_summary

1645: END IF;
1646:
1647: BEGIN
1648: SELECT tax_amt, overridden_flag INTO l_summary_tax_amt, l_overridden_flag
1649: FROM zx_lines_summary
1650: WHERE summary_tax_line_id = p_summary_tax_line_id;
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: NULL;

Line 1762: 'Update zx_lines_summary (+)');

1758:
1759: IF (g_level_procedure >= g_current_runtime_level ) THEN
1760: FND_LOG.STRING(g_level_procedure,
1761: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1762: 'Update zx_lines_summary (+)');
1763: END IF;
1764:
1765: FOR rec IN c2(p_application_id,
1766: p_entity_code,

Line 1843: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;

1839: SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
1840:
1841: -- new changes
1842: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
1843: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
1844: END IF;
1845: -- new changes
1846:
1847: SELECT max(abs(tax_apportionment_line_number))+1

Line 2293: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;

2289: -- OR l_existing_summary_tax_line_id is NOT NULL
2290: THEN
2291: l_had_frozen_dists := TRUE;
2292: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
2293: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
2294: END IF;
2295: END IF;
2296:
2297: -- update detail tax line with the new summary tax line id

Line 2318: UPDATE ZX_LINES_SUMMARY

2314: END LOOP;
2315:
2316: IF l_allow_update_flag = 'Y' THEN
2317: IF l_existing_summary_tax_line_id is NULL THEN
2318: UPDATE ZX_LINES_SUMMARY
2319: SET TAX_STATUS_CODE = p_tax_status_code,
2320: TAX_RATE_ID = p_tax_rate_Id,
2321: SUMMARY_TAX_LINE_ID = nvl(l_summary_tax_line_id,p_summary_tax_line_id) ,
2322: TAX_RATE_CODE = p_tax_rate_code,

Line 2508: 'Update zx_lines_summary (-)');

2504:
2505: IF (g_level_procedure >= g_current_runtime_level ) THEN
2506: FND_LOG.STRING(g_level_procedure,
2507: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2508: 'Update zx_lines_summary (-)');
2509: END IF;
2510:
2511: IF (g_level_procedure >= g_current_runtime_level ) THEN
2512: FND_LOG.STRING(g_level_procedure,

Line 2655: 'Update zx_lines_summary for DELETE (+)');

2651:
2652: IF (g_level_procedure >= g_current_runtime_level ) THEN
2653: FND_LOG.STRING(g_level_procedure,
2654: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2655: 'Update zx_lines_summary for DELETE (+)');
2656: END IF;
2657:
2658: UPDATE ZX_LINES_SUMMARY
2659: SET DELETE_FLAG = 'Y',

Line 2658: UPDATE ZX_LINES_SUMMARY

2654: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2655: 'Update zx_lines_summary for DELETE (+)');
2656: END IF;
2657:
2658: UPDATE ZX_LINES_SUMMARY
2659: SET DELETE_FLAG = 'Y',
2660: OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
2661: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
2662:

Line 2681: 'Update zx_lines_summary for DELETE (-)');

2677:
2678: IF (g_level_procedure >= g_current_runtime_level ) THEN
2679: FND_LOG.STRING(g_level_procedure,
2680: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2681: 'Update zx_lines_summary for DELETE (-)');
2682: FND_LOG.STRING(g_level_procedure,
2683: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',
2684: 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');
2685: END IF;

Line 2774: FROM ZX_LINES_SUMMARY LS

2770: --tax if such a tax line already exists for the transaction line
2771: --Validation for logical primary key
2772: SELECT count(*)
2773: INTO l_key_check
2774: FROM ZX_LINES_SUMMARY LS
2775: WHERE APPLICATION_ID = p_application_id
2776: AND ENTITY_CODE = p_entity_code
2777: AND EVENT_CLASS_CODE = p_event_class_code
2778: AND INTERNAL_ORGANIZATION_ID = p_internal_organization_id

Line 2817: FROM ZX_LINES_SUMMARY

2813: c_event_class_code VARCHAR2,
2814: c_entity_code VARCHAR2,
2815: c_trx_id NUMBER) IS
2816: SELECT *
2817: FROM ZX_LINES_SUMMARY
2818: WHERE application_id = c_application_id
2819: AND entity_code = c_entity_code
2820: AND event_class_code = c_event_class_code
2821: AND trx_id = c_trx_id