[Home] [Help]
81: --
82: --
83: procedure set_security_group_id
84: (
85: p_position_id in per_positions.position_id%TYPE
86: ) is
87: --
88: -- Declare cursor
89: --
89: --
90: cursor csr_sec_grp is
91: select inf.org_information14
92: from hr_organization_information inf
93: , per_positions pos
94: where pos.position_id = p_position_id
95: and inf.organization_id = pos.business_group_id
96: and inf.org_information_context || '' = 'Business Group Information';
97: --
141: --
142: -- Validates that values entered for this column exist in the PER_JOBS
143: -- table.
144: --
145: -- Validates that PER_POSITIONS.DATE_EFFECTIVE cannot be less than the
146: -- DATE_FROM value for the JOB record on PER_JOBS.
147: --
148: -- Pre-conditions :
149: -- Format for p_date_effective must be correct
239: --
240: -- Validates that values entered for this column exist in the
241: -- HR_ORGANIZATION_UNITS table. (I)
242: --
243: -- Validates that PER_POSITIONS.DATE_EFFECTIVE cannot be less than the
244: -- DATE_FROM value for the ORGANIZATION record on HR_ORGANIZATION_UNITS.
245: --
246: -- Pre-conditions:
247: -- Format for p_date_effective must be correct
375: l_api_updating boolean;
376: --
377: cursor csr_valid_successor_position is
378: select 'x'
379: from per_positions pos
380: where pos.position_id = p_successor_position_id
381: and pos.business_group_id + 0 = p_business_group_id
382: and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;
383: --
472: --
473: --
474: cursor csr_valid_relief_position is
475: select 'x'
476: from per_positions pos
477: where pos.position_id = p_relief_position_id
478: and pos.business_group_id + 0 = p_business_group_id
479: and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;
480: --
536: -- organization's LOCATION_ID is null the value for the business group is
537: -- selected.
538: --
539: -- Validates that values entered for this column exist in the
540: -- HR_LOCATIONS table and are active for the PER_POSITIONS.DATE_EFFECTIVE
541: -- i.e. HR_LOCATIONS.INACTIVE_DATE must be null or greater than
542: -- PER_POSITIONS.DATE_EFFECTIVE
543: --
544: -- Pre-conditions:
538: --
539: -- Validates that values entered for this column exist in the
540: -- HR_LOCATIONS table and are active for the PER_POSITIONS.DATE_EFFECTIVE
541: -- i.e. HR_LOCATIONS.INACTIVE_DATE must be null or greater than
542: -- PER_POSITIONS.DATE_EFFECTIVE
543: --
544: -- Pre-conditions:
545: -- Format for p_date_effective must be correct
546: --
1363: -- b) During insert.
1364: --
1365: hr_dflex_utility.ins_or_upd_descflex_attribs
1366: (p_appl_short_name => 'PER'
1367: ,p_descflex_name => 'PER_POSITIONS'
1368: ,p_attribute_category => p_rec.attribute_category
1369: ,p_attribute1_name => 'ATTRIBUTE1'
1370: ,p_attribute1_value => p_rec.attribute1
1371: ,p_attribute2_name => 'ATTRIBUTE2'
1556: -- p_position_id
1557: -- p_name
1558: --
1559: -- Post Success :
1560: -- If the NAME in PER_POSITIONS table does not exist for given BUSINESS_GROUP_ID
1561: -- then processing continues
1562: --
1563: -- Post Failure :
1564: -- If the NAME does exist in PER_POSITIONS table for given BUSINESS_GROUP_ID,
1560: -- If the NAME in PER_POSITIONS table does not exist for given BUSINESS_GROUP_ID
1561: -- then processing continues
1562: --
1563: -- Post Failure :
1564: -- If the NAME does exist in PER_POSITIONS table for given BUSINESS_GROUP_ID,
1565: -- then an application error will be raised and processing terminated
1566: --
1567: -- Access Status :
1568: -- Internal Table Handler Use only.
1962: --
1963: cursor csr_leg_code is
1964: select pbg.legislation_code
1965: from per_business_groups pbg
1966: , per_positions pos
1967: where pos.position_id = p_position_id
1968: and pbg.business_group_id = pos.business_group_id;
1969: --
1970: -- Declare local variables