APPS.HXC_TIMECARD_PROPERTIES dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 10: ,column_name fnd_descr_flex_column_usages.application_column_name%type

6: g_debug boolean := hr_utility.debug_enabled;
7:
8: Type property_definition is Record
9: (property_name varchar2(60)
10: ,column_name fnd_descr_flex_column_usages.application_column_name%type
11: );
12:
13: Type property_definition_tbl is table of property_definition index by binary_integer;
14:

Line 18: (context_code fnd_descr_flex_column_usages.descriptive_flex_context_code%type

14:
15: g_property_definitions property_definition_tbl;
16:
17: Type context_definition is Record
18: (context_code fnd_descr_flex_column_usages.descriptive_flex_context_code%type
19: ,start_index number
20: );
21:
22: Type context_definition_tbl is table of context_definition index by binary_integer;

Line 36: (p_context_code in fnd_descr_flex_column_usages.descriptive_flex_context_code%type

32: type asg_number is table of per_all_assignments_f.assignment_number%type index by binary_integer;
33: type asg_status is table of per_assignment_status_types.per_system_status%type index by binary_integer;
34:
35: function find_segment
36: (p_context_code in fnd_descr_flex_column_usages.descriptive_flex_context_code%type
37: ,p_segment_name in fnd_descr_flex_column_usages.end_user_column_name%type
38: ) return varchar2 is
39:
40: cursor c_segment_name

Line 37: ,p_segment_name in fnd_descr_flex_column_usages.end_user_column_name%type

33: type asg_status is table of per_assignment_status_types.per_system_status%type index by binary_integer;
34:
35: function find_segment
36: (p_context_code in fnd_descr_flex_column_usages.descriptive_flex_context_code%type
37: ,p_segment_name in fnd_descr_flex_column_usages.end_user_column_name%type
38: ) return varchar2 is
39:
40: cursor c_segment_name
41: (p_cc in fnd_descr_flex_column_usages.descriptive_flex_context_code%type

Line 41: (p_cc in fnd_descr_flex_column_usages.descriptive_flex_context_code%type

37: ,p_segment_name in fnd_descr_flex_column_usages.end_user_column_name%type
38: ) return varchar2 is
39:
40: cursor c_segment_name
41: (p_cc in fnd_descr_flex_column_usages.descriptive_flex_context_code%type
42: ,p_sn in fnd_descr_flex_column_usages.end_user_column_name%type
43: ) is
44: select application_column_name
45: from fnd_descr_flex_column_usages

Line 42: ,p_sn in fnd_descr_flex_column_usages.end_user_column_name%type

38: ) return varchar2 is
39:
40: cursor c_segment_name
41: (p_cc in fnd_descr_flex_column_usages.descriptive_flex_context_code%type
42: ,p_sn in fnd_descr_flex_column_usages.end_user_column_name%type
43: ) is
44: select application_column_name
45: from fnd_descr_flex_column_usages
46: where descriptive_flexfield_name = 'OTC PREFERENCES'

Line 45: from fnd_descr_flex_column_usages

41: (p_cc in fnd_descr_flex_column_usages.descriptive_flex_context_code%type
42: ,p_sn in fnd_descr_flex_column_usages.end_user_column_name%type
43: ) is
44: select application_column_name
45: from fnd_descr_flex_column_usages
46: where descriptive_flexfield_name = 'OTC PREFERENCES'
47: and descriptive_flex_context_code = p_cc
48: and end_user_column_name = p_sn
49: and application_id = 809;

Line 275: (p_context_code in fnd_descr_flex_column_usages.descriptive_flex_context_code%type

271:
272: end cache_property_definitions;
273:
274: procedure find_name_indices_for_context
275: (p_context_code in fnd_descr_flex_column_usages.descriptive_flex_context_code%type
276: ,p_for_timecard in boolean
277: ,p_start_index out nocopy number
278: ,p_stop_index out nocopy number
279: ) is

Line 1016: l_property_column fnd_descr_flex_column_usages.application_column_name%type;

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;
1019: l_date DATE;
1020:

Line 1340: from fnd_descr_flex_column_usages

1336: ,p_segment in number
1337: ) is
1338: select replace(initcap(replace(descriptive_flex_context_code,'_',' ')),' ')
1339: ||replace(initcap(replace(end_user_column_name,'_',' ')),' ') property_name
1340: from fnd_descr_flex_column_usages
1341: where descriptive_flexfield_name = 'OTC PREFERENCES'
1342: and descriptive_flex_context_code = p_code
1343: and application_column_name = 'ATTRIBUTE'||to_char(p_segment)
1344: and application_id = 809;