1 Package ghr_rei_flex_ddf AUTHID CURRENT_USER as
2 /* $Header: ghreiddf.pkh 115.1 99/10/18 00:35:27 porting ship $ */
3 -- -----------------------------------------------------------------------------
4 -- |-------------------------------< ddf >--------------------------------------|
5 -- -----------------------------------------------------------------------------
6 -- {Start of Comments}
7 --
8 -- Description:
9 -- This procedure controls the validation processing required for
10 -- developer descriptive flexfields by calling the relevant validation
11 -- procedures. These are called dependant on the value of the relevant
12 -- entity reference field value.
13 --
14 -- Pre Conditions:
15 -- A fully validated entity record structure.
16 --
17 -- In Arguments:
18 -- p_rec (Record structure for relevant entity).
19 --
20 -- Post Success:
21 -- Processing of the calling api continues.
22 --
23 -- Post Failure:
24 -- A failure can only occur under two circumstances:
25 -- 1) The value of reference field is not supported.
26 -- 2) If when the refence field value is null and not all
27 -- the attribute arguments are not null(i.e. attribute
28 -- arguments cannot be set without a corresponding reference
29 -- field value).
30 --
31 -- Developer Implementation Notes:
32 -- Developer defined.
33 --
34 -- Access Status:
35 -- Internal Development Use Only.
36 --
37 -- {End of Comments}
38 -- -----------------------------------------------------------------------------
39 procedure ddf
40 (p_rec in ghr_rei_shd.g_rec_type
41 );
42 --
43
44 -- -----------------------------------------------------------------------------------------
45 -- |--------------------------< chk_reason_for_submission >--------------------------------|
46 -- -----------------------------------------------------------------------------------------
47 -- {Start of Comments}
48 --
49 -- Description:
50 -- This procedure validates the descriptive flexfield containing the information about reason
51 -- for submission. An error message is returned if this validation fails.
52 --
53 -- Pre Conditions:
54 -- None.
55 --
56 -- In Arguments:
57 -- p_pa_request_extra_info_id
58 -- p_reason_for_submission
59 -- p_effective_date
60 -- p_object_version_number
61 --
62 -- Post Success:
63 -- Processing of the calling api continues.
64 --
65 -- Post Failure:
66 -- Processing stops and error raised.
67 --
68 -- Developer Implementation Notes:
69 -- Developer defined.
70 --
71 -- Access Status:
72 -- Internal Development Use Only.
73 --
74 -- {End of Comments}
75 -- -----------------------------------------------------------------------------
76 --
77 procedure chk_reason_for_submission
78 (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
79 ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
80 ,p_effective_date in date
81 ,p_object_version_number in number
82 );
83
84 -- -----------------------------------------------------------------------------------------
85 -- |-----------------------------------< chk_explanation >---------------------------------|
86 -- -----------------------------------------------------------------------------------------
87 -- {Start of Comments}
88 --
89 -- Description:
90 -- This procedure validates the descriptive flexfield containing the information about
91 -- explanation. An error message is returned if this validation fails.
92 --
93 -- Pre Conditions:
94 -- None.
95 --
96 -- In Arguments:
97 -- p_reason_for_sbmission
98 -- p_pa_request_extra_info_id
99 -- p_explanation
100 -- p_object_version_number
101 --
102 -- Post Success:
103 -- Processing of the calling api continues.
104 --
105 -- Post Failure:
106 -- Processing stops and error raised.
107 --
108 -- Developer Implementation Notes:
109 -- Developer defined.
110 --
111 -- Access Status:
112 -- Internal Development Use Only.
113 --
114 -- {End of Comments}
115 -- -----------------------------------------------------------------------------
116 --
117 procedure chk_explanation
118 (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
119 ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
120 ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
121 ,p_object_version_number in number
122 );
123 --
124 -- -----------------------------------------------------------------------------------------
125 -- |-----------------------------------< chk_service>--------------------------------------|
126 -- -----------------------------------------------------------------------------------------
127 -- {Start of Comments}
128 --
129 -- Description:
130 -- This procedure validates the descriptive flexfield containing the information about service.
131 -- An error message is returned if this validation fails.
132 --
133 -- Pre Conditions:
134 -- None.
135 --
136 -- In Arguments:
137 -- p_pa_request_extra_info_id
138 -- p_service
139 -- p_effective_date
140 -- p_object_version_number
141 --
142 -- Post Success:
143 -- Processing of the calling api continues.
144 --
145 -- Post Failure:
146 -- Processing stops and error raised.
147 --
148 -- Developer Implementation Notes:
149 -- Developer defined.
150 --
151 -- Access Status:
152 -- Internal Development Use Only.
153 --
154 -- {End of Comments}
155 -- -----------------------------------------------------------------------------
156 --
157
158 procedure chk_service
159 (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
160 ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE
161 ,p_effective_date in date
162 ,p_object_version_number in number
163 );
164 end ghr_rei_flex_ddf;