PACKAGE: APPS.POS_WC_CREATE_UPDATE_PVT

Source

1 PACKAGE POS_WC_CREATE_UPDATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: POSVWCCS.pls 120.2.12010000.4 2010/04/14 17:45:58 suyjoshi ship $*/
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 PROCEDURE START_APPROVAL_WORKFLOW
47 (
48   p_wc_header_id      IN		NUMBER,
49   x_return_status     OUT nocopy	VARCHAR2,
50   x_return_msg        OUT nocopy	VARCHAR2
51 );
52 
53 -- code added for work confirmation correction ER - 9414650
54 
55 PROCEDURE insert_corrections_into_rti
56 (
57   p_shipment_header_id IN NUMBER,
58   p_line_location_id IN NUMBER,
59   p_group_id IN NUMBER,
60   p_amount_correction IN NUMBER,
61   p_quantity_correction IN NUMBER,
62   p_requested_amount_correction IN NUMBER,
63   p_material_stored_correction IN NUMBER,
64   p_comments IN VARCHAR2 );
65 
66 procedure Launch_RTP_Immediate
67 			   (p_group_id IN NUMBER);
68 
69 TYPE wc_correction_history_rec IS RECORD
70 (
71  --last_updated_by NUMBER,
72  correction_date DATE,
73  corrected_by VARCHAR2(100),
74  shipment_header_id NUMBER,
75  po_header_id NUMBER,
76  po_line_id NUMBER,
77  po_line_location_id NUMBER,
78  comments VARCHAR2(100),
79  quantity_ordered NUMBER,
80  amount_ordered NUMBER,
81  price NUMBER,
82  group_id NUMBER,
83  document_line_num NUMBER,
84  pay_item_num NUMBER,
85  description VARCHAR2(100),
86  matching_basis VARCHAR2(10),
87  old_quantity NUMBER,
88  new_quantity NUMBER,
89  old_req_amount NUMBER,
90  new_req_amount NUMBER,
91  old_req_deliver NUMBER,
92  new_req_deliver NUMBER,
93  old_mat_stored NUMBER,
94  new_mat_stored NUMBER,
95  old_total_amount NUMBER,
96  new_total_amount NUMBER,
97  old_progress NUMBER,
98  new_progress NUMBER
99 );
100 TYPE correction_history_tab IS TABLE OF wc_correction_history_rec;
101 
102 PROCEDURE get_wc_history(p_shipment_header_id IN NUMBER,
103                          p_correction_history_tab IN OUT NOCOPY correction_history_tab);
104 
105 FUNCTION get_wc_correction_history(p_shipment_header_id IN NUMBER)
106 RETURN correction_history_tab PIPELINED;
107 
108 -- end of code added for work confirmation correction ER - 9414650
109 
110 END POS_WC_CREATE_UPDATE_PVT;
111