DBA Data[Home] [Help]

APPS.ZX_TRX_DETAIL dependencies on ZX_LINES_SUMMARY

Line 2964: UPDATE ZX_LINES_SUMMARY

2960: AND TRX_ID = p_trx_id;
2961:
2962: IF (p_reporting_flag= 'N' ) THEN
2963:
2964: UPDATE ZX_LINES_SUMMARY
2965: SET REPORTING_ONLY_FLAG = 'N'
2966: WHERE APPLICATION_ID = p_application_id
2967: AND ENTITY_CODE = p_entity_code
2968: AND EVENT_CLASS_CODE = p_event_class_code

Line 3039: 'Deleting rows from ZX_LINES_SUMMARY');

3035:
3036: IF (g_level_statement >= g_current_runtime_level ) THEN
3037: FND_LOG.STRING(g_level_statement,
3038: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',
3039: 'Deleting rows from ZX_LINES_SUMMARY');
3040: END IF;
3041:
3042: FORALL i IN 1 .. p_count
3043: DELETE ZX_LINES_SUMMARY

Line 3043: DELETE ZX_LINES_SUMMARY

3039: 'Deleting rows from ZX_LINES_SUMMARY');
3040: END IF;
3041:
3042: FORALL i IN 1 .. p_count
3043: DELETE ZX_LINES_SUMMARY
3044: WHERE APPLICATION_ID = p_application_id_tbl(i)
3045: AND ENTITY_CODE = p_entity_code_tbl(i)
3046: AND EVENT_CLASS_CODE = p_event_class_code_tbl(i)
3047: AND TRX_ID = p_trx_id_tbl(i);