APPS.PQH_TCT_WIZARD_PKG dependencies on PQH_ATTRIBUTE_RANGES_API

Line 148: pqh_attribute_ranges_api.create_attribute_range(

144: -- Create a rule with the above generated rule name and attribute
145: -- ranges value null
146: -- File : pqrngapi.pkh/pkb
147: --
148: pqh_attribute_ranges_api.create_attribute_range(
149: p_validate => p_validate
150: ,p_attribute_range_id => l_attribute_range_id
151: ,p_approver_flag => NULL
152: ,p_enable_flag => p_enable_flag

Line 232: pqh_attribute_ranges_api.update_attribute_range

228: open csr_get_attribute_range(p_routing_category_id => p_old_routing_category_id);
229: loop
230: fetch csr_get_attribute_range into l_rng_record;
231: exit when csr_get_attribute_range%notfound;
232: pqh_attribute_ranges_api.update_attribute_range
233: (
234: p_validate => p_validate
235: ,p_attribute_range_id => l_rng_record.attribute_range_id
236: ,p_approver_flag => l_rng_record.approver_flag

Line 299: pqh_attribute_ranges_api.update_attribute_range

295: open csr_get_attribute_range(p_routing_category_id => p_routing_category_id);
296: loop
297: fetch csr_get_attribute_range into l_rng_record;
298: exit when csr_get_attribute_range%notfound;
299: pqh_attribute_ranges_api.update_attribute_range
300: (
301: p_validate => p_validate
302: ,p_attribute_range_id => l_rng_record.attribute_range_id
303: ,p_approver_flag => l_rng_record.approver_flag

Line 377: pqh_attribute_ranges_api.create_attribute_range

373: --
374: -- Create a rule with the above generated rule name and attribute
375: -- ranges value null
376: --
377: pqh_attribute_ranges_api.create_attribute_range
378: (p_validate => p_validate
379: ,p_attribute_range_id => l_attribute_range_id
380: ,p_approver_flag => NULL
381: ,p_enable_flag => p_enable_flag

Line 458: pqh_attribute_ranges_api.create_attribute_range(

454: p_range_name := generate_rule_name;
455: --
456: -- Create a rule with the above generated rule name and attribute
457: -- ranges value null
458: pqh_attribute_ranges_api.create_attribute_range(
459: p_validate => p_validate
460: ,p_attribute_range_id => p_attribute_range_id
461: ,p_approver_flag => p_approver_flag
462: ,p_enable_flag => p_enable_flag

Line 481: pqh_attribute_ranges_api.update_attribute_range(

477: ,p_effective_date => p_effective_date);
478: --
479: Else
480: --
481: pqh_attribute_ranges_api.update_attribute_range(
482: p_validate => p_validate
483: ,p_attribute_range_id => p_attribute_range_id
484: ,p_approver_flag => 'Y'
485: ,p_enable_flag => 'Y'

Line 529: pqh_attribute_ranges_api.update_attribute_range

525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: --
528: --
529: pqh_attribute_ranges_api.update_attribute_range
530: (
531: p_validate => p_validate
532: ,p_attribute_range_id => p_attribute_range_id
533: ,p_approver_flag => p_approver_flag

Line 575: pqh_attribute_ranges_api.delete_attribute_range

571: --
572: --
573: -- Delete the authorization rule for the default approver.
574: --
575: pqh_attribute_ranges_api.delete_attribute_range
576: (
577: p_validate => p_validate
578: ,p_attribute_range_id => p_attribute_range_id
579: ,p_object_version_number => p_object_version_number

Line 1022: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE

1018: For rct_rec in csr_adv_rct loop
1019: --
1020: For rule_rec in csr_rout_rule(rct_rec.routing_category_id) loop
1021: --
1022: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE
1023: (
1024: p_validate => false
1025: ,p_attribute_range_id => l_attribute_range_id
1026: ,p_enable_flag => rule_rec.enable_flag

Line 1063: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE

1059: l_position_id := NULL;
1060: l_assignment_id := rule_rec.member_id;
1061: End if;
1062: --
1063: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE
1064: (
1065: p_validate => false
1066: ,p_attribute_range_id => l_attribute_range_id
1067: ,p_enable_flag => rule_rec.enable_flag

Line 1187: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE

1183: End loop;
1184: --
1185: If not l_found then
1186: hr_utility.set_location('calling delete_ATTRIBUTE_RANGE', 5);
1187: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE
1188: (p_validate => false
1189: ,p_attribute_range_id => old_rec.attribute_range_id
1190: ,p_object_version_number => old_rec.object_version_number
1191: ,p_effective_date => sysdate);

Line 1297: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE

1293: End if;
1294: End loop;
1295: --
1296: If not l_found then
1297: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE
1298: (p_validate => false
1299: ,p_attribute_range_id => old_rec.attribute_range_id
1300: ,p_object_version_number => old_rec.object_version_number
1301: ,p_effective_date => sysdate);

Line 1575: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE

1571: p_all_attribute_range_id := NULL;
1572: --
1573: For attr_rec in csr_rout_attr loop
1574: --
1575: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE
1576: (
1577: p_validate => false
1578: ,p_attribute_range_id => l_attribute_range_id
1579: ,p_enable_flag => p_enable_flag

Line 1656: pqh_attribute_ranges_api.update_ATTRIBUTE_RANGE

1652: If csr_update_rule%NOTFOUND then
1653: Exit;
1654: End if;
1655: --
1656: pqh_attribute_ranges_api.update_ATTRIBUTE_RANGE
1657: (
1658: p_validate => false
1659: ,p_attribute_range_id => att_range_rec.attribute_range_id
1660: ,p_approver_flag => p_approver_flag

Line 1764: pqh_attribute_ranges_api.delete_ATTRIBUTE_RANGE

1760: If csr_delete_rule%NOTFOUND then
1761: Exit;
1762: End if;
1763: --
1764: pqh_attribute_ranges_api.delete_ATTRIBUTE_RANGE
1765: (
1766: p_validate => false
1767: ,p_attribute_range_id => l_id
1768: ,p_object_version_number => l_ovn

Line 1865: pqh_attribute_ranges_api.update_attribute_range(

1861: For exist_appr_rec in csr_chk_already_approver loop
1862: --
1863: l_create_appr := false;
1864: --
1865: pqh_attribute_ranges_api.update_attribute_range(
1866: p_validate => false
1867: ,p_attribute_range_id => exist_appr_rec.attribute_range_id
1868: ,p_approver_flag => 'Y'
1869: ,p_enable_flag => 'Y'

Line 1888: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE

1884: -- authorization attributes with attribute ranges value null
1885: --
1886: For attr_rec in csr_auth_attr loop
1887: --
1888: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE
1889: (
1890: p_validate => false
1891: ,p_attribute_range_id => l_attribute_range_id
1892: ,p_routing_category_id => p_routing_category_id

Line 1989: pqh_attribute_ranges_api.update_ATTRIBUTE_RANGE

1985: If csr_update_approver%notfound then
1986: exit;
1987: End if;
1988: --
1989: pqh_attribute_ranges_api.update_ATTRIBUTE_RANGE
1990: (
1991: p_validate => false
1992: ,p_attribute_range_id => l_id
1993: ,p_approver_flag => p_approver_flag

Line 2079: pqh_attribute_ranges_api.delete_ATTRIBUTE_RANGE

2075: If csr_delete_approver%notfound then
2076: exit;
2077: End if;
2078: --
2079: pqh_attribute_ranges_api.delete_ATTRIBUTE_RANGE
2080: (
2081: p_validate => false
2082: ,p_attribute_range_id => l_id
2083: ,p_object_version_number => l_ovn

Line 2156: pqh_attribute_ranges_api.update_ATTRIBUTE_RANGE

2152: exit;
2153: End if;
2154: --
2155: --
2156: pqh_attribute_ranges_api.update_ATTRIBUTE_RANGE
2157: (p_validate => false
2158: ,p_attribute_range_id => l_id
2159: ,p_approver_flag => p_approver_flag
2160: ,p_object_version_number => l_ovn

Line 2233: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE

2229: p_all_attribute_range_id := NULL;
2230: --
2231: For attr_rec in csr_auth_attr loop
2232: --
2233: pqh_attribute_ranges_api.create_ATTRIBUTE_RANGE
2234: (
2235: p_validate => false
2236: ,p_attribute_range_id => l_attribute_range_id
2237: ,p_routing_category_id => p_routing_category_id

Line 2263: pqh_attribute_ranges_api.delete_ATTRIBUTE_RANGE

2259: -- information , we can delete those rules.
2260: --
2261: For sys_rec in csr_sys_rule loop
2262: --
2263: pqh_attribute_ranges_api.delete_ATTRIBUTE_RANGE
2264: (
2265: p_validate => false
2266: ,p_attribute_range_id => sys_rec.attribute_range_id
2267: ,p_object_version_number => sys_rec.object_version_number