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_EFFECTIVITY_SETS

Line 7876: FROM cz_effectivity_sets

7872: IS
7873: BEGIN
7874: SELECT MAX(last_update_date)
7875: INTO x_last_update_date
7876: FROM cz_effectivity_sets
7877: WHERE cz_effectivity_sets.effectivity_set_id IN(
7878: SELECT DISTINCT effectivity_set_id
7879: FROM cz_ps_nodes
7880: WHERE cz_ps_nodes.devl_project_id = p_model_id

Line 7877: WHERE cz_effectivity_sets.effectivity_set_id IN(

7873: BEGIN
7874: SELECT MAX(last_update_date)
7875: INTO x_last_update_date
7876: FROM cz_effectivity_sets
7877: WHERE cz_effectivity_sets.effectivity_set_id IN(
7878: SELECT DISTINCT effectivity_set_id
7879: FROM cz_ps_nodes
7880: WHERE cz_ps_nodes.devl_project_id = p_model_id
7881: AND cz_ps_nodes.deleted_flag = record_not_deleted

Line 7893: v_update_date cz_effectivity_sets.last_update_date%TYPE;

7889: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7890: ------get last update date for effectivity
7891: PROCEDURE get_eff_date(p_model_array IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
7892: AS
7893: v_update_date cz_effectivity_sets.last_update_date%TYPE;
7894: BEGIN
7895: IF (p_model_array.COUNT > 0)
7896: THEN
7897: x_max_update_date := cz_utils.epoch_begin;

Line 9594: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_effectivity_sets_seq

9590: check_all_null := FALSE;
9591: v_cz_eff_sets_old_ref.DELETE;
9592: v_cz_eff_sets_new_ref.DELETE;
9593:
9594: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_effectivity_sets_seq
9595: , 'cz_effectivity_sets_s.nextval' || cz_pb_mgr.v_db_link
9596: ,cz_pb_mgr.v_oraclesequenceincr
9597: )
9598: ,effectivity_set_id

Line 9595: , 'cz_effectivity_sets_s.nextval' || cz_pb_mgr.v_db_link

9591: v_cz_eff_sets_old_ref.DELETE;
9592: v_cz_eff_sets_new_ref.DELETE;
9593:
9594: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_effectivity_sets_seq
9595: , 'cz_effectivity_sets_s.nextval' || cz_pb_mgr.v_db_link
9596: ,cz_pb_mgr.v_oraclesequenceincr
9597: )
9598: ,effectivity_set_id
9599: BULK COLLECT INTO v_cz_eff_sets_new_ref

Line 9601: FROM cz_effectivity_sets

9597: )
9598: ,effectivity_set_id
9599: BULK COLLECT INTO v_cz_eff_sets_new_ref
9600: ,v_cz_eff_sets_old_ref
9601: FROM cz_effectivity_sets
9602: WHERE cz_effectivity_sets.effectivity_set_id = p_eff_set_id_ref(p) AND cz_effectivity_sets.deleted_flag = '0';
9603: EXCEPTION
9604: WHEN NO_DATA_FOUND
9605: THEN

Line 9602: WHERE cz_effectivity_sets.effectivity_set_id = p_eff_set_id_ref(p) AND cz_effectivity_sets.deleted_flag = '0';

9598: ,effectivity_set_id
9599: BULK COLLECT INTO v_cz_eff_sets_new_ref
9600: ,v_cz_eff_sets_old_ref
9601: FROM cz_effectivity_sets
9602: WHERE cz_effectivity_sets.effectivity_set_id = p_eff_set_id_ref(p) AND cz_effectivity_sets.deleted_flag = '0';
9603: EXCEPTION
9604: WHEN NO_DATA_FOUND
9605: THEN
9606: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);

Line 9610: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_effectivity_sets', 'SQLERRM', SQLERRM);

9606: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
9607: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EFFSETS', SQLCODE);
9608: WHEN OTHERS
9609: THEN
9610: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_effectivity_sets', 'SQLERRM', SQLERRM);
9611: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTEFFSETS', SQLCODE);
9612: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9613: END;
9614:

Line 9651: ------------------insert into cz effectivity sets

9647: END IF;
9648: END IF;
9649: END LOOP;
9650:
9651: ------------------insert into cz effectivity sets
9652: plsql_table_list.DELETE;
9653: rec_count := 1;
9654: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
9655: plsql_table_list(rec_count).table_name := p_new_key_name;

Line 9660: insert_into_table('cz_effectivity_sets'

9656:
9657: IF (NOT check_all_null)
9658: THEN
9659: BEGIN
9660: insert_into_table('cz_effectivity_sets'
9661: ,'effectivity_set_id'
9662: ,cz_pb_mgr.v_db_link
9663: ,plsql_table_list
9664: ,p_old_key_name

Line 22910: 'cz_effectivity_sets s' || ' ' ||

22906: ELSIF(what_exists = 'EFF_SETS')
22907: THEN
22908: l_sql_str :=
22909: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || 't' || ',' ||
22910: 'cz_effectivity_sets s' || ' ' ||
22911: 'WHERE t.object_type = ''EFF'' AND t.NAME = s.NAME' || ' ' ||
22912: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
22913: 'AND s.effectivity_set_id = :1';
22914: l_sync_msg_object_type_tkn := cz_effset_caption;