APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_LAYOUT_COMP_QUALIFIERS

Line 15: ATTRIBUTE_CATEGORY HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE26%type,

11:
12: -- Types created for the Zero Hrs Template Enhancement.
13:
14: TYPE v_att_ids IS RECORD (
15: ATTRIBUTE_CATEGORY HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE26%type,
16: ATTRIBUTE_COLUMN_NAME HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE27%type
17: );
18:
19: TYPE r_att_ids IS TABLE OF v_att_ids

Line 16: ATTRIBUTE_COLUMN_NAME HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE27%type

12: -- Types created for the Zero Hrs Template Enhancement.
13:
14: TYPE v_att_ids IS RECORD (
15: ATTRIBUTE_CATEGORY HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE26%type,
16: ATTRIBUTE_COLUMN_NAME HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE27%type
17: );
18:
19: TYPE r_att_ids IS TABLE OF v_att_ids
20: INDEX BY BINARY_INTEGER;

Line 54: from HXC_LAYOUT_COMP_QUALIFIERS qualifiers

50: p_att_ids in out nocopy r_att_ids)
51: IS
52: cursor cur_layout_attributes(P_LAYOUT_ID in varchar2) is
53: select QUALIFIER_ATTRIBUTE26,UPPER(QUALIFIER_ATTRIBUTE27)
54: from HXC_LAYOUT_COMP_QUALIFIERS qualifiers
55: where
56: exists
57: (select LAYOUT_COMPONENT_ID from HXC_LAYOUT_COMPONENTS COMPONENTS where
58: layout_id =P_LAYOUT_ID and COMPONENTS.LAYOUT_COMPONENT_ID = qualifiers.LAYOUT_COMPONENT_ID )

Line 60: l_attribute HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE26%type;

56: exists
57: (select LAYOUT_COMPONENT_ID from HXC_LAYOUT_COMPONENTS COMPONENTS where
58: layout_id =P_LAYOUT_ID and COMPONENTS.LAYOUT_COMPONENT_ID = qualifiers.LAYOUT_COMPONENT_ID )
59: and UPPER(QUALIFIER_ATTRIBUTE27) LIKE 'ATTRIBUTE%' and QUALIFIER_ATTRIBUTE_CATEGORY<>'HIDDEN_FIELD';
60: l_attribute HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE26%type;
61: l_attribute_category HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE27%type;
62: l_index number;
63: begin
64:

Line 61: l_attribute_category HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE27%type;

57: (select LAYOUT_COMPONENT_ID from HXC_LAYOUT_COMPONENTS COMPONENTS where
58: layout_id =P_LAYOUT_ID and COMPONENTS.LAYOUT_COMPONENT_ID = qualifiers.LAYOUT_COMPONENT_ID )
59: and UPPER(QUALIFIER_ATTRIBUTE27) LIKE 'ATTRIBUTE%' and QUALIFIER_ATTRIBUTE_CATEGORY<>'HIDDEN_FIELD';
60: l_attribute HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE26%type;
61: l_attribute_category HXC_LAYOUT_COMP_QUALIFIERS.QUALIFIER_ATTRIBUTE27%type;
62: l_index number;
63: begin
64:
65: l_index := 0;