1 PACKAGE PO_RCO_VALIDATION_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGRCVS.pls 120.2.12010000.4 2008/10/23 06:29:16 rojain 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
115 PROCEDURE get_preparer_name(
116 p_api_version IN NUMBER
117 , p_req_hdr_id IN NUMBER
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_preparer_name OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE update_reqcancel_from_so(
123 p_api_version IN NUMBER
124 , x_return_status OUT NOCOPY VARCHAR2
125 , p_req_hdr_id IN NUMBER
126 , p_req_line_id IN NUMBER
127 );
128
129
130 PROCEDURE update_reqchange_from_so(
131 p_api_version IN NUMBER
132 , x_return_status OUT NOCOPY VARCHAR2
133 , p_req_line_id IN NUMBER
134 , p_delta_quantity IN NUMBER
135 , p_new_need_by_date IN DATE
136 );
137
138 END po_rco_validation_grp;