2082: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2083: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2084:
2085: l_last_update_date := sysdate;
2086: l_last_updated_by := FND_GLOBAL.USER_ID;
2087: l_creation_date := sysdate;
2088: l_created_by := FND_GLOBAL.USER_ID;
2089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2090:
2084:
2085: l_last_update_date := sysdate;
2086: l_last_updated_by := FND_GLOBAL.USER_ID;
2087: l_creation_date := sysdate;
2088: l_created_by := FND_GLOBAL.USER_ID;
2089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2090:
2091: if (l_extraction_type = 'FULL') then
2092:
2085: l_last_update_date := sysdate;
2086: l_last_updated_by := FND_GLOBAL.USER_ID;
2087: l_creation_date := sysdate;
2088: l_created_by := FND_GLOBAL.USER_ID;
2089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2090:
2091: if (l_extraction_type = 'FULL') then
2092:
2093: insert /*+ append parallel(rmr_i) */ into PJI_RM_RES_WT_F rmr_i
2432: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2433: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2434:
2435: l_last_update_date := sysdate;
2436: l_last_updated_by := FND_GLOBAL.USER_ID;
2437: l_creation_date := sysdate;
2438: l_created_by := FND_GLOBAL.USER_ID;
2439: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2440:
2434:
2435: l_last_update_date := sysdate;
2436: l_last_updated_by := FND_GLOBAL.USER_ID;
2437: l_creation_date := sysdate;
2438: l_created_by := FND_GLOBAL.USER_ID;
2439: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2440:
2441: if (l_extraction_type = 'FULL') then
2442:
2435: l_last_update_date := sysdate;
2436: l_last_updated_by := FND_GLOBAL.USER_ID;
2437: l_creation_date := sysdate;
2438: l_created_by := FND_GLOBAL.USER_ID;
2439: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2440:
2441: if (l_extraction_type = 'FULL') then
2442:
2443: insert /*+ append parallel(rms_i) */ into PJI_RM_RES_F rms_i