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 8600: FROM cz_effectivity_sets

8596: IS
8597: BEGIN
8598: SELECT MAX(last_update_date)
8599: INTO x_last_update_date
8600: FROM cz_effectivity_sets
8601: WHERE cz_effectivity_sets.effectivity_set_id IN(
8602: SELECT DISTINCT effectivity_set_id
8603: FROM cz_ps_nodes
8604: WHERE cz_ps_nodes.devl_project_id = p_model_id

Line 8601: WHERE cz_effectivity_sets.effectivity_set_id IN(

8597: BEGIN
8598: SELECT MAX(last_update_date)
8599: INTO x_last_update_date
8600: FROM cz_effectivity_sets
8601: WHERE cz_effectivity_sets.effectivity_set_id IN(
8602: SELECT DISTINCT effectivity_set_id
8603: FROM cz_ps_nodes
8604: WHERE cz_ps_nodes.devl_project_id = p_model_id
8605: AND cz_ps_nodes.deleted_flag = record_not_deleted

Line 8617: v_update_date cz_effectivity_sets.last_update_date%TYPE;

8613: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8614: ------get last update date for effectivity
8615: PROCEDURE get_eff_date(p_model_array IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
8616: AS
8617: v_update_date cz_effectivity_sets.last_update_date%TYPE;
8618: BEGIN
8619: IF (p_model_array.COUNT > 0)
8620: THEN
8621: x_max_update_date := cz_utils.epoch_begin;

Line 10350: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_effectivity_sets_seq

10346: check_all_null := FALSE;
10347: v_cz_eff_sets_old_ref.DELETE;
10348: v_cz_eff_sets_new_ref.DELETE;
10349:
10350: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_effectivity_sets_seq
10351: , 'cz_effectivity_sets_s.nextval' || cz_pb_mgr.v_db_link
10352: ,cz_pb_mgr.v_oraclesequenceincr
10353: )
10354: ,effectivity_set_id

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

10347: v_cz_eff_sets_old_ref.DELETE;
10348: v_cz_eff_sets_new_ref.DELETE;
10349:
10350: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_effectivity_sets_seq
10351: , 'cz_effectivity_sets_s.nextval' || cz_pb_mgr.v_db_link
10352: ,cz_pb_mgr.v_oraclesequenceincr
10353: )
10354: ,effectivity_set_id
10355: BULK COLLECT INTO v_cz_eff_sets_new_ref

Line 10357: FROM cz_effectivity_sets

10353: )
10354: ,effectivity_set_id
10355: BULK COLLECT INTO v_cz_eff_sets_new_ref
10356: ,v_cz_eff_sets_old_ref
10357: FROM cz_effectivity_sets
10358: WHERE cz_effectivity_sets.effectivity_set_id = p_eff_set_id_ref(p) AND cz_effectivity_sets.deleted_flag = '0';
10359: EXCEPTION
10360: WHEN NO_DATA_FOUND
10361: THEN

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

10354: ,effectivity_set_id
10355: BULK COLLECT INTO v_cz_eff_sets_new_ref
10356: ,v_cz_eff_sets_old_ref
10357: FROM cz_effectivity_sets
10358: WHERE cz_effectivity_sets.effectivity_set_id = p_eff_set_id_ref(p) AND cz_effectivity_sets.deleted_flag = '0';
10359: EXCEPTION
10360: WHEN NO_DATA_FOUND
10361: THEN
10362: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);

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

10362: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
10363: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EFFSETS', SQLCODE);
10364: WHEN OTHERS
10365: THEN
10366: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_effectivity_sets', 'SQLERRM', SQLERRM);
10367: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTEFFSETS', SQLCODE);
10368: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10369: END;
10370:

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

10403: END IF;
10404: END IF;
10405: END LOOP;
10406:
10407: ------------------insert into cz effectivity sets
10408: plsql_table_list.DELETE;
10409: rec_count := 1;
10410: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
10411: plsql_table_list(rec_count).table_name := p_new_key_name;

Line 10416: insert_into_table('cz_effectivity_sets'

10412:
10413: IF (NOT check_all_null)
10414: THEN
10415: BEGIN
10416: insert_into_table('cz_effectivity_sets'
10417: ,'effectivity_set_id'
10418: ,cz_pb_mgr.v_db_link
10419: ,plsql_table_list
10420: ,p_old_key_name

Line 24363: 'cz_effectivity_sets s' || ' ' ||

24359: ELSIF(what_exists = 'EFF_SETS')
24360: THEN
24361: l_sql_str :=
24362: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || 't' || ',' ||
24363: 'cz_effectivity_sets s' || ' ' ||
24364: 'WHERE t.object_type = ''EFF'' AND t.NAME = s.NAME' || ' ' ||
24365: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
24366: 'AND s.effectivity_set_id = :1';
24367: l_sync_msg_object_type_tkn := cz_effset_caption;