APPS.CZ_PB_MGR dependencies on CZ_PB_MODEL_EXPORTS_S

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

9056: EXECUTE IMMEDIATE 'SELECT remote_model_id '
9057: || ' '
9058: || 'FROM cz_pb_model_exports'
9059: || ' '
9060: || 'WHERE cz_pb_model_exports.server_id = :1'
9061: || ' '
9062: || 'AND cz_pb_model_exports.export_id = '
9063: || ' '
9064: || '(SELECT MIN(export_id)'

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

9082: || 'AND x.migration_group_id IS NOT NULL)'
9083: || ' '
9084: || 'AND cz_pb_model_exports.model_id = :5'
9085: || ' '
9086: || 'AND cz_pb_model_exports.status = ''OK'''
9087: INTO x_remote_model_id
9088: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;
9089: END IF;
9090: ELSE

Line 9094: WHERE cz_pb_model_exports.server_id = p_server_id

9090: ELSE
9091: SELECT cz_pb_model_exports.remote_model_id
9092: INTO x_remote_model_id
9093: FROM cz_pb_model_exports
9094: WHERE cz_pb_model_exports.server_id = p_server_id
9095: AND cz_pb_model_exports.export_id =
9096: (SELECT MAX(export_id)
9097: FROM cz_pb_model_exports
9098: WHERE cz_pb_model_exports.server_id = p_server_id

Line 9098: WHERE cz_pb_model_exports.server_id = p_server_id

9094: WHERE cz_pb_model_exports.server_id = p_server_id
9095: AND cz_pb_model_exports.export_id =
9096: (SELECT MAX(export_id)
9097: FROM cz_pb_model_exports
9098: WHERE cz_pb_model_exports.server_id = p_server_id
9099: AND cz_pb_model_exports.model_id = p_model_id
9100: AND cz_pb_model_exports.status = 'OK'
9101: AND migration_group_id IS NULL)
9102: AND cz_pb_model_exports.model_id = p_model_id

Line 9100: AND cz_pb_model_exports.status = 'OK'

9096: (SELECT MAX(export_id)
9097: FROM cz_pb_model_exports
9098: WHERE cz_pb_model_exports.server_id = p_server_id
9099: AND cz_pb_model_exports.model_id = p_model_id
9100: AND cz_pb_model_exports.status = 'OK'
9101: AND migration_group_id IS NULL)
9102: AND cz_pb_model_exports.model_id = p_model_id
9103: AND cz_pb_model_exports.status = 'OK';
9104: END IF;

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

9099: AND cz_pb_model_exports.model_id = p_model_id
9100: AND cz_pb_model_exports.status = 'OK'
9101: AND migration_group_id IS NULL)
9102: AND cz_pb_model_exports.model_id = p_model_id
9103: AND cz_pb_model_exports.status = 'OK';
9104: END IF;
9105:
9106: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id) := x_remote_model_id;
9107: END IF;

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

9455: INSERT INTO cz_pb_model_exports
9456: (export_id, export_seq, model_id, root_model_id, server_id, publication_id, export_reverse_seq
9457: ,superseded_flag, last_xfr_activity, creation_date, last_update_date, created_by, last_updated_by, migration_group_id
9458: )
9459: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)
9460: ,'N', SYSDATE, SYSDATE, SYSDATE, 1, 1, cz_pb_mgr.g_migration_group_id
9461: );
9462:
9463: SELECT cz_pb_model_exports_s.CURRVAL

Line 9463: SELECT cz_pb_model_exports_s.CURRVAL

9459: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)
9460: ,'N', SYSDATE, SYSDATE, SYSDATE, 1, 1, cz_pb_mgr.g_migration_group_id
9461: );
9462:
9463: SELECT cz_pb_model_exports_s.CURRVAL
9464: INTO cz_pb_mgr.v_export_id
9465: FROM DUAL;
9466:
9467: COMMIT;

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

12301: FROM cz_pb_model_exports
12302: WHERE cz_pb_model_exports.publication_id = p_publication_id
12303: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
12304: ---AND cz_pb_model_exports.export_reverse_seq = 0
12305: AND cz_pb_model_exports.superseded_flag = 'N';
12306: END IF;
12307:
12308: ---the above query has been changed to hold good for circular connectors
12309: ---In circular references the root may not have an export rev seq of 0