DBA Data[Home] [Help]

APPS.HXC_SETUP_VALIDATION_PKG dependencies on HXC_PREFERENCE_EVALUATION

Line 36: , p_master_pref_table IN OUT NOCOPY hxc_preference_evaluation.t_pref_table

32: , p_timecard_bb_id NUMBER
33: , p_timecard_bb_ovn NUMBER
34: , p_start_date DATE
35: , p_end_date DATE
36: , p_master_pref_table IN OUT NOCOPY hxc_preference_evaluation.t_pref_table
37: , p_messages IN OUT NOCOPY hxc_message_table_type ) IS
38:
39: CURSOR csr_get_retrieval_rules ( p_rtr_grp_id NUMBER ) IS
40: SELECT

Line 142: l_pref_table hxc_preference_evaluation.t_pref_table;

138:
139: l_proc VARCHAR2(72);
140:
141: l_index BINARY_INTEGER;
142: l_pref_table hxc_preference_evaluation.t_pref_table;
143:
144: l_id NUMBER(15);
145: l_pref_code VARCHAR2(30);
146:

Line 238: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

234:
235: -- now get the retrieval rule grp id and application set id
236: -- based on the resource id
237:
238: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
239: p_preference_code => 'TS_PER_APPLICATION_SET',
240: p_start_evaluation_date => l_timecard_info_rec.start_date,
241: p_end_evaluation_date => l_timecard_info_rec.end_date,
242: p_sorted_pref_table => l_pref_table,

Line 250: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

246: if g_debug then
247: hr_utility.trace('gaz - app set id is '||to_char(l_app_set_id));
248: end if;
249:
250: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
251: p_preference_code => 'TS_PER_RETRIEVAL_RULES',
252: p_start_evaluation_date => l_timecard_info_rec.start_date,
253: p_end_evaluation_date => l_timecard_info_rec.end_date,
254: p_sorted_pref_table => l_pref_table,

Line 262: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

258: if g_debug then
259: hr_utility.trace('gaz - rtr grp id is '||to_char(l_rtr_grp_id));
260: end if;
261:
262: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
263: p_preference_code => 'TC_W_RULES_EVALUATION',
264: p_start_evaluation_date => l_timecard_info_rec.start_date,
265: p_end_evaluation_date => l_timecard_info_rec.end_date,
266: p_sorted_pref_table => l_pref_table,

Line 275: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

271: if g_debug then
272: hr_utility.trace('gaz - otm explosion is '||l_otm_explosion);
273: end if;
274:
275: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
276: p_preference_code => 'TS_PER_APPROVAL_PERIODS',
277: p_start_evaluation_date => l_timecard_info_rec.start_date,
278: p_end_evaluation_date => l_timecard_info_rec.end_date,
279: p_sorted_pref_table => l_pref_table,

Line 287: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

283: if g_debug then
284: hr_utility.trace('gaz - approval period set id is '||to_char(l_approval_period_set_id));
285: end if;
286:
287: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
288: p_preference_code => 'TS_PER_APPROVAL_STYLE',
289: p_start_evaluation_date => l_timecard_info_rec.start_date,
290: p_end_evaluation_date => l_timecard_info_rec.end_date,
291: p_sorted_pref_table => l_pref_table,

Line 301: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

297: hr_utility.trace('gaz - approval style id is '||to_char(l_approval_style_id));
298: hr_utility.trace('gaz - override approval style id is '||to_char(l_override_approval_style_id));
299: end if;
300:
301: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
302: p_preference_code => 'TC_W_TCRD_ST_ALW_EDITS',
303: p_start_evaluation_date => l_timecard_info_rec.start_date,
304: p_end_evaluation_date => l_timecard_info_rec.end_date,
305: p_sorted_pref_table => l_pref_table,

Line 319: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

315: end if;
316:
317: --ELP Validation
318:
319: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
320: p_preference_code => 'TS_PER_ELP_RULES',
321: p_start_evaluation_date => l_timecard_info_rec.start_date,
322: p_end_evaluation_date => l_timecard_info_rec.end_date,
323: p_sorted_pref_table => l_pref_table,

Line 333: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

329: end if;
330:
331: -- Override Approval Validation
332:
333: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
334: p_preference_code => 'TC_W_APRVR_DFLT_OVRD',
335: p_start_evaluation_date => l_timecard_info_rec.start_date,
336: p_end_evaluation_date => l_timecard_info_rec.end_date,
337: p_sorted_pref_table => l_pref_table,

Line 342: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

338: p_master_pref_table => p_master_pref_table );
339:
340: l_default_override_approver_id := TO_NUMBER(l_pref_table(1).attribute1);
341:
342: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
343: p_preference_code => 'TC_W_APRVR_ENBLE_OVRD',
344: p_start_evaluation_date => l_timecard_info_rec.start_date,
345: p_end_evaluation_date => l_timecard_info_rec.end_date,
346: p_sorted_pref_table => l_pref_table,

Line 351: hxc_preference_evaluation.clear_sort_pref_table_cache;

347: p_master_pref_table => p_master_pref_table );
348:
349: l_can_enter_override_approver := l_pref_table(1).attribute1;
350:
351: hxc_preference_evaluation.clear_sort_pref_table_cache;
352:
353:
354: IF l_past_limit_date is null THEN
355: l_past_limit_date := '0001/01/01';

Line 803: hxc_preference_evaluation.resource_preferences

799: -- | |
800: -- +---------------------------------------------------------------------------+
801:
802: l_cla_prefs_ok := FALSE;
803: hxc_preference_evaluation.resource_preferences
804: (p_resource_id => l_timecard_info_rec.resource_id,
805: p_preference_code => 'TC_W_FLOW_PROCESS_NAME',
806: p_start_evaluation_date => l_timecard_info_rec.start_date,
807: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 816: hxc_preference_evaluation.resource_preferences

812: -- For AUDIT Flow:
813: -- Audit Layout Must be set
814: -- Delete is *NOT* allowed
815: -- CLA TERG must be specified
816: hxc_preference_evaluation.resource_preferences
817: (p_resource_id => l_timecard_info_rec.resource_id,
818: p_preference_code => 'TC_W_TCRD_LAYOUT',
819: p_start_evaluation_date => l_timecard_info_rec.start_date,
820: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 826: hxc_preference_evaluation.resource_preferences

822: p_master_pref_table => p_master_pref_table );
823:
824: if ( l_pref_table(1).attribute6 IS NOT NULL ) then
825: --Audit Layout is Not Null
826: hxc_preference_evaluation.resource_preferences
827: (p_resource_id => l_timecard_info_rec.resource_id,
828: p_preference_code => 'TC_W_DELETE_ALLOW',
829: p_start_evaluation_date => l_timecard_info_rec.start_date,
830: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 835: hxc_preference_evaluation.resource_preferences

831: p_sorted_pref_table => l_pref_table,
832: p_master_pref_table => p_master_pref_table );
833:
834: if(l_pref_table(1).attribute1 = 'N' )then
835: hxc_preference_evaluation.resource_preferences
836: (p_resource_id => l_timecard_info_rec.resource_id,
837: p_preference_code => 'TS_PER_AUDIT_REQUIREMENTS',
838: p_start_evaluation_date => l_timecard_info_rec.start_date,
839: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 870: hxc_preference_evaluation.resource_preferences

866: --
867: -- Non Audit flow:
868: -- Audit layout must be null
869: -- CLA TERG must be null
870: hxc_preference_evaluation.resource_preferences
871: (p_resource_id => l_timecard_info_rec.resource_id,
872: p_preference_code => 'TC_W_TCRD_LAYOUT',
873: p_start_evaluation_date => l_timecard_info_rec.start_date,
874: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 880: hxc_preference_evaluation.resource_preferences

876: p_master_pref_table => p_master_pref_table );
877:
878: if ( l_pref_table(1).attribute6 is null ) then
879: --Audit Layout is null
880: hxc_preference_evaluation.resource_preferences
881: (p_resource_id => l_timecard_info_rec.resource_id,
882: p_preference_code => 'TS_PER_AUDIT_REQUIREMENTS',
883: p_start_evaluation_date => l_timecard_info_rec.start_date,
884: p_end_evaluation_date => l_timecard_info_rec.end_date,