1 PACKAGE PO_REQ_DIST_SV AUTHID CURRENT_USER as
2 /* $Header: POXRQD1S.pls 115.2 2002/11/23 01:57:40 sbull ship $ */
3 /*===========================================================================
4 PACKAGE NAME: po_req_dist_sv
5
6 DESCRIPTION: Contains all the server side procedures
7 that access the entity, PO_REQ_DISTRIBUTIONS.
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME None
12
13 OWNER: MCHIHAOU
14
15 PROCEDURE NAMES: check_unique
16 check_max_dist_num
17 select_summary
18 create_dist_for_modify
19
20 ===========================================================================*/
21
22
23
24 /*===========================================================================
25 PROCEDURE NAME: check_unique
26
27 DESCRIPTION: Checks if distribution number entered in the form
28 already exists in the database.
29
30 ===========================================================================*/
31 FUNCTION check_unique
32 (X_row_id VARCHAR2,
33 X_distribution_num NUMBER,
34 X_requisition_line_id NUMBER)
35 RETURN BOOLEAN;
36
37 /*===========================================================================
38 PROCEDURE NAME: check_unique_insert
39
40 DESCRIPTION: Checks if distribution number entered in the form
41 already exists in the database during the commit when
42 user is inserting rows.
43
44
45 ===========================================================================*/
46 PROCEDURE check_unique_insert
47 (X_row_id IN OUT NOCOPY VARCHAR2,
48 X_distribution_num NUMBER,
49 X_requisition_line_id NUMBER);
50
51
52
53 /*===========================================================================
54 PROCEDURE NAME: get_max_dist_num
55
56 DESCRIPTION: get the maximum number for the distribution lines that
57 have been committed to the Database.
58
59 PARAMETERS:
60
61
62 DESIGN REFERENCES:
63
64 ALGORITHM:
65
66 NOTES:
67
68 OPEN ISSUES:
69
70 CLOSED ISSUES:
71
72 CHANGE HISTORY:
73 ===========================================================================*/
74 FUNCTION get_max_dist_num( X_requisition_line_id NUMBER)
75 RETURN NUMBER;
76
77 /*===========================================================================
78 PROCEDURE NAME: select_summary
79
80 DESCRIPTION: Running total implementation for Req_line_quantity
81 implemented according to standards.
82
83 PARAMETERS:
84
85
86 DESIGN REFERENCES:
87
88 ALGORITHM:
89
90 NOTES:
91
92 OPEN ISSUES:
93
94 CLOSED ISSUES:
95
96 CHANGE HISTORY:
97 ===========================================================================*/
98 PROCEDURE select_summary( X_requisition_line_id IN OUT NOCOPY NUMBER,
99 X_total IN OUT NOCOPY NUMBER);
100
101
102
103
104
105 /*===========================================================================
106 PROCEDURE NAME: update_reqs_distributions
107
108 DESCRIPTION: Updates requisition distributions gl_cancelled_date
109 or gl_closed_date based on control action.
110
111
112 PARAMETERS: X_req_header_id IN NUMBER,
113 X_req_line_id IN NUMBER,
114 X_req_control_action IN VARCHAR2,
115 X_req_action_date IN DATE,
116 X_req_control_error_rc IN OUT VARCHAR2
117
118
119 DESIGN REFERENCES: POXDOCON.dd
120
121 ALGORITHM: 1. If control action is 'CANCEL',
122 update gl_cancelled_date to sysdate.
123 2. If control action is 'FINALLY CLOSE', update
124 gl_closed_date sysdate.
125
126 NOTES:
127
128 OPEN ISSUES:
129
130 CLOSED ISSUES:
131
132 CHANGE HISTORY: WLAU 5/12 Created
133 WLAU 5/30/96 Bug: 361657 add action_date
134 ===========================================================================*/
135 PROCEDURE update_reqs_distributions
136 (X_req_header_id IN NUMBER,
137 X_req_line_id IN NUMBER,
138 X_req_control_action IN VARCHAR2,
139 X_req_action_date IN DATE,
140 X_req_control_error_rc IN OUT NOCOPY VARCHAR2);
141
142
143 /*===========================================================================
144 PROCEDURE NAME: val_create_dist
145
146 DESCRIPTION: If a requistion line is committed then validate
147 if a distribution should be created automatically.
148
149 PARAMETERS: X_line_id NUMBER
150 X_destination_type_code VARCHAR2
151 X_destination_org_id NUMBER
152 X_req_encumbrance_flag VARCHAR2
153 X_gl_date DATE
154
155 DESIGN REFERENCES: MODIFY_REQS.dd
156 POXRQERQ.doc
157
158 ALGORITHM:
159
160 NOTES:
161
162 OPEN ISSUES: DEBUG. We may not need this apis since
163 currently in Rel 10 we check if the
164 total distribution quantity is > 0 to
165 check for the existance of distributions.
166 The rest of the validation is possible on the
167 client.
168
169 CLOSED ISSUES:
170
171 CHANGE HISTORY:
172 ===========================================================================*/
173
174 /*
175 PROCEDURE val_create_dist(X_line_id NUMBER,
176 X_destination_type_code VARCHAR2,
177 X_destination_org_id NUMBER,
178 X_req_encumbrance_flag VARCHAR2,
179 X_gl_date DATE,
180 X_code_combination_id NUMBER);
181 */
182
183 /*===========================================================================
184 PROCEDURE NAME: create_dist_for_modify
185
186 DESCRIPTION:
187
188 PARAMETERS: x_new_req_line_id
189 x_orig_req_line_id
190
191
192 DESIGN REFERENCES: MODIFY_REQS.dd
193
194 ALGORITHM:
195
196 NOTES:
197
198 OPEN ISSUES:
199
200 CLOSED ISSUES:
201
202 CHANGE HISTORY:
203 ===========================================================================*/
204
205 PROCEDURE create_dist_for_modify (x_new_req_line_id IN NUMBER,
206 x_orig_req_line_id IN NUMBER,
207 x_new_line_quantity IN NUMBER);
208
209
210 END po_req_dist_sv;