APPS.CZ_PB_MGR dependencies on CZ_PB_MODEL_EXPORTS_S

Line 9816: || 'WHERE cz_pb_model_exports.server_id = :1'

9812: EXECUTE IMMEDIATE 'SELECT remote_model_id '
9813: || ' '
9814: || 'FROM cz_pb_model_exports'
9815: || ' '
9816: || 'WHERE cz_pb_model_exports.server_id = :1'
9817: || ' '
9818: || 'AND cz_pb_model_exports.export_id = '
9819: || ' '
9820: || '(SELECT MIN(export_id)'

Line 9842: || 'AND cz_pb_model_exports.status = ''OK'''

9838: || 'AND x.migration_group_id IS NOT NULL)'
9839: || ' '
9840: || 'AND cz_pb_model_exports.model_id = :5'
9841: || ' '
9842: || 'AND cz_pb_model_exports.status = ''OK'''
9843: INTO x_remote_model_id
9844: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;
9845: END IF;
9846: ELSE

Line 9850: WHERE cz_pb_model_exports.server_id = p_server_id

9846: ELSE
9847: SELECT cz_pb_model_exports.remote_model_id
9848: INTO x_remote_model_id
9849: FROM cz_pb_model_exports
9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id

Line 9854: WHERE cz_pb_model_exports.server_id = p_server_id

9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id

Line 9856: AND cz_pb_model_exports.status = 'OK'

9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';
9860: END IF;

Line 9859: AND cz_pb_model_exports.status = 'OK';

9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';
9860: END IF;
9861:
9862: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id) := x_remote_model_id;
9863: END IF;

Line 10215: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)

10211: INSERT INTO cz_pb_model_exports
10212: (export_id, export_seq, model_id, root_model_id, server_id, publication_id, export_reverse_seq
10213: ,superseded_flag, last_xfr_activity, creation_date, last_update_date, created_by, last_updated_by, migration_group_id
10214: )
10215: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)
10216: ,'N', SYSDATE, SYSDATE, SYSDATE, 1, 1, cz_pb_mgr.g_migration_group_id
10217: );
10218:
10219: SELECT cz_pb_model_exports_s.CURRVAL

Line 10219: SELECT cz_pb_model_exports_s.CURRVAL

10215: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)
10216: ,'N', SYSDATE, SYSDATE, SYSDATE, 1, 1, cz_pb_mgr.g_migration_group_id
10217: );
10218:
10219: SELECT cz_pb_model_exports_s.CURRVAL
10220: INTO cz_pb_mgr.v_export_id
10221: FROM DUAL;
10222:
10223: COMMIT;

Line 13297: AND cz_pb_model_exports.superseded_flag = 'N';

13293: FROM cz_pb_model_exports
13294: WHERE cz_pb_model_exports.publication_id = p_publication_id
13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
13296: ---AND cz_pb_model_exports.export_reverse_seq = 0
13297: AND cz_pb_model_exports.superseded_flag = 'N';
13298: END IF;
13299:
13300: ---the above query has been changed to hold good for circular connectors
13301: ---In circular references the root may not have an export rev seq of 0