3295:
3296: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
3297:
3298: l_last_update_date := sysdate;
3299: l_last_updated_by := FND_GLOBAL.USER_ID;
3300: l_creation_date := sysdate;
3301: l_created_by := FND_GLOBAL.USER_ID;
3302: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3303:
3297:
3298: l_last_update_date := sysdate;
3299: l_last_updated_by := FND_GLOBAL.USER_ID;
3300: l_creation_date := sysdate;
3301: l_created_by := FND_GLOBAL.USER_ID;
3302: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3303:
3304: if (l_extraction_type = 'FULL') then
3305:
3298: l_last_update_date := sysdate;
3299: l_last_updated_by := FND_GLOBAL.USER_ID;
3300: l_creation_date := sysdate;
3301: l_created_by := FND_GLOBAL.USER_ID;
3302: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3303:
3304: if (l_extraction_type = 'FULL') then
3305:
3306: insert into PJI_PA_PROJ_EVENTS_LOG
4454:
4455: begin
4456:
4457: l_last_update_date := sysdate;
4458: l_last_updated_by := FND_GLOBAL.USER_ID;
4459: l_creation_date := sysdate;
4460: l_created_by := FND_GLOBAL.USER_ID;
4461: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4462:
4456:
4457: l_last_update_date := sysdate;
4458: l_last_updated_by := FND_GLOBAL.USER_ID;
4459: l_creation_date := sysdate;
4460: l_created_by := FND_GLOBAL.USER_ID;
4461: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4462:
4463: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
4464:
4457: l_last_update_date := sysdate;
4458: l_last_updated_by := FND_GLOBAL.USER_ID;
4459: l_creation_date := sysdate;
4460: l_created_by := FND_GLOBAL.USER_ID;
4461: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4462:
4463: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
4464:
4465: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);')) then
4689:
4690: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4691:
4692: l_last_update_date := sysdate;
4693: l_last_updated_by := FND_GLOBAL.USER_ID;
4694: l_creation_date := sysdate;
4695: l_created_by := FND_GLOBAL.USER_ID;
4696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4697:
4691:
4692: l_last_update_date := sysdate;
4693: l_last_updated_by := FND_GLOBAL.USER_ID;
4694: l_creation_date := sysdate;
4695: l_created_by := FND_GLOBAL.USER_ID;
4696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4697:
4698: if (l_extraction_type = 'FULL') then
4699:
4692: l_last_update_date := sysdate;
4693: l_last_updated_by := FND_GLOBAL.USER_ID;
4694: l_creation_date := sysdate;
4695: l_created_by := FND_GLOBAL.USER_ID;
4696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4697:
4698: if (l_extraction_type = 'FULL') then
4699:
4700: insert into PJI_PJP_WBS_HEADER
5154:
5155: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
5156:
5157: l_last_update_date := sysdate;
5158: l_last_updated_by := FND_GLOBAL.USER_ID;
5159: l_creation_date := sysdate;
5160: l_created_by := FND_GLOBAL.USER_ID;
5161: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5162:
5156:
5157: l_last_update_date := sysdate;
5158: l_last_updated_by := FND_GLOBAL.USER_ID;
5159: l_creation_date := sysdate;
5160: l_created_by := FND_GLOBAL.USER_ID;
5161: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5162:
5163: if (l_extraction_type = 'FULL') then
5164:
5157: l_last_update_date := sysdate;
5158: l_last_updated_by := FND_GLOBAL.USER_ID;
5159: l_creation_date := sysdate;
5160: l_created_by := FND_GLOBAL.USER_ID;
5161: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5162:
5163: if (l_extraction_type = 'FULL') then
5164:
5165: l_rbs_header_id := -1;
5725: return;
5726: end if;
5727:
5728: l_last_update_date := sysdate;
5729: l_last_updated_by := FND_GLOBAL.USER_ID;
5730: l_creation_date := sysdate;
5731: l_created_by := FND_GLOBAL.USER_ID;
5732: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5733:
5727:
5728: l_last_update_date := sysdate;
5729: l_last_updated_by := FND_GLOBAL.USER_ID;
5730: l_creation_date := sysdate;
5731: l_created_by := FND_GLOBAL.USER_ID;
5732: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5733:
5734: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
5735:
5728: l_last_update_date := sysdate;
5729: l_last_updated_by := FND_GLOBAL.USER_ID;
5730: l_creation_date := sysdate;
5731: l_created_by := FND_GLOBAL.USER_ID;
5732: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5733:
5734: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
5735:
5736: if (l_extraction_type = 'INCREMENTAL') then
8307:
8308: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
8309:
8310: l_last_update_date := sysdate;
8311: l_last_updated_by := FND_GLOBAL.USER_ID;
8312: l_last_update_login := FND_GLOBAL.LOGIN_ID;
8313:
8314: update PA_PROJECTS_ALL
8315: set PJI_SOURCE_FLAG = 'Y',
8308: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
8309:
8310: l_last_update_date := sysdate;
8311: l_last_updated_by := FND_GLOBAL.USER_ID;
8312: l_last_update_login := FND_GLOBAL.LOGIN_ID;
8313:
8314: update PA_PROJECTS_ALL
8315: set PJI_SOURCE_FLAG = 'Y',
8316: LAST_UPDATE_DATE = l_last_update_date,
18512:
18513: begin
18514:
18515: l_last_update_date := sysdate;
18516: l_last_updated_by := FND_GLOBAL.USER_ID;
18517: l_creation_date := sysdate;
18518: l_created_by := FND_GLOBAL.USER_ID;
18519: l_last_update_login := FND_GLOBAL.LOGIN_ID;
18520:
18514:
18515: l_last_update_date := sysdate;
18516: l_last_updated_by := FND_GLOBAL.USER_ID;
18517: l_creation_date := sysdate;
18518: l_created_by := FND_GLOBAL.USER_ID;
18519: l_last_update_login := FND_GLOBAL.LOGIN_ID;
18520:
18521: if (p_worker_id is not null) then
18522:
18515: l_last_update_date := sysdate;
18516: l_last_updated_by := FND_GLOBAL.USER_ID;
18517: l_creation_date := sysdate;
18518: l_created_by := FND_GLOBAL.USER_ID;
18519: l_last_update_login := FND_GLOBAL.LOGIN_ID;
18520:
18521: if (p_worker_id is not null) then
18522:
18523: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
18998:
18999: begin
19000:
19001: l_last_update_date := sysdate;
19002: l_last_updated_by := FND_GLOBAL.USER_ID;
19003: l_creation_date := sysdate;
19004: l_created_by := FND_GLOBAL.USER_ID;
19005: l_last_update_login := FND_GLOBAL.LOGIN_ID;
19006:
19000:
19001: l_last_update_date := sysdate;
19002: l_last_updated_by := FND_GLOBAL.USER_ID;
19003: l_creation_date := sysdate;
19004: l_created_by := FND_GLOBAL.USER_ID;
19005: l_last_update_login := FND_GLOBAL.LOGIN_ID;
19006:
19007: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
19008:
19001: l_last_update_date := sysdate;
19002: l_last_updated_by := FND_GLOBAL.USER_ID;
19003: l_creation_date := sysdate;
19004: l_created_by := FND_GLOBAL.USER_ID;
19005: l_last_update_login := FND_GLOBAL.LOGIN_ID;
19006:
19007: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
19008:
19009: if (p_worker_id is not null) then