7: --
8:
9: c_attribute_category constant varchar2(18) := 'ATTRIBUTE_CATEGORY';
10:
11: g_debug boolean := hr_utility.debug_enabled;
12:
13: FUNCTION get_updatable_components RETURN components_tab IS
14:
15: CURSOR csr_get_layout_components ( p_layout_id NUMBER ) IS
51: l_ind PLS_INTEGER := 1;
52:
53: BEGIN
54:
55: g_debug := hr_utility.debug_enabled;
56:
57: IF g_debug THEN
58: hr_utility.trace('Entering get updatable comps');
59:
54:
55: g_debug := hr_utility.debug_enabled;
56:
57: IF g_debug THEN
58: hr_utility.trace('Entering get updatable comps');
59:
60: hr_utility.trace('in layout comps');
61: hr_utility.trace('resource id is '||to_char(l_resource_id));
62: END IF;
56:
57: IF g_debug THEN
58: hr_utility.trace('Entering get updatable comps');
59:
60: hr_utility.trace('in layout comps');
61: hr_utility.trace('resource id is '||to_char(l_resource_id));
62: END IF;
63:
64: l_layout_id := hxc_preference_evaluation.resource_preferences(l_resource_id, 'TC_W_TCRD_LAYOUT', 1);
57: IF g_debug THEN
58: hr_utility.trace('Entering get updatable comps');
59:
60: hr_utility.trace('in layout comps');
61: hr_utility.trace('resource id is '||to_char(l_resource_id));
62: END IF;
63:
64: l_layout_id := hxc_preference_evaluation.resource_preferences(l_resource_id, 'TC_W_TCRD_LAYOUT', 1);
65:
119:
120: END LOOP;
121:
122: IF g_debug THEN
123: hr_utility.trace('Leaving get updatable comps');
124: END IF;
125:
126: RETURN l_components_tab;
127:
148:
149:
150:
151: IF g_debug THEN
152: hr_utility.trace('In update ok');
153: END IF;
154:
155: FOR x IN p_comps_tab.FIRST .. p_comps_tab.LAST
156: LOOP
155: FOR x IN p_comps_tab.FIRST .. p_comps_tab.LAST
156: LOOP
157:
158: IF g_debug THEN
159: hr_utility.trace('p comps is '||p_comps_tab(x).bld_blk_info_type ||' : '||p_comps_tab(x).segment );
160: END IF;
161:
162: IF ( ( p_comps_tab(x).bld_blk_info_type = p_att_rec.bld_blk_info_type ) AND
163: ( p_comps_tab(x).segment = p_att_rec.segment ) )
163: ( p_comps_tab(x).segment = p_att_rec.segment ) )
164: THEN
165:
166: IF g_debug THEN
167: hr_utility.trace('Cannot update !!!!');
168: END IF;
169:
170: RETURN FALSE;
171:
176: -- See bug 4269761
177: --
178: if(p_att_rec.segment = c_attribute_category) then
179: IF g_debug THEN
180: hr_utility.trace('Can not update attribute category!');
181: END IF;
182: return false;
183: end if;
184:
184:
185: END LOOP;
186:
187: IF g_debug THEN
188: hr_utility.trace('Can update !!!!');
189: END IF;
190:
191: RETURN TRUE;
192:
194:
195:
196: BEGIN
197:
198: g_debug := hr_utility.debug_enabled;
199:
200: IF g_debug THEN
201: hr_utility.trace('Entering reset non updatable comps');
202: END IF;
197:
198: g_debug := hr_utility.debug_enabled;
199:
200: IF g_debug THEN
201: hr_utility.trace('Entering reset non updatable comps');
202: END IF;
203:
204: l_comps_tab := hxc_layout_utils_pkg.get_updatable_components;
205:
220:
221: END LOOP;
222:
223: IF g_debug THEN
224: hr_utility.trace('Leaving reset non updatable comps');
225: END IF;
226:
227: END reset_non_updatable_comps;
228: