APPS.ZX_TRX_DETAIL dependencies on ZX_LINES

Line 2877: FROM ZX_LINES

2873: TAX_RATE_ID,
2874: TAX_RATE_CODE,
2875: TAX_RATE,
2876: LINE_AMT
2877: FROM ZX_LINES
2878: WHERE APPLICATION_ID = p_application_id
2879: AND ENTITY_CODE = p_entity_code
2880: AND EVENT_CLASS_CODE = p_event_class_code
2881: AND TRX_ID = p_trx_id;

Line 2950: UPDATE ZX_LINES

2946: END IF;
2947:
2948: p_return_status := FND_API.G_RET_STS_SUCCESS;
2949:
2950: UPDATE ZX_LINES
2951: SET
2952: REPORTING_ONLY_FLAG = p_reporting_flag ,
2953: LAST_UPDATED_BY = fnd_global.user_id ,
2954: LAST_UPDATE_DATE = SYSDATE ,

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 3026: 'Deleting rows from ZX_LINES');

3022:
3023: IF (g_level_statement >= g_current_runtime_level ) THEN
3024: FND_LOG.STRING(g_level_statement,
3025: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',
3026: 'Deleting rows from ZX_LINES');
3027: END IF;
3028:
3029: FORALL i IN 1 .. p_count
3030: DELETE ZX_LINES

Line 3030: DELETE ZX_LINES

3026: 'Deleting rows from ZX_LINES');
3027: END IF;
3028:
3029: FORALL i IN 1 .. p_count
3030: DELETE ZX_LINES
3031: WHERE APPLICATION_ID = p_application_id_tbl(i)
3032: AND ENTITY_CODE = p_entity_code_tbl(i)
3033: AND EVENT_CLASS_CODE = p_event_class_code_tbl(i)
3034: AND TRX_ID = p_trx_id_tbl(i);

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);

Line 3065: 'Deleting rows from ZX_LINES_DET_FACTORS');

3061:
3062: IF (g_level_statement >= g_current_runtime_level ) THEN
3063: FND_LOG.STRING(g_level_statement,
3064: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',
3065: 'Deleting rows from ZX_LINES_DET_FACTORS');
3066: END IF;
3067:
3068: FORALL i IN 1 .. p_count
3069: DELETE ZX_LINES_DET_FACTORS

Line 3069: DELETE ZX_LINES_DET_FACTORS

3065: 'Deleting rows from ZX_LINES_DET_FACTORS');
3066: END IF;
3067:
3068: FORALL i IN 1 .. p_count
3069: DELETE ZX_LINES_DET_FACTORS
3070: WHERE APPLICATION_ID = p_application_id_tbl(i)
3071: AND ENTITY_CODE = p_entity_code_tbl(i)
3072: AND EVENT_CLASS_CODE = p_event_class_code_tbl(i)
3073: AND TRX_ID = p_trx_id_tbl(i);