APPS.ZX_TRX_DETAIL dependencies on ZX_SIM_PURGE

Line 3164: FROM ZX_SIM_PURGE

3160: SELECT APPLICATION_ID,
3161: ENTITY_CODE,
3162: EVENT_CLASS_CODE,
3163: TRX_ID
3164: FROM ZX_SIM_PURGE
3165: WHERE TRX_ID = c_trx_id;
3166:
3167: BEGIN
3168:

Line 3202: -- delete row from ZX_SIM_PURGE table

3198: l_error_buffer);
3199:
3200: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3201: --
3202: -- delete row from ZX_SIM_PURGE table
3203: --
3204: IF (g_level_procedure >= g_current_runtime_level ) THEN
3205: FND_LOG.STRING(g_level_procedure,
3206: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',

Line 3207: 'Deleting from ZX_SIM_PURGE table');

3203: --
3204: IF (g_level_procedure >= g_current_runtime_level ) THEN
3205: FND_LOG.STRING(g_level_procedure,
3206: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',
3207: 'Deleting from ZX_SIM_PURGE table');
3208: END IF;
3209:
3210: DELETE ZX_SIM_PURGE
3211: WHERE TRX_ID = p_trx_id;

Line 3210: DELETE ZX_SIM_PURGE

3206: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',
3207: 'Deleting from ZX_SIM_PURGE table');
3208: END IF;
3209:
3210: DELETE ZX_SIM_PURGE
3211: WHERE TRX_ID = p_trx_id;
3212: END IF;
3213:
3214: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 3263: FROM ZX_SIM_PURGE;

3259: SELECT APPLICATION_ID,
3260: ENTITY_CODE,
3261: EVENT_CLASS_CODE,
3262: TRX_ID
3263: FROM ZX_SIM_PURGE;
3264:
3265: BEGIN
3266:
3267: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3320: -- delete ZX_SIM_PURGE table

3316: CLOSE get_purge_all_csr;
3317:
3318: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3319: --
3320: -- delete ZX_SIM_PURGE table
3321: --
3322: IF (g_level_procedure >= g_current_runtime_level ) THEN
3323: FND_LOG.STRING(g_level_procedure,
3324: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',

Line 3325: 'Deleting ZX_SIM_PURGE table');

3321: --
3322: IF (g_level_procedure >= g_current_runtime_level ) THEN
3323: FND_LOG.STRING(g_level_procedure,
3324: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',
3325: 'Deleting ZX_SIM_PURGE table');
3326: END IF;
3327:
3328: DELETE ZX_SIM_PURGE;
3329:

Line 3328: DELETE ZX_SIM_PURGE;

3324: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',
3325: 'Deleting ZX_SIM_PURGE table');
3326: END IF;
3327:
3328: DELETE ZX_SIM_PURGE;
3329:
3330: END IF;
3331:
3332: IF (g_level_procedure >= g_current_runtime_level ) THEN