DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 294: update pji_pjp_proj_batch_map set act_err_msg=p_err_msg

290: BEGIN
291:
292: pa_debug.log_message('DELETE_FIN8: p_project_id'||p_project_id||'p_err_flag'||p_err_flag||'p_err_msg '||p_err_msg , 3);
293: IF p_err_flag =1 THEN
294: update pji_pjp_proj_batch_map set act_err_msg=p_err_msg
295: where project_id=p_project_id;
296:
297: else
298: print_time ( ' Deleting pji_fm_aggr_fin8 0001 p_calendar_type ' || p_calendar_type ) ;

Line 4426: insert into PJI_PJP_PROJ_BATCH_MAP

4422: null COMPLETION_TEXT
4423: from
4424: dual;
4425:
4426: insert into PJI_PJP_PROJ_BATCH_MAP
4427: (
4428: WORKER_ID,
4429: PROJECT_ID,
4430: PJI_PROJECT_STATUS,

Line 4559: DELETE FROM PJI_PJP_PROJ_BATCH_MAP WHERE WORKER_ID = l_worker_id;

4555:
4556: PJI_UTILS.SET_PARAMETER('PJP_FPM_UPGRADE_DATE',
4557: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
4558:
4559: DELETE FROM PJI_PJP_PROJ_BATCH_MAP WHERE WORKER_ID = l_worker_id;
4560:
4561: commit;
4562:
4563: EXCEPTION