1 PACKAGE PO_RCO_VALIDATION_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGRCVS.pls 120.7.12020000.3 2013/02/10 21:08:11 vegajula ship $*/
3
4 FUNCTION is_req_cancellable(p_req_hdr_id IN NUMBER) RETURN VARCHAR2;
5
6 function IS_ANY_LINE_WITHDRAWABLE(p_req_hdr_id in number) return varchar2;
7
8 FUNCTION is_req_changeable(p_req_hdr_id IN NUMBER) RETURN VARCHAR2;
9
10 FUNCTION is_reqline_cancellable(p_req_line_id IN NUMBER) RETURN VARCHAR2;
11
12 PROCEDURE calculate_disttax(p_api_version IN NUMBER,
13 x_return_status OUT NOCOPY VARCHAR2,
14 p_dist_id NUMBER,
15 p_price NUMBER,
16 p_quantity NUMBER,
17 p_dist_amount NUMBER,
18 p_rec_tax OUT NOCOPY NUMBER,
19 p_nonrec_tax OUT NOCOPY NUMBER);
20
21
22 PROCEDURE is_req_line_changeable(p_api_version IN NUMBER,
23 x_return_status OUT NOCOPY VARCHAR2,
24 p_req_line_id IN NUMBER,
25 p_price_flag OUT NOCOPY VARCHAR2,
26 p_date_flag OUT NOCOPY VARCHAR2,
27 p_qty_flag OUT NOCOPY VARCHAR2,
28 p_start_date_flag OUT NOCOPY VARCHAR2,
29 p_end_date_flag OUT NOCOPY VARCHAR2,
30 p_amount_flag OUT NOCOPY VARCHAR2,
31 p_cancel_flag OUT NOCOPY VARCHAR2);
32
33 PROCEDURE is_req_line_cancellable(p_api_version IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 p_req_line_id IN NUMBER,
36 p_flag IN VARCHAR2 DEFAULT NULL);
37
38 PROCEDURE save_reqchange(p_api_version IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 p_req_hdr_id IN NUMBER,
41 p_change_table IN po_req_change_table,
42 p_cancel_table IN po_req_cancel_table,
43 p_change_request_group_id OUT NOCOPY NUMBER,
44 x_retmsg OUT NOCOPY VARCHAR2,
45 x_errtable OUT NOCOPY po_req_change_err_table);
46
47 PROCEDURE save_ireqchange(p_api_version IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 p_req_hdr_id IN NUMBER,
50 p_change_table IN po_req_change_table,
51 p_cancel_table IN po_req_cancel_table,
52 p_change_request_group_id OUT NOCOPY NUMBER,
53 x_retmsg OUT NOCOPY VARCHAR2,
54 x_errtable OUT NOCOPY po_req_change_err_table);
55
56 PROCEDURE save_reqcancel(p_api_version IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 p_req_hdr_id IN NUMBER,
59 p_cancel_table IN po_req_cancel_table,
60 p_change_request_group_id OUT NOCOPY NUMBER,
61 x_retmsg OUT NOCOPY VARCHAR2,
62 p_grp_id IN NUMBER DEFAULT NULL);
63
64 PROCEDURE submit_reqchange (p_api_version IN NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2,
66 p_group_id IN NUMBER,
67 p_fundscheck_flag IN VARCHAR2,
68 p_note_to_approver IN VARCHAR2,
69 p_initiator IN VARCHAR2,
70 x_retmsg OUT NOCOPY VARCHAR2,
71 x_errcode OUT NOCOPY VARCHAR2,
72 x_errtable OUT NOCOPY po_req_change_err_table );
73
74 PROCEDURE submit_reqcancel (
75 p_api_version IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 p_group_id IN NUMBER,
78 x_retmsg OUT NOCOPY VARCHAR2,
79 p_errtable OUT NOCOPY po_req_change_err_table,
80 p_flag IN VARCHAR2 DEFAULT NULL);
81
82
83 PROCEDURE save_ireqcancel(p_api_version IN NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 p_req_hdr_id IN NUMBER,
86 p_cancel_table IN po_req_cancel_table,
87 p_change_request_group_id OUT NOCOPY NUMBER,
88 x_retmsg OUT NOCOPY VARCHAR2,
89 p_grp_id IN NUMBER DEFAULT NULL);
90
91 PROCEDURE submit_ireqchange (p_api_version IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 p_group_id IN NUMBER,
94 p_fundscheck_flag IN VARCHAR2,
95 p_note_to_approver IN VARCHAR2,
96 p_initiator IN VARCHAR2,
97 x_retmsg OUT NOCOPY VARCHAR2,
98 x_errcode OUT NOCOPY VARCHAR2,
99 x_errtable OUT NOCOPY po_req_change_err_table );
100
101 PROCEDURE submit_ireqcancel (
102 p_api_version IN NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2,
104 p_group_id IN NUMBER,
105 x_retmsg OUT NOCOPY VARCHAR2,
106 p_errtable OUT NOCOPY po_req_change_err_table,
107 p_flag IN VARCHAR2 DEFAULT NULL);
108
109
110 PROCEDURE is_on_complex_work_order(p_line_loc_id IN NUMBER,
111 x_return_status OUT NOCOPY VARCHAR2);
112
113
114 PROCEDURE is_complex_work_order(p_header_id IN NUMBER,
115 x_return_status OUT NOCOPY VARCHAR2) ;
116
117
118
119 PROCEDURE get_preparer_name(
120 p_api_version IN NUMBER
121 , p_req_hdr_id IN NUMBER
122 , x_return_status OUT NOCOPY VARCHAR2
123 , x_preparer_name OUT NOCOPY VARCHAR2
124 );
125
126
127 PROCEDURE update_reqcancel_from_so(
128 p_api_version IN NUMBER
129 , p_req_line_id_tbl IN Dbms_Sql.number_table
130 , p_req_can_qty_tbl IN Dbms_Sql.number_table
131 , p_req_can_all IN Boolean
132 , x_return_status OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE update_reqcancel_from_so(
136 p_api_version IN NUMBER
137 , x_return_status OUT NOCOPY VARCHAR2
138 , p_req_line_id_tbl IN Dbms_Sql.number_table --this needs to be table of number
139 );
140
141 PROCEDURE update_reqchange_from_so(
142 p_api_version IN NUMBER
143 , x_return_status OUT NOCOPY VARCHAR2
144 , p_req_line_id IN NUMBER
145 , p_delta_quantity IN NUMBER
146 , p_new_need_by_date IN DATE
147 );
148
149 -- 14227140 changes starts
150 /**
151 * Procedure to update the cancel qty in req line from SO
152 * This method is called when a SO initiated partial
153 * cancellation of Qty (Primary or Secondary) or cancellation of line.
154 *
155 * @param p_api_version of the procedure api
156 * @param p_req_line_id_tbl number table of canceled req lines
157 * @param p_req_can_prim_qty_tbl number table of canceled Prim Qty of req lines
158 * @param p_req_can_sec_qty_tbl number table of canceled Secondary Qty of req lines
159 * @param p_req_can_all boolean to hole weather req line cancelation flag
160 * @param x_return_status returns the tstatus of the api.
161 */
162 PROCEDURE update_reqcancel_from_so(
163 p_api_version IN NUMBER
164 , p_req_line_id_tbl IN Dbms_Sql.number_table
165 , p_req_can_prim_qty_tbl IN Dbms_Sql.number_table
166 , p_req_can_sec_qty_tbl IN Dbms_Sql.number_table
167 , p_req_can_all IN Boolean
168 , x_return_status OUT NOCOPY VARCHAR2
169 );
170
171
172 /**
173 * Procedure to update the Qty changes on req line from SO changes
174 * This method is called when a SO initiated change in Qty (Primary or Secondary).
175 *
176 * @param p_api_version of the procedure api
177 * @param x_return_status returns the tstatus of the api.
178 * @param p_req_line_id number holds the req line number
179 * @param p_delta_quantity_prim number changed Prim Qty of SO
180 * @param p_delta_quantity_sec number changed Secondary Qty of SO
181 * @param p_new_need_by_date date need by date of SO.
182 */
183 PROCEDURE update_reqchange_from_so(
184 p_api_version IN NUMBER
185 , x_return_status OUT NOCOPY VARCHAR2
186 , p_req_line_id IN NUMBER
187 , p_delta_quantity_prim IN NUMBER
188 , p_delta_quantity_sec IN NUMBER
189 , p_new_need_by_date IN DATE
190 );
191
192 -- 14227140 changes ends
193
194
195 END po_rco_validation_grp;