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 144: l_pref_table hxc_preference_evaluation.t_pref_table;

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

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

248:
249: -- now get the retrieval rule grp id and application set id
250: -- based on the resource id
251:
252: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
253: p_preference_code => 'TS_PER_APPLICATION_SET',
254: p_start_evaluation_date => l_timecard_info_rec.start_date,
255: p_end_evaluation_date => l_timecard_info_rec.end_date,
256: p_sorted_pref_table => l_pref_table,

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

260: if g_debug then
261: hr_utility.trace('OTL Setup - app set id is '||to_char(l_app_set_id));
262: end if;
263:
264: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
265: p_preference_code => 'TS_PER_RETRIEVAL_RULES',
266: p_start_evaluation_date => l_timecard_info_rec.start_date,
267: p_end_evaluation_date => l_timecard_info_rec.end_date,
268: p_sorted_pref_table => l_pref_table,

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

276: -- OTL - ABS Integration
277:
278: IF NVL(FND_PROFILE.VALUE('HR_ABS_OTL_INTEGRATION'),'N') = 'Y'
279: THEN
280: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
281: p_preference_code => 'TS_ABS_PREFERENCES',
282: p_start_evaluation_date => l_timecard_info_rec.start_date,
283: p_end_evaluation_date => l_timecard_info_rec.end_date,
284: p_sorted_pref_table => l_pref_table,

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

312: hr_utility.trace('PA-PAY> l_timecard_info_rec.start_date ::'||l_timecard_info_rec.start_date);
313: hr_utility.trace('PA-PAY> l_timecard_info_rec.end_date ::'||l_timecard_info_rec.end_date);
314: END IF;
315:
316: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
317: p_preference_code => 'TS_PA_PAY_INTG',
318: p_start_evaluation_date => l_timecard_info_rec.start_date,
319: p_end_evaluation_date => l_timecard_info_rec.end_date,
320: p_sorted_pref_table => l_pref_table,

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

346: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is false');
347: end if;
348:
349:
350: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
351: p_preference_code => 'TC_W_RULES_EVALUATION',
352: p_start_evaluation_date => l_timecard_info_rec.start_date,
353: p_end_evaluation_date => l_timecard_info_rec.end_date,
354: p_sorted_pref_table => l_pref_table,

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

359: if g_debug then
360: hr_utility.trace('OTL Setup - otm explosion is '||l_otm_explosion);
361: end if;
362:
363: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
364: p_preference_code => 'TS_PER_APPROVAL_PERIODS',
365: p_start_evaluation_date => l_timecard_info_rec.start_date,
366: p_end_evaluation_date => l_timecard_info_rec.end_date,
367: p_sorted_pref_table => l_pref_table,

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

371: if g_debug then
372: hr_utility.trace('OTL Setup - approval period set id is '||to_char(l_approval_period_set_id));
373: end if;
374:
375: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
376: p_preference_code => 'TS_PER_APPROVAL_STYLE',
377: p_start_evaluation_date => l_timecard_info_rec.start_date,
378: p_end_evaluation_date => l_timecard_info_rec.end_date,
379: p_sorted_pref_table => l_pref_table,

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

385: hr_utility.trace('OTL Setup - approval style id is '||to_char(l_approval_style_id));
386: hr_utility.trace('OTL Setup - override approval style id is '||to_char(l_override_approval_style_id));
387: end if;
388:
389: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
390: p_preference_code => 'TC_W_TCRD_ST_ALW_EDITS',
391: p_start_evaluation_date => l_timecard_info_rec.start_date,
392: p_end_evaluation_date => l_timecard_info_rec.end_date,
393: p_sorted_pref_table => l_pref_table,

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

403: end if;
404:
405: --ELP Validation
406:
407: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
408: p_preference_code => 'TS_PER_ELP_RULES',
409: p_start_evaluation_date => l_timecard_info_rec.start_date,
410: p_end_evaluation_date => l_timecard_info_rec.end_date,
411: p_sorted_pref_table => l_pref_table,

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

417: end if;
418:
419: -- Override Approval Validation
420:
421: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
422: p_preference_code => 'TC_W_APRVR_DFLT_OVRD',
423: p_start_evaluation_date => l_timecard_info_rec.start_date,
424: p_end_evaluation_date => l_timecard_info_rec.end_date,
425: p_sorted_pref_table => l_pref_table,

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

426: p_master_pref_table => p_master_pref_table );
427:
428: l_default_override_approver_id := TO_NUMBER(l_pref_table(1).attribute1);
429:
430: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
431: p_preference_code => 'TC_W_APRVR_ENBLE_OVRD',
432: p_start_evaluation_date => l_timecard_info_rec.start_date,
433: p_end_evaluation_date => l_timecard_info_rec.end_date,
434: p_sorted_pref_table => l_pref_table,

Line 439: hxc_preference_evaluation.clear_sort_pref_table_cache;

435: p_master_pref_table => p_master_pref_table );
436:
437: l_can_enter_override_approver := l_pref_table(1).attribute1;
438:
439: hxc_preference_evaluation.clear_sort_pref_table_cache;
440:
441:
442: IF l_past_limit_date is null THEN
443: l_past_limit_date := '0001/01/01';

Line 969: hxc_preference_evaluation.resource_preferences

965: -- | |
966: -- +---------------------------------------------------------------------------+
967:
968: l_cla_prefs_ok := FALSE;
969: hxc_preference_evaluation.resource_preferences
970: (p_resource_id => l_timecard_info_rec.resource_id,
971: p_preference_code => 'TC_W_FLOW_PROCESS_NAME',
972: p_start_evaluation_date => l_timecard_info_rec.start_date,
973: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 982: hxc_preference_evaluation.resource_preferences

978: -- For AUDIT Flow:
979: -- Audit Layout Must be set
980: -- Delete is *NOT* allowed
981: -- CLA TERG must be specified
982: hxc_preference_evaluation.resource_preferences
983: (p_resource_id => l_timecard_info_rec.resource_id,
984: p_preference_code => 'TC_W_TCRD_LAYOUT',
985: p_start_evaluation_date => l_timecard_info_rec.start_date,
986: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 992: hxc_preference_evaluation.resource_preferences

988: p_master_pref_table => p_master_pref_table );
989:
990: if ( l_pref_table(1).attribute6 IS NOT NULL ) then
991: --Audit Layout is Not Null
992: hxc_preference_evaluation.resource_preferences
993: (p_resource_id => l_timecard_info_rec.resource_id,
994: p_preference_code => 'TC_W_DELETE_ALLOW',
995: p_start_evaluation_date => l_timecard_info_rec.start_date,
996: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 1001: hxc_preference_evaluation.resource_preferences

997: p_sorted_pref_table => l_pref_table,
998: p_master_pref_table => p_master_pref_table );
999:
1000: if(l_pref_table(1).attribute1 = 'N' )then
1001: hxc_preference_evaluation.resource_preferences
1002: (p_resource_id => l_timecard_info_rec.resource_id,
1003: p_preference_code => 'TS_PER_AUDIT_REQUIREMENTS',
1004: p_start_evaluation_date => l_timecard_info_rec.start_date,
1005: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 1036: hxc_preference_evaluation.resource_preferences

1032: --
1033: -- Non Audit flow:
1034: -- Audit layout must be null
1035: -- CLA TERG must be null
1036: hxc_preference_evaluation.resource_preferences
1037: (p_resource_id => l_timecard_info_rec.resource_id,
1038: p_preference_code => 'TC_W_TCRD_LAYOUT',
1039: p_start_evaluation_date => l_timecard_info_rec.start_date,
1040: p_end_evaluation_date => l_timecard_info_rec.end_date,

Line 1046: hxc_preference_evaluation.resource_preferences

1042: p_master_pref_table => p_master_pref_table );
1043:
1044: if ( l_pref_table(1).attribute6 is null ) then
1045: --Audit Layout is null
1046: hxc_preference_evaluation.resource_preferences
1047: (p_resource_id => l_timecard_info_rec.resource_id,
1048: p_preference_code => 'TS_PER_AUDIT_REQUIREMENTS',
1049: p_start_evaluation_date => l_timecard_info_rec.start_date,
1050: p_end_evaluation_date => l_timecard_info_rec.end_date,