APPS.PJI_FM_SUM_MAIN dependencies on PJI_SYSTEM_CONFIG_HIST

Line 151: insert into PJI_SYSTEM_CONFIG_HIST

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

Line 366: insert into PJI_SYSTEM_CONFIG_HIST

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

Line 1437: update PJI_SYSTEM_CONFIG_HIST

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

Line 1494: update PJI_SYSTEM_CONFIG_HIST

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

Line 1534: update PJI_SYSTEM_CONFIG_HIST

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