[Home] [Help]
1245:
1246: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1247: ----generates new publication id for the target publication
1248: PROCEDURE get_new_publication_id(
1249: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1250: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1251: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1252: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1253: ,x_status IN OUT NOCOPY VARCHAR2
1246: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1247: ----generates new publication id for the target publication
1248: PROCEDURE get_new_publication_id(
1249: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1250: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1251: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1252: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1253: ,x_status IN OUT NOCOPY VARCHAR2
1254: )
1247: ----generates new publication id for the target publication
1248: PROCEDURE get_new_publication_id(
1249: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1250: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1251: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1252: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1253: ,x_status IN OUT NOCOPY VARCHAR2
1254: )
1255: AS
1248: PROCEDURE get_new_publication_id(
1249: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1250: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1251: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1252: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
1253: ,x_status IN OUT NOCOPY VARCHAR2
1254: )
1255: AS
1256: BEGIN
1257: IF (x_status <> PUBLICATION_ERROR)
1258: THEN
1259: IF (cz_pb_mgr.v_server_id <> 0)
1260: THEN
1261: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
1262: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
1263: ,cz_pb_mgr.v_oraclesequenceincr
1264: )
1265: ,publication_id, remote_publication_id
1258: THEN
1259: IF (cz_pb_mgr.v_server_id <> 0)
1260: THEN
1261: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
1262: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
1263: ,cz_pb_mgr.v_oraclesequenceincr
1264: )
1265: ,publication_id, remote_publication_id
1266: INTO x_new_pub_id
1264: )
1265: ,publication_id, remote_publication_id
1266: INTO x_new_pub_id
1267: ,x_old_pb_id, x_old_rem_pb_id
1268: FROM cz_model_publications
1269: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1270: ELSE
1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1272: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1265: ,publication_id, remote_publication_id
1266: INTO x_new_pub_id
1267: ,x_old_pb_id, x_old_rem_pb_id
1268: FROM cz_model_publications
1269: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1270: ELSE
1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1272: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1273: FROM cz_model_publications
1267: ,x_old_pb_id, x_old_rem_pb_id
1268: FROM cz_model_publications
1269: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1270: ELSE
1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1272: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1273: FROM cz_model_publications
1274: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1275: END IF;
1269: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1270: ELSE
1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1272: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1273: FROM cz_model_publications
1274: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1275: END IF;
1276: END IF;
1277: EXCEPTION
1270: ELSE
1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1272: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1273: FROM cz_model_publications
1274: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1275: END IF;
1276: END IF;
1277: EXCEPTION
1278: WHEN OTHERS
1276: END IF;
1277: EXCEPTION
1278: WHEN OTHERS
1279: THEN
1280: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
1281: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUB', SQLCODE);
1282: x_status := PUBLICATION_ERROR;
1283: RAISE;
1284: END get_new_publication_id;
5282: l_applicable_from DATE := cz_utils.epoch_begin;
5283: l_applicable_until DATE := cz_utils.epoch_end;
5284: l_status NUMBER := 0;
5285: l_ref_cursor ref_cursor;
5286: l_src_pb_id cz_model_publications.publication_id%TYPE;
5287: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
5288: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
5289: BEGIN
5290: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
5283: l_applicable_until DATE := cz_utils.epoch_end;
5284: l_status NUMBER := 0;
5285: l_ref_cursor ref_cursor;
5286: l_src_pb_id cz_model_publications.publication_id%TYPE;
5287: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
5288: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
5289: BEGIN
5290: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
5291: THEN
5284: l_status NUMBER := 0;
5285: l_ref_cursor ref_cursor;
5286: l_src_pb_id cz_model_publications.publication_id%TYPE;
5287: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
5288: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
5289: BEGIN
5290: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
5291: THEN
5292: l_inst_str :=
5289: BEGIN
5290: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
5291: THEN
5292: l_inst_str :=
5293: 'UPDATE cz_model_publications'
5294: || p_link_name
5295: || ' t'
5296: || ' '
5297: || 'SET t.last_update_date = sysdate'
5321: l_tgt_pb_id := p_src_id;
5322: END IF;
5323:
5324: l_inst_str :=
5325: 'INSERT INTO cz_model_publications'
5326: || p_link_name
5327: || ' '
5328: || '(PUBLICATION_ID,'
5329: || ' '
5384: EXCEPTION
5385: WHEN OTHERS
5386: THEN
5387: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5388: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
5389: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
5390: RAISE;
5391: END create_uit_publication;
5392:
5457: FOR i IN cz_pb_mgr.g_ui_templates_old_temp_id_ref.FIRST .. cz_pb_mgr.g_ui_templates_old_temp_id_ref.LAST
5458: LOOP
5459: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
5460: THEN
5461: SELECT cz_model_publications_s.NEXTVAL
5462: INTO l_src_pb_id
5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=
5462: INTO l_src_pb_id
5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=
5466: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
5468: ,cz_pb_mgr.v_oraclesequenceincr
5469: );
5470:
5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=
5466: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
5468: ,cz_pb_mgr.v_oraclesequenceincr
5469: );
5470:
5471: -- IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
6746: END export_single_oa_ui;
6747:
6748: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6749: ----update pup status
6750: PROCEDURE update_pup_status(p_publication_id cz_model_publications.publication_id%TYPE)
6751: IS
6752: l_remote_publication_id NUMBER;
6753: BEGIN
6754: UPDATE cz_model_publications
6750: PROCEDURE update_pup_status(p_publication_id cz_model_publications.publication_id%TYPE)
6751: IS
6752: l_remote_publication_id NUMBER;
6753: BEGIN
6754: UPDATE cz_model_publications
6755: SET export_status = 'OK'
6756: WHERE remote_publication_id = (SELECT remote_publication_id
6757: FROM cz_model_publications
6758: WHERE deleted_flag = '0' AND publication_id = p_publication_id AND export_status = 'ERR')
6753: BEGIN
6754: UPDATE cz_model_publications
6755: SET export_status = 'OK'
6756: WHERE remote_publication_id = (SELECT remote_publication_id
6757: FROM cz_model_publications
6758: WHERE deleted_flag = '0' AND publication_id = p_publication_id AND export_status = 'ERR')
6759: AND export_status = 'PUP'
6760: AND deleted_flag = '0';
6761: END;
6760: AND deleted_flag = '0';
6761: END;
6762:
6763: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6764: ------updates export status in cZ_model_publications
6765: PROCEDURE update_publication_status(p_publication_id IN NUMBER, p_pb_status IN VARCHAR2, p_db_link IN VARCHAR2)
6766: IS
6767: BEGIN
6768: IF ((p_publication_id > 0) AND(p_pb_status IS NOT NULL))
6767: BEGIN
6768: IF ((p_publication_id > 0) AND(p_pb_status IS NOT NULL))
6769: THEN
6770: cz_pb_mgr.v_insert_string :=
6771: 'UPDATE cz_model_publications'
6772: || p_db_link
6773: || ' '
6774: || 'SET export_status = :1,'
6775: || ' '
6774: || 'SET export_status = :1,'
6775: || ' '
6776: || 'published = sysdate'
6777: || ' '
6778: || 'WHERE cz_model_publications.publication_id = :2';
6779:
6780: EXECUTE IMMEDIATE cz_pb_mgr.v_insert_string
6781: USING p_pb_status, p_publication_id;
6782: END IF;
7263: RAISE;
7264: END rollback_data;
7265:
7266: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7267: -----------procedure updates the status in cz_model_publications and cz_pb_model_exports
7268: -----------@p_publication_id : source publication id
7269: -----------@p_status : publication status
7270: -----------@p_link : database link name
7271: -----------@p_models_exported : source models that have entries in model exports
7270: -----------@p_link : database link name
7271: -----------@p_models_exported : source models that have entries in model exports
7272: -----------@x_status : publication status parameter
7273: PROCEDURE update_pb_status(
7274: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
7275: ,p_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
7276: ,p_models_exported IN OUT NOCOPY cz_pb_mgr.t_ref
7277: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
7278: )
7271: -----------@p_models_exported : source models that have entries in model exports
7272: -----------@x_status : publication status parameter
7273: PROCEDURE update_pb_status(
7274: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
7275: ,p_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
7276: ,p_models_exported IN OUT NOCOPY cz_pb_mgr.t_ref
7277: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
7278: )
7279: AS
7273: PROCEDURE update_pb_status(
7274: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
7275: ,p_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
7276: ,p_models_exported IN OUT NOCOPY cz_pb_mgr.t_ref
7277: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
7278: )
7279: AS
7280: BEGIN
7281: -----update status on the source. p_link is null
7300: END IF;
7301: EXCEPTION
7302: WHEN OTHERS
7303: THEN
7304: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
7305: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDPBSTATUS', SQLCODE);
7306: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7307: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
7308: RAISE;
7539: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7540: ----procedure that checks if a model has been published earlier
7541: ----@p_publication_id : publication_id of the publication request
7542: ----x_record_count : returns count of earlier publications
7543: PROCEDURE chk_if_aleady_published(p_publication_id IN cz_model_publications.publication_id%TYPE, x_record_count IN OUT NOCOPY NUMBER)
7544: AS
7545: BEGIN
7546: IF (g_object_type = MODEL_PUBLICATION)
7547: THEN
7546: IF (g_object_type = MODEL_PUBLICATION)
7547: THEN
7548: SELECT COUNT(*)
7549: INTO x_record_count
7550: FROM cz_model_publications z
7551: WHERE z.object_id = (SELECT object_id
7552: FROM cz_model_publications
7553: WHERE cz_model_publications.publication_id = p_publication_id)
7554: AND z.server_id = (SELECT server_id
7548: SELECT COUNT(*)
7549: INTO x_record_count
7550: FROM cz_model_publications z
7551: WHERE z.object_id = (SELECT object_id
7552: FROM cz_model_publications
7553: WHERE cz_model_publications.publication_id = p_publication_id)
7554: AND z.server_id = (SELECT server_id
7555: FROM cz_model_publications
7556: WHERE cz_model_publications.publication_id = p_publication_id)
7549: INTO x_record_count
7550: FROM cz_model_publications z
7551: WHERE z.object_id = (SELECT object_id
7552: FROM cz_model_publications
7553: WHERE cz_model_publications.publication_id = p_publication_id)
7554: AND z.server_id = (SELECT server_id
7555: FROM cz_model_publications
7556: WHERE cz_model_publications.publication_id = p_publication_id)
7557: AND z.model_last_struct_update =
7551: WHERE z.object_id = (SELECT object_id
7552: FROM cz_model_publications
7553: WHERE cz_model_publications.publication_id = p_publication_id)
7554: AND z.server_id = (SELECT server_id
7555: FROM cz_model_publications
7556: WHERE cz_model_publications.publication_id = p_publication_id)
7557: AND z.model_last_struct_update =
7558: (SELECT last_struct_update
7559: FROM cz_devl_projects
7552: FROM cz_model_publications
7553: WHERE cz_model_publications.publication_id = p_publication_id)
7554: AND z.server_id = (SELECT server_id
7555: FROM cz_model_publications
7556: WHERE cz_model_publications.publication_id = p_publication_id)
7557: AND z.model_last_struct_update =
7558: (SELECT last_struct_update
7559: FROM cz_devl_projects
7560: WHERE cz_devl_projects.devl_project_id =
7558: (SELECT last_struct_update
7559: FROM cz_devl_projects
7560: WHERE cz_devl_projects.devl_project_id =
7561: (SELECT object_id
7562: FROM cz_model_publications
7563: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))
7564: AND z.export_status IN('OK', 'PUP')
7565: AND z.source_target_flag = g_source_flag
7566: AND z.deleted_flag = record_not_deleted;
7559: FROM cz_devl_projects
7560: WHERE cz_devl_projects.devl_project_id =
7561: (SELECT object_id
7562: FROM cz_model_publications
7563: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))
7564: AND z.export_status IN('OK', 'PUP')
7565: AND z.source_target_flag = g_source_flag
7566: AND z.deleted_flag = record_not_deleted;
7567: ELSIF(g_object_type = template_publication)
7567: ELSIF(g_object_type = template_publication)
7568: THEN
7569: SELECT COUNT(*)
7570: INTO x_record_count
7571: FROM cz_model_publications z
7572: WHERE z.object_id = (SELECT object_id
7573: FROM cz_model_publications
7574: WHERE cz_model_publications.publication_id = p_publication_id)
7575: AND z.server_id = (SELECT server_id
7569: SELECT COUNT(*)
7570: INTO x_record_count
7571: FROM cz_model_publications z
7572: WHERE z.object_id = (SELECT object_id
7573: FROM cz_model_publications
7574: WHERE cz_model_publications.publication_id = p_publication_id)
7575: AND z.server_id = (SELECT server_id
7576: FROM cz_model_publications
7577: WHERE cz_model_publications.publication_id = p_publication_id)
7570: INTO x_record_count
7571: FROM cz_model_publications z
7572: WHERE z.object_id = (SELECT object_id
7573: FROM cz_model_publications
7574: WHERE cz_model_publications.publication_id = p_publication_id)
7575: AND z.server_id = (SELECT server_id
7576: FROM cz_model_publications
7577: WHERE cz_model_publications.publication_id = p_publication_id)
7578: AND z.export_status IN('OK', 'PUP')
7572: WHERE z.object_id = (SELECT object_id
7573: FROM cz_model_publications
7574: WHERE cz_model_publications.publication_id = p_publication_id)
7575: AND z.server_id = (SELECT server_id
7576: FROM cz_model_publications
7577: WHERE cz_model_publications.publication_id = p_publication_id)
7578: AND z.export_status IN('OK', 'PUP')
7579: AND z.source_target_flag = g_source_flag
7580: AND z.deleted_flag = record_not_deleted;
7573: FROM cz_model_publications
7574: WHERE cz_model_publications.publication_id = p_publication_id)
7575: AND z.server_id = (SELECT server_id
7576: FROM cz_model_publications
7577: WHERE cz_model_publications.publication_id = p_publication_id)
7578: AND z.export_status IN('OK', 'PUP')
7579: AND z.source_target_flag = g_source_flag
7580: AND z.deleted_flag = record_not_deleted;
7581: END IF;
7590: -----@p_model_id: model_id on the publication request
7591: -----@p_server_id : server_id on the publication request
7592: -----x_last_xfr_activity : last published date
7593: PROCEDURE get_last_xfr_activity(
7594: p_model_id IN cz_model_publications.model_id%TYPE
7595: ,p_server_id IN cz_model_publications.server_id%TYPE
7596: ,x_last_xfr_activity IN OUT NOCOPY DATE
7597: )
7598: AS
7591: -----@p_server_id : server_id on the publication request
7592: -----x_last_xfr_activity : last published date
7593: PROCEDURE get_last_xfr_activity(
7594: p_model_id IN cz_model_publications.model_id%TYPE
7595: ,p_server_id IN cz_model_publications.server_id%TYPE
7596: ,x_last_xfr_activity IN OUT NOCOPY DATE
7597: )
7598: AS
7599: BEGIN
7609: AND z.server_id = p_server_id
7610: AND z.status = 'OK'
7611: AND z.publication_id IN(
7612: SELECT publication_id
7613: FROM cz_model_publications
7614: WHERE export_status IN('OK', 'PUP')
7615: AND server_id = p_server_id
7616: AND UPPER(publication_mode) = cz_model_migration_pvt.mode_migration));
7617: --SPUPPALA bug#7116052 7-AUG-2009
7626: AND z.server_id = p_server_id
7627: AND z.status = 'OK'
7628: AND z.publication_id IN(
7629: SELECT publication_id
7630: FROM cz_model_publications
7631: WHERE export_status IN('OK', 'PUP')
7632: AND server_id = p_server_id
7633: AND UPPER(publication_mode) <> cz_model_migration_pvt.mode_migration));
7634: --SPUPPALA bug#7116052 7-AUG-2009
7641:
7642: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7643: -----procedure that retrieves the last update date from cz_expression nodes
7644: -----required to check if rules have been changed since it was last published
7645: PROCEDURE get_max_expr_date(p_model_id cz_model_publications.model_id%TYPE, x_expr_node_date IN OUT NOCOPY DATE)
7646: AS
7647: BEGIN
7648: SELECT MAX(last_update_date)
7649: INTO x_expr_node_date
7663:
7664: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7665: -----procedure that retrieves the last_struct_update date
7666: -----required to check if ps structure been changed since model was last published
7667: PROCEDURE get_last_struct_date(p_model_id cz_model_publications.model_id%TYPE, x_last_struct_date IN OUT NOCOPY DATE)
7668: AS
7669: BEGIN
7670: SELECT last_struct_update
7671: INTO x_last_struct_date
7682: -----@p_model_id : model that is exported
7683: -----@p_src_models : source models array
7684: -----x_ui_def_ref : output of source ui defs
7685: PROCEDURE get_source_uis(
7686: p_model_id IN cz_model_publications.model_id%TYPE
7687: ,p_src_models IN cz_pb_mgr.t_ref
7688: ,x_ui_def_ref IN OUT NOCOPY cz_pb_mgr.t_ref
7689: )
7690: AS
7780: END get_source_uis;
7781:
7782: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7783: ----procedure that returns the max last_update_date of ui schema
7784: PROCEDURE get_max_ui_date(p_ui_def_id IN cz_model_publications.ui_def_id%TYPE, x_max_update_date IN OUT NOCOPY DATE)
7785: AS
7786: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7787: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7788: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
8291: END get_max_ui_date;
8292:
8293: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8294: -------procedure that retrieves all source models
8295: PROCEDURE get_source_models(p_model_id IN cz_model_publications.model_id%TYPE, x_models_tbl IN OUT NOCOPY cz_pb_mgr.t_ref)
8296: AS
8297: v_count PLS_INTEGER := 0;
8298: v_component_id cz_model_ref_expls.component_id%TYPE;
8299:
8547: IS
8548: l_last_update_date DATE;
8549: l_prev_date DATE := cz_utils.epoch_begin;
8550: rec_count NUMBER := 0;
8551: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
8552: BEGIN
8553: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
8554: THEN
8555: l_pub_mode := cz_model_migration_pvt.mode_migration;
8566: LOOP
8567: BEGIN
8568: SELECT MAX(published)
8569: INTO l_last_update_date
8570: FROM cz_model_publications
8571: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
8572: AND cz_model_publications.deleted_flag = record_not_deleted
8573: AND cz_model_publications.object_type = template_publication
8574: AND UPPER(cz_model_publications.publication_mode) = l_pub_mode;
8567: BEGIN
8568: SELECT MAX(published)
8569: INTO l_last_update_date
8570: FROM cz_model_publications
8571: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
8572: AND cz_model_publications.deleted_flag = record_not_deleted
8573: AND cz_model_publications.object_type = template_publication
8574: AND UPPER(cz_model_publications.publication_mode) = l_pub_mode;
8575: --SPUPPALA bug#7116052 7-AUG-2009
8568: SELECT MAX(published)
8569: INTO l_last_update_date
8570: FROM cz_model_publications
8571: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
8572: AND cz_model_publications.deleted_flag = record_not_deleted
8573: AND cz_model_publications.object_type = template_publication
8574: AND UPPER(cz_model_publications.publication_mode) = l_pub_mode;
8575: --SPUPPALA bug#7116052 7-AUG-2009
8576: EXCEPTION
8569: INTO l_last_update_date
8570: FROM cz_model_publications
8571: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
8572: AND cz_model_publications.deleted_flag = record_not_deleted
8573: AND cz_model_publications.object_type = template_publication
8574: AND UPPER(cz_model_publications.publication_mode) = l_pub_mode;
8575: --SPUPPALA bug#7116052 7-AUG-2009
8576: EXCEPTION
8577: WHEN NO_DATA_FOUND
8570: FROM cz_model_publications
8571: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
8572: AND cz_model_publications.deleted_flag = record_not_deleted
8573: AND cz_model_publications.object_type = template_publication
8574: AND UPPER(cz_model_publications.publication_mode) = l_pub_mode;
8575: --SPUPPALA bug#7116052 7-AUG-2009
8576: EXCEPTION
8577: WHEN NO_DATA_FOUND
8578: THEN
8977: BEGIN
8978: -- using binding vars
8979: -- check existing in ui template table (esp for mig)?
8980: OPEN l_ref_cursor FOR 'SELECT object_id'
8981: || ' FROM cz_model_publications'
8982: || cz_pb_mgr.v_db_link
8983: || ' t'
8984: || ' WHERE t.source_model_id = '
8985: || p_src_template_id
9032: x_status := 0;
9033:
9034: SELECT last_update_date
9035: INTO l_last_update_date
9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9033:
9034: SELECT last_update_date
9035: INTO l_last_update_date
9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9034: SELECT last_update_date
9035: INTO l_last_update_date
9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9035: INTO l_last_update_date
9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9043:
9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9043:
9044: SELECT last_update_date
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9043:
9044: SELECT last_update_date
9045: INTO l_uit_update_date
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9043:
9044: SELECT last_update_date
9045: INTO l_uit_update_date
9046: FROM cz_ui_templates
9890: v_count PLS_INTEGER := 0;
9891: v_models model_id_table;
9892: record_index NUMBER := 0;
9893: not_exported_record_index NUMBER := 0;
9894: v_model_id cz_model_publications.model_id%TYPE;
9895: v_expr_last_update cz_expression_nodes.last_update_date%TYPE;
9896: l_exp_models_idx_ref cz_pb_mgr.t_ref_idx_vc2;
9897: l_intl_text_date DATE;
9898: l_eff_set_date DATE;
10270: IF ((p_publication_id > 0) AND(cz_pb_mgr.v_session_parameter <> model_copy))
10271: THEN
10272: v_remote_link := retrieve_db_link(cz_pb_mgr.v_server_id);
10273: cz_pb_mgr.v_insert_string :=
10274: 'SELECT publication_id FROM cz_model_publications' || v_remote_link || ' t' || ' ' || 'WHERE t.publication_id = '
10275: || p_publication_id;
10276:
10277: OPEN remote_pb_cv FOR cz_pb_mgr.v_insert_string;
10278:
10616: END verify_model_for_sync;
10617:
10618: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10619: ------procedure to get synchronized values for organization_id,
10620: ------top_item_id and product_key of cz_model_publications
10621: ------If no bom synch required, then default values are returned
10622: PROCEDURE get_synchronized_pb_values(p_publication_id IN NUMBER)
10623: IS
10624: BEGIN
10629: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
10630: INTO cz_pb_mgr.v_bomsynch_org_id
10631: ,cz_pb_mgr.v_bomsynch_item_id
10632: ,cz_pb_mgr.v_bomsynch_product_key
10633: FROM cz_model_publications
10634: WHERE cz_model_publications.publication_id = p_publication_id;
10635: END IF;
10636: EXCEPTION
10637: WHEN OTHERS
10630: INTO cz_pb_mgr.v_bomsynch_org_id
10631: ,cz_pb_mgr.v_bomsynch_item_id
10632: ,cz_pb_mgr.v_bomsynch_product_key
10633: FROM cz_model_publications
10634: WHERE cz_model_publications.publication_id = p_publication_id;
10635: END IF;
10636: EXCEPTION
10637: WHEN OTHERS
10638: THEN
13232: -----@p_new_ui_array : array containing new ui_def_ids
13233: -----@x_new_ui_def_id : new ui_def_id
13234: -----@x_status : publication status parameter
13235: PROCEDURE get_new_ui_def_id(
13236: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13237: ,p_old_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
13238: ,p_new_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
13239: ,x_new_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13240: ,x_status IN OUT NOCOPY VARCHAR2
13235: PROCEDURE get_new_ui_def_id(
13236: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13237: ,p_old_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
13238: ,p_new_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
13239: ,x_new_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13240: ,x_status IN OUT NOCOPY VARCHAR2
13241: )
13242: AS
13243: v_old_ui_def_id cz_model_publications.model_id%TYPE;
13239: ,x_new_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13240: ,x_status IN OUT NOCOPY VARCHAR2
13241: )
13242: AS
13243: v_old_ui_def_id cz_model_publications.model_id%TYPE;
13244: BEGIN
13245: IF (x_status <> PUBLICATION_ERROR)
13246: THEN
13247: SELECT ui_def_id
13245: IF (x_status <> PUBLICATION_ERROR)
13246: THEN
13247: SELECT ui_def_id
13248: INTO v_old_ui_def_id
13249: FROM cz_model_publications
13250: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
13251:
13252: IF ((v_old_ui_def_id > 0) AND(p_new_ui_array.COUNT > 0))
13253: THEN
13246: THEN
13247: SELECT ui_def_id
13248: INTO v_old_ui_def_id
13249: FROM cz_model_publications
13250: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
13251:
13252: IF ((v_old_ui_def_id > 0) AND(p_new_ui_array.COUNT > 0))
13253: THEN
13254: IF (p_old_ui_array.COUNT > 0) THEN
13267: END IF;
13268: EXCEPTION
13269: WHEN OTHERS
13270: THEN
13271: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_DATA_FOUND', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
13272: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:UIDEFID', SQLCODE);
13273: x_status := PUBLICATION_ERROR;
13274: RAISE;
13275: END get_new_ui_def_id;
13276:
13277: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13278: ----procedure gets model id for target publication
13279: PROCEDURE get_new_model_id(
13280: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13281: ,p_new_model_array IN OUT NOCOPY cz_pb_mgr.t_ref
13282: ,x_new_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13283: ,x_status IN OUT NOCOPY VARCHAR2
13284: )
13278: ----procedure gets model id for target publication
13279: PROCEDURE get_new_model_id(
13280: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13281: ,p_new_model_array IN OUT NOCOPY cz_pb_mgr.t_ref
13282: ,x_new_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13283: ,x_status IN OUT NOCOPY VARCHAR2
13284: )
13285: AS
13286: BEGIN
13313: END get_new_model_id;
13314:
13315: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13316: ------procedure that retrieves the source publication_id, export_status, server_id, remote_publication_id
13317: ------from cz_model_publications table
13318: ------@p_publication_id : publication id whose info is required
13319: ------@p_status : publication_status
13320: ------@x_model_id : model that is to be published
13321: ------@x_ui_def_id : ui_def_id
13322: ------@x_export_status : prev publication status
13323: ------@x_remote_publication_id : prev remote publication id
13324: ------@x_status : publication status parameter
13325: PROCEDURE get_source_pb_info(
13326: p_publication_id IN cz_model_publications.publication_id%TYPE
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13323: ------@x_remote_publication_id : prev remote publication id
13324: ------@x_status : publication status parameter
13325: PROCEDURE get_source_pb_info(
13326: p_publication_id IN cz_model_publications.publication_id%TYPE
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13324: ------@x_status : publication status parameter
13325: PROCEDURE get_source_pb_info(
13326: p_publication_id IN cz_model_publications.publication_id%TYPE
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13325: PROCEDURE get_source_pb_info(
13326: p_publication_id IN cz_model_publications.publication_id%TYPE
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13333: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
13326: p_publication_id IN cz_model_publications.publication_id%TYPE
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13333: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
13334: ,x_status IN OUT NOCOPY VARCHAR2
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13333: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
13334: ,x_status IN OUT NOCOPY VARCHAR2
13335: )
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13333: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
13334: ,x_status IN OUT NOCOPY VARCHAR2
13335: )
13336: AS
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13333: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
13334: ,x_status IN OUT NOCOPY VARCHAR2
13335: )
13336: AS
13337: BEGIN
13338: IF (x_status <> PUBLICATION_ERROR)
13339: THEN
13340: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
13341: INTO x_model_id, x_ui_def_id, x_server_id, x_export_status, x_remote_publication_id, x_object_type, x_pb_mode, g_engine_type
13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13339: THEN
13340: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
13341: INTO x_model_id, x_ui_def_id, x_server_id, x_export_status, x_remote_publication_id, x_object_type, x_pb_mode, g_engine_type
13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13347: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
13340: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
13341: INTO x_model_id, x_ui_def_id, x_server_id, x_export_status, x_remote_publication_id, x_object_type, x_pb_mode, g_engine_type
13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13347: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
13348: -- AND cz_model_publications.disabled_flag = '0';
13341: INTO x_model_id, x_ui_def_id, x_server_id, x_export_status, x_remote_publication_id, x_object_type, x_pb_mode, g_engine_type
13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13347: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
13348: -- AND cz_model_publications.disabled_flag = '0';
13349:
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13347: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
13348: -- AND cz_model_publications.disabled_flag = '0';
13349:
13350: ----if x_ui_def_id is null
13351: IF (x_ui_def_id IS NULL)
13352: THEN
13377: END get_source_pb_info;
13378:
13379: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13380: ------procedure that retrieves the prev publication_id, export_status, server_id, remote_publication_id
13381: ------from cz_model_publications table
13382: ------@p_publication_id : publication id whose info is required
13383: ------@p_status : publication_status
13384: ------@x_prev publication id : prev publication id
13385: ------@x_prev_export_status : prev publication status
13385: ------@x_prev_export_status : prev publication status
13386: ------@x_prev_remote_publication_id : prev remote publication id
13387: ------@x_status : publication status parameter
13388: PROCEDURE get_new_copy_pb_info(
13389: p_publication_id IN cz_model_publications.publication_id%TYPE
13390: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13391: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13392: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13393: ,x_status IN OUT NOCOPY VARCHAR2
13386: ------@x_prev_remote_publication_id : prev remote publication id
13387: ------@x_status : publication status parameter
13388: PROCEDURE get_new_copy_pb_info(
13389: p_publication_id IN cz_model_publications.publication_id%TYPE
13390: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13391: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13392: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13393: ,x_status IN OUT NOCOPY VARCHAR2
13394: )
13387: ------@x_status : publication status parameter
13388: PROCEDURE get_new_copy_pb_info(
13389: p_publication_id IN cz_model_publications.publication_id%TYPE
13390: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13391: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13392: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13393: ,x_status IN OUT NOCOPY VARCHAR2
13394: )
13395: AS
13388: PROCEDURE get_new_copy_pb_info(
13389: p_publication_id IN cz_model_publications.publication_id%TYPE
13390: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13391: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13392: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13393: ,x_status IN OUT NOCOPY VARCHAR2
13394: )
13395: AS
13396: BEGIN
13397: IF (p_publication_id IS NOT NULL)
13398: THEN
13399: SELECT publication_id, export_status, remote_publication_id
13400: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
13401: FROM cz_model_publications
13402: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
13403: END IF;
13404: EXCEPTION
13405: WHEN OTHERS
13398: THEN
13399: SELECT publication_id, export_status, remote_publication_id
13400: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
13401: FROM cz_model_publications
13402: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
13403: END IF;
13404: EXCEPTION
13405: WHEN OTHERS
13406: THEN
13413: END get_new_copy_pb_info;
13414:
13415: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13416: ------procedure that retrieves the prev publication_id, export_status, server_id, remote_publication_id
13417: ------from cz_model_publications table
13418: ------@p_publication_id : publication id whose info is required
13419: ------@p_status : publication_status
13420: ------@x_prev publication id : prev publication id
13421: ------@x_prev_export_status : prev publication status
13421: ------@x_prev_export_status : prev publication status
13422: ------@x_prev_remote_publication_id : prev remote publication id
13423: ------@x_status : publication status parameter
13424: PROCEDURE get_republish_pb_info(
13425: p_publication_id IN cz_model_publications.publication_id%TYPE
13426: ,p_status IN cz_model_publications.export_status%TYPE
13427: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13428: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13429: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13422: ------@x_prev_remote_publication_id : prev remote publication id
13423: ------@x_status : publication status parameter
13424: PROCEDURE get_republish_pb_info(
13425: p_publication_id IN cz_model_publications.publication_id%TYPE
13426: ,p_status IN cz_model_publications.export_status%TYPE
13427: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13428: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13429: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13430: ,x_status IN OUT NOCOPY VARCHAR2
13423: ------@x_status : publication status parameter
13424: PROCEDURE get_republish_pb_info(
13425: p_publication_id IN cz_model_publications.publication_id%TYPE
13426: ,p_status IN cz_model_publications.export_status%TYPE
13427: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13428: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13429: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13430: ,x_status IN OUT NOCOPY VARCHAR2
13431: )
13424: PROCEDURE get_republish_pb_info(
13425: p_publication_id IN cz_model_publications.publication_id%TYPE
13426: ,p_status IN cz_model_publications.export_status%TYPE
13427: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13428: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13429: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13430: ,x_status IN OUT NOCOPY VARCHAR2
13431: )
13432: AS
13425: p_publication_id IN cz_model_publications.publication_id%TYPE
13426: ,p_status IN cz_model_publications.export_status%TYPE
13427: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13428: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13429: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13430: ,x_status IN OUT NOCOPY VARCHAR2
13431: )
13432: AS
13433: BEGIN
13432: AS
13433: BEGIN
13434: SELECT publication_id, export_status, remote_publication_id
13435: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
13436: FROM cz_model_publications
13437: WHERE cz_model_publications.remote_publication_id = p_publication_id
13438: AND cz_model_publications.export_status = p_status
13439: AND cz_model_publications.deleted_flag = record_not_deleted;
13440: EXCEPTION
13433: BEGIN
13434: SELECT publication_id, export_status, remote_publication_id
13435: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
13436: FROM cz_model_publications
13437: WHERE cz_model_publications.remote_publication_id = p_publication_id
13438: AND cz_model_publications.export_status = p_status
13439: AND cz_model_publications.deleted_flag = record_not_deleted;
13440: EXCEPTION
13441: WHEN OTHERS
13434: SELECT publication_id, export_status, remote_publication_id
13435: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
13436: FROM cz_model_publications
13437: WHERE cz_model_publications.remote_publication_id = p_publication_id
13438: AND cz_model_publications.export_status = p_status
13439: AND cz_model_publications.deleted_flag = record_not_deleted;
13440: EXCEPTION
13441: WHEN OTHERS
13442: THEN
13435: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
13436: FROM cz_model_publications
13437: WHERE cz_model_publications.remote_publication_id = p_publication_id
13438: AND cz_model_publications.export_status = p_status
13439: AND cz_model_publications.deleted_flag = record_not_deleted;
13440: EXCEPTION
13441: WHEN OTHERS
13442: THEN
13443: cz_pb_mgr.v_err_message := 'Error in retrieving publication info (republish) for publication id : ' || p_publication_id || ' : ' || SQLERRM;
13453: ----------@x_publication_id : retrieved max publication id
13454: ----------@x_status: publication status parameter
13455: PROCEDURE get_max_pub_id(
13456: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13457: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13458: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13459: ,x_status IN OUT NOCOPY VARCHAR2
13460: )
13461: AS
13454: ----------@x_status: publication status parameter
13455: PROCEDURE get_max_pub_id(
13456: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13457: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13458: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13459: ,x_status IN OUT NOCOPY VARCHAR2
13460: )
13461: AS
13462: BEGIN
13461: AS
13462: BEGIN
13463: SELECT MAX(publication_id)
13464: INTO x_publication_id
13465: FROM cz_model_publications t
13466: WHERE t.model_id = p_model_id
13467: AND t.server_id = p_server_id
13468: AND t.model_last_struct_update = (SELECT last_struct_update
13469: FROM cz_devl_projects
13497: -----@x_status : publication status parameter
13498: PROCEDURE get_prev_publication(
13499: p_ui_str IN OUT NOCOPY VARCHAR2
13500: ,p_session_parameter IN OUT NOCOPY VARCHAR2
13501: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
13502: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13503: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13504: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13505: ,x_status IN OUT NOCOPY VARCHAR2
13498: PROCEDURE get_prev_publication(
13499: p_ui_str IN OUT NOCOPY VARCHAR2
13500: ,p_session_parameter IN OUT NOCOPY VARCHAR2
13501: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
13502: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13503: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13504: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13505: ,x_status IN OUT NOCOPY VARCHAR2
13506: )
13499: p_ui_str IN OUT NOCOPY VARCHAR2
13500: ,p_session_parameter IN OUT NOCOPY VARCHAR2
13501: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
13502: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13503: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13504: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13505: ,x_status IN OUT NOCOPY VARCHAR2
13506: )
13507: AS
13500: ,p_session_parameter IN OUT NOCOPY VARCHAR2
13501: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
13502: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13503: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13504: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13505: ,x_status IN OUT NOCOPY VARCHAR2
13506: )
13507: AS
13508: v_pr_pub_id cz_model_publications.publication_id%TYPE;
13504: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13505: ,x_status IN OUT NOCOPY VARCHAR2
13506: )
13507: AS
13508: v_pr_pub_id cz_model_publications.publication_id%TYPE;
13509: BEGIN
13510: IF ((p_ui_str = 'UI') AND(p_session_parameter <> model_copy))
13511: THEN
13512: IF (p_rem_publication_id IS NOT NULL)
13559: ------@p_old_publication_id : old publication id
13560: ------@p_link IN OUT NOCOPY : db link
13561: ------@x_status publication status parameter
13562: PROCEDURE insert_tgt_publication(
13563: p_new_publication_id IN cz_model_publications.publication_id%TYPE
13564: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
13565: ,p_model_id IN cz_model_publications.model_id%TYPE
13566: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
13567: ,p_link IN OUT NOCOPY VARCHAR2
13560: ------@p_link IN OUT NOCOPY : db link
13561: ------@x_status publication status parameter
13562: PROCEDURE insert_tgt_publication(
13563: p_new_publication_id IN cz_model_publications.publication_id%TYPE
13564: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
13565: ,p_model_id IN cz_model_publications.model_id%TYPE
13566: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
13567: ,p_link IN OUT NOCOPY VARCHAR2
13568: ,p_insert_flag IN VARCHAR2
13561: ------@x_status publication status parameter
13562: PROCEDURE insert_tgt_publication(
13563: p_new_publication_id IN cz_model_publications.publication_id%TYPE
13564: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
13565: ,p_model_id IN cz_model_publications.model_id%TYPE
13566: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
13567: ,p_link IN OUT NOCOPY VARCHAR2
13568: ,p_insert_flag IN VARCHAR2
13569: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13562: PROCEDURE insert_tgt_publication(
13563: p_new_publication_id IN cz_model_publications.publication_id%TYPE
13564: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
13565: ,p_model_id IN cz_model_publications.model_id%TYPE
13566: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
13567: ,p_link IN OUT NOCOPY VARCHAR2
13568: ,p_insert_flag IN VARCHAR2
13569: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13570: )
13565: ,p_model_id IN cz_model_publications.model_id%TYPE
13566: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
13567: ,p_link IN OUT NOCOPY VARCHAR2
13568: ,p_insert_flag IN VARCHAR2
13569: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13570: )
13571: AS
13572: v_ui_def VARCHAR2(2000);
13573: v_inst_str VARCHAR2(8000);
13586: v_src_ui_def_id := TO_CHAR(cz_pb_mgr.v_root_ui_def_id);
13587: END IF;
13588:
13589: v_inst_str :=
13590: 'INSERT INTO cz_model_publications'
13591: || p_link
13592: || ''
13593: || ' '
13594: || '(PUBLICATION_ID'
13698: || ',PAGE_LAYOUT'
13699: || ' '
13700: || ',disabled_flag'
13701: || ' '
13702: || 'FROM cz_model_publications'
13703: || ' '
13704: || 'WHERE publication_id = :11 ';
13705:
13706: EXECUTE IMMEDIATE v_inst_str
13718:
13719: ---------update remote_publication on the source
13720: IF (p_insert_flag = 'REPUBLISH')
13721: THEN
13722: UPDATE cz_model_publications
13723: SET remote_publication_id = p_new_publication_id
13724: WHERE publication_id = cz_pb_mgr.v_cz_model_pub_old_id;
13725: ELSIF(p_insert_flag = 'NEW')
13726: THEN
13723: SET remote_publication_id = p_new_publication_id
13724: WHERE publication_id = cz_pb_mgr.v_cz_model_pub_old_id;
13725: ELSIF(p_insert_flag = 'NEW')
13726: THEN
13727: UPDATE cz_model_publications
13728: SET remote_publication_id = p_new_publication_id
13729: WHERE publication_id = p_old_publication_id;
13730: END IF;
13731:
13737:
13738: ------update for republish_model api
13739: IF (cz_pb_mgr.v_republish_model = new_copy_mode)
13740: THEN
13741: EXECUTE IMMEDIATE 'UPDATE cz_model_publications'
13742: || p_link
13743: || ' t '
13744: || ' '
13745: || 'SET t.applicable_from = :1,'
13765:
13766: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13767: -----procedure that inserts publication applicability parameters on the target instance
13768: PROCEDURE insert_pb_parameters(
13769: p_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13770: ,p_old_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13771: ,p_session_parameter IN OUT NOCOPY VARCHAR2
13772: ,p_db_link IN VARCHAR2
13773: ,x_status IN OUT NOCOPY VARCHAR2
13766: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13767: -----procedure that inserts publication applicability parameters on the target instance
13768: PROCEDURE insert_pb_parameters(
13769: p_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13770: ,p_old_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13771: ,p_session_parameter IN OUT NOCOPY VARCHAR2
13772: ,p_db_link IN VARCHAR2
13773: ,x_status IN OUT NOCOPY VARCHAR2
13774: )
14061:
14062: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
14063: -----procedure that uploads publication data
14064: ----@p_publication_id : publication request id on the source database
14065: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
14066: AS
14067: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
14068: v_remote_model cz_model_publications.model_id%TYPE;
14069: v_prev_publication_id cz_model_publications.publication_id%TYPE;
14063: -----procedure that uploads publication data
14064: ----@p_publication_id : publication request id on the source database
14065: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
14066: AS
14067: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
14068: v_remote_model cz_model_publications.model_id%TYPE;
14069: v_prev_publication_id cz_model_publications.publication_id%TYPE;
14070: v_prev_export_status cz_model_publications.export_status%TYPE;
14071: BEGIN
14064: ----@p_publication_id : publication request id on the source database
14065: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
14066: AS
14067: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
14068: v_remote_model cz_model_publications.model_id%TYPE;
14069: v_prev_publication_id cz_model_publications.publication_id%TYPE;
14070: v_prev_export_status cz_model_publications.export_status%TYPE;
14071: BEGIN
14072: pbdebug := 22036;
14065: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
14066: AS
14067: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
14068: v_remote_model cz_model_publications.model_id%TYPE;
14069: v_prev_publication_id cz_model_publications.publication_id%TYPE;
14070: v_prev_export_status cz_model_publications.export_status%TYPE;
14071: BEGIN
14072: pbdebug := 22036;
14073: -------------update the status in cz_model_publications and model exports
14066: AS
14067: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
14068: v_remote_model cz_model_publications.model_id%TYPE;
14069: v_prev_publication_id cz_model_publications.publication_id%TYPE;
14070: v_prev_export_status cz_model_publications.export_status%TYPE;
14071: BEGIN
14072: pbdebug := 22036;
14073: -------------update the status in cz_model_publications and model exports
14074: update_pb_status(p_publication_id, cz_pb_mgr.v_status_code, cz_pb_mgr.v_models_to_be_exported, cz_pb_mgr.v_status_code);
14069: v_prev_publication_id cz_model_publications.publication_id%TYPE;
14070: v_prev_export_status cz_model_publications.export_status%TYPE;
14071: BEGIN
14072: pbdebug := 22036;
14073: -------------update the status in cz_model_publications and model exports
14074: update_pb_status(p_publication_id, cz_pb_mgr.v_status_code, cz_pb_mgr.v_models_to_be_exported, cz_pb_mgr.v_status_code);
14075: ------------get new publication id for the target publication
14076: get_new_publication_id(p_publication_id
14077: ,cz_pb_mgr.v_cz_model_pub_old_id
14097: ,v_prev_export_status
14098: ,cz_pb_mgr.v_prev_remote_publication_id
14099: ,cz_pb_mgr.v_status_code
14100: );
14101: --------insert the new publication into cz_model_publications table of the target db
14102: insert_tgt_publication(cz_pb_mgr.v_cz_model_pub_new_id
14103: ,cz_pb_mgr.v_cz_model_pub_old_id
14104: ,v_remote_model
14105: ,v_new_ui_def_id
14123: IF (LTRIM(RTRIM(UPPER(v_prev_export_status))) = 'PUP')
14124: THEN
14125: IF (cz_pb_mgr.v_status_code = PUBLICATION_ERROR)
14126: THEN
14127: UPDATE cz_model_publications
14128: SET export_status = 'OK'
14129: WHERE publication_id = v_prev_publication_id;
14130: ELSE
14131: UPDATE cz_model_publications
14127: UPDATE cz_model_publications
14128: SET export_status = 'OK'
14129: WHERE publication_id = v_prev_publication_id;
14130: ELSE
14131: UPDATE cz_model_publications
14132: SET deleted_flag = '1'
14133: ,export_status = 'OK'
14134: WHERE publication_id = v_prev_publication_id;
14135:
14134: WHERE publication_id = v_prev_publication_id;
14135:
14136: EXECUTE IMMEDIATE 'BEGIN'
14137: || ' '
14138: || 'UPDATE cz_model_publications'
14139: || cz_pb_mgr.v_db_link
14140: || ' '
14141: || ' '
14142: || 'SET deleted_flag = ''1'','
17852: END;
17853: -----------------------------------------------------------------------------------------------------
17854: -------------- Load data : procedure used to export data
17855: PROCEDURE load_data(
17856: v_publication_id IN cz_model_publications.publication_id%TYPE
17857: ,v_root_model_id IN cz_model_publications.model_id%TYPE
17858: ,v_server_id IN cz_model_publications.server_id%TYPE
17859: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
17860: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
17853: -----------------------------------------------------------------------------------------------------
17854: -------------- Load data : procedure used to export data
17855: PROCEDURE load_data(
17856: v_publication_id IN cz_model_publications.publication_id%TYPE
17857: ,v_root_model_id IN cz_model_publications.model_id%TYPE
17858: ,v_server_id IN cz_model_publications.server_id%TYPE
17859: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
17860: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
17861: )
17854: -------------- Load data : procedure used to export data
17855: PROCEDURE load_data(
17856: v_publication_id IN cz_model_publications.publication_id%TYPE
17857: ,v_root_model_id IN cz_model_publications.model_id%TYPE
17858: ,v_server_id IN cz_model_publications.server_id%TYPE
17859: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
17860: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
17861: )
17862: AS
17855: PROCEDURE load_data(
17856: v_publication_id IN cz_model_publications.publication_id%TYPE
17857: ,v_root_model_id IN cz_model_publications.model_id%TYPE
17858: ,v_server_id IN cz_model_publications.server_id%TYPE
17859: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
17860: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
17861: )
17862: AS
17863: v_db_link VARCHAR2(128);
18021: l_new_publication_id NUMBER;
18022: v_inst_str VARCHAR2(2000);
18023: BEGIN
18024: v_inst_str :=
18025: 'UPDATE cz_model_publications set deleted_flag = ''1'' WHERE object_id := :1 '
18026: || ' '
18027: || 'and object_type = :2 and server_id = :3 and source_target_flag = :4';
18028:
18029: EXECUTE IMMEDIATE v_inst_str
18030: USING p_temp_id, 'UIT', cz_pb_mgr.v_db_link, g_source_flag;
18031:
18032: COMMIT;
18033: v_inst_str :=
18034: 'UPDATE cz_model_publications'
18035: || cz_pb_mgr.v_db_link
18036: || ' set deleted_flag = ''1'' WHERE object_id := :1'
18037: || ' '
18038: || 'and object_type = :2 and server_id = :3 and source_target_flag = :4';
18041: USING p_temp_id, 'UIT', cz_pb_mgr.v_db_link, g_source_flag;
18042:
18043: COMMIT;
18044:
18045: SELECT cz_model_publications_s.NEXTVAL
18046: INTO l_old_publication_id
18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=
18046: INTO l_old_publication_id
18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=
18050: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
18052: ,cz_pb_mgr.v_oraclesequenceincr
18053: );
18054: v_inst_str :=
18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=
18050: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
18052: ,cz_pb_mgr.v_oraclesequenceincr
18053: );
18054: v_inst_str :=
18055: 'INSERT INTO cz_model_publications'
18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
18052: ,cz_pb_mgr.v_oraclesequenceincr
18053: );
18054: v_inst_str :=
18055: 'INSERT INTO cz_model_publications'
18056: || ' '
18057: || '(PUBLICATION_ID,MODEL_ID,OBJECT_ID,OBJECT_TYPE,SERVER_ID,ORGANIZATION_ID,TOP_ITEM_ID,PRODUCT_KEY'
18058: || ' '
18059: || ',PUBLICATION_MODE,UI_DEF_ID,UI_STYLE,APPLICABLE_FROM,APPLICABLE_UNTIL,EXPORT_STATUS,MODEL_PERSISTENT_ID'
18075: EXECUTE IMMEDIATE v_inst_str
18076: USING l_old_publication_id, p_temp_id, p_temp_id, l_remote_publication_id;
18077:
18078: v_inst_str :=
18079: 'INSERT INTO cz_model_publications'
18080: || cz_pb_mgr.v_db_link
18081: || ''
18082: || ' '
18083: || '(PUBLICATION_ID,MODEL_ID,OBJECT_ID,OBJECT_TYPE,SERVER_ID,ORGANIZATION_ID,TOP_ITEM_ID,PRODUCT_KEY'
18255: PROCEDURE proc_export(
18256: publicationid IN NUMBER
18257: ,modelid IN NUMBER
18258: ,serverid IN NUMBER
18259: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
18260: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
18261: )
18262: IS
18263: CURSOR model_cur(rootmodelid NUMBER, serverid NUMBER, pubid NUMBER)
18621: v_object_id cz_rp_entries.object_id%TYPE;
18622: v_copy_number NUMBER := 0.0;
18623: v_rp_orig_sys_ref VARCHAR2(255);
18624: v_imp_ps_node_count PLS_INTEGER := 0;
18625: v_pub_id cz_model_publications.publication_id%TYPE;
18626: l_msg_index NUMBER;
18627: failed_to_lock_model EXCEPTION;
18628: l_msg_data VARCHAR2(2000);
18629: l_msg_count NUMBER := 0;
18854: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18855: ELSE
18856: -----------create a dummy publication
18857: BEGIN
18858: SELECT cz_model_publications_s.NEXTVAL
18859: INTO cz_pb_mgr.v_publication_id
18860: FROM DUAL;
18861:
18862: v_pub_id := cz_pb_mgr.v_publication_id;
18868: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18869: END;
18870:
18871: BEGIN
18872: INSERT INTO cz_model_publications
18873: (publication_id, model_id, server_id, product_key, publication_mode
18874: ,ui_def_id, ui_style, applicable_from, applicable_until, deleted_flag, model_last_struct_update, model_last_logic_update
18875: ,model_last_updated, source_target_flag, object_id, object_type, disabled_flag
18876: )
19253: x_model_id := v_object_id;
19254: END IF;
19255:
19256: ----------delete dummy publication record
19257: DELETE FROM cz_model_publications
19258: WHERE publication_id = v_pub_id;
19259:
19260: DELETE FROM cz_model_publications
19261: WHERE remote_publication_id = v_pub_id;
19256: ----------delete dummy publication record
19257: DELETE FROM cz_model_publications
19258: WHERE publication_id = v_pub_id;
19259:
19260: DELETE FROM cz_model_publications
19261: WHERE remote_publication_id = v_pub_id;
19262:
19263: DELETE FROM cz_pb_model_exports
19264: WHERE publication_id = v_pub_id;
19346: PROCEDURE publish_all_models
19347: AS
19348:
19349: l_publication_id_tbl cz_pb_mgr.number_type_tbl;
19350: v_tobepublished cz_model_publications.publication_id%TYPE;
19351: v_run_id cz_db_logs.run_id%TYPE;
19352: v_pb_status cz_model_publications.export_status%TYPE;
19353: BEGIN
19354:
19348:
19349: l_publication_id_tbl cz_pb_mgr.number_type_tbl;
19350: v_tobepublished cz_model_publications.publication_id%TYPE;
19351: v_run_id cz_db_logs.run_id%TYPE;
19352: v_pb_status cz_model_publications.export_status%TYPE;
19353: BEGIN
19354:
19355: SELECT publication_id BULK COLLECT INTO l_publication_id_tbl
19356: FROM cz_model_publications
19352: v_pb_status cz_model_publications.export_status%TYPE;
19353: BEGIN
19354:
19355: SELECT publication_id BULK COLLECT INTO l_publication_id_tbl
19356: FROM cz_model_publications
19357: WHERE cz_model_publications.deleted_flag = record_not_deleted
19358: AND cz_model_publications.export_status = publication_pending
19359: AND UPPER(object_type) = model_publication
19360: ORDER BY publication_id;
19353: BEGIN
19354:
19355: SELECT publication_id BULK COLLECT INTO l_publication_id_tbl
19356: FROM cz_model_publications
19357: WHERE cz_model_publications.deleted_flag = record_not_deleted
19358: AND cz_model_publications.export_status = publication_pending
19359: AND UPPER(object_type) = model_publication
19360: ORDER BY publication_id;
19361:
19354:
19355: SELECT publication_id BULK COLLECT INTO l_publication_id_tbl
19356: FROM cz_model_publications
19357: WHERE cz_model_publications.deleted_flag = record_not_deleted
19358: AND cz_model_publications.export_status = publication_pending
19359: AND UPPER(object_type) = model_publication
19360: ORDER BY publication_id;
19361:
19362: IF l_publication_id_tbl.COUNT > 0 THEN
19375: END publish_all_models;
19376:
19377: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19378: -----initialize pb parameters
19379: PROCEDURE initialize_pb_parameters(p_publication_id IN cz_model_publications.publication_id%TYPE)
19380: AS
19381: l_log_pb_time cz_db_settings.VALUE%TYPE;
19382: l_pub_mode cz_model_publications.publication_mode%TYPE;
19383: BEGIN
19378: -----initialize pb parameters
19379: PROCEDURE initialize_pb_parameters(p_publication_id IN cz_model_publications.publication_id%TYPE)
19380: AS
19381: l_log_pb_time cz_db_settings.VALUE%TYPE;
19382: l_pub_mode cz_model_publications.publication_mode%TYPE;
19383: BEGIN
19384: fnd_msg_pub.initialize;
19385: cz_pb_mgr.v_publication_id := p_publication_id;
19386: cz_pb_mgr.sequence_const := 0;
19399: v_refresh_rules := 'NO';
19400:
19401: SELECT publication_mode
19402: INTO l_pub_mode
19403: FROM cz_model_publications
19404: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted;
19405:
19406: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
19407: THEN
19459: RAISE;
19460: END initialize_pb_parameters;
19461:
19462: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19463: PROCEDURE check_ui_template_exist(p_template_id IN NUMBER, x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE)
19464: IS
19465: l_count NUMBER := 0;
19466: BEGIN
19467: SELECT 1
19485: --------@p_model_id : model id of the pb request
19486: --------@p_ui_def_id : ui_def_id of the request
19487: --------@x_status : publication status parameter
19488: PROCEDURE check_model_ui_exist(
19489: p_publication_id IN cz_model_publications.publication_id%TYPE
19490: ,p_model_id IN cz_model_publications.model_id%TYPE
19491: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19492: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19493: )
19486: --------@p_ui_def_id : ui_def_id of the request
19487: --------@x_status : publication status parameter
19488: PROCEDURE check_model_ui_exist(
19489: p_publication_id IN cz_model_publications.publication_id%TYPE
19490: ,p_model_id IN cz_model_publications.model_id%TYPE
19491: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19492: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19493: )
19494: AS
19487: --------@x_status : publication status parameter
19488: PROCEDURE check_model_ui_exist(
19489: p_publication_id IN cz_model_publications.publication_id%TYPE
19490: ,p_model_id IN cz_model_publications.model_id%TYPE
19491: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19492: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19493: )
19494: AS
19495: v_model_chk_count NUMBER := 0.0;
19488: PROCEDURE check_model_ui_exist(
19489: p_publication_id IN cz_model_publications.publication_id%TYPE
19490: ,p_model_id IN cz_model_publications.model_id%TYPE
19491: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19492: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19493: )
19494: AS
19495: v_model_chk_count NUMBER := 0.0;
19496: v_ui_chk_count NUMBER := 0.0;
19540:
19541: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19542: -------procedure that gets the target ui def id in case no new copy is made
19543: PROCEDURE get_tgt_ui_def(
19544: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19545: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
19546: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
19547: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19541: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19542: -------procedure that gets the target ui def id in case no new copy is made
19543: PROCEDURE get_tgt_ui_def(
19544: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19545: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
19546: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
19547: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19549: )
19542: -------procedure that gets the target ui def id in case no new copy is made
19543: PROCEDURE get_tgt_ui_def(
19544: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19545: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
19546: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
19547: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19549: )
19550: AS
19543: PROCEDURE get_tgt_ui_def(
19544: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19545: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
19546: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
19547: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19549: )
19550: AS
19551: v_ui_name cz_ui_defs.NAME%TYPE;
19544: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
19545: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
19546: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
19547: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19549: )
19550: AS
19551: v_ui_name cz_ui_defs.NAME%TYPE;
19552: v_old_remote_model cz_model_publications.model_id%TYPE;
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19549: )
19550: AS
19551: v_ui_name cz_ui_defs.NAME%TYPE;
19552: v_old_remote_model cz_model_publications.model_id%TYPE;
19553: ui_cv ref_cursor;
19554: BEGIN
19555: BEGIN
19556: SELECT NAME
19605: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19606: -----procedure that checks the export status of the existing request
19607: -----Only requests with a status of PEN can be published
19608: PROCEDURE check_export_status(
19609: p_export_status IN cz_model_publications.export_status%TYPE
19610: ,p_pb_flag IN VARCHAR2
19611: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19612: )
19613: AS
19607: -----Only requests with a status of PEN can be published
19608: PROCEDURE check_export_status(
19609: p_export_status IN cz_model_publications.export_status%TYPE
19610: ,p_pb_flag IN VARCHAR2
19611: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19612: )
19613: AS
19614: BEGIN
19615: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
19982: l_publication_proc CONSTANT VARCHAR2(10) := 'CZ_PB_MGR';
19983: l_migration_proc CONSTANT VARCHAR2(20) := 'CZ_MODEL_MIGRATION';
19984: l_proc_name v$session.module%TYPE;
19985: v_check_publication BOOLEAN;
19986: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;
19989: v_prev_export_status cz_model_publications.export_status%TYPE;
19990: v_cur_export_status cz_model_publications.export_status%TYPE;
19983: l_migration_proc CONSTANT VARCHAR2(20) := 'CZ_MODEL_MIGRATION';
19984: l_proc_name v$session.module%TYPE;
19985: v_check_publication BOOLEAN;
19986: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;
19989: v_prev_export_status cz_model_publications.export_status%TYPE;
19990: v_cur_export_status cz_model_publications.export_status%TYPE;
19991: v_pb_mode cz_model_publications.publication_mode%TYPE;
19984: l_proc_name v$session.module%TYPE;
19985: v_check_publication BOOLEAN;
19986: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;
19989: v_prev_export_status cz_model_publications.export_status%TYPE;
19990: v_cur_export_status cz_model_publications.export_status%TYPE;
19991: v_pb_mode cz_model_publications.publication_mode%TYPE;
19992: l_tgt_status VARCHAR2(1);
19985: v_check_publication BOOLEAN;
19986: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;
19989: v_prev_export_status cz_model_publications.export_status%TYPE;
19990: v_cur_export_status cz_model_publications.export_status%TYPE;
19991: v_pb_mode cz_model_publications.publication_mode%TYPE;
19992: l_tgt_status VARCHAR2(1);
19993: l_tgt_msg VARCHAR2(2000);
19986: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;
19989: v_prev_export_status cz_model_publications.export_status%TYPE;
19990: v_cur_export_status cz_model_publications.export_status%TYPE;
19991: v_pb_mode cz_model_publications.publication_mode%TYPE;
19992: l_tgt_status VARCHAR2(1);
19993: l_tgt_msg VARCHAR2(2000);
19994: l_msg_data VARCHAR2(2000);
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;
19989: v_prev_export_status cz_model_publications.export_status%TYPE;
19990: v_cur_export_status cz_model_publications.export_status%TYPE;
19991: v_pb_mode cz_model_publications.publication_mode%TYPE;
19992: l_tgt_status VARCHAR2(1);
19993: l_tgt_msg VARCHAR2(2000);
19994: l_msg_data VARCHAR2(2000);
19995: l_msg_count NUMBER;
20250:
20251: RAISE failed_to_lock_model;
20252: END IF;
20253:
20254: UPDATE cz_model_publications
20255: SET export_status = publication_processing
20256: WHERE publication_id = cz_pb_mgr.v_publication_id;
20257:
20258: IF (v_check_publication) THEN
20720:
20721: ------reset status to the original if a re-publish fails
20722: IF (LTRIM(RTRIM(UPPER(v_prev_export_status))) = 'PUP') THEN
20723: IF (cz_pb_mgr.v_status_code = PUBLICATION_ERROR) THEN
20724: UPDATE cz_model_publications
20725: SET export_status = 'OK'
20726: WHERE publication_id = v_prev_publication_id;
20727: ELSE
20728: UPDATE cz_model_publications
20724: UPDATE cz_model_publications
20725: SET export_status = 'OK'
20726: WHERE publication_id = v_prev_publication_id;
20727: ELSE
20728: UPDATE cz_model_publications
20729: SET deleted_flag = '1'
20730: WHERE publication_id = v_prev_publication_id;
20731:
20732: EXECUTE IMMEDIATE 'BEGIN'
20730: WHERE publication_id = v_prev_publication_id;
20731:
20732: EXECUTE IMMEDIATE 'BEGIN'
20733: || ' '
20734: || 'UPDATE cz_model_publications'
20735: || cz_pb_mgr.v_db_link
20736: || ''
20737: || ' '
20738: || 'SET deleted_flag = ''1'''
20978: ,x_msg_count OUT NOCOPY NUMBER
20979: ,x_msg_data OUT NOCOPY VARCHAR2
20980: )
20981: AS
20982: v_server_id cz_model_publications.server_id%TYPE;
20983: v_cz_link_name cz_servers.cz_link_name%TYPE;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;
20980: )
20981: AS
20982: v_server_id cz_model_publications.server_id%TYPE;
20983: v_cz_link_name cz_servers.cz_link_name%TYPE;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;
20987: l_object_type cz_model_publications.object_type%TYPE;
20988: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
20981: AS
20982: v_server_id cz_model_publications.server_id%TYPE;
20983: v_cz_link_name cz_servers.cz_link_name%TYPE;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;
20987: l_object_type cz_model_publications.object_type%TYPE;
20988: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
20989: no_link_name EXCEPTION;
20983: v_cz_link_name cz_servers.cz_link_name%TYPE;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;
20987: l_object_type cz_model_publications.object_type%TYPE;
20988: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
20989: no_link_name EXCEPTION;
20990: invalid_object_type EXCEPTION;
20991: template_in_use EXCEPTION;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;
20987: l_object_type cz_model_publications.object_type%TYPE;
20988: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
20989: no_link_name EXCEPTION;
20990: invalid_object_type EXCEPTION;
20991: template_in_use EXCEPTION;
20992: cannot_del_pup EXCEPTION;
20989: no_link_name EXCEPTION;
20990: invalid_object_type EXCEPTION;
20991: template_in_use EXCEPTION;
20992: cannot_del_pup EXCEPTION;
20993: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20994: BEGIN
20995: fnd_msg_pub.initialize;
20996: x_return_status := FND_API.G_RET_STS_SUCCESS;
20997: x_msg_count := 0;
21007: END IF;
21008:
21009: SELECT server_id, export_status, remote_publication_id, object_type
21010: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
21011: FROM cz_model_publications
21012: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
21013:
21014:
21015: --execute the procedure that obsoletes the records
21008:
21009: SELECT server_id, export_status, remote_publication_id, object_type
21010: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
21011: FROM cz_model_publications
21012: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
21013:
21014:
21015: --execute the procedure that obsoletes the records
21016: --if the target has been converted into a development instance
21021: --it is possible that the obsoleting process changed value of the publication record.
21022: --so requery
21023: SELECT server_id, export_status, remote_publication_id, object_type
21024: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
21025: FROM cz_model_publications
21026: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
21027: END IF;
21028:
21029: IF (v_export_status = 'PUP')
21022: --so requery
21023: SELECT server_id, export_status, remote_publication_id, object_type
21024: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
21025: FROM cz_model_publications
21026: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
21027: END IF;
21028:
21029: IF (v_export_status = 'PUP')
21030: THEN
21034: ----check for reset cases
21035: BEGIN
21036: SELECT publication_id
21037: INTO l_reset_publication
21038: FROM cz_model_publications
21039: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21035: BEGIN
21036: SELECT publication_id
21037: INTO l_reset_publication
21038: FROM cz_model_publications
21039: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21043: --SPUPPALA bug#7116052 7-AUG-2009.
21036: SELECT publication_id
21037: INTO l_reset_publication
21038: FROM cz_model_publications
21039: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21043: --SPUPPALA bug#7116052 7-AUG-2009.
21044: --AND cz_model_publications.publication_mode = l_pub_mode;
21037: INTO l_reset_publication
21038: FROM cz_model_publications
21039: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21043: --SPUPPALA bug#7116052 7-AUG-2009.
21044: --AND cz_model_publications.publication_mode = l_pub_mode;
21045: EXCEPTION
21038: FROM cz_model_publications
21039: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21043: --SPUPPALA bug#7116052 7-AUG-2009.
21044: --AND cz_model_publications.publication_mode = l_pub_mode;
21045: EXCEPTION
21046: WHEN OTHERS
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21043: --SPUPPALA bug#7116052 7-AUG-2009.
21044: --AND cz_model_publications.publication_mode = l_pub_mode;
21045: EXCEPTION
21046: WHEN OTHERS
21047: THEN
21048: l_reset_publication := 0;
21082: RAISE template_in_use;
21083: END IF;
21084: END IF;
21085:
21086: UPDATE cz_model_publications
21087: SET deleted_flag = '1'
21088: WHERE publication_id = publicationid;
21089:
21090: DELETE FROM cz_pb_client_apps
21094: WHERE publication_id = publicationid;
21095:
21096: IF (l_reset_publication > 0)
21097: THEN
21098: UPDATE cz_model_publications
21099: SET export_status = 'OK'
21100: WHERE publication_id = l_reset_publication;
21101: END IF;
21102:
21103: IF ((v_export_status <> 'PEN') AND(v_remote_publication_id IS NOT NULL))
21104: THEN
21105: EXECUTE IMMEDIATE 'BEGIN'
21106: || ' '
21107: || 'UPDATE cz_model_publications'
21108: || v_cz_link_name
21109: || ''
21110: || ' '
21111: || 'SET deleted_flag = ''1'''
21181: ,x_msg_count OUT NOCOPY NUMBER
21182: ,x_msg_data OUT NOCOPY VARCHAR2
21183: )
21184: AS
21185: v_server_id cz_model_publications.server_id%TYPE;
21186: v_cz_link_name cz_servers.cz_link_name%TYPE;
21187: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21188: v_object_type cz_model_publications.object_type%TYPE;
21189: v_export_status cz_model_publications.export_status%TYPE;
21183: )
21184: AS
21185: v_server_id cz_model_publications.server_id%TYPE;
21186: v_cz_link_name cz_servers.cz_link_name%TYPE;
21187: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21188: v_object_type cz_model_publications.object_type%TYPE;
21189: v_export_status cz_model_publications.export_status%TYPE;
21190: cannot_disable_template EXCEPTION;
21191: cannot_disable_publication EXCEPTION;
21184: AS
21185: v_server_id cz_model_publications.server_id%TYPE;
21186: v_cz_link_name cz_servers.cz_link_name%TYPE;
21187: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21188: v_object_type cz_model_publications.object_type%TYPE;
21189: v_export_status cz_model_publications.export_status%TYPE;
21190: cannot_disable_template EXCEPTION;
21191: cannot_disable_publication EXCEPTION;
21192: BEGIN
21185: v_server_id cz_model_publications.server_id%TYPE;
21186: v_cz_link_name cz_servers.cz_link_name%TYPE;
21187: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21188: v_object_type cz_model_publications.object_type%TYPE;
21189: v_export_status cz_model_publications.export_status%TYPE;
21190: cannot_disable_template EXCEPTION;
21191: cannot_disable_publication EXCEPTION;
21192: BEGIN
21193: x_return_status := FND_API.G_RET_STS_SUCCESS;
21203: END IF;
21204:
21205: SELECT object_type, server_id, remote_publication_id, export_status
21206: INTO v_object_type, v_server_id, v_remote_publication_id, v_export_status
21207: FROM cz_model_publications
21208: WHERE cz_model_publications.publication_id = publicationid;
21209:
21210: BEGIN
21211: SELECT fndnam_link_name
21204:
21205: SELECT object_type, server_id, remote_publication_id, export_status
21206: INTO v_object_type, v_server_id, v_remote_publication_id, v_export_status
21207: FROM cz_model_publications
21208: WHERE cz_model_publications.publication_id = publicationid;
21209:
21210: BEGIN
21211: SELECT fndnam_link_name
21212: INTO v_cz_link_name
21236: END IF;
21237:
21238: cz_pb_mgr.remote_publication_id := v_remote_publication_id;
21239:
21240: UPDATE cz_model_publications
21241: SET disabled_flag = '1'
21242: WHERE publication_id = publicationid;
21243:
21244: EXECUTE IMMEDIATE 'BEGIN'
21242: WHERE publication_id = publicationid;
21243:
21244: EXECUTE IMMEDIATE 'BEGIN'
21245: || ' '
21246: || 'UPDATE cz_model_publications'
21247: || v_cz_link_name
21248: || ''
21249: || ' '
21250: || 'SET disabled_flag = ''1'''
21278: END disable_publication;
21279:
21280: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21281: PROCEDURE get_edit_info(
21282: publicationid IN cz_model_publications.publication_id%TYPE
21283: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21279:
21280: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21281: PROCEDURE get_edit_info(
21282: publicationid IN cz_model_publications.publication_id%TYPE
21283: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
21282: publicationid IN cz_model_publications.publication_id%TYPE
21283: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
21288: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
21289: )
21290: AS
21283: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
21288: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
21289: )
21290: AS
21291: BEGIN
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
21288: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
21289: )
21290: AS
21291: BEGIN
21292: SELECT product_key, publication_mode, server_id, export_status, source_target_flag, remote_publication_id
21290: AS
21291: BEGIN
21292: SELECT product_key, publication_mode, server_id, export_status, source_target_flag, remote_publication_id
21293: INTO x_product_key, x_publication_mode, x_server_id, x_export_status, x_source_target_flag, x_remote_publication_id
21294: FROM cz_model_publications
21295: WHERE cz_model_publications.publication_id = publicationid;
21296: EXCEPTION
21297: WHEN OTHERS
21298: THEN
21291: BEGIN
21292: SELECT product_key, publication_mode, server_id, export_status, source_target_flag, remote_publication_id
21293: INTO x_product_key, x_publication_mode, x_server_id, x_export_status, x_source_target_flag, x_remote_publication_id
21294: FROM cz_model_publications
21295: WHERE cz_model_publications.publication_id = publicationid;
21296: EXCEPTION
21297: WHEN OTHERS
21298: THEN
21299: NULL;
21363: RAISE;
21364: END;
21365:
21366: -------->>>>>>>>>>>>>>>>>>
21367: PROCEDURE delete_src_pb_data(publicationid IN cz_model_publications.publication_id%TYPE)
21368: AS
21369: BEGIN
21370: DELETE FROM cz_publication_usages
21371: WHERE cz_publication_usages.publication_id = publicationid;
21382: END;
21383:
21384: ------->>>>>>>>>>>>>>>>>>>>>>
21385: PROCEDURE insert_src_pb_data(
21386: publicationid IN cz_model_publications.publication_id%TYPE
21387: ,p_application_id_tbl IN cz_pb_mgr.t_ref
21388: ,p_language_id_tbl IN cz_pb_mgr.t_lang_code
21389: ,p_usage_id_tbl IN cz_pb_mgr.t_ref
21390: ,x_status IN OUT NOCOPY VARCHAR2
21434:
21435: -------->>>>>>>>>>>>>>>>>>>>>
21436: PROCEDURE insert_tgt_pb_data(
21437: p_status_str IN OUT NOCOPY VARCHAR2
21438: ,p_export_status IN cz_model_publications.export_status%TYPE
21439: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE
21440: ,p_publication_mode IN VARCHAR2
21441: ,p_start_date IN DATE
21442: ,p_disable_date IN DATE
21439: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE
21440: ,p_publication_mode IN VARCHAR2
21441: ,p_start_date IN DATE
21442: ,p_disable_date IN DATE
21443: ,p_remote_publication_id IN cz_model_publications.remote_publication_id%TYPE
21444: ,p_application_id_tbl IN cz_pb_mgr.t_ref
21445: ,p_language_id_tbl IN cz_pb_mgr.t_lang_code
21446: ,p_usage_id_tbl IN cz_pb_mgr.t_ref
21447: )
21452: BEGIN
21453: IF ((p_status_str <> '-1') AND(p_export_status <> 'PEN'))
21454: THEN
21455: v_edit_str :=
21456: 'UPDATE cz_model_publications'
21457: || p_tgt_link
21458: || ' '
21459: || 'SET publication_mode = :1,'
21460: || ' '
21542: ,x_msg_count OUT NOCOPY NUMBER
21543: ,x_msg_data OUT NOCOPY VARCHAR2
21544: )
21545: AS
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21543: ,x_msg_data OUT NOCOPY VARCHAR2
21544: )
21545: AS
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21544: )
21545: AS
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21552: v_count NUMBER;
21545: AS
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21552: v_count NUMBER;
21553: v_application_id VARCHAR2(2000);
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21552: v_count NUMBER;
21553: v_application_id VARCHAR2(2000);
21554: v_language_id VARCHAR2(2000);
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21552: v_count NUMBER;
21553: v_application_id VARCHAR2(2000);
21554: v_language_id VARCHAR2(2000);
21555: v_usage_id VARCHAR2(2000);
21579:
21580: BEGIN
21581: SELECT publication_id
21582: INTO l_publication_id
21583: FROM cz_model_publications
21584: WHERE cz_model_publications.publication_id = publicationid;
21585: EXCEPTION
21586: WHEN NO_DATA_FOUND
21587: THEN
21580: BEGIN
21581: SELECT publication_id
21582: INTO l_publication_id
21583: FROM cz_model_publications
21584: WHERE cz_model_publications.publication_id = publicationid;
21585: EXCEPTION
21586: WHEN NO_DATA_FOUND
21587: THEN
21588: RAISE no_pub_found;
21589: END;
21590:
21591: SELECT COUNT(*)
21592: INTO v_count
21593: FROM cz_model_publications
21594: WHERE cz_model_publications.publication_id = publicationid
21595: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
21596:
21597: IF (v_count = 0)
21590:
21591: SELECT COUNT(*)
21592: INTO v_count
21593: FROM cz_model_publications
21594: WHERE cz_model_publications.publication_id = publicationid
21595: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
21596:
21597: IF (v_count = 0)
21598: THEN
21591: SELECT COUNT(*)
21592: INTO v_count
21593: FROM cz_model_publications
21594: WHERE cz_model_publications.publication_id = publicationid
21595: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
21596:
21597: IF (v_count = 0)
21598: THEN
21599: x_return_status := FND_API.G_RET_STS_ERROR;
21608: ELSE
21609: v_tgt_link := retrieve_db_link(v_server_id);
21610: END IF;
21611:
21612: UPDATE cz_model_publications
21613: SET publication_mode = publicationmode
21614: ,applicable_from = startdate
21615: ,applicable_until = disabledate
21616: WHERE publication_id = publicationid;
21668: ,x_msg_count OUT NOCOPY NUMBER
21669: ,x_msg_data OUT NOCOPY VARCHAR2
21670: )
21671: AS
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21669: ,x_msg_data OUT NOCOPY VARCHAR2
21670: )
21671: AS
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21670: )
21671: AS
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21678: v_count NUMBER;
21671: AS
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21678: v_count NUMBER;
21679: v_application_id VARCHAR2(2000);
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21678: v_count NUMBER;
21679: v_application_id VARCHAR2(2000);
21680: v_language_id VARCHAR2(2000);
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21678: v_count NUMBER;
21679: v_application_id VARCHAR2(2000);
21680: v_language_id VARCHAR2(2000);
21681: v_usage_id VARCHAR2(2000);
21702:
21703: BEGIN
21704: SELECT publication_id
21705: INTO l_publication_id
21706: FROM cz_model_publications
21707: WHERE cz_model_publications.publication_id = publicationid;
21708: EXCEPTION
21709: WHEN NO_DATA_FOUND
21710: THEN
21703: BEGIN
21704: SELECT publication_id
21705: INTO l_publication_id
21706: FROM cz_model_publications
21707: WHERE cz_model_publications.publication_id = publicationid;
21708: EXCEPTION
21709: WHEN NO_DATA_FOUND
21710: THEN
21711: RAISE no_pub_found;
21712: END;
21713:
21714: SELECT COUNT(*)
21715: INTO v_count
21716: FROM cz_model_publications
21717: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
21718:
21719: IF (v_count = 0)
21720: THEN
21713:
21714: SELECT COUNT(*)
21715: INTO v_count
21716: FROM cz_model_publications
21717: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
21718:
21719: IF (v_count = 0)
21720: THEN
21721: x_return_status := FND_API.G_RET_STS_ERROR;
21730: ELSE
21731: v_tgt_link := retrieve_db_link(v_server_id);
21732: END IF;
21733:
21734: UPDATE cz_model_publications
21735: SET publication_mode = publicationmode
21736: ,applicable_from = startdate
21737: ,applicable_until = disabledate
21738: WHERE publication_id = publicationid;
21786: ,x_msg_count OUT NOCOPY NUMBER
21787: ,x_msg_data OUT NOCOPY VARCHAR2
21788: )
21789: AS
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21787: ,x_msg_data OUT NOCOPY VARCHAR2
21788: )
21789: AS
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21788: )
21789: AS
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21796: v_count NUMBER;
21789: AS
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21796: v_count NUMBER;
21797: v_application_id VARCHAR2(2000);
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21796: v_count NUMBER;
21797: v_application_id VARCHAR2(2000);
21798: v_language_id VARCHAR2(2000);
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21796: v_count NUMBER;
21797: v_application_id VARCHAR2(2000);
21798: v_language_id VARCHAR2(2000);
21799: v_usage_id VARCHAR2(2000);
21823:
21824: BEGIN
21825: SELECT publication_id
21826: INTO l_publication_id
21827: FROM cz_model_publications
21828: WHERE cz_model_publications.publication_id = publicationid;
21829: EXCEPTION
21830: WHEN NO_DATA_FOUND
21831: THEN
21824: BEGIN
21825: SELECT publication_id
21826: INTO l_publication_id
21827: FROM cz_model_publications
21828: WHERE cz_model_publications.publication_id = publicationid;
21829: EXCEPTION
21830: WHEN NO_DATA_FOUND
21831: THEN
21832: RAISE no_pub_found;
21833: END;
21834:
21835: SELECT COUNT(*)
21836: INTO v_count
21837: FROM cz_model_publications
21838: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
21839:
21840: IF (v_count = 0)
21841: THEN
21834:
21835: SELECT COUNT(*)
21836: INTO v_count
21837: FROM cz_model_publications
21838: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
21839:
21840: IF (v_count = 0)
21841: THEN
21842: x_return_status := FND_API.G_RET_STS_ERROR;
21851: ELSE
21852: v_tgt_link := retrieve_db_link(v_server_id);
21853: END IF;
21854:
21855: -----UPDATE cz_model_publications
21856: -----SET publication_mode = publicationMode,
21857: -----applicable_from = startDate,
21858: -----applicable_until = disableDate
21859: -----WHERE publication_id = publicationId;
22149: PROCEDURE reset_processing_pubs
22150: IS
22151: v_link_name cz_servers.fndnam_link_name%TYPE;
22152: v_db_link VARCHAR2(255);
22153: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
22154: BEGIN
22155: fnd_msg_pub.initialize;
22156:
22157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
22162: l_pub_mode := cz_model_migration_pvt.mode_copy;
22163: END IF;
22164:
22165: FOR i IN (SELECT publication_id, remote_publication_id, server_id
22166: FROM cz_model_publications
22167: WHERE UPPER(export_status) = publication_processing AND deleted_flag = '0')
22168: LOOP
22169: BEGIN
22170: SELECT fndnam_link_name
22181:
22182: --
22183: -- mark remote publication as deleted
22184: --
22185: EXECUTE IMMEDIATE 'UPDATE CZ_MODEL_PUBLICATIONS' || v_db_link || ' SET deleted_flag=:1' || ' WHERE publication_id = :2'
22186: USING '1', i.remote_publication_id;
22187: EXCEPTION
22188: WHEN NO_DATA_FOUND
22189: THEN
22195: END LOOP;
22196:
22197: DELETE FROM cz_pb_model_exports
22198: WHERE publication_id IN(SELECT publication_id
22199: FROM cz_model_publications
22200: WHERE UPPER(export_status) = publication_processing);
22201:
22202: UPDATE cz_model_publications
22203: SET export_status = publication_pending
22198: WHERE publication_id IN(SELECT publication_id
22199: FROM cz_model_publications
22200: WHERE UPPER(export_status) = publication_processing);
22201:
22202: UPDATE cz_model_publications
22203: SET export_status = publication_pending
22204: WHERE UPPER(export_status) = publication_processing;
22205:
22206: COMMIT;
22228: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22229: ------procedure that gets applicability parameters for the
22230: ------publication to be republished
22231: PROCEDURE get_pb_parameters(
22232: p_publication_id IN cz_model_publications.publication_id%TYPE
22233: ,x_applicationid_tbl IN OUT NOCOPY cz_pb_mgr.t_ref
22234: ,x_usageid_tbl IN OUT NOCOPY cz_pb_mgr.t_ref
22235: ,x_languageid_tbl IN OUT NOCOPY cz_pb_mgr.t_lang_code
22236: ,x_status IN OUT NOCOPY VARCHAR2
22269: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22270: ------procedure that creates a new publication request
22271: ------for republish
22272: PROCEDURE create_republish_request(
22273: p_publication_id IN cz_model_publications.publication_id%TYPE
22274: ,p_start_date IN DATE
22275: ,p_end_date IN DATE
22276: ,x_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
22277: ,p_repub_str IN VARCHAR2
22272: PROCEDURE create_republish_request(
22273: p_publication_id IN cz_model_publications.publication_id%TYPE
22274: ,p_start_date IN DATE
22275: ,p_end_date IN DATE
22276: ,x_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
22277: ,p_repub_str IN VARCHAR2
22278: ,x_status IN OUT NOCOPY VARCHAR2
22279: )
22280: AS
22277: ,p_repub_str IN VARCHAR2
22278: ,x_status IN OUT NOCOPY VARCHAR2
22279: )
22280: AS
22281: v_new_publication_id cz_model_publications.publication_id%TYPE;
22282: v_old_publication_id cz_model_publications.publication_id%TYPE;
22283: BEGIN
22284: x_status := 'OK';
22285:
22278: ,x_status IN OUT NOCOPY VARCHAR2
22279: )
22280: AS
22281: v_new_publication_id cz_model_publications.publication_id%TYPE;
22282: v_old_publication_id cz_model_publications.publication_id%TYPE;
22283: BEGIN
22284: x_status := 'OK';
22285:
22286: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22282: v_old_publication_id cz_model_publications.publication_id%TYPE;
22283: BEGIN
22284: x_status := 'OK';
22285:
22286: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22287: INTO v_new_publication_id, v_old_publication_id
22288: FROM DUAL;
22289:
22290: INSERT INTO cz_model_publications
22286: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22287: INTO v_new_publication_id, v_old_publication_id
22288: FROM DUAL;
22289:
22290: INSERT INTO cz_model_publications
22291: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
22292: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update
22293: ,model_last_updated, user_str01, user_str02, user_str03, user_str04, user_num01, user_num02, user_num03, user_num04
22294: ,model_persistent_id, source_target_flag, remote_publication_id, disabled_flag, object_id, object_type)
22295: SELECT v_new_publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
22296: ,p_start_date, p_end_date, 'PEN', '0', model_last_struct_update, model_last_logic_update, model_last_updated, user_str01, user_str02
22297: ,user_str03, user_str04, user_num01, user_num02, user_num03, user_num04, model_persistent_id, source_target_flag
22298: ,remote_publication_id, disabled_flag, object_id, object_type
22299: FROM cz_model_publications
22300: WHERE publication_id = p_publication_id;
22301:
22302: v_repub_parameter := pub_model;
22303: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_status);
22303: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_status);
22304:
22305: IF (p_repub_str = new_copy_str)
22306: THEN
22307: UPDATE cz_model_publications
22308: SET remote_publication_id = NULL
22309: WHERE publication_id = v_new_publication_id;
22310: ELSIF(p_repub_str = repub_str)
22311: THEN
22308: SET remote_publication_id = NULL
22309: WHERE publication_id = v_new_publication_id;
22310: ELSIF(p_repub_str = repub_str)
22311: THEN
22312: UPDATE cz_model_publications
22313: SET export_status = 'PUP'
22314: WHERE publication_id = p_publication_id;
22315: END IF;
22316:
22332: ,x_msg_count OUT NOCOPY NUMBER
22333: ,x_msg_data OUT NOCOPY VARCHAR2
22334: )
22335: AS
22336: v_new_publication_id cz_model_publications.publication_id%TYPE;
22337: v_old_publication_id cz_model_publications.publication_id%TYPE;
22338: v_source_pb_record cz_model_publications%ROWTYPE;
22339: l_application_id_tbl cz_pb_mgr.t_ref;
22340: l_language_id_tbl cz_pb_mgr.t_lang_code;
22333: ,x_msg_data OUT NOCOPY VARCHAR2
22334: )
22335: AS
22336: v_new_publication_id cz_model_publications.publication_id%TYPE;
22337: v_old_publication_id cz_model_publications.publication_id%TYPE;
22338: v_source_pb_record cz_model_publications%ROWTYPE;
22339: l_application_id_tbl cz_pb_mgr.t_ref;
22340: l_language_id_tbl cz_pb_mgr.t_lang_code;
22341: l_usage_id_tbl cz_pb_mgr.t_ref;
22334: )
22335: AS
22336: v_new_publication_id cz_model_publications.publication_id%TYPE;
22337: v_old_publication_id cz_model_publications.publication_id%TYPE;
22338: v_source_pb_record cz_model_publications%ROWTYPE;
22339: l_application_id_tbl cz_pb_mgr.t_ref;
22340: l_language_id_tbl cz_pb_mgr.t_lang_code;
22341: l_usage_id_tbl cz_pb_mgr.t_ref;
22342: l_param_status VARCHAR2(2000);
22366:
22367: ----get source pb info
22368: SELECT *
22369: INTO v_source_pb_record
22370: FROM cz_model_publications
22371: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted AND source_target_flag = cz_model_migration_pvt.pub_source_flag;
22372:
22373: ----check status
22374: IF (v_source_pb_record.export_status <> 'OK')
22430: THEN
22431: RAISE pub_overlap;
22432: END IF;
22433:
22434: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22435: INTO v_new_publication_id, v_old_publication_id
22436: FROM DUAL;
22437:
22438: INSERT INTO cz_model_publications
22434: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22435: INTO v_new_publication_id, v_old_publication_id
22436: FROM DUAL;
22437:
22438: INSERT INTO cz_model_publications
22439: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
22440: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update
22441: ,model_last_updated, user_str01, user_str02, user_str03, user_str04, user_num01, user_num02, user_num03, user_num04
22442: ,model_persistent_id, source_target_flag, remote_publication_id, object_id, object_type, disabled_flag)
22443: SELECT v_new_publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
22444: ,applicable_from, applicable_until, 'PEN', '0', model_last_struct_update, model_last_logic_update, model_last_updated, user_str01
22445: ,user_str02, user_str03, user_str04, user_num01, user_num02, user_num03, user_num04, model_persistent_id, source_target_flag
22446: ,remote_publication_id, object_id, object_type, disabled_flag
22447: FROM cz_model_publications
22448: WHERE publication_id = p_publication_id;
22449:
22450: v_repub_parameter := pub_model;
22451: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_return_status);
22449:
22450: v_repub_parameter := pub_model;
22451: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_return_status);
22452:
22453: UPDATE cz_model_publications
22454: SET export_status = 'PUP'
22455: WHERE publication_id = p_publication_id;
22456:
22457: x_new_publication_id := v_new_publication_id;
22526: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
22527: ------procedure that resets the start and end dates
22528: ------of the original publication
22529: PROCEDURE reset_pb_dates(
22530: p_publicationid IN cz_model_publications.publication_id%TYPE
22531: ,x_applicable_from IN OUT NOCOPY DATE
22532: ,x_applicable_until IN OUT NOCOPY DATE
22533: ,x_orig_start_date IN OUT NOCOPY DATE
22534: ,x_orig_end_date IN OUT NOCOPY DATE
22538: ,x_status IN OUT NOCOPY VARCHAR2
22539: )
22540: AS
22541: v_db_link cz_servers.fndnam_link_name%TYPE;
22542: v_server_id cz_model_publications.server_id%TYPE;
22543: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22544: reset_date_error EXCEPTION;
22545: BEGIN
22546: SELECT applicable_from, applicable_until, server_id, remote_publication_id
22539: )
22540: AS
22541: v_db_link cz_servers.fndnam_link_name%TYPE;
22542: v_server_id cz_model_publications.server_id%TYPE;
22543: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22544: reset_date_error EXCEPTION;
22545: BEGIN
22546: SELECT applicable_from, applicable_until, server_id, remote_publication_id
22547: INTO v_repub_appl_from, v_repub_appl_until, v_server_id, v_remote_publication_id
22544: reset_date_error EXCEPTION;
22545: BEGIN
22546: SELECT applicable_from, applicable_until, server_id, remote_publication_id
22547: INTO v_repub_appl_from, v_repub_appl_until, v_server_id, v_remote_publication_id
22548: FROM cz_model_publications
22549: WHERE publication_id = p_publicationid;
22550:
22551: x_orig_start_date := v_repub_appl_from;
22552: x_orig_end_date := v_repub_appl_until;
22603: ELSE
22604: RAISE reset_date_error;
22605: END IF;
22606:
22607: UPDATE cz_model_publications
22608: SET applicable_from = v_repub_appl_from
22609: ,applicable_until = v_repub_appl_until
22610: WHERE publication_id = p_publicationid;
22611:
22626: END reset_pb_dates;
22627:
22628: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22629: PROCEDURE reset_repub_changes(
22630: p_publication_id IN cz_model_publications.publication_id%TYPE
22631: ,p_orig_start_date IN DATE
22632: ,p_orig_end_date IN DATE
22633: ,x_reset_status IN OUT NOCOPY VARCHAR2
22634: )
22633: ,x_reset_status IN OUT NOCOPY VARCHAR2
22634: )
22635: AS
22636: BEGIN
22637: UPDATE cz_model_publications
22638: SET cz_model_publications.applicable_from = p_orig_start_date
22639: ,cz_model_publications.applicable_until = p_orig_end_date
22640: ,cz_model_publications.deleted_flag = '0'
22641: ,cz_model_publications.export_status = 'OK'
22634: )
22635: AS
22636: BEGIN
22637: UPDATE cz_model_publications
22638: SET cz_model_publications.applicable_from = p_orig_start_date
22639: ,cz_model_publications.applicable_until = p_orig_end_date
22640: ,cz_model_publications.deleted_flag = '0'
22641: ,cz_model_publications.export_status = 'OK'
22642: WHERE cz_model_publications.publication_id = p_publication_id;
22635: AS
22636: BEGIN
22637: UPDATE cz_model_publications
22638: SET cz_model_publications.applicable_from = p_orig_start_date
22639: ,cz_model_publications.applicable_until = p_orig_end_date
22640: ,cz_model_publications.deleted_flag = '0'
22641: ,cz_model_publications.export_status = 'OK'
22642: WHERE cz_model_publications.publication_id = p_publication_id;
22643:
22636: BEGIN
22637: UPDATE cz_model_publications
22638: SET cz_model_publications.applicable_from = p_orig_start_date
22639: ,cz_model_publications.applicable_until = p_orig_end_date
22640: ,cz_model_publications.deleted_flag = '0'
22641: ,cz_model_publications.export_status = 'OK'
22642: WHERE cz_model_publications.publication_id = p_publication_id;
22643:
22644: COMMIT;
22637: UPDATE cz_model_publications
22638: SET cz_model_publications.applicable_from = p_orig_start_date
22639: ,cz_model_publications.applicable_until = p_orig_end_date
22640: ,cz_model_publications.deleted_flag = '0'
22641: ,cz_model_publications.export_status = 'OK'
22642: WHERE cz_model_publications.publication_id = p_publication_id;
22643:
22644: COMMIT;
22645: EXCEPTION
22638: SET cz_model_publications.applicable_from = p_orig_start_date
22639: ,cz_model_publications.applicable_until = p_orig_end_date
22640: ,cz_model_publications.deleted_flag = '0'
22641: ,cz_model_publications.export_status = 'OK'
22642: WHERE cz_model_publications.publication_id = p_publication_id;
22643:
22644: COMMIT;
22645: EXCEPTION
22646: WHEN OTHERS
22656: p_publication_id IN OUT NOCOPY NUMBER
22657: ,p_start_date IN OUT NOCOPY DATE
22658: ,p_end_date IN OUT NOCOPY DATE
22659: ,x_run_id OUT NOCOPY NUMBER
22660: ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE
22661: )
22662: AS
22663: v_upto_date_status VARCHAR2(2000);
22664: v_source_pb_record cz_model_publications%ROWTYPE;
22660: ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE
22661: )
22662: AS
22663: v_upto_date_status VARCHAR2(2000);
22664: v_source_pb_record cz_model_publications%ROWTYPE;
22665: v_new_publication_id cz_model_publications.publication_id%TYPE;
22666: v_publicationidstring VARCHAR2(2000);
22667: v_reset_str VARCHAR2(100);
22668: v_reset_status VARCHAR2(2000);
22661: )
22662: AS
22663: v_upto_date_status VARCHAR2(2000);
22664: v_source_pb_record cz_model_publications%ROWTYPE;
22665: v_new_publication_id cz_model_publications.publication_id%TYPE;
22666: v_publicationidstring VARCHAR2(2000);
22667: v_reset_str VARCHAR2(100);
22668: v_reset_status VARCHAR2(2000);
22669: v_repub_status VARCHAR2(2000);
22689:
22690: ----get source pb info
22691: SELECT *
22692: INTO v_source_pb_record
22693: FROM cz_model_publications
22694: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted AND source_target_flag = g_source_flag;
22695:
22696: ----capture original values
22697: v_repub_remote_pb_id := v_source_pb_record.remote_publication_id;
22830: ,x_msg_count OUT NOCOPY NUMBER
22831: ,x_msg_data OUT NOCOPY VARCHAR2
22832: )
22833: AS
22834: v_server_id cz_model_publications.server_id%TYPE;
22835: v_cz_link_name cz_servers.cz_link_name%TYPE;
22836: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22837: v_app_id_tbl cz_pb_mgr.t_ref;
22838: v_usg_id_tbl cz_pb_mgr.t_ref;
22832: )
22833: AS
22834: v_server_id cz_model_publications.server_id%TYPE;
22835: v_cz_link_name cz_servers.cz_link_name%TYPE;
22836: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22837: v_app_id_tbl cz_pb_mgr.t_ref;
22838: v_usg_id_tbl cz_pb_mgr.t_ref;
22839: v_lang_id_tbl cz_pb_mgr.t_lang_code;
22840: v_object_type cz_model_publications.object_type%TYPE;
22836: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22837: v_app_id_tbl cz_pb_mgr.t_ref;
22838: v_usg_id_tbl cz_pb_mgr.t_ref;
22839: v_lang_id_tbl cz_pb_mgr.t_lang_code;
22840: v_object_type cz_model_publications.object_type%TYPE;
22841: l_status VARCHAR2(3);
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22838: v_usg_id_tbl cz_pb_mgr.t_ref;
22839: v_lang_id_tbl cz_pb_mgr.t_lang_code;
22840: v_object_type cz_model_publications.object_type%TYPE;
22841: l_status VARCHAR2(3);
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22839: v_lang_id_tbl cz_pb_mgr.t_lang_code;
22840: v_object_type cz_model_publications.object_type%TYPE;
22841: l_status VARCHAR2(3);
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22847: v_export_status cz_model_publications.export_status%TYPE;
22840: v_object_type cz_model_publications.object_type%TYPE;
22841: l_status VARCHAR2(3);
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22847: v_export_status cz_model_publications.export_status%TYPE;
22848: l_publicationidstring VARCHAR2(2000);
22841: l_status VARCHAR2(3);
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22847: v_export_status cz_model_publications.export_status%TYPE;
22848: l_publicationidstring VARCHAR2(2000);
22849: cannot_enable_template EXCEPTION;
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22847: v_export_status cz_model_publications.export_status%TYPE;
22848: l_publicationidstring VARCHAR2(2000);
22849: cannot_enable_template EXCEPTION;
22850: get_params_exception EXCEPTION;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22847: v_export_status cz_model_publications.export_status%TYPE;
22848: l_publicationidstring VARCHAR2(2000);
22849: cannot_enable_template EXCEPTION;
22850: get_params_exception EXCEPTION;
22851: pub_overlap EXCEPTION;
22865:
22866: BEGIN
22867: SELECT export_status
22868: INTO v_export_status
22869: FROM cz_model_publications
22870: WHERE cz_model_publications.publication_id = publicationid;
22871: EXCEPTION
22872: WHEN OTHERS
22873: THEN
22866: BEGIN
22867: SELECT export_status
22868: INTO v_export_status
22869: FROM cz_model_publications
22870: WHERE cz_model_publications.publication_id = publicationid;
22871: EXCEPTION
22872: WHEN OTHERS
22873: THEN
22874: v_export_status := NULL;
22882: SELECT object_type, server_id, remote_publication_id, product_key, applicable_from, applicable_until, source_target_flag
22883: ,publication_mode, v_export_status
22884: INTO v_object_type, v_server_id, v_remote_publication_id, l_product_key, l_applicable_from, l_applicable_until, l_source_target_flag
22885: ,l_publication_mode, v_export_status
22886: FROM cz_model_publications
22887: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.disabled_flag = '1';
22888:
22889: BEGIN
22890: SELECT fndnam_link_name
22883: ,publication_mode, v_export_status
22884: INTO v_object_type, v_server_id, v_remote_publication_id, l_product_key, l_applicable_from, l_applicable_until, l_source_target_flag
22885: ,l_publication_mode, v_export_status
22886: FROM cz_model_publications
22887: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.disabled_flag = '1';
22888:
22889: BEGIN
22890: SELECT fndnam_link_name
22891: INTO v_cz_link_name
22938: ELSE
22939: v_cz_link_name := '@' || LTRIM(RTRIM(v_cz_link_name));
22940: END IF;
22941:
22942: UPDATE cz_model_publications
22943: SET disabled_flag = '0'
22944: WHERE publication_id = publicationid;
22945:
22946: cz_pb_mgr.remote_publication_id := v_remote_publication_id;
22946: cz_pb_mgr.remote_publication_id := v_remote_publication_id;
22947:
22948: EXECUTE IMMEDIATE 'BEGIN'
22949: || ' '
22950: || 'UPDATE cz_model_publications'
22951: || v_cz_link_name
22952: || ' '
22953: || 'SET disabled_flag = ''0'''
22954: || ' '
23083: ,x_msg_data OUT NOCOPY VARCHAR2
23084: )
23085: IS
23086: l_model_id cz_rp_entries.object_id%TYPE;
23087: l_publication_mode cz_model_publications.publication_mode%TYPE;
23088: l_usg_id cz_publication_usages.usage_id%TYPE;
23089: l_lang_code cz_pb_languages.LANGUAGE%TYPE;
23090: l_start_date DATE;
23091: l_end_date DATE;
23095: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;
23096: v_publicationidstring VARCHAR2(2000);
23097: v_upto_date_status VARCHAR2(2000);
23098: l_ui_style cz_ui_defs.ui_style%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;
23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23103: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
23254: THEN
23255: RAISE pub_overlap;
23256: END IF;
23257:
23258: SELECT cz_model_publications_s.NEXTVAL
23259: INTO v_new_publication_id
23260: FROM DUAL;
23261:
23262: INSERT INTO cz_model_publications
23258: SELECT cz_model_publications_s.NEXTVAL
23259: INTO v_new_publication_id
23260: FROM DUAL;
23261:
23262: INSERT INTO cz_model_publications
23263: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode
23264: ,ui_def_id, ui_style, applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update
23265: ,model_last_logic_update, model_last_updated, model_persistent_id, source_target_flag, remote_publication_id, object_id
23266: ,object_type, disabled_flag
23429: --The current design for model migration will run
23430: --the publication process for every model that has been selected
23431: --to be migrated. The process of collecting the models is in
23432: --CZ_MODEL_MIGRATION_PVT. Once the models are collected there, for every
23433: --CZ_MODEL_PUBLICATIONS record, publish model is called. Given that,
23434: --this procedure gets the model for the current migration cz_model_publication
23435: --record.
23436:
23437: FUNCTION get_rootmodel_and_mig_tgt_fldr(p_publication_id NUMBER)
23443: --we load the global variable
23444: --holding the value of migration target folder
23445: SELECT migration_group_id, migration_tgt_folder
23446: INTO cz_pb_mgr.g_migration_group_id, cz_pb_mgr.g_migration_tgt_folder_id
23447: FROM cz_model_publications
23448: WHERE publication_id = p_publication_id;
23449:
23450: --get the model corresponding to this publication
23451: SELECT object_id
23449:
23450: --get the model corresponding to this publication
23451: SELECT object_id
23452: BULK COLLECT INTO mm_root_model
23453: FROM cz_model_publications
23454: WHERE publication_id = p_publication_id;
23455:
23456: RETURN mm_root_model;
23457: END get_rootmodel_and_mig_tgt_fldr;
25217: * NOT the current child model. So we need to check if the
25218: * CHILD was transfered before during migration.
25219: */
25220: FUNCTION get_mdl_last_xfr_activity(
25221: p_model_id IN cz_model_publications.model_id%TYPE
25222: ,p_server_id IN cz_model_publications.server_id%TYPE
25223:
25224: ) RETURN DATE
25225: AS
25218: * CHILD was transfered before during migration.
25219: */
25220: FUNCTION get_mdl_last_xfr_activity(
25221: p_model_id IN cz_model_publications.model_id%TYPE
25222: ,p_server_id IN cz_model_publications.server_id%TYPE
25223:
25224: ) RETURN DATE
25225: AS
25226: x_last_xfr_activity DATE := NULL;
25236: AND z.server_id = p_server_id
25237: AND z.status = 'OK'
25238: AND z.publication_id IN(
25239: SELECT publication_id
25240: FROM cz_model_publications
25241: WHERE export_status IN('OK', 'PUP')
25242: AND server_id = p_server_id
25243: AND UPPER(publication_mode) = cz_model_migration_pvt.mode_migration));
25244: --SPUPPALA bug#7116052 7-AUG-2009