1 Package ghr_pei_flex_ddf AUTHID CURRENT_USER as
2 /* $Header: ghpeiddf.pkh 115.4 2002/01/09 10:24:51 pkm ship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- |-------------------------------< ddf >--------------------------------------|
6 -- -----------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- This procedure controls the validation processing required for
11 -- developer descriptive flexfields by calling the relevant validation
12 -- procedures. These are called dependant on the value of the relevant
13 -- entity reference field value.
14 --
15 -- Pre Conditions:
16 -- A fully validated entity record structure.
17 --
18 -- In Arguments:
19 -- p_rec (Record structure for relevant entity).
20 --
21 -- Post Success:
22 -- Processing of the calling api continues.
23 --
24 -- Post Failure:
25 -- A failure can only occur under two circumstances:
26 -- 1) The value of reference field is not supported.
27 -- 2) If when the reference field value is null and not all
28 -- the information arguments are not null(i.e. information
29 -- arguments cannot be set without a corresponding reference
30 -- field value).
31 --
32 -- Developer Implementation Notes:
33 -- Developer defined.
34 --
35 -- Access Status:
36 -- Internal Development Use Only.
37 --
38 -- {End of Comments}
39 -- -----------------------------------------------------------------------------
40 /*
41 procedure ddf
42 (p_rec in pe_pei_shd.g_rec_type
43 );
44 */
45 procedure ddf
46 (
47 p_person_extra_info_id in number ,
48 p_person_id in number ,
49 p_information_type in varchar2 ,
50 p_request_id in number ,
51 p_program_application_id in number ,
52 p_program_id in number ,
53 p_program_update_date in date ,
54 p_pei_attribute_category in varchar2 ,
55 p_pei_attribute1 in varchar2 ,
56 p_pei_attribute2 in varchar2 ,
57 p_pei_attribute3 in varchar2 ,
58 p_pei_attribute4 in varchar2 ,
59 p_pei_attribute5 in varchar2 ,
60 p_pei_attribute6 in varchar2 ,
61 p_pei_attribute7 in varchar2 ,
62 p_pei_attribute8 in varchar2 ,
63 p_pei_attribute9 in varchar2 ,
64 p_pei_attribute10 in varchar2 ,
65 p_pei_attribute11 in varchar2 ,
66 p_pei_attribute12 in varchar2 ,
67 p_pei_attribute13 in varchar2 ,
68 p_pei_attribute14 in varchar2 ,
69 p_pei_attribute15 in varchar2 ,
70 p_pei_attribute16 in varchar2 ,
71 p_pei_attribute17 in varchar2 ,
72 p_pei_attribute18 in varchar2 ,
73 p_pei_attribute19 in varchar2 ,
74 p_pei_attribute20 in varchar2 ,
75 p_pei_information_category in varchar2 ,
76 p_pei_information1 in varchar2 ,
77 p_pei_information2 in varchar2 ,
78 p_pei_information3 in varchar2 ,
79 p_pei_information4 in varchar2 ,
80 p_pei_information5 in varchar2 ,
81 p_pei_information6 in varchar2 ,
82 p_pei_information7 in varchar2 ,
83 p_pei_information8 in varchar2 ,
84 p_pei_information9 in varchar2 ,
85 p_pei_information10 in varchar2 ,
86 p_pei_information11 in varchar2 ,
87 p_pei_information12 in varchar2 ,
88 p_pei_information13 in varchar2 ,
89 p_pei_information14 in varchar2 ,
90 p_pei_information15 in varchar2 ,
91 p_pei_information16 in varchar2 ,
92 p_pei_information17 in varchar2 ,
93 p_pei_information18 in varchar2 ,
94 p_pei_information19 in varchar2 ,
95 p_pei_information20 in varchar2 ,
96 p_pei_information21 in varchar2 ,
97 p_pei_information22 in varchar2 ,
98 p_pei_information23 in varchar2 ,
99 p_pei_information24 in varchar2 ,
100 p_pei_information25 in varchar2 ,
101 p_pei_information26 in varchar2 ,
102 p_pei_information27 in varchar2 ,
103 p_pei_information28 in varchar2 ,
104 p_pei_information29 in varchar2 ,
105 p_pei_information30 in varchar2
106 );
107
108 -- |-------------------------< chk_ins_routing_group_info >--------------------------|
109 -- ----------------------------------------------------------------------------
110 --
111 -- Desciption:
112 -- This procedures validates that the if the person is :
113 -- Already assigned to this routing group.
114 -- If he the Reviewer/ Requestor/ Authorizer/ Approver combination is valid.
115 -- If the Person is already assigned a Defualt routing group.
116 -- Pre-conditions :
117 -- p_person_id is valid
118 --
119 -- In Parameters :
120 -- p_information_type
121 -- p_person_id
122 -- p_pei_information3
123 -- p_pei_information4
124 -- p_pei_information5
125 -- p_pei_information6
126 -- p_pei_information7
127 -- p_pei_information8
128 -- p_pei_information9
129 -- p_pei_information10
130 --
131 -- Post Success :
132 -- Processing continues if the Person is not already a member of the routing
133 -- group.
134 -- If his roles of Reviewer/ Requestor/ Authorizer/ Approver/ Personnelist combination is valid.
135 -- If his Default Routing group is valid
136 --
137 --
138 -- Post Failure :
139 -- An application error will be raised and processing is terminated if the
140 -- Person has a duplicate Routing group.
141 -- An application error will also be raised and processing is terminated if
142 -- his roles of Reviewer/ Requestor/ Authorizer/ Approver/ Personnelist combination is invalid.
143 -- If he is already a Defaulted to a routing group.
144 --
145 -- Access Status :
146 -- Internal Row Handler Use only.
147 --
148 -- {End of Comments}
149 --
150 -- ---------------------------------------------------------------------------
151 Procedure chk_routing_group_info
152 (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
153 ,p_information_type in per_people_extra_info.information_type%TYPE
154 ,p_person_id in per_people_extra_info.person_id%TYPE
155 ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156 ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157 ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158 ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159 ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160 ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161 ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
162 ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
163 );
164 --
165 Procedure chk_oghr_roles
166 (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
167 ,p_information_type in per_people_extra_info.information_type%TYPE
168 ,p_person_id in per_people_extra_info.person_id%TYPE
169 ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170 ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171 ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172 ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173 ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174 ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175 ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
176 ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
177 );
178 --
179 --
180 end ghr_pei_flex_ddf;