APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_PREFERENCE_EVALUATION

Line 1266: l_pref_table hxc_preference_evaluation.t_pref_table;

1262: ) IS
1263: l_index NUMBER
1264: /*ADVICE(1197): NUMBER has no precision [315] */
1265: := 0;
1266: l_pref_table hxc_preference_evaluation.t_pref_table;
1267:
1268:
1269: /*
1270: CURSOR c_emp_hireinfo (

Line 1399: hxc_preference_evaluation.resource_preferences (

1395: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');
1396:
1397: IF p_resource_id IS NOT NULL THEN
1398: IF NOT g_resource_perftab.EXISTS (p_resource_id) THEN
1399: hxc_preference_evaluation.resource_preferences (
1400: p_resource_id,
1401: 'TC_W_TCRD_LAYOUT,TS_PER_APPROVAL_STYLE,TC_W_ALW_NEG_TIME,TC_W_TCRD_PERIOD,TC_W_TCRD_ST_ALW_EDITS,TS_PER_AUDIT_REQUIREMENTS',
1402: l_pref_table
1403: );

Line 2817: l_pref_table hxc_preference_evaluation.t_pref_table;

2813: ) IS
2814: l_resource_pref_index NUMBER
2815: /*ADVICE(2315): NUMBER has no precision [315] */
2816: ;
2817: l_pref_table hxc_preference_evaluation.t_pref_table;
2818: l_resource_table hxc_preference_evaluation.t_resource_pref_table;
2819: l_query_append VARCHAR2 (32000);
2820: /*ADVICE(2320): VARCHAR2 declaration with length greater than 500 characters [307] */
2821:

Line 2818: l_resource_table hxc_preference_evaluation.t_resource_pref_table;

2814: l_resource_pref_index NUMBER
2815: /*ADVICE(2315): NUMBER has no precision [315] */
2816: ;
2817: l_pref_table hxc_preference_evaluation.t_pref_table;
2818: l_resource_table hxc_preference_evaluation.t_resource_pref_table;
2819: l_query_append VARCHAR2 (32000);
2820: /*ADVICE(2320): VARCHAR2 declaration with length greater than 500 characters [307] */
2821:
2822:

Line 2858: hxc_preference_evaluation.resource_prefs_bulk (

2854: || p_group_id || ' ) ';
2855: l_pref_table.DELETE;
2856: l_resource_table.DELETE;
2857: g_start_stop_pref_cache.DELETE;
2858: hxc_preference_evaluation.resource_prefs_bulk (
2859: p_evaluation_date => SYSDATE,
2860: p_pref_table => l_pref_table,
2861: p_resource_pref_table => l_resource_table,
2862: p_resource_sql => l_query_append

Line 2943: hxc_preference_evaluation.t_pref_table;

2939: AND p_business_group_id = NVL (a.business_group_id, p_business_group_id) order by c.name);
2940: /*end of fix 5083261*/
2941: l_pref_resource
2942: /*ADVICE(2415): Unreferenced variable [553] */
2943: hxc_preference_evaluation.t_pref_table;
2944: l_periodname_list
2945: /*ADVICE(2418): Unreferenced variable [553] */
2946: hxc_timekeeper_utilities.t_group_list;
2947: l_pref_index

Line 3075: l_pref_table hxc_preference_evaluation.t_pref_table;

3071: p_timekeeper_id IN NUMBER,
3072: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,
3073: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list
3074: ) IS
3075: l_pref_table hxc_preference_evaluation.t_pref_table;
3076: l_index NUMBER
3077: /*ADVICE(2548): NUMBER has no precision [315] */
3078: := 0;
3079: m_alias_typ VARCHAR2 (80) := NULL;

Line 3115: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, l_pref_table, SYSDATE);

3111: WHERE typ.person_type_id = ptu.person_type_id
3112: AND SYSDATE BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3113: AND ptu.person_id = p_person_id;
3114: BEGIN
3115: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, l_pref_table, SYSDATE);
3116: OPEN c_get_type (p_timekeeper_id);
3117: FETCH c_get_type INTO l_person_type;
3118: CLOSE c_get_type;
3119: l_index := l_pref_table.FIRST;