DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on FND_GLOBAL

Line 3299: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 3301: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 3302: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 4458: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 4460: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 4461: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 4693: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 4695: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 4696: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 5158: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 5160: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 5161: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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;

Line 5729: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 5731: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 5732: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 8311: l_last_updated_by := FND_GLOBAL.USER_ID;

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',

Line 8312: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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,

Line 18516: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 18518: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 18519: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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);

Line 19002: l_last_updated_by := FND_GLOBAL.USER_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:

Line 19004: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 19005: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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