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 4858: from hr_all_positions_f

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

Line 5499: (p_base_table_name => 'hr_all_positions_f',

5495: hr_utility.set_location(l_proc,20 );
5496: end if;
5497: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and
5498: NOT (dt_api.check_min_max_dates
5499: (p_base_table_name => 'hr_all_positions_f',
5500: p_base_key_column => 'position_id',
5501: p_base_key_value => p_relief_position_id,
5502: p_from_date => p_validation_start_date,
5503: p_to_date => p_validation_end_date))) Then

Line 5512: (p_base_table_name => 'hr_all_positions_f',

5508: hr_utility.set_location(l_proc,30 );
5509: end if;
5510: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and
5511: NOT (dt_api.check_min_max_dates
5512: (p_base_table_name => 'hr_all_positions_f',
5513: p_base_key_column => 'position_id',
5514: p_base_key_value => p_successor_position_id,
5515: p_from_date => p_validation_start_date,
5516: p_to_date => p_validation_end_date))) Then

Line 5525: (p_base_table_name => 'hr_all_positions_f',

5521: hr_utility.set_location(l_proc,40 );
5522: end if;
5523: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and
5524: NOT (dt_api.check_min_max_dates
5525: (p_base_table_name => 'hr_all_positions_f',
5526: p_base_key_column => 'position_id',
5527: p_base_key_value => p_supervisor_position_id,
5528: p_from_date => p_validation_start_date,
5529: p_to_date => p_validation_end_date))) Then

Line 5682: (p_base_table_name => 'hr_all_positions_f',

5678: p_argument => 'position_id',
5679: p_argument_value => p_position_id);
5680: --
5681: If (dt_api.rows_exist
5682: (p_base_table_name => 'hr_all_positions_f',
5683: p_base_key_column => 'relief_position_id',
5684: p_base_key_value => p_position_id,
5685: p_from_date => p_validation_start_date,
5686: p_to_date => p_validation_end_date)) Then

Line 5692: (p_base_table_name => 'hr_all_positions_f',

5688: Raise l_rows_exist;
5689: End If;
5690:
5691: If (dt_api.rows_exist
5692: (p_base_table_name => 'hr_all_positions_f',
5693: p_base_key_column => 'supervisor_position_id',
5694: p_base_key_value => p_position_id,
5695: p_from_date => p_validation_start_date,
5696: p_to_date => p_validation_end_date)) Then

Line 5701: (p_base_table_name => 'hr_all_positions_f',

5697: l_table_name := 'all positions';
5698: Raise l_rows_exist;
5699: End If;
5700: If (dt_api.rows_exist
5701: (p_base_table_name => 'hr_all_positions_f',
5702: p_base_key_column => 'successor_position_id',
5703: p_base_key_value => p_position_id,
5704: p_from_date => p_validation_start_date,
5705: p_to_date => p_validation_end_date)) Then

Line 5711: (p_base_table_name => 'hr_all_positions_f',

5707: Raise l_rows_exist;
5708: End If;
5709: /*
5710: If (dt_api.rows_exist
5711: (p_base_table_name => 'hr_all_positions_f',
5712: p_base_key_column => 'prior_position_id',
5713: p_base_key_value => p_position_id,
5714: p_from_date => p_validation_start_date,
5715: p_to_date => p_validation_end_date)) Then

Line 7263: from hr_all_positions_f

7259: -- fetches the next row info. given effective start date
7260: cursor next_row(p_effective_start_date date) is
7261: select effective_start_date,effective_end_date
7262: ,hr_psf_shd.get_availability_status(availability_status_id,p_business_group_id)
7263: from hr_all_positions_f
7264: where position_id = p_position_id
7265: and effective_start_date > p_effective_start_date
7266: order by effective_start_date ;
7267: cursor current_row is

Line 7269: from hr_all_positions_f

7265: and effective_start_date > p_effective_start_date
7266: order by effective_start_date ;
7267: cursor current_row is
7268: select effective_start_date,effective_end_date
7269: from hr_all_positions_f
7270: where position_id = p_position_id
7271: and object_version_number = p_object_version_number ;
7272: cursor pos_all is
7273: select date_effective

Line 7274: from hr_all_positions_f

7270: where position_id = p_position_id
7271: and object_version_number = p_object_version_number ;
7272: cursor pos_all is
7273: select date_effective
7274: from hr_all_positions_f
7275: where position_id = p_position_id
7276: for update of date_effective;
7277: begin
7278: if g_debug then

Line 7307: update hr_all_positions_f

7303: if g_debug then
7304: hr_utility.set_location('next row active changing date effective '||l_proc,35);
7305: end if;
7306: for i in pos_all loop
7307: update hr_all_positions_f
7308: set date_effective = l_next_esd
7309: where current of pos_all ;
7310: end loop;
7311: end if;

Line 7496: from hr_all_positions_f

7492: select '1'
7493: into l_exists
7494: from sys.dual
7495: where exists(select null
7496: from hr_all_positions_f
7497: where successor_position_id = p_position_id);
7498: exception when no_data_found then
7499: null;
7500:

Line 7517: from hr_all_positions_f

7513: select '1'
7514: into l_exists
7515: from sys.dual
7516: where exists(select null
7517: from hr_all_positions_f
7518: where supervisor_position_id = p_position_id);
7519: exception when no_data_found then
7520: null;
7521:

Line 7887: ,p_descflex_name => 'DDF HR_ALL_POSITIONS_F'

7883: then
7884: --
7885: hr_dflex_utility.ins_or_upd_descflex_attribs
7886: (p_appl_short_name => 'PER'
7887: ,p_descflex_name => 'DDF HR_ALL_POSITIONS_F'
7888: ,p_attribute_category => p_rec.information_category
7889: ,p_attribute1_name => 'information1'
7890: ,p_attribute1_value => p_rec.information1
7891: ,p_attribute2_name => 'information2'

Line 8270: hr_all_positions_f psf

8266: --
8267: cursor c1 is
8268: select min(psf.effective_start_date)
8269: from
8270: hr_all_positions_f psf
8271: where psf.position_id = p_position_id
8272: and hr_psf_shd.get_availability_status(psf.availability_status_id
8273: ,psf.business_group_id) = 'ACTIVE';
8274:

Line 8329: hr_all_positions_f psf

8325: --
8326: cursor c1 is
8327: select count(*)
8328: from
8329: hr_all_positions_f psf
8330: where psf.position_id = p_position_id
8331: and hr_psf_shd.get_availability_status(psf.availability_status_id
8332: ,psf.business_group_id) <> 'PROPOSED';
8333: --

Line 8337: hr_all_positions_f psf

8333: --
8334: cursor c2 is
8335: select min(psf.effective_Start_Date)
8336: from
8337: hr_all_positions_f psf
8338: where psf.position_id = p_position_id;
8339: --
8340: Begin
8341: --

Line 8389: hr_all_positions_f psf

8385: --
8386: cursor c1 is
8387: select count(*)
8388: from
8389: hr_all_positions_f psf
8390: where psf.position_id = p_position_id
8391: and hr_psf_shd.get_availability_status(psf.availability_status_id
8392: ,psf.business_group_id) <> 'PROPOSED';
8393: --

Line 8425: hr_all_positions_f psf

8421: cursor c1 is
8422: select
8423: min(psf.effective_start_date)
8424: from
8425: hr_all_positions_f psf
8426: where psf.position_id = p_position_id;
8427: --
8428: cursor c2 is
8429: select max(effective_start_date)

Line 8430: from hr_all_positions_f psf

8426: where psf.position_id = p_position_id;
8427: --
8428: cursor c2 is
8429: select max(effective_start_date)
8430: from hr_all_positions_f psf
8431: where psf.position_id = p_position_id
8432: and psf.effective_start_date < p_effective_start_date;
8433: --
8434: l_proposed_only boolean ;

Line 8492: from hr_all_positions_f psf

8488: l_proc varchar2(30) ;
8489: --
8490: cursor c1 is
8491: select max(psf.effective_start_date)
8492: from hr_all_positions_f psf
8493: where psf.position_id = p_position_id;
8494: --
8495: cursor c2 is
8496: select min(effective_start_date)

Line 8502: from hr_all_positions_f psf

8498: where paf.position_id = p_position_id;
8499: --
8500: cursor c3 is
8501: select min(effective_start_date)
8502: from hr_all_positions_f psf
8503: where psf.position_id = p_position_id
8504: and psf.effective_start_date > p_effective_start_date;
8505: --
8506: l_proposed_only boolean;