APPS.PJI_FM_SUM_MAIN dependencies on PJI_SYSTEM_CONFIG_HIST

Line 152: insert into PJI_SYSTEM_CONFIG_HIST

148: end if;
149:
150: if (l_transition_flag = 'Y') then
151:
152: insert into PJI_SYSTEM_CONFIG_HIST
153: (
154: REQUEST_ID,
155: USER_NAME,
156: PROCESS_NAME,

Line 367: insert into PJI_SYSTEM_CONFIG_HIST

363: end if;
364:
365: PJI_UTILS.SET_PARAMETER('EXTRACTION_TYPE', l_extraction_type);
366:
367: insert into PJI_SYSTEM_CONFIG_HIST
368: (
369: REQUEST_ID,
370: USER_NAME,
371: PROCESS_NAME,

Line 1438: update PJI_SYSTEM_CONFIG_HIST

1434: if (l_params_util_flag = 'Y') then
1435: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');
1436: end if;
1437:
1438: update PJI_SYSTEM_CONFIG_HIST
1439: set END_DATE = sysdate,
1440: COMPLETION_TEXT = 'Normal completion'
1441: where PROCESS_NAME = g_process || 1 and
1442: RUN_TYPE = 'TRANSITION' and

Line 1495: update PJI_SYSTEM_CONFIG_HIST

1491:
1492: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process || 1);
1493: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process);
1494:
1495: update PJI_SYSTEM_CONFIG_HIST
1496: set END_DATE = sysdate,
1497: COMPLETION_TEXT = 'Normal completion'
1498: where PROCESS_NAME = g_process || 1 and
1499: END_DATE is null;

Line 1535: update PJI_SYSTEM_CONFIG_HIST

1531: pji_utils.write2log(sqlerrm, true, 0);
1532:
1533: l_sqlerrm := substr(sqlerrm, 1, 240);
1534:
1535: update PJI_SYSTEM_CONFIG_HIST
1536: set END_DATE = sysdate,
1537: COMPLETION_TEXT = l_sqlerrm
1538: where PROCESS_NAME = g_process || 1 and
1539: END_DATE is null;