APPS.CZ_PB_SYNC dependencies on CZ_MODEL_PUBLICATIONS_S

Line 243: WHERE cz_model_publications.server_id = v_tgt_pb_server_id

239: IF (v_tgt_pb_server_id <> 0) THEN
240: SELECT 1
241: INTO v_src_server_count
242: FROM cz_model_publications
243: WHERE cz_model_publications.server_id = v_tgt_pb_server_id
244: AND cz_model_publications.deleted_flag = '0'
245: AND ROWNUM < 2;
246: END IF;
247:

Line 623: SELECT cz_model_publications_s.nextval

619: linkName cz_servers.fndnam_link_name%TYPE;
620:
621: BEGIN
622: ----get new publication id
623: SELECT cz_model_publications_s.nextval
624: INTO l_new_pb_id
625: FROM dual;
626:
627: IF (p_src_ui_def_id IS NULL) THEN

Line 819: PROCEDURE clear_publication_data(p_target_server_id IN cz_model_publications.server_id%TYPE)

815: WHEN OTHERS THEN
816: RAISE;
817: END;
818: -------------------------------------------------------
819: PROCEDURE clear_publication_data(p_target_server_id IN cz_model_publications.server_id%TYPE)
820: IS
821:
822: l_src_pub_tbl t_ref;
823:

Line 1632: UPDATE cz_model_publications set deleted_flag = '1';

1628:
1629: IF (UPPER(p_decomm_flag) = 'YES') THEN
1630: modify_target_server(v_link_name,l_hostname,l_instance_name,l_instance_name);
1631: ELSE
1632: UPDATE cz_model_publications set deleted_flag = '1';
1633: COMMIT;
1634: END IF;
1635: END LOOP;
1636: END IF;