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_MODEL_PUBLICATIONS_S

Line 1261: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq

1257: IF (x_status <> PUBLICATION_ERROR)
1258: THEN
1259: IF (cz_pb_mgr.v_server_id <> 0)
1260: THEN
1261: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
1262: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
1263: ,cz_pb_mgr.v_oraclesequenceincr
1264: )
1265: ,publication_id, remote_publication_id

Line 1262: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

1258: THEN
1259: IF (cz_pb_mgr.v_server_id <> 0)
1260: THEN
1261: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
1262: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
1263: ,cz_pb_mgr.v_oraclesequenceincr
1264: )
1265: ,publication_id, remote_publication_id
1266: INTO x_new_pub_id

Line 1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id

1267: ,x_old_pb_id, x_old_rem_pb_id
1268: FROM cz_model_publications
1269: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1270: ELSE
1271: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_id
1272: INTO x_new_pub_id, x_old_pb_id, x_old_rem_pb_id
1273: FROM cz_model_publications
1274: WHERE cz_model_publications.publication_id = cz_pb_mgr.v_publication_id AND cz_model_publications.deleted_flag = record_not_deleted;
1275: END IF;

Line 5461: SELECT cz_model_publications_s.NEXTVAL

5457: FOR i IN cz_pb_mgr.g_ui_templates_old_temp_id_ref.FIRST .. cz_pb_mgr.g_ui_templates_old_temp_id_ref.LAST
5458: LOOP
5459: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
5460: THEN
5461: SELECT cz_model_publications_s.NEXTVAL
5462: INTO l_src_pb_id
5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=

Line 5466: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq

5462: INTO l_src_pb_id
5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=
5466: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
5468: ,cz_pb_mgr.v_oraclesequenceincr
5469: );
5470:

Line 5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=
5466: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
5468: ,cz_pb_mgr.v_oraclesequenceincr
5469: );
5470:
5471: -- IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN

Line 7595: ,p_server_id IN cz_model_publications.server_id%TYPE

7591: -----@p_server_id : server_id on the publication request
7592: -----x_last_xfr_activity : last published date
7593: PROCEDURE get_last_xfr_activity(
7594: p_model_id IN cz_model_publications.model_id%TYPE
7595: ,p_server_id IN cz_model_publications.server_id%TYPE
7596: ,x_last_xfr_activity IN OUT NOCOPY DATE
7597: )
7598: AS
7599: BEGIN

Line 9039: AND cz_model_publications.source_target_flag = g_source_flag

9035: INTO l_last_update_date
9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9043:

Line 9040: AND cz_model_publications.server_id = p_server_id

9036: FROM cz_model_publications
9037: WHERE cz_model_publications.object_id = p_template_id
9038: AND cz_model_publications.object_type = 'UIT'
9039: AND cz_model_publications.source_target_flag = g_source_flag
9040: AND cz_model_publications.server_id = p_server_id
9041: AND cz_model_publications.export_status IN('OK', 'PUP')
9042: AND cz_model_publications.deleted_flag = '0';
9043:
9044: SELECT last_update_date

Line 13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE

13325: PROCEDURE get_source_pb_info(
13326: p_publication_id IN cz_model_publications.publication_id%TYPE
13327: ,x_model_id IN OUT NOCOPY cz_model_publications.model_id%TYPE
13328: ,x_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
13329: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13330: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
13331: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13332: ,x_object_type IN OUT NOCOPY cz_model_publications.object_type%TYPE
13333: ,x_pb_mode IN OUT NOCOPY cz_model_publications.publication_mode%TYPE

Line 13457: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE

13453: ----------@x_publication_id : retrieved max publication id
13454: ----------@x_status: publication status parameter
13455: PROCEDURE get_max_pub_id(
13456: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13457: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13458: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13459: ,x_status IN OUT NOCOPY VARCHAR2
13460: )
13461: AS

Line 17858: ,v_server_id IN cz_model_publications.server_id%TYPE

17854: -------------- Load data : procedure used to export data
17855: PROCEDURE load_data(
17856: v_publication_id IN cz_model_publications.publication_id%TYPE
17857: ,v_root_model_id IN cz_model_publications.model_id%TYPE
17858: ,v_server_id IN cz_model_publications.server_id%TYPE
17859: ,x_status_code IN OUT NOCOPY cz_model_publications.export_status%TYPE
17860: ,p_copy_nonjradui IN BOOLEAN DEFAULT TRUE
17861: )
17862: AS

Line 18025: 'UPDATE cz_model_publications set deleted_flag = ''1'' WHERE object_id := :1 '

18021: l_new_publication_id NUMBER;
18022: v_inst_str VARCHAR2(2000);
18023: BEGIN
18024: v_inst_str :=
18025: 'UPDATE cz_model_publications set deleted_flag = ''1'' WHERE object_id := :1 '
18026: || ' '
18027: || 'and object_type = :2 and server_id = :3 and source_target_flag = :4';
18028:
18029: EXECUTE IMMEDIATE v_inst_str

Line 18045: SELECT cz_model_publications_s.NEXTVAL

18041: USING p_temp_id, 'UIT', cz_pb_mgr.v_db_link, g_source_flag;
18042:
18043: COMMIT;
18044:
18045: SELECT cz_model_publications_s.NEXTVAL
18046: INTO l_old_publication_id
18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=

Line 18050: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq

18046: INTO l_old_publication_id
18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=
18050: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
18052: ,cz_pb_mgr.v_oraclesequenceincr
18053: );
18054: v_inst_str :=

Line 18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=
18050: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
18052: ,cz_pb_mgr.v_oraclesequenceincr
18053: );
18054: v_inst_str :=
18055: 'INSERT INTO cz_model_publications'

Line 18858: SELECT cz_model_publications_s.NEXTVAL

18854: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18855: ELSE
18856: -----------create a dummy publication
18857: BEGIN
18858: SELECT cz_model_publications_s.NEXTVAL
18859: INTO cz_pb_mgr.v_publication_id
18860: FROM DUAL;
18861:
18862: v_pub_id := cz_pb_mgr.v_publication_id;

Line 20982: v_server_id cz_model_publications.server_id%TYPE;

20978: ,x_msg_count OUT NOCOPY NUMBER
20979: ,x_msg_data OUT NOCOPY VARCHAR2
20980: )
20981: AS
20982: v_server_id cz_model_publications.server_id%TYPE;
20983: v_cz_link_name cz_servers.cz_link_name%TYPE;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;

Line 21040: AND cz_model_publications.server_id = v_server_id

21036: SELECT publication_id
21037: INTO l_reset_publication
21038: FROM cz_model_publications
21039: WHERE cz_model_publications.remote_publication_id = v_remote_publication_id
21040: AND cz_model_publications.server_id = v_server_id
21041: AND cz_model_publications.deleted_flag = record_not_deleted
21042: AND cz_model_publications.export_status = 'PUP';
21043: --SPUPPALA bug#7116052 7-AUG-2009.
21044: --AND cz_model_publications.publication_mode = l_pub_mode;

Line 21185: v_server_id cz_model_publications.server_id%TYPE;

21181: ,x_msg_count OUT NOCOPY NUMBER
21182: ,x_msg_data OUT NOCOPY VARCHAR2
21183: )
21184: AS
21185: v_server_id cz_model_publications.server_id%TYPE;
21186: v_cz_link_name cz_servers.cz_link_name%TYPE;
21187: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21188: v_object_type cz_model_publications.object_type%TYPE;
21189: v_export_status cz_model_publications.export_status%TYPE;

Line 21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE

21283: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
21288: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
21289: )
21290: AS
21291: BEGIN

Line 21548: v_server_id cz_model_publications.server_id%TYPE;

21544: )
21545: AS
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21552: v_count NUMBER;

Line 21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;

21545: AS
21546: v_product_key cz_model_publications.product_key%TYPE;
21547: v_publication_mode cz_model_publications.publication_mode%TYPE;
21548: v_server_id cz_model_publications.server_id%TYPE;
21549: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21550: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21551: v_export_status cz_model_publications.export_status%TYPE;
21552: v_count NUMBER;
21553: v_application_id VARCHAR2(2000);

Line 21674: v_server_id cz_model_publications.server_id%TYPE;

21670: )
21671: AS
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21678: v_count NUMBER;

Line 21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;

21671: AS
21672: v_product_key cz_model_publications.product_key%TYPE;
21673: v_publication_mode cz_model_publications.publication_mode%TYPE;
21674: v_server_id cz_model_publications.server_id%TYPE;
21675: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21676: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21677: v_export_status cz_model_publications.export_status%TYPE;
21678: v_count NUMBER;
21679: v_application_id VARCHAR2(2000);

Line 21792: v_server_id cz_model_publications.server_id%TYPE;

21788: )
21789: AS
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21796: v_count NUMBER;

Line 21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;

21789: AS
21790: v_product_key cz_model_publications.product_key%TYPE;
21791: v_publication_mode cz_model_publications.publication_mode%TYPE;
21792: v_server_id cz_model_publications.server_id%TYPE;
21793: v_source_target_flag cz_model_publications.source_target_flag%TYPE;
21794: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21795: v_export_status cz_model_publications.export_status%TYPE;
21796: v_count NUMBER;
21797: v_application_id VARCHAR2(2000);

Line 22286: SELECT cz_model_publications_s.NEXTVAL, p_publication_id

22282: v_old_publication_id cz_model_publications.publication_id%TYPE;
22283: BEGIN
22284: x_status := 'OK';
22285:
22286: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22287: INTO v_new_publication_id, v_old_publication_id
22288: FROM DUAL;
22289:
22290: INSERT INTO cz_model_publications

Line 22434: SELECT cz_model_publications_s.NEXTVAL, p_publication_id

22430: THEN
22431: RAISE pub_overlap;
22432: END IF;
22433:
22434: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22435: INTO v_new_publication_id, v_old_publication_id
22436: FROM DUAL;
22437:
22438: INSERT INTO cz_model_publications

Line 22542: v_server_id cz_model_publications.server_id%TYPE;

22538: ,x_status IN OUT NOCOPY VARCHAR2
22539: )
22540: AS
22541: v_db_link cz_servers.fndnam_link_name%TYPE;
22542: v_server_id cz_model_publications.server_id%TYPE;
22543: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22544: reset_date_error EXCEPTION;
22545: BEGIN
22546: SELECT applicable_from, applicable_until, server_id, remote_publication_id

Line 22834: v_server_id cz_model_publications.server_id%TYPE;

22830: ,x_msg_count OUT NOCOPY NUMBER
22831: ,x_msg_data OUT NOCOPY VARCHAR2
22832: )
22833: AS
22834: v_server_id cz_model_publications.server_id%TYPE;
22835: v_cz_link_name cz_servers.cz_link_name%TYPE;
22836: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22837: v_app_id_tbl cz_pb_mgr.t_ref;
22838: v_usg_id_tbl cz_pb_mgr.t_ref;

Line 22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;

22841: l_status VARCHAR2(3);
22842: l_product_key cz_model_publications.product_key%TYPE;
22843: l_applicable_from cz_model_publications.applicable_from%TYPE;
22844: l_applicable_until cz_model_publications.applicable_until%TYPE;
22845: l_source_target_flag cz_model_publications.source_target_flag%TYPE;
22846: l_publication_mode cz_model_publications.publication_mode%TYPE;
22847: v_export_status cz_model_publications.export_status%TYPE;
22848: l_publicationidstring VARCHAR2(2000);
22849: cannot_enable_template EXCEPTION;

Line 23258: SELECT cz_model_publications_s.NEXTVAL

23254: THEN
23255: RAISE pub_overlap;
23256: END IF;
23257:
23258: SELECT cz_model_publications_s.NEXTVAL
23259: INTO v_new_publication_id
23260: FROM DUAL;
23261:
23262: INSERT INTO cz_model_publications

Line 25222: ,p_server_id IN cz_model_publications.server_id%TYPE

25218: * CHILD was transfered before during migration.
25219: */
25220: FUNCTION get_mdl_last_xfr_activity(
25221: p_model_id IN cz_model_publications.model_id%TYPE
25222: ,p_server_id IN cz_model_publications.server_id%TYPE
25223:
25224: ) RETURN DATE
25225: AS
25226: x_last_xfr_activity DATE := NULL;