[Home] [Help]
PACKAGE: APPS.POS_WC_VIEW_CANCEL_PVT
Source
1 PACKAGE POS_WC_VIEW_CANCEL_PVT AUTHID CURRENT_USER AS
2 /* $Header: POSVWCVS.pls 120.5.12020000.4 2013/02/09 14:24:58 hvutukur ship $*/
3
4
5 PROCEDURE DELETE_WC
6 (
7 p_wc_id IN NUMBER,
8 x_return_status OUT NOCOPY VARCHAR2,
9 x_return_msg OUT NOCOPY VARCHAR2
10 );
11
12 PROCEDURE CANCEL_WC
13 (
14 p_wc_num IN VARCHAR2,
15 p_wc_id IN NUMBER,
16 p_wc_status IN VARCHAR2,
17 p_po_header_id IN NUMBER,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_return_msg OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE GET_WC_INFO
23 (
24 p_wc_id IN NUMBER,
25 p_wc_stage IN VARCHAR2,
26 p_wc_request_date IN DATE,
27 p_vendor_id IN NUMBER,
28 p_vendor_site_id IN NUMBER,
29 x_po_header_id OUT nocopy NUMBER,
30 x_po_num OUT nocopy VARCHAR2,
31 x_po_currency_code OUT nocopy VARCHAR2,
32 x_ordered OUT nocopy NUMBER,
33 x_approved OUT nocopy NUMBER,
34 x_prev_submitted OUT nocopy NUMBER,
35 x_requested OUT nocopy NUMBER,
36 x_material_stored OUT nocopy NUMBER,
37 x_total_requested OUT nocopy NUMBER,
38 x_wc_status OUT nocopy VARCHAR2,
39 x_wc_display_status OUT nocopy VARCHAR2,
40 x_po_lines_ordered OUT nocopy NUMBER,
41 x_prev_delivered OUT nocopy NUMBER,
42 x_delivery OUT nocopy NUMBER,
43 x_return_status OUT nocopy VARCHAR2,
44 x_return_msg OUT nocopy VARCHAR2
45 );
46
47 PROCEDURE GET_PO_HEADER_INFO
48 (
49 p_po_header_id IN NUMBER,
50 x_ordered OUT nocopy NUMBER,
51 x_approved OUT nocopy NUMBER,
52 x_pay_item_total OUT nocopy NUMBER,
53 x_return_status OUT nocopy VARCHAR2,
54 x_return_msg OUT nocopy VARCHAR2
55 );
56
57 PROCEDURE GET_WC_APPROVERS
58 (
59 p_wc_id IN NUMBER,
60 x_approvers OUT nocopy PO_TBL_VARCHAR2000,
61 x_return_status OUT nocopy VARCHAR2,
62 x_return_msg OUT nocopy VARCHAR2
63 );
64
65 PROCEDURE GET_WC_STATUS
66 (
67 p_wc_id IN NUMBER,
68 p_wc_stage IN VARCHAR2,
69 x_wc_status OUT nocopy VARCHAR2,
70 x_wc_display_status OUT nocopy VARCHAR2,
71 x_return_status OUT nocopy VARCHAR2,
72 x_return_msg OUT nocopy VARCHAR2
73 );
74
75 FUNCTION GET_CURRENCY_PRECISION(p_po_header_id IN number)
76 RETURN NUMBER ;
77
78 END POS_WC_VIEW_CANCEL_PVT;
79
80