2: /* $Header: zxmigtrxflypkgs.pls 120.2 2005/10/06 17:24:45 lxzhang noship $ */
3:
4:
5: TYPE zx_upg_trx_info_rec_type IS RECORD(
6: application_id ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
7: event_class_code ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
8: entity_code ZX_LINES_DET_FACTORS.ENTITY_CODE%TYPE,
9: trx_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE,
10: trx_line_id ZX_LINES_DET_FACTORS.TRX_LINE_ID%TYPE,
3:
4:
5: TYPE zx_upg_trx_info_rec_type IS RECORD(
6: application_id ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
7: event_class_code ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
8: entity_code ZX_LINES_DET_FACTORS.ENTITY_CODE%TYPE,
9: trx_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE,
10: trx_line_id ZX_LINES_DET_FACTORS.TRX_LINE_ID%TYPE,
11: trx_level_type ZX_LINES_DET_FACTORS.TRX_LEVEL_TYPE%TYPE
4:
5: TYPE zx_upg_trx_info_rec_type IS RECORD(
6: application_id ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
7: event_class_code ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
8: entity_code ZX_LINES_DET_FACTORS.ENTITY_CODE%TYPE,
9: trx_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE,
10: trx_line_id ZX_LINES_DET_FACTORS.TRX_LINE_ID%TYPE,
11: trx_level_type ZX_LINES_DET_FACTORS.TRX_LEVEL_TYPE%TYPE
12: );
5: TYPE zx_upg_trx_info_rec_type IS RECORD(
6: application_id ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
7: event_class_code ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
8: entity_code ZX_LINES_DET_FACTORS.ENTITY_CODE%TYPE,
9: trx_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE,
10: trx_line_id ZX_LINES_DET_FACTORS.TRX_LINE_ID%TYPE,
11: trx_level_type ZX_LINES_DET_FACTORS.TRX_LEVEL_TYPE%TYPE
12: );
13:
6: application_id ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
7: event_class_code ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
8: entity_code ZX_LINES_DET_FACTORS.ENTITY_CODE%TYPE,
9: trx_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE,
10: trx_line_id ZX_LINES_DET_FACTORS.TRX_LINE_ID%TYPE,
11: trx_level_type ZX_LINES_DET_FACTORS.TRX_LEVEL_TYPE%TYPE
12: );
13:
14:
7: event_class_code ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
8: entity_code ZX_LINES_DET_FACTORS.ENTITY_CODE%TYPE,
9: trx_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE,
10: trx_line_id ZX_LINES_DET_FACTORS.TRX_LINE_ID%TYPE,
11: trx_level_type ZX_LINES_DET_FACTORS.TRX_LEVEL_TYPE%TYPE
12: );
13:
14:
15: PROCEDURE upgrade_trx_on_fly(