1 PACKAGE PER_POS_STRUCTURE_ELEMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: pepse01t.pkh 115.5 2003/07/11 10:46:49 dcasemor ship $ */
3 -------------------------------------------------------------------------------
4 FUNCTION get_subordinates(X_View_All_Positions VARCHAR2
5 ,X_Parent_Position_Id NUMBER
6 ,X_Pos_Structure_Version_id NUMBER
7 ,X_Security_Profile_Id NUMBER) RETURN NUMBER;
8 -------------------------------------------------------------------------------
9 PROCEDURE get_holders(X_Business_Group_Id NUMBER
10 ,X_Position_Id NUMBER
11 ,X_Organization_id NUMBER
12 ,X_Holder IN OUT NOCOPY VARCHAR2
13 ,X_No_Holders IN OUT NOCOPY NUMBER
14 ,X_Session_date DATE
15 ,X_Employee_Number IN OUT NOCOPY VARCHAR2
16 ,X_User_Person_Type IN OUT NOCOPY VARCHAR2);
17 -------------------------------------------------------------------------------
18 PROCEDURE block_post_query(X_Business_Group_Id NUMBER
19 ,X_Position_Id NUMBER
20 ,X_Organization_id IN OUT NOCOPY NUMBER
21 ,X_Holder IN OUT NOCOPY VARCHAR2
22 ,X_No_Holders IN OUT NOCOPY NUMBER
23 ,X_Employee_Number IN OUT NOCOPY VARCHAR2
24 ,X_Subordinate_position_id NUMBER
25 ,X_View_All_Positions VARCHAR2
26 ,X_Parent_Position_Id NUMBER
27 ,X_Pos_Structure_Version_id NUMBER
28 ,X_Security_Profile_Id NUMBER
29 ,X_Session_date DATE
30 ,X_exists_in_hierarchy IN OUT NOCOPY VARCHAR2
31 ,X_Number_of_Subordinates IN OUT NOCOPY NUMBER
32 ,X_User_Person_Type IN OUT NOCOPY VARCHAR2);
33 -------------------------------------------------------------------------------
34 PROCEDURE maintain_pos_list(X_Business_Group_Id NUMBER
35 ,X_Security_Profile_Id NUMBER
36 ,X_View_All_Positions VARCHAR2
37 ,X_Sec_Pos_Structure_Version_id NUMBER
38 ,X_Position_Id NUMBER);
39 -------------------------------------------------------------------------------
40 PROCEDURE check_unique(X_Parent_position_id NUMBER
41 ,X_Pos_Structure_Version_Id NUMBER
42 ,X_Subordinate_Position_Id NUMBER);
43 -------------------------------------------------------------------------------
44 PROCEDURE pre_delete_checks(X_Subordinate_position_Id NUMBER
45 ,X_Position_Structure_Id NUMBER
46 ,X_Business_Group_Id NUMBER
47 ,X_Hr_Installed VARCHAR2
48 ,X_Pos_Structure_version_Id NUMBER);
49 -------------------------------------------------------------------------------
50 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
51 X_Pos_Structure_Element_Id IN OUT NOCOPY NUMBER,
52 X_Business_Group_Id NUMBER,
53 X_Pos_Structure_Version_Id NUMBER,
54 X_Subordinate_Position_Id NUMBER,
55 X_Parent_Position_Id NUMBER
56 );
57 -------------------------------------------------------------------------------
58 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
59 X_Pos_Structure_Element_Id NUMBER,
60 X_Business_Group_Id NUMBER,
61 X_Pos_Structure_Version_Id NUMBER,
62 X_Subordinate_Position_Id NUMBER,
63 X_Parent_Position_Id NUMBER
64 );
65 -------------------------------------------------------------------------------
66 PROCEDURE Update_Row(X_Rowid VARCHAR2,
67 X_Pos_Structure_Element_Id NUMBER,
68 X_Business_Group_Id NUMBER,
69 X_Pos_Structure_Version_Id NUMBER,
70 X_Subordinate_Position_Id NUMBER,
71 X_Parent_Position_Id NUMBER
72 );
73 -------------------------------------------------------------------------------
74 PROCEDURE Delete_Row(X_Rowid VARCHAR2
75 ,X_Subordinate_position_Id NUMBER
76 ,X_Position_Structure_Id NUMBER
77 ,X_Business_Group_Id NUMBER
78 ,X_Hr_Installed VARCHAR2
79 ,X_Pos_Structure_version_Id NUMBER);
80
81 END PER_POS_STRUCTURE_ELEMENTS_PKG;