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_INS dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 69: from per_spinal_point_placements_f t

65: --
66: Cursor C_Sel1 Is
67: select t.created_by,
68: t.creation_date
69: from per_spinal_point_placements_f t
70: where t.placement_id = p_rec.placement_id
71: and t.effective_start_date =
72: per_spp_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);

Line 76: l_created_by per_spinal_point_placements_f.created_by%TYPE;

72: per_spp_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_spinal_point_placements_f.created_by%TYPE;
77: l_creation_date per_spinal_point_placements_f.creation_date%TYPE;
78: l_last_update_date per_spinal_point_placements_f.last_update_date%TYPE;
79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;
80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;

Line 77: l_creation_date per_spinal_point_placements_f.creation_date%TYPE;

73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_spinal_point_placements_f.created_by%TYPE;
77: l_creation_date per_spinal_point_placements_f.creation_date%TYPE;
78: l_last_update_date per_spinal_point_placements_f.last_update_date%TYPE;
79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;
80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;
81: --

Line 78: l_last_update_date per_spinal_point_placements_f.last_update_date%TYPE;

74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_spinal_point_placements_f.created_by%TYPE;
77: l_creation_date per_spinal_point_placements_f.creation_date%TYPE;
78: l_last_update_date per_spinal_point_placements_f.last_update_date%TYPE;
79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;
80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;
81: --
82: Begin

Line 79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;

75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_spinal_point_placements_f.created_by%TYPE;
77: l_creation_date per_spinal_point_placements_f.creation_date%TYPE;
78: l_last_update_date per_spinal_point_placements_f.last_update_date%TYPE;
79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;
80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);

Line 80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;

76: l_created_by per_spinal_point_placements_f.created_by%TYPE;
77: l_creation_date per_spinal_point_placements_f.creation_date%TYPE;
78: l_last_update_date per_spinal_point_placements_f.last_update_date%TYPE;
79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;
80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --

Line 89: (p_base_table_name => 'per_spinal_point_placements_f'

85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=
88: dt_api.get_object_version_number
89: (p_base_table_name => 'per_spinal_point_placements_f'
90: ,p_base_key_column => 'placement_id'
91: ,p_base_key_value => p_rec.placement_id
92: );
93: --

Line 132: -- Insert the row into: per_spinal_point_placements_f

128: End If;
129: --
130: per_spp_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: per_spinal_point_placements_f
133: --
134: insert into per_spinal_point_placements_f
135: (placement_id
136: ,effective_start_date

Line 134: insert into per_spinal_point_placements_f

130: per_spp_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: per_spinal_point_placements_f
133: --
134: insert into per_spinal_point_placements_f
135: (placement_id
136: ,effective_start_date
137: ,effective_end_date
138: ,business_group_id

Line 369: FROM per_spinal_point_placements_f spp

365: CURSOR csr_future_spp_records(p_assignment_id number, p_effective_date date) IS
366: SELECT spp.placement_id,
367: spp.object_version_number,
368: spp.effective_start_date
369: FROM per_spinal_point_placements_f spp
370: WHERE spp.assignment_id = p_assignment_id
371: AND spp.effective_start_date > p_effective_date;
372: -- ORDER BY placement_id; Bug fix: 3648542
373: --

Line 375: l_previous_id per_spinal_point_placements_f.placement_id%type;

371: AND spp.effective_start_date > p_effective_date;
372: -- ORDER BY placement_id; Bug fix: 3648542
373: --
374: --
375: l_previous_id per_spinal_point_placements_f.placement_id%type;
376: l_object_version_number NUMBER;
377: l_effective_start_date DATE;
378: l_effective_end_date DATE;
379: l_proc VARCHAR2(72) := g_package||'delete_future_spps';

Line 440: from per_spinal_point_placements_f spp

436: select spp.placement_id
437: -- ,spp.effective_start_date
438: -- ,spp.effective_end_date
439: -- ,spp.step_id
440: from per_spinal_point_placements_f spp
441: where spp.assignment_id = p_assignment_id
442: and spp.effective_start_date > p_effective_date;
443: --
444: -- select the earliest of (effective_start_date-1) for existing spps.

Line 448: from per_spinal_point_placements_f spp

444: -- select the earliest of (effective_start_date-1) for existing spps.
445: --
446: Cursor spp_end_date(p_assignment_id number, p_effective_date date) IS
447: select min(spp.effective_start_date-1)
448: from per_spinal_point_placements_f spp
449: where spp.assignment_id = p_assignment_id
450: and spp.effective_start_date > p_effective_date;
451: --
452: --

Line 509: from per_spinal_point_placements_f spp

505: ,spp.effective_start_date
506: ,spp.effective_end_date
507: ,spp.object_version_number
508: ,spp.step_id
509: from per_spinal_point_placements_f spp
510: where spp.assignment_id = p_assignment_id
511: and p_effective_date between spp.effective_start_date and spp.effective_end_date;
512: --
513: --

Line 517: l_placement_id per_spinal_point_placements_f.placement_id%type;

513: --
514: --
515: l_proc varchar2(72) := g_package||'sync_spp_asg';
516: l_assignment_id per_all_assignments_f.assignment_id%type;
517: l_placement_id per_spinal_point_placements_f.placement_id%type;
518: l_future_spp_id per_spinal_point_placements_f.placement_id%type;
519: l_end_date DATE;
520: l_validation_start_date DATE;
521: l_validation_end_date DATE;

Line 518: l_future_spp_id per_spinal_point_placements_f.placement_id%type;

514: --
515: l_proc varchar2(72) := g_package||'sync_spp_asg';
516: l_assignment_id per_all_assignments_f.assignment_id%type;
517: l_placement_id per_spinal_point_placements_f.placement_id%type;
518: l_future_spp_id per_spinal_point_placements_f.placement_id%type;
519: l_end_date DATE;
520: l_validation_start_date DATE;
521: l_validation_end_date DATE;
522: l_spp_delete_warning BOOLEAN;

Line 805: update per_spinal_point_placements_f

801: hr_utility.set_location(l_proc, 6);
802: --
803: if l_step_end_date < p_rec.effective_end_date then
804:
805: update per_spinal_point_placements_f
806: set effective_end_date = l_step_end_date
807: where placement_id = p_rec.placement_id
808: and effective_start_date = p_rec.effective_start_date;
809:

Line 874: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'

870: --
871: when hr_api.cannot_find_prog_unit then
872: --
873: hr_api.cannot_find_prog_unit_error
874: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
875: ,p_hook_type => 'AI');
876: --
877: end;
878: --

Line 972: ,p_base_table_name => 'per_spinal_point_placements_f'

968:
969: dt_api.validate_dt_mode
970: (p_effective_date => p_effective_date
971: ,p_datetrack_mode => p_datetrack_mode
972: ,p_base_table_name => 'per_spinal_point_placements_f'
973: ,p_base_key_column => 'placement_id'
974: ,p_base_key_value => p_rec.placement_id
975: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
976: ,p_parent_key_column1 => 'step_id'

Line 991: ,p_base_table_name => 'per_spinal_point_placements_f'

987: --
988: dt_api.validate_dt_mode
989: (p_effective_date => p_effective_date
990: ,p_datetrack_mode => p_datetrack_mode
991: ,p_base_table_name => 'per_spinal_point_placements_f'
992: ,p_base_key_column => 'placement_id'
993: ,p_base_key_value => p_rec.placement_id
994: --,p_parent_table_name1 => 'per_spinal_point_steps_f'
995: --,p_parent_key_column1 => 'step_id'

Line 1171: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

1167: ) is
1168: --
1169: l_rec per_spp_shd.g_rec_type;
1170: l_proc varchar2(72) := g_package||'ins';
1171: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
1172: --
1173: cursor chk_step_valid_for_grade is
1174: select parent_spine_id
1175: from per_grade_spines_f pgs,