DBA Data[Home] [Help]

APPS.CZ_CX_UTIL_PVT dependencies on CZ_RULES

Line 30: SELECT cz_rules_s.NEXTVAL INTO m_rule_id FROM DUAL;

26: NULL;
27: END;
28: END IF;
29:
30: SELECT cz_rules_s.NEXTVAL INTO m_rule_id FROM DUAL;
31: m_last_rule_id := m_rule_id + m_increment - 1;
32: ELSE
33: m_rule_id := m_rule_id + 1;
34: END IF;

Line 43: -- 1. transform old fc recs to new cx rule data: cz_func_comp_specs => cz_rules

39: --------------------------------------------------------------------------------
40: -- Converting old functional companion data to configurator extension foramt.
41: -- Returns return_status 1 if the conversion process is successful, 0 otherwise.
42: -- The tasks performed here are as follows.
43: -- 1. transform old fc recs to new cx rule data: cz_func_comp_specs => cz_rules
44: -- 2. update cz_rule_folders's id and type: func_comp_id, FNC => rule_id, CXT
45: -- 3. convert old ui fc data to new cx form
46: -- cz_ui_nodes: func_comp_id => cx_command_name
47: -- cz_ui_node_props: old value_str type (5,6) => new value_str type (31,32)

Line 128: INSERT INTO cz_rules(rule_id

124: SET rule_folder_id = l_rule_id, object_type = 'CXT'
125: WHERE rule_folder_id = fc_tbl(j) AND object_type = 'FNC';
126: l_stat := 3.3;
127:
128: INSERT INTO cz_rules(rule_id
129: ,persistent_rule_id
130: ,rule_type
131: ,seq_nbr
132: ,invalid_flag