315:
316: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
317:
318: l_last_update_date := sysdate;
319: l_last_updated_by := FND_GLOBAL.USER_ID;
320: l_creation_date := sysdate;
321: l_created_by := FND_GLOBAL.USER_ID;
322: l_last_update_login := FND_GLOBAL.LOGIN_ID;
323:
317:
318: l_last_update_date := sysdate;
319: l_last_updated_by := FND_GLOBAL.USER_ID;
320: l_creation_date := sysdate;
321: l_created_by := FND_GLOBAL.USER_ID;
322: l_last_update_login := FND_GLOBAL.LOGIN_ID;
323:
324: if (l_extraction_type = 'FULL') then
325:
318: l_last_update_date := sysdate;
319: l_last_updated_by := FND_GLOBAL.USER_ID;
320: l_creation_date := sysdate;
321: l_created_by := FND_GLOBAL.USER_ID;
322: l_last_update_login := FND_GLOBAL.LOGIN_ID;
323:
324: if (l_extraction_type = 'FULL') then
325:
326: insert into PJI_PA_PROJ_EVENTS_LOG
1304:
1305: begin
1306:
1307: l_last_update_date := sysdate;
1308: l_last_updated_by := FND_GLOBAL.USER_ID;
1309: l_creation_date := sysdate;
1310: l_created_by := FND_GLOBAL.USER_ID;
1311: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1312:
1306:
1307: l_last_update_date := sysdate;
1308: l_last_updated_by := FND_GLOBAL.USER_ID;
1309: l_creation_date := sysdate;
1310: l_created_by := FND_GLOBAL.USER_ID;
1311: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1312:
1313: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1314:
1307: l_last_update_date := sysdate;
1308: l_last_updated_by := FND_GLOBAL.USER_ID;
1309: l_creation_date := sysdate;
1310: l_created_by := FND_GLOBAL.USER_ID;
1311: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1312:
1313: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1314:
1315: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);')) then
1539:
1540: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
1541:
1542: l_last_update_date := sysdate;
1543: l_last_updated_by := FND_GLOBAL.USER_ID;
1544: l_creation_date := sysdate;
1545: l_created_by := FND_GLOBAL.USER_ID;
1546: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1547:
1541:
1542: l_last_update_date := sysdate;
1543: l_last_updated_by := FND_GLOBAL.USER_ID;
1544: l_creation_date := sysdate;
1545: l_created_by := FND_GLOBAL.USER_ID;
1546: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1547:
1548: if (l_extraction_type = 'FULL') then
1549:
1542: l_last_update_date := sysdate;
1543: l_last_updated_by := FND_GLOBAL.USER_ID;
1544: l_creation_date := sysdate;
1545: l_created_by := FND_GLOBAL.USER_ID;
1546: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1547:
1548: if (l_extraction_type = 'FULL') then
1549:
1550: insert into PJI_PJP_WBS_HEADER
1960:
1961: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
1962:
1963: l_last_update_date := sysdate;
1964: l_last_updated_by := FND_GLOBAL.USER_ID;
1965: l_creation_date := sysdate;
1966: l_created_by := FND_GLOBAL.USER_ID;
1967: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1968:
1962:
1963: l_last_update_date := sysdate;
1964: l_last_updated_by := FND_GLOBAL.USER_ID;
1965: l_creation_date := sysdate;
1966: l_created_by := FND_GLOBAL.USER_ID;
1967: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1968:
1969: if (l_extraction_type = 'FULL') then
1970:
1963: l_last_update_date := sysdate;
1964: l_last_updated_by := FND_GLOBAL.USER_ID;
1965: l_creation_date := sysdate;
1966: l_created_by := FND_GLOBAL.USER_ID;
1967: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1968:
1969: if (l_extraction_type = 'FULL') then
1970:
1971: l_rbs_header_id := -1;
2531: return;
2532: end if;
2533:
2534: l_last_update_date := sysdate;
2535: l_last_updated_by := FND_GLOBAL.USER_ID;
2536: l_creation_date := sysdate;
2537: l_created_by := FND_GLOBAL.USER_ID;
2538: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2539:
2533:
2534: l_last_update_date := sysdate;
2535: l_last_updated_by := FND_GLOBAL.USER_ID;
2536: l_creation_date := sysdate;
2537: l_created_by := FND_GLOBAL.USER_ID;
2538: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2539:
2540: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
2541:
2534: l_last_update_date := sysdate;
2535: l_last_updated_by := FND_GLOBAL.USER_ID;
2536: l_creation_date := sysdate;
2537: l_created_by := FND_GLOBAL.USER_ID;
2538: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2539:
2540: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
2541:
2542: if (l_extraction_type = 'INCREMENTAL') then
5040:
5041: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
5042:
5043: l_last_update_date := sysdate;
5044: l_last_updated_by := FND_GLOBAL.USER_ID;
5045: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5046:
5047: update PA_PROJECTS_ALL
5048: set PJI_SOURCE_FLAG = 'Y',
5041: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
5042:
5043: l_last_update_date := sysdate;
5044: l_last_updated_by := FND_GLOBAL.USER_ID;
5045: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5046:
5047: update PA_PROJECTS_ALL
5048: set PJI_SOURCE_FLAG = 'Y',
5049: LAST_UPDATE_DATE = l_last_update_date,
16332:
16333: begin
16334:
16335: l_last_update_date := sysdate;
16336: l_last_updated_by := FND_GLOBAL.USER_ID;
16337: l_creation_date := sysdate;
16338: l_created_by := FND_GLOBAL.USER_ID;
16339: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16340:
16334:
16335: l_last_update_date := sysdate;
16336: l_last_updated_by := FND_GLOBAL.USER_ID;
16337: l_creation_date := sysdate;
16338: l_created_by := FND_GLOBAL.USER_ID;
16339: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16340:
16341: if (p_worker_id is not null) then
16342:
16335: l_last_update_date := sysdate;
16336: l_last_updated_by := FND_GLOBAL.USER_ID;
16337: l_creation_date := sysdate;
16338: l_created_by := FND_GLOBAL.USER_ID;
16339: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16340:
16341: if (p_worker_id is not null) then
16342:
16343: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16816:
16817: begin
16818:
16819: l_last_update_date := sysdate;
16820: l_last_updated_by := FND_GLOBAL.USER_ID;
16821: l_creation_date := sysdate;
16822: l_created_by := FND_GLOBAL.USER_ID;
16823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16824:
16818:
16819: l_last_update_date := sysdate;
16820: l_last_updated_by := FND_GLOBAL.USER_ID;
16821: l_creation_date := sysdate;
16822: l_created_by := FND_GLOBAL.USER_ID;
16823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16824:
16825: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
16826:
16819: l_last_update_date := sysdate;
16820: l_last_updated_by := FND_GLOBAL.USER_ID;
16821: l_creation_date := sysdate;
16822: l_created_by := FND_GLOBAL.USER_ID;
16823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16824:
16825: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
16826:
16827: if (p_worker_id is not null) then