[Home] [Help]
PACKAGE: APPS.PER_POSITION_STRUCTURES_PKG
Source
1 PACKAGE PER_POSITION_STRUCTURES_PKG AUTHID CURRENT_USER as
2 /* $Header: pepst01t.pkh 115.2 2003/02/11 09:59:46 eumenyio ship $ */
3
4 procedure form_startup(p_business_group_id NUMBER,
5 p_security_profile_id IN OUT NOCOPY NUMBER,
6 p_view_all_poss IN OUT NOCOPY VARCHAR2,
7 p_hr_installed IN OUT NOCOPY VARCHAR2,
8 p_pa_installed IN OUT NOCOPY VARCHAR2);
9
10 PROCEDURE check_name_unique(X_Rowid VARCHAR2,
11 X_Name VARCHAR2,
12 X_Business_group_id NUMBER);
13
14 PROCEDURE check_primary_flag(X_Rowid VARCHAR2,
15 X_Primary_flag VARCHAR2,
16 X_Business_group_id NUMBER);
17
18 PROCEDURE pre_delete_checks(X_Position_Structure_Id NUMBER,
19 X_Business_Group_Id NUMBER,
20 X_Po_Installed VARCHAR2,
21 X_Hr_Installed VARCHAR2);
22
23 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
24 X_Position_Structure_Id IN OUT NOCOPY NUMBER,
25 X_Business_Group_Id NUMBER,
26 X_Name VARCHAR2,
27 X_Comments VARCHAR2 ,
28 X_Primary_Position_Flag VARCHAR2 ,
29 X_Attribute_Category VARCHAR2 ,
30 X_Attribute1 VARCHAR2 ,
31 X_Attribute2 VARCHAR2 ,
32 X_Attribute3 VARCHAR2 ,
33 X_Attribute4 VARCHAR2 ,
34 X_Attribute5 VARCHAR2 ,
35 X_Attribute6 VARCHAR2 ,
36 X_Attribute7 VARCHAR2 ,
37 X_Attribute8 VARCHAR2 ,
38 X_Attribute9 VARCHAR2 ,
39 X_Attribute10 VARCHAR2 ,
40 X_Attribute11 VARCHAR2 ,
41 X_Attribute12 VARCHAR2 ,
42 X_Attribute13 VARCHAR2 ,
43 X_Attribute14 VARCHAR2 ,
44 X_Attribute15 VARCHAR2 ,
45 X_Attribute16 VARCHAR2 ,
46 X_Attribute17 VARCHAR2 ,
47 X_Attribute18 VARCHAR2 ,
48 X_Attribute19 VARCHAR2 ,
49 X_Attribute20 VARCHAR2
50 );
51
52 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
53 X_Position_Structure_Id NUMBER,
54 X_Business_Group_Id NUMBER,
55 X_Name VARCHAR2,
56 X_Comments VARCHAR2 ,
57 X_Primary_Position_Flag VARCHAR2 ,
58 X_Attribute_Category VARCHAR2 ,
59 X_Attribute1 VARCHAR2 ,
60 X_Attribute2 VARCHAR2 ,
61 X_Attribute3 VARCHAR2 ,
62 X_Attribute4 VARCHAR2 ,
63 X_Attribute5 VARCHAR2 ,
64 X_Attribute6 VARCHAR2 ,
65 X_Attribute7 VARCHAR2 ,
66 X_Attribute8 VARCHAR2 ,
67 X_Attribute9 VARCHAR2 ,
68 X_Attribute10 VARCHAR2 ,
69 X_Attribute11 VARCHAR2 ,
70 X_Attribute12 VARCHAR2 ,
71 X_Attribute13 VARCHAR2 ,
72 X_Attribute14 VARCHAR2 ,
73 X_Attribute15 VARCHAR2 ,
74 X_Attribute16 VARCHAR2 ,
75 X_Attribute17 VARCHAR2 ,
76 X_Attribute18 VARCHAR2 ,
77 X_Attribute19 VARCHAR2 ,
78 X_Attribute20 VARCHAR2
79 );
80
81 PROCEDURE Update_Row(X_Rowid VARCHAR2,
82 X_Position_Structure_Id NUMBER,
83 X_Business_Group_Id NUMBER,
84 X_Name VARCHAR2,
85 X_Comments VARCHAR2 ,
86 X_Primary_Position_Flag VARCHAR2 ,
87 X_Attribute_Category VARCHAR2 ,
88 X_Attribute1 VARCHAR2 ,
89 X_Attribute2 VARCHAR2 ,
90 X_Attribute3 VARCHAR2 ,
91 X_Attribute4 VARCHAR2 ,
92 X_Attribute5 VARCHAR2 ,
93 X_Attribute6 VARCHAR2 ,
94 X_Attribute7 VARCHAR2 ,
95 X_Attribute8 VARCHAR2 ,
96 X_Attribute9 VARCHAR2 ,
97 X_Attribute10 VARCHAR2 ,
98 X_Attribute11 VARCHAR2 ,
99 X_Attribute12 VARCHAR2 ,
100 X_Attribute13 VARCHAR2 ,
101 X_Attribute14 VARCHAR2 ,
102 X_Attribute15 VARCHAR2 ,
103 X_Attribute16 VARCHAR2 ,
104 X_Attribute17 VARCHAR2 ,
105 X_Attribute18 VARCHAR2 ,
106 X_Attribute19 VARCHAR2 ,
107 X_Attribute20 VARCHAR2
108 );
109
110 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
111 X_Position_Structure_Id NUMBER,
112 X_Business_Group_Id NUMBER,
113 X_Po_Installed VARCHAR2,
114 X_Hr_Installed VARCHAR2);
115
116 function postform(p_business_group_id NUMBER) return boolean;
117
118 END PER_POSITION_STRUCTURES_PKG;