APPS.CZ_LOGIC_GEN dependencies on CZ_PROPERTIES

Line 778: p_property_id IN cz_properties.property_id%TYPE,

774:
775: sUnsatisfiedId VARCHAR2(4000);
776: ---------------------------------------------------------------------------------------
777: FUNCTION GET_PROPERTY_VALUE(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
778: p_property_id IN cz_properties.property_id%TYPE,
779: p_item_id IN cz_item_masters.item_id%TYPE,
780: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
781: RETURN VARCHAR2 IS
782: l_def_value cz_properties.def_value%TYPE;

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

776: ---------------------------------------------------------------------------------------
777: FUNCTION GET_PROPERTY_VALUE(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
778: p_property_id IN cz_properties.property_id%TYPE,
779: p_item_id IN cz_item_masters.item_id%TYPE,
780: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
781: RETURN VARCHAR2 IS
782: l_def_value cz_properties.def_value%TYPE;
783: l_tab tStringArray;
784: BEGIN

Line 782: l_def_value cz_properties.def_value%TYPE;

778: p_property_id IN cz_properties.property_id%TYPE,
779: p_item_id IN cz_item_masters.item_id%TYPE,
780: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
781: RETURN VARCHAR2 IS
782: l_def_value cz_properties.def_value%TYPE;
783: l_tab tStringArray;
784: BEGIN
785:
786: SELECT NVL(TO_CHAR(def_num_value), def_value), data_type INTO l_def_value, x_data_type

Line 787: FROM cz_properties

783: l_tab tStringArray;
784: BEGIN
785:
786: SELECT NVL(TO_CHAR(def_num_value), def_value), data_type INTO l_def_value, x_data_type
787: FROM cz_properties
788: WHERE property_id = p_property_id
789: AND deleted_flag = FLAG_NOT_DELETED;
790:
791: SELECT NVL(TO_CHAR(data_num_value), data_value) BULK COLLECT INTO l_tab

Line 2801: FROM cz_properties

2797: EXCEPTION
2798: WHEN OTHERS THEN
2799:
2800: SELECT name INTO errorMessage
2801: FROM cz_properties
2802: WHERE property_id = propertyId;
2803:
2804: localString := v_return;
2805: RAISE CZ_R_INCORRECT_DATA_TYPE;

Line 3035: FROM cz_properties

3031: EXCEPTION
3032: WHEN OTHERS THEN
3033:
3034: SELECT name INTO errorMessage
3035: FROM cz_properties
3036: WHERE property_id = propertyId;
3037:
3038: localString := v_return(i);
3039: RAISE CZ_R_INCORRECT_DATA_TYPE;

Line 3393: FROM cz_properties

3389: EXCEPTION
3390: WHEN OTHERS THEN
3391:
3392: SELECT name INTO errorMessage
3393: FROM cz_properties
3394: WHERE property_id = v_tExprPropertyId(j);
3395:
3396: RAISE CZ_R_INCORRECT_NUMERICLHS;
3397: END;

Line 5228: FROM cz_properties

5224: BEGIN
5225: IF(v_tExprPropertyId(propChild) IS NOT NULL)THEN
5226:
5227: SELECT data_type, name INTO DataType, PropName
5228: FROM cz_properties
5229: WHERE deleted_flag = FLAG_NOT_DELETED
5230: AND property_id = v_tExprPropertyId(propChild);
5231: nDebug := 7004043;
5232:

Line 5238: FROM cz_properties

5234:
5235: ELSIF(v_tExprType(propChild) = EXPR_LITERAL)THEN
5236:
5237: SELECT property_id, data_type, name INTO propertyId, DataType, PropName
5238: FROM cz_properties
5239: WHERE deleted_flag = FLAG_NOT_DELETED
5240: AND name = v_tExprDataValue(propChild);
5241:
5242: RETURN propertyId;

Line 5325: propName cz_properties.name%TYPE;

5321: nCount PLS_INTEGER;
5322: propertyId PLS_INTEGER;
5323: dataType PLS_INTEGER;
5324: propType PLS_INTEGER;
5325: propName cz_properties.name%TYPE;
5326: BEGIN
5327:
5328: nDebug := 7004020;
5329:

Line 5372: propName cz_properties.name%TYPE;

5368: propType PLS_INTEGER;
5369: jChild PLS_INTEGER;
5370: isLocal PLS_INTEGER := 0;
5371: LocalType PLS_INTEGER := DATA_TYPE_VOID;
5372: propName cz_properties.name%TYPE;
5373: v_extern tStringArray;
5374: v_quotes VARCHAR2(2);
5375: BEGIN
5376:

Line 5999: propName cz_properties.name%TYPE;

5995: nCount PLS_INTEGER;
5996: propertyId PLS_INTEGER;
5997: dataType PLS_INTEGER;
5998: propType PLS_INTEGER;
5999: propName cz_properties.name%TYPE;
6000: BEGIN
6001:
6002: nDebug := 7005020;
6003:

Line 6043: propName cz_properties.name%TYPE;

6039: FUNCTION EXAMINE_WHERE_CLAUSE(j IN PLS_INTEGER) RETURN VARCHAR2 IS
6040: argChild PLS_INTEGER;
6041: propType PLS_INTEGER;
6042: jChild PLS_INTEGER;
6043: propName cz_properties.name%TYPE;
6044: LocalType PLS_INTEGER := DATA_TYPE_VOID;
6045: v_extern tStringArray;
6046: v_quotes VARCHAR2(2);
6047: BEGIN