1447: PROCEDURE update_value (
1448: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
1449: p_index IN NUMBER,
1450: p_segment IN hxc_mapping_components.SEGMENT%TYPE,
1451: p_value IN hxc_time_attributes.attribute1%TYPE
1452: )
1453: IS
1454: BEGIN
1455: IF (p_segment = 'ATTRIBUTE1')
1550:
1551: PROCEDURE set_new_attribute_value (
1552: p_attribute IN OUT NOCOPY hxc_attribute_type,
1553: p_segment IN hxc_mapping_components.SEGMENT%TYPE,
1554: p_value IN hxc_time_attributes.attribute1%TYPE,
1555: p_changed IN hxc_time_attributes.attribute1%TYPE
1556: )
1557: IS
1558: BEGIN
1551: PROCEDURE set_new_attribute_value (
1552: p_attribute IN OUT NOCOPY hxc_attribute_type,
1553: p_segment IN hxc_mapping_components.SEGMENT%TYPE,
1554: p_value IN hxc_time_attributes.attribute1%TYPE,
1555: p_changed IN hxc_time_attributes.attribute1%TYPE
1556: )
1557: IS
1558: BEGIN
1559: IF (p_segment = 'ATTRIBUTE1')
2284: l_proc VARCHAR2 (72);
2285: l_index PLS_INTEGER;
2286:
2287: CURSOR find_attribute (
2288: p_attr_id hxc_time_attributes.time_attribute_id%TYPE
2289: )
2290: IS
2291: SELECT time_attribute_id, attribute_category, attribute1,
2292: attribute2, attribute3, attribute4, attribute5, attribute6,
2296: attribute19, attribute20, attribute21, attribute22,
2297: attribute23, attribute24, attribute25, attribute26,
2298: attribute27, attribute28, attribute29, attribute30,
2299: MAX (object_version_number)
2300: FROM hxc_time_attributes
2301: WHERE time_attribute_id = p_attr_id
2302: GROUP BY time_attribute_id,
2303: attribute_category,
2304: attribute1,
2771: --
2772: -----------------------------------------------------------------------------
2773: FUNCTION get_index_in_attr_table (
2774: p_attr_table IN hxc_self_service_time_deposit.app_attributes_info,
2775: p_attr_id_to_find IN hxc_time_attributes.time_attribute_id%TYPE,
2776: p_attribute_name_to_find IN hxc_mapping_components.field_name%TYPE
2777: )
2778: RETURN PLS_INTEGER
2779: IS