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 (SUMMARY_TAX_LINE_ID,
158: INTERNAL_ORGANIZATION_ID,

Line 157: INSERT INTO ZX_LINES_SUMMARY (SUMMARY_TAX_LINE_ID,

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 (SUMMARY_TAX_LINE_ID,
158: INTERNAL_ORGANIZATION_ID,
159: APPLICATION_ID,
160: ENTITY_CODE,
161: EVENT_CLASS_CODE,

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

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

Line 662: FROM ZX_LINES_SUMMARY

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

Line 1553: FROM zx_lines_summary

1549: ORDER by associated_child_frozen_flag DESC NULLS LAST;
1550:
1551: CURSOR existing_summary_tax_line(l_tax_rate NUMBER) IS
1552: SELECT summary_tax_line_id
1553: FROM zx_lines_summary
1554: WHERE application_id = p_application_id
1555: AND entity_code = p_entity_code
1556: AND event_class_code = p_event_class_code
1557: AND trx_id = p_trx_id

Line 1642: FROM zx_lines_summary

1638: END IF;
1639:
1640: BEGIN
1641: SELECT tax_amt, overridden_flag INTO l_summary_tax_amt, l_overridden_flag
1642: FROM zx_lines_summary
1643: WHERE summary_tax_line_id = p_summary_tax_line_id;
1644: EXCEPTION
1645: WHEN OTHERS THEN
1646: NULL;

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

1735:
1736: IF (g_level_procedure >= g_current_runtime_level ) THEN
1737: FND_LOG.STRING(g_level_procedure,
1738: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1739: 'Update zx_lines_summary (+)');
1740: END IF;
1741:
1742: FOR rec IN c2(p_application_id,
1743: p_entity_code,

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

1803: SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
1804:
1805: -- new changes
1806: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
1807: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
1808: END IF;
1809: -- new changes
1810:
1811: SELECT max(abs(tax_apportionment_line_number))+1

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

2234: -- OR l_existing_summary_tax_line_id is NOT NULL
2235: THEN
2236: l_had_frozen_dists := TRUE;
2237: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
2238: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
2239: END IF;
2240: END IF;
2241:
2242: -- update detail tax line with the new summary tax line id

Line 2262: UPDATE ZX_LINES_SUMMARY

2258: END IF; -- tax_only_line_flag
2259: END LOOP;
2260:
2261: IF l_existing_summary_tax_line_id is NULL THEN
2262: UPDATE ZX_LINES_SUMMARY
2263: SET TAX_STATUS_CODE = p_tax_status_code,
2264: TAX_RATE_ID = p_tax_rate_Id,
2265: SUMMARY_TAX_LINE_ID = nvl(l_summary_tax_line_id,p_summary_tax_line_id) ,
2266: TAX_RATE_CODE = p_tax_rate_code,

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

2446:
2447: IF (g_level_procedure >= g_current_runtime_level ) THEN
2448: FND_LOG.STRING(g_level_procedure,
2449: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2450: 'Update zx_lines_summary (-)');
2451: END IF;
2452:
2453: IF (g_level_procedure >= g_current_runtime_level ) THEN
2454: FND_LOG.STRING(g_level_procedure,

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

2593:
2594: IF (g_level_procedure >= g_current_runtime_level ) THEN
2595: FND_LOG.STRING(g_level_procedure,
2596: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2597: 'Update zx_lines_summary for DELETE (+)');
2598: END IF;
2599:
2600: UPDATE ZX_LINES_SUMMARY
2601: SET DELETE_FLAG = 'Y',

Line 2600: UPDATE ZX_LINES_SUMMARY

2596: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2597: 'Update zx_lines_summary for DELETE (+)');
2598: END IF;
2599:
2600: UPDATE ZX_LINES_SUMMARY
2601: SET DELETE_FLAG = 'Y',
2602: OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
2603: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
2604:

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

2619:
2620: IF (g_level_procedure >= g_current_runtime_level ) THEN
2621: FND_LOG.STRING(g_level_procedure,
2622: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2623: 'Update zx_lines_summary for DELETE (-)');
2624: FND_LOG.STRING(g_level_procedure,
2625: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',
2626: 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');
2627: END IF;

Line 2716: FROM ZX_LINES_SUMMARY LS

2712: --tax if such a tax line already exists for the transaction line
2713: --Validation for logical primary key
2714: SELECT count(*)
2715: INTO l_key_check
2716: FROM ZX_LINES_SUMMARY LS
2717: WHERE APPLICATION_ID = p_application_id
2718: AND ENTITY_CODE = p_entity_code
2719: AND EVENT_CLASS_CODE = p_event_class_code
2720: AND INTERNAL_ORGANIZATION_ID = p_internal_organization_id

Line 2759: FROM ZX_LINES_SUMMARY

2755: c_event_class_code VARCHAR2,
2756: c_entity_code VARCHAR2,
2757: c_trx_id NUMBER) IS
2758: SELECT *
2759: FROM ZX_LINES_SUMMARY
2760: WHERE application_id = c_application_id
2761: AND entity_code = c_entity_code
2762: AND event_class_code = c_event_class_code
2763: AND trx_id = c_trx_id