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_RESOURCE_RULES_UTILS

Line 229: hxc_resource_rules_utils.chk_flex_valid ('SCL', pa.soft_coding_keyflex_id,

225: 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)
226: AND p_evaluation_date between hrr.start_date and hrr.end_date
227: AND ( (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 3 ),
228: 'SCL', DECODE ( pa.soft_coding_keyflex_id, NULL, -1,
229: hxc_resource_rules_utils.chk_flex_valid ('SCL', pa.soft_coding_keyflex_id,
230: SUBSTR( hrr.eligibility_criteria_type, 5 ),
231: hrr.eligibility_criteria_id )), -1 ) = 1 )
232: OR
233: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ),

Line 235: hxc_resource_rules_utils.chk_flex_valid ( 'PEOPLE', pa.people_group_id,

231: hrr.eligibility_criteria_id )), -1 ) = 1 )
232: OR
233: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ),
234: 'PEOPLE', DECODE ( pa.people_group_id, NULL, -1,
235: hxc_resource_rules_utils.chk_flex_valid ( 'PEOPLE', pa.people_group_id,
236: SUBSTR( hrr.eligibility_criteria_type, 8 ),
237: hrr.eligibility_criteria_id )), -1 ) = 1 )
238: OR
239: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ),

Line 241: hxc_resource_rules_utils.chk_flex_valid ( 'GRADE', pa.grade_id,

237: hrr.eligibility_criteria_id )), -1 ) = 1 )
238: OR
239: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ),
240: 'GRADE', DECODE ( pa.grade_id, NULL, -1,
241: hxc_resource_rules_utils.chk_flex_valid ( 'GRADE', pa.grade_id,
242: SUBSTR( hrr.eligibility_criteria_type, 7 ),
243: hrr.eligibility_criteria_id )), -1 ) = 1 )
244: OR
245:

Line 1608: hxc_resource_rules_utils.chk_flex_valid ( 'SCL', pa.soft_coding_keyflex_id,

1604: and hrr.start_date <= pa.effective_end_date
1605: and hrr.end_date >=pa.effective_start_date
1606: AND ( (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 3 ),
1607: 'SCL', DECODE ( pa.soft_coding_keyflex_id, NULL, -1,
1608: hxc_resource_rules_utils.chk_flex_valid ( 'SCL', pa.soft_coding_keyflex_id,
1609: SUBSTR( hrr.eligibility_criteria_type, 5 ), hrr.eligibility_criteria_id )), -1 ) = 1 )
1610: OR
1611: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ),
1612: 'PEOPLE', DECODE ( pa.people_group_id, NULL, -1,

Line 1613: hxc_resource_rules_utils.chk_flex_valid ( 'PEOPLE', pa.people_group_id,

1609: SUBSTR( hrr.eligibility_criteria_type, 5 ), hrr.eligibility_criteria_id )), -1 ) = 1 )
1610: OR
1611: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ),
1612: 'PEOPLE', DECODE ( pa.people_group_id, NULL, -1,
1613: hxc_resource_rules_utils.chk_flex_valid ( 'PEOPLE', pa.people_group_id,
1614: SUBSTR( hrr.eligibility_criteria_type, 8 ), hrr.eligibility_criteria_id )), -1 ) = 1 )
1615: OR
1616: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ),
1617: 'GRADE', DECODE ( pa.grade_id, NULL, -1,

Line 1618: hxc_resource_rules_utils.chk_flex_valid ( 'GRADE', pa.grade_id,

1614: SUBSTR( hrr.eligibility_criteria_type, 8 ), hrr.eligibility_criteria_id )), -1 ) = 1 )
1615: OR
1616: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ),
1617: 'GRADE', DECODE ( pa.grade_id, NULL, -1,
1618: hxc_resource_rules_utils.chk_flex_valid ( 'GRADE', pa.grade_id,
1619: SUBSTR( hrr.eligibility_criteria_type, 7 ), hrr.eligibility_criteria_id )), -1 ) = 1 )
1620: OR
1621:
1622: (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 3 ),

Line 3182: hxc_resource_rules_utils.chk_flex_valid (''SCL'', pa.soft_coding_keyflex_id,

3178: BETWEEN pa.effective_start_date AND pa.effective_END_date
3179: AND :evaluation_date between hrr.start_date and hrr.end_date
3180: AND ( (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 3 ),
3181: ''SCL'', DECODE ( pa.soft_coding_keyflex_id, NULL, -1,
3182: hxc_resource_rules_utils.chk_flex_valid (''SCL'', pa.soft_coding_keyflex_id,
3183: SUBSTR( hrr.eligibility_criteria_type, 5 ),
3184: hrr.eligibility_criteria_id )), -1 ) = 1 )
3185: OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ),
3186: ''PEOPLE'', DECODE ( pa.people_group_id, NULL, -1,

Line 3187: hxc_resource_rules_utils.chk_flex_valid ( ''PEOPLE'', pa.people_group_id,

3183: SUBSTR( hrr.eligibility_criteria_type, 5 ),
3184: hrr.eligibility_criteria_id )), -1 ) = 1 )
3185: OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ),
3186: ''PEOPLE'', DECODE ( pa.people_group_id, NULL, -1,
3187: hxc_resource_rules_utils.chk_flex_valid ( ''PEOPLE'', pa.people_group_id,
3188: SUBSTR( hrr.eligibility_criteria_type, 8 ),
3189: hrr.eligibility_criteria_id )), -1 ) = 1 )
3190: OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ),
3191: ''GRADE'', DECODE ( pa.grade_id, NULL, -1,

Line 3192: hxc_resource_rules_utils.chk_flex_valid ( ''GRADE'', pa.grade_id,

3188: SUBSTR( hrr.eligibility_criteria_type, 8 ),
3189: hrr.eligibility_criteria_id )), -1 ) = 1 )
3190: OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ),
3191: ''GRADE'', DECODE ( pa.grade_id, NULL, -1,
3192: hxc_resource_rules_utils.chk_flex_valid ( ''GRADE'', pa.grade_id,
3193: SUBSTR( hrr.eligibility_criteria_type, 7 ),
3194: hrr.eligibility_criteria_id )), -1 ) = 1 )
3195: OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 3 ),
3196: ''JOB'', hrr.eligibility_criteria_id, -1 ) = to_char(pa.job_id))-- Issue 4