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

Line 789: p_property_id IN cz_properties.property_id%TYPE,

785:
786: sUnsatisfiedId VARCHAR2(4000);
787: ---------------------------------------------------------------------------------------
788: FUNCTION GET_PROPERTY_VALUE(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
789: p_property_id IN cz_properties.property_id%TYPE,
790: p_item_id IN cz_item_masters.item_id%TYPE,
791: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
792: RETURN VARCHAR2 IS
793: l_def_value cz_properties.def_value%TYPE;

Line 791: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)

787: ---------------------------------------------------------------------------------------
788: FUNCTION GET_PROPERTY_VALUE(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
789: p_property_id IN cz_properties.property_id%TYPE,
790: p_item_id IN cz_item_masters.item_id%TYPE,
791: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
792: RETURN VARCHAR2 IS
793: l_def_value cz_properties.def_value%TYPE;
794: l_tab tStringArray;
795: BEGIN

Line 793: l_def_value cz_properties.def_value%TYPE;

789: p_property_id IN cz_properties.property_id%TYPE,
790: p_item_id IN cz_item_masters.item_id%TYPE,
791: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
792: RETURN VARCHAR2 IS
793: l_def_value cz_properties.def_value%TYPE;
794: l_tab tStringArray;
795: BEGIN
796:
797: SELECT NVL(TO_CHAR(def_num_value), def_value), data_type INTO l_def_value, x_data_type

Line 798: FROM cz_properties

794: l_tab tStringArray;
795: BEGIN
796:
797: SELECT NVL(TO_CHAR(def_num_value), def_value), data_type INTO l_def_value, x_data_type
798: FROM cz_properties
799: WHERE property_id = p_property_id
800: AND deleted_flag = FLAG_NOT_DELETED;
801:
802: SELECT NVL(TO_CHAR(data_num_value), data_value) BULK COLLECT INTO l_tab

Line 2812: FROM cz_properties

2808: EXCEPTION
2809: WHEN OTHERS THEN
2810:
2811: SELECT name INTO errorMessage
2812: FROM cz_properties
2813: WHERE property_id = propertyId;
2814:
2815: localString := v_return;
2816: RAISE CZ_R_INCORRECT_DATA_TYPE;

Line 3046: FROM cz_properties

3042: EXCEPTION
3043: WHEN OTHERS THEN
3044:
3045: SELECT name INTO errorMessage
3046: FROM cz_properties
3047: WHERE property_id = propertyId;
3048:
3049: localString := v_return(i);
3050: RAISE CZ_R_INCORRECT_DATA_TYPE;

Line 3404: FROM cz_properties

3400: EXCEPTION
3401: WHEN OTHERS THEN
3402:
3403: SELECT name INTO errorMessage
3404: FROM cz_properties
3405: WHERE property_id = v_tExprPropertyId(j);
3406:
3407: RAISE CZ_R_INCORRECT_NUMERICLHS;
3408: END;

Line 5239: FROM cz_properties

5235: BEGIN
5236: IF(v_tExprPropertyId(propChild) IS NOT NULL)THEN
5237:
5238: SELECT data_type, name INTO DataType, PropName
5239: FROM cz_properties
5240: WHERE deleted_flag = FLAG_NOT_DELETED
5241: AND property_id = v_tExprPropertyId(propChild);
5242: nDebug := 7004043;
5243:

Line 5249: FROM cz_properties

5245:
5246: ELSIF(v_tExprType(propChild) = EXPR_LITERAL)THEN
5247:
5248: SELECT property_id, data_type, name INTO propertyId, DataType, PropName
5249: FROM cz_properties
5250: WHERE deleted_flag = FLAG_NOT_DELETED
5251: AND name = v_tExprDataValue(propChild);
5252:
5253: RETURN propertyId;

Line 5336: propName cz_properties.name%TYPE;

5332: nCount PLS_INTEGER;
5333: propertyId PLS_INTEGER;
5334: dataType PLS_INTEGER;
5335: propType PLS_INTEGER;
5336: propName cz_properties.name%TYPE;
5337: BEGIN
5338:
5339: nDebug := 7004020;
5340:

Line 5383: propName cz_properties.name%TYPE;

5379: propType PLS_INTEGER;
5380: jChild PLS_INTEGER;
5381: isLocal PLS_INTEGER := 0;
5382: LocalType PLS_INTEGER := DATA_TYPE_VOID;
5383: propName cz_properties.name%TYPE;
5384: v_extern tStringArray;
5385: v_quotes VARCHAR2(2);
5386: BEGIN
5387:

Line 6012: propName cz_properties.name%TYPE;

6008: nCount PLS_INTEGER;
6009: propertyId PLS_INTEGER;
6010: dataType PLS_INTEGER;
6011: propType PLS_INTEGER;
6012: propName cz_properties.name%TYPE;
6013: BEGIN
6014:
6015: nDebug := 7005020;
6016:

Line 6056: propName cz_properties.name%TYPE;

6052: FUNCTION EXAMINE_WHERE_CLAUSE(j IN PLS_INTEGER) RETURN VARCHAR2 IS
6053: argChild PLS_INTEGER;
6054: propType PLS_INTEGER;
6055: jChild PLS_INTEGER;
6056: propName cz_properties.name%TYPE;
6057: LocalType PLS_INTEGER := DATA_TYPE_VOID;
6058: v_extern tStringArray;
6059: v_quotes VARCHAR2(2);
6060: BEGIN