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_HDRS

Line 239: FROM cz_config_hdrs

235: SELECT model_instantiation_type,
236: component_instance_type
237: INTO x_model_instantiation_type,
238: x_component_instance_type
239: FROM cz_config_hdrs
240: WHERE cz_config_hdrs.config_hdr_id = p_config_hdr_id
241: AND cz_config_hdrs.config_rev_nbr = p_config_rev_nbr;
242: EXCEPTION
243: WHEN OTHERS THEN

Line 240: WHERE cz_config_hdrs.config_hdr_id = p_config_hdr_id

236: component_instance_type
237: INTO x_model_instantiation_type,
238: x_component_instance_type
239: FROM cz_config_hdrs
240: WHERE cz_config_hdrs.config_hdr_id = p_config_hdr_id
241: AND cz_config_hdrs.config_rev_nbr = p_config_rev_nbr;
242: EXCEPTION
243: WHEN OTHERS THEN
244: x_model_instantiation_type := '0';

Line 241: AND cz_config_hdrs.config_rev_nbr = p_config_rev_nbr;

237: INTO x_model_instantiation_type,
238: x_component_instance_type
239: FROM cz_config_hdrs
240: WHERE cz_config_hdrs.config_hdr_id = p_config_hdr_id
241: AND cz_config_hdrs.config_rev_nbr = p_config_rev_nbr;
242: EXCEPTION
243: WHEN OTHERS THEN
244: x_model_instantiation_type := '0';
245: x_component_instance_type := '0';

Line 412: SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;

408: l_input_id_tbl t_local_number_tbl;
409:
410: BEGIN
411:
412: SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;
413:
414: FOR i IN 1..p_inst_hdr_id_tbl.COUNT LOOP
415:
416: IF(p_inst_hdr_id_tbl(i).inventory_item_id = p_inventory_id)THEN

Line 423: INSERT INTO cz_config_hdrs ( config_hdr_id

419: l_input_id_tbl(l_inst_header_id_tbl.COUNT) := l_inst_header_id_tbl.COUNT;
420: END IF;
421: END LOOP;
422:
423: INSERT INTO cz_config_hdrs ( config_hdr_id
424: , config_rev_nbr
425: , name
426: , desc_text
427: , effective_usage_id

Line 500: DELETE FROM cz_config_hdrs WHERE config_hdr_id = p_dummy_hdr_id

496:
497: DELETE FROM cz_config_contents_v WHERE config_hdr_id = p_dummy_hdr_id
498: AND config_rev_nbr = 1;
499:
500: DELETE FROM cz_config_hdrs WHERE config_hdr_id = p_dummy_hdr_id
501: AND config_rev_nbr = 1;
502: END IF;
503: END delete_dummy_config;
504:

Line 960: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

956: PRAGMA AUTONOMOUS_TRANSACTION;
957:
958: l_api_name CONSTANT VARCHAR2(30) := 'generate_config_trees';
959: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 961: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

957:
958: l_api_name CONSTANT VARCHAR2(30) := 'generate_config_trees';
959: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 962: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

958: l_api_name CONSTANT VARCHAR2(30) := 'generate_config_trees';
959: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 963: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

959: l_api_version CONSTANT NUMBER := 1.0;
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);

Line 1135: UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_config_hdr_id

1131: reset_config_delta (v_config_hdr_id, v_config_rev_nbr);
1132: reset_config_flags (v_config_hdr_id, v_config_rev_nbr);
1133:
1134: -- set effective_date of new config to sysdate - bug#8417357
1135: UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_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

Line 1139: UPDATE cz_config_hdrs SET baseline_rev_nbr = l_config_rev_nbr WHERE config_hdr_id = l_config_hdr_id

1135: UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_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:

Line 1551: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

1547:
1548: l_api_name CONSTANT VARCHAR2(30) := 'add_to_config_tree';
1549: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 1552: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

1548: l_api_name CONSTANT VARCHAR2(30) := 'add_to_config_tree';
1549: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 1558: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

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:
1561: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1562: l_con_config_tbl container_config_tbl_type;

Line 1559: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%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:
1561: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1562: l_con_config_tbl container_config_tbl_type;
1563:

Line 2237: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;

2233: IS
2234: l_api_version CONSTANT NUMBER := 1.0;
2235: l_api_name CONSTANT VARCHAR2(30) := 'is_rma_allowed';
2236:
2237: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
2238: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
2239:
2240: BEGIN
2241: IF (NOT FND_API.compatible_api_call(l_api_version

Line 2238: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

2234: l_api_version CONSTANT NUMBER := 1.0;
2235: l_api_name CONSTANT VARCHAR2(30) := 'is_rma_allowed';
2236:
2237: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
2238: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
2239:
2240: BEGIN
2241: IF (NOT FND_API.compatible_api_call(l_api_version
2242: ,p_api_version