eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PB_MGR dependencies on CZ_PB_MODEL_EXPORTS

Line 7250: DELETE FROM cz_pb_model_exports

7246:
7247: delete_from_idx_tables('cz_rule_folders', 'rule_folder_id', cz_pb_mgr.v_cz_folders_id_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref);
7248: delete_from_idx_tables('cz_expression_nodes', 'expr_node_id', cz_pb_mgr.v_cz_enodes_enode_id_old_ref, cz_pb_mgr.v_cz_enodes_enode_id_idx_ref);
7249:
7250: DELETE FROM cz_pb_model_exports
7251: WHERE publication_id = cz_pb_mgr.v_publication_id;
7252:
7253: COMMIT;
7254: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;

Line 7267: -----------procedure updates the status in cz_model_publications and cz_pb_model_exports

7263: RAISE;
7264: END rollback_data;
7265:
7266: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7267: -----------procedure updates the status in cz_model_publications and cz_pb_model_exports
7268: -----------@p_publication_id : source publication id
7269: -----------@p_status : publication status
7270: -----------@p_link : database link name
7271: -----------@p_models_exported : source models that have entries in model exports

Line 7288: UPDATE cz_pb_model_exports t

7284: IF (p_models_exported.COUNT > 0)
7285: THEN
7286: FOR i IN p_models_exported.FIRST .. p_models_exported.LAST
7287: LOOP
7288: UPDATE cz_pb_model_exports t
7289: SET t.status = p_status
7290: WHERE t.model_id = p_models_exported(i) AND t.server_id = cz_pb_mgr.v_server_id AND t.publication_id = p_publication_id;
7291: END LOOP;
7292:

Line 7604: FROM cz_pb_model_exports

7600: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7601: THEN
7602: SELECT last_xfr_activity
7603: INTO x_last_xfr_activity
7604: FROM cz_pb_model_exports
7605: WHERE cz_pb_model_exports.export_id =
7606: (SELECT MAX(export_id)
7607: FROM cz_pb_model_exports z
7608: WHERE z.root_model_id = p_model_id

Line 7605: WHERE cz_pb_model_exports.export_id =

7601: THEN
7602: SELECT last_xfr_activity
7603: INTO x_last_xfr_activity
7604: FROM cz_pb_model_exports
7605: WHERE cz_pb_model_exports.export_id =
7606: (SELECT MAX(export_id)
7607: FROM cz_pb_model_exports z
7608: WHERE z.root_model_id = p_model_id
7609: AND z.server_id = p_server_id

Line 7607: FROM cz_pb_model_exports z

7603: INTO x_last_xfr_activity
7604: FROM cz_pb_model_exports
7605: WHERE cz_pb_model_exports.export_id =
7606: (SELECT MAX(export_id)
7607: FROM cz_pb_model_exports z
7608: WHERE z.root_model_id = p_model_id
7609: AND z.server_id = p_server_id
7610: AND z.status = 'OK'
7611: AND z.publication_id IN(

Line 7621: FROM cz_pb_model_exports

7617: --SPUPPALA bug#7116052 7-AUG-2009
7618: ELSE
7619: SELECT last_xfr_activity
7620: INTO x_last_xfr_activity
7621: FROM cz_pb_model_exports
7622: WHERE cz_pb_model_exports.export_id =
7623: (SELECT MAX(export_id)
7624: FROM cz_pb_model_exports z
7625: WHERE z.root_model_id = p_model_id

Line 7622: WHERE cz_pb_model_exports.export_id =

7618: ELSE
7619: SELECT last_xfr_activity
7620: INTO x_last_xfr_activity
7621: FROM cz_pb_model_exports
7622: WHERE cz_pb_model_exports.export_id =
7623: (SELECT MAX(export_id)
7624: FROM cz_pb_model_exports z
7625: WHERE z.root_model_id = p_model_id
7626: AND z.server_id = p_server_id

Line 7624: FROM cz_pb_model_exports z

7620: INTO x_last_xfr_activity
7621: FROM cz_pb_model_exports
7622: WHERE cz_pb_model_exports.export_id =
7623: (SELECT MAX(export_id)
7624: FROM cz_pb_model_exports z
7625: WHERE z.root_model_id = p_model_id
7626: AND z.server_id = p_server_id
7627: AND z.status = 'OK'
7628: AND z.publication_id IN(

Line 9385: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;

9381: record_count PLS_INTEGER := 0;
9382: v_last_update_date cz_ui_defs.last_update_date%TYPE;
9383: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;
9384: v_eff_update_date DATE;
9385: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
9386: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;
9387: l_capt_update_date DATE;
9388: l_ps_node_update_date DATE;
9389: v_descr_date DATE;

Line 9386: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;

9382: v_last_update_date cz_ui_defs.last_update_date%TYPE;
9383: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;
9384: v_eff_update_date DATE;
9385: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
9386: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;
9387: l_capt_update_date DATE;
9388: l_ps_node_update_date DATE;
9389: v_descr_date DATE;
9390: BEGIN

Line 9793: ,p_model_id IN cz_pb_model_exports.model_id%TYPE

9789: ------@p_model_id --- source model id
9790: ------@x_remote_model_id -- retrieved remote model id
9791: PROCEDURE get_remote_model_id(
9792: p_server_id IN cz_servers.server_local_id%TYPE
9793: ,p_model_id IN cz_pb_model_exports.model_id%TYPE
9794: ,x_status IN OUT NOCOPY VARCHAR2
9795: ,x_remote_model_id IN OUT NOCOPY cz_pb_model_exports.model_id%TYPE
9796: )
9797: AS

Line 9795: ,x_remote_model_id IN OUT NOCOPY cz_pb_model_exports.model_id%TYPE

9791: PROCEDURE get_remote_model_id(
9792: p_server_id IN cz_servers.server_local_id%TYPE
9793: ,p_model_id IN cz_pb_model_exports.model_id%TYPE
9794: ,x_status IN OUT NOCOPY VARCHAR2
9795: ,x_remote_model_id IN OUT NOCOPY cz_pb_model_exports.model_id%TYPE
9796: )
9797: AS
9798: BEGIN
9799: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN

Line 9806: FROM cz_pb_model_exports

9802: ELSE
9803: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9804: IF p_server_id=0 THEN
9805: SELECT remote_model_id INTO x_remote_model_id
9806: FROM cz_pb_model_exports
9807: WHERE export_id=(SELECT max(export_id)
9808: FROM cz_pb_model_exports
9809: WHERE model_id=p_model_id AND server_id=0
9810: AND status='OK' AND migration_group_id=g_migration_group_id);

Line 9808: FROM cz_pb_model_exports

9804: IF p_server_id=0 THEN
9805: SELECT remote_model_id INTO x_remote_model_id
9806: FROM cz_pb_model_exports
9807: WHERE export_id=(SELECT max(export_id)
9808: FROM cz_pb_model_exports
9809: WHERE model_id=p_model_id AND server_id=0
9810: AND status='OK' AND migration_group_id=g_migration_group_id);
9811: ELSE
9812: EXECUTE IMMEDIATE 'SELECT remote_model_id '

Line 9814: || 'FROM cz_pb_model_exports'

9810: AND status='OK' AND migration_group_id=g_migration_group_id);
9811: ELSE
9812: EXECUTE IMMEDIATE 'SELECT remote_model_id '
9813: || ' '
9814: || 'FROM cz_pb_model_exports'
9815: || ' '
9816: || 'WHERE cz_pb_model_exports.server_id = :1'
9817: || ' '
9818: || 'AND cz_pb_model_exports.export_id = '

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

9812: EXECUTE IMMEDIATE 'SELECT remote_model_id '
9813: || ' '
9814: || 'FROM cz_pb_model_exports'
9815: || ' '
9816: || 'WHERE cz_pb_model_exports.server_id = :1'
9817: || ' '
9818: || 'AND cz_pb_model_exports.export_id = '
9819: || ' '
9820: || '(SELECT MIN(export_id)'

Line 9818: || 'AND cz_pb_model_exports.export_id = '

9814: || 'FROM cz_pb_model_exports'
9815: || ' '
9816: || 'WHERE cz_pb_model_exports.server_id = :1'
9817: || ' '
9818: || 'AND cz_pb_model_exports.export_id = '
9819: || ' '
9820: || '(SELECT MIN(export_id)'
9821: || ' '
9822: || 'FROM cz_pb_model_exports x, cz_devl_projects'

Line 9822: || 'FROM cz_pb_model_exports x, cz_devl_projects'

9818: || 'AND cz_pb_model_exports.export_id = '
9819: || ' '
9820: || '(SELECT MIN(export_id)'
9821: || ' '
9822: || 'FROM cz_pb_model_exports x, cz_devl_projects'
9823: || cz_pb_mgr.v_db_link
9824: || ' farprj'
9825: || ' '
9826: || 'WHERE x.server_id = :2'

Line 9840: || 'AND cz_pb_model_exports.model_id = :5'

9836: || 'AND farprj.post_migr_change_flag = :4'
9837: || ' '
9838: || 'AND x.migration_group_id IS NOT NULL)'
9839: || ' '
9840: || 'AND cz_pb_model_exports.model_id = :5'
9841: || ' '
9842: || 'AND cz_pb_model_exports.status = ''OK'''
9843: INTO x_remote_model_id
9844: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;

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

9838: || 'AND x.migration_group_id IS NOT NULL)'
9839: || ' '
9840: || 'AND cz_pb_model_exports.model_id = :5'
9841: || ' '
9842: || 'AND cz_pb_model_exports.status = ''OK'''
9843: INTO x_remote_model_id
9844: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;
9845: END IF;
9846: ELSE

Line 9847: SELECT cz_pb_model_exports.remote_model_id

9843: INTO x_remote_model_id
9844: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;
9845: END IF;
9846: ELSE
9847: SELECT cz_pb_model_exports.remote_model_id
9848: INTO x_remote_model_id
9849: FROM cz_pb_model_exports
9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =

Line 9849: FROM cz_pb_model_exports

9845: END IF;
9846: ELSE
9847: SELECT cz_pb_model_exports.remote_model_id
9848: INTO x_remote_model_id
9849: FROM cz_pb_model_exports
9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports

Line 9850: WHERE cz_pb_model_exports.server_id = p_server_id

9846: ELSE
9847: SELECT cz_pb_model_exports.remote_model_id
9848: INTO x_remote_model_id
9849: FROM cz_pb_model_exports
9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id

Line 9851: AND cz_pb_model_exports.export_id =

9847: SELECT cz_pb_model_exports.remote_model_id
9848: INTO x_remote_model_id
9849: FROM cz_pb_model_exports
9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id

Line 9853: FROM cz_pb_model_exports

9849: FROM cz_pb_model_exports
9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)

Line 9854: WHERE cz_pb_model_exports.server_id = p_server_id

9850: WHERE cz_pb_model_exports.server_id = p_server_id
9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id

Line 9855: AND cz_pb_model_exports.model_id = p_model_id

9851: AND cz_pb_model_exports.export_id =
9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';

Line 9856: AND cz_pb_model_exports.status = 'OK'

9852: (SELECT MAX(export_id)
9853: FROM cz_pb_model_exports
9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';
9860: END IF;

Line 9858: AND cz_pb_model_exports.model_id = p_model_id

9854: WHERE cz_pb_model_exports.server_id = p_server_id
9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';
9860: END IF;
9861:
9862: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id) := x_remote_model_id;

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

9855: AND cz_pb_model_exports.model_id = p_model_id
9856: AND cz_pb_model_exports.status = 'OK'
9857: AND migration_group_id IS NULL)
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';
9860: END IF;
9861:
9862: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id) := x_remote_model_id;
9863: END IF;

Line 9903: l_remote_model cz_pb_model_exports.model_id%TYPE;

9899: l_max_arc_date DATE;
9900: l_max_ui_date DATE;
9901: l_ps_node_update_date DATE;
9902: l_remote_model_cur ref_cursor;
9903: l_remote_model cz_pb_model_exports.model_id%TYPE;
9904: l_remote_proj cz_pb_model_exports.model_id%TYPE;
9905: l_remote_name VARCHAR2(32000);
9906: child_model_ui_has_changed BOOLEAN := FALSE;
9907: BEGIN

Line 9904: l_remote_proj cz_pb_model_exports.model_id%TYPE;

9900: l_max_ui_date DATE;
9901: l_ps_node_update_date DATE;
9902: l_remote_model_cur ref_cursor;
9903: l_remote_model cz_pb_model_exports.model_id%TYPE;
9904: l_remote_proj cz_pb_model_exports.model_id%TYPE;
9905: l_remote_name VARCHAR2(32000);
9906: child_model_ui_has_changed BOOLEAN := FALSE;
9907: BEGIN
9908: cz_pb_mgr.v_models_to_be_exported.DELETE;

Line 9950: FROM cz_pb_model_exports

9946:
9947: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
9948: IF cz_pb_mgr.v_server_id = 0 THEN
9949: SELECT COUNT(*) INTO v_count
9950: FROM cz_pb_model_exports
9951: WHERE model_id=v_model_id AND status=publication_ok AND server_id=0
9952: AND migration_group_id=g_migration_group_id;
9953: ELSE
9954: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_pb_model_exports x, cz_devl_projects'

Line 9954: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_pb_model_exports x, cz_devl_projects'

9950: FROM cz_pb_model_exports
9951: WHERE model_id=v_model_id AND status=publication_ok AND server_id=0
9952: AND migration_group_id=g_migration_group_id;
9953: ELSE
9954: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_pb_model_exports x, cz_devl_projects'
9955: || cz_pb_mgr.v_db_link
9956: || ' farprj'
9957: || ' '
9958: || 'WHERE x.model_id = :1'

Line 9977: FROM cz_pb_model_exports x

9973: END IF;
9974: ELSE
9975: SELECT COUNT(*)
9976: INTO v_count
9977: FROM cz_pb_model_exports x
9978: WHERE x.model_id = v_model_id AND x.status = publication_ok AND x.server_id = cz_pb_mgr.v_server_id
9979: AND migration_group_id IS NULL;
9980: END IF;
9981:

Line 10052: FROM cz_devl_projects x, cz_pb_model_exports y

10048:
10049: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
10050: IF cz_pb_mgr.v_server_id = 0 THEN
10051: SELECT COUNT(*) INTO v_count
10052: FROM cz_devl_projects x, cz_pb_model_exports y
10053: WHERE x.devl_project_id = y.model_id
10054: AND x.last_update_date < y.last_xfr_activity
10055: AND y.last_xfr_activity > v_expr_last_update
10056: AND y.model_id = v_model_id AND y.server_id = 0

Line 10059: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_devl_projects x, cz_pb_model_exports y, cz_devl_projects'

10055: AND y.last_xfr_activity > v_expr_last_update
10056: AND y.model_id = v_model_id AND y.server_id = 0
10057: AND y.status = 'OK' AND y.migration_group_id = g_migration_group_id;
10058: ELSE
10059: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_devl_projects x, cz_pb_model_exports y, cz_devl_projects'
10060: || cz_pb_mgr.v_db_link
10061: || ' farprj'
10062: || ' '
10063: || 'WHERE x.devl_project_id = y.model_id'

Line 10086: FROM cz_devl_projects x, cz_pb_model_exports y

10082: END IF;
10083: ELSE
10084: SELECT COUNT(*)
10085: INTO v_count
10086: FROM cz_devl_projects x, cz_pb_model_exports y
10087: WHERE x.devl_project_id = y.model_id
10088: AND x.last_update_date < y.last_xfr_activity
10089: AND y.last_xfr_activity > v_expr_last_update
10090: AND y.model_id = v_model_id

Line 10211: INSERT INTO cz_pb_model_exports

10207: INTO v_node_depth
10208: FROM cz_model_ref_expls
10209: WHERE model_id = rootmodelid AND component_id = modelid AND deleted_flag = '0';
10210:
10211: INSERT INTO cz_pb_model_exports
10212: (export_id, export_seq, model_id, root_model_id, server_id, publication_id, export_reverse_seq
10213: ,superseded_flag, last_xfr_activity, creation_date, last_update_date, created_by, last_updated_by, migration_group_id
10214: )
10215: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)

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

10211: INSERT INTO cz_pb_model_exports
10212: (export_id, export_seq, model_id, root_model_id, server_id, publication_id, export_reverse_seq
10213: ,superseded_flag, last_xfr_activity, creation_date, last_update_date, created_by, last_updated_by, migration_group_id
10214: )
10215: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)
10216: ,'N', SYSDATE, SYSDATE, SYSDATE, 1, 1, cz_pb_mgr.g_migration_group_id
10217: );
10218:
10219: SELECT cz_pb_model_exports_s.CURRVAL

Line 10219: SELECT cz_pb_model_exports_s.CURRVAL

10215: VALUES (cz_pb_model_exports_s.NEXTVAL, cz_pb_model_exports_s.CURRVAL, modelid, rootmodelid, serverid, publicationid, NVL(v_node_depth, 0)
10216: ,'N', SYSDATE, SYSDATE, SYSDATE, 1, 1, cz_pb_mgr.g_migration_group_id
10217: );
10218:
10219: SELECT cz_pb_model_exports_s.CURRVAL
10220: INTO cz_pb_mgr.v_export_id
10221: FROM DUAL;
10222:
10223: COMMIT;

Line 10245: UPDATE cz_pb_model_exports

10241: FOR copyid IN cz_pb_mgr.v_models_not_to_be_exported.FIRST .. cz_pb_mgr.v_models_not_to_be_exported.LAST
10242: LOOP
10243: create_export_request(cz_pb_mgr.v_root_model_id, cz_pb_mgr.v_models_not_to_be_exported(copyid), cz_pb_mgr.v_publication_id, 0);
10244:
10245: UPDATE cz_pb_model_exports
10246: SET remote_model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid)
10247: ,status = publication_ok
10248: WHERE cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id
10249: AND cz_pb_model_exports.model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid);

Line 10248: WHERE cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id

10244:
10245: UPDATE cz_pb_model_exports
10246: SET remote_model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid)
10247: ,status = publication_ok
10248: WHERE cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id
10249: AND cz_pb_model_exports.model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid);
10250: END LOOP;
10251: END IF;
10252:

Line 10249: AND cz_pb_model_exports.model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid);

10245: UPDATE cz_pb_model_exports
10246: SET remote_model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid)
10247: ,status = publication_ok
10248: WHERE cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id
10249: AND cz_pb_model_exports.model_id = cz_pb_mgr.v_models_not_to_be_exported(copyid);
10250: END LOOP;
10251: END IF;
10252:
10253: COMMIT;

Line 12170: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;

12166: v_remote_pers_ui_node_tbl cz_pb_mgr.t_ref;
12167: v_remote_pers_ui_node_ref cz_pb_mgr.t_ref;
12168: ui_def_ref_id_cv ref_cursor;
12169: v_node_ref_proj_id cz_devl_projects.devl_project_id%TYPE;
12170: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;
12171: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
12172: rec_count NUMBER;
12173:
12174: CURSOR l_ui_def_cur (p_ui_def_id NUMBER) IS SELECT name FROM cz_ui_defs b WHERE b.ui_def_id = p_ui_def_id;

Line 12171: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;

12167: v_remote_pers_ui_node_ref cz_pb_mgr.t_ref;
12168: ui_def_ref_id_cv ref_cursor;
12169: v_node_ref_proj_id cz_devl_projects.devl_project_id%TYPE;
12170: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;
12171: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
12172: rec_count NUMBER;
12173:
12174: CURSOR l_ui_def_cur (p_ui_def_id NUMBER) IS SELECT name FROM cz_ui_defs b WHERE b.ui_def_id = p_ui_def_id;
12175: l_ui_def_name cz_ui_defs.name%TYPE;

Line 13293: FROM cz_pb_model_exports

13289: IF (p_new_model_array.COUNT > 0)
13290: THEN
13291: SELECT remote_model_id
13292: INTO x_new_model_id
13293: FROM cz_pb_model_exports
13294: WHERE cz_pb_model_exports.publication_id = p_publication_id
13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
13296: ---AND cz_pb_model_exports.export_reverse_seq = 0
13297: AND cz_pb_model_exports.superseded_flag = 'N';

Line 13294: WHERE cz_pb_model_exports.publication_id = p_publication_id

13290: THEN
13291: SELECT remote_model_id
13292: INTO x_new_model_id
13293: FROM cz_pb_model_exports
13294: WHERE cz_pb_model_exports.publication_id = p_publication_id
13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
13296: ---AND cz_pb_model_exports.export_reverse_seq = 0
13297: AND cz_pb_model_exports.superseded_flag = 'N';
13298: END IF;

Line 13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id

13291: SELECT remote_model_id
13292: INTO x_new_model_id
13293: FROM cz_pb_model_exports
13294: WHERE cz_pb_model_exports.publication_id = p_publication_id
13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
13296: ---AND cz_pb_model_exports.export_reverse_seq = 0
13297: AND cz_pb_model_exports.superseded_flag = 'N';
13298: END IF;
13299:

Line 13296: ---AND cz_pb_model_exports.export_reverse_seq = 0

13292: INTO x_new_model_id
13293: FROM cz_pb_model_exports
13294: WHERE cz_pb_model_exports.publication_id = p_publication_id
13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
13296: ---AND cz_pb_model_exports.export_reverse_seq = 0
13297: AND cz_pb_model_exports.superseded_flag = 'N';
13298: END IF;
13299:
13300: ---the above query has been changed to hold good for circular connectors

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

13293: FROM cz_pb_model_exports
13294: WHERE cz_pb_model_exports.publication_id = p_publication_id
13295: AND cz_pb_model_exports.model_id = cz_pb_model_exports.root_model_id
13296: ---AND cz_pb_model_exports.export_reverse_seq = 0
13297: AND cz_pb_model_exports.superseded_flag = 'N';
13298: END IF;
13299:
13300: ---the above query has been changed to hold good for circular connectors
13301: ---In circular references the root may not have an export rev seq of 0

Line 13302: UPDATE cz_pb_model_exports

13298: END IF;
13299:
13300: ---the above query has been changed to hold good for circular connectors
13301: ---In circular references the root may not have an export rev seq of 0
13302: UPDATE cz_pb_model_exports
13303: SET superseded_flag = 'Y'
13304: WHERE publication_id = p_publication_id AND superseded_flag = 'N';
13305: END IF;
13306: EXCEPTION

Line 13736: 'FROM cz_pb_model_exports WHERE publication_id = ' ||p_old_publication_id|| ')';

13732: --Bug#12653412: SKM**SUN PURGE (Update all the models in cz_devl_projects.published to NULL
13733: --based on the list of models exported (from cz_model_exports.remote_model_id) based on p_new/old_publication_id
13734: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects SET published = NULL ' || ' ' ||
13735: 'WHERE devl_project_id IN (SELECT remote_model_id '|| ' '||
13736: 'FROM cz_pb_model_exports WHERE publication_id = ' ||p_old_publication_id|| ')';
13737:
13738: ------update for republish_model api
13739: IF (cz_pb_mgr.v_republish_model = new_copy_mode)
13740: THEN

Line 18266: FROM cz_pb_model_exports

18262: IS
18263: CURSOR model_cur(rootmodelid NUMBER, serverid NUMBER, pubid NUMBER)
18264: IS
18265: SELECT model_id
18266: FROM cz_pb_model_exports
18267: WHERE root_model_id = rootmodelid AND server_id = serverid AND publication_id = pubid AND superseded_flag = 'N'
18268: ORDER BY export_reverse_seq DESC;
18269:
18270: v_cursor NUMBER;

Line 18927: FROM cz_pb_model_exports

18923:
18924: BEGIN
18925: SELECT remote_model_id
18926: INTO v_object_id
18927: FROM cz_pb_model_exports
18928: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)
18929: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;
18930: EXCEPTION
18931: WHEN OTHERS

Line 18928: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)

18924: BEGIN
18925: SELECT remote_model_id
18926: INTO v_object_id
18927: FROM cz_pb_model_exports
18928: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)
18929: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;
18930: EXCEPTION
18931: WHEN OTHERS
18932: THEN

Line 18929: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;

18925: SELECT remote_model_id
18926: INTO v_object_id
18927: FROM cz_pb_model_exports
18928: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)
18929: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;
18930: EXCEPTION
18931: WHEN OTHERS
18932: THEN
18933: cz_pb_mgr.v_err_message := 'Error in retrieving remote model id : ' || SQLERRM;

Line 19263: DELETE FROM cz_pb_model_exports

19259:
19260: DELETE FROM cz_model_publications
19261: WHERE remote_publication_id = v_pub_id;
19262:
19263: DELETE FROM cz_pb_model_exports
19264: WHERE publication_id = v_pub_id;
19265: END IF;
19266:
19267: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

Line 20307: FROM cz_pb_model_exports

20303:
20304: BEGIN
20305: SELECT remote_model_id
20306: INTO v_object_id
20307: FROM cz_pb_model_exports
20308: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)
20309: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;
20310: EXCEPTION
20311: WHEN OTHERS THEN

Line 20308: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)

20304: BEGIN
20305: SELECT remote_model_id
20306: INTO v_object_id
20307: FROM cz_pb_model_exports
20308: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)
20309: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;
20310: EXCEPTION
20311: WHEN OTHERS THEN
20312: cz_pb_mgr.v_err_message := 'Error in retrieving remote model id : ' || SQLERRM;

Line 20309: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;

20305: SELECT remote_model_id
20306: INTO v_object_id
20307: FROM cz_pb_model_exports
20308: WHERE cz_pb_model_exports.model_id = cz_pb_mgr.v_models_to_be_exported(i)
20309: AND cz_pb_model_exports.publication_id = cz_pb_mgr.v_publication_id;
20310: EXCEPTION
20311: WHEN OTHERS THEN
20312: cz_pb_mgr.v_err_message := 'Error in retrieving remote model id : ' || SQLERRM;
20313: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);

Line 22197: DELETE FROM cz_pb_model_exports

22193: NULL;
22194: END;
22195: END LOOP;
22196:
22197: DELETE FROM cz_pb_model_exports
22198: WHERE publication_id IN(SELECT publication_id
22199: FROM cz_model_publications
22200: WHERE UPPER(export_status) = publication_processing);
22201:

Line 23576: ---------- update remote_model id in the source cz_pb_model_exports

23572:
23573: insert_devl_projects(cz_pb_mgr.v_new_devl_id, cz_pb_mgr.v_models_to_be_exported(i), cz_pb_mgr.v_devl_orig_sys_ref
23574: ,cz_pb_mgr.v_status_code);
23575:
23576: ---------- update remote_model id in the source cz_pb_model_exports
23577: UPDATE cz_pb_model_exports t
23578: SET t.remote_model_id = cz_pb_mgr.v_models_to_be_exported_new(i)
23579: WHERE t.publication_id = cz_pb_mgr.v_publication_id
23580: AND t.server_id = cz_pb_mgr.v_server_id

Line 23577: UPDATE cz_pb_model_exports t

23573: insert_devl_projects(cz_pb_mgr.v_new_devl_id, cz_pb_mgr.v_models_to_be_exported(i), cz_pb_mgr.v_devl_orig_sys_ref
23574: ,cz_pb_mgr.v_status_code);
23575:
23576: ---------- update remote_model id in the source cz_pb_model_exports
23577: UPDATE cz_pb_model_exports t
23578: SET t.remote_model_id = cz_pb_mgr.v_models_to_be_exported_new(i)
23579: WHERE t.publication_id = cz_pb_mgr.v_publication_id
23580: AND t.server_id = cz_pb_mgr.v_server_id
23581: AND t.model_id = cz_pb_mgr.v_models_to_be_exported(i);

Line 25161: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;

25157: FUNCTION has_ui_inany_chld_mdl_changed(rootmodelid IN NUMBER) RETURN boolean IS
25158:
25159: v_models_tbl cz_pb_mgr.t_ref;
25160: v_last_update_date cz_ui_defs.last_update_date%TYPE;
25161: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
25162: curr_model_tbl cz_pb_mgr.t_ref;
25163:
25164: BEGIN
25165: get_source_models(rootmodelid, v_models_tbl);

Line 25231: FROM cz_pb_model_exports

25227: BEGIN
25228:
25229: SELECT last_xfr_activity
25230: INTO x_last_xfr_activity
25231: FROM cz_pb_model_exports
25232: WHERE cz_pb_model_exports.export_id =
25233: (SELECT MAX(export_id)
25234: FROM cz_pb_model_exports z
25235: WHERE z.model_id = p_model_id

Line 25232: WHERE cz_pb_model_exports.export_id =

25228:
25229: SELECT last_xfr_activity
25230: INTO x_last_xfr_activity
25231: FROM cz_pb_model_exports
25232: WHERE cz_pb_model_exports.export_id =
25233: (SELECT MAX(export_id)
25234: FROM cz_pb_model_exports z
25235: WHERE z.model_id = p_model_id
25236: AND z.server_id = p_server_id

Line 25234: FROM cz_pb_model_exports z

25230: INTO x_last_xfr_activity
25231: FROM cz_pb_model_exports
25232: WHERE cz_pb_model_exports.export_id =
25233: (SELECT MAX(export_id)
25234: FROM cz_pb_model_exports z
25235: WHERE z.model_id = p_model_id
25236: AND z.server_id = p_server_id
25237: AND z.status = 'OK'
25238: AND z.publication_id IN(