2582: l_start_rowid ROWID;
2583: l_end_rowid ROWID;
2584: l_rows_processed NUMBER;
2585:
2586: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
2587: l_restart BOOLEAN := FALSE;
2588:
2589: TYPE LineList IS TABLE OF VARCHAR2(25);
2590: linetype LineList := LineList('ITEM', 'ERV', 'IPV', 'TAX', 'TERV', 'TIPV');
2626: sysdate,
2627: NULL,
2628: p_parent_request_id,
2629: sysdate,
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2627: NULL,
2628: p_parent_request_id,
2629: sysdate,
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2629: sysdate,
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:
2638:
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:
2638:
2639: FORALL i IN linetype.FIRST..linetype.LAST
2787:
2788: g_batch_size := p_batch_size;
2789: g_num_workers := p_num_workers;
2790: g_debug_flag := p_debug_flag;
2791: g_parent_request_id := FND_GLOBAL.conc_request_id;
2792: g_upgrade_mode := p_upgrade_mode;
2793:
2794:
2795: l_debug_info := 'Inside Transaction_Upgrade_Main procedure';
2867: p_upgrade_mode,
2868: sysdate,
2869: NULL,
2870: sysdate,
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2868: sysdate,
2869: NULL,
2870: sysdate,
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2870: sysdate,
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2879: END IF;
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2879: END IF;
2880:
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2879: END IF;
2880:
2881:
3025:
3026: UPDATE ap_invoices_upg_control
3027: SET end_date = sysdate
3028: WHERE module_name = 'TRANSACTION_UPGRADE_MAIN'
3029: AND request_id = FND_GLOBAL.conc_request_id;
3030:
3031: END IF;
3032:
3033: ELSE