eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_PREFERENCE_EVALUATION dependencies on HXC_PREFERENCE_EVALUATION

Line 1: PACKAGE BODY hxc_preference_evaluation AS

1: PACKAGE BODY hxc_preference_evaluation AS
2: /* $Header: hxcpfevl.pkb 120.20 2011/08/10 10:23:15 asrajago ship $ */
3:
4: g_migration_mode BOOLEAN := FALSE;
5: g_package VARCHAR2 (72) := 'hxc_preference_evaluation';

Line 5: g_package VARCHAR2 (72) := 'hxc_preference_evaluation';

1: PACKAGE BODY hxc_preference_evaluation AS
2: /* $Header: hxcpfevl.pkb 120.20 2011/08/10 10:23:15 asrajago ship $ */
3:
4: g_migration_mode BOOLEAN := FALSE;
5: g_package VARCHAR2 (72) := 'hxc_preference_evaluation';
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: -- will use PL/SQL tables in various places to manipulate preference information
9:

Line 192: ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in

188: AND Decode(pa.assignment_type , 'C',
189: Decode(cwk_final_process_date,pa.effective_END_date,pa.effective_END_date + l_num_of_days_to_add ,pa.effective_END_date),pa.effective_END_date)
190: AND p_evaluation_date between hrr.start_date and hrr.end_date
191: AND (
192: ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in
193: (SELECT pose.organization_id_parent
194: FROM
195: per_org_structure_elements pose
196: start with organization_id_child = pa.organization_id

Line 198: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

194: FROM
195: per_org_structure_elements pose
196: start with organization_id_child = pa.organization_id
197: and pose.org_structure_version_id=
198: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
199: hrr.eligibility_criteria_type)
200: connect by prior organization_id_parent=organization_id_child
201: and pose.org_structure_version_id=
202: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

Line 202: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

198: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
199: hrr.eligibility_criteria_type)
200: connect by prior organization_id_parent=organization_id_child
201: and pose.org_structure_version_id=
202: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
203: hrr.eligibility_criteria_type)
204: union
205: select organization_id
206: from hr_all_organization_units

Line 1504: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in

1500: OR ( pa.EMPLOYMENT_CATEGORY = hrr.eligibility_criteria_id
1501: AND hrr.eligibility_criteria_type = 'ASGN_CATEGORY')
1502: OR ( to_char(pa.organization_id) = hrr.eligibility_criteria_id
1503: AND hrr.eligibility_criteria_type = 'ORGANIZATION')
1504: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in
1505: (SELECT pose.organization_id_parent
1506: FROM
1507: per_org_structure_elements pose
1508: start with organization_id_child = pa.organization_id

Line 1510: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

1506: FROM
1507: per_org_structure_elements pose
1508: start with organization_id_child = pa.organization_id
1509: and pose.org_structure_version_id=
1510: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1511: hrr.eligibility_criteria_type)
1512: connect by prior organization_id_parent=organization_id_child
1513: and pose.org_structure_version_id=
1514: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

Line 1514: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

1510: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1511: hrr.eligibility_criteria_type)
1512: connect by prior organization_id_parent=organization_id_child
1513: and pose.org_structure_version_id=
1514: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1515: hrr.eligibility_criteria_type)
1516: union
1517: select organization_id
1518: from hr_all_organization_units

Line 1564: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in

1560: OR ( pa.EMPLOYMENT_CATEGORY = hrr.eligibility_criteria_id
1561: AND hrr.eligibility_criteria_type = 'ASGN_CATEGORY')
1562: OR ( to_char(pa.organization_id) = hrr.eligibility_criteria_id
1563: AND hrr.eligibility_criteria_type = 'ORGANIZATION')
1564: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in
1565: (SELECT pose.organization_id_parent
1566: FROM
1567: per_org_structure_elements pose
1568: start with organization_id_child = pa.organization_id

Line 1570: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

1566: FROM
1567: per_org_structure_elements pose
1568: start with organization_id_child = pa.organization_id
1569: and pose.org_structure_version_id=
1570: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1571: hrr.eligibility_criteria_type)
1572: connect by prior organization_id_parent=organization_id_child
1573: and pose.org_structure_version_id=
1574: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

Line 1574: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),

1570: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1571: hrr.eligibility_criteria_type)
1572: connect by prior organization_id_parent=organization_id_child
1573: and pose.org_structure_version_id=
1574: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1575: hrr.eligibility_criteria_type)
1576: union
1577: select organization_id
1578: from hr_all_organization_units

Line 2708: hxc_preference_evaluation.resource_preferences(p_resource_id => p_resource_id,

2704: THEN
2705:
2706: g_sort_pref_table.DELETE;
2707:
2708: hxc_preference_evaluation.resource_preferences(p_resource_id => p_resource_id,
2709: p_start_evaluation_date => p_start_evaluation_date,
2710: p_end_evaluation_date => p_end_evaluation_date,
2711: p_pref_table => g_sort_pref_table,
2712: p_no_prefs_outside_asg => p_no_prefs_outside_asg );

Line 2722: hxc_preference_evaluation.resource_preferences(p_resource_id => p_resource_id,

2718: END IF;
2719:
2720: ELSE
2721:
2722: hxc_preference_evaluation.resource_preferences(p_resource_id => p_resource_id,
2723: p_start_evaluation_date => p_start_evaluation_date,
2724: p_end_evaluation_date => p_end_evaluation_date,
2725: p_pref_table => g_sort_pref_table,
2726: p_no_prefs_outside_asg => p_no_prefs_outside_asg );

Line 3093: l_eval_pref_table hxc_preference_evaluation.t_pref_table;

3089:
3090:
3091: l_pref_table_idx number;
3092:
3093: l_eval_pref_table hxc_preference_evaluation.t_pref_table;
3094: l_eval_pref_table_idx number;
3095:
3096: l_set_start number;
3097: l_set_stop number;

Line 3140: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,''-'',1,1)+1)) in

3136: OR ( to_char(pa.location_id) = hrr.eligibility_criteria_id
3137: AND hrr.eligibility_criteria_type = ''LOCATION'')
3138: OR ( to_char(pa.organization_id) = hrr.eligibility_criteria_id
3139: AND hrr.eligibility_criteria_type = ''ORGANIZATION'')
3140: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,''-'',1,1)+1)) in
3141: (SELECT pose.organization_id_parent
3142: FROM
3143: per_org_structure_elements pose
3144: start with organization_id_child = pa.organization_id

Line 3146: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),

3142: FROM
3143: per_org_structure_elements pose
3144: start with organization_id_child = pa.organization_id
3145: and pose.org_structure_version_id=
3146: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),
3147: hrr.eligibility_criteria_type)
3148: connect by prior organization_id_parent=organization_id_child
3149: and pose.org_structure_version_id=
3150: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),

Line 3150: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),

3146: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),
3147: hrr.eligibility_criteria_type)
3148: connect by prior organization_id_parent=organization_id_child
3149: and pose.org_structure_version_id=
3150: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),
3151: hrr.eligibility_criteria_type)
3152: union
3153: select organization_id
3154: from hr_all_organization_units

Line 3157: OR ( HXC_PREFERENCE_EVALUATION.check_number(hrr.eligibility_criteria_id)

3153: select organization_id
3154: from hr_all_organization_units
3155: where organization_id = pa.organization_id))
3156: AND hrr.eligibility_criteria_type = ''ROLLUP'' )
3157: OR ( HXC_PREFERENCE_EVALUATION.check_number(hrr.eligibility_criteria_id)
3158: in ( SELECT typ.person_type_id
3159: FROM per_person_types typ
3160: ,per_person_type_usages_f ptu
3161: WHERE typ.system_person_type IN (''EMP'',''EX_EMP'',''EMP_APL'',''EX_EMP_APL'',''CWK'',''EX_CWK'')

Line 3290: hxc_preference_evaluation.resource_preferences(

3286:
3287: -- if no match found, then need to evaluate preferences.
3288: if (l_matches = 0) then
3289: -- Call preference evaluation proc
3290: hxc_preference_evaluation.resource_preferences(
3291: p_resource_id =>l_current_resource_id,
3292: p_evaluation_date =>p_evaluation_date,
3293: p_pref_table =>l_eval_pref_table,
3294: p_ignore_user_id => true,

Line 3908: END hxc_preference_evaluation;

3904: RETURN resource_preferences(p_resource_id,p_pref_code,p_attribute_n,SYSDATE,p_resp_id);
3905: END resource_preferences;
3906: --===============================================
3907:
3908: END hxc_preference_evaluation;
3909: