[Home] [Help]
PACKAGE: APPS.PER_GRADE_SPINES_PKG
Source
1 package PER_GRADE_SPINES_PKG as
2 /* $Header: pegrs01t.pkh 120.0 2005/05/31 09:32:40 appldev noship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Grade_Spine_Id IN OUT NOCOPY NUMBER,
6 X_Effective_Start_Date DATE,
7 X_Effective_End_Date DATE,
8 X_Business_Group_Id NUMBER,
9 X_Parent_Spine_Id NUMBER,
10 X_Grade_Id NUMBER,
11 X_Ceiling_Step_Id IN OUT NOCOPY NUMBER
12 );
13
14 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
15 X_Grade_Spine_Id NUMBER,
16 X_Effective_Start_Date DATE,
17 X_Effective_End_Date DATE,
18 X_Business_Group_Id NUMBER,
19 X_Parent_Spine_Id NUMBER,
20 X_Grade_Id NUMBER,
21 X_Ceiling_Step_Id NUMBER,
22 X_starting_step NUMBER,
23 X_request_id NUMBER,
24 X_program_application_id NUMBER,
25 X_program_id NUMBER,
26 X_program_update_date DATE
27 );
28
29 PROCEDURE Update_Row(X_Rowid VARCHAR2,
30 X_Grade_Spine_Id NUMBER,
31 X_Effective_Start_Date DATE,
32 X_Effective_End_Date DATE,
33 X_Business_Group_Id NUMBER,
34 X_Parent_Spine_Id NUMBER,
35 X_Grade_Id NUMBER,
36 X_Ceiling_Step_Id NUMBER
37 );
38
39 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
40
41 procedure stb_del_validation(p_pspine_id IN NUMBER,
42 p_grd_id IN NUMBER);
43
44 procedure chk_unq_grade_spine(p_grd_id IN NUMBER,
45 p_sess IN DATE);
46
47 procedure first_step(
48 p_step_id IN NUMBER,
49 p_grade_spine_id IN NUMBER,
50 p_spinal_point_id IN NUMBER,
51 p_sequence IN NUMBER,
52 p_effective_start_date IN DATE,
53 p_effective_end_date IN DATE,
54 p_business_group_id IN NUMBER,
55 p_last_update_date IN DATE,
56 p_last_updated_by IN NUMBER,
57 p_last_update_login IN NUMBER,
58 p_created_by IN NUMBER,
59 p_creation_date IN DATE,
60 p_information_category IN VARCHAR2);
61
62 --
63 -- first_step_api will be required for Grade/Step Progression Support
64 -- BUG#2999562
65 --
66 procedure first_step_api(
67 p_step_id IN NUMBER,
68 p_grade_spine_id IN NUMBER,
69 p_spinal_point_id IN NUMBER,
70 p_sequence IN NUMBER,
71 p_effective_start_date IN DATE,
72 p_effective_end_date IN DATE,
73 p_business_group_id IN NUMBER,
74 p_last_update_date IN DATE,
75 p_last_updated_by IN NUMBER,
76 p_last_update_login IN NUMBER,
77 p_created_by IN NUMBER,
78 p_creation_date IN DATE,
79 p_information_category IN VARCHAR2,
80 p_object_version_number IN number,
81 p_effective_date in date);
82
83 procedure chk_low_ceiling(p_val_start IN DATE,
84 p_val_end IN DATE,
85 p_gspine_id IN NUMBER,
86 p_new_ceil IN NUMBER);
87
88 procedure get_gspine_end(p_gspine_id in number,
89 p_grade_id in number,
90 p_eff_end_date in date,
91 p_gspine_opento_date in out nocopy date);
92
93 procedure close_gspine(p_gspine_id IN NUMBER,
94 p_sess IN DATE);
95
96 procedure open_gspine(p_gspine_id in number,
97 p_grade_id in number,
98 p_eff_end_date in date);
99
100
101 end PER_GRADE_SPINES_PKG;