APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_MODEL_PUBLICATIONS_S

Line 619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;

615: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
616: END;
617:
618: -- insert
619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;
620: EXECUTE IMMEDIATE
621: ' INSERT INTO cz_model_publications (PUBLICATION_ID ' ||
622: ' ,MODEL_ID ' ||
623: ' ,SERVER_ID ' ||

Line 837: UPDATE CZ_MODEL_PUBLICATIONS SET export_status = PUBLICATION_PENDING

833:
834: IF (v_pub_tbl.COUNT > 0) THEN
835: FOR i IN v_pub_tbl.FIRST..v_pub_tbl.LAST
836: LOOP
837: UPDATE CZ_MODEL_PUBLICATIONS SET export_status = PUBLICATION_PENDING
838: WHERE export_status = PUBLICATION_OK
839: AND deleted_flag = '0';
840:
841: x_status := NULL;