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_NETWORK_API_PUB dependencies on CZ_CONFIG_ITEMS

Line 261: FROM cz_config_items

257:
258: BEGIN
259: SELECT config_item_id, inventory_item_id, organization_id
260: INTO x_config_item_id, x_inventory_item_id, x_organization_id
261: FROM cz_config_items
262: WHERE config_hdr_id = p_config_hdr_id
263: AND config_rev_nbr = p_config_rev_nbr
264: AND deleted_flag = '0'
265: AND inventory_item_id IS NOT NULL

Line 288: FROM cz_config_items

284: BEGIN
285: ----get container header
286: SELECT config_hdr_id, config_rev_nbr
287: INTO x_container_hdr_id, x_container_rev_nbr
288: FROM cz_config_items
289: WHERE cz_config_items.instance_hdr_id = p_config_hdr_id
290: AND cz_config_items.instance_rev_nbr = p_config_rev_nbr
291: AND cz_config_items.deleted_flag = '0'
292: AND ROWNUM < 2;

Line 289: WHERE cz_config_items.instance_hdr_id = p_config_hdr_id

285: ----get container header
286: SELECT config_hdr_id, config_rev_nbr
287: INTO x_container_hdr_id, x_container_rev_nbr
288: FROM cz_config_items
289: WHERE cz_config_items.instance_hdr_id = p_config_hdr_id
290: AND cz_config_items.instance_rev_nbr = p_config_rev_nbr
291: AND cz_config_items.deleted_flag = '0'
292: AND ROWNUM < 2;
293: EXCEPTION

Line 290: AND cz_config_items.instance_rev_nbr = p_config_rev_nbr

286: SELECT config_hdr_id, config_rev_nbr
287: INTO x_container_hdr_id, x_container_rev_nbr
288: FROM cz_config_items
289: WHERE cz_config_items.instance_hdr_id = p_config_hdr_id
290: AND cz_config_items.instance_rev_nbr = p_config_rev_nbr
291: AND cz_config_items.deleted_flag = '0'
292: AND ROWNUM < 2;
293: EXCEPTION
294: WHEN OTHERS THEN

Line 291: AND cz_config_items.deleted_flag = '0'

287: INTO x_container_hdr_id, x_container_rev_nbr
288: FROM cz_config_items
289: WHERE cz_config_items.instance_hdr_id = p_config_hdr_id
290: AND cz_config_items.instance_rev_nbr = p_config_rev_nbr
291: AND cz_config_items.deleted_flag = '0'
292: AND ROWNUM < 2;
293: EXCEPTION
294: WHEN OTHERS THEN
295: x_container_hdr_id := -1;

Line 358: UPDATE cz_config_items

354: p_config_rev_nbr IN NUMBER)
355: IS
356:
357: BEGIN
358: UPDATE cz_config_items
359: SET config_delta = 0
360: WHERE config_hdr_id = p_config_hdr_id
361: AND config_rev_nbr = p_config_rev_nbr;
362: END reset_config_delta ;

Line 937: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;

933: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
934: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
935: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
936: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
937: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
938: l_organization_id cz_config_items.organization_id%TYPE;
939: l_config_item_id cz_config_items.config_item_id%TYPE;
940: l_model_instantiation_type VARCHAR2(1);
941: l_component_instance_type VARCHAR2(1);

Line 938: l_organization_id cz_config_items.organization_id%TYPE;

934: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
935: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
936: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
937: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
938: l_organization_id cz_config_items.organization_id%TYPE;
939: l_config_item_id cz_config_items.config_item_id%TYPE;
940: l_model_instantiation_type VARCHAR2(1);
941: l_component_instance_type VARCHAR2(1);
942: container_model_tbl container_model_tbl_type;

Line 939: l_config_item_id cz_config_items.config_item_id%TYPE;

935: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
936: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
937: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
938: l_organization_id cz_config_items.organization_id%TYPE;
939: l_config_item_id cz_config_items.config_item_id%TYPE;
940: l_model_instantiation_type VARCHAR2(1);
941: l_component_instance_type VARCHAR2(1);
942: container_model_tbl container_model_tbl_type;
943: container_config_tbl container_config_tbl_type;

Line 1416: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;

1412:
1413: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1414: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1415:
1416: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
1417: l_organization_id cz_config_items.organization_id%TYPE;
1418: l_config_item_id cz_config_items.config_item_id%TYPE;
1419:
1420: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

Line 1417: l_organization_id cz_config_items.organization_id%TYPE;

1413: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1414: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1415:
1416: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
1417: l_organization_id cz_config_items.organization_id%TYPE;
1418: l_config_item_id cz_config_items.config_item_id%TYPE;
1419:
1420: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1421: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

Line 1418: l_config_item_id cz_config_items.config_item_id%TYPE;

1414: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1415:
1416: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
1417: l_organization_id cz_config_items.organization_id%TYPE;
1418: l_config_item_id cz_config_items.config_item_id%TYPE;
1419:
1420: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1421: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1422:

Line 2020: l_component_instance_type cz_config_items.component_instance_type%TYPE;

2016: IS
2017: l_api_version CONSTANT NUMBER := 1.0;
2018: l_api_name CONSTANT VARCHAR2(30) := 'is_configurable';
2019:
2020: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2021:
2022: BEGIN
2023: IF (NOT FND_API.compatible_api_call(l_api_version
2024: ,p_api_version

Line 2033: FROM cz_config_items

2029: END IF;
2030:
2031: BEGIN
2032: SELECT component_instance_type INTO l_component_instance_type
2033: FROM cz_config_items
2034: WHERE config_hdr_id = p_config_hdr_id
2035: AND config_rev_nbr = p_config_rev_nbr
2036: AND config_item_id = p_config_item_id
2037: AND deleted_flag = NO_FLAG;

Line 2167: FROM cz_config_items

2163: IS
2164:
2165: CURSOR config_sub_tree_cur IS
2166: SELECT component_instance_type,config_delta,ext_activated_flag
2167: FROM cz_config_items
2168: WHERE config_hdr_id = p_config_hdr_id
2169: AND config_rev_nbr = p_config_rev_nbr
2170: AND deleted_flag = NO_FLAG
2171: START WITH config_item_id = p_config_item_id

Line 2180: l_component_instance_type cz_config_items.component_instance_type%TYPE;

2176: AND config_hdr_id = p_config_hdr_id
2177: AND config_rev_nbr = p_config_rev_nbr
2178: AND deleted_flag = NO_FLAG;
2179:
2180: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2181: l_config_delta cz_config_items.config_delta%TYPE;
2182: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;
2183:
2184: BEGIN

Line 2181: l_config_delta cz_config_items.config_delta%TYPE;

2177: AND config_rev_nbr = p_config_rev_nbr
2178: AND deleted_flag = NO_FLAG;
2179:
2180: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2181: l_config_delta cz_config_items.config_delta%TYPE;
2182: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;
2183:
2184: BEGIN
2185: x_root_inst_changed := FALSE;

Line 2182: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;

2178: AND deleted_flag = NO_FLAG;
2179:
2180: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2181: l_config_delta cz_config_items.config_delta%TYPE;
2182: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;
2183:
2184: BEGIN
2185: x_root_inst_changed := FALSE;
2186: OPEN config_sub_tree_cur;

Line 2222: FROM cz_config_items

2218: IS
2219:
2220: BEGIN
2221: SELECT config_item_id BULK COLLECT INTO x_child_config_tbl
2222: FROM cz_config_items
2223: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
2224: AND deleted_flag = NO_FLAG
2225: START WITH config_item_id = p_config_item_id
2226: AND config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr

Line 2301: UPDATE cz_config_items

2297: END IF;
2298: END IF;
2299:
2300: l_ext_activated_flag := '1';
2301: UPDATE cz_config_items
2302: SET ext_activated_flag = NO_FLAG
2303: WHERE ext_activated_flag = l_ext_activated_flag
2304: AND config_hdr_id = p_config_hdr_id
2305: AND config_rev_nbr = p_config_rev_nbr

Line 2308: FROM cz_config_items

2304: AND config_hdr_id = p_config_hdr_id
2305: AND config_rev_nbr = p_config_rev_nbr
2306: AND config_item_id IN
2307: (SELECT config_item_id
2308: FROM cz_config_items
2309: WHERE config_hdr_id = p_config_hdr_id
2310: AND config_rev_nbr = p_config_rev_nbr
2311: AND deleted_flag = NO_FLAG
2312: START WITH config_item_id = p_config_item_id

Line 2391: FROM cz_config_items

2387: -- add bit is bit 1, which has a value of 2 when turned on
2388: l_add_bit pls_integer := 2;
2389: BEGIN
2390: SELECT config_delta INTO l_delta
2391: FROM cz_config_items
2392: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
2393: AND config_item_id = p_config_item_id;
2394:
2395: IF to_number(utl_raw.bit_and(to_char(l_delta,l_hex_format), to_char(l_add_bit,l_hex_format))) > 0 THEN