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.PER_SPP_BUS dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 50: (p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE

46: --
47: -- {End Of Comments}
48: -- ----------------------------------------------------------------------------
49: procedure chk_assignment_id
50: (p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE
51: ,p_datetrack_mode in varchar2
52: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
53: ,p_object_version_number in
54: per_spinal_point_placements_f.object_version_number%TYPE

Line 52: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE

48: -- ----------------------------------------------------------------------------
49: procedure chk_assignment_id
50: (p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE
51: ,p_datetrack_mode in varchar2
52: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
53: ,p_object_version_number in
54: per_spinal_point_placements_f.object_version_number%TYPE
55: ,p_effective_date in date
56: )

Line 54: per_spinal_point_placements_f.object_version_number%TYPE

50: (p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE
51: ,p_datetrack_mode in varchar2
52: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
53: ,p_object_version_number in
54: per_spinal_point_placements_f.object_version_number%TYPE
55: ,p_effective_date in date
56: )
57: -- Bug 2488727 added parameter effective date
58: is

Line 75: from per_spinal_point_placements_f

71: effective_start_date and effective_end_date;
72:
73: cursor csr_placement_exists is
74: select placement_id
75: from per_spinal_point_placements_f
76: where assignment_id = p_assignment_id
77: and p_effective_date between
78: effective_start_date and effective_end_date;
79: --

Line 169: (p_step_id in per_spinal_point_placements_f.step_id%TYPE

165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: procedure chk_pay_ass_ceiling
169: (p_step_id in per_spinal_point_placements_f.step_id%TYPE
170: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
171: ,p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE
172: ,p_effective_date in date
173: )

Line 170: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE

166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: procedure chk_pay_ass_ceiling
169: (p_step_id in per_spinal_point_placements_f.step_id%TYPE
170: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
171: ,p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE
172: ,p_effective_date in date
173: )
174: is

Line 171: ,p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE

167: -- ----------------------------------------------------------------------------
168: procedure chk_pay_ass_ceiling
169: (p_step_id in per_spinal_point_placements_f.step_id%TYPE
170: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
171: ,p_assignment_id in per_spinal_point_placements_f.assignment_id%TYPE
172: ,p_effective_date in date
173: )
174: is
175: --

Line 328: (p_reason IN per_spinal_point_placements_f.reason%TYPE

324: --
325: -- ---------------------------------------------------------------------------
326: --
327: PROCEDURE chk_reason
328: (p_reason IN per_spinal_point_placements_f.reason%TYPE
329: ,p_effective_date IN date) IS
330: --
331: -- Declare Local Variables
332: --

Line 395: (p_placement_id in per_spinal_point_placements_f.placement_id%TYPE

391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: procedure chk_object_version_number
395: (p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
396: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE
397: ,p_effective_date in date
398: )
399: is

Line 396: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE

392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: procedure chk_object_version_number
395: (p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
396: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE
397: ,p_effective_date in date
398: )
399: is
400: --

Line 408: from per_spinal_point_placements_f spp

404: l_object_version_number number;
405: --
406: cursor csr_valid_ovn is
407: select object_version_number spp
408: from per_spinal_point_placements_f spp
409: where spp.placement_id = p_placement_id
410: and p_effective_date between spp.effective_start_date
411: and spp.effective_end_date
412: and object_version_number = p_object_version_number;

Line 482: (p_auto_increment_flag in per_spinal_point_placements_f.auto_increment_flag%TYPE

478: --
479: -- {End Of Comments}
480: -- ----------------------------------------------------------------------------
481: procedure chk_auto_inc_flag
482: (p_auto_increment_flag in per_spinal_point_placements_f.auto_increment_flag%TYPE
483: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
484: ,p_increment_number in per_spinal_point_placements_f.increment_number%TYPE
485: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE
486: )

Line 483: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE

479: -- {End Of Comments}
480: -- ----------------------------------------------------------------------------
481: procedure chk_auto_inc_flag
482: (p_auto_increment_flag in per_spinal_point_placements_f.auto_increment_flag%TYPE
483: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
484: ,p_increment_number in per_spinal_point_placements_f.increment_number%TYPE
485: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE
486: )
487: is

Line 484: ,p_increment_number in per_spinal_point_placements_f.increment_number%TYPE

480: -- ----------------------------------------------------------------------------
481: procedure chk_auto_inc_flag
482: (p_auto_increment_flag in per_spinal_point_placements_f.auto_increment_flag%TYPE
483: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
484: ,p_increment_number in per_spinal_point_placements_f.increment_number%TYPE
485: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE
486: )
487: is
488: --

Line 485: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE

481: procedure chk_auto_inc_flag
482: (p_auto_increment_flag in per_spinal_point_placements_f.auto_increment_flag%TYPE
483: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
484: ,p_increment_number in per_spinal_point_placements_f.increment_number%TYPE
485: ,p_object_version_number in per_spinal_point_placements_f.object_version_number%TYPE
486: )
487: is
488: --
489: l_proc varchar2(72) := g_package||'chk_auto_inc_flag';

Line 609: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

605: is
606: --
607: l_proc varchar2(72) := g_package||'chk_reason_only_update';
608: --
609: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;

Line 610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

606: --
607: l_proc varchar2(72) := g_package||'chk_reason_only_update';
608: --
609: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

Line 611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

607: l_proc varchar2(72) := g_package||'chk_reason_only_update';
608: --
609: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;

Line 612: l_step_id per_spinal_point_placements_f.step_id%TYPE;

608: --
609: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;
616: l_old_rec per_spp_shd.g_rec_type;

Line 613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;

609: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;
616: l_old_rec per_spp_shd.g_rec_type;
617: --

Line 614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

610: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;
616: l_old_rec per_spp_shd.g_rec_type;
617: --
618:

Line 615: l_reason per_spinal_point_placements_f.reason%TYPE;

611: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;
616: l_old_rec per_spp_shd.g_rec_type;
617: --
618:
619: cursor csr_reason_1 is

Line 627: from per_spinal_point_placements_f

623: step_id,
624: auto_increment_flag,
625: parent_spine_id,
626: reason
627: from per_spinal_point_placements_f
628: where placement_id = p_rec.placement_id
629: and p_effective_date between effective_start_date
630: and effective_end_date;
631:

Line 716: (p_step_id in per_spinal_point_placements_f.step_id%TYPE

712: --
713: -- {End Of Comments}
714: -- ----------------------------------------------------------------------------
715: procedure chk_parent_spine_step_id
716: (p_step_id in per_spinal_point_placements_f.step_id%TYPE
717: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
718: ,p_effective_start_date in
719: per_spinal_point_placements_f.effective_start_date%TYPE
720: ,p_effective_end_date in

Line 717: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE

713: -- {End Of Comments}
714: -- ----------------------------------------------------------------------------
715: procedure chk_parent_spine_step_id
716: (p_step_id in per_spinal_point_placements_f.step_id%TYPE
717: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
718: ,p_effective_start_date in
719: per_spinal_point_placements_f.effective_start_date%TYPE
720: ,p_effective_end_date in
721: per_spinal_point_placements_f.effective_end_date%TYPE

Line 719: per_spinal_point_placements_f.effective_start_date%TYPE

715: procedure chk_parent_spine_step_id
716: (p_step_id in per_spinal_point_placements_f.step_id%TYPE
717: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
718: ,p_effective_start_date in
719: per_spinal_point_placements_f.effective_start_date%TYPE
720: ,p_effective_end_date in
721: per_spinal_point_placements_f.effective_end_date%TYPE
722: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
723: ,p_object_version_number in

Line 721: per_spinal_point_placements_f.effective_end_date%TYPE

717: ,p_parent_spine_id in per_spinal_point_placements_f.parent_spine_id%TYPE
718: ,p_effective_start_date in
719: per_spinal_point_placements_f.effective_start_date%TYPE
720: ,p_effective_end_date in
721: per_spinal_point_placements_f.effective_end_date%TYPE
722: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
723: ,p_object_version_number in
724: per_spinal_point_placements_f.object_version_number%TYPE
725: )

Line 722: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE

718: ,p_effective_start_date in
719: per_spinal_point_placements_f.effective_start_date%TYPE
720: ,p_effective_end_date in
721: per_spinal_point_placements_f.effective_end_date%TYPE
722: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
723: ,p_object_version_number in
724: per_spinal_point_placements_f.object_version_number%TYPE
725: )
726: is

Line 724: per_spinal_point_placements_f.object_version_number%TYPE

720: ,p_effective_end_date in
721: per_spinal_point_placements_f.effective_end_date%TYPE
722: ,p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
723: ,p_object_version_number in
724: per_spinal_point_placements_f.object_version_number%TYPE
725: )
726: is
727: --
728: l_proc varchar2(72) := g_package||'chk_parent_spine_step_id';

Line 890: (p_placement_id in per_spinal_point_placements_f.placement_id%TYPE

886: --
887: -- {End Of Comments}
888: -- ----------------------------------------------------------------------------
889: procedure chk_future_asg_changes
890: (p_placement_id in per_spinal_point_placements_f.placement_id%TYPE
891: ,p_effective_date in date
892: ,p_datetrack_mode in varchar2
893: )
894: as

Line 912: from per_all_assignments_f paf, per_spinal_point_placements_f psf

908: --Cursor to select current assignemnt grade.
909: --
910: cursor c_curr_grade is
911: select paf.grade_id , paf.assignment_id
912: from per_all_assignments_f paf, per_spinal_point_placements_f psf
913: where paf.assignment_id = psf.assignment_id
914: and psf.placement_id = p_placement_id
915: and p_effective_date between psf.effective_start_Date and psf.effective_end_date
916: and p_effective_date between paf.effective_start_Date and paf.effective_end_date;

Line 923: from per_spinal_point_placements_f pspf

919: -- Cursor to select effective end date of next spp record.
920: --
921: cursor c_next_spp_eed is
922: select pspf.effective_end_date
923: from per_spinal_point_placements_f pspf
924: where pspf.placement_id = p_placement_id
925: and pspf.effective_start_date > p_effective_Date
926: order by pspf.effective_end_date ;
927:

Line 1018: , per_spinal_point_placements_f spp

1014: --
1015: cursor csr_sec_grp is
1016: select pbg.security_group_id
1017: from per_business_groups pbg
1018: , per_spinal_point_placements_f spp
1019: where spp.placement_id = p_placement_id
1020: and pbg.business_group_id = spp.business_group_id;
1021: --
1022: -- Declare local variables

Line 1078: , per_spinal_point_placements_f spp

1074: --
1075: cursor csr_leg_code is
1076: select pbg.legislation_code
1077: from per_business_groups pbg
1078: , per_spinal_point_placements_f spp
1079: where spp.placement_id = p_placement_id
1080: and pbg.business_group_id = spp.business_group_id;
1081: --
1082: -- Declare local variables

Line 1438: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

1434: ,p_validation_end_date in date
1435: ) is
1436: --
1437: l_proc varchar2(72) := g_package||'insert_validate';
1438: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1439: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1440: --
1441: Begin
1442: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1439: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

1435: ) is
1436: --
1437: l_proc varchar2(72) := g_package||'insert_validate';
1438: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1439: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1440: --
1441: Begin
1442: hr_utility.set_location('Entering:'||l_proc, 5);
1443: --

Line 1511: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

1507: ,p_validation_end_date in out nocopy date
1508: ) is
1509: --
1510: l_proc varchar2(72) := g_package||'update_validate';
1511: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1512: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1513: --
1514: --csr_start_end_date select the start and end date for the record being modified
1515: --

Line 1512: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

1508: ) is
1509: --
1510: l_proc varchar2(72) := g_package||'update_validate';
1511: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1512: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1513: --
1514: --csr_start_end_date select the start and end date for the record being modified
1515: --
1516: cursor csr_start_end_date is

Line 1519: from per_spinal_point_placements_f spp

1515: --
1516: cursor csr_start_end_date is
1517: select spp.effective_start_date,
1518: spp.effective_end_date
1519: from per_spinal_point_placements_f spp
1520: where spp.placement_id = p_rec.placement_id
1521: and spp.assignment_id = p_rec.assignment_id
1522: and p_effective_date between spp.effective_start_date
1523: and spp.effective_end_date ;