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.HR_PSF_BUS dependencies on HR_ALL_POSITIONS_F

Line 27: , hr_all_positions_f pos

23: --
24: cursor csr_sec_grp is
25: select inf.org_information14
26: from hr_organization_information inf
27: , hr_all_positions_f pos
28: where pos.position_id = p_position_id
29: and inf.organization_id = pos.business_group_id
30: and inf.org_information_context || '' = 'Business Group Information';
31: --

Line 267: from hr_all_positions_f pos, per_shared_types sht

263: is
264: -- cursor to check active rows for the position prior to the effective_start_date of their row
265: cursor pos_active_rows(p_position_id number,p_effective_start_date date) is
266: select count(*)
267: from hr_all_positions_f pos, per_shared_types sht
268: where pos.position_id = p_position_id
269: and pos.effective_start_date < p_effective_start_date
270: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
271: -- cursor to find out the next active row's effective start date

Line 274: from hr_all_positions_f pos, per_shared_types sht

270: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
271: -- cursor to find out the next active row's effective start date
272: cursor next_active_row(p_position_id number,p_effective_start_date date) is
273: select effective_start_date
274: from hr_all_positions_f pos, per_shared_types sht
275: where pos.position_id = p_position_id
276: and pos.effective_start_date > p_effective_start_date
277: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
278: -- cursor to find the first active row

Line 281: from hr_all_positions_f pos

277: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
278: -- cursor to find the first active row
279: cursor valid_first_active_row(p_position_id number,p_effective_end_date date) is
280: select min(effective_start_date)
281: from hr_all_positions_f pos
282: where effective_start_date > p_effective_end_date + 1
283: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
284: l_active_rows number;
285: l_current_row_stat varchar2(30);

Line 443: from hr_all_positions_f pos

439: index by binary_integer ;
440: chk_stat tran_stat;
441: cursor csr_stat(p_position_id number,p_effective_start_date date,p_business_group_id number) is
442: select hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id)
443: from hr_all_positions_f pos
444: where pos.position_id = p_position_id
445: and pos.effective_start_date = p_effective_start_date;
446: cursor csr_prev(p_position_id number, p_effective_start_date date) is
447: select max(effective_start_date)

Line 448: from hr_all_positions_f

444: where pos.position_id = p_position_id
445: and pos.effective_start_date = p_effective_start_date;
446: cursor csr_prev(p_position_id number, p_effective_start_date date) is
447: select max(effective_start_date)
448: from hr_all_positions_f
449: where position_id = p_position_id
450: and effective_start_date < p_effective_start_date ;
451: cursor csr_future(p_position_id number, p_effective_start_date date) is
452: select min(effective_start_date)

Line 453: from hr_all_positions_f

449: where position_id = p_position_id
450: and effective_start_date < p_effective_start_date ;
451: cursor csr_future(p_position_id number, p_effective_start_date date) is
452: select min(effective_start_date)
453: from hr_all_positions_f
454: where position_id = p_position_id
455: and effective_start_date > p_effective_start_date ;
456: cursor csr_present(p_position_id number, p_object_version_number number) is
457: select effective_start_date

Line 458: from hr_all_positions_f

454: where position_id = p_position_id
455: and effective_start_date > p_effective_start_date ;
456: cursor csr_present(p_position_id number, p_object_version_number number) is
457: select effective_start_date
458: from hr_all_positions_f
459: where position_id = p_position_id
460: and object_version_number = p_object_version_number ;
461: l_present_stat varchar2(30) ;
462: l_prev_stat varchar2(30);

Line 687: (p_position_id in hr_all_positions_f.position_id%TYPE

683: -- |-------------------< chk_entry_step_id >-----------------------|
684: -- ---------------------------------------------------------------------------
685: --
686: procedure chk_entry_step_id
687: (p_position_id in hr_all_positions_f.position_id%TYPE
688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE
689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

Line 688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE

684: -- ---------------------------------------------------------------------------
685: --
686: procedure chk_entry_step_id
687: (p_position_id in hr_all_positions_f.position_id%TYPE
688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE
689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

Line 689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE

685: --
686: procedure chk_entry_step_id
687: (p_position_id in hr_all_positions_f.position_id%TYPE
688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE
689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
693: ,p_effective_date in date

Line 690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE

686: procedure chk_entry_step_id
687: (p_position_id in hr_all_positions_f.position_id%TYPE
688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE
689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
693: ,p_effective_date in date
694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

Line 691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

687: (p_position_id in hr_all_positions_f.position_id%TYPE
688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE
689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
693: ,p_effective_date in date
694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
695: )

Line 692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

688: ,p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE
689: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
693: ,p_effective_date in date
694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
695: )
696: is

Line 694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

690: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
691: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
692: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
693: ,p_effective_date in date
694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
695: )
696: is
697: --
698: l_sequence per_spinal_point_steps_f.sequence%TYPE;

Line 854: (p_position_id in hr_all_positions_f.position_id%TYPE

850: -- |---------------------------< chk_entry_grade_id >------------------------------|
851: -- ---------------------------------------------------------------------------
852: --
853: procedure chk_entry_grade_id
854: (p_position_id in hr_all_positions_f.position_id%TYPE
855: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
857: ,p_effective_date in date
858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

Line 855: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE

851: -- ---------------------------------------------------------------------------
852: --
853: procedure chk_entry_grade_id
854: (p_position_id in hr_all_positions_f.position_id%TYPE
855: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
857: ,p_effective_date in date
858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
859: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

Line 856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE

852: --
853: procedure chk_entry_grade_id
854: (p_position_id in hr_all_positions_f.position_id%TYPE
855: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
857: ,p_effective_date in date
858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
859: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
860: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

Line 858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

854: (p_position_id in hr_all_positions_f.position_id%TYPE
855: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
857: ,p_effective_date in date
858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
859: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
860: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
861: )
862: is

Line 859: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

855: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
857: ,p_effective_date in date
858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
859: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
860: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
861: )
862: is
863: --

Line 860: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

856: ,p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE
857: ,p_effective_date in date
858: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
859: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
860: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
861: )
862: is
863: --
864: l_exists varchar2(1);

Line 868: l_vac_grade_id hr_all_positions_f.entry_grade_id%TYPE;

864: l_exists varchar2(1);
865: l_api_updating boolean;
866: l_business_group_id number(15);
867: l_proc varchar2(72);
868: l_vac_grade_id hr_all_positions_f.entry_grade_id%TYPE;
869: --
870: cursor csr_valid_grade is
871: select business_group_id
872: from per_grades

Line 984: (p_position_id in hr_all_positions_f.position_id%TYPE

980: -- |---------------------------< chk_entry_grade_rule_id >------------------------------|
981: -- ---------------------------------------------------------------------------
982: --
983: procedure chk_entry_grade_rule_id
984: (p_position_id in hr_all_positions_f.position_id%TYPE
985: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

Line 985: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE

981: -- ---------------------------------------------------------------------------
982: --
983: procedure chk_entry_grade_rule_id
984: (p_position_id in hr_all_positions_f.position_id%TYPE
985: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
989: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

Line 986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE

982: --
983: procedure chk_entry_grade_rule_id
984: (p_position_id in hr_all_positions_f.position_id%TYPE
985: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
989: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
990: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

Line 988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

984: (p_position_id in hr_all_positions_f.position_id%TYPE
985: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
989: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
990: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
991: )
992: is

Line 989: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

985: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
989: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
990: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
991: )
992: is
993: --

Line 990: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

986: ,p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
989: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
990: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
991: )
992: is
993: --
994: l_exists varchar2(1);

Line 998: l_entry_grade_rule_id hr_all_positions_f.entry_grade_rule_id%TYPE;

994: l_exists varchar2(1);
995: l_api_updating boolean;
996: l_business_group_id number(15);
997: l_proc varchar2(72) ;
998: l_entry_grade_rule_id hr_all_positions_f.entry_grade_rule_id%TYPE;
999: --
1000: cursor csr_valid_grade_rule is
1001: select business_group_id
1002: from pay_grade_rules_f

Line 1112: (p_position_id in hr_all_positions_f.position_id%TYPE

1108: -- |------------------------< chk_pay_freq_payroll_id >-------------------------------|
1109: -- ---------------------------------------------------------------------------
1110: --
1111: procedure chk_pay_freq_payroll_id
1112: (p_position_id in hr_all_positions_f.position_id%TYPE
1113: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1114: ,p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE
1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

Line 1113: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE

1109: -- ---------------------------------------------------------------------------
1110: --
1111: procedure chk_pay_freq_payroll_id
1112: (p_position_id in hr_all_positions_f.position_id%TYPE
1113: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1114: ,p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE
1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1117: ,p_effective_date in date

Line 1114: ,p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE

1110: --
1111: procedure chk_pay_freq_payroll_id
1112: (p_position_id in hr_all_positions_f.position_id%TYPE
1113: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1114: ,p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE
1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1117: ,p_effective_date in date
1118: ,p_datetrack_mode in varchar2

Line 1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

1111: procedure chk_pay_freq_payroll_id
1112: (p_position_id in hr_all_positions_f.position_id%TYPE
1113: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1114: ,p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE
1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1117: ,p_effective_date in date
1118: ,p_datetrack_mode in varchar2
1119: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

Line 1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

1112: (p_position_id in hr_all_positions_f.position_id%TYPE
1113: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1114: ,p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE
1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1117: ,p_effective_date in date
1118: ,p_datetrack_mode in varchar2
1119: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
1120: )

Line 1119: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

1115: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1116: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1117: ,p_effective_date in date
1118: ,p_datetrack_mode in varchar2
1119: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
1120: )
1121: is
1122: --
1123: l_api_updating boolean;

Line 1264: -- If the POSITION_DEFINITION_ID in HR_ALL_POSITIONS_F table does not exist

1260: -- p_effective_date
1261: -- p_object_version_number
1262: --
1263: -- Post Success :
1264: -- If the POSITION_DEFINITION_ID in HR_ALL_POSITIONS_F table does not exist
1265: -- for given BUSINESS_GROUP_ID then processing continues
1266: --
1267: -- Post Failure :
1268: -- If the POSITION_DEFINITION_ID does exist in HR_ALL_POSITIONS_F table for given

Line 1268: -- If the POSITION_DEFINITION_ID does exist in HR_ALL_POSITIONS_F table for given

1264: -- If the POSITION_DEFINITION_ID in HR_ALL_POSITIONS_F table does not exist
1265: -- for given BUSINESS_GROUP_ID then processing continues
1266: --
1267: -- Post Failure :
1268: -- If the POSITION_DEFINITION_ID does exist in HR_ALL_POSITIONS_F table for given
1269: -- BUSINESS_GROUP_ID, then an application error will be raised and processing
1270: -- terminated
1271: --
1272: -- Access Status :

Line 1298: from hr_all_positions_f psf

1294: -- position definition id within the validation date range - except for
1295: -- the current position
1296: cursor csr_ccid_unique is
1297: select 'x'
1298: from hr_all_positions_f psf
1299: where psf.position_id <> nvl(p_position_id, -1)
1300: and psf.business_group_id = p_business_group_id
1301: and psf.position_definition_id = p_position_definition_id
1302: and psf.effective_start_date <= p_validation_end_date

Line 1453: from hr_all_positions_f psf

1449: l_proc varchar2(72) ;
1450: --
1451: cursor csr_name_unique is
1452: select 'x'
1453: from hr_all_positions_f psf
1454: where psf.name = p_name
1455: and (p_position_id is null or psf.position_id <> p_position_id)
1456: and psf.business_group_id = p_business_group_id;
1457: --

Line 1687: (p_position_id in hr_all_positions_f.position_id%TYPE

1683: -- |------------------------< chk_pay_basis_id >-------------------------------|
1684: -- ---------------------------------------------------------------------------
1685: --
1686: procedure chk_pay_basis_id
1687: (p_position_id in hr_all_positions_f.position_id%TYPE
1688: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1689: ,p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE
1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

Line 1688: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE

1684: -- ---------------------------------------------------------------------------
1685: --
1686: procedure chk_pay_basis_id
1687: (p_position_id in hr_all_positions_f.position_id%TYPE
1688: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1689: ,p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE
1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1692: ,p_effective_date in date

Line 1689: ,p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE

1685: --
1686: procedure chk_pay_basis_id
1687: (p_position_id in hr_all_positions_f.position_id%TYPE
1688: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1689: ,p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE
1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1692: ,p_effective_date in date
1693: ,p_datetrack_mode in varchar2

Line 1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

1686: procedure chk_pay_basis_id
1687: (p_position_id in hr_all_positions_f.position_id%TYPE
1688: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1689: ,p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE
1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1692: ,p_effective_date in date
1693: ,p_datetrack_mode in varchar2
1694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

Line 1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

1687: (p_position_id in hr_all_positions_f.position_id%TYPE
1688: ,p_business_group_id in hr_all_positions_f.business_group_id%TYPE
1689: ,p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE
1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1692: ,p_effective_date in date
1693: ,p_datetrack_mode in varchar2
1694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
1695: )

Line 1694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

1690: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
1691: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
1692: ,p_effective_date in date
1693: ,p_datetrack_mode in varchar2
1694: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
1695: )
1696: is
1697: --
1698: cursor c1 is

Line 1852: from hr_all_positions_f

1848: ,p_object_version_number in number default null) is
1849: --
1850: cursor c_get_eff_start_date (p_position_id number) is
1851: select min(effective_start_date)
1852: from hr_all_positions_f
1853: where position_id = p_position_id;
1854: --
1855: l_proc varchar2(72) ;
1856: l_api_updating boolean;

Line 2324: from hr_all_positions_f psf, per_shared_types sht

2320: l_api_updating boolean;
2321: --
2322: cursor csr_valid_successor_position (p_validation_start_date date) is
2323: select 'x'
2324: from hr_all_positions_f psf, per_shared_types sht
2325: where psf.position_id = p_successor_position_id
2326: and psf.availability_status_id = sht.shared_type_id
2327: and (sht.business_group_id = p_business_group_id
2328: or sht.business_group_id is null)

Line 2450: from hr_all_positions_f psf, per_shared_types sht

2446: l_api_updating boolean;
2447: --
2448: cursor csr_valid_relief_position (p_validation_start_date date) is
2449: select 'x'
2450: from hr_all_positions_f psf, per_shared_types sht
2451: where psf.position_id = p_relief_position_id
2452: and psf.availability_status_id = sht.shared_type_id
2453: and (sht.business_group_id = p_business_group_id
2454: or sht.business_group_id is null)

Line 2966: (p_position_id in hr_all_positions_f.position_id%TYPE

2962: -- |-------------------< chk_position_transaction_id >-----------------------|
2963: -- ---------------------------------------------------------------------------
2964: --
2965: procedure chk_position_transaction_id
2966: (p_position_id in hr_all_positions_f.position_id%TYPE
2967: ,p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE
2968: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
2969: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
2970: ,p_effective_date in date

Line 2967: ,p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE

2963: -- ---------------------------------------------------------------------------
2964: --
2965: procedure chk_position_transaction_id
2966: (p_position_id in hr_all_positions_f.position_id%TYPE
2967: ,p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE
2968: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
2969: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
2970: ,p_effective_date in date
2971: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

Line 2968: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE

2964: --
2965: procedure chk_position_transaction_id
2966: (p_position_id in hr_all_positions_f.position_id%TYPE
2967: ,p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE
2968: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
2969: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
2970: ,p_effective_date in date
2971: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
2972: )

Line 2969: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE

2965: procedure chk_position_transaction_id
2966: (p_position_id in hr_all_positions_f.position_id%TYPE
2967: ,p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE
2968: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
2969: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
2970: ,p_effective_date in date
2971: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
2972: )
2973: is

Line 2971: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE

2967: ,p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE
2968: ,p_validation_start_date in hr_all_positions_f.effective_start_date%TYPE
2969: ,p_validation_end_date in hr_all_positions_f.effective_end_date%TYPE
2970: ,p_effective_date in date
2971: ,p_object_version_number in hr_all_positions_f.object_version_number%TYPE
2972: )
2973: is
2974: --
2975: l_exists varchar2(1);

Line 3112: from hr_all_positions_f psf, per_shared_types sht

3108: l_api_updating boolean;
3109: --
3110: cursor csr_valid_supervisor_position (p_validation_start_date date) is
3111: select 'x'
3112: from hr_all_positions_f psf, per_shared_types sht
3113: where psf.position_id = p_supervisor_position_id
3114: and psf.availability_status_id = sht.shared_type_id
3115: and (sht.business_group_id = p_business_group_id
3116: or sht.business_group_id is null)

Line 3238: from hr_all_positions_f psf, per_shared_types sht

3234: l_api_updating boolean;
3235: --
3236: cursor csr_valid_prior_position (p_validation_start_date date) is
3237: select 'x'
3238: from hr_all_positions_f psf, per_shared_types sht
3239: where psf.position_id = p_prior_position_id
3240: and psf.availability_status_id = sht.shared_type_id
3241: and (sht.business_group_id = p_business_group_id
3242: or sht.business_group_id is null)

Line 4857: from hr_all_positions_f

4853: select p_validation_start_date start_date
4854: from dual
4855: union
4856: select effective_start_date start_date
4857: from hr_all_positions_f
4858: where effective_start_date between p_validation_start_date
4859: and p_validation_end_date
4860: and position_id = p_position_id
4861: union

Line 5382: (p_base_table_name => 'hr_all_positions_f',

5378: hr_utility.set_location(l_proc,20 );
5379: end if;
5380: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and
5381: NOT (dt_api.check_min_max_dates
5382: (p_base_table_name => 'hr_all_positions_f',
5383: p_base_key_column => 'position_id',
5384: p_base_key_value => p_relief_position_id,
5385: p_from_date => p_validation_start_date,
5386: p_to_date => p_validation_end_date))) Then

Line 5395: (p_base_table_name => 'hr_all_positions_f',

5391: hr_utility.set_location(l_proc,30 );
5392: end if;
5393: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and
5394: NOT (dt_api.check_min_max_dates
5395: (p_base_table_name => 'hr_all_positions_f',
5396: p_base_key_column => 'position_id',
5397: p_base_key_value => p_successor_position_id,
5398: p_from_date => p_validation_start_date,
5399: p_to_date => p_validation_end_date))) Then

Line 5408: (p_base_table_name => 'hr_all_positions_f',

5404: hr_utility.set_location(l_proc,40 );
5405: end if;
5406: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and
5407: NOT (dt_api.check_min_max_dates
5408: (p_base_table_name => 'hr_all_positions_f',
5409: p_base_key_column => 'position_id',
5410: p_base_key_value => p_supervisor_position_id,
5411: p_from_date => p_validation_start_date,
5412: p_to_date => p_validation_end_date))) Then

Line 5565: (p_base_table_name => 'hr_all_positions_f',

5561: p_argument => 'position_id',
5562: p_argument_value => p_position_id);
5563: --
5564: If (dt_api.rows_exist
5565: (p_base_table_name => 'hr_all_positions_f',
5566: p_base_key_column => 'relief_position_id',
5567: p_base_key_value => p_position_id,
5568: p_from_date => p_validation_start_date,
5569: p_to_date => p_validation_end_date)) Then

Line 5575: (p_base_table_name => 'hr_all_positions_f',

5571: Raise l_rows_exist;
5572: End If;
5573:
5574: If (dt_api.rows_exist
5575: (p_base_table_name => 'hr_all_positions_f',
5576: p_base_key_column => 'supervisor_position_id',
5577: p_base_key_value => p_position_id,
5578: p_from_date => p_validation_start_date,
5579: p_to_date => p_validation_end_date)) Then

Line 5584: (p_base_table_name => 'hr_all_positions_f',

5580: l_table_name := 'all positions';
5581: Raise l_rows_exist;
5582: End If;
5583: If (dt_api.rows_exist
5584: (p_base_table_name => 'hr_all_positions_f',
5585: p_base_key_column => 'successor_position_id',
5586: p_base_key_value => p_position_id,
5587: p_from_date => p_validation_start_date,
5588: p_to_date => p_validation_end_date)) Then

Line 5594: (p_base_table_name => 'hr_all_positions_f',

5590: Raise l_rows_exist;
5591: End If;
5592: /*
5593: If (dt_api.rows_exist
5594: (p_base_table_name => 'hr_all_positions_f',
5595: p_base_key_column => 'prior_position_id',
5596: p_base_key_value => p_position_id,
5597: p_from_date => p_validation_start_date,
5598: p_to_date => p_validation_end_date)) Then

Line 7146: from hr_all_positions_f

7142: -- fetches the next row info. given effective start date
7143: cursor next_row(p_effective_start_date date) is
7144: select effective_start_date,effective_end_date
7145: ,hr_psf_shd.get_availability_status(availability_status_id,p_business_group_id)
7146: from hr_all_positions_f
7147: where position_id = p_position_id
7148: and effective_start_date > p_effective_start_date
7149: order by effective_start_date ;
7150: cursor current_row is

Line 7152: from hr_all_positions_f

7148: and effective_start_date > p_effective_start_date
7149: order by effective_start_date ;
7150: cursor current_row is
7151: select effective_start_date,effective_end_date
7152: from hr_all_positions_f
7153: where position_id = p_position_id
7154: and object_version_number = p_object_version_number ;
7155: cursor pos_all is
7156: select date_effective

Line 7157: from hr_all_positions_f

7153: where position_id = p_position_id
7154: and object_version_number = p_object_version_number ;
7155: cursor pos_all is
7156: select date_effective
7157: from hr_all_positions_f
7158: where position_id = p_position_id
7159: for update of date_effective;
7160: begin
7161: if g_debug then

Line 7190: update hr_all_positions_f

7186: if g_debug then
7187: hr_utility.set_location('next row active changing date effective '||l_proc,35);
7188: end if;
7189: for i in pos_all loop
7190: update hr_all_positions_f
7191: set date_effective = l_next_esd
7192: where current of pos_all ;
7193: end loop;
7194: end if;

Line 7376: from hr_all_positions_f

7372: select '1'
7373: into l_exists
7374: from sys.dual
7375: where exists(select null
7376: from hr_all_positions_f
7377: where successor_position_id = p_position_id);
7378: exception when no_data_found then
7379: null;
7380:

Line 7397: from hr_all_positions_f

7393: select '1'
7394: into l_exists
7395: from sys.dual
7396: where exists(select null
7397: from hr_all_positions_f
7398: where supervisor_position_id = p_position_id);
7399: exception when no_data_found then
7400: null;
7401:

Line 7760: ,p_descflex_name => 'DDF HR_ALL_POSITIONS_F'

7756: then
7757: --
7758: hr_dflex_utility.ins_or_upd_descflex_attribs
7759: (p_appl_short_name => 'PER'
7760: ,p_descflex_name => 'DDF HR_ALL_POSITIONS_F'
7761: ,p_attribute_category => p_rec.information_category
7762: ,p_attribute1_name => 'information1'
7763: ,p_attribute1_value => p_rec.information1
7764: ,p_attribute2_name => 'information2'

Line 8143: hr_all_positions_f psf

8139: --
8140: cursor c1 is
8141: select min(psf.effective_start_date)
8142: from
8143: hr_all_positions_f psf
8144: where psf.position_id = p_position_id
8145: and hr_psf_shd.get_availability_status(psf.availability_status_id
8146: ,psf.business_group_id) = 'ACTIVE';
8147:

Line 8202: hr_all_positions_f psf

8198: --
8199: cursor c1 is
8200: select count(*)
8201: from
8202: hr_all_positions_f psf
8203: where psf.position_id = p_position_id
8204: and hr_psf_shd.get_availability_status(psf.availability_status_id
8205: ,psf.business_group_id) <> 'PROPOSED';
8206: --

Line 8210: hr_all_positions_f psf

8206: --
8207: cursor c2 is
8208: select min(psf.effective_Start_Date)
8209: from
8210: hr_all_positions_f psf
8211: where psf.position_id = p_position_id;
8212: --
8213: Begin
8214: --

Line 8262: hr_all_positions_f psf

8258: --
8259: cursor c1 is
8260: select count(*)
8261: from
8262: hr_all_positions_f psf
8263: where psf.position_id = p_position_id
8264: and hr_psf_shd.get_availability_status(psf.availability_status_id
8265: ,psf.business_group_id) <> 'PROPOSED';
8266: --

Line 8298: hr_all_positions_f psf

8294: cursor c1 is
8295: select
8296: min(psf.effective_start_date)
8297: from
8298: hr_all_positions_f psf
8299: where psf.position_id = p_position_id;
8300: --
8301: cursor c2 is
8302: select max(effective_start_date)

Line 8303: from hr_all_positions_f psf

8299: where psf.position_id = p_position_id;
8300: --
8301: cursor c2 is
8302: select max(effective_start_date)
8303: from hr_all_positions_f psf
8304: where psf.position_id = p_position_id
8305: and psf.effective_start_date < p_effective_start_date;
8306: --
8307: l_proposed_only boolean ;

Line 8365: from hr_all_positions_f psf

8361: l_proc varchar2(30) ;
8362: --
8363: cursor c1 is
8364: select max(psf.effective_start_date)
8365: from hr_all_positions_f psf
8366: where psf.position_id = p_position_id;
8367: --
8368: cursor c2 is
8369: select min(effective_start_date)

Line 8375: from hr_all_positions_f psf

8371: where paf.position_id = p_position_id;
8372: --
8373: cursor c3 is
8374: select min(effective_start_date)
8375: from hr_all_positions_f psf
8376: where psf.position_id = p_position_id
8377: and psf.effective_start_date > p_effective_start_date;
8378: --
8379: l_proposed_only boolean;