APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_MODEL_PUBLICATIONS

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

27: ---------------------------------------------------------------------------------------
28:
29: /*
30: * Public API for Model Migration.
31: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.
32: * Migration request is created by Developer and contains the list of all models selected
33: * for Migration from the source's Configurator Repository, target Instance name and
34: * target Repository Folder.
35: * @param p_userid Standard parameters required for locking. Represent calling user.

Line 68: FOR c_pub IN (SELECT publication_id FROM cz_model_publications

64: END IF;
65:
66: x_status := FND_API.G_RET_STS_SUCCESS;
67:
68: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
69: WHERE migration_group_id = p_request_id AND deleted_flag = '0')LOOP
70:
71: cz_pb_mgr.publish_model(c_pub.publication_id, x_run_id, l_status);
72:

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

82: /*
83: * Migrate Models concurrent procedure.
84: * @param errbuf Standard Oracle Concurrent Program output parameters.
85: * @param retcode Standard Oracle Concurrent Program output parameters.
86: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.
87: * Migration request is created by Developer and contains the list of all models selected
88: * for Migration from the source's Configurator Repository, target Instance name and
89: * target Repository Folder.
90: */

Line 108: FOR c_pub IN (SELECT publication_id FROM cz_model_publications

104:
105: retcode:=0;
106: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 0;
107:
108: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
109: WHERE migration_group_id = p_request_id AND deleted_flag = '0')LOOP
110:
111: l_mig_group_found :=TRUE;
112: cz_pb_mgr.publish_model(c_pub.publication_id, l_run_id, l_status);

Line 610: FROM cz_model_publications

606: IF p_organization_id IS NULL THEN
607: l_one_org := FALSE;
608: SELECT DISTINCT top_item_id, organization_id
609: BULK COLLECT INTO l_item_tbl, l_org_tbl
610: FROM cz_model_publications
611: WHERE deleted_flag = '0' AND object_type = 'PRJ'
612: AND source_target_flag = 'T' AND export_status = 'OK'
613: AND top_item_id IS NOT NULL AND organization_id IS NOT NULL;
614: ELSE

Line 618: FROM cz_model_publications

614: ELSE
615: l_one_org := TRUE;
616: IF p_top_inv_item_from IS NULL AND p_top_inv_item_to IS NULL THEN
617: SELECT DISTINCT top_item_id BULK COLLECT INTO l_item_tbl
618: FROM cz_model_publications
619: WHERE deleted_flag = '0' AND object_type = 'PRJ'
620: AND source_target_flag = 'T' AND export_status = 'OK'
621: AND organization_id = p_organization_id;
622: ELSE

Line 629: AND exists (SELECT NULL FROM cz_model_publications

625: WHERE organization_id = p_organization_id
626: AND concatenated_segments BETWEEN NVL(p_top_inv_item_from, p_top_inv_item_to)
627: AND NVL(p_top_inv_item_to, p_top_inv_item_from)
628: AND bom_item_type = BOM_ITEM_TYPE_MODEL
629: AND exists (SELECT NULL FROM cz_model_publications
630: WHERE deleted_flag = '0' AND object_type = 'PRJ'
631: AND source_target_flag = 'T' AND export_status = 'OK'
632: AND top_item_id = item.inventory_item_id
633: AND organization_id = p_organization_id);

Line 858: SELECT cz_model_publications_s.NEXTVAL, publication_id

854: update cz_servers
855: set source_server_flag = '0' where
856: source_server_flag = '1';
857: --create a pseudo record for all the target publications
858: SELECT cz_model_publications_s.NEXTVAL, publication_id
859: BULK COLLECT
860: INTO l_new_pb_id, l_old_pb_id
861: FROM cz_model_publications
862: WHERE SOURCE_TARGET_FLAG = 'T'

Line 861: FROM cz_model_publications

857: --create a pseudo record for all the target publications
858: SELECT cz_model_publications_s.NEXTVAL, publication_id
859: BULK COLLECT
860: INTO l_new_pb_id, l_old_pb_id
861: FROM cz_model_publications
862: WHERE SOURCE_TARGET_FLAG = 'T'
863: AND cz_model_publications.deleted_flag = '0';
864:
865: l_inst_str:= 'INSERT INTO cz_model_publications ' ||

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

859: BULK COLLECT
860: INTO l_new_pb_id, l_old_pb_id
861: FROM cz_model_publications
862: WHERE SOURCE_TARGET_FLAG = 'T'
863: AND cz_model_publications.deleted_flag = '0';
864:
865: l_inst_str:= 'INSERT INTO cz_model_publications ' ||
866: ' (PUBLICATION_ID ' ||
867: ' ,MODEL_ID ' ||

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

861: FROM cz_model_publications
862: WHERE SOURCE_TARGET_FLAG = 'T'
863: AND cz_model_publications.deleted_flag = '0';
864:
865: l_inst_str:= 'INSERT INTO cz_model_publications ' ||
866: ' (PUBLICATION_ID ' ||
867: ' ,MODEL_ID ' ||
868: ' ,OBJECT_ID ' ||
869: ' ,OBJECT_TYPE ' ||

Line 917: ' FROM cz_model_publications ' ||

913: ' ,CONTAINER ' ||
914: ' ,PAGE_LAYOUT ' ||
915: ' ,disabled_flag ' ||
916: ' ,''1'' ' ||
917: ' FROM cz_model_publications ' ||
918: ' WHERE publication_id = :2 ';
919:
920: --insert the pseudo record
921: FORALL i IN 1..l_new_pb_id.COUNT

Line 1005: FROM cz_model_publications

1001: INTO obselete_exists
1002: FROM DUAL
1003: WHERE EXISTS (
1004: SELECT publication_id
1005: FROM cz_model_publications
1006: WHERE source_target_flag = 'S'
1007: AND deleted_flag = '0'
1008: AND export_status <> MODEL_PUBLICATION_OBSELETE
1009: AND server_id = l_server_id);

Line 1031: UPDATE cz_model_publications

1027: x_msg_data => x_msg_data);
1028:
1029:
1030: --update all publications for local server id
1031: UPDATE cz_model_publications
1032: set export_status = MODEL_PUBLICATION_OBSELETE
1033: WHERE SOURCE_TARGET_FLAG = 'S'
1034: AND deleted_flag = '0'
1035: AND export_status <> MODEL_PUBLICATION_OBSELETE