DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_RUN_INFOS_S

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

3593: allowDecimalOptionClass := 0;
3594: END;
3595:
3596: BEGIN
3597: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;
3598: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
3599: VALUES (genRun_ID,SYSDATE,SYSDATE,'0');
3600: x_run_id := genRun_ID;
3601: EXCEPTION

Line 3907: UPDATE CZ_XFR_RUN_INFOS SET

3903: END;
3904:
3905: ----5) Finally update the (LAST_ACTIVITY,COMPLETED) fields of CZ_XFR_RUN_INFOS
3906: BEGIN
3907: UPDATE CZ_XFR_RUN_INFOS SET
3908: LAST_ACTIVITY=SYSDATE,
3909: COMPLETED='1'
3910: WHERE RUN_ID=genRun_ID;
3911: EXCEPTION