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.

[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_CONFIG_ITEMS

Line 325: FROM cz_config_items

321: END IF;
322:
323: SELECT instance_hdr_id, instance_rev_nbr, component_instance_type
324: BULK COLLECT INTO l_instance_hdr_id_tbl, l_instance_rev_nbr_tbl, l_instance_type_tbl
325: FROM cz_config_items
326: WHERE config_hdr_id = in_config_hdr_id AND config_rev_nbr = in_config_rev_nbr
327: AND deleted_flag = '0'
328: AND component_instance_type IN (GENERIC_INSTANCE_ROOT, NETWORK_INSTANCE_ROOT);
329:

Line 390: DELETE FROM CZ_CONFIG_ITEMS

386: DELETE FROM CZ_CONFIG_ATTRIBUTES
387: WHERE CONFIG_HDR_ID=in_config_hdr_id
388: AND CONFIG_REV_NBR=in_config_rev_nbr;
389:
390: DELETE FROM CZ_CONFIG_ITEMS
391: WHERE CONFIG_HDR_ID=in_config_hdr_id
392: AND CONFIG_REV_NBR=in_config_rev_nbr;
393:
394: DELETE FROM CZ_CONFIG_INPUTS

Line 647: l_str cz_config_items.node_identifier%TYPE;

643: x_item_depth OUT NOCOPY NUMBER)
644: IS
645: l_instr INTEGER;
646: l_count PLS_INTEGER;
647: l_str cz_config_items.node_identifier%TYPE;
648: l_ecc cz_config_items.node_identifier%TYPE;
649:
650: BEGIN
651: l_count := 1;

Line 648: l_ecc cz_config_items.node_identifier%TYPE;

644: IS
645: l_instr INTEGER;
646: l_count PLS_INTEGER;
647: l_str cz_config_items.node_identifier%TYPE;
648: l_ecc cz_config_items.node_identifier%TYPE;
649:
650: BEGIN
651: l_count := 1;
652: l_ecc := '';

Line 675: l_ecc cz_config_items.node_identifier%TYPE;

671: ,p_config_item_id IN NUMBER
672: ,x_ecc_code OUT NOCOPY VARCHAR2
673: ,x_item_depth OUT NOCOPY NUMBER)
674: IS
675: l_ecc cz_config_items.node_identifier%TYPE;
676: l_inventory_item_id NUMBER;
677: l_instance_nbr NUMBER;
678: l_depth PLS_INTEGER;
679: CURSOR ecc_cur(p_config_item_id NUMBER) IS

Line 681: FROM cz_config_items

677: l_instance_nbr NUMBER;
678: l_depth PLS_INTEGER;
679: CURSOR ecc_cur(p_config_item_id NUMBER) IS
680: SELECT inventory_item_id, instance_nbr
681: FROM cz_config_items
682: WHERE deleted_flag = '0'
683: AND inventory_item_id IS NOT NULL
684: AND config_hdr_id = p_config_hdr_id
685: AND config_rev_nbr = p_config_rev_nbr

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

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;
902: l_new_item cz_config_items.config_item_id%TYPE:= 0;

Line 902: l_new_item cz_config_items.config_item_id%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;
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;

Line 916: l_new_item_name cz_config_items.name%TYPE;

912: v_xml_str LONG := NULL;
913: l_config_err_msg VARCHAR2(2000);
914: PARSE_XML_ERROR EXCEPTION;
915: NO_INPUT_HDR_EXCEP EXCEPTION;
916: l_new_item_name cz_config_items.name%TYPE;
917: l_bv_profile VARCHAR2(100);
918: v_parse_message VARCHAR2(2000);
919: l_len NUMBER := 2000;
920: l_delta_exists VARCHAR2(3) := 'NO';

Line 1234: DELETE FROM CZ_CONFIG_ITEMS

1230: IF p_delete_ext_attr THEN
1231: DELETE FROM CZ_CONFIG_EXT_ATTRIBUTES
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;

Line 1422: l_ext_comp_code cz_config_items.node_identifier%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;
1426: l_item_seq_map NUMBER_TBL_INDEXBY_TYPE;

Line 1660: INSERT INTO CZ_CONFIG_ITEMS

1656: END LOOP;
1657:
1658: l_nDebug := 5;
1659: FORALL i IN l_config_item_tbl.first .. l_config_item_tbl.lAST
1660: INSERT INTO CZ_CONFIG_ITEMS
1661: (config_hdr_id
1662: ,config_rev_nbr
1663: ,config_item_id
1664: ,sequence_nbr

Line 1696: FROM cz_config_items

1692: -- reoder sequences if generated by this proc
1693: l_nDebug := 6;
1694: IF l_rec1_seq IS NULL THEN
1695: SELECT config_item_id BULK COLLECT INTO l_config_item_tbl
1696: FROM cz_config_items
1697: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
1698: ORDER BY sequence_nbr, config_delta;
1699:
1700: FOR i IN l_config_item_tbl.FIRST .. l_config_item_tbl.LAST LOOP

Line 1705: UPDATE cz_config_items

1701: l_seq_nbr_tbl(i) := i;
1702: END LOOP;
1703:
1704: FORALL i IN l_config_item_tbl.FIRST .. l_config_item_tbl.LAST
1705: UPDATE cz_config_items
1706: SET sequence_nbr = l_seq_nbr_tbl(i)
1707: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
1708: AND config_item_id = l_config_item_tbl(i);
1709: IF l_log_stmt THEN

Line 1798: INSERT INTO CZ_CONFIG_ITEMS

1794: -- or modified after changing to not generate ecc
1795: -- If we do need to keep ecc, do a single bulk insert for both the item recs from
1796: -- inputs and the dummy recs here by adding the dummies to the tbls used in processing
1797: -- inputs and then moving bulk ins stmt to the end of processing attr
1798: INSERT INTO CZ_CONFIG_ITEMS
1799: (config_hdr_id
1800: ,config_rev_nbr
1801: ,config_item_id
1802: ,sequence_nbr

Line 1857: FROM cz_config_ext_attributes attr, cz_config_items item

1853: IF l_rec1_seq IS NULL THEN
1854: l_config_item_tbl.DELETE;
1855: l_seq_nbr_tbl.DELETE;
1856: SELECT attr.config_item_id BULK COLLECT INTO l_config_item_tbl
1857: FROM cz_config_ext_attributes attr, cz_config_items item
1858: WHERE attr.config_hdr_id = l_pseudo_hdr_id AND attr.config_rev_nbr = 1
1859: AND attr.config_hdr_id = item.config_hdr_id AND attr.config_rev_nbr = item.config_rev_nbr
1860: AND attr.config_item_id = item.config_item_id
1861: ORDER BY nvl(length(translate(item.node_identifier,'-0123456789','A')),0), attr.sequence_nbr;

Line 1987: l_ext_comp_code cz_config_items.node_identifier%TYPE;

1983: l_rec1_seq NUMBER;
1984: l_hdr_id NUMBER;
1985: l_rev_nbr NUMBER;
1986: l_item_id NUMBER;
1987: l_ext_comp_code cz_config_items.node_identifier%TYPE;
1988: l_item_depth INTEGER;
1989: l_delta_status VARCHAR2(1);
1990: l_check_db_setting BOOLEAN;
1991:

Line 2089: INSERT INTO CZ_CONFIG_ITEMS(config_hdr_id

2085: END LOOP;
2086:
2087: l_nDebug := 3;
2088: FORALL i IN l_item_id_tbl.first .. l_item_id_tbl.lAST
2089: INSERT INTO CZ_CONFIG_ITEMS(config_hdr_id
2090: ,config_rev_nbr
2091: ,config_item_id
2092: ,sequence_nbr
2093: ,node_identifier

Line 2123: FROM cz_config_items

2119: -- IF l_rec1_seq IS NULL THEN
2120: l_item_id_tbl.delete;
2121: l_input_seq_tbl.delete;
2122: SELECT config_item_id BULK COLLECT INTO l_item_id_tbl
2123: FROM cz_config_items
2124: WHERE config_hdr_id = l_pseudo_hdr_id
2125: AND config_rev_nbr = 1
2126: ORDER BY config_delta, sequence_nbr;
2127:

Line 2133: UPDATE cz_config_items

2129: l_input_seq_tbl(i) := i;
2130: END LOOP;
2131:
2132: FORALL i IN l_item_id_tbl.FIRST .. l_item_id_tbl.LAST
2133: UPDATE cz_config_items
2134: SET sequence_nbr = l_input_seq_tbl(i)
2135: WHERE config_hdr_id = l_pseudo_hdr_id
2136: AND config_rev_nbr = 1
2137: AND config_item_id = l_item_id_tbl(i);

Line 3009: FROM cz_config_items

3005: v_ndebug := 3;
3006: BEGIN
3007: SELECT inventory_item_id, organization_id
3008: INTO v_inventory_item_id, v_organization_id
3009: FROM cz_config_items
3010: WHERE config_hdr_id = v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr
3011: AND deleted_flag = '0' AND inventory_item_id IS NOT NULL
3012: AND to_char(inventory_item_id) = node_identifier;
3013: EXCEPTION