APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_RUN_INFOS

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

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

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

3913: x_run_id := genRun_ID;
3914: EXCEPTION
3915: WHEN OTHERS THEN
3916: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3917: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL:CZ_XFR_RUN_INFOS',11276,genRun_ID);
3918: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3919: END;
3920: COMMIT;
3921:

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

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

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