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_CF_API dependencies on CZ_CONFIG_HDRS

Line 133: SELECT cz_config_hdrs_s.NEXTVAL

129: BEGIN
130: IF ( (last_hdr_allocated IS NULL)
131: OR
132: (next_hdr_to_use = (NVL(last_hdr_allocated, 0) + id_increment)) ) THEN
133: SELECT cz_config_hdrs_s.NEXTVAL
134: INTO last_hdr_allocated
135: FROM dual;
136: next_hdr_to_use := last_hdr_allocated;
137: END IF;

Line 279: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;

275: Return_value IN OUT NOCOPY NUMBER)
276: IS
277: in_config_hdr_id NUMBER := config_hdr_id;
278: in_config_rev_nbr NUMBER := config_rev_nbr;
279: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
280: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
281: l_instance_hdr_id_tbl number_tbl_indexby_type;
282: l_instance_rev_nbr_tbl number_tbl_indexby_type;
283: l_run_id NUMBER;

Line 280: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

276: IS
277: in_config_hdr_id NUMBER := config_hdr_id;
278: in_config_rev_nbr NUMBER := config_rev_nbr;
279: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
280: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
281: l_instance_hdr_id_tbl number_tbl_indexby_type;
282: l_instance_rev_nbr_tbl number_tbl_indexby_type;
283: l_run_id NUMBER;
284: l_ndebug NUMBER := 0;

Line 293: TYPE instype_tbl_type IS TABLE OF cz_config_hdrs.component_instance_type%TYPE INDEX BY PLS_INTEGER;

289: l_number_of_active_instances NUMBER;
290: l_return_revision NUMBER;
291: l_ib_error NUMBER;
292:
293: TYPE instype_tbl_type IS TABLE OF cz_config_hdrs.component_instance_type%TYPE INDEX BY PLS_INTEGER;
294: l_instance_type_tbl instype_tbl_type;
295:
296: BEGIN
297: Return_value:=1;

Line 311: FROM cz_config_hdrs

307: -- i.e., component_instance_type must be 'R'
308: BEGIN
309: SELECT model_instantiation_type, component_instance_type
310: INTO l_model_instantiation_type, l_component_instance_type
311: FROM cz_config_hdrs
312: WHERE config_hdr_id = in_config_hdr_id AND config_rev_nbr = in_config_rev_nbr;
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN
315: RETURN;

Line 419: DELETE FROM CZ_CONFIG_HDRS

415:
416: l_instance_hdr_id_tbl(l_instance_hdr_id_tbl.COUNT+1) := in_config_hdr_id;
417: l_instance_rev_nbr_tbl(l_instance_rev_nbr_tbl.COUNT+1) := in_config_rev_nbr;
418: FORALL i IN l_instance_hdr_id_tbl.FIRST .. l_instance_hdr_id_tbl.LAST
419: DELETE FROM CZ_CONFIG_HDRS
420: WHERE CONFIG_HDR_ID = l_instance_hdr_id_tbl(i)
421: AND CONFIG_REV_NBR = l_instance_rev_nbr_tbl(i);
422:
423: l_ndebug := 7;

Line 435: UPDATE cz_config_hdrs

431: RAISE del_ib_config_exc;
432: END IF;
433: ELSE
434: -- Mark the configuration session as "To Be Deleted" as few config instances are still active
435: UPDATE cz_config_hdrs
436: SET to_be_deleted_flag = '1'
437: WHERE config_hdr_id=in_config_hdr_id and
438: config_rev_nbr = in_config_rev_nbr;
439: END IF;

Line 894: v_header_id cz_config_hdrs.config_hdr_id%TYPE;

890: x_config_messages IN OUT NOCOPY CFG_OUTPUT_PIECES,
891: x_return_status IN OUT NOCOPY VARCHAR2)
892: IS
893:
894: v_header_id cz_config_hdrs.config_hdr_id%TYPE;
895: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
896: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;
897: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
898: l_prev_item cz_config_items.config_item_id%TYPE := 0;

Line 895: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

891: x_return_status IN OUT NOCOPY VARCHAR2)
892: IS
893:
894: v_header_id cz_config_hdrs.config_hdr_id%TYPE;
895: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
896: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;
897: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
898: l_prev_item cz_config_items.config_item_id%TYPE := 0;
899: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;

Line 896: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;

892: IS
893:
894: v_header_id cz_config_hdrs.config_hdr_id%TYPE;
895: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
896: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;
897: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
898: l_prev_item cz_config_items.config_item_id%TYPE := 0;
899: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
900: l_prev_qty NUMBER := 0;

Line 897: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;

893:
894: v_header_id cz_config_hdrs.config_hdr_id%TYPE;
895: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
896: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;
897: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
898: l_prev_item cz_config_items.config_item_id%TYPE := 0;
899: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
900: l_prev_qty NUMBER := 0;
901: l_description mtl_system_items.description%TYPE;

Line 899: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;

895: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
896: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;
897: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
898: l_prev_item cz_config_items.config_item_id%TYPE := 0;
899: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
900: l_prev_qty NUMBER := 0;
901: l_description mtl_system_items.description%TYPE;
902: l_new_item cz_config_items.config_item_id%TYPE:= 0;
903: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;

Line 903: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;

899: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
900: l_prev_qty NUMBER := 0;
901: l_description mtl_system_items.description%TYPE;
902: l_new_item cz_config_items.config_item_id%TYPE:= 0;
903: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;
904: l_new_component_code cz_config_details_v.component_code%TYPE;
905: l_new_qty NUMBER := 0;
906: l_new_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
907: l_new_organization_id mtl_system_items.organization_id%TYPE;

Line 1236: DELETE FROM CZ_CONFIG_HDRS

1232: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1233: END IF;
1234: DELETE FROM CZ_CONFIG_ITEMS
1235: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1236: DELETE FROM CZ_CONFIG_HDRS
1237: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1238: COMMIT;
1239: END delete_bv_records;
1240:

Line 1417: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

1413:
1414: l_url VARCHAR2(32767);
1415: l_validation_type VARCHAR2(1);
1416: l_validation_status INTEGER;
1417: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1418: l_operation_code VARCHAR2(40);
1419: l_rec1_seq INTEGER;
1420: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1421: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

Line 1420: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

1416: l_validation_status INTEGER;
1417: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1418: l_operation_code VARCHAR2(40);
1419: l_rec1_seq INTEGER;
1420: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1421: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1422: l_ext_comp_code cz_config_items.node_identifier%TYPE;
1423: l_item_depth INTEGER;
1424:

Line 1421: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

1417: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1418: l_operation_code VARCHAR2(40);
1419: l_rec1_seq INTEGER;
1420: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1421: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1422: l_ext_comp_code cz_config_items.node_identifier%TYPE;
1423: l_item_depth INTEGER;
1424:
1425: l_upd_item_map NUMBER_TBL_INDEXBY_CHAR_TYPE;

Line 1518: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id

1514: l_has_attr := p_config_ext_attr_tbl IS NOT NULL AND p_config_ext_attr_tbl.COUNT > 0;
1515: IF l_has_item OR l_has_attr THEN
1516: -- create pseudo hdr rec
1517: l_pseudo_hdr_id := next_config_hdr_id;
1518: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id
1519: ,config_rev_nbr
1520: ,name
1521: ,effective_usage_id
1522: ,component_instance_type

Line 2013: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id

2009:
2010: IF config_input_list.COUNT > 0 THEN
2011: BEGIN
2012: l_pseudo_hdr_id := next_config_hdr_id;
2013: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id
2014: ,config_rev_nbr
2015: ,name
2016: ,effective_usage_id
2017: ,deleted_flag

Line 2954: v_model_identifier cz_config_hdrs.model_identifier%TYPE;

2950: v_inventory_item_id NUMBER;
2951: v_organization_id NUMBER;
2952: v_product_key cz_devl_projects.product_key%TYPE;
2953: v_component_id NUMBER;
2954: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
2955: v_ndebug NUMBER := 0;
2956:
2957: BEGIN
2958: BEGIN

Line 2961: FROM CZ_CONFIG_HDRS

2957: BEGIN
2958: BEGIN
2959: SELECT component_id, model_identifier
2960: INTO v_component_id, v_model_identifier
2961: FROM CZ_CONFIG_HDRS
2962: WHERE config_hdr_id = v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr;
2963: EXCEPTION
2964: WHEN NO_DATA_FOUND THEN
2965: RETURN NULL;

Line 2980: -- a. Look for model corresponding to cz_config_hdrs.component_id. If it exists, find

2976: -- is a publication. If the model is a non-BOM or a mixed model in which the root is non
2977: -- BOM orig_sys_ref will be NULL. In the customer case of bug 2475218, a BOM reference
2978: -- was added to a copy of the original non-bom model. The fix for bug 2475218 was:
2979: -- New logic if the root ps node orig_sys_ref lookup fails:
2980: -- a. Look for model corresponding to cz_config_hdrs.component_id. If it exists, find
2981: -- its BOM model.
2982: -- b. If a. fails, iterate over all projects that have persistent_project_id equal to
2983: -- the config's persistent_component_id. Iterate until a root BOM model is found.
2984:

Line 3230: l_config_effective_date FROM CZ_CONFIG_HDRS WHERE config_hdr_id =

3226: END IF;
3227:
3228: BEGIN
3229: SELECT creation_date, effective_date INTO l_config_creation_date,
3230: l_config_effective_date FROM CZ_CONFIG_HDRS WHERE config_hdr_id =
3231: p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr;
3232: EXCEPTION
3233: WHEN NO_DATA_FOUND THEN
3234: -- just set l_config_creation_date and l_config_effective_date