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_DEVELOPER_UTILS_PVT dependencies on CZ_PROPERTIES

Line 524: l_property_name CZ_PROPERTIES.NAME%TYPE;

520: RETURN REPLACE(l_path, FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8), '\''');
521: END get_Path;
522:
523: FUNCTION get_Property(p_property_id IN NUMBER) RETURN VARCHAR2 IS
524: l_property_name CZ_PROPERTIES.NAME%TYPE;
525: BEGIN
526: SELECT NAME INTO l_property_name FROM CZ_PROPERTIES
527: WHERE property_id=p_property_id;
528: RETURN '"' || l_property_name || '"';

Line 526: SELECT NAME INTO l_property_name FROM CZ_PROPERTIES

522:
523: FUNCTION get_Property(p_property_id IN NUMBER) RETURN VARCHAR2 IS
524: l_property_name CZ_PROPERTIES.NAME%TYPE;
525: BEGIN
526: SELECT NAME INTO l_property_name FROM CZ_PROPERTIES
527: WHERE property_id=p_property_id;
528: RETURN '"' || l_property_name || '"';
529: END get_Property;
530:

Line 4903: x_new_property_id := allocateId('CZ_PROPERTIES_S');

4899:
4900: BEGIN
4901:
4902: x_return_status := FND_API.G_RET_STS_SUCCESS;
4903: x_new_property_id := allocateId('CZ_PROPERTIES_S');
4904: l_name := copy_name(p_property_id,'PRP');
4905: INSERT INTO CZ_PROPERTIES
4906: (
4907: PROPERTY_ID

Line 4905: INSERT INTO CZ_PROPERTIES

4901:
4902: x_return_status := FND_API.G_RET_STS_SUCCESS;
4903: x_new_property_id := allocateId('CZ_PROPERTIES_S');
4904: l_name := copy_name(p_property_id,'PRP');
4905: INSERT INTO CZ_PROPERTIES
4906: (
4907: PROPERTY_ID
4908: ,PROPERTY_UNIT
4909: ,DESC_TEXT

Line 4951: FROM CZ_PROPERTIES

4947: ,SECURITY_MASK
4948: ,EFF_MASK
4949: ,CHECKOUT_USER
4950: ,def_num_value
4951: FROM CZ_PROPERTIES
4952: WHERE property_id=p_property_id;
4953:
4954: IF SQL%ROWCOUNT = 0 THEN
4955: RAISE INVALID_PROPERTY_ID_EXCP;

Line 4959: FOR i IN (SELECT def_num_value FROM cz_properties

4955: RAISE INVALID_PROPERTY_ID_EXCP;
4956: END IF;
4957:
4958: -- Create new text if the type is translateable text
4959: FOR i IN (SELECT def_num_value FROM cz_properties
4960: WHERE property_id=p_property_id
4961: AND data_type=8
4962: AND def_num_value IS NOT NULL) LOOP
4963: l_text_id := i.def_num_value;

Line 4968: UPDATE cz_properties

4964: l_new_intl_text_id := copy_INTL_TEXT(i.def_num_value);
4965: IF l_new_intl_text_id = -1 THEN
4966: RAISE NO_TXT_FOUND_EXCP;
4967: END IF;
4968: UPDATE cz_properties
4969: SET def_num_value=l_new_intl_text_id
4970: WHERE property_id=x_new_property_id;
4971: END LOOP;
4972:

Line 6781: UPDATE cz_properties

6777: AND object_type = 'PRP'
6778: AND deleted_flag = '0'
6779: AND seeded_flag <> '1';
6780:
6781: UPDATE cz_properties
6782: SET cz_properties.deleted_flag = '1',
6783: cz_properties.name = append_name(p_property_id, 'PRP', name)
6784: WHERE property_id = p_property_id;
6785: ELSE

Line 6782: SET cz_properties.deleted_flag = '1',

6778: AND deleted_flag = '0'
6779: AND seeded_flag <> '1';
6780:
6781: UPDATE cz_properties
6782: SET cz_properties.deleted_flag = '1',
6783: cz_properties.name = append_name(p_property_id, 'PRP', name)
6784: WHERE property_id = p_property_id;
6785: ELSE
6786: x_return_status := l_return_status;

Line 6783: cz_properties.name = append_name(p_property_id, 'PRP', name)

6779: AND seeded_flag <> '1';
6780:
6781: UPDATE cz_properties
6782: SET cz_properties.deleted_flag = '1',
6783: cz_properties.name = append_name(p_property_id, 'PRP', name)
6784: WHERE property_id = p_property_id;
6785: ELSE
6786: x_return_status := l_return_status;
6787: x_msg_count := l_msg_count;

Line 8415: UPDATE cz_properties

8411: UPDATE cz_effectivity_sets
8412: SET deleted_flag = '1'
8413: WHERE effectivity_set_id = l_object_id_tbl(i);
8414: ELSIF (l_object_typ_tbl(i) = 'PRP') THEN
8415: UPDATE cz_properties
8416: SET deleted_flag = '1'
8417: WHERE property_id = l_object_id_tbl(i);
8418: END IF;
8419: END LOOP;

Line 8603: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;

8599: TYPE tIntegerTable IS TABLE OF PLS_INTEGER INDEX BY VARCHAR2(15);
8600: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8601:
8602: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8603: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8604: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;

Line 9043: SELECT name INTO v_Name FROM cz_properties

9039: --We don't want to account for deleted_flag in this query because we want to parse a rule even
9040: --if it refers to a deleted property instead of ignoring the rule.
9041:
9042: BEGIN
9043: SELECT name INTO v_Name FROM cz_properties
9044: WHERE property_id = v_ExprPropertyId(j);
9045:
9046: h_PropertyName(v_ExprPropertyId(j)) := v_Name;
9047:

Line 10464: v_property_name cz_properties.name%TYPE;

10460: v_model_name VARCHAR2(2000);
10461: v_seeded_flag VARCHAR2(1);
10462: v_arg_count NUMBER;
10463: v_property_value VARCHAR2(4000);
10464: v_property_name cz_properties.name%TYPE;
10465: v_item_name cz_ps_nodes.name%TYPE;
10466: v_parent_name cz_ps_nodes.name%TYPE;
10467: v_parent_id cz_ps_nodes.parent_id%TYPE;
10468: v_inst_scope cz_rules.instantiation_scope%TYPE;

Line 10870: FROM cz_properties

10866: v_parent_name := NULL;
10867:
10868: BEGIN
10869: SELECT name INTO v_property_name
10870: FROM cz_properties
10871: WHERE deleted_flag = '0'
10872: AND property_id = v_tPropertyId(i);
10873:
10874: SELECT parent_id, name INTO v_parent_id, v_item_name