APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_MODEL_PUBLICATIONS

Line 55: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.

51: ---------------------------------------------------------------------------------------
52:
53: /*
54: * Public API for Model Migration.
55: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.
56: * Migration request is created by Developer and contains the list of all models selected
57: * for Migration from the source's Configurator Repository, target Instance name and
58: * target Repository Folder.
59: * @param p_userid Standard parameters required for locking. Represent calling user.

Line 92: FOR c_pub IN (SELECT publication_id FROM cz_model_publications

88: END IF;
89:
90: x_status := FND_API.G_RET_STS_SUCCESS;
91:
92: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
93: WHERE migration_group_id = p_request_id AND deleted_flag = '0' AND server_id <> '0')LOOP
94:
95: cz_pb_mgr.publish_model(c_pub.publication_id, x_run_id, l_status);
96:

Line 110: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.

106: /*
107: * Migrate Models concurrent procedure.
108: * @param errbuf Standard Oracle Concurrent Program output parameters.
109: * @param retcode Standard Oracle Concurrent Program output parameters.
110: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.
111: * Migration request is created by Developer and contains the list of all models selected
112: * for Migration from the source's Configurator Repository, target Instance name and
113: * target Repository Folder.
114: */

Line 132: FOR c_pub IN (SELECT publication_id FROM cz_model_publications

128:
129: retcode:=0;
130: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 0;
131:
132: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
133: WHERE migration_group_id = p_request_id AND deleted_flag = '0' AND server_id <> '0')LOOP
134:
135: l_mig_group_found :=TRUE;
136: cz_pb_mgr.publish_model(c_pub.publication_id, l_run_id, l_status);

Line 634: FROM cz_model_publications

630: IF p_organization_id IS NULL THEN
631: l_one_org := FALSE;
632: SELECT DISTINCT top_item_id, organization_id
633: BULK COLLECT INTO l_item_tbl, l_org_tbl
634: FROM cz_model_publications
635: WHERE deleted_flag = '0' AND object_type = 'PRJ'
636: AND source_target_flag = 'T' AND export_status = 'OK'
637: AND top_item_id IS NOT NULL AND organization_id IS NOT NULL;
638: ELSE

Line 642: FROM cz_model_publications

638: ELSE
639: l_one_org := TRUE;
640: IF p_top_inv_item_from IS NULL AND p_top_inv_item_to IS NULL THEN
641: SELECT DISTINCT top_item_id BULK COLLECT INTO l_item_tbl
642: FROM cz_model_publications
643: WHERE deleted_flag = '0' AND object_type = 'PRJ'
644: AND source_target_flag = 'T' AND export_status = 'OK'
645: AND organization_id = p_organization_id;
646: ELSE

Line 653: AND exists (SELECT NULL FROM cz_model_publications

649: WHERE organization_id = p_organization_id
650: AND concatenated_segments BETWEEN NVL(p_top_inv_item_from, p_top_inv_item_to)
651: AND NVL(p_top_inv_item_to, p_top_inv_item_from)
652: AND bom_item_type = BOM_ITEM_TYPE_MODEL
653: AND exists (SELECT NULL FROM cz_model_publications
654: WHERE deleted_flag = '0' AND object_type = 'PRJ'
655: AND source_target_flag = 'T' AND export_status = 'OK'
656: AND top_item_id = item.inventory_item_id
657: AND organization_id = p_organization_id);

Line 882: SELECT cz_model_publications_s.NEXTVAL, publication_id

878: update cz_servers
879: set source_server_flag = '0' where
880: source_server_flag = '1';
881: --create a pseudo record for all the target publications
882: SELECT cz_model_publications_s.NEXTVAL, publication_id
883: BULK COLLECT
884: INTO l_new_pb_id, l_old_pb_id
885: FROM cz_model_publications
886: WHERE SOURCE_TARGET_FLAG = 'T'

Line 885: FROM cz_model_publications

881: --create a pseudo record for all the target publications
882: SELECT cz_model_publications_s.NEXTVAL, publication_id
883: BULK COLLECT
884: INTO l_new_pb_id, l_old_pb_id
885: FROM cz_model_publications
886: WHERE SOURCE_TARGET_FLAG = 'T'
887: AND cz_model_publications.deleted_flag = '0';
888:
889: l_inst_str:= 'INSERT INTO cz_model_publications ' ||

Line 887: AND cz_model_publications.deleted_flag = '0';

883: BULK COLLECT
884: INTO l_new_pb_id, l_old_pb_id
885: FROM cz_model_publications
886: WHERE SOURCE_TARGET_FLAG = 'T'
887: AND cz_model_publications.deleted_flag = '0';
888:
889: l_inst_str:= 'INSERT INTO cz_model_publications ' ||
890: ' (PUBLICATION_ID ' ||
891: ' ,MODEL_ID ' ||

Line 889: l_inst_str:= 'INSERT INTO cz_model_publications ' ||

885: FROM cz_model_publications
886: WHERE SOURCE_TARGET_FLAG = 'T'
887: AND cz_model_publications.deleted_flag = '0';
888:
889: l_inst_str:= 'INSERT INTO cz_model_publications ' ||
890: ' (PUBLICATION_ID ' ||
891: ' ,MODEL_ID ' ||
892: ' ,OBJECT_ID ' ||
893: ' ,OBJECT_TYPE ' ||

Line 941: ' FROM cz_model_publications ' ||

937: ' ,CONTAINER ' ||
938: ' ,PAGE_LAYOUT ' ||
939: ' ,disabled_flag ' ||
940: ' ,''1'' ' ||
941: ' FROM cz_model_publications ' ||
942: ' WHERE publication_id = :2 ';
943:
944: --insert the pseudo record
945: FORALL i IN 1..l_new_pb_id.COUNT

Line 1029: FROM cz_model_publications

1025: INTO obselete_exists
1026: FROM DUAL
1027: WHERE EXISTS (
1028: SELECT publication_id
1029: FROM cz_model_publications
1030: WHERE source_target_flag = 'S'
1031: AND deleted_flag = '0'
1032: AND export_status <> MODEL_PUBLICATION_OBSELETE
1033: AND server_id = l_server_id);

Line 1055: UPDATE cz_model_publications

1051: x_msg_data => x_msg_data);
1052:
1053:
1054: --update all publications for local server id
1055: UPDATE cz_model_publications
1056: set export_status = MODEL_PUBLICATION_OBSELETE
1057: WHERE SOURCE_TARGET_FLAG = 'S'
1058: AND deleted_flag = '0'
1059: AND export_status <> MODEL_PUBLICATION_OBSELETE