DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_RUN_INFOS_S

Line 3910: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;

3906: allowDecimalOptionClass := 0;
3907: END;
3908:
3909: BEGIN
3910: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;
3911: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
3912: VALUES (genRun_ID,SYSDATE,SYSDATE,'0');
3913: x_run_id := genRun_ID;
3914: EXCEPTION

Line 4299: UPDATE CZ_XFR_RUN_INFOS SET

4295: END;
4296:
4297: ----5) Finally update the (LAST_ACTIVITY,COMPLETED) fields of CZ_XFR_RUN_INFOS
4298: BEGIN
4299: UPDATE CZ_XFR_RUN_INFOS SET
4300: LAST_ACTIVITY=SYSDATE,
4301: COMPLETED='1'
4302: WHERE RUN_ID=genRun_ID;
4303: EXCEPTION