[Home] [Help]
987:
988: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
989: ----generates new publication id for the target publication
990: PROCEDURE get_new_publication_id(
991: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
992: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
993: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
994: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
995: ,x_status IN OUT NOCOPY VARCHAR2
988: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
989: ----generates new publication id for the target publication
990: PROCEDURE get_new_publication_id(
991: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
992: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
993: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
994: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
995: ,x_status IN OUT NOCOPY VARCHAR2
996: )
989: ----generates new publication id for the target publication
990: PROCEDURE get_new_publication_id(
991: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
992: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
993: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
994: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
995: ,x_status IN OUT NOCOPY VARCHAR2
996: )
997: AS
990: PROCEDURE get_new_publication_id(
991: p_old_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
992: ,x_old_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
993: ,x_new_pub_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
994: ,x_old_rem_pb_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
995: ,x_status IN OUT NOCOPY VARCHAR2
996: )
997: AS
998: BEGIN
999: IF (x_status <> PUBLICATION_ERROR)
1000: THEN
1001: IF (cz_pb_mgr.v_server_id <> 0)
1002: THEN
1003: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
1004: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
1005: ,cz_pb_mgr.v_oraclesequenceincr
1006: )
1007: ,publication_id, remote_publication_id
1000: THEN
1001: IF (cz_pb_mgr.v_server_id <> 0)
1002: THEN
1003: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
1004: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
1005: ,cz_pb_mgr.v_oraclesequenceincr
1006: )
1007: ,publication_id, remote_publication_id
1008: INTO x_new_pub_id
1006: )
1007: ,publication_id, remote_publication_id
1008: INTO x_new_pub_id
1009: ,x_old_pb_id, x_old_rem_pb_id
1010: FROM cz_model_publications
1011: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1012: ELSE
1013: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1014: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1007: ,publication_id, remote_publication_id
1008: INTO x_new_pub_id
1009: ,x_old_pb_id, x_old_rem_pb_id
1010: FROM cz_model_publications
1011: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1012: ELSE
1013: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1014: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1015: FROM cz_model_publications
1009: ,x_old_pb_id, x_old_rem_pb_id
1010: FROM cz_model_publications
1011: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1012: ELSE
1013: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1014: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1015: FROM cz_model_publications
1016: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1017: END IF;
1011: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1012: ELSE
1013: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1014: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1015: FROM cz_model_publications
1016: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1017: END IF;
1018: END IF;
1019: EXCEPTION
1012: ELSE
1013: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1014: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1015: FROM cz_model_publications
1016: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1017: END IF;
1018: END IF;
1019: EXCEPTION
1020: WHEN OTHERS
1018: END IF;
1019: EXCEPTION
1020: WHEN OTHERS
1021: THEN
1022: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
1023: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUB', SQLCODE);
1024: x_status := PUBLICATION_ERROR;
1025: RAISE;
1026: END get_new_publication_id;
4576: l_applicable_from DATE := cz_utils.epoch_begin;
4577: l_applicable_until DATE := cz_utils.epoch_end;
4578: l_status NUMBER := 0;
4579: l_ref_cursor ref_cursor;
4580: l_src_pb_id cz_model_publications.publication_id%TYPE;
4581: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
4582: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
4583: BEGIN
4584: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
4577: l_applicable_until DATE := cz_utils.epoch_end;
4578: l_status NUMBER := 0;
4579: l_ref_cursor ref_cursor;
4580: l_src_pb_id cz_model_publications.publication_id%TYPE;
4581: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
4582: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
4583: BEGIN
4584: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
4585: THEN
4578: l_status NUMBER := 0;
4579: l_ref_cursor ref_cursor;
4580: l_src_pb_id cz_model_publications.publication_id%TYPE;
4581: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
4582: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
4583: BEGIN
4584: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
4585: THEN
4586: l_inst_str :=
4583: BEGIN
4584: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
4585: THEN
4586: l_inst_str :=
4587: 'UPDATE cz_model_publications'
4588: || p_link_name
4589: || ' t'
4590: || ' '
4591: || 'SET t.last_update_date = sysdate'
4615: l_tgt_pb_id := p_src_id;
4616: END IF;
4617:
4618: l_inst_str :=
4619: 'INSERT INTO cz_model_publications'
4620: || p_link_name
4621: || ' '
4622: || '(PUBLICATION_ID,'
4623: || ' '
4678: EXCEPTION
4679: WHEN OTHERS
4680: THEN
4681: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4682: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
4683: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
4684: RAISE;
4685: END create_uit_publication;
4686:
4751: 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
4752: LOOP
4753: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
4754: THEN
4755: SELECT cz_model_publications_s.NEXTVAL
4756: INTO l_src_pb_id
4757: FROM DUAL;
4758:
4759: l_tgt_pb_id :=
4756: INTO l_src_pb_id
4757: FROM DUAL;
4758:
4759: l_tgt_pb_id :=
4760: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
4761: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
4762: ,cz_pb_mgr.v_oraclesequenceincr
4763: );
4764:
4757: FROM DUAL;
4758:
4759: l_tgt_pb_id :=
4760: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
4761: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
4762: ,cz_pb_mgr.v_oraclesequenceincr
4763: );
4764:
4765: -- IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
6120: END log_pb_trace;
6121:
6122: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6123: ----update pup status
6124: PROCEDURE update_pup_status(p_publication_id cz_model_publications.publication_id%TYPE)
6125: IS
6126: l_remote_publication_id NUMBER;
6127: BEGIN
6128: UPDATE cz_model_publications
6124: PROCEDURE update_pup_status(p_publication_id cz_model_publications.publication_id%TYPE)
6125: IS
6126: l_remote_publication_id NUMBER;
6127: BEGIN
6128: UPDATE cz_model_publications
6129: SET export_status = 'OK'
6130: WHERE remote_publication_id = (SELECT remote_publication_id
6131: FROM cz_model_publications
6132: WHERE deleted_flag = '0' AND publication_id = p_publication_id AND export_status = 'ERR')
6127: BEGIN
6128: UPDATE cz_model_publications
6129: SET export_status = 'OK'
6130: WHERE remote_publication_id = (SELECT remote_publication_id
6131: FROM cz_model_publications
6132: WHERE deleted_flag = '0' AND publication_id = p_publication_id AND export_status = 'ERR')
6133: AND export_status = 'PUP'
6134: AND deleted_flag = '0';
6135: END;
6134: AND deleted_flag = '0';
6135: END;
6136:
6137: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6138: ------updates export status in cZ_model_publications
6139: PROCEDURE update_publication_status(p_publication_id IN NUMBER, p_pb_status IN VARCHAR2, p_db_link IN VARCHAR2)
6140: IS
6141: BEGIN
6142: IF ((p_publication_id > 0) AND(p_pb_status IS NOT NULL))
6141: BEGIN
6142: IF ((p_publication_id > 0) AND(p_pb_status IS NOT NULL))
6143: THEN
6144: cz_pb_mgr.v_insert_string :=
6145: 'UPDATE cz_model_publications'
6146: || p_db_link
6147: || ' '
6148: || 'SET export_status = :1,'
6149: || ' '
6148: || 'SET export_status = :1,'
6149: || ' '
6150: || 'published = sysdate'
6151: || ' '
6152: || 'WHERE cz_model_publications.publication_id = :2';
6153:
6154: EXECUTE IMMEDIATE cz_pb_mgr.v_insert_string
6155: USING p_pb_status, p_publication_id;
6156: END IF;
6542: RAISE;
6543: END rollback_data;
6544:
6545: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6546: -----------procedure updates the status in cz_model_publications and cz_pb_model_exports
6547: -----------@p_publication_id : source publication id
6548: -----------@p_status : publication status
6549: -----------@p_link : database link name
6550: -----------@p_models_exported : source models that have entries in model exports
6549: -----------@p_link : database link name
6550: -----------@p_models_exported : source models that have entries in model exports
6551: -----------@x_status : publication status parameter
6552: PROCEDURE update_pb_status(
6553: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
6554: ,p_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
6555: ,p_models_exported IN OUT NOCOPY cz_pb_mgr.t_ref
6556: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
6557: )
6550: -----------@p_models_exported : source models that have entries in model exports
6551: -----------@x_status : publication status parameter
6552: PROCEDURE update_pb_status(
6553: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
6554: ,p_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
6555: ,p_models_exported IN OUT NOCOPY cz_pb_mgr.t_ref
6556: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
6557: )
6558: AS
6552: PROCEDURE update_pb_status(
6553: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
6554: ,p_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
6555: ,p_models_exported IN OUT NOCOPY cz_pb_mgr.t_ref
6556: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
6557: )
6558: AS
6559: BEGIN
6560: -----update status on the source. p_link is null
6579: END IF;
6580: EXCEPTION
6581: WHEN OTHERS
6582: THEN
6583: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
6584: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDPBSTATUS', SQLCODE);
6585: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6586: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
6587: RAISE;
6818: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6819: ----procedure that checks if a model has been published earlier
6820: ----@p_publication_id : publication_id of the publication request
6821: ----x_record_count : returns count of earlier publications
6822: PROCEDURE chk_if_aleady_published(p_publication_id IN cz_model_publications.publication_id%TYPE, x_record_count IN OUT NOCOPY NUMBER)
6823: AS
6824: BEGIN
6825: IF (g_object_type = MODEL_PUBLICATION)
6826: THEN
6825: IF (g_object_type = MODEL_PUBLICATION)
6826: THEN
6827: SELECT COUNT(*)
6828: INTO x_record_count
6829: FROM cz_model_publications z
6830: WHERE z.object_id = (SELECT object_id
6831: FROM cz_model_publications
6832: WHERE cz_model_publications.publication_id = p_publication_id)
6833: AND z.server_id = (SELECT server_id
6827: SELECT COUNT(*)
6828: INTO x_record_count
6829: FROM cz_model_publications z
6830: WHERE z.object_id = (SELECT object_id
6831: FROM cz_model_publications
6832: WHERE cz_model_publications.publication_id = p_publication_id)
6833: AND z.server_id = (SELECT server_id
6834: FROM cz_model_publications
6835: WHERE cz_model_publications.publication_id = p_publication_id)
6828: INTO x_record_count
6829: FROM cz_model_publications z
6830: WHERE z.object_id = (SELECT object_id
6831: FROM cz_model_publications
6832: WHERE cz_model_publications.publication_id = p_publication_id)
6833: AND z.server_id = (SELECT server_id
6834: FROM cz_model_publications
6835: WHERE cz_model_publications.publication_id = p_publication_id)
6836: AND z.model_last_struct_update =
6830: WHERE z.object_id = (SELECT object_id
6831: FROM cz_model_publications
6832: WHERE cz_model_publications.publication_id = p_publication_id)
6833: AND z.server_id = (SELECT server_id
6834: FROM cz_model_publications
6835: WHERE cz_model_publications.publication_id = p_publication_id)
6836: AND z.model_last_struct_update =
6837: (SELECT last_struct_update
6838: FROM cz_devl_projects
6831: FROM cz_model_publications
6832: WHERE cz_model_publications.publication_id = p_publication_id)
6833: AND z.server_id = (SELECT server_id
6834: FROM cz_model_publications
6835: WHERE cz_model_publications.publication_id = p_publication_id)
6836: AND z.model_last_struct_update =
6837: (SELECT last_struct_update
6838: FROM cz_devl_projects
6839: WHERE cz_devl_projects.devl_project_id =
6837: (SELECT last_struct_update
6838: FROM cz_devl_projects
6839: WHERE cz_devl_projects.devl_project_id =
6840: (SELECT object_id
6841: FROM cz_model_publications
6842: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))
6843: AND z.export_status IN('OK', 'PUP')
6844: AND z.source_target_flag = g_source_flag
6845: AND z.deleted_flag = record_not_deleted;
6838: FROM cz_devl_projects
6839: WHERE cz_devl_projects.devl_project_id =
6840: (SELECT object_id
6841: FROM cz_model_publications
6842: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))
6843: AND z.export_status IN('OK', 'PUP')
6844: AND z.source_target_flag = g_source_flag
6845: AND z.deleted_flag = record_not_deleted;
6846: ELSIF(g_object_type = template_publication)
6846: ELSIF(g_object_type = template_publication)
6847: THEN
6848: SELECT COUNT(*)
6849: INTO x_record_count
6850: FROM cz_model_publications z
6851: WHERE z.object_id = (SELECT object_id
6852: FROM cz_model_publications
6853: WHERE cz_model_publications.publication_id = p_publication_id)
6854: AND z.server_id = (SELECT server_id
6848: SELECT COUNT(*)
6849: INTO x_record_count
6850: FROM cz_model_publications z
6851: WHERE z.object_id = (SELECT object_id
6852: FROM cz_model_publications
6853: WHERE cz_model_publications.publication_id = p_publication_id)
6854: AND z.server_id = (SELECT server_id
6855: FROM cz_model_publications
6856: WHERE cz_model_publications.publication_id = p_publication_id)
6849: INTO x_record_count
6850: FROM cz_model_publications z
6851: WHERE z.object_id = (SELECT object_id
6852: FROM cz_model_publications
6853: WHERE cz_model_publications.publication_id = p_publication_id)
6854: AND z.server_id = (SELECT server_id
6855: FROM cz_model_publications
6856: WHERE cz_model_publications.publication_id = p_publication_id)
6857: AND z.export_status IN('OK', 'PUP')
6851: WHERE z.object_id = (SELECT object_id
6852: FROM cz_model_publications
6853: WHERE cz_model_publications.publication_id = p_publication_id)
6854: AND z.server_id = (SELECT server_id
6855: FROM cz_model_publications
6856: WHERE cz_model_publications.publication_id = p_publication_id)
6857: AND z.export_status IN('OK', 'PUP')
6858: AND z.source_target_flag = g_source_flag
6859: AND z.deleted_flag = record_not_deleted;
6852: FROM cz_model_publications
6853: WHERE cz_model_publications.publication_id = p_publication_id)
6854: AND z.server_id = (SELECT server_id
6855: FROM cz_model_publications
6856: WHERE cz_model_publications.publication_id = p_publication_id)
6857: AND z.export_status IN('OK', 'PUP')
6858: AND z.source_target_flag = g_source_flag
6859: AND z.deleted_flag = record_not_deleted;
6860: END IF;
6869: -----@p_model_id: model_id on the publication request
6870: -----@p_server_id : server_id on the publication request
6871: -----x_last_xfr_activity : last published date
6872: PROCEDURE get_last_xfr_activity(
6873: p_model_id IN cz_model_publications.model_id%TYPE
6874: ,p_server_id IN cz_model_publications.server_id%TYPE
6875: ,x_last_xfr_activity IN OUT NOCOPY DATE
6876: )
6877: AS
6870: -----@p_server_id : server_id on the publication request
6871: -----x_last_xfr_activity : last published date
6872: PROCEDURE get_last_xfr_activity(
6873: p_model_id IN cz_model_publications.model_id%TYPE
6874: ,p_server_id IN cz_model_publications.server_id%TYPE
6875: ,x_last_xfr_activity IN OUT NOCOPY DATE
6876: )
6877: AS
6878: BEGIN
6888: AND z.server_id = p_server_id
6889: AND z.status = 'OK'
6890: AND z.publication_id IN(
6891: SELECT publication_id
6892: FROM cz_model_publications
6893: WHERE export_status IN('OK', 'PUP')
6894: AND server_id = p_server_id
6895: AND publication_mode = cz_model_migration_pvt.mode_migration));
6896: ELSE
6904: AND z.server_id = p_server_id
6905: AND z.status = 'OK'
6906: AND z.publication_id IN(
6907: SELECT publication_id
6908: FROM cz_model_publications
6909: WHERE export_status IN('OK', 'PUP')
6910: AND server_id = p_server_id
6911: AND publication_mode <> cz_model_migration_pvt.mode_migration));
6912: END IF;
6918:
6919: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6920: -----procedure that retrieves the last update date from cz_expression nodes
6921: -----required to check if rules have been changed since it was last published
6922: PROCEDURE get_max_expr_date(p_model_id cz_model_publications.model_id%TYPE, x_expr_node_date IN OUT NOCOPY DATE)
6923: AS
6924: BEGIN
6925: SELECT MAX(last_update_date)
6926: INTO x_expr_node_date
6940:
6941: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6942: -----procedure that retrieves the last_struct_update date
6943: -----required to check if ps structure been changed since model was last published
6944: PROCEDURE get_last_struct_date(p_model_id cz_model_publications.model_id%TYPE, x_last_struct_date IN OUT NOCOPY DATE)
6945: AS
6946: BEGIN
6947: SELECT last_struct_update
6948: INTO x_last_struct_date
6959: -----@p_model_id : model that is exported
6960: -----@p_src_models : source models array
6961: -----x_ui_def_ref : output of source ui defs
6962: PROCEDURE get_source_uis(
6963: p_model_id IN cz_model_publications.model_id%TYPE
6964: ,p_src_models IN cz_pb_mgr.t_ref
6965: ,x_ui_def_ref IN OUT NOCOPY cz_pb_mgr.t_ref
6966: )
6967: AS
7057: END get_source_uis;
7058:
7059: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7060: ----procedure that returns the max last_update_date of ui schema
7061: 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)
7062: AS
7063: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7064: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7065: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7568: END get_max_ui_date;
7569:
7570: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7571: -------procedure that retrieves all source models
7572: 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)
7573: AS
7574: v_count PLS_INTEGER := 0;
7575: v_component_id cz_model_ref_expls.component_id%TYPE;
7576:
7824: IS
7825: l_last_update_date DATE;
7826: l_prev_date DATE := cz_utils.epoch_begin;
7827: rec_count NUMBER := 0;
7828: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
7829: BEGIN
7830: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7831: THEN
7832: l_pub_mode := cz_model_migration_pvt.mode_migration;
7843: LOOP
7844: BEGIN
7845: SELECT MAX(published)
7846: INTO l_last_update_date
7847: FROM cz_model_publications
7848: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
7849: AND cz_model_publications.deleted_flag = record_not_deleted
7850: AND cz_model_publications.object_type = template_publication
7851: AND cz_model_publications.publication_mode = l_pub_mode;
7844: BEGIN
7845: SELECT MAX(published)
7846: INTO l_last_update_date
7847: FROM cz_model_publications
7848: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
7849: AND cz_model_publications.deleted_flag = record_not_deleted
7850: AND cz_model_publications.object_type = template_publication
7851: AND cz_model_publications.publication_mode = l_pub_mode;
7852: EXCEPTION
7845: SELECT MAX(published)
7846: INTO l_last_update_date
7847: FROM cz_model_publications
7848: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
7849: AND cz_model_publications.deleted_flag = record_not_deleted
7850: AND cz_model_publications.object_type = template_publication
7851: AND cz_model_publications.publication_mode = l_pub_mode;
7852: EXCEPTION
7853: WHEN NO_DATA_FOUND
7846: INTO l_last_update_date
7847: FROM cz_model_publications
7848: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
7849: AND cz_model_publications.deleted_flag = record_not_deleted
7850: AND cz_model_publications.object_type = template_publication
7851: AND cz_model_publications.publication_mode = l_pub_mode;
7852: EXCEPTION
7853: WHEN NO_DATA_FOUND
7854: THEN
7847: FROM cz_model_publications
7848: WHERE cz_model_publications.object_id = p_global_templs_ref(i)
7849: AND cz_model_publications.deleted_flag = record_not_deleted
7850: AND cz_model_publications.object_type = template_publication
7851: AND cz_model_publications.publication_mode = l_pub_mode;
7852: EXCEPTION
7853: WHEN NO_DATA_FOUND
7854: THEN
7855: NULL;
8253: BEGIN
8254: -- using binding vars
8255: -- check existing in ui template table (esp for mig)?
8256: OPEN l_ref_cursor FOR 'SELECT object_id'
8257: || ' FROM cz_model_publications'
8258: || cz_pb_mgr.v_db_link
8259: || ' t'
8260: || ' WHERE t.source_model_id = '
8261: || p_src_template_id
8307: x_status := 0;
8308:
8309: SELECT last_update_date
8310: INTO l_last_update_date
8311: FROM cz_model_publications
8312: WHERE cz_model_publications.object_id = p_template_id
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8308:
8309: SELECT last_update_date
8310: INTO l_last_update_date
8311: FROM cz_model_publications
8312: WHERE cz_model_publications.object_id = p_template_id
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8316: AND cz_model_publications.export_status IN('OK', 'PUP')
8309: SELECT last_update_date
8310: INTO l_last_update_date
8311: FROM cz_model_publications
8312: WHERE cz_model_publications.object_id = p_template_id
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8316: AND cz_model_publications.export_status IN('OK', 'PUP')
8317: AND cz_model_publications.deleted_flag = '0';
8310: INTO l_last_update_date
8311: FROM cz_model_publications
8312: WHERE cz_model_publications.object_id = p_template_id
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8316: AND cz_model_publications.export_status IN('OK', 'PUP')
8317: AND cz_model_publications.deleted_flag = '0';
8318:
8311: FROM cz_model_publications
8312: WHERE cz_model_publications.object_id = p_template_id
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8316: AND cz_model_publications.export_status IN('OK', 'PUP')
8317: AND cz_model_publications.deleted_flag = '0';
8318:
8319: SELECT last_update_date
8312: WHERE cz_model_publications.object_id = p_template_id
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8316: AND cz_model_publications.export_status IN('OK', 'PUP')
8317: AND cz_model_publications.deleted_flag = '0';
8318:
8319: SELECT last_update_date
8320: INTO l_uit_update_date
8313: AND cz_model_publications.object_type = 'UIT'
8314: AND cz_model_publications.source_target_flag = g_source_flag
8315: AND cz_model_publications.server_id = p_server_id
8316: AND cz_model_publications.export_status IN('OK', 'PUP')
8317: AND cz_model_publications.deleted_flag = '0';
8318:
8319: SELECT last_update_date
8320: INTO l_uit_update_date
8321: FROM cz_ui_templates
9134: v_count PLS_INTEGER := 0;
9135: v_models model_id_table;
9136: record_index NUMBER := 0;
9137: not_exported_record_index NUMBER := 0;
9138: v_model_id cz_model_publications.model_id%TYPE;
9139: v_expr_last_update cz_expression_nodes.last_update_date%TYPE;
9140: l_exp_models_idx_ref cz_pb_mgr.t_ref_idx_vc2;
9141: l_intl_text_date DATE;
9142: l_eff_set_date DATE;
9514: IF ((p_publication_id > 0) AND(cz_pb_mgr.v_session_parameter <> model_copy))
9515: THEN
9516: v_remote_link := retrieve_db_link(cz_pb_mgr.v_server_id);
9517: cz_pb_mgr.v_insert_string :=
9518: 'SELECT publication_id FROM cz_model_publications' || v_remote_link || ' t' || ' ' || 'WHERE t.publication_id = '
9519: || p_publication_id;
9520:
9521: OPEN remote_pb_cv FOR cz_pb_mgr.v_insert_string;
9522:
9860: END verify_model_for_sync;
9861:
9862: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
9863: ------procedure to get synchronized values for organization_id,
9864: ------top_item_id and product_key of cz_model_publications
9865: ------If no bom synch required, then default values are returned
9866: PROCEDURE get_synchronized_pb_values(p_publication_id IN NUMBER)
9867: IS
9868: BEGIN
9873: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
9874: INTO cz_pb_mgr.v_bomsynch_org_id
9875: ,cz_pb_mgr.v_bomsynch_item_id
9876: ,cz_pb_mgr.v_bomsynch_product_key
9877: FROM cz_model_publications
9878: WHERE cz_model_publications.publication_id = p_publication_id;
9879: END IF;
9880: EXCEPTION
9881: WHEN OTHERS
9874: INTO cz_pb_mgr.v_bomsynch_org_id
9875: ,cz_pb_mgr.v_bomsynch_item_id
9876: ,cz_pb_mgr.v_bomsynch_product_key
9877: FROM cz_model_publications
9878: WHERE cz_model_publications.publication_id = p_publication_id;
9879: END IF;
9880: EXCEPTION
9881: WHEN OTHERS
9882: THEN
12240: -----@p_new_ui_array : array containing new ui_def_ids
12241: -----@x_new_ui_def_id : new ui_def_id
12242: -----@x_status : publication status parameter
12243: PROCEDURE get_new_ui_def_id(
12244: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12245: ,p_old_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
12246: ,p_new_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
12247: ,x_new_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12248: ,x_status IN OUT NOCOPY VARCHAR2
12243: PROCEDURE get_new_ui_def_id(
12244: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12245: ,p_old_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
12246: ,p_new_ui_array IN OUT NOCOPY cz_pb_mgr.t_ref
12247: ,x_new_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12248: ,x_status IN OUT NOCOPY VARCHAR2
12249: )
12250: AS
12251: v_old_ui_def_id cz_model_publications.model_id%TYPE;
12247: ,x_new_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12248: ,x_status IN OUT NOCOPY VARCHAR2
12249: )
12250: AS
12251: v_old_ui_def_id cz_model_publications.model_id%TYPE;
12252: BEGIN
12253: IF (x_status <> PUBLICATION_ERROR)
12254: THEN
12255: SELECT ui_def_id
12253: IF (x_status <> PUBLICATION_ERROR)
12254: THEN
12255: SELECT ui_def_id
12256: INTO v_old_ui_def_id
12257: FROM cz_model_publications
12258: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
12259:
12260: IF ((v_old_ui_def_id > 0) AND(p_new_ui_array.COUNT > 0))
12261: THEN
12254: THEN
12255: SELECT ui_def_id
12256: INTO v_old_ui_def_id
12257: FROM cz_model_publications
12258: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
12259:
12260: IF ((v_old_ui_def_id > 0) AND(p_new_ui_array.COUNT > 0))
12261: THEN
12262: IF (p_old_ui_array.COUNT > 0) THEN
12275: END IF;
12276: EXCEPTION
12277: WHEN OTHERS
12278: THEN
12279: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_DATA_FOUND', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
12280: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:UIDEFID', SQLCODE);
12281: x_status := PUBLICATION_ERROR;
12282: RAISE;
12283: END get_new_ui_def_id;
12284:
12285: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12286: ----procedure gets model id for target publication
12287: PROCEDURE get_new_model_id(
12288: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12289: ,p_new_model_array IN OUT NOCOPY cz_pb_mgr.t_ref
12290: ,x_new_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12291: ,x_status IN OUT NOCOPY VARCHAR2
12292: )
12286: ----procedure gets model id for target publication
12287: PROCEDURE get_new_model_id(
12288: p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12289: ,p_new_model_array IN OUT NOCOPY cz_pb_mgr.t_ref
12290: ,x_new_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12291: ,x_status IN OUT NOCOPY VARCHAR2
12292: )
12293: AS
12294: BEGIN
12321: END get_new_model_id;
12322:
12323: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12324: ------procedure that retrieves the source publication_id, export_status, server_id, remote_publication_id
12325: ------from cz_model_publications table
12326: ------@p_publication_id : publication id whose info is required
12327: ------@p_status : publication_status
12328: ------@x_model_id : model that is to be published
12329: ------@x_ui_def_id : ui_def_id
12330: ------@x_export_status : prev publication status
12331: ------@x_remote_publication_id : prev remote publication id
12332: ------@x_status : publication status parameter
12333: PROCEDURE get_source_pb_info(
12334: p_publication_id IN cz_model_publications.publication_id%TYPE
12335: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12331: ------@x_remote_publication_id : prev remote publication id
12332: ------@x_status : publication status parameter
12333: PROCEDURE get_source_pb_info(
12334: p_publication_id IN cz_model_publications.publication_id%TYPE
12335: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12332: ------@x_status : publication status parameter
12333: PROCEDURE get_source_pb_info(
12334: p_publication_id IN cz_model_publications.publication_id%TYPE
12335: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12340: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
12333: PROCEDURE get_source_pb_info(
12334: p_publication_id IN cz_model_publications.publication_id%TYPE
12335: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12340: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
12341: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
12334: p_publication_id IN cz_model_publications.publication_id%TYPE
12335: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12340: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
12341: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
12342: ,x_status IN OUT NOCOPY VARCHAR2
12335: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12340: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
12341: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
12342: ,x_status IN OUT NOCOPY VARCHAR2
12343: )
12336: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12340: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
12341: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
12342: ,x_status IN OUT NOCOPY VARCHAR2
12343: )
12344: AS
12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12338: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12339: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12340: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
12341: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE
12342: ,x_status IN OUT NOCOPY VARCHAR2
12343: )
12344: AS
12345: BEGIN
12346: IF (x_status <> PUBLICATION_ERROR)
12347: THEN
12348: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
12349: 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
12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12347: THEN
12348: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
12349: 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
12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12355: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
12348: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
12349: 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
12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12355: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
12356: -- AND cz_model_publications.disabled_flag = '0';
12349: 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
12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12355: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
12356: -- AND cz_model_publications.disabled_flag = '0';
12357:
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12355: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
12356: -- AND cz_model_publications.disabled_flag = '0';
12357:
12358: ----if x_ui_def_id is null
12359: IF (x_ui_def_id IS NULL)
12360: THEN
12385: END get_source_pb_info;
12386:
12387: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12388: ------procedure that retrieves the prev publication_id, export_status, server_id, remote_publication_id
12389: ------from cz_model_publications table
12390: ------@p_publication_id : publication id whose info is required
12391: ------@p_status : publication_status
12392: ------@x_prev publication id : prev publication id
12393: ------@x_prev_export_status : prev publication status
12393: ------@x_prev_export_status : prev publication status
12394: ------@x_prev_remote_publication_id : prev remote publication id
12395: ------@x_status : publication status parameter
12396: PROCEDURE get_new_copy_pb_info(
12397: p_publication_id IN cz_model_publications.publication_id%TYPE
12398: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12399: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12400: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12401: ,x_status IN OUT NOCOPY VARCHAR2
12394: ------@x_prev_remote_publication_id : prev remote publication id
12395: ------@x_status : publication status parameter
12396: PROCEDURE get_new_copy_pb_info(
12397: p_publication_id IN cz_model_publications.publication_id%TYPE
12398: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12399: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12400: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12401: ,x_status IN OUT NOCOPY VARCHAR2
12402: )
12395: ------@x_status : publication status parameter
12396: PROCEDURE get_new_copy_pb_info(
12397: p_publication_id IN cz_model_publications.publication_id%TYPE
12398: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12399: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12400: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12401: ,x_status IN OUT NOCOPY VARCHAR2
12402: )
12403: AS
12396: PROCEDURE get_new_copy_pb_info(
12397: p_publication_id IN cz_model_publications.publication_id%TYPE
12398: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12399: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12400: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12401: ,x_status IN OUT NOCOPY VARCHAR2
12402: )
12403: AS
12404: BEGIN
12405: IF (p_publication_id IS NOT NULL)
12406: THEN
12407: SELECT publication_id, export_status, remote_publication_id
12408: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
12409: FROM cz_model_publications
12410: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
12411: END IF;
12412: EXCEPTION
12413: WHEN OTHERS
12406: THEN
12407: SELECT publication_id, export_status, remote_publication_id
12408: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
12409: FROM cz_model_publications
12410: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
12411: END IF;
12412: EXCEPTION
12413: WHEN OTHERS
12414: THEN
12421: END get_new_copy_pb_info;
12422:
12423: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12424: ------procedure that retrieves the prev publication_id, export_status, server_id, remote_publication_id
12425: ------from cz_model_publications table
12426: ------@p_publication_id : publication id whose info is required
12427: ------@p_status : publication_status
12428: ------@x_prev publication id : prev publication id
12429: ------@x_prev_export_status : prev publication status
12429: ------@x_prev_export_status : prev publication status
12430: ------@x_prev_remote_publication_id : prev remote publication id
12431: ------@x_status : publication status parameter
12432: PROCEDURE get_republish_pb_info(
12433: p_publication_id IN cz_model_publications.publication_id%TYPE
12434: ,p_status IN cz_model_publications.export_status%TYPE
12435: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12436: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12437: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12430: ------@x_prev_remote_publication_id : prev remote publication id
12431: ------@x_status : publication status parameter
12432: PROCEDURE get_republish_pb_info(
12433: p_publication_id IN cz_model_publications.publication_id%TYPE
12434: ,p_status IN cz_model_publications.export_status%TYPE
12435: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12436: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12437: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12438: ,x_status IN OUT NOCOPY VARCHAR2
12431: ------@x_status : publication status parameter
12432: PROCEDURE get_republish_pb_info(
12433: p_publication_id IN cz_model_publications.publication_id%TYPE
12434: ,p_status IN cz_model_publications.export_status%TYPE
12435: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12436: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12437: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12438: ,x_status IN OUT NOCOPY VARCHAR2
12439: )
12432: PROCEDURE get_republish_pb_info(
12433: p_publication_id IN cz_model_publications.publication_id%TYPE
12434: ,p_status IN cz_model_publications.export_status%TYPE
12435: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12436: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12437: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12438: ,x_status IN OUT NOCOPY VARCHAR2
12439: )
12440: AS
12433: p_publication_id IN cz_model_publications.publication_id%TYPE
12434: ,p_status IN cz_model_publications.export_status%TYPE
12435: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12436: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12437: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12438: ,x_status IN OUT NOCOPY VARCHAR2
12439: )
12440: AS
12441: BEGIN
12440: AS
12441: BEGIN
12442: SELECT publication_id, export_status, remote_publication_id
12443: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
12444: FROM cz_model_publications
12445: WHERE cz_model_publications.remote_publication_id = p_publication_id
12446: AND cz_model_publications.export_status = p_status
12447: AND cz_model_publications.deleted_flag = record_not_deleted;
12448: EXCEPTION
12441: BEGIN
12442: SELECT publication_id, export_status, remote_publication_id
12443: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
12444: FROM cz_model_publications
12445: WHERE cz_model_publications.remote_publication_id = p_publication_id
12446: AND cz_model_publications.export_status = p_status
12447: AND cz_model_publications.deleted_flag = record_not_deleted;
12448: EXCEPTION
12449: WHEN OTHERS
12442: SELECT publication_id, export_status, remote_publication_id
12443: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
12444: FROM cz_model_publications
12445: WHERE cz_model_publications.remote_publication_id = p_publication_id
12446: AND cz_model_publications.export_status = p_status
12447: AND cz_model_publications.deleted_flag = record_not_deleted;
12448: EXCEPTION
12449: WHEN OTHERS
12450: THEN
12443: INTO x_prev_publication_id, x_prev_export_status, x_prev_remote_publication_id
12444: FROM cz_model_publications
12445: WHERE cz_model_publications.remote_publication_id = p_publication_id
12446: AND cz_model_publications.export_status = p_status
12447: AND cz_model_publications.deleted_flag = record_not_deleted;
12448: EXCEPTION
12449: WHEN OTHERS
12450: THEN
12451: cz_pb_mgr.v_err_message := 'Error in retrieving publication info (republish) for publication id : ' || p_publication_id || ' : ' || SQLERRM;
12461: ----------@x_publication_id : retrieved max publication id
12462: ----------@x_status: publication status parameter
12463: PROCEDURE get_max_pub_id(
12464: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12465: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12466: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12467: ,x_status IN OUT NOCOPY VARCHAR2
12468: )
12469: AS
12462: ----------@x_status: publication status parameter
12463: PROCEDURE get_max_pub_id(
12464: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12465: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12466: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12467: ,x_status IN OUT NOCOPY VARCHAR2
12468: )
12469: AS
12470: BEGIN
12469: AS
12470: BEGIN
12471: SELECT MAX(publication_id)
12472: INTO x_publication_id
12473: FROM cz_model_publications t
12474: WHERE t.model_id = p_model_id
12475: AND t.server_id = p_server_id
12476: AND t.model_last_struct_update = (SELECT last_struct_update
12477: FROM cz_devl_projects
12505: -----@x_status : publication status parameter
12506: PROCEDURE get_prev_publication(
12507: p_ui_str IN OUT NOCOPY VARCHAR2
12508: ,p_session_parameter IN OUT NOCOPY VARCHAR2
12509: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
12510: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12511: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12512: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12513: ,x_status IN OUT NOCOPY VARCHAR2
12506: PROCEDURE get_prev_publication(
12507: p_ui_str IN OUT NOCOPY VARCHAR2
12508: ,p_session_parameter IN OUT NOCOPY VARCHAR2
12509: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
12510: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12511: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12512: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12513: ,x_status IN OUT NOCOPY VARCHAR2
12514: )
12507: p_ui_str IN OUT NOCOPY VARCHAR2
12508: ,p_session_parameter IN OUT NOCOPY VARCHAR2
12509: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
12510: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12511: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12512: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12513: ,x_status IN OUT NOCOPY VARCHAR2
12514: )
12515: AS
12508: ,p_session_parameter IN OUT NOCOPY VARCHAR2
12509: ,p_rem_publication_id IN cz_model_publications.publication_id%TYPE
12510: ,x_prev_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12511: ,x_prev_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12512: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12513: ,x_status IN OUT NOCOPY VARCHAR2
12514: )
12515: AS
12516: v_pr_pub_id cz_model_publications.publication_id%TYPE;
12512: ,x_prev_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12513: ,x_status IN OUT NOCOPY VARCHAR2
12514: )
12515: AS
12516: v_pr_pub_id cz_model_publications.publication_id%TYPE;
12517: BEGIN
12518: IF ((p_ui_str = 'UI') AND(p_session_parameter <> model_copy))
12519: THEN
12520: IF (p_rem_publication_id IS NOT NULL)
12567: ------@p_old_publication_id : old publication id
12568: ------@p_link IN OUT NOCOPY : db link
12569: ------@x_status publication status parameter
12570: PROCEDURE insert_tgt_publication(
12571: p_new_publication_id IN cz_model_publications.publication_id%TYPE
12572: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
12573: ,p_model_id IN cz_model_publications.model_id%TYPE
12574: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
12575: ,p_link IN OUT NOCOPY VARCHAR2
12568: ------@p_link IN OUT NOCOPY : db link
12569: ------@x_status publication status parameter
12570: PROCEDURE insert_tgt_publication(
12571: p_new_publication_id IN cz_model_publications.publication_id%TYPE
12572: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
12573: ,p_model_id IN cz_model_publications.model_id%TYPE
12574: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
12575: ,p_link IN OUT NOCOPY VARCHAR2
12576: ,p_insert_flag IN VARCHAR2
12569: ------@x_status publication status parameter
12570: PROCEDURE insert_tgt_publication(
12571: p_new_publication_id IN cz_model_publications.publication_id%TYPE
12572: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
12573: ,p_model_id IN cz_model_publications.model_id%TYPE
12574: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
12575: ,p_link IN OUT NOCOPY VARCHAR2
12576: ,p_insert_flag IN VARCHAR2
12577: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12570: PROCEDURE insert_tgt_publication(
12571: p_new_publication_id IN cz_model_publications.publication_id%TYPE
12572: ,p_old_publication_id IN cz_model_publications.publication_id%TYPE
12573: ,p_model_id IN cz_model_publications.model_id%TYPE
12574: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
12575: ,p_link IN OUT NOCOPY VARCHAR2
12576: ,p_insert_flag IN VARCHAR2
12577: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12578: )
12573: ,p_model_id IN cz_model_publications.model_id%TYPE
12574: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
12575: ,p_link IN OUT NOCOPY VARCHAR2
12576: ,p_insert_flag IN VARCHAR2
12577: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
12578: )
12579: AS
12580: v_ui_def VARCHAR2(2000);
12581: v_inst_str VARCHAR2(8000);
12594: v_src_ui_def_id := TO_CHAR(cz_pb_mgr.v_root_ui_def_id);
12595: END IF;
12596:
12597: v_inst_str :=
12598: 'INSERT INTO cz_model_publications'
12599: || p_link
12600: || ''
12601: || ' '
12602: || '(PUBLICATION_ID'
12706: || ',PAGE_LAYOUT'
12707: || ' '
12708: || ',disabled_flag'
12709: || ' '
12710: || 'FROM cz_model_publications'
12711: || ' '
12712: || 'WHERE publication_id = :11 ';
12713:
12714: EXECUTE IMMEDIATE v_inst_str
12726:
12727: ---------update remote_publication on the source
12728: IF (p_insert_flag = 'REPUBLISH')
12729: THEN
12730: UPDATE cz_model_publications
12731: SET remote_publication_id = p_new_publication_id
12732: WHERE publication_id = cz_pb_mgr.v_cz_model_pub_old_id;
12733: ELSIF(p_insert_flag = 'NEW')
12734: THEN
12731: SET remote_publication_id = p_new_publication_id
12732: WHERE publication_id = cz_pb_mgr.v_cz_model_pub_old_id;
12733: ELSIF(p_insert_flag = 'NEW')
12734: THEN
12735: UPDATE cz_model_publications
12736: SET remote_publication_id = p_new_publication_id
12737: WHERE publication_id = p_old_publication_id;
12738: END IF;
12739:
12739:
12740: ------update for republish_model api
12741: IF (cz_pb_mgr.v_republish_model = new_copy_mode)
12742: THEN
12743: EXECUTE IMMEDIATE 'UPDATE cz_model_publications'
12744: || p_link
12745: || ' t '
12746: || ' '
12747: || 'SET t.applicable_from = :1,'
12767:
12768: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12769: -----procedure that inserts publication applicability parameters on the target instance
12770: PROCEDURE insert_pb_parameters(
12771: p_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12772: ,p_old_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12773: ,p_session_parameter IN OUT NOCOPY VARCHAR2
12774: ,p_db_link IN VARCHAR2
12775: ,x_status IN OUT NOCOPY VARCHAR2
12768: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12769: -----procedure that inserts publication applicability parameters on the target instance
12770: PROCEDURE insert_pb_parameters(
12771: p_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12772: ,p_old_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12773: ,p_session_parameter IN OUT NOCOPY VARCHAR2
12774: ,p_db_link IN VARCHAR2
12775: ,x_status IN OUT NOCOPY VARCHAR2
12776: )
13006:
13007: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13008: -----procedure that uploads publication data
13009: ----@p_publication_id : publication request id on the source database
13010: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
13011: AS
13012: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
13013: v_remote_model cz_model_publications.model_id%TYPE;
13014: v_prev_publication_id cz_model_publications.publication_id%TYPE;
13008: -----procedure that uploads publication data
13009: ----@p_publication_id : publication request id on the source database
13010: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
13011: AS
13012: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
13013: v_remote_model cz_model_publications.model_id%TYPE;
13014: v_prev_publication_id cz_model_publications.publication_id%TYPE;
13015: v_prev_export_status cz_model_publications.export_status%TYPE;
13016: BEGIN
13009: ----@p_publication_id : publication request id on the source database
13010: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
13011: AS
13012: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
13013: v_remote_model cz_model_publications.model_id%TYPE;
13014: v_prev_publication_id cz_model_publications.publication_id%TYPE;
13015: v_prev_export_status cz_model_publications.export_status%TYPE;
13016: BEGIN
13017: pbdebug := 22036;
13010: PROCEDURE upload_publication_data(p_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE)
13011: AS
13012: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
13013: v_remote_model cz_model_publications.model_id%TYPE;
13014: v_prev_publication_id cz_model_publications.publication_id%TYPE;
13015: v_prev_export_status cz_model_publications.export_status%TYPE;
13016: BEGIN
13017: pbdebug := 22036;
13018: -------------update the status in cz_model_publications and model exports
13011: AS
13012: v_new_ui_def_id cz_model_publications.ui_def_id%TYPE;
13013: v_remote_model cz_model_publications.model_id%TYPE;
13014: v_prev_publication_id cz_model_publications.publication_id%TYPE;
13015: v_prev_export_status cz_model_publications.export_status%TYPE;
13016: BEGIN
13017: pbdebug := 22036;
13018: -------------update the status in cz_model_publications and model exports
13019: 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);
13014: v_prev_publication_id cz_model_publications.publication_id%TYPE;
13015: v_prev_export_status cz_model_publications.export_status%TYPE;
13016: BEGIN
13017: pbdebug := 22036;
13018: -------------update the status in cz_model_publications and model exports
13019: 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);
13020: ------------get new publication id for the target publication
13021: get_new_publication_id(p_publication_id
13022: ,cz_pb_mgr.v_cz_model_pub_old_id
13042: ,v_prev_export_status
13043: ,cz_pb_mgr.v_prev_remote_publication_id
13044: ,cz_pb_mgr.v_status_code
13045: );
13046: --------insert the new publication into cz_model_publications table of the target db
13047: insert_tgt_publication(cz_pb_mgr.v_cz_model_pub_new_id
13048: ,cz_pb_mgr.v_cz_model_pub_old_id
13049: ,v_remote_model
13050: ,v_new_ui_def_id
13068: IF (LTRIM(RTRIM(UPPER(v_prev_export_status))) = 'PUP')
13069: THEN
13070: IF (cz_pb_mgr.v_status_code = PUBLICATION_ERROR)
13071: THEN
13072: UPDATE cz_model_publications
13073: SET export_status = 'OK'
13074: WHERE publication_id = v_prev_publication_id;
13075: ELSE
13076: UPDATE cz_model_publications
13072: UPDATE cz_model_publications
13073: SET export_status = 'OK'
13074: WHERE publication_id = v_prev_publication_id;
13075: ELSE
13076: UPDATE cz_model_publications
13077: SET deleted_flag = '1'
13078: ,export_status = 'OK'
13079: WHERE publication_id = v_prev_publication_id;
13080:
13079: WHERE publication_id = v_prev_publication_id;
13080:
13081: EXECUTE IMMEDIATE 'BEGIN'
13082: || ' '
13083: || 'UPDATE cz_model_publications'
13084: || cz_pb_mgr.v_db_link
13085: || ' '
13086: || ' '
13087: || 'SET deleted_flag = ''1'','
16715: END;
16716: -----------------------------------------------------------------------------------------------------
16717: -------------- Load data : procedure used to export data
16718: PROCEDURE load_data(
16719: v_publication_id IN cz_model_publications.publication_id%TYPE
16720: ,v_root_model_id IN cz_model_publications.model_id%TYPE
16721: ,v_server_id IN cz_model_publications.server_id%TYPE
16722: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
16723: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
16716: -----------------------------------------------------------------------------------------------------
16717: -------------- Load data : procedure used to export data
16718: PROCEDURE load_data(
16719: v_publication_id IN cz_model_publications.publication_id%TYPE
16720: ,v_root_model_id IN cz_model_publications.model_id%TYPE
16721: ,v_server_id IN cz_model_publications.server_id%TYPE
16722: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
16723: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
16724: )
16717: -------------- Load data : procedure used to export data
16718: PROCEDURE load_data(
16719: v_publication_id IN cz_model_publications.publication_id%TYPE
16720: ,v_root_model_id IN cz_model_publications.model_id%TYPE
16721: ,v_server_id IN cz_model_publications.server_id%TYPE
16722: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
16723: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
16724: )
16725: AS
16718: PROCEDURE load_data(
16719: v_publication_id IN cz_model_publications.publication_id%TYPE
16720: ,v_root_model_id IN cz_model_publications.model_id%TYPE
16721: ,v_server_id IN cz_model_publications.server_id%TYPE
16722: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
16723: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
16724: )
16725: AS
16726: v_db_link VARCHAR2(128);
16878: l_new_publication_id NUMBER;
16879: v_inst_str VARCHAR2(2000);
16880: BEGIN
16881: v_inst_str :=
16882: 'UPDATE cz_model_publications set deleted_flag = ''1'' WHERE object_id := :1 '
16883: || ' '
16884: || 'and object_type = :2 and server_id = :3 and source_target_flag = :4';
16885:
16886: EXECUTE IMMEDIATE v_inst_str
16887: USING p_temp_id, 'UIT', cz_pb_mgr.v_db_link, g_source_flag;
16888:
16889: COMMIT;
16890: v_inst_str :=
16891: 'UPDATE cz_model_publications'
16892: || cz_pb_mgr.v_db_link
16893: || ' set deleted_flag = ''1'' WHERE object_id := :1'
16894: || ' '
16895: || 'and object_type = :2 and server_id = :3 and source_target_flag = :4';
16898: USING p_temp_id, 'UIT', cz_pb_mgr.v_db_link, g_source_flag;
16899:
16900: COMMIT;
16901:
16902: SELECT cz_model_publications_s.NEXTVAL
16903: INTO l_old_publication_id
16904: FROM DUAL;
16905:
16906: l_remote_publication_id :=
16903: INTO l_old_publication_id
16904: FROM DUAL;
16905:
16906: l_remote_publication_id :=
16907: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
16908: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
16909: ,cz_pb_mgr.v_oraclesequenceincr
16910: );
16911: v_inst_str :=
16904: FROM DUAL;
16905:
16906: l_remote_publication_id :=
16907: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
16908: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
16909: ,cz_pb_mgr.v_oraclesequenceincr
16910: );
16911: v_inst_str :=
16912: 'INSERT INTO cz_model_publications'
16908: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
16909: ,cz_pb_mgr.v_oraclesequenceincr
16910: );
16911: v_inst_str :=
16912: 'INSERT INTO cz_model_publications'
16913: || ' '
16914: || '(PUBLICATION_ID,MODEL_ID,OBJECT_ID,OBJECT_TYPE,SERVER_ID,ORGANIZATION_ID,TOP_ITEM_ID,PRODUCT_KEY'
16915: || ' '
16916: || ',PUBLICATION_MODE,UI_DEF_ID,UI_STYLE,APPLICABLE_FROM,APPLICABLE_UNTIL,EXPORT_STATUS,MODEL_PERSISTENT_ID'
16932: EXECUTE IMMEDIATE v_inst_str
16933: USING l_old_publication_id, p_temp_id, p_temp_id, l_remote_publication_id;
16934:
16935: v_inst_str :=
16936: 'INSERT INTO cz_model_publications'
16937: || cz_pb_mgr.v_db_link
16938: || ''
16939: || ' '
16940: || '(PUBLICATION_ID,MODEL_ID,OBJECT_ID,OBJECT_TYPE,SERVER_ID,ORGANIZATION_ID,TOP_ITEM_ID,PRODUCT_KEY'
17112: PROCEDURE proc_export(
17113: publicationid IN NUMBER
17114: ,modelid IN NUMBER
17115: ,serverid IN NUMBER
17116: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
17117: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
17118: )
17119: IS
17120: CURSOR model_cur(rootmodelid NUMBER, serverid NUMBER, pubid NUMBER)
17478: v_object_id cz_rp_entries.object_id%TYPE;
17479: v_copy_number NUMBER := 0.0;
17480: v_rp_orig_sys_ref VARCHAR2(255);
17481: v_imp_ps_node_count PLS_INTEGER := 0;
17482: v_pub_id cz_model_publications.publication_id%TYPE;
17483: l_msg_index NUMBER;
17484: failed_to_lock_model EXCEPTION;
17485: l_msg_data VARCHAR2(2000);
17486: l_msg_count NUMBER := 0;
17711: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17712: ELSE
17713: -----------create a dummy publication
17714: BEGIN
17715: SELECT cz_model_publications_s.NEXTVAL
17716: INTO cz_pb_mgr.v_publication_id
17717: FROM DUAL;
17718:
17719: v_pub_id := cz_pb_mgr.v_publication_id;
17725: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17726: END;
17727:
17728: BEGIN
17729: INSERT INTO cz_model_publications
17730: (publication_id, model_id, server_id, product_key, publication_mode
17731: ,ui_def_id, ui_style, applicable_from, applicable_until, deleted_flag, model_last_struct_update, model_last_logic_update
17732: ,model_last_updated, source_target_flag, object_id, object_type, disabled_flag
17733: )
18110: x_model_id := v_object_id;
18111: END IF;
18112:
18113: ----------delete dummy publication record
18114: DELETE FROM cz_model_publications
18115: WHERE publication_id = v_pub_id;
18116:
18117: DELETE FROM cz_model_publications
18118: WHERE remote_publication_id = v_pub_id;
18113: ----------delete dummy publication record
18114: DELETE FROM cz_model_publications
18115: WHERE publication_id = v_pub_id;
18116:
18117: DELETE FROM cz_model_publications
18118: WHERE remote_publication_id = v_pub_id;
18119:
18120: DELETE FROM cz_pb_model_exports
18121: WHERE publication_id = v_pub_id;
18205:
18206: CURSOR tobepublished_cur
18207: IS
18208: SELECT publication_id
18209: FROM cz_model_publications
18210: WHERE cz_model_publications.deleted_flag = record_not_deleted
18211: AND cz_model_publications.export_status = publication_pending
18212: AND UPPER(object_type) = model_publication
18213: ORDER BY publication_id;
18206: CURSOR tobepublished_cur
18207: IS
18208: SELECT publication_id
18209: FROM cz_model_publications
18210: WHERE cz_model_publications.deleted_flag = record_not_deleted
18211: AND cz_model_publications.export_status = publication_pending
18212: AND UPPER(object_type) = model_publication
18213: ORDER BY publication_id;
18214:
18207: IS
18208: SELECT publication_id
18209: FROM cz_model_publications
18210: WHERE cz_model_publications.deleted_flag = record_not_deleted
18211: AND cz_model_publications.export_status = publication_pending
18212: AND UPPER(object_type) = model_publication
18213: ORDER BY publication_id;
18214:
18215: v_tobepublished cz_model_publications.publication_id%TYPE;
18211: AND cz_model_publications.export_status = publication_pending
18212: AND UPPER(object_type) = model_publication
18213: ORDER BY publication_id;
18214:
18215: v_tobepublished cz_model_publications.publication_id%TYPE;
18216: v_run_id cz_db_logs.run_id%TYPE;
18217: v_pb_status cz_model_publications.export_status%TYPE;
18218: BEGIN
18219:
18213: ORDER BY publication_id;
18214:
18215: v_tobepublished cz_model_publications.publication_id%TYPE;
18216: v_run_id cz_db_logs.run_id%TYPE;
18217: v_pb_status cz_model_publications.export_status%TYPE;
18218: BEGIN
18219:
18220: OPEN tobepublished_cur;
18221:
18238: END publish_all_models;
18239:
18240: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18241: -----initialize pb parameters
18242: PROCEDURE initialize_pb_parameters(p_publication_id IN cz_model_publications.publication_id%TYPE)
18243: AS
18244: l_log_pb_time cz_db_settings.VALUE%TYPE;
18245: l_pub_mode cz_model_publications.publication_mode%TYPE;
18246: BEGIN
18241: -----initialize pb parameters
18242: PROCEDURE initialize_pb_parameters(p_publication_id IN cz_model_publications.publication_id%TYPE)
18243: AS
18244: l_log_pb_time cz_db_settings.VALUE%TYPE;
18245: l_pub_mode cz_model_publications.publication_mode%TYPE;
18246: BEGIN
18247: fnd_msg_pub.initialize;
18248: cz_pb_mgr.v_publication_id := p_publication_id;
18249: cz_pb_mgr.sequence_const := 0;
18262: v_refresh_rules := 'NO';
18263:
18264: SELECT publication_mode
18265: INTO l_pub_mode
18266: FROM cz_model_publications
18267: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted;
18268:
18269: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
18270: THEN
18322: RAISE;
18323: END initialize_pb_parameters;
18324:
18325: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18326: PROCEDURE check_ui_template_exist(p_template_id IN NUMBER, x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE)
18327: IS
18328: l_count NUMBER := 0;
18329: BEGIN
18330: SELECT 1
18348: --------@p_model_id : model id of the pb request
18349: --------@p_ui_def_id : ui_def_id of the request
18350: --------@x_status : publication status parameter
18351: PROCEDURE check_model_ui_exist(
18352: p_publication_id IN cz_model_publications.publication_id%TYPE
18353: ,p_model_id IN cz_model_publications.model_id%TYPE
18354: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18355: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18356: )
18349: --------@p_ui_def_id : ui_def_id of the request
18350: --------@x_status : publication status parameter
18351: PROCEDURE check_model_ui_exist(
18352: p_publication_id IN cz_model_publications.publication_id%TYPE
18353: ,p_model_id IN cz_model_publications.model_id%TYPE
18354: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18355: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18356: )
18357: AS
18350: --------@x_status : publication status parameter
18351: PROCEDURE check_model_ui_exist(
18352: p_publication_id IN cz_model_publications.publication_id%TYPE
18353: ,p_model_id IN cz_model_publications.model_id%TYPE
18354: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18355: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18356: )
18357: AS
18358: v_model_chk_count NUMBER := 0.0;
18351: PROCEDURE check_model_ui_exist(
18352: p_publication_id IN cz_model_publications.publication_id%TYPE
18353: ,p_model_id IN cz_model_publications.model_id%TYPE
18354: ,p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18355: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18356: )
18357: AS
18358: v_model_chk_count NUMBER := 0.0;
18359: v_ui_chk_count NUMBER := 0.0;
18403:
18404: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18405: -------procedure that gets the target ui def id in case no new copy is made
18406: PROCEDURE get_tgt_ui_def(
18407: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18408: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
18409: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
18410: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18404: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18405: -------procedure that gets the target ui def id in case no new copy is made
18406: PROCEDURE get_tgt_ui_def(
18407: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18408: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
18409: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
18410: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18412: )
18405: -------procedure that gets the target ui def id in case no new copy is made
18406: PROCEDURE get_tgt_ui_def(
18407: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18408: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
18409: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
18410: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18412: )
18413: AS
18406: PROCEDURE get_tgt_ui_def(
18407: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18408: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
18409: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
18410: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18412: )
18413: AS
18414: v_ui_name cz_ui_defs.NAME%TYPE;
18407: p_ui_def_id IN cz_model_publications.ui_def_id%TYPE
18408: ,p_prev_rem_publication_id IN cz_model_publications.publication_id%TYPE
18409: ,x_rem_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
18410: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18412: )
18413: AS
18414: v_ui_name cz_ui_defs.NAME%TYPE;
18415: v_old_remote_model cz_model_publications.model_id%TYPE;
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18412: )
18413: AS
18414: v_ui_name cz_ui_defs.NAME%TYPE;
18415: v_old_remote_model cz_model_publications.model_id%TYPE;
18416: ui_cv ref_cursor;
18417: BEGIN
18418: BEGIN
18419: SELECT NAME
18468: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18469: -----procedure that checks the export status of the existing request
18470: -----Only requests with a status of PEN can be published
18471: PROCEDURE check_export_status(
18472: p_export_status IN cz_model_publications.export_status%TYPE
18473: ,p_pb_flag IN VARCHAR2
18474: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18475: )
18476: AS
18470: -----Only requests with a status of PEN can be published
18471: PROCEDURE check_export_status(
18472: p_export_status IN cz_model_publications.export_status%TYPE
18473: ,p_pb_flag IN VARCHAR2
18474: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18475: )
18476: AS
18477: BEGIN
18478: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
18845: l_publication_proc CONSTANT VARCHAR2(10) := 'CZ_PB_MGR';
18846: l_migration_proc CONSTANT VARCHAR2(20) := 'CZ_MODEL_MIGRATION';
18847: l_proc_name v$session.module%TYPE;
18848: v_check_publication BOOLEAN;
18849: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;
18852: v_prev_export_status cz_model_publications.export_status%TYPE;
18853: v_cur_export_status cz_model_publications.export_status%TYPE;
18846: l_migration_proc CONSTANT VARCHAR2(20) := 'CZ_MODEL_MIGRATION';
18847: l_proc_name v$session.module%TYPE;
18848: v_check_publication BOOLEAN;
18849: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;
18852: v_prev_export_status cz_model_publications.export_status%TYPE;
18853: v_cur_export_status cz_model_publications.export_status%TYPE;
18854: v_pb_mode cz_model_publications.publication_mode%TYPE;
18847: l_proc_name v$session.module%TYPE;
18848: v_check_publication BOOLEAN;
18849: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;
18852: v_prev_export_status cz_model_publications.export_status%TYPE;
18853: v_cur_export_status cz_model_publications.export_status%TYPE;
18854: v_pb_mode cz_model_publications.publication_mode%TYPE;
18855: l_tgt_status VARCHAR2(1);
18848: v_check_publication BOOLEAN;
18849: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;
18852: v_prev_export_status cz_model_publications.export_status%TYPE;
18853: v_cur_export_status cz_model_publications.export_status%TYPE;
18854: v_pb_mode cz_model_publications.publication_mode%TYPE;
18855: l_tgt_status VARCHAR2(1);
18856: l_tgt_msg VARCHAR2(2000);
18849: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;
18852: v_prev_export_status cz_model_publications.export_status%TYPE;
18853: v_cur_export_status cz_model_publications.export_status%TYPE;
18854: v_pb_mode cz_model_publications.publication_mode%TYPE;
18855: l_tgt_status VARCHAR2(1);
18856: l_tgt_msg VARCHAR2(2000);
18857: l_msg_data VARCHAR2(2000);
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;
18852: v_prev_export_status cz_model_publications.export_status%TYPE;
18853: v_cur_export_status cz_model_publications.export_status%TYPE;
18854: v_pb_mode cz_model_publications.publication_mode%TYPE;
18855: l_tgt_status VARCHAR2(1);
18856: l_tgt_msg VARCHAR2(2000);
18857: l_msg_data VARCHAR2(2000);
18858: l_msg_count NUMBER;
19065:
19066: RAISE failed_to_lock_model;
19067: END IF;
19068:
19069: UPDATE cz_model_publications
19070: SET export_status = publication_processing
19071: WHERE publication_id = cz_pb_mgr.v_publication_id;
19072:
19073: IF (v_check_publication) THEN
19526:
19527: ------reset status to the original if a re-publish fails
19528: IF (LTRIM(RTRIM(UPPER(v_prev_export_status))) = 'PUP') THEN
19529: IF (cz_pb_mgr.v_status_code = PUBLICATION_ERROR) THEN
19530: UPDATE cz_model_publications
19531: SET export_status = 'OK'
19532: WHERE publication_id = v_prev_publication_id;
19533: ELSE
19534: UPDATE cz_model_publications
19530: UPDATE cz_model_publications
19531: SET export_status = 'OK'
19532: WHERE publication_id = v_prev_publication_id;
19533: ELSE
19534: UPDATE cz_model_publications
19535: SET deleted_flag = '1'
19536: WHERE publication_id = v_prev_publication_id;
19537:
19538: EXECUTE IMMEDIATE 'BEGIN'
19536: WHERE publication_id = v_prev_publication_id;
19537:
19538: EXECUTE IMMEDIATE 'BEGIN'
19539: || ' '
19540: || 'UPDATE cz_model_publications'
19541: || cz_pb_mgr.v_db_link
19542: || ''
19543: || ' '
19544: || 'SET deleted_flag = ''1'''
19770: ,x_msg_count OUT NOCOPY NUMBER
19771: ,x_msg_data OUT NOCOPY VARCHAR2
19772: )
19773: AS
19774: v_server_id cz_model_publications.server_id%TYPE;
19775: v_cz_link_name cz_servers.cz_link_name%TYPE;
19776: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19777: v_export_status cz_model_publications.export_status%TYPE;
19778: l_tmp_publication NUMBER;
19772: )
19773: AS
19774: v_server_id cz_model_publications.server_id%TYPE;
19775: v_cz_link_name cz_servers.cz_link_name%TYPE;
19776: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19777: v_export_status cz_model_publications.export_status%TYPE;
19778: l_tmp_publication NUMBER;
19779: l_object_type cz_model_publications.object_type%TYPE;
19780: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
19773: AS
19774: v_server_id cz_model_publications.server_id%TYPE;
19775: v_cz_link_name cz_servers.cz_link_name%TYPE;
19776: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19777: v_export_status cz_model_publications.export_status%TYPE;
19778: l_tmp_publication NUMBER;
19779: l_object_type cz_model_publications.object_type%TYPE;
19780: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
19781: no_link_name EXCEPTION;
19775: v_cz_link_name cz_servers.cz_link_name%TYPE;
19776: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19777: v_export_status cz_model_publications.export_status%TYPE;
19778: l_tmp_publication NUMBER;
19779: l_object_type cz_model_publications.object_type%TYPE;
19780: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
19781: no_link_name EXCEPTION;
19782: invalid_object_type EXCEPTION;
19783: template_in_use EXCEPTION;
19776: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19777: v_export_status cz_model_publications.export_status%TYPE;
19778: l_tmp_publication NUMBER;
19779: l_object_type cz_model_publications.object_type%TYPE;
19780: l_reset_publication cz_model_publications.remote_publication_id%TYPE := 0;
19781: no_link_name EXCEPTION;
19782: invalid_object_type EXCEPTION;
19783: template_in_use EXCEPTION;
19784: cannot_del_pup EXCEPTION;
19781: no_link_name EXCEPTION;
19782: invalid_object_type EXCEPTION;
19783: template_in_use EXCEPTION;
19784: cannot_del_pup EXCEPTION;
19785: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
19786: BEGIN
19787: fnd_msg_pub.initialize;
19788: x_return_status := FND_API.G_RET_STS_SUCCESS;
19789: x_msg_count := 0;
19799: END IF;
19800:
19801: SELECT server_id, export_status, remote_publication_id, object_type
19802: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
19803: FROM cz_model_publications
19804: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
19805:
19806:
19807: --execute the procedure that obsoletes the records
19800:
19801: SELECT server_id, export_status, remote_publication_id, object_type
19802: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
19803: FROM cz_model_publications
19804: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
19805:
19806:
19807: --execute the procedure that obsoletes the records
19808: --if the target has been converted into a development instance
19813: --it is possible that the obsoleting process changed value of the publication record.
19814: --so requery
19815: SELECT server_id, export_status, remote_publication_id, object_type
19816: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
19817: FROM cz_model_publications
19818: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
19819: END IF;
19820:
19821: IF (v_export_status = 'PUP')
19814: --so requery
19815: SELECT server_id, export_status, remote_publication_id, object_type
19816: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
19817: FROM cz_model_publications
19818: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.deleted_flag = record_not_deleted;
19819: END IF;
19820:
19821: IF (v_export_status = 'PUP')
19822: THEN
19826: ----check for reset cases
19827: BEGIN
19828: SELECT publication_id
19829: INTO l_reset_publication
19830: FROM cz_model_publications
19831: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
19832: AND cz_model_publications.server_id = v_server_id
19833: AND cz_model_publications.deleted_flag = record_not_deleted
19834: AND cz_model_publications.export_status = 'PUP'
19827: BEGIN
19828: SELECT publication_id
19829: INTO l_reset_publication
19830: FROM cz_model_publications
19831: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
19832: AND cz_model_publications.server_id = v_server_id
19833: AND cz_model_publications.deleted_flag = record_not_deleted
19834: AND cz_model_publications.export_status = 'PUP'
19835: AND cz_model_publications.publication_mode = l_pub_mode;
19828: SELECT publication_id
19829: INTO l_reset_publication
19830: FROM cz_model_publications
19831: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
19832: AND cz_model_publications.server_id = v_server_id
19833: AND cz_model_publications.deleted_flag = record_not_deleted
19834: AND cz_model_publications.export_status = 'PUP'
19835: AND cz_model_publications.publication_mode = l_pub_mode;
19836: EXCEPTION
19829: INTO l_reset_publication
19830: FROM cz_model_publications
19831: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
19832: AND cz_model_publications.server_id = v_server_id
19833: AND cz_model_publications.deleted_flag = record_not_deleted
19834: AND cz_model_publications.export_status = 'PUP'
19835: AND cz_model_publications.publication_mode = l_pub_mode;
19836: EXCEPTION
19837: WHEN OTHERS
19830: FROM cz_model_publications
19831: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
19832: AND cz_model_publications.server_id = v_server_id
19833: AND cz_model_publications.deleted_flag = record_not_deleted
19834: AND cz_model_publications.export_status = 'PUP'
19835: AND cz_model_publications.publication_mode = l_pub_mode;
19836: EXCEPTION
19837: WHEN OTHERS
19838: THEN
19831: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
19832: AND cz_model_publications.server_id = v_server_id
19833: AND cz_model_publications.deleted_flag = record_not_deleted
19834: AND cz_model_publications.export_status = 'PUP'
19835: AND cz_model_publications.publication_mode = l_pub_mode;
19836: EXCEPTION
19837: WHEN OTHERS
19838: THEN
19839: l_reset_publication := 0;
19873: RAISE template_in_use;
19874: END IF;
19875: END IF;
19876:
19877: UPDATE cz_model_publications
19878: SET deleted_flag = '1'
19879: WHERE publication_id = publicationid;
19880:
19881: DELETE FROM cz_pb_client_apps
19885: WHERE publication_id = publicationid;
19886:
19887: IF (l_reset_publication > 0)
19888: THEN
19889: UPDATE cz_model_publications
19890: SET export_status = 'OK'
19891: WHERE publication_id = l_reset_publication;
19892: END IF;
19893:
19894: IF ((v_export_status <> 'PEN') AND(v_remote_publication_id IS NOT NULL))
19895: THEN
19896: EXECUTE IMMEDIATE 'BEGIN'
19897: || ' '
19898: || 'UPDATE cz_model_publications'
19899: || v_cz_link_name
19900: || ''
19901: || ' '
19902: || 'SET deleted_flag = ''1'''
19972: ,x_msg_count OUT NOCOPY NUMBER
19973: ,x_msg_data OUT NOCOPY VARCHAR2
19974: )
19975: AS
19976: v_server_id cz_model_publications.server_id%TYPE;
19977: v_cz_link_name cz_servers.cz_link_name%TYPE;
19978: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19979: v_object_type cz_model_publications.object_type%TYPE;
19980: v_export_status cz_model_publications.export_status%TYPE;
19974: )
19975: AS
19976: v_server_id cz_model_publications.server_id%TYPE;
19977: v_cz_link_name cz_servers.cz_link_name%TYPE;
19978: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19979: v_object_type cz_model_publications.object_type%TYPE;
19980: v_export_status cz_model_publications.export_status%TYPE;
19981: cannot_disable_template EXCEPTION;
19982: cannot_disable_publication EXCEPTION;
19975: AS
19976: v_server_id cz_model_publications.server_id%TYPE;
19977: v_cz_link_name cz_servers.cz_link_name%TYPE;
19978: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19979: v_object_type cz_model_publications.object_type%TYPE;
19980: v_export_status cz_model_publications.export_status%TYPE;
19981: cannot_disable_template EXCEPTION;
19982: cannot_disable_publication EXCEPTION;
19983: BEGIN
19976: v_server_id cz_model_publications.server_id%TYPE;
19977: v_cz_link_name cz_servers.cz_link_name%TYPE;
19978: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19979: v_object_type cz_model_publications.object_type%TYPE;
19980: v_export_status cz_model_publications.export_status%TYPE;
19981: cannot_disable_template EXCEPTION;
19982: cannot_disable_publication EXCEPTION;
19983: BEGIN
19984: x_return_status := FND_API.G_RET_STS_SUCCESS;
19994: END IF;
19995:
19996: SELECT object_type, server_id, remote_publication_id, export_status
19997: INTO v_object_type, v_server_id, v_remote_publication_id, v_export_status
19998: FROM cz_model_publications
19999: WHERE cz_model_publications.publication_id = publicationid;
20000:
20001: BEGIN
20002: SELECT fndnam_link_name
19995:
19996: SELECT object_type, server_id, remote_publication_id, export_status
19997: INTO v_object_type, v_server_id, v_remote_publication_id, v_export_status
19998: FROM cz_model_publications
19999: WHERE cz_model_publications.publication_id = publicationid;
20000:
20001: BEGIN
20002: SELECT fndnam_link_name
20003: INTO v_cz_link_name
20027: END IF;
20028:
20029: cz_pb_mgr.remote_publication_id := v_remote_publication_id;
20030:
20031: UPDATE cz_model_publications
20032: SET disabled_flag = '1'
20033: WHERE publication_id = publicationid;
20034:
20035: EXECUTE IMMEDIATE 'BEGIN'
20033: WHERE publication_id = publicationid;
20034:
20035: EXECUTE IMMEDIATE 'BEGIN'
20036: || ' '
20037: || 'UPDATE cz_model_publications'
20038: || v_cz_link_name
20039: || ''
20040: || ' '
20041: || 'SET disabled_flag = ''1'''
20069: END disable_publication;
20070:
20071: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
20072: PROCEDURE get_edit_info(
20073: publicationid IN cz_model_publications.publication_id%TYPE
20074: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
20075: ,x_publication_mode IN OUT NOCOPY VARCHAR2
20076: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
20077: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
20070:
20071: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
20072: PROCEDURE get_edit_info(
20073: publicationid IN cz_model_publications.publication_id%TYPE
20074: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
20075: ,x_publication_mode IN OUT NOCOPY VARCHAR2
20076: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
20077: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
20078: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
20073: publicationid IN cz_model_publications.publication_id%TYPE
20074: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
20075: ,x_publication_mode IN OUT NOCOPY VARCHAR2
20076: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
20077: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
20078: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
20079: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
20080: )
20081: AS
20074: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
20075: ,x_publication_mode IN OUT NOCOPY VARCHAR2
20076: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
20077: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
20078: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
20079: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
20080: )
20081: AS
20082: BEGIN
20075: ,x_publication_mode IN OUT NOCOPY VARCHAR2
20076: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
20077: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
20078: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
20079: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
20080: )
20081: AS
20082: BEGIN
20083: SELECT product_key, publication_mode, server_id, export_status, source_target_flag, remote_publication_id
20081: AS
20082: BEGIN
20083: SELECT product_key, publication_mode, server_id, export_status, source_target_flag, remote_publication_id
20084: INTO x_product_key, x_publication_mode, x_server_id, x_export_status, x_source_target_flag, x_remote_publication_id
20085: FROM cz_model_publications
20086: WHERE cz_model_publications.publication_id = publicationid;
20087: EXCEPTION
20088: WHEN OTHERS
20089: THEN
20082: BEGIN
20083: SELECT product_key, publication_mode, server_id, export_status, source_target_flag, remote_publication_id
20084: INTO x_product_key, x_publication_mode, x_server_id, x_export_status, x_source_target_flag, x_remote_publication_id
20085: FROM cz_model_publications
20086: WHERE cz_model_publications.publication_id = publicationid;
20087: EXCEPTION
20088: WHEN OTHERS
20089: THEN
20090: NULL;
20154: RAISE;
20155: END;
20156:
20157: -------->>>>>>>>>>>>>>>>>>
20158: PROCEDURE delete_src_pb_data(publicationid IN cz_model_publications.publication_id%TYPE)
20159: AS
20160: BEGIN
20161: DELETE FROM cz_publication_usages
20162: WHERE cz_publication_usages.publication_id = publicationid;
20173: END;
20174:
20175: ------->>>>>>>>>>>>>>>>>>>>>>
20176: PROCEDURE insert_src_pb_data(
20177: publicationid IN cz_model_publications.publication_id%TYPE
20178: ,p_application_id_tbl IN cz_pb_mgr.t_ref
20179: ,p_language_id_tbl IN cz_pb_mgr.t_lang_code
20180: ,p_usage_id_tbl IN cz_pb_mgr.t_ref
20181: ,x_status IN OUT NOCOPY VARCHAR2
20225:
20226: -------->>>>>>>>>>>>>>>>>>>>>
20227: PROCEDURE insert_tgt_pb_data(
20228: p_status_str IN OUT NOCOPY VARCHAR2
20229: ,p_export_status IN cz_model_publications.export_status%TYPE
20230: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE
20231: ,p_publication_mode IN VARCHAR2
20232: ,p_start_date IN DATE
20233: ,p_disable_date IN DATE
20230: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE
20231: ,p_publication_mode IN VARCHAR2
20232: ,p_start_date IN DATE
20233: ,p_disable_date IN DATE
20234: ,p_remote_publication_id IN cz_model_publications.remote_publication_id%TYPE
20235: ,p_application_id_tbl IN cz_pb_mgr.t_ref
20236: ,p_language_id_tbl IN cz_pb_mgr.t_lang_code
20237: ,p_usage_id_tbl IN cz_pb_mgr.t_ref
20238: )
20243: BEGIN
20244: IF ((p_status_str <> '-1') AND(p_export_status <> 'PEN'))
20245: THEN
20246: v_edit_str :=
20247: 'UPDATE cz_model_publications'
20248: || p_tgt_link
20249: || ' '
20250: || 'SET publication_mode = :1,'
20251: || ' '
20333: ,x_msg_count OUT NOCOPY NUMBER
20334: ,x_msg_data OUT NOCOPY VARCHAR2
20335: )
20336: AS
20337: v_product_key cz_model_publications.product_key%TYPE;
20338: v_publication_mode cz_model_publications.publication_mode%TYPE;
20339: v_server_id cz_model_publications.server_id%TYPE;
20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20341: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20334: ,x_msg_data OUT NOCOPY VARCHAR2
20335: )
20336: AS
20337: v_product_key cz_model_publications.product_key%TYPE;
20338: v_publication_mode cz_model_publications.publication_mode%TYPE;
20339: v_server_id cz_model_publications.server_id%TYPE;
20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20341: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20342: v_export_status cz_model_publications.export_status%TYPE;
20335: )
20336: AS
20337: v_product_key cz_model_publications.product_key%TYPE;
20338: v_publication_mode cz_model_publications.publication_mode%TYPE;
20339: v_server_id cz_model_publications.server_id%TYPE;
20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20341: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20342: v_export_status cz_model_publications.export_status%TYPE;
20343: v_count NUMBER;
20336: AS
20337: v_product_key cz_model_publications.product_key%TYPE;
20338: v_publication_mode cz_model_publications.publication_mode%TYPE;
20339: v_server_id cz_model_publications.server_id%TYPE;
20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20341: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20342: v_export_status cz_model_publications.export_status%TYPE;
20343: v_count NUMBER;
20344: v_application_id VARCHAR2(2000);
20337: v_product_key cz_model_publications.product_key%TYPE;
20338: v_publication_mode cz_model_publications.publication_mode%TYPE;
20339: v_server_id cz_model_publications.server_id%TYPE;
20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20341: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20342: v_export_status cz_model_publications.export_status%TYPE;
20343: v_count NUMBER;
20344: v_application_id VARCHAR2(2000);
20345: v_language_id VARCHAR2(2000);
20338: v_publication_mode cz_model_publications.publication_mode%TYPE;
20339: v_server_id cz_model_publications.server_id%TYPE;
20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20341: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20342: v_export_status cz_model_publications.export_status%TYPE;
20343: v_count NUMBER;
20344: v_application_id VARCHAR2(2000);
20345: v_language_id VARCHAR2(2000);
20346: v_usage_id VARCHAR2(2000);
20370:
20371: BEGIN
20372: SELECT publication_id
20373: INTO l_publication_id
20374: FROM cz_model_publications
20375: WHERE cz_model_publications.publication_id = publicationid;
20376: EXCEPTION
20377: WHEN NO_DATA_FOUND
20378: THEN
20371: BEGIN
20372: SELECT publication_id
20373: INTO l_publication_id
20374: FROM cz_model_publications
20375: WHERE cz_model_publications.publication_id = publicationid;
20376: EXCEPTION
20377: WHEN NO_DATA_FOUND
20378: THEN
20379: RAISE no_pub_found;
20380: END;
20381:
20382: SELECT COUNT(*)
20383: INTO v_count
20384: FROM cz_model_publications
20385: WHERE cz_model_publications.publication_id = publicationid
20386: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
20387:
20388: IF (v_count = 0)
20381:
20382: SELECT COUNT(*)
20383: INTO v_count
20384: FROM cz_model_publications
20385: WHERE cz_model_publications.publication_id = publicationid
20386: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
20387:
20388: IF (v_count = 0)
20389: THEN
20382: SELECT COUNT(*)
20383: INTO v_count
20384: FROM cz_model_publications
20385: WHERE cz_model_publications.publication_id = publicationid
20386: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
20387:
20388: IF (v_count = 0)
20389: THEN
20390: x_return_status := FND_API.G_RET_STS_ERROR;
20399: ELSE
20400: v_tgt_link := retrieve_db_link(v_server_id);
20401: END IF;
20402:
20403: UPDATE cz_model_publications
20404: SET publication_mode = publicationmode
20405: ,applicable_from = startdate
20406: ,applicable_until = disabledate
20407: WHERE publication_id = publicationid;
20459: ,x_msg_count OUT NOCOPY NUMBER
20460: ,x_msg_data OUT NOCOPY VARCHAR2
20461: )
20462: AS
20463: v_product_key cz_model_publications.product_key%TYPE;
20464: v_publication_mode cz_model_publications.publication_mode%TYPE;
20465: v_server_id cz_model_publications.server_id%TYPE;
20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20467: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20460: ,x_msg_data OUT NOCOPY VARCHAR2
20461: )
20462: AS
20463: v_product_key cz_model_publications.product_key%TYPE;
20464: v_publication_mode cz_model_publications.publication_mode%TYPE;
20465: v_server_id cz_model_publications.server_id%TYPE;
20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20467: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20468: v_export_status cz_model_publications.export_status%TYPE;
20461: )
20462: AS
20463: v_product_key cz_model_publications.product_key%TYPE;
20464: v_publication_mode cz_model_publications.publication_mode%TYPE;
20465: v_server_id cz_model_publications.server_id%TYPE;
20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20467: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20468: v_export_status cz_model_publications.export_status%TYPE;
20469: v_count NUMBER;
20462: AS
20463: v_product_key cz_model_publications.product_key%TYPE;
20464: v_publication_mode cz_model_publications.publication_mode%TYPE;
20465: v_server_id cz_model_publications.server_id%TYPE;
20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20467: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20468: v_export_status cz_model_publications.export_status%TYPE;
20469: v_count NUMBER;
20470: v_application_id VARCHAR2(2000);
20463: v_product_key cz_model_publications.product_key%TYPE;
20464: v_publication_mode cz_model_publications.publication_mode%TYPE;
20465: v_server_id cz_model_publications.server_id%TYPE;
20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20467: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20468: v_export_status cz_model_publications.export_status%TYPE;
20469: v_count NUMBER;
20470: v_application_id VARCHAR2(2000);
20471: v_language_id VARCHAR2(2000);
20464: v_publication_mode cz_model_publications.publication_mode%TYPE;
20465: v_server_id cz_model_publications.server_id%TYPE;
20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20467: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20468: v_export_status cz_model_publications.export_status%TYPE;
20469: v_count NUMBER;
20470: v_application_id VARCHAR2(2000);
20471: v_language_id VARCHAR2(2000);
20472: v_usage_id VARCHAR2(2000);
20493:
20494: BEGIN
20495: SELECT publication_id
20496: INTO l_publication_id
20497: FROM cz_model_publications
20498: WHERE cz_model_publications.publication_id = publicationid;
20499: EXCEPTION
20500: WHEN NO_DATA_FOUND
20501: THEN
20494: BEGIN
20495: SELECT publication_id
20496: INTO l_publication_id
20497: FROM cz_model_publications
20498: WHERE cz_model_publications.publication_id = publicationid;
20499: EXCEPTION
20500: WHEN NO_DATA_FOUND
20501: THEN
20502: RAISE no_pub_found;
20503: END;
20504:
20505: SELECT COUNT(*)
20506: INTO v_count
20507: FROM cz_model_publications
20508: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
20509:
20510: IF (v_count = 0)
20511: THEN
20504:
20505: SELECT COUNT(*)
20506: INTO v_count
20507: FROM cz_model_publications
20508: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
20509:
20510: IF (v_count = 0)
20511: THEN
20512: x_return_status := FND_API.G_RET_STS_ERROR;
20521: ELSE
20522: v_tgt_link := retrieve_db_link(v_server_id);
20523: END IF;
20524:
20525: UPDATE cz_model_publications
20526: SET publication_mode = publicationmode
20527: ,applicable_from = startdate
20528: ,applicable_until = disabledate
20529: WHERE publication_id = publicationid;
20577: ,x_msg_count OUT NOCOPY NUMBER
20578: ,x_msg_data OUT NOCOPY VARCHAR2
20579: )
20580: AS
20581: v_product_key cz_model_publications.product_key%TYPE;
20582: v_publication_mode cz_model_publications.publication_mode%TYPE;
20583: v_server_id cz_model_publications.server_id%TYPE;
20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20585: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20578: ,x_msg_data OUT NOCOPY VARCHAR2
20579: )
20580: AS
20581: v_product_key cz_model_publications.product_key%TYPE;
20582: v_publication_mode cz_model_publications.publication_mode%TYPE;
20583: v_server_id cz_model_publications.server_id%TYPE;
20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20585: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20586: v_export_status cz_model_publications.export_status%TYPE;
20579: )
20580: AS
20581: v_product_key cz_model_publications.product_key%TYPE;
20582: v_publication_mode cz_model_publications.publication_mode%TYPE;
20583: v_server_id cz_model_publications.server_id%TYPE;
20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20585: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20586: v_export_status cz_model_publications.export_status%TYPE;
20587: v_count NUMBER;
20580: AS
20581: v_product_key cz_model_publications.product_key%TYPE;
20582: v_publication_mode cz_model_publications.publication_mode%TYPE;
20583: v_server_id cz_model_publications.server_id%TYPE;
20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20585: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20586: v_export_status cz_model_publications.export_status%TYPE;
20587: v_count NUMBER;
20588: v_application_id VARCHAR2(2000);
20581: v_product_key cz_model_publications.product_key%TYPE;
20582: v_publication_mode cz_model_publications.publication_mode%TYPE;
20583: v_server_id cz_model_publications.server_id%TYPE;
20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20585: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20586: v_export_status cz_model_publications.export_status%TYPE;
20587: v_count NUMBER;
20588: v_application_id VARCHAR2(2000);
20589: v_language_id VARCHAR2(2000);
20582: v_publication_mode cz_model_publications.publication_mode%TYPE;
20583: v_server_id cz_model_publications.server_id%TYPE;
20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
20585: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20586: v_export_status cz_model_publications.export_status%TYPE;
20587: v_count NUMBER;
20588: v_application_id VARCHAR2(2000);
20589: v_language_id VARCHAR2(2000);
20590: v_usage_id VARCHAR2(2000);
20614:
20615: BEGIN
20616: SELECT publication_id
20617: INTO l_publication_id
20618: FROM cz_model_publications
20619: WHERE cz_model_publications.publication_id = publicationid;
20620: EXCEPTION
20621: WHEN NO_DATA_FOUND
20622: THEN
20615: BEGIN
20616: SELECT publication_id
20617: INTO l_publication_id
20618: FROM cz_model_publications
20619: WHERE cz_model_publications.publication_id = publicationid;
20620: EXCEPTION
20621: WHEN NO_DATA_FOUND
20622: THEN
20623: RAISE no_pub_found;
20624: END;
20625:
20626: SELECT COUNT(*)
20627: INTO v_count
20628: FROM cz_model_publications
20629: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
20630:
20631: IF (v_count = 0)
20632: THEN
20625:
20626: SELECT COUNT(*)
20627: INTO v_count
20628: FROM cz_model_publications
20629: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
20630:
20631: IF (v_count = 0)
20632: THEN
20633: x_return_status := FND_API.G_RET_STS_ERROR;
20642: ELSE
20643: v_tgt_link := retrieve_db_link(v_server_id);
20644: END IF;
20645:
20646: -----UPDATE cz_model_publications
20647: -----SET publication_mode = publicationMode,
20648: -----applicable_from = startDate,
20649: -----applicable_until = disableDate
20650: -----WHERE publication_id = publicationId;
20940: PROCEDURE reset_processing_pubs
20941: IS
20942: v_link_name cz_servers.fndnam_link_name%TYPE;
20943: v_db_link VARCHAR2(255);
20944: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20945: BEGIN
20946: fnd_msg_pub.initialize;
20947:
20948: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
20953: l_pub_mode := cz_model_migration_pvt.mode_copy;
20954: END IF;
20955:
20956: FOR i IN (SELECT publication_id, remote_publication_id, server_id
20957: FROM cz_model_publications
20958: WHERE UPPER(export_status) = publication_processing AND deleted_flag = '0')
20959: LOOP
20960: BEGIN
20961: SELECT fndnam_link_name
20972:
20973: --
20974: -- mark remote publication as deleted
20975: --
20976: EXECUTE IMMEDIATE 'UPDATE CZ_MODEL_PUBLICATIONS' || v_db_link || ' SET deleted_flag=:1' || ' WHERE publication_id = :2'
20977: USING '1', i.remote_publication_id;
20978: EXCEPTION
20979: WHEN NO_DATA_FOUND
20980: THEN
20986: END LOOP;
20987:
20988: DELETE FROM cz_pb_model_exports
20989: WHERE publication_id IN(SELECT publication_id
20990: FROM cz_model_publications
20991: WHERE UPPER(export_status) = publication_processing);
20992:
20993: UPDATE cz_model_publications
20994: SET export_status = publication_pending
20989: WHERE publication_id IN(SELECT publication_id
20990: FROM cz_model_publications
20991: WHERE UPPER(export_status) = publication_processing);
20992:
20993: UPDATE cz_model_publications
20994: SET export_status = publication_pending
20995: WHERE UPPER(export_status) = publication_processing;
20996:
20997: COMMIT;
21019: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21020: ------procedure that gets applicability parameters for the
21021: ------publication to be republished
21022: PROCEDURE get_pb_parameters(
21023: p_publication_id IN cz_model_publications.publication_id%TYPE
21024: ,x_applicationid_tbl IN OUT NOCOPY cz_pb_mgr.t_ref
21025: ,x_usageid_tbl IN OUT NOCOPY cz_pb_mgr.t_ref
21026: ,x_languageid_tbl IN OUT NOCOPY cz_pb_mgr.t_lang_code
21027: ,x_status IN OUT NOCOPY VARCHAR2
21060: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21061: ------procedure that creates a new publication request
21062: ------for republish
21063: PROCEDURE create_republish_request(
21064: p_publication_id IN cz_model_publications.publication_id%TYPE
21065: ,p_start_date IN DATE
21066: ,p_end_date IN DATE
21067: ,x_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
21068: ,p_repub_str IN VARCHAR2
21063: PROCEDURE create_republish_request(
21064: p_publication_id IN cz_model_publications.publication_id%TYPE
21065: ,p_start_date IN DATE
21066: ,p_end_date IN DATE
21067: ,x_new_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
21068: ,p_repub_str IN VARCHAR2
21069: ,x_status IN OUT NOCOPY VARCHAR2
21070: )
21071: AS
21068: ,p_repub_str IN VARCHAR2
21069: ,x_status IN OUT NOCOPY VARCHAR2
21070: )
21071: AS
21072: v_new_publication_id cz_model_publications.publication_id%TYPE;
21073: v_old_publication_id cz_model_publications.publication_id%TYPE;
21074: BEGIN
21075: x_status := 'OK';
21076:
21069: ,x_status IN OUT NOCOPY VARCHAR2
21070: )
21071: AS
21072: v_new_publication_id cz_model_publications.publication_id%TYPE;
21073: v_old_publication_id cz_model_publications.publication_id%TYPE;
21074: BEGIN
21075: x_status := 'OK';
21076:
21077: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21073: v_old_publication_id cz_model_publications.publication_id%TYPE;
21074: BEGIN
21075: x_status := 'OK';
21076:
21077: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21078: INTO v_new_publication_id, v_old_publication_id
21079: FROM DUAL;
21080:
21081: INSERT INTO cz_model_publications
21077: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21078: INTO v_new_publication_id, v_old_publication_id
21079: FROM DUAL;
21080:
21081: INSERT INTO cz_model_publications
21082: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
21083: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update
21084: ,model_last_updated, user_str01, user_str02, user_str03, user_str04, user_num01, user_num02, user_num03, user_num04
21085: ,model_persistent_id, source_target_flag, remote_publication_id, disabled_flag, object_id, object_type)
21086: SELECT v_new_publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
21087: ,p_start_date, p_end_date, 'PEN', '0', model_last_struct_update, model_last_logic_update, model_last_updated, user_str01, user_str02
21088: ,user_str03, user_str04, user_num01, user_num02, user_num03, user_num04, model_persistent_id, source_target_flag
21089: ,remote_publication_id, disabled_flag, object_id, object_type
21090: FROM cz_model_publications
21091: WHERE publication_id = p_publication_id;
21092:
21093: v_repub_parameter := pub_model;
21094: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_status);
21094: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_status);
21095:
21096: IF (p_repub_str = new_copy_str)
21097: THEN
21098: UPDATE cz_model_publications
21099: SET remote_publication_id = NULL
21100: WHERE publication_id = v_new_publication_id;
21101: ELSIF(p_repub_str = repub_str)
21102: THEN
21099: SET remote_publication_id = NULL
21100: WHERE publication_id = v_new_publication_id;
21101: ELSIF(p_repub_str = repub_str)
21102: THEN
21103: UPDATE cz_model_publications
21104: SET export_status = 'PUP'
21105: WHERE publication_id = p_publication_id;
21106: END IF;
21107:
21123: ,x_msg_count OUT NOCOPY NUMBER
21124: ,x_msg_data OUT NOCOPY VARCHAR2
21125: )
21126: AS
21127: v_new_publication_id cz_model_publications.publication_id%TYPE;
21128: v_old_publication_id cz_model_publications.publication_id%TYPE;
21129: v_source_pb_record cz_model_publications%ROWTYPE;
21130: l_application_id_tbl cz_pb_mgr.t_ref;
21131: l_language_id_tbl cz_pb_mgr.t_lang_code;
21124: ,x_msg_data OUT NOCOPY VARCHAR2
21125: )
21126: AS
21127: v_new_publication_id cz_model_publications.publication_id%TYPE;
21128: v_old_publication_id cz_model_publications.publication_id%TYPE;
21129: v_source_pb_record cz_model_publications%ROWTYPE;
21130: l_application_id_tbl cz_pb_mgr.t_ref;
21131: l_language_id_tbl cz_pb_mgr.t_lang_code;
21132: l_usage_id_tbl cz_pb_mgr.t_ref;
21125: )
21126: AS
21127: v_new_publication_id cz_model_publications.publication_id%TYPE;
21128: v_old_publication_id cz_model_publications.publication_id%TYPE;
21129: v_source_pb_record cz_model_publications%ROWTYPE;
21130: l_application_id_tbl cz_pb_mgr.t_ref;
21131: l_language_id_tbl cz_pb_mgr.t_lang_code;
21132: l_usage_id_tbl cz_pb_mgr.t_ref;
21133: l_param_status VARCHAR2(2000);
21157:
21158: ----get source pb info
21159: SELECT *
21160: INTO v_source_pb_record
21161: FROM cz_model_publications
21162: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted AND source_target_flag = cz_model_migration_pvt.pub_source_flag;
21163:
21164: ----check status
21165: IF (v_source_pb_record.export_status <> 'OK')
21221: THEN
21222: RAISE pub_overlap;
21223: END IF;
21224:
21225: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21226: INTO v_new_publication_id, v_old_publication_id
21227: FROM DUAL;
21228:
21229: INSERT INTO cz_model_publications
21225: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21226: INTO v_new_publication_id, v_old_publication_id
21227: FROM DUAL;
21228:
21229: INSERT INTO cz_model_publications
21230: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
21231: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update
21232: ,model_last_updated, user_str01, user_str02, user_str03, user_str04, user_num01, user_num02, user_num03, user_num04
21233: ,model_persistent_id, source_target_flag, remote_publication_id, object_id, object_type, disabled_flag)
21234: SELECT v_new_publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
21235: ,applicable_from, applicable_until, 'PEN', '0', model_last_struct_update, model_last_logic_update, model_last_updated, user_str01
21236: ,user_str02, user_str03, user_str04, user_num01, user_num02, user_num03, user_num04, model_persistent_id, source_target_flag
21237: ,remote_publication_id, object_id, object_type, disabled_flag
21238: FROM cz_model_publications
21239: WHERE publication_id = p_publication_id;
21240:
21241: v_repub_parameter := pub_model;
21242: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_return_status);
21240:
21241: v_repub_parameter := pub_model;
21242: insert_pb_parameters(v_new_publication_id, v_old_publication_id, v_repub_parameter, ' ', x_return_status);
21243:
21244: UPDATE cz_model_publications
21245: SET export_status = 'PUP'
21246: WHERE publication_id = p_publication_id;
21247:
21248: x_new_publication_id := v_new_publication_id;
21317: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21318: ------procedure that resets the start and end dates
21319: ------of the original publication
21320: PROCEDURE reset_pb_dates(
21321: p_publicationid IN cz_model_publications.publication_id%TYPE
21322: ,x_applicable_from IN OUT NOCOPY DATE
21323: ,x_applicable_until IN OUT NOCOPY DATE
21324: ,x_orig_start_date IN OUT NOCOPY DATE
21325: ,x_orig_end_date IN OUT NOCOPY DATE
21329: ,x_status IN OUT NOCOPY VARCHAR2
21330: )
21331: AS
21332: v_db_link cz_servers.fndnam_link_name%TYPE;
21333: v_server_id cz_model_publications.server_id%TYPE;
21334: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21335: reset_date_error EXCEPTION;
21336: BEGIN
21337: SELECT applicable_from, applicable_until, server_id, remote_publication_id
21330: )
21331: AS
21332: v_db_link cz_servers.fndnam_link_name%TYPE;
21333: v_server_id cz_model_publications.server_id%TYPE;
21334: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21335: reset_date_error EXCEPTION;
21336: BEGIN
21337: SELECT applicable_from, applicable_until, server_id, remote_publication_id
21338: INTO v_repub_appl_from, v_repub_appl_until, v_server_id, v_remote_publication_id
21335: reset_date_error EXCEPTION;
21336: BEGIN
21337: SELECT applicable_from, applicable_until, server_id, remote_publication_id
21338: INTO v_repub_appl_from, v_repub_appl_until, v_server_id, v_remote_publication_id
21339: FROM cz_model_publications
21340: WHERE publication_id = p_publicationid;
21341:
21342: x_orig_start_date := v_repub_appl_from;
21343: x_orig_end_date := v_repub_appl_until;
21394: ELSE
21395: RAISE reset_date_error;
21396: END IF;
21397:
21398: UPDATE cz_model_publications
21399: SET applicable_from = v_repub_appl_from
21400: ,applicable_until = v_repub_appl_until
21401: WHERE publication_id = p_publicationid;
21402:
21417: END reset_pb_dates;
21418:
21419: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21420: PROCEDURE reset_repub_changes(
21421: p_publication_id IN cz_model_publications.publication_id%TYPE
21422: ,p_orig_start_date IN DATE
21423: ,p_orig_end_date IN DATE
21424: ,x_reset_status IN OUT NOCOPY VARCHAR2
21425: )
21424: ,x_reset_status IN OUT NOCOPY VARCHAR2
21425: )
21426: AS
21427: BEGIN
21428: UPDATE cz_model_publications
21429: SET cz_model_publications.applicable_from = p_orig_start_date
21430: ,cz_model_publications.applicable_until = p_orig_end_date
21431: ,cz_model_publications.deleted_flag = '0'
21432: ,cz_model_publications.export_status = 'OK'
21425: )
21426: AS
21427: BEGIN
21428: UPDATE cz_model_publications
21429: SET cz_model_publications.applicable_from = p_orig_start_date
21430: ,cz_model_publications.applicable_until = p_orig_end_date
21431: ,cz_model_publications.deleted_flag = '0'
21432: ,cz_model_publications.export_status = 'OK'
21433: WHERE cz_model_publications.publication_id = p_publication_id;
21426: AS
21427: BEGIN
21428: UPDATE cz_model_publications
21429: SET cz_model_publications.applicable_from = p_orig_start_date
21430: ,cz_model_publications.applicable_until = p_orig_end_date
21431: ,cz_model_publications.deleted_flag = '0'
21432: ,cz_model_publications.export_status = 'OK'
21433: WHERE cz_model_publications.publication_id = p_publication_id;
21434:
21427: BEGIN
21428: UPDATE cz_model_publications
21429: SET cz_model_publications.applicable_from = p_orig_start_date
21430: ,cz_model_publications.applicable_until = p_orig_end_date
21431: ,cz_model_publications.deleted_flag = '0'
21432: ,cz_model_publications.export_status = 'OK'
21433: WHERE cz_model_publications.publication_id = p_publication_id;
21434:
21435: COMMIT;
21428: UPDATE cz_model_publications
21429: SET cz_model_publications.applicable_from = p_orig_start_date
21430: ,cz_model_publications.applicable_until = p_orig_end_date
21431: ,cz_model_publications.deleted_flag = '0'
21432: ,cz_model_publications.export_status = 'OK'
21433: WHERE cz_model_publications.publication_id = p_publication_id;
21434:
21435: COMMIT;
21436: EXCEPTION
21429: SET cz_model_publications.applicable_from = p_orig_start_date
21430: ,cz_model_publications.applicable_until = p_orig_end_date
21431: ,cz_model_publications.deleted_flag = '0'
21432: ,cz_model_publications.export_status = 'OK'
21433: WHERE cz_model_publications.publication_id = p_publication_id;
21434:
21435: COMMIT;
21436: EXCEPTION
21437: WHEN OTHERS
21447: p_publication_id IN OUT NOCOPY NUMBER
21448: ,p_start_date IN OUT NOCOPY DATE
21449: ,p_end_date IN OUT NOCOPY DATE
21450: ,x_run_id OUT NOCOPY NUMBER
21451: ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE
21452: )
21453: AS
21454: v_upto_date_status VARCHAR2(2000);
21455: v_source_pb_record cz_model_publications%ROWTYPE;
21451: ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE
21452: )
21453: AS
21454: v_upto_date_status VARCHAR2(2000);
21455: v_source_pb_record cz_model_publications%ROWTYPE;
21456: v_new_publication_id cz_model_publications.publication_id%TYPE;
21457: v_publicationidstring VARCHAR2(2000);
21458: v_reset_str VARCHAR2(100);
21459: v_reset_status VARCHAR2(2000);
21452: )
21453: AS
21454: v_upto_date_status VARCHAR2(2000);
21455: v_source_pb_record cz_model_publications%ROWTYPE;
21456: v_new_publication_id cz_model_publications.publication_id%TYPE;
21457: v_publicationidstring VARCHAR2(2000);
21458: v_reset_str VARCHAR2(100);
21459: v_reset_status VARCHAR2(2000);
21460: v_repub_status VARCHAR2(2000);
21480:
21481: ----get source pb info
21482: SELECT *
21483: INTO v_source_pb_record
21484: FROM cz_model_publications
21485: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted AND source_target_flag = g_source_flag;
21486:
21487: ----capture original values
21488: v_repub_remote_pb_id := v_source_pb_record.remote_publication_id;
21621: ,x_msg_count OUT NOCOPY NUMBER
21622: ,x_msg_data OUT NOCOPY VARCHAR2
21623: )
21624: AS
21625: v_server_id cz_model_publications.server_id%TYPE;
21626: v_cz_link_name cz_servers.cz_link_name%TYPE;
21627: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21628: v_app_id_tbl cz_pb_mgr.t_ref;
21629: v_usg_id_tbl cz_pb_mgr.t_ref;
21623: )
21624: AS
21625: v_server_id cz_model_publications.server_id%TYPE;
21626: v_cz_link_name cz_servers.cz_link_name%TYPE;
21627: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21628: v_app_id_tbl cz_pb_mgr.t_ref;
21629: v_usg_id_tbl cz_pb_mgr.t_ref;
21630: v_lang_id_tbl cz_pb_mgr.t_lang_code;
21631: v_object_type cz_model_publications.object_type%TYPE;
21627: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21628: v_app_id_tbl cz_pb_mgr.t_ref;
21629: v_usg_id_tbl cz_pb_mgr.t_ref;
21630: v_lang_id_tbl cz_pb_mgr.t_lang_code;
21631: v_object_type cz_model_publications.object_type%TYPE;
21632: l_status VARCHAR2(3);
21633: l_product_key cz_model_publications.product_key%TYPE;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21629: v_usg_id_tbl cz_pb_mgr.t_ref;
21630: v_lang_id_tbl cz_pb_mgr.t_lang_code;
21631: v_object_type cz_model_publications.object_type%TYPE;
21632: l_status VARCHAR2(3);
21633: l_product_key cz_model_publications.product_key%TYPE;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21636: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
21637: l_publication_mode cz_model_publications.publication_mode%TYPE;
21630: v_lang_id_tbl cz_pb_mgr.t_lang_code;
21631: v_object_type cz_model_publications.object_type%TYPE;
21632: l_status VARCHAR2(3);
21633: l_product_key cz_model_publications.product_key%TYPE;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21636: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
21637: l_publication_mode cz_model_publications.publication_mode%TYPE;
21638: v_export_status cz_model_publications.export_status%TYPE;
21631: v_object_type cz_model_publications.object_type%TYPE;
21632: l_status VARCHAR2(3);
21633: l_product_key cz_model_publications.product_key%TYPE;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21636: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
21637: l_publication_mode cz_model_publications.publication_mode%TYPE;
21638: v_export_status cz_model_publications.export_status%TYPE;
21639: l_publicationidstring VARCHAR2(2000);
21632: l_status VARCHAR2(3);
21633: l_product_key cz_model_publications.product_key%TYPE;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21636: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
21637: l_publication_mode cz_model_publications.publication_mode%TYPE;
21638: v_export_status cz_model_publications.export_status%TYPE;
21639: l_publicationidstring VARCHAR2(2000);
21640: cannot_enable_template EXCEPTION;
21633: l_product_key cz_model_publications.product_key%TYPE;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21636: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
21637: l_publication_mode cz_model_publications.publication_mode%TYPE;
21638: v_export_status cz_model_publications.export_status%TYPE;
21639: l_publicationidstring VARCHAR2(2000);
21640: cannot_enable_template EXCEPTION;
21641: get_params_exception EXCEPTION;
21634: l_applicable_from cz_model_publications.applicable_from%TYPE;
21635: l_applicable_until cz_model_publications.applicable_until%TYPE;
21636: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
21637: l_publication_mode cz_model_publications.publication_mode%TYPE;
21638: v_export_status cz_model_publications.export_status%TYPE;
21639: l_publicationidstring VARCHAR2(2000);
21640: cannot_enable_template EXCEPTION;
21641: get_params_exception EXCEPTION;
21642: pub_overlap EXCEPTION;
21656:
21657: BEGIN
21658: SELECT export_status
21659: INTO v_export_status
21660: FROM cz_model_publications
21661: WHERE cz_model_publications.publication_id = publicationid;
21662: EXCEPTION
21663: WHEN OTHERS
21664: THEN
21657: BEGIN
21658: SELECT export_status
21659: INTO v_export_status
21660: FROM cz_model_publications
21661: WHERE cz_model_publications.publication_id = publicationid;
21662: EXCEPTION
21663: WHEN OTHERS
21664: THEN
21665: v_export_status := NULL;
21673: SELECT object_type, server_id, remote_publication_id, product_key, applicable_from, applicable_until, source_target_flag
21674: ,publication_mode, v_export_status
21675: INTO v_object_type, v_server_id, v_remote_publication_id, l_product_key, l_applicable_from, l_applicable_until, l_source_target_flag
21676: ,l_publication_mode, v_export_status
21677: FROM cz_model_publications
21678: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.disabled_flag = '1';
21679:
21680: BEGIN
21681: SELECT fndnam_link_name
21674: ,publication_mode, v_export_status
21675: INTO v_object_type, v_server_id, v_remote_publication_id, l_product_key, l_applicable_from, l_applicable_until, l_source_target_flag
21676: ,l_publication_mode, v_export_status
21677: FROM cz_model_publications
21678: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.disabled_flag = '1';
21679:
21680: BEGIN
21681: SELECT fndnam_link_name
21682: INTO v_cz_link_name
21729: ELSE
21730: v_cz_link_name := '@' || LTRIM(RTRIM(v_cz_link_name));
21731: END IF;
21732:
21733: UPDATE cz_model_publications
21734: SET disabled_flag = '0'
21735: WHERE publication_id = publicationid;
21736:
21737: cz_pb_mgr.remote_publication_id := v_remote_publication_id;
21737: cz_pb_mgr.remote_publication_id := v_remote_publication_id;
21738:
21739: EXECUTE IMMEDIATE 'BEGIN'
21740: || ' '
21741: || 'UPDATE cz_model_publications'
21742: || v_cz_link_name
21743: || ' '
21744: || 'SET disabled_flag = ''0'''
21745: || ' '
21874: ,x_msg_data OUT NOCOPY VARCHAR2
21875: )
21876: IS
21877: l_model_id cz_rp_entries.object_id%TYPE;
21878: l_publication_mode cz_model_publications.publication_mode%TYPE;
21879: l_usg_id cz_publication_usages.usage_id%TYPE;
21880: l_lang_code cz_pb_languages.LANGUAGE%TYPE;
21881: l_start_date DATE;
21882: l_end_date DATE;
21886: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;
21887: v_publicationidstring VARCHAR2(2000);
21888: v_upto_date_status VARCHAR2(2000);
21889: l_ui_style cz_ui_defs.ui_style%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;
21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
21892: l_organization_id cz_devl_projects.organization_id%TYPE;
21893: l_product_key cz_devl_projects.product_key%TYPE;
21894: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
22045: THEN
22046: RAISE pub_overlap;
22047: END IF;
22048:
22049: SELECT cz_model_publications_s.NEXTVAL
22050: INTO v_new_publication_id
22051: FROM DUAL;
22052:
22053: INSERT INTO cz_model_publications
22049: SELECT cz_model_publications_s.NEXTVAL
22050: INTO v_new_publication_id
22051: FROM DUAL;
22052:
22053: INSERT INTO cz_model_publications
22054: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode
22055: ,ui_def_id, ui_style, applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update
22056: ,model_last_logic_update, model_last_updated, model_persistent_id, source_target_flag, remote_publication_id, object_id
22057: ,object_type, disabled_flag
22220: --The current design for model migration will run
22221: --the publication process for every model that has been selected
22222: --to be migrated. The process of collecting the models is in
22223: --CZ_MODEL_MIGRATION_PVT. Once the models are collected there, for every
22224: --CZ_MODEL_PUBLICATIONS record, publish model is called. Given that,
22225: --this procedure gets the model for the current migration cz_model_publication
22226: --record.
22227:
22228: FUNCTION get_rootmodel_and_mig_tgt_fldr(p_publication_id NUMBER)
22234: --we load the global variable
22235: --holding the value of migration target folder
22236: SELECT migration_group_id, migration_tgt_folder
22237: INTO cz_pb_mgr.g_migration_group_id, cz_pb_mgr.g_migration_tgt_folder_id
22238: FROM cz_model_publications
22239: WHERE publication_id = p_publication_id;
22240:
22241: --get the model corresponding to this publication
22242: SELECT object_id
22240:
22241: --get the model corresponding to this publication
22242: SELECT object_id
22243: BULK COLLECT INTO mm_root_model
22244: FROM cz_model_publications
22245: WHERE publication_id = p_publication_id;
22246:
22247: RETURN mm_root_model;
22248: END get_rootmodel_and_mig_tgt_fldr;
23706: * NOT the current child model. So we need to check if the
23707: * CHILD was transfered before during migration.
23708: */
23709: FUNCTION get_mdl_last_xfr_activity(
23710: p_model_id IN cz_model_publications.model_id%TYPE
23711: ,p_server_id IN cz_model_publications.server_id%TYPE
23712:
23713: ) RETURN DATE
23714: AS
23707: * CHILD was transfered before during migration.
23708: */
23709: FUNCTION get_mdl_last_xfr_activity(
23710: p_model_id IN cz_model_publications.model_id%TYPE
23711: ,p_server_id IN cz_model_publications.server_id%TYPE
23712:
23713: ) RETURN DATE
23714: AS
23715: x_last_xfr_activity DATE := NULL;
23725: AND z.server_id = p_server_id
23726: AND z.status = 'OK'
23727: AND z.publication_id IN(
23728: SELECT publication_id
23729: FROM cz_model_publications
23730: WHERE export_status IN('OK', 'PUP')
23731: AND server_id = p_server_id
23732: AND publication_mode = cz_model_migration_pvt.mode_migration));
23733: