APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_PREF_HIERARCHIES

Line 1014: l_property_value hxc_pref_hierarchies.attribute1%type;

1010:
1011: l_pref_table HXC_PREFERENCE_EVALUATION.T_PREF_TABLE;
1012:
1013: l_prop_table t_prop_table;
1014: l_property_value hxc_pref_hierarchies.attribute1%type;
1015: l_property_name varchar2(60);
1016: l_property_column fnd_descr_flex_column_usages.application_column_name%type;
1017: l_index NUMBER;
1018: l_prop_index NUMBER :=1;

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

1297: ,p_stop_date in date
1298: ) return varchar2 is
1299:
1300: l_eval_date date;
1301: l_property_value hxc_pref_hierarchies.attribute1%type := null;
1302:
1303: Begin
1304:
1305: l_property_value := find_property_value(p_props,p_name,p_code,p_segment,p_start_date);

Line 1329: ,p_code in hxc_pref_hierarchies.code%type

1325:
1326: Function find_property_value
1327: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
1328: ,p_name in varchar2
1329: ,p_code in hxc_pref_hierarchies.code%type
1330: ,p_segment in number
1331: ,p_date in date
1332: ) return varchar2 is
1333:

Line 1346: l_property_value hxc_pref_hierarchies.attribute1%type;

1342: and descriptive_flex_context_code = p_code
1343: and application_column_name = 'ATTRIBUTE'||to_char(p_segment)
1344: and application_id = 809;
1345:
1346: l_property_value hxc_pref_hierarchies.attribute1%type;
1347: l_property_name varchar2(240) := null;
1348: l_index number;
1349: l_date_difference number;
1350: l_close_value hxc_pref_hierarchies.attribute1%type;

Line 1350: l_close_value hxc_pref_hierarchies.attribute1%type;

1346: l_property_value hxc_pref_hierarchies.attribute1%type;
1347: l_property_name varchar2(240) := null;
1348: l_index number;
1349: l_date_difference number;
1350: l_close_value hxc_pref_hierarchies.attribute1%type;
1351:
1352: Begin
1353:
1354: if(p_name is null) then