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_ITEMS

Line 338: FROM cz_config_items

334: END IF;
335:
336: SELECT instance_hdr_id, instance_rev_nbr, component_instance_type
337: BULK COLLECT INTO l_instance_hdr_id_tbl, l_instance_rev_nbr_tbl, l_instance_type_tbl
338: FROM cz_config_items
339: WHERE config_hdr_id = in_config_hdr_id AND config_rev_nbr = in_config_rev_nbr
340: AND deleted_flag = '0'
341: AND component_instance_type IN (GENERIC_INSTANCE_ROOT, NETWORK_INSTANCE_ROOT);
342:

Line 403: DELETE FROM CZ_CONFIG_ITEMS

399: DELETE FROM CZ_CONFIG_ATTRIBUTES
400: WHERE CONFIG_HDR_ID=in_config_hdr_id
401: AND CONFIG_REV_NBR=in_config_rev_nbr;
402:
403: DELETE FROM CZ_CONFIG_ITEMS
404: WHERE CONFIG_HDR_ID=in_config_hdr_id
405: AND CONFIG_REV_NBR=in_config_rev_nbr;
406:
407: DELETE FROM CZ_CONFIG_INPUTS

Line 677: l_str cz_config_items.node_identifier%TYPE;

673: x_item_depth OUT NOCOPY NUMBER)
674: IS
675: l_instr INTEGER;
676: l_count PLS_INTEGER;
677: l_str cz_config_items.node_identifier%TYPE;
678: l_ecc cz_config_items.node_identifier%TYPE;
679:
680: BEGIN
681: l_count := 1;

Line 678: l_ecc cz_config_items.node_identifier%TYPE;

674: IS
675: l_instr INTEGER;
676: l_count PLS_INTEGER;
677: l_str cz_config_items.node_identifier%TYPE;
678: l_ecc cz_config_items.node_identifier%TYPE;
679:
680: BEGIN
681: l_count := 1;
682: l_ecc := '';

Line 705: l_ecc cz_config_items.node_identifier%TYPE;

701: ,p_config_item_id IN NUMBER
702: ,x_ecc_code OUT NOCOPY VARCHAR2
703: ,x_item_depth OUT NOCOPY NUMBER)
704: IS
705: l_ecc cz_config_items.node_identifier%TYPE;
706: l_inventory_item_id NUMBER;
707: l_instance_nbr NUMBER;
708: l_depth PLS_INTEGER;
709: CURSOR ecc_cur(p_config_item_id NUMBER) IS

Line 711: FROM cz_config_items

707: l_instance_nbr NUMBER;
708: l_depth PLS_INTEGER;
709: CURSOR ecc_cur(p_config_item_id NUMBER) IS
710: SELECT inventory_item_id, instance_nbr
711: FROM cz_config_items
712: WHERE deleted_flag = '0'
713: AND inventory_item_id IS NOT NULL
714: AND config_hdr_id = p_config_hdr_id
715: AND config_rev_nbr = p_config_rev_nbr

Line 937: l_prev_item cz_config_items.config_item_id%TYPE := 0;

933: v_header_id cz_config_hdrs.config_hdr_id%TYPE;
934: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
935: v_output_cfg_hdr_id cz_config_hdrs.config_hdr_id%TYPE := 0;
936: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
937: l_prev_item cz_config_items.config_item_id%TYPE := 0;
938: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
939: l_prev_qty NUMBER := 0;
940: l_description mtl_system_items.description%TYPE;
941: l_new_item cz_config_items.config_item_id%TYPE:= 0;

Line 941: l_new_item cz_config_items.config_item_id%TYPE:= 0;

937: l_prev_item cz_config_items.config_item_id%TYPE := 0;
938: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
939: l_prev_qty NUMBER := 0;
940: l_description mtl_system_items.description%TYPE;
941: l_new_item cz_config_items.config_item_id%TYPE:= 0;
942: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;
943: l_new_component_code cz_config_details_v.component_code%TYPE;
944: l_new_qty NUMBER := 0;
945: l_new_inventory_item_id mtl_system_items.inventory_item_id%TYPE;

Line 955: l_new_item_name cz_config_items.name%TYPE;

951: v_xml_str LONG := NULL;
952: l_config_err_msg VARCHAR2(2000);
953: PARSE_XML_ERROR EXCEPTION;
954: NO_INPUT_HDR_EXCEP EXCEPTION;
955: l_new_item_name cz_config_items.name%TYPE;
956: l_bv_profile VARCHAR2(100);
957: v_parse_message VARCHAR2(2000);
958: l_len NUMBER := 2000;
959: l_delta_exists VARCHAR2(3) := 'NO';

Line 1327: DELETE FROM CZ_CONFIG_ITEMS

1323: IF p_delete_ext_attr THEN
1324: DELETE FROM CZ_CONFIG_EXT_ATTRIBUTES
1325: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1326: END IF;
1327: DELETE FROM CZ_CONFIG_ITEMS
1328: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1329: DELETE FROM CZ_CONFIG_HDRS
1330: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1331: COMMIT;

Line 1774: l_ext_comp_code cz_config_items.node_identifier%TYPE;

1770: l_operation_code VARCHAR2(40);
1771: l_rec1_seq INTEGER;
1772: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1773: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1774: l_ext_comp_code cz_config_items.node_identifier%TYPE;
1775: l_item_depth INTEGER;
1776:
1777: l_upd_item_map NUMBER_TBL_INDEXBY_CHAR_TYPE;
1778: l_item_seq_map NUMBER_TBL_INDEXBY_TYPE;

Line 2013: INSERT INTO CZ_CONFIG_ITEMS

2009: END LOOP;
2010:
2011: l_nDebug := 5;
2012: FORALL i IN l_config_item_tbl.first .. l_config_item_tbl.lAST
2013: INSERT INTO CZ_CONFIG_ITEMS
2014: (config_hdr_id
2015: ,config_rev_nbr
2016: ,config_item_id
2017: ,sequence_nbr

Line 2049: FROM cz_config_items

2045: -- reoder sequences if generated by this proc
2046: l_nDebug := 6;
2047: IF l_rec1_seq IS NULL THEN
2048: SELECT config_item_id BULK COLLECT INTO l_config_item_tbl
2049: FROM cz_config_items
2050: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
2051: ORDER BY sequence_nbr, config_delta;
2052:
2053: FOR i IN l_config_item_tbl.FIRST .. l_config_item_tbl.LAST LOOP

Line 2058: UPDATE cz_config_items

2054: l_seq_nbr_tbl(i) := i;
2055: END LOOP;
2056:
2057: FORALL i IN l_config_item_tbl.FIRST .. l_config_item_tbl.LAST
2058: UPDATE cz_config_items
2059: SET sequence_nbr = l_seq_nbr_tbl(i)
2060: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
2061: AND config_item_id = l_config_item_tbl(i);
2062: IF l_log_stmt THEN

Line 2151: INSERT INTO CZ_CONFIG_ITEMS

2147: -- or modified after changing to not generate ecc
2148: -- If we do need to keep ecc, do a single bulk insert for both the item recs from
2149: -- inputs and the dummy recs here by adding the dummies to the tbls used in processing
2150: -- inputs and then moving bulk ins stmt to the end of processing attr
2151: INSERT INTO CZ_CONFIG_ITEMS
2152: (config_hdr_id
2153: ,config_rev_nbr
2154: ,config_item_id
2155: ,sequence_nbr

Line 2210: FROM cz_config_ext_attributes attr, cz_config_items item

2206: IF l_rec1_seq IS NULL THEN
2207: l_config_item_tbl.DELETE;
2208: l_seq_nbr_tbl.DELETE;
2209: SELECT attr.config_item_id BULK COLLECT INTO l_config_item_tbl
2210: FROM cz_config_ext_attributes attr, cz_config_items item
2211: WHERE attr.config_hdr_id = l_pseudo_hdr_id AND attr.config_rev_nbr = 1
2212: AND attr.config_hdr_id = item.config_hdr_id AND attr.config_rev_nbr = item.config_rev_nbr
2213: AND attr.config_item_id = item.config_item_id
2214: ORDER BY nvl(length(translate(item.node_identifier,'-0123456789','A')),0), attr.sequence_nbr;

Line 2386: l_ext_comp_code cz_config_items.node_identifier%TYPE;

2382: l_rec1_seq NUMBER;
2383: l_hdr_id NUMBER;
2384: l_rev_nbr NUMBER;
2385: l_item_id NUMBER;
2386: l_ext_comp_code cz_config_items.node_identifier%TYPE;
2387: l_item_depth INTEGER;
2388: l_delta_status VARCHAR2(1);
2389: l_check_db_setting BOOLEAN;
2390:

Line 2488: INSERT INTO CZ_CONFIG_ITEMS(config_hdr_id

2484: END LOOP;
2485:
2486: l_nDebug := 3;
2487: FORALL i IN l_item_id_tbl.first .. l_item_id_tbl.lAST
2488: INSERT INTO CZ_CONFIG_ITEMS(config_hdr_id
2489: ,config_rev_nbr
2490: ,config_item_id
2491: ,sequence_nbr
2492: ,node_identifier

Line 2522: FROM cz_config_items

2518: -- IF l_rec1_seq IS NULL THEN
2519: l_item_id_tbl.delete;
2520: l_input_seq_tbl.delete;
2521: SELECT config_item_id BULK COLLECT INTO l_item_id_tbl
2522: FROM cz_config_items
2523: WHERE config_hdr_id = l_pseudo_hdr_id
2524: AND config_rev_nbr = 1
2525: ORDER BY config_delta, sequence_nbr;
2526:

Line 2532: UPDATE cz_config_items

2528: l_input_seq_tbl(i) := i;
2529: END LOOP;
2530:
2531: FORALL i IN l_item_id_tbl.FIRST .. l_item_id_tbl.LAST
2532: UPDATE cz_config_items
2533: SET sequence_nbr = l_input_seq_tbl(i)
2534: WHERE config_hdr_id = l_pseudo_hdr_id
2535: AND config_rev_nbr = 1
2536: AND config_item_id = l_item_id_tbl(i);

Line 3409: FROM cz_config_items

3405: v_ndebug := 3;
3406: BEGIN
3407: SELECT inventory_item_id, organization_id
3408: INTO v_inventory_item_id, v_organization_id
3409: FROM cz_config_items
3410: WHERE config_hdr_id = v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr
3411: AND deleted_flag = '0' AND inventory_item_id IS NOT NULL
3412: AND to_char(inventory_item_id) = node_identifier;
3413: EXCEPTION