2417: p_upgrade_mode,
2418: sysdate,
2419: NULL,
2420: sysdate,
2421: FND_GLOBAL.User_ID,
2422: FND_GLOBAL.User_ID,
2423: sysdate,
2424: FND_GLOBAL.Login_ID,
2425: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2418: sysdate,
2419: NULL,
2420: sysdate,
2421: FND_GLOBAL.User_ID,
2422: FND_GLOBAL.User_ID,
2423: sysdate,
2424: FND_GLOBAL.Login_ID,
2425: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2426: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2420: sysdate,
2421: FND_GLOBAL.User_ID,
2422: FND_GLOBAL.User_ID,
2423: sysdate,
2424: FND_GLOBAL.Login_ID,
2425: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2426: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2427: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_request_id, NULL));
2428:
2421: FND_GLOBAL.User_ID,
2422: FND_GLOBAL.User_ID,
2423: sysdate,
2424: FND_GLOBAL.Login_ID,
2425: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2426: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2427: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_request_id, NULL));
2428:
2429:
2422: FND_GLOBAL.User_ID,
2423: sysdate,
2424: FND_GLOBAL.Login_ID,
2425: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2426: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2427: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_request_id, NULL));
2428:
2429:
2430: UPDATE ap_lines_upg_sync_data
2423: sysdate,
2424: FND_GLOBAL.Login_ID,
2425: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2426: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2427: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_request_id, NULL));
2428:
2429:
2430: UPDATE ap_lines_upg_sync_data
2431: SET Status = 'S';
2446:
2447: UPDATE ap_invoices_upg_control
2448: SET end_date = sysdate
2449: WHERE module_name = 'TRANSACTION_UPGRADE_SYNC'
2450: AND request_id = FND_GLOBAL.conc_request_id;
2451:
2452:
2453: COMMIT;
2454: