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_HDRS

Line 144: SELECT cz_config_hdrs_s.NEXTVAL

140: BEGIN
141: IF ( (last_hdr_allocated IS NULL)
142: OR
143: (next_hdr_to_use = (NVL(last_hdr_allocated, 0) + id_increment)) ) THEN
144: SELECT cz_config_hdrs_s.NEXTVAL
145: INTO last_hdr_allocated
146: FROM dual;
147: next_hdr_to_use := last_hdr_allocated;
148: END IF;

Line 290: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;

286: Return_value IN OUT NOCOPY NUMBER)
287: IS
288: in_config_hdr_id NUMBER := config_hdr_id;
289: in_config_rev_nbr NUMBER := config_rev_nbr;
290: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
291: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
292: l_instance_hdr_id_tbl number_tbl_indexby_type;
293: l_instance_rev_nbr_tbl number_tbl_indexby_type;
294: l_run_id NUMBER;

Line 291: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

287: IS
288: in_config_hdr_id NUMBER := config_hdr_id;
289: in_config_rev_nbr NUMBER := config_rev_nbr;
290: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
291: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
292: l_instance_hdr_id_tbl number_tbl_indexby_type;
293: l_instance_rev_nbr_tbl number_tbl_indexby_type;
294: l_run_id NUMBER;
295: l_ndebug NUMBER := 0;

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

302: l_ib_error NUMBER;
303:
304: v_table_name VARCHAR2(100) := NULL;
305:
306: TYPE instype_tbl_type IS TABLE OF cz_config_hdrs.component_instance_type%TYPE INDEX BY PLS_INTEGER;
307: l_instance_type_tbl instype_tbl_type;
308:
309: BEGIN
310: Return_value:=1;

Line 324: FROM cz_config_hdrs

320: -- i.e., component_instance_type must be 'R'
321: BEGIN
322: SELECT model_instantiation_type, component_instance_type
323: INTO l_model_instantiation_type, l_component_instance_type
324: FROM cz_config_hdrs
325: WHERE config_hdr_id = in_config_hdr_id AND config_rev_nbr = in_config_rev_nbr;
326: EXCEPTION
327: WHEN NO_DATA_FOUND THEN
328: RETURN;

Line 449: DELETE FROM CZ_CONFIG_HDRS

445:
446: l_instance_hdr_id_tbl(l_instance_hdr_id_tbl.COUNT+1) := in_config_hdr_id;
447: l_instance_rev_nbr_tbl(l_instance_rev_nbr_tbl.COUNT+1) := in_config_rev_nbr;
448: FORALL i IN l_instance_hdr_id_tbl.FIRST .. l_instance_hdr_id_tbl.LAST
449: DELETE FROM CZ_CONFIG_HDRS
450: WHERE CONFIG_HDR_ID = l_instance_hdr_id_tbl(i)
451: AND CONFIG_REV_NBR = l_instance_rev_nbr_tbl(i);
452:
453: l_ndebug := 7;

Line 465: UPDATE cz_config_hdrs

461: RAISE del_ib_config_exc;
462: END IF;
463: ELSE
464: -- Mark the configuration session as "To Be Deleted" as few config instances are still active
465: UPDATE cz_config_hdrs
466: SET to_be_deleted_flag = '1'
467: WHERE config_hdr_id=in_config_hdr_id and
468: config_rev_nbr = in_config_rev_nbr;
469: END IF;

Line 933: v_header_id cz_config_hdrs.config_hdr_id%TYPE;

929: x_return_status IN OUT NOCOPY VARCHAR2,
930: x_return_config_changed OUT NOCOPY VARCHAR2)
931: IS
932:
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;

Line 934: v_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

930: x_return_config_changed OUT NOCOPY VARCHAR2)
931: IS
932:
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;

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

931: IS
932:
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;

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

932:
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;

Line 938: l_prev_rev cz_config_hdrs.config_rev_nbr%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;
942: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;

Line 942: l_new_rev cz_config_hdrs.config_rev_nbr%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;
946: l_new_organization_id mtl_system_items.organization_id%TYPE;

Line 1329: DELETE FROM CZ_CONFIG_HDRS

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;
1332: END delete_bv_records;
1333: --------------------------------------------------------------------------------

Line 1367: p_config_header_id cz_config_hdrs.config_hdr_id%TYPE := NULL;

1363: p_publication_mode VARCHAR(1):= NULL;
1364: p_product_id cz_devl_projects.product_key%TYPE := NULL;
1365: p_inventory_item_id cz_devl_projects.inventory_item_id%TYPE := NULL;
1366: p_context_org_id cz_devl_projects.organization_id%TYPE := NULL;
1367: p_config_header_id cz_config_hdrs.config_hdr_id%TYPE := NULL;
1368: p_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := NULL;
1369: --
1370: MISSING_CAL_APPL EXCEPTION;
1371: NO_MODEL_INFO_FOUND EXCEPTION;

Line 1368: p_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := NULL;

1364: p_product_id cz_devl_projects.product_key%TYPE := NULL;
1365: p_inventory_item_id cz_devl_projects.inventory_item_id%TYPE := NULL;
1366: p_context_org_id cz_devl_projects.organization_id%TYPE := NULL;
1367: p_config_header_id cz_config_hdrs.config_hdr_id%TYPE := NULL;
1368: p_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := NULL;
1369: --
1370: MISSING_CAL_APPL EXCEPTION;
1371: NO_MODEL_INFO_FOUND EXCEPTION;
1372:

Line 1484: SELECT model_identifier INTO l_model_identifier FROM cz_config_hdrs

1480: ELSIF mHasNativeBOMParams = TRUE THEN
1481: x_product_key := p_context_org_id || ':' || p_inventory_item_id;
1482: ELSIF mHasRestoreParams = TRUE OR (p_config_header_id IS NOT NULL AND p_config_rev_nbr IS NOT NULL) THEN
1483: --12816:204:2008/07/06 05:05
1484: SELECT model_identifier INTO l_model_identifier FROM cz_config_hdrs
1485: WHERE config_hdr_id = p_config_header_id AND config_rev_nbr = p_config_rev_nbr AND deleted_flag = 0;
1486: IF l_model_identifier IS NOT NULL THEN
1487: l_index1 := INSTR(l_model_identifier, ':');
1488: p_inventory_item_id := SUBSTR(l_model_identifier, 1, l_index1-1);

Line 1769: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

1765:
1766: l_url VARCHAR2(32767);
1767: l_validation_type VARCHAR2(1);
1768: l_validation_status INTEGER;
1769: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%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;

Line 1772: l_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;

1768: l_validation_status INTEGER;
1769: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%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:

Line 1773: l_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;

1769: l_pseudo_hdr_id cz_config_hdrs.config_hdr_id%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;

Line 1871: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id

1867: l_has_attr := p_config_ext_attr_tbl IS NOT NULL AND p_config_ext_attr_tbl.COUNT > 0;
1868: IF l_has_item OR l_has_attr THEN
1869: -- create pseudo hdr rec
1870: l_pseudo_hdr_id := next_config_hdr_id;
1871: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id
1872: ,config_rev_nbr
1873: ,name
1874: ,effective_usage_id
1875: ,component_instance_type

Line 2412: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id

2408:
2409: IF config_input_list.COUNT > 0 THEN
2410: BEGIN
2411: l_pseudo_hdr_id := next_config_hdr_id;
2412: INSERT INTO CZ_CONFIG_HDRS (config_hdr_id
2413: ,config_rev_nbr
2414: ,name
2415: ,effective_usage_id
2416: ,deleted_flag

Line 3354: v_model_identifier cz_config_hdrs.model_identifier%TYPE;

3350: v_inventory_item_id NUMBER;
3351: v_organization_id NUMBER;
3352: v_product_key cz_devl_projects.product_key%TYPE;
3353: v_component_id NUMBER;
3354: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
3355: v_ndebug NUMBER := 0;
3356:
3357: BEGIN
3358: BEGIN

Line 3361: FROM CZ_CONFIG_HDRS

3357: BEGIN
3358: BEGIN
3359: SELECT component_id, model_identifier
3360: INTO v_component_id, v_model_identifier
3361: FROM CZ_CONFIG_HDRS
3362: WHERE config_hdr_id = v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr;
3363: EXCEPTION
3364: WHEN NO_DATA_FOUND THEN
3365: RETURN NULL;

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

3376: -- is a publication. If the model is a non-BOM or a mixed model in which the root is non
3377: -- BOM orig_sys_ref will be NULL. In the customer case of bug 2475218, a BOM reference
3378: -- was added to a copy of the original non-bom model. The fix for bug 2475218 was:
3379: -- New logic if the root ps node orig_sys_ref lookup fails:
3380: -- a. Look for model corresponding to cz_config_hdrs.component_id. If it exists, find
3381: -- its BOM model.
3382: -- b. If a. fails, iterate over all projects that have persistent_project_id equal to
3383: -- the config's persistent_component_id. Iterate until a root BOM model is found.
3384:

Line 3630: l_config_effective_date FROM CZ_CONFIG_HDRS WHERE config_hdr_id =

3626: END IF;
3627:
3628: BEGIN
3629: SELECT creation_date, effective_date INTO l_config_creation_date,
3630: l_config_effective_date FROM CZ_CONFIG_HDRS WHERE config_hdr_id =
3631: p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr;
3632: EXCEPTION
3633: WHEN NO_DATA_FOUND THEN
3634: -- just set l_config_creation_date and l_config_effective_date

Line 3925: v_model_identifier cz_config_hdrs.model_identifier%TYPE;

3921: v_inventory_item_id NUMBER;
3922: v_organization_id NUMBER;
3923: v_product_key cz_devl_projects.product_key%TYPE := NULL;
3924: v_persist_comp_id NUMBER;
3925: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
3926:
3927: CURSOR prj_cursor IS
3928: SELECT product_key
3929: FROM CZ_DEVL_PROJECTS

Line 3938: FROM CZ_CONFIG_HDRS

3934: BEGIN
3935: BEGIN
3936: SELECT persistent_component_id, model_identifier
3937: INTO v_persist_comp_id, v_model_identifier
3938: FROM CZ_CONFIG_HDRS
3939: WHERE config_hdr_id = v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr;
3940: EXCEPTION
3941: WHEN NO_DATA_FOUND THEN
3942: RETURN NULL;