APPS.PER_SPINAL_PT_PLCMT_PKG dependencies on PER_SPINAL_PT_PLCMT_PKG

Line 1: package body PER_SPINAL_PT_PLCMT_PKG as

1: package body PER_SPINAL_PT_PLCMT_PKG as
2: /* $Header: pespp01t.pkb 120.0 2005/05/31 21:28:38 appldev noship $ */
3:
4: procedure check_ass_end(p_ass_id IN NUMBER,
5: p_sess IN DATE,

Line 18: hr_utility.set_location('per_spinal_pt_plcmt_pkg.check_ass_end',1);

14: and a.grade_id <> p_grd_id;
15: --
16: begin
17: --
18: hr_utility.set_location('per_spinal_pt_plcmt_pkg.check_ass_end',1);
19: --
20: open c20;
21: --
22: fetch c20 into l_exists;

Line 48: hr_utility.set_location('per_spinal_pt_plcmt_pkg.b_delete_valid',1);

44: and effective_start_date > p_eed;
45: --
46: begin
47: --
48: hr_utility.set_location('per_spinal_pt_plcmt_pkg.b_delete_valid',1);
49: --
50: open c1;
51: --
52: fetch c1 into l_exists;

Line 99: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',1);

95: --
96: l_count NUMBER;
97: begin
98: --
99: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',1);
100: --
101: open c2;
102: --
103: fetch c2 into p_step_dsc,

Line 112: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',2);

108:
109: --
110:
111: --
112: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',2);
113: --
114: open c21;
115: --
116: fetch c21 into p_rsn_desc;

Line 136: hr_utility.set_location('per_spinal_pt_plcmt_pkg.chk_exist',1);

132: and effective_end_date >= p_sess;
133: --
134: begin
135: --
136: hr_utility.set_location('per_spinal_pt_plcmt_pkg.chk_exist',1);
137: --
138: open c3;
139: --
140: fetch c3 into l_exists;

Line 505: --this was placed in the 'per_spinal_pt_plcmt_pkg' as there

501: END Delete_Row;
502:
503:
504: --procedure to populate the control block (CTRL) in the form PERWSSPP
505: --this was placed in the 'per_spinal_pt_plcmt_pkg' as there
506: --were none for the control block being as it wasn't based
507: --on a table.
508:
509: procedure pop_ctrl(p_ass_id IN NUMBER,

Line 578: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',1);

574: --
575: l_ceil_step NUMBER;
576: begin
577: --
578: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',1);
579: --
580: open c5;
581: --
582: fetch c5 into p_ass_eed,

Line 599: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',2);

595: END IF;
596: --
597: close c5;
598: --
599: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',2);
600: --
601: open c6;
602: --
603: fetch c6 into p_ceil_step;

Line 608: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',3);

604: --
605: close c6;
606:
607: --
608: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',3);
609: --
610: open c7;
611: --
612: fetch c7 into p_inc_def;

Line 660: per_spinal_pt_plcmt_pkg.pop_ctrl(p_ass_id

656: END IF;
657: --
658: close c_derive_info;
659: --
660: per_spinal_pt_plcmt_pkg.pop_ctrl(p_ass_id
661: ,l_grd_id
662: ,l_grd_name
663: ,l_ceil_sp
664: ,l_parent_name

Line 676: end PER_SPINAL_PT_PLCMT_PKG;

672: ,'Y'
673: ,l_grd_ldr_name);
674: end test_path_to_perwsspp;
675:
676: end PER_SPINAL_PT_PLCMT_PKG;