APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_RUN_INFOS

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 3598: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)

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
3602: WHEN OTHERS THEN

Line 3604: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:CZ_XFR_RUN_INFOS',11276,genRun_ID);

3600: x_run_id := genRun_ID;
3601: EXCEPTION
3602: WHEN OTHERS THEN
3603: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3604: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:CZ_XFR_RUN_INFOS',11276,genRun_ID);
3605: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3606: END;
3607: COMMIT;
3608:

Line 3905: ----5) Finally update the (LAST_ACTIVITY,COMPLETED) fields of CZ_XFR_RUN_INFOS

3901: WHEN OTHERS THEN
3902: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.TRACKABLE',11276,genRun_ID);
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'

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