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 3303: insert into PJI_PJP_PROJ_BATCH_MAP

3299: null COMPLETION_TEXT
3300: from
3301: dual;
3302:
3303: insert into PJI_PJP_PROJ_BATCH_MAP
3304: (
3305: WORKER_ID,
3306: PROJECT_ID,
3307: PJI_PROJECT_STATUS,

Line 3436: DELETE FROM PJI_PJP_PROJ_BATCH_MAP WHERE WORKER_ID = l_worker_id;

3432:
3433: PJI_UTILS.SET_PARAMETER('PJP_FPM_UPGRADE_DATE',
3434: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
3435:
3436: DELETE FROM PJI_PJP_PROJ_BATCH_MAP WHERE WORKER_ID = l_worker_id;
3437:
3438: commit;
3439:
3440: EXCEPTION