APPS.PJI_PJP_SUM_MAIN dependencies on PJI_SYSTEM_CONFIG_HIST

Line 2969: insert into PJI_SYSTEM_CONFIG_HIST

2965: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
2966:
2967: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');
2968: -- Putting this insert here, Config Hist in case of resubmit of failed run Bug 5057835
2969: insert into PJI_SYSTEM_CONFIG_HIST
2970: (
2971: REQUEST_ID,
2972: USER_NAME,
2973: PROCESS_NAME,

Line 3990: update PJI_SYSTEM_CONFIG_HIST

3986: -- mark current iteration as successful
3987:
3988: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);
3989:
3990: update PJI_SYSTEM_CONFIG_HIST
3991: set END_DATE = sysdate,
3992: COMPLETION_TEXT = 'Normal completion'
3993: where PROCESS_NAME = l_process and
3994: END_DATE is null;

Line 4059: update PJI_SYSTEM_CONFIG_HIST

4055: end if;
4056:
4057: l_sqlerrm := substr(sqlerrm, 1, 240);
4058:
4059: update PJI_SYSTEM_CONFIG_HIST
4060: set END_DATE = sysdate,
4061: COMPLETION_TEXT = l_sqlerrm
4062: where PROCESS_NAME = g_process || p_worker_id and
4063: END_DATE is null;