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

Line 144: FROM hxc_resource_rules hrr,

140: CURSOR c_eligible_hierarchies_basic(p_resource_id IN NUMBER,
141: p_evaluation_date IN DATE) IS
142:
143: SELECT hrr.pref_hierarchy_id, hrr.rule_evaluation_order
144: FROM hxc_resource_rules hrr,
145: per_all_assignments_f pa
146: WHERE pa.person_id = p_resource_id
147: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
148: AND pa.primary_flag = 'Y'

Line 180: FROM hxc_resource_rules hrr,

176: CURSOR c_eligible_hierarchies_rollup(p_resource_id IN NUMBER,
177: p_evaluation_date IN DATE) IS
178: SELECT /*+ USE_NL(PA HRR) */
179: hrr.pref_hierarchy_id, hrr.rule_evaluation_order
180: FROM hxc_resource_rules hrr,
181: per_all_assignments_f pa
182: WHERE pa.person_id = p_resource_id
183: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
184: AND pa.primary_flag = 'Y'

Line 216: FROM hxc_resource_rules hrr,

212: -- Modified cursor to support CWK.
213: CURSOR c_eligible_hierarchies_flex(p_resource_id IN NUMBER,
214: p_evaluation_date IN DATE) IS
215: SELECT hrr.pref_hierarchy_id, hrr.rule_evaluation_order
216: FROM hxc_resource_rules hrr,
217: per_all_assignments_f pa
218: WHERE pa.person_id = p_resource_id
219: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
220: AND pa.primary_flag = 'Y'

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 261: FROM hxc_resource_rules hrr

257: -- But, keep it simple for now.
258:
259: CURSOR c_personal_hierarchy(p_user_id IN NUMBER) IS
260: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order
261: FROM hxc_resource_rules hrr
262: WHERE hrr.resource_type='PERSON'
263: AND hrr.eligibility_criteria_type = 'LOGIN'
264: AND hrr.eligibility_criteria_id = to_char(p_user_id) ; -- Issue 4
265:

Line 274: FROM hxc_resource_rules hrr

270: CURSOR c_resp_hierarchies(p_responsibility_id IN NUMBER,
271: p_evaluation_date IN DATE) IS
272: SELECT hrr.pref_hierarchy_id ,
273: hrr.rule_evaluation_order
274: FROM hxc_resource_rules hrr
275: WHERE hrr.resource_type='PERSON'
276: AND p_evaluation_date BETWEEN hrr.start_date
277: AND hrr.end_date
278: AND hrr.eligibility_criteria_type IN ('RESPONSIBILITY','PERST_RESPONSIBILITY')

Line 289: FROM hxc_resource_rules hrr

285: CURSOR c_perst_resp_hierarchies(p_responsibility_id IN NUMBER,
286: p_evaluation_date IN DATE) IS
287: SELECT hrr.pref_hierarchy_id ,
288: hrr.rule_evaluation_order
289: FROM hxc_resource_rules hrr
290: WHERE hrr.resource_type='PERSON'
291: AND p_evaluation_date BETWEEN hrr.start_date
292: AND hrr.end_date
293: AND hrr.eligibility_criteria_type = 'PERST_RESPONSIBILITY'

Line 302: FROM hxc_resource_rules hrr,

298:
299: /*Cursor Modified By Mithun for CWK Terminate Bug*/
300: CURSOR c_person_type_hierarchies(p_resource_id IN NUMBER,p_evaluation_date IN DATE) IS
301: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order
302: FROM hxc_resource_rules hrr,
303: per_person_types typ,
304: per_person_type_usages_f ptu
305: WHERE hrr.resource_type='PERSON'
306: AND p_evaluation_date between hrr.start_date and hrr.end_date

Line 1478: FROM hxc_resource_rules hrr,

1474: , pa.effective_start_date) elig_start_date,
1475: decode(hrr.eligibility_criteria_type,
1476: 'ALL_PEOPLE', hr_general.end_of_time
1477: , pa.effective_END_date) elig_end_date
1478: FROM hxc_resource_rules hrr,
1479: per_all_assignments_f pa
1480: WHERE pa.person_id = p_resource_id
1481: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
1482: AND pa.primary_flag = 'Y'

Line 1538: FROM hxc_resource_rules hrr,

1534: hrr.start_date,
1535: hrr.end_date,
1536: pa.effective_start_date elig_start_date,
1537: pa.effective_END_date elig_end_date
1538: FROM hxc_resource_rules hrr,
1539: per_all_assignments_f pa
1540: WHERE pa.person_id = p_resource_id
1541: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
1542: AND pa.primary_flag = 'Y'

Line 1594: FROM hxc_resource_rules hrr,

1590: hrr.rule_evaluation_order,
1591: hrr.start_date, hrr.end_date,
1592: pa.effective_start_date elig_start_date,
1593: pa.effective_END_date elig_end_date
1594: FROM hxc_resource_rules hrr,
1595: per_all_assignments_f pa
1596: WHERE pa.person_id = p_resource_id
1597: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
1598: AND pa.primary_flag = 'Y'

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 1643: FROM hxc_resource_rules hrr,

1639:
1640: CURSOR c_personal_hierarchy(p_resource_id IN NUMBER) IS
1641:
1642: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order, hrr.start_date, hrr.end_date
1643: FROM hxc_resource_rules hrr,
1644: fnd_user fu
1645: WHERE hrr.resource_type='PERSON'
1646: AND hrr.eligibility_criteria_type = 'LOGIN'
1647: AND hrr.eligibility_criteria_id = to_char(fu.user_id) -- Issue 4

Line 1659: FROM hxc_resource_rules hrr,

1655: p_end_evaluation_date IN DATE) IS
1656: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order, hrr.start_date, hrr.end_date,
1657: fr.start_date elig_start_date,
1658: fr.end_date elig_end_date
1659: FROM hxc_resource_rules hrr,
1660: fnd_responsibility fr
1661: WHERE hrr.resource_type='PERSON'
1662: and p_start_evaluation_date <= hrr.end_date
1663: and hrr.start_date <= p_end_evaluation_date

Line 1683: FROM hxc_resource_rules hrr

1679: hrr.start_date,
1680: hrr.end_date,
1681: p_start_evaluation_date elig_start_date,
1682: p_end_evaluation_date elig_end_date
1683: FROM hxc_resource_rules hrr
1684: WHERE hrr.resource_type='PERSON'
1685: AND p_start_evaluation_date BETWEEN hrr.start_date
1686: AND hrr.end_date
1687: AND p_end_evaluation_date BETWEEN hrr.start_date

Line 1707: FROM hxc_resource_rules hrr,

1703: p_end_evaluation_date IN DATE) IS
1704: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order, hrr.start_date, hrr.end_date,
1705: ptu.effective_start_date elig_start_date,
1706: ptu.effective_end_date elig_end_date
1707: FROM hxc_resource_rules hrr,
1708: per_person_types typ,
1709: per_person_type_usages_f ptu
1710: WHERE hrr.resource_type='PERSON'
1711: and p_start_evaluation_date <= hrr.end_date

Line 3117: FROM hxc_resource_rules hrr,

3113: l_sql_statement := ' SELECT /*+ USE_NL(PA HRR) */
3114: pa.person_id as criteria_id,
3115: hrr.pref_hierarchy_id,
3116: hrr.rule_evaluation_order
3117: FROM hxc_resource_rules hrr,
3118: per_all_assignments_f pa
3119: WHERE pa.person_id '||p_resource_sql||'
3120: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
3121: AND pa.primary_flag =''Y''

Line 3171: FROM hxc_resource_rules hrr,

3167: AND hrr.eligibility_criteria_type = ''PERSON_TYPE'')
3168: OR (
3169: hrr.eligibility_criteria_type = ''ALL_PEOPLE''))'|| 'union '||
3170: ' SELECT pa.person_id as criteria_id,hrr.pref_hierarchy_id, hrr.rule_evaluation_order
3171: FROM hxc_resource_rules hrr,
3172: per_all_assignments_f pa
3173: WHERE pa.person_id '||p_resource_sql||'
3174: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
3175: AND pa.primary_flag = ''Y''

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

Line 3362: (p_criteria hxc_resource_rules.eligibility_criteria_id%TYPE,

3358:
3359: end resource_prefs_bulk;
3360:
3361: function return_version_id
3362: (p_criteria hxc_resource_rules.eligibility_criteria_id%TYPE,
3363: p_eligibility_type hxc_resource_rules.eligibility_criteria_type%TYPE)
3364: return number is
3365:
3366: cursor c_version_id(p_number number) is

Line 3363: p_eligibility_type hxc_resource_rules.eligibility_criteria_type%TYPE)

3359: end resource_prefs_bulk;
3360:
3361: function return_version_id
3362: (p_criteria hxc_resource_rules.eligibility_criteria_id%TYPE,
3363: p_eligibility_type hxc_resource_rules.eligibility_criteria_type%TYPE)
3364: return number is
3365:
3366: cursor c_version_id(p_number number) is
3367: select org_structure_version_id