DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_PREFERENCE_EVALUATION

Line 1284: l_pref_table hxc_preference_evaluation.t_pref_table;

1280: ) IS
1281: l_index NUMBER
1282: /*ADVICE(1197): NUMBER has no precision [315] */
1283: := 0;
1284: l_pref_table hxc_preference_evaluation.t_pref_table;
1285:
1286:
1287: /*
1288: CURSOR c_emp_hireinfo (

Line 1417: hxc_preference_evaluation.resource_preferences (

1413: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');
1414:
1415: IF p_resource_id IS NOT NULL THEN
1416: IF NOT g_resource_perftab.EXISTS (p_resource_id) THEN
1417: hxc_preference_evaluation.resource_preferences (
1418: p_resource_id,
1419: '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',
1420: l_pref_table
1421: );

Line 2835: l_pref_table hxc_preference_evaluation.t_pref_table;

2831: ) IS
2832: l_resource_pref_index NUMBER
2833: /*ADVICE(2315): NUMBER has no precision [315] */
2834: ;
2835: l_pref_table hxc_preference_evaluation.t_pref_table;
2836: l_resource_table hxc_preference_evaluation.t_resource_pref_table;
2837: l_query_append VARCHAR2 (32000);
2838: /*ADVICE(2320): VARCHAR2 declaration with length greater than 500 characters [307] */
2839:

Line 2836: l_resource_table hxc_preference_evaluation.t_resource_pref_table;

2832: l_resource_pref_index NUMBER
2833: /*ADVICE(2315): NUMBER has no precision [315] */
2834: ;
2835: l_pref_table hxc_preference_evaluation.t_pref_table;
2836: l_resource_table hxc_preference_evaluation.t_resource_pref_table;
2837: l_query_append VARCHAR2 (32000);
2838: /*ADVICE(2320): VARCHAR2 declaration with length greater than 500 characters [307] */
2839:
2840:

Line 2876: hxc_preference_evaluation.resource_prefs_bulk (

2872: || p_group_id || ' ) ';
2873: l_pref_table.DELETE;
2874: l_resource_table.DELETE;
2875: g_start_stop_pref_cache.DELETE;
2876: hxc_preference_evaluation.resource_prefs_bulk (
2877: p_evaluation_date => SYSDATE,
2878: p_pref_table => l_pref_table,
2879: p_resource_pref_table => l_resource_table,
2880: p_resource_sql => l_query_append

Line 2961: hxc_preference_evaluation.t_pref_table;

2957: AND p_business_group_id = NVL (a.business_group_id, p_business_group_id) order by c.name);
2958: /*end of fix 5083261*/
2959: l_pref_resource
2960: /*ADVICE(2415): Unreferenced variable [553] */
2961: hxc_preference_evaluation.t_pref_table;
2962: l_periodname_list
2963: /*ADVICE(2418): Unreferenced variable [553] */
2964: hxc_timekeeper_utilities.t_group_list;
2965: l_pref_index

Line 3093: l_pref_table hxc_preference_evaluation.t_pref_table;

3089: p_timekeeper_id IN NUMBER,
3090: p_tk_layout_info OUT NOCOPY hxc_timekeeper_utilities.tk_layout_tab,
3091: p_att_alias_table OUT NOCOPY hxc_timekeeper_utilities.att_alias_list
3092: ) IS
3093: l_pref_table hxc_preference_evaluation.t_pref_table;
3094: l_index NUMBER
3095: /*ADVICE(2548): NUMBER has no precision [315] */
3096: := 0;
3097: m_alias_typ VARCHAR2 (80) := NULL;

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

3129: WHERE typ.person_type_id = ptu.person_type_id
3130: AND SYSDATE BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3131: AND ptu.person_id = p_person_id;
3132: BEGIN
3133: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, l_pref_table, SYSDATE);
3134: OPEN c_get_type (p_timekeeper_id);
3135: FETCH c_get_type INTO l_person_type;
3136: CLOSE c_get_type;
3137: l_index := l_pref_table.FIRST;

Line 4717: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');

4713:
4714: p_attribute_array:= HXC_ATTRIBUTE_TABLE_TYPE();
4715:
4716: if g_debug then
4717: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
4718: end if;
4719:
4720: hxc_preference_evaluation.get_tc_resp
4721: (p_resource_id,

Line 4720: hxc_preference_evaluation.get_tc_resp

4716: if g_debug then
4717: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
4718: end if;
4719:
4720: hxc_preference_evaluation.get_tc_resp
4721: (p_resource_id,
4722: p_start_period,
4723: p_end_period,
4724: l_resp_id,

Line 4728: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');

4724: l_resp_id,
4725: l_resp_appl_id);
4726:
4727: if g_debug then
4728: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');
4729: end if;
4730:
4731: l_approval_style_id := hxc_preference_evaluation.resource_preferences(
4732: p_resource_id,

Line 4731: l_approval_style_id := hxc_preference_evaluation.resource_preferences(

4727: if g_debug then
4728: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');
4729: end if;
4730:
4731: l_approval_style_id := hxc_preference_evaluation.resource_preferences(
4732: p_resource_id,
4733: 'TS_PER_APPROVAL_STYLE',
4734: 1,
4735: l_resp_id

Line 5880: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');

5876:
5877: p_messages:= HXC_MESSAGE_TABLE_TYPE();
5878:
5879: if g_debug then
5880: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
5881: end if;
5882:
5883: hxc_preference_evaluation.get_tc_resp
5884: (p_resource_id,

Line 5883: hxc_preference_evaluation.get_tc_resp

5879: if g_debug then
5880: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
5881: end if;
5882:
5883: hxc_preference_evaluation.get_tc_resp
5884: (p_resource_id,
5885: p_start_period,
5886: p_end_period,
5887: l_resp_id,

Line 5891: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');

5887: l_resp_id,
5888: l_resp_appl_id);
5889:
5890: if g_debug then
5891: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');
5892: end if;
5893:
5894: l_approval_style_id := hxc_preference_evaluation.resource_preferences(
5895: p_resource_id,

Line 5894: l_approval_style_id := hxc_preference_evaluation.resource_preferences(

5890: if g_debug then
5891: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');
5892: end if;
5893:
5894: l_approval_style_id := hxc_preference_evaluation.resource_preferences(
5895: p_resource_id,
5896: 'TS_PER_APPROVAL_STYLE',
5897: 1,
5898: l_resp_id