APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_PREF_HIERARCHIES

Line 987: l_property_value hxc_pref_hierarchies.attribute1%type;

983:
984: l_pref_table HXC_PREFERENCE_EVALUATION.T_PREF_TABLE;
985:
986: l_prop_table t_prop_table;
987: l_property_value hxc_pref_hierarchies.attribute1%type;
988: l_property_name varchar2(60);
989: l_property_column fnd_descr_flex_column_usages.application_column_name%type;
990: l_index NUMBER;
991: l_prop_index NUMBER :=1;

Line 1178: l_property_value hxc_pref_hierarchies.attribute1%type := null;

1174: ,p_stop_date in date
1175: ) return varchar2 is
1176:
1177: l_eval_date date;
1178: l_property_value hxc_pref_hierarchies.attribute1%type := null;
1179:
1180: Begin
1181:
1182: l_property_value := find_property_value(p_props,p_name,p_code,p_segment,p_start_date);

Line 1206: ,p_code in hxc_pref_hierarchies.code%type

1202:
1203: Function find_property_value
1204: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
1205: ,p_name in varchar2
1206: ,p_code in hxc_pref_hierarchies.code%type
1207: ,p_segment in number
1208: ,p_date in date
1209: ) return varchar2 is
1210:

Line 1223: l_property_value hxc_pref_hierarchies.attribute1%type;

1219: and descriptive_flex_context_code = p_code
1220: and application_column_name = 'ATTRIBUTE'||to_char(p_segment)
1221: and application_id = 809;
1222:
1223: l_property_value hxc_pref_hierarchies.attribute1%type;
1224: l_property_name varchar2(240) := null;
1225: l_index number;
1226: l_date_difference number;
1227: l_close_value hxc_pref_hierarchies.attribute1%type;

Line 1227: l_close_value hxc_pref_hierarchies.attribute1%type;

1223: l_property_value hxc_pref_hierarchies.attribute1%type;
1224: l_property_name varchar2(240) := null;
1225: l_index number;
1226: l_date_difference number;
1227: l_close_value hxc_pref_hierarchies.attribute1%type;
1228:
1229: Begin
1230:
1231: if(p_name is null) then