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 1003: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq

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

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

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

Line 1013: SELECT cz_model_publications_s.NEXTVAL, publication_id, remote_publication_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
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;

Line 4755: SELECT cz_model_publications_s.NEXTVAL

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 :=

Line 4760: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq

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:

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

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

Line 6874: ,p_server_id IN cz_model_publications.server_id%TYPE

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

Line 8314: AND cz_model_publications.source_target_flag = g_source_flag

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:

Line 8315: AND cz_model_publications.server_id = p_server_id

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

Line 12337: ,x_server_id IN OUT NOCOPY cz_model_publications.server_id%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

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

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

Line 16721: ,v_server_id IN cz_model_publications.server_id%TYPE

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

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

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

Line 16902: SELECT cz_model_publications_s.NEXTVAL

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 :=

Line 16907: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq

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 :=

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

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'

Line 17715: SELECT cz_model_publications_s.NEXTVAL

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;

Line 19774: v_server_id cz_model_publications.server_id%TYPE;

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;

Line 19832: AND cz_model_publications.server_id = v_server_id

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

Line 19976: v_server_id cz_model_publications.server_id%TYPE;

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;

Line 20078: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%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
20082: BEGIN

Line 20339: v_server_id cz_model_publications.server_id%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;

Line 20340: v_source_target_flag cz_model_publications.source_target_flag%TYPE;

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);

Line 20465: v_server_id cz_model_publications.server_id%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;

Line 20466: v_source_target_flag cz_model_publications.source_target_flag%TYPE;

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);

Line 20583: v_server_id cz_model_publications.server_id%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;

Line 20584: v_source_target_flag cz_model_publications.source_target_flag%TYPE;

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);

Line 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

Line 21225: SELECT cz_model_publications_s.NEXTVAL, p_publication_id

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

Line 21333: v_server_id cz_model_publications.server_id%TYPE;

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

Line 21625: v_server_id cz_model_publications.server_id%TYPE;

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;

Line 21636: l_source_target_flag cz_model_publications.source_target_flag%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);
21640: cannot_enable_template EXCEPTION;

Line 22049: SELECT cz_model_publications_s.NEXTVAL

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

Line 23711: ,p_server_id IN cz_model_publications.server_id%TYPE

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;