DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on FND_GLOBAL

Line 478: l_last_updated_by := FND_GLOBAL.USER_ID;

474:
475: if (l_row_count > 0) then
476:
477: l_last_update_date := sysdate;
478: l_last_updated_by := FND_GLOBAL.USER_ID;
479: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
480: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
481: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
482: l_program_update_date := sysdate;

Line 479: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

475: if (l_row_count > 0) then
476:
477: l_last_update_date := sysdate;
478: l_last_updated_by := FND_GLOBAL.USER_ID;
479: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
480: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
481: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
482: l_program_update_date := sysdate;
483:

Line 480: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;

476:
477: l_last_update_date := sysdate;
478: l_last_updated_by := FND_GLOBAL.USER_ID;
479: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
480: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
481: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
482: l_program_update_date := sysdate;
483:
484: update PA_FORECAST_ITEM_DETAILS fid

Line 481: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

477: l_last_update_date := sysdate;
478: l_last_updated_by := FND_GLOBAL.USER_ID;
479: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
480: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
481: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
482: l_program_update_date := sysdate;
483:
484: update PA_FORECAST_ITEM_DETAILS fid
485: set fid.PJI_SUMMARIZED_FLAG = null,

Line 1538: l_last_updated_by := FND_GLOBAL.USER_ID;

1534: return;
1535: end if;
1536:
1537: l_last_update_date := sysdate;
1538: l_last_updated_by := FND_GLOBAL.USER_ID;
1539: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1540: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1541: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1542: l_program_update_date := sysdate;

Line 1539: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

1535: end if;
1536:
1537: l_last_update_date := sysdate;
1538: l_last_updated_by := FND_GLOBAL.USER_ID;
1539: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1540: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1541: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1542: l_program_update_date := sysdate;
1543: l_helper_batch_id := 0;

Line 1540: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;

1536:
1537: l_last_update_date := sysdate;
1538: l_last_updated_by := FND_GLOBAL.USER_ID;
1539: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1540: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1541: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1542: l_program_update_date := sysdate;
1543: l_helper_batch_id := 0;
1544:

Line 1541: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

1537: l_last_update_date := sysdate;
1538: l_last_updated_by := FND_GLOBAL.USER_ID;
1539: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1540: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1541: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1542: l_program_update_date := sysdate;
1543: l_helper_batch_id := 0;
1544:
1545: while (l_helper_batch_id <> -1) loop

Line 1970: <> FND_GLOBAL.CONC_REQUEST_ID) then

1966: -- helper. Therefore do nothing.
1967: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process,
1968: PJI_RM_SUM_MAIN.g_process ||
1969: to_char(p_worker_id))
1970: <> FND_GLOBAL.CONC_REQUEST_ID) then
1971: pji_utils.write2log('Warning: Helper is already running.');
1972: commit;
1973: retcode := 0;
1974: return;