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 360: UPDATE cz_config_items

356: p_config_rev_nbr IN NUMBER)
357: IS
358:
359: BEGIN
360: UPDATE cz_config_items
361: SET config_delta = 0
362: WHERE config_hdr_id = p_config_hdr_id
363: AND config_rev_nbr = p_config_rev_nbr
364: /* Need to verify */

Line 384: UPDATE cz_config_items

380: l_prof_val := fnd_profile.value('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS');
381:
382: -- if unchanged items not output, only set ext_activated_flag to '1' on instance root
383: -- otherwise set to '1' on all items in trackable instances
384: UPDATE cz_config_items
385: SET line_type = NULL,
386: ext_activated_flag = Decode(l_prof_val, 'N', (Decode (component_instance_type, 'I', '1', '0')), '1')
387: WHERE config_hdr_id = p_config_hdr_id
388: AND config_rev_nbr = p_config_rev_nbr

Line 964: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;

960: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
961: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
962: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
963: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
964: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
965: l_organization_id cz_config_items.organization_id%TYPE;
966: l_config_item_id cz_config_items.config_item_id%TYPE;
967: l_model_instantiation_type VARCHAR2(1);
968: l_component_instance_type VARCHAR2(1);

Line 965: l_organization_id cz_config_items.organization_id%TYPE;

961: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
962: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
963: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
964: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
965: l_organization_id cz_config_items.organization_id%TYPE;
966: l_config_item_id cz_config_items.config_item_id%TYPE;
967: l_model_instantiation_type VARCHAR2(1);
968: l_component_instance_type VARCHAR2(1);
969: container_model_tbl container_model_tbl_type;

Line 966: l_config_item_id cz_config_items.config_item_id%TYPE;

962: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
963: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
964: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
965: l_organization_id cz_config_items.organization_id%TYPE;
966: l_config_item_id cz_config_items.config_item_id%TYPE;
967: l_model_instantiation_type VARCHAR2(1);
968: l_component_instance_type VARCHAR2(1);
969: container_model_tbl container_model_tbl_type;
970: container_config_tbl container_config_tbl_type;

Line 1099: SELECT 1 BULK COLLECT INTO l_instance_number_tbl FROM cz_config_items

1095: RAISE INVALID_CONTAINER_HDR;
1096: END IF;
1097:
1098: --Check the number of instances in the container - the optimization is valid only if there is only one.
1099: SELECT 1 BULK COLLECT INTO l_instance_number_tbl FROM cz_config_items
1100: WHERE component_instance_type = 'I'
1101: AND deleted_flag = '0'
1102: AND config_hdr_id = l_main_config_hdr_id
1103: AND config_rev_nbr = l_main_config_rev_nbr;

Line 1140: AND config_rev_nbr = (SELECT instance_rev_nbr FROM cz_config_items WHERE config_hdr_id =

1136: AND config_rev_nbr = v_config_rev_nbr;
1137:
1138: -- set baseline rev for the new instance header
1139: UPDATE cz_config_hdrs SET baseline_rev_nbr = l_config_rev_nbr WHERE config_hdr_id = l_config_hdr_id
1140: AND config_rev_nbr = (SELECT instance_rev_nbr FROM cz_config_items WHERE config_hdr_id =
1141: v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr AND
1142: component_instance_type = 'I');
1143:
1144: -- need to delete discontinued items

Line 1145: DELETE FROM cz_config_items a WHERE discontinued_flag = '1'

1141: v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr AND
1142: component_instance_type = 'I');
1143:
1144: -- need to delete discontinued items
1145: DELETE FROM cz_config_items a WHERE discontinued_flag = '1'
1146: AND config_hdr_id = v_config_hdr_id
1147: AND config_rev_nbr = v_config_rev_nbr
1148: AND not exists (SELECT 1 from cz_config_items
1149: WHERE parent_config_item_id = a.config_item_id

Line 1148: AND not exists (SELECT 1 from cz_config_items

1144: -- need to delete discontinued items
1145: DELETE FROM cz_config_items a WHERE discontinued_flag = '1'
1146: AND config_hdr_id = v_config_hdr_id
1147: AND config_rev_nbr = v_config_rev_nbr
1148: AND not exists (SELECT 1 from cz_config_items
1149: WHERE parent_config_item_id = a.config_item_id
1150: AND config_hdr_id = v_config_hdr_id
1151: AND config_rev_nbr = v_config_rev_nbr
1152: AND discontinued_flag = '0');

Line 1554: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;

1550:
1551: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1552: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1553:
1554: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
1555: l_organization_id cz_config_items.organization_id%TYPE;
1556: l_config_item_id cz_config_items.config_item_id%TYPE;
1557:
1558: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

Line 1555: l_organization_id cz_config_items.organization_id%TYPE;

1551: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1552: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1553:
1554: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
1555: l_organization_id cz_config_items.organization_id%TYPE;
1556: l_config_item_id cz_config_items.config_item_id%TYPE;
1557:
1558: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1559: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

Line 1556: l_config_item_id cz_config_items.config_item_id%TYPE;

1552: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1553:
1554: l_inventory_item_id cz_config_items.inventory_item_id%TYPE;
1555: l_organization_id cz_config_items.organization_id%TYPE;
1556: l_config_item_id cz_config_items.config_item_id%TYPE;
1557:
1558: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1559: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1560:

Line 2158: l_component_instance_type cz_config_items.component_instance_type%TYPE;

2154: IS
2155: l_api_version CONSTANT NUMBER := 1.0;
2156: l_api_name CONSTANT VARCHAR2(30) := 'is_configurable';
2157:
2158: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2159:
2160: BEGIN
2161: IF (NOT FND_API.compatible_api_call(l_api_version
2162: ,p_api_version

Line 2171: FROM cz_config_items

2167: END IF;
2168:
2169: BEGIN
2170: SELECT component_instance_type INTO l_component_instance_type
2171: FROM cz_config_items
2172: WHERE config_hdr_id = p_config_hdr_id
2173: AND config_rev_nbr = p_config_rev_nbr
2174: AND config_item_id = p_config_item_id
2175: AND deleted_flag = NO_FLAG;

Line 2305: FROM cz_config_items

2301: IS
2302:
2303: CURSOR config_sub_tree_cur IS
2304: SELECT component_instance_type,config_delta,ext_activated_flag
2305: FROM cz_config_items
2306: WHERE config_hdr_id = p_config_hdr_id
2307: AND config_rev_nbr = p_config_rev_nbr
2308: AND deleted_flag = NO_FLAG
2309: START WITH config_item_id = p_config_item_id

Line 2318: l_component_instance_type cz_config_items.component_instance_type%TYPE;

2314: AND config_hdr_id = p_config_hdr_id
2315: AND config_rev_nbr = p_config_rev_nbr
2316: AND deleted_flag = NO_FLAG;
2317:
2318: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2319: l_config_delta cz_config_items.config_delta%TYPE;
2320: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;
2321:
2322: BEGIN

Line 2319: l_config_delta cz_config_items.config_delta%TYPE;

2315: AND config_rev_nbr = p_config_rev_nbr
2316: AND deleted_flag = NO_FLAG;
2317:
2318: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2319: l_config_delta cz_config_items.config_delta%TYPE;
2320: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;
2321:
2322: BEGIN
2323: x_root_inst_changed := FALSE;

Line 2320: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;

2316: AND deleted_flag = NO_FLAG;
2317:
2318: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2319: l_config_delta cz_config_items.config_delta%TYPE;
2320: l_ext_activated_flag cz_config_items.ext_activated_flag%TYPE;
2321:
2322: BEGIN
2323: x_root_inst_changed := FALSE;
2324: OPEN config_sub_tree_cur;

Line 2360: FROM cz_config_items

2356: IS
2357:
2358: BEGIN
2359: SELECT config_item_id BULK COLLECT INTO x_child_config_tbl
2360: FROM cz_config_items
2361: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
2362: AND deleted_flag = NO_FLAG
2363: START WITH config_item_id = p_config_item_id
2364: AND config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr

Line 2439: UPDATE cz_config_items

2435: END IF;
2436: END IF;
2437:
2438: l_ext_activated_flag := '1';
2439: UPDATE cz_config_items
2440: SET ext_activated_flag = NO_FLAG
2441: WHERE ext_activated_flag = l_ext_activated_flag
2442: AND config_hdr_id = p_config_hdr_id
2443: AND config_rev_nbr = p_config_rev_nbr

Line 2446: FROM cz_config_items

2442: AND config_hdr_id = p_config_hdr_id
2443: AND config_rev_nbr = p_config_rev_nbr
2444: AND config_item_id IN
2445: (SELECT config_item_id
2446: FROM cz_config_items
2447: WHERE config_hdr_id = p_config_hdr_id
2448: AND config_rev_nbr = p_config_rev_nbr
2449: AND deleted_flag = NO_FLAG
2450: START WITH config_item_id = p_config_item_id

Line 2529: FROM cz_config_items

2525: -- add bit is bit 1, which has a value of 2 when turned on
2526: l_add_bit pls_integer := 2;
2527: BEGIN
2528: SELECT config_delta INTO l_delta
2529: FROM cz_config_items
2530: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
2531: AND config_item_id = p_config_item_id;
2532:
2533: IF to_number(utl_raw.bit_and(to_char(l_delta,l_hex_format), to_char(l_add_bit,l_hex_format))) > 0 THEN