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;
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:
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
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,
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;
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;
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:
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
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;