DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on FND_GLOBAL

Line 319: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 321: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 322: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 1308: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 1310: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 1311: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 1543: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 1545: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 1546: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 1964: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 1966: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 1967: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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;

Line 2535: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 2537: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 2538: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 5044: l_last_updated_by := FND_GLOBAL.USER_ID;

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

Line 5045: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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,

Line 16336: l_last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 16338: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 16339: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

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

Line 16822: l_created_by := FND_GLOBAL.USER_ID;

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:

Line 16823: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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