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 385: SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;

381: l_input_id_tbl t_local_number_tbl;
382:
383: BEGIN
384:
385: SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;
386:
387: FOR i IN 1..p_inst_hdr_id_tbl.COUNT LOOP
388:
389: IF(p_inst_hdr_id_tbl(i).inventory_item_id = p_inventory_id)THEN

Line 396: INSERT INTO cz_config_hdrs ( config_hdr_id

392: l_input_id_tbl(l_inst_header_id_tbl.COUNT) := l_inst_header_id_tbl.COUNT;
393: END IF;
394: END LOOP;
395:
396: INSERT INTO cz_config_hdrs ( config_hdr_id
397: , config_rev_nbr
398: , name
399: , desc_text
400: , effective_usage_id

Line 473: DELETE FROM cz_config_hdrs WHERE config_hdr_id = p_dummy_hdr_id

469:
470: DELETE FROM cz_config_contents_v WHERE config_hdr_id = p_dummy_hdr_id
471: AND config_rev_nbr = 1;
472:
473: DELETE FROM cz_config_hdrs WHERE config_hdr_id = p_dummy_hdr_id
474: AND config_rev_nbr = 1;
475: END IF;
476: END delete_dummy_config;
477:

Line 933: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

929: PRAGMA AUTONOMOUS_TRANSACTION;
930:
931: l_api_name CONSTANT VARCHAR2(30) := 'generate_config_trees';
932: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 934: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

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

Line 935: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

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

Line 936: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

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

Line 1413: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

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

Line 1414: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

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

Line 1420: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

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

Line 1421: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%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:
1423: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1424: l_con_config_tbl container_config_tbl_type;
1425:

Line 2099: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;

2095: IS
2096: l_api_version CONSTANT NUMBER := 1.0;
2097: l_api_name CONSTANT VARCHAR2(30) := 'is_rma_allowed';
2098:
2099: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
2100: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
2101:
2102: BEGIN
2103: IF (NOT FND_API.compatible_api_call(l_api_version

Line 2100: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

2096: l_api_version CONSTANT NUMBER := 1.0;
2097: l_api_name CONSTANT VARCHAR2(30) := 'is_rma_allowed';
2098:
2099: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
2100: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
2101:
2102: BEGIN
2103: IF (NOT FND_API.compatible_api_call(l_api_version
2104: ,p_api_version