1 PACKAGE PER_SIT_PKG AUTHID CURRENT_USER as
2 /* $Header: pesit01t.pkh 115.1 2003/02/10 17:21:37 eumenyio ship $ */
3 --
4 ----------------------------------------------------------------------
5 -- check_unique_sit
6 --
7 -- Ensures that the Special Info Type is unique within the Business Group
8 --
9 procedure check_unique_sit(p_special_information_type_id in number
10 ,p_bg_id in number
11 ,p_id_flex_num in number);
12 --
13 ----------------------------------------------------------------------
14 -- sit_flex_used
15 --
16 -- Determines whether the Flex Structure has been used in Personal
17 -- Analyses
18 --
19 function sit_flex_used(p_bg_id number
20 ,p_id_flex_num number) return boolean;
21 --
22 ----------------------------------------------------------------------
23 -- sit_del_validation
24 --
25 -- Delete Validation
26 --
27 procedure sit_del_validation(p_bg_id number
28 ,p_id_flex_num number);
29 ----------------------------------------------------------------------
30 --
31 procedure populate_fields(p_id_flex_num number
32 ,p_name IN OUT NOCOPY varchar2
33 ,p_flex_enabled IN OUT NOCOPY varchar2);
34
35 ----------------------------------------------------------------------
36 -- get_special_info_type_id
37 --
38 -- Retrives next UNIQUE ID
39 --
40 function get_special_info_type_id return number;
41
42 ----------------------------------------------------------------------
43 -- ins_sit
44 --
45 -- Inserts a record into PER_SPECIAL_INFO_TYPES
46 --
47 procedure ins_sit (p_SPECIAL_INFORMATION_TYPE_ID in out nocopy NUMBER,
48 p_BUSINESS_GROUP_ID in NUMBER,
49 p_ID_FLEX_NUM in NUMBER,
50 p_COMMENTS in varchar2,
51 p_ENABLED_FLAG in VARCHAR2,
52 p_REQUEST_ID in NUMBER,
53 p_PROGRAM_APPLICATION_ID in NUMBER,
54 p_PROGRAM_ID in NUMBER,
55 p_PROGRAM_UPDATE_DATE in DATE,
56 p_ATTRIBUTE_CATEGORY in VARCHAR2,
57 p_ATTRIBUTE1 in VARCHAR2,
58 p_ATTRIBUTE2 in VARCHAR2,
59 p_ATTRIBUTE3 in VARCHAR2,
60 p_ATTRIBUTE4 in VARCHAR2,
61 p_ATTRIBUTE5 in VARCHAR2,
62 p_ATTRIBUTE6 in VARCHAR2,
63 p_ATTRIBUTE7 in VARCHAR2,
64 p_ATTRIBUTE8 in VARCHAR2,
65 p_ATTRIBUTE9 in VARCHAR2,
66 p_ATTRIBUTE10 in VARCHAR2,
67 p_ATTRIBUTE11 in VARCHAR2,
68 p_ATTRIBUTE12 in VARCHAR2,
69 p_ATTRIBUTE13 in VARCHAR2,
70 p_ATTRIBUTE14 in VARCHAR2,
71 p_ATTRIBUTE15 in VARCHAR2,
72 p_ATTRIBUTE16 in VARCHAR2,
73 p_ATTRIBUTE17 in VARCHAR2,
74 p_ATTRIBUTE18 in VARCHAR2,
75 p_ATTRIBUTE19 in VARCHAR2,
76 p_ATTRIBUTE20 in VARCHAR2,
77 p_MULTIPLE_OCCURRENCES_FLAG in VARCHAR2);
78
79 ----------------------------------------------------------------------
80 -- lck
81 --
82 -- Locks a record in PER_SPECIAL_INFO_TYPES
83 --
84 Procedure lck ( p_special_information_type_id in number );
85
86 ----------------------------------------------------------------------
87 -- upd_sit
88 --
89 -- Updates a record into PER_SPECIAL_INFO_TYPES
90 --
91 procedure upd_sit (p_SPECIAL_INFORMATION_TYPE_ID in NUMBER,
92 p_BUSINESS_GROUP_ID in NUMBER,
93 p_ID_FLEX_NUM in NUMBER,
94 p_COMMENTS in VARCHAR2,
95 p_ENABLED_FLAG in VARCHAR2,
96 p_REQUEST_ID in NUMBER,
97 p_PROGRAM_APPLICATION_ID in NUMBER,
98 p_PROGRAM_ID in NUMBER,
99 p_PROGRAM_UPDATE_DATE in DATE,
100 p_ATTRIBUTE_CATEGORY in VARCHAR2,
101 p_ATTRIBUTE1 in VARCHAR2,
102 p_ATTRIBUTE2 in VARCHAR2,
103 p_ATTRIBUTE3 in VARCHAR2,
104 p_ATTRIBUTE4 in VARCHAR2,
105 p_ATTRIBUTE5 in VARCHAR2,
106 p_ATTRIBUTE6 in VARCHAR2,
107 p_ATTRIBUTE7 in VARCHAR2,
108 p_ATTRIBUTE8 in VARCHAR2,
109 p_ATTRIBUTE9 in VARCHAR2,
110 p_ATTRIBUTE10 in VARCHAR2,
111 p_ATTRIBUTE11 in VARCHAR2,
112 p_ATTRIBUTE12 in VARCHAR2,
113 p_ATTRIBUTE13 in VARCHAR2,
114 p_ATTRIBUTE14 in VARCHAR2,
115 p_ATTRIBUTE15 in VARCHAR2,
116 p_ATTRIBUTE16 in VARCHAR2,
117 p_ATTRIBUTE17 in VARCHAR2,
118 p_ATTRIBUTE18 in VARCHAR2,
119 p_ATTRIBUTE19 in VARCHAR2,
120 p_ATTRIBUTE20 in VARCHAR2,
121 p_MULTIPLE_OCCURRENCES_FLAG in VARCHAR2);
122 --
123 ----------------------------------------------------------------------
124 -- reset_usages
125 --
126 -- Removes any records in PER_SPECIAL_INFO_TYPE_USAGES which have
127 -- had their associated flag reset
128 -- Calls add_usage to insert any new usages for each category
129 --
130 --
131 procedure reset_usages (p_special_information_type_id in number,
132 p_job_category in varchar2,
133 p_position_category in varchar2,
134 p_skill_category in varchar2,
135 p_other_category in varchar2,
136 p_osha_category in varchar2,
137 p_ada_category in varchar2);
138
139 ----------------------------------------------------------------------
140 -- del_sit
141 --
142 -- Deletes a record from PER_SPECIAL_INFO_TYPES
143 -- Calls delete_usages to also delete associated category usages
144 --
145 procedure del_sit (p_special_information_type_id in number);
146 --
147 --
148
149 ----------------------------------------------------------------------
150 -- sit in use
151 --
152 -- checks if a special info types in a given category are in use
153 -- used in the check that a type can be reverted back to not being in a
154 -- category
155 --
156 ----------------------------------------------------------------------
157 --
158 function sit_in_use (p_business_group_id in number,
159 p_id_flex_num in number,
160 p_category in varchar2) return boolean;
161 --
162
163 END PER_SIT_PKG;