DBA Data[Home] [Help]

PACKAGE: APPS.POS_WC_CREATE_UPDATE_PVT

Source


1 PACKAGE POS_WC_CREATE_UPDATE_PVT AS
2 /* $Header: POSVWCCS.pls 120.2 2005/11/21 14:30:21 jacheung noship $*/
3 
4 FUNCTION DRAFT_EXISTS_FOR_PO ( p_po_header_id      IN  NUMBER)
5 RETURN VARCHAR2;
6 
7 
8 PROCEDURE GET_PO_INFO
9 (
10 	p_po_header_id			IN  NUMBER,
11 	x_ordered						OUT nocopy NUMBER,
12 	x_approved					OUT nocopy NUMBER,
13   x_return_status     OUT nocopy VARCHAR2,
14   x_return_msg        OUT nocopy VARCHAR2
15 );
16 
17 
18 FUNCTION GET_WC_TOTAL_REQUESTED
19 (
20 	p_wc_id							IN NUMBER,
21 	p_wc_stage					IN VARCHAR2
22 )
23 RETURN NUMBER;
24 
25 PROCEDURE GET_PAY_ITEM_PROGRESS(
26   p_wc_pay_item_id    IN  NUMBER,
27   p_wc_stage          IN  VARCHAR2,
28   x_progress          OUT NOCOPY NUMBER,
29   x_return_status     OUT NOCOPY VARCHAR2,
30   x_return_msg        OUT NOCOPY VARCHAR2);
31 
32 PROCEDURE GET_PAY_ITEM_PREV_SUBMITTED(
33 	p_wc_pay_item_id		IN  NUMBER,
34 	p_po_pay_item_id		IN  NUMBER,
35 	p_wc_stage					IN	VARCHAR2,
36 	x_prev_submitted		OUT NOCOPY NUMBER);
37 
38 
39 PROCEDURE COMPLETE_WC_APPROVAL_WF_BLOCK
40 (
41   p_wc_header_id      IN          NUMBER,
42   x_return_status     OUT nocopy  VARCHAR2,
43   x_return_msg        OUT nocopy  VARCHAR2
44 );
45 
46 
47 PROCEDURE START_APPROVAL_WORKFLOW
48 (
49   p_wc_header_id      IN					NUMBER,
50   x_return_status     OUT nocopy	VARCHAR2,
51   x_return_msg        OUT nocopy	VARCHAR2
52 );
53 
54 END POS_WC_CREATE_UPDATE_PVT;
55