3310: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3311: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3312:
3313: l_last_update_date := sysdate;
3314: l_last_updated_by := FND_GLOBAL.USER_ID;
3315: l_creation_date := sysdate;
3316: l_created_by := FND_GLOBAL.USER_ID;
3317: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3318:
3312:
3313: l_last_update_date := sysdate;
3314: l_last_updated_by := FND_GLOBAL.USER_ID;
3315: l_creation_date := sysdate;
3316: l_created_by := FND_GLOBAL.USER_ID;
3317: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3318:
3319: if (l_extraction_type = 'FULL') then
3320:
3313: l_last_update_date := sysdate;
3314: l_last_updated_by := FND_GLOBAL.USER_ID;
3315: l_creation_date := sysdate;
3316: l_created_by := FND_GLOBAL.USER_ID;
3317: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3318:
3319: if (l_extraction_type = 'FULL') then
3320:
3321: insert /*+ append parallel(fpw) */ into PJI_FP_PROJ_ET_WT_F fpw
3801: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3802: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3803:
3804: l_last_update_date := sysdate;
3805: l_last_updated_by := FND_GLOBAL.USER_ID;
3806: l_creation_date := sysdate;
3807: l_created_by := FND_GLOBAL.USER_ID;
3808: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3809:
3803:
3804: l_last_update_date := sysdate;
3805: l_last_updated_by := FND_GLOBAL.USER_ID;
3806: l_creation_date := sysdate;
3807: l_created_by := FND_GLOBAL.USER_ID;
3808: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3809:
3810: if (l_extraction_type = 'FULL') then
3811:
3804: l_last_update_date := sysdate;
3805: l_last_updated_by := FND_GLOBAL.USER_ID;
3806: l_creation_date := sysdate;
3807: l_created_by := FND_GLOBAL.USER_ID;
3808: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3809:
3810: if (l_extraction_type = 'FULL') then
3811:
3812: insert /*+ append parallel(fpe) */ into PJI_FP_PROJ_ET_F fpe
4314: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4315: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
4316:
4317: l_last_update_date := sysdate;
4318: l_last_updated_by := FND_GLOBAL.USER_ID;
4319: l_creation_date := sysdate;
4320: l_created_by := FND_GLOBAL.USER_ID;
4321: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4322:
4316:
4317: l_last_update_date := sysdate;
4318: l_last_updated_by := FND_GLOBAL.USER_ID;
4319: l_creation_date := sysdate;
4320: l_created_by := FND_GLOBAL.USER_ID;
4321: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4322:
4323: if (l_extraction_type = 'FULL') then
4324:
4317: l_last_update_date := sysdate;
4318: l_last_updated_by := FND_GLOBAL.USER_ID;
4319: l_creation_date := sysdate;
4320: l_created_by := FND_GLOBAL.USER_ID;
4321: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4322:
4323: if (l_extraction_type = 'FULL') then
4324:
4325: insert /*+ append parallel(fpp) */ into PJI_FP_PROJ_F fpp