2517: l_start_rowid ROWID;
2518: l_end_rowid ROWID;
2519: l_rows_processed NUMBER;
2520:
2521: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
2522: l_restart BOOLEAN := FALSE;
2523:
2524: TYPE LineList IS TABLE OF VARCHAR2(25);
2525: linetype LineList := LineList('ITEM', 'ERV', 'IPV', 'TAX', 'TERV', 'TIPV');
2561: sysdate,
2562: NULL,
2563: p_parent_request_id,
2564: sysdate,
2565: FND_GLOBAL.User_ID,
2566: FND_GLOBAL.User_ID,
2567: sysdate,
2568: FND_GLOBAL.Login_ID,
2569: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2562: NULL,
2563: p_parent_request_id,
2564: sysdate,
2565: FND_GLOBAL.User_ID,
2566: FND_GLOBAL.User_ID,
2567: sysdate,
2568: FND_GLOBAL.Login_ID,
2569: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2570: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2564: sysdate,
2565: FND_GLOBAL.User_ID,
2566: FND_GLOBAL.User_ID,
2567: sysdate,
2568: FND_GLOBAL.Login_ID,
2569: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2570: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2571: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2572:
2565: FND_GLOBAL.User_ID,
2566: FND_GLOBAL.User_ID,
2567: sysdate,
2568: FND_GLOBAL.Login_ID,
2569: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2570: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2571: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2572:
2573:
2566: FND_GLOBAL.User_ID,
2567: sysdate,
2568: FND_GLOBAL.Login_ID,
2569: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2570: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2571: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2572:
2573:
2574: FORALL i IN linetype.FIRST..linetype.LAST
2722:
2723: g_batch_size := p_batch_size;
2724: g_num_workers := p_num_workers;
2725: g_debug_flag := p_debug_flag;
2726: g_parent_request_id := FND_GLOBAL.conc_request_id;
2727: g_upgrade_mode := p_upgrade_mode;
2728:
2729:
2730: l_debug_info := 'Inside Transaction_Upgrade_Main procedure';
2802: p_upgrade_mode,
2803: sysdate,
2804: NULL,
2805: sysdate,
2806: FND_GLOBAL.User_ID,
2807: FND_GLOBAL.User_ID,
2808: sysdate,
2809: FND_GLOBAL.Login_ID,
2810: FND_GLOBAL.prog_appl_id,
2803: sysdate,
2804: NULL,
2805: sysdate,
2806: FND_GLOBAL.User_ID,
2807: FND_GLOBAL.User_ID,
2808: sysdate,
2809: FND_GLOBAL.Login_ID,
2810: FND_GLOBAL.prog_appl_id,
2811: FND_GLOBAL.conc_program_id,
2805: sysdate,
2806: FND_GLOBAL.User_ID,
2807: FND_GLOBAL.User_ID,
2808: sysdate,
2809: FND_GLOBAL.Login_ID,
2810: FND_GLOBAL.prog_appl_id,
2811: FND_GLOBAL.conc_program_id,
2812: FND_GLOBAL.conc_request_id);
2813:
2806: FND_GLOBAL.User_ID,
2807: FND_GLOBAL.User_ID,
2808: sysdate,
2809: FND_GLOBAL.Login_ID,
2810: FND_GLOBAL.prog_appl_id,
2811: FND_GLOBAL.conc_program_id,
2812: FND_GLOBAL.conc_request_id);
2813:
2814: END IF;
2807: FND_GLOBAL.User_ID,
2808: sysdate,
2809: FND_GLOBAL.Login_ID,
2810: FND_GLOBAL.prog_appl_id,
2811: FND_GLOBAL.conc_program_id,
2812: FND_GLOBAL.conc_request_id);
2813:
2814: END IF;
2815:
2808: sysdate,
2809: FND_GLOBAL.Login_ID,
2810: FND_GLOBAL.prog_appl_id,
2811: FND_GLOBAL.conc_program_id,
2812: FND_GLOBAL.conc_request_id);
2813:
2814: END IF;
2815:
2816:
2960:
2961: UPDATE ap_invoices_upg_control
2962: SET end_date = sysdate
2963: WHERE module_name = 'TRANSACTION_UPGRADE_MAIN'
2964: AND request_id = FND_GLOBAL.conc_request_id;
2965:
2966: END IF;
2967:
2968: ELSE