APPS.CZ_UI_GENERATOR dependencies on CZ_PROPERTIES

Line 7520: p_property_id IN cz_properties.property_id%TYPE,

7516: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7517: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
7518:
7519: FUNCTION get_Property_Value(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
7520: p_property_id IN cz_properties.property_id%TYPE,
7521: p_item_id IN cz_item_masters.item_id%TYPE)
7522: RETURN VARCHAR2 IS
7523: TYPE tStringArray IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
7524: v_def_value cz_properties.def_value%TYPE;

Line 7524: v_def_value cz_properties.def_value%TYPE;

7520: p_property_id IN cz_properties.property_id%TYPE,
7521: p_item_id IN cz_item_masters.item_id%TYPE)
7522: RETURN VARCHAR2 IS
7523: TYPE tStringArray IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
7524: v_def_value cz_properties.def_value%TYPE;
7525: v_tab tStringArray;
7526: BEGIN
7527:
7528: SELECT NVL(TO_CHAR(def_num_value), def_value) INTO v_def_value

Line 7529: FROM cz_properties

7525: v_tab tStringArray;
7526: BEGIN
7527:
7528: SELECT NVL(TO_CHAR(def_num_value), def_value) INTO v_def_value
7529: FROM cz_properties
7530: WHERE property_id = p_property_id AND deleted_flag = '0';
7531:
7532: SELECT NVL(TO_CHAR(data_num_value), data_value) BULK COLLECT INTO v_tab
7533: FROM cz_ps_prop_vals

Line 7572: v_property_id CZ_PROPERTIES.property_id%TYPE;

7568: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
7569:
7570: FUNCTION getTextByProperty(p_ps_node_id IN NUMBER,p_ui_node_id IN NUMBER) RETURN VARCHAR2 IS
7571:
7572: v_property_id CZ_PROPERTIES.property_id%TYPE;
7573: v_item_id CZ_PS_NODES.item_id%TYPE;
7574:
7575: BEGIN -- sselahi
7576: v_property_id:=TO_NUMBER(getUseLabelsProperty(p_ui_node_id,'LabelProperty'));