1 PACKAGE PO_CLM_COLS_SUB_CHECK AUTHID CURRENT_USER AS
2 /* $Header: PO_CLM_COLS_SUB_CHECK.pls 120.6.12020000.2 2013/03/31 10:38:12 vpeddi ship $ */
3
4 g_package_name VARCHAR2(35) := 'PO_CLM_COLS_SUB_CHECK';
5
6 PROCEDURE CLM_ORDER_AMT_WITHIN_MAX_MIN
7 (
8 p_document_id IN NUMBER
9 ,p_draft_id IN NUMBER
10 ,p_online_report_id IN NUMBER
11 ,p_login_id IN NUMBER
12 ,p_user_id IN NUMBER
13 ,p_sequence IN NUMBER
14 ,x_return_status OUT NOCOPY VARCHAR2
15 ,x_errorcode OUT NOCOPY NUMBER
16 ,x_msg_count OUT NOCOPY NUMBER
17 ,x_msg_data OUT NOCOPY VARCHAR2
18 );
19
20 PROCEDURE CLM_MAX_ORD_AMT_WITIN_SUM_AMT
21 (
22 p_document_id IN NUMBER
23 ,p_draft_id IN NUMBER
24 ,p_online_report_id IN NUMBER
25 ,p_login_id IN NUMBER
26 ,p_user_id IN NUMBER
27 ,p_sequence IN NUMBER
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_errorcode OUT NOCOPY NUMBER
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE CLM_ORD_DT_WITIN_ST_END_DT
35 (
36 p_document_id IN NUMBER
37 ,p_draft_id IN NUMBER
38 ,p_online_report_id IN NUMBER
39 ,p_login_id IN NUMBER
40 ,p_user_id IN NUMBER
41 ,p_sequence IN NUMBER
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_errorcode OUT NOCOPY NUMBER
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE CLM_ORD_DT_LINE_WITIN_DT_HEAD
49 (
50 p_document_id IN NUMBER
51 ,p_draft_id IN NUMBER
52 ,p_online_report_id IN NUMBER
53 ,p_login_id IN NUMBER
54 ,p_user_id IN NUMBER
55 ,p_sequence IN NUMBER
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_errorcode OUT NOCOPY NUMBER
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE CLM_EFF_DT_HEAD_CHECK
63 (
64 p_draft_id IN NUMBER
65 ,p_document_id IN NUMBER
66 ,p_online_report_id IN NUMBER
67 ,p_login_id IN NUMBER
68 ,p_user_id IN NUMBER
69 ,p_sequence IN NUMBER
70 ,x_return_status OUT NOCOPY VARCHAR2
71 );
72
73
74 PROCEDURE CLM_QTY_ORD_QTY_CHECK
75 (
76 p_document_id IN NUMBER
77 ,p_draft_id IN NUMBER
78 ,p_online_report_id IN NUMBER
79 ,p_login_id IN NUMBER
80 ,p_user_id IN NUMBER
81 ,p_sequence IN NUMBER
82 ,x_return_status OUT NOCOPY VARCHAR2
83 ,x_errorcode OUT NOCOPY NUMBER
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE CLM_AMT_ORD_AMT_CHECK
89 (
90 p_document_id IN NUMBER
91 ,p_draft_id IN NUMBER
92 ,p_online_report_id IN NUMBER
93 ,p_login_id IN NUMBER
94 ,p_user_id IN NUMBER
95 ,p_sequence IN NUMBER
96 ,x_return_status OUT NOCOPY VARCHAR2
97 ,x_errorcode OUT NOCOPY NUMBER
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 );
101
102 PROCEDURE CLM_TOT_QTY_WIT_MAX_MIN_CHECK
103 (
104 p_document_id IN NUMBER
105 ,p_draft_id IN NUMBER
106 ,p_online_report_id IN NUMBER
107 ,p_login_id IN NUMBER
108 ,p_user_id IN NUMBER
109 ,p_sequence IN NUMBER
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_errorcode OUT NOCOPY NUMBER
112 ,x_msg_count OUT NOCOPY NUMBER
113 ,x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116 PROCEDURE CLM_ORD_TOT_QTY_LE_MAX_QTY_CHK
117 (
118 p_document_id IN NUMBER
119 ,p_draft_id IN NUMBER
120 ,p_online_report_id IN NUMBER
121 ,p_login_id IN NUMBER
122 ,p_user_id IN NUMBER
123 ,p_sequence IN NUMBER
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_errorcode OUT NOCOPY NUMBER
126 ,x_msg_count OUT NOCOPY NUMBER
127 ,x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE CLM_ORD_TOT_AMT_LE_MAX_AMT_CHK
131 (
132 p_document_id IN NUMBER
133 ,p_draft_id IN NUMBER
134 ,p_online_report_id IN NUMBER
135 ,p_login_id IN NUMBER
136 ,p_user_id IN NUMBER
137 ,p_sequence IN NUMBER
138 ,x_return_status OUT NOCOPY VARCHAR2
139 ,x_errorcode OUT NOCOPY NUMBER
140 ,x_msg_count OUT NOCOPY NUMBER
141 ,x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144 PROCEDURE CLM_AMT_GE_LINE_AMT
145 (
146 p_document_id IN NUMBER
147 ,p_draft_id IN NUMBER
148 ,p_online_report_id IN NUMBER
149 ,p_login_id IN NUMBER
150 ,p_user_id IN NUMBER
151 ,p_sequence IN NUMBER
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_errorcode OUT NOCOPY NUMBER
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2
156 );
157
158 PROCEDURE CLM_AMT_WITHIN_MAX_MIN_ORD_AMT
159 (
160 p_document_id IN NUMBER
161 ,p_draft_id IN NUMBER
162 ,p_online_report_id IN NUMBER
163 ,p_login_id IN NUMBER
164 ,p_user_id IN NUMBER
165 ,p_sequence IN NUMBER
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_errorcode OUT NOCOPY NUMBER
168 ,x_msg_count OUT NOCOPY NUMBER
169 ,x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE CLM_SRC_DOC_CHK
173 (
174 p_document_id IN NUMBER
175 ,p_draft_id IN NUMBER
176 ,p_online_report_id IN NUMBER
177 ,p_login_id IN NUMBER
178 ,p_user_id IN NUMBER
179 ,p_sequence IN NUMBER
180 ,x_return_status OUT NOCOPY VARCHAR2
181 ,x_errorcode OUT NOCOPY NUMBER
182 ,x_msg_count OUT NOCOPY NUMBER
183 ,x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE CLM_NAMED_COLS_SUB_CHK
187 (
188 p_document_id IN NUMBER
189 ,p_draft_id IN NUMBER
190 ,p_online_report_id IN NUMBER
191 ,p_login_id IN NUMBER
192 ,p_user_id IN NUMBER
193 ,p_sequence IN NUMBER
194 ,x_return_message OUT NOCOPY VARCHAR2
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_errorcode OUT NOCOPY NUMBER
197 ,x_msg_count OUT NOCOPY NUMBER
198 ,x_msg_data OUT NOCOPY VARCHAR2
199 );
200
201 PROCEDURE LOG_ERR_CLM_NMD_COLS_SUB_CHK
202 (
203 p_online_report_id IN NUMBER
204 ,p_login_id IN NUMBER
205 ,p_user_id IN NUMBER
206 ,p_line_num IN NUMBER DEFAULT 0
207 ,p_sequence IN NUMBER
208 ,p_return_message IN VARCHAR2
209 );
210
211 FUNCTION getAmountOrderedForIDV
212 (
213 p_level IN VARCHAR2
214 , p_doc_level_id IN NUMBER
215 , p_idv_header_id IN NUMBER
216 , p_idv_line_id IN NUMBER DEFAULT NULL
217 ) RETURN NUMBER;
218
219 FUNCTION getAmountOrdered
220 ( p_level IN VARCHAR2
221 , p_header_id IN NUMBER
222 , p_idv_header_id IN NUMBER
223 , p_idv_line_id IN NUMBER DEFAULT NULL
224 , p_draft_id IN NUMBER
225 ) RETURN NUMBER;
226
227 END;