PACKAGE: APPS.POS_TOTALS_PO_SV

Source

1 PACKAGE POS_TOTALS_PO_SV AUTHID CURRENT_USER as
2 /* $Header: POSPOTOS.pls 120.2 2010/01/29 09:38:33 ssreekum ship $ */
3 
4   FUNCTION get_po_total(X_header_id NUMBER)
5 	   return number;
6   --pragma restrict_references (get_po_total,WNDS,RNPS,WNPS);
7 
8   FUNCTION get_release_total(X_release_id NUMBER)
9 	   return number;
10   --pragma restrict_references (get_release_total,WNDS,RNPS,WNPS);
11 
12   FUNCTION get_po_archive_total(X_header_id NUMBER,
13 				X_revision_num NUMBER,
14 				X_doc_type VARCHAR)
15 	   return number;
16    --pragma restrict_references (get_po_archive_total,WNDS,RNPS,WNPS);
17 
18   FUNCTION get_amount_ordered(X_header_id NUMBER,
19 				X_revision_num NUMBER,
20 				X_doc_type VARCHAR)
21 	   return number;
22   pragma restrict_references (get_amount_ordered,WNDS,RNPS,WNPS);
23 
24   FUNCTION get_release_archive_total(X_release_id NUMBER,
25 				X_revision_num NUMBER)
26 	   return number;
27 
28 FUNCTION get_line_total
29 	(x_po_header_id in number,
30 	 x_po_release_id in number,
31 	 x_po_line_id   number,
32 	 X_revision_num number default NULL) return number;
33 
34 
35 FUNCTION get_shipment_total
36 	(x_po_line_location_id   number,
37 	 X_revision_num number) return number;
38 
39 
40 PROCEDURE get_shipment_amounts (
41 	p_po_line_location_id	IN  NUMBER,
42 	p_revision_num 		IN  NUMBER,
43 	p_amount_ordered	OUT NOCOPY NUMBER,
44 	p_amount_received	OUT NOCOPY NUMBER,
45 	p_amount_billed		OUT NOCOPY NUMBER);
46 
47 FUNCTION get_po_total_received (
48 	p_po_header_id		NUMBER,
49 	p_po_release_id		NUMBER,
50 	p_revision_num 		NUMBER )
51 RETURN NUMBER;
52 
53 
54 FUNCTION get_po_total_invoiced (
55 	p_po_header_id		NUMBER,
56 	p_po_release_id		NUMBER,
57 	p_revision_num 		NUMBER )
58 RETURN NUMBER;
59 
60 
61 FUNCTION get_po_payment_status (p_po_header_id 	NUMBER,
62 				p_po_release_id	NUMBER )
63 RETURN VARCHAR2;
64 
65 
66 FUNCTION get_ship_payment_status (p_line_location_id 	NUMBER)
67 RETURN VARCHAR2;
68 
69 FUNCTION get_po_total_quantity_received (
70 	p_po_header_id		NUMBER,
71 	p_po_release_id		NUMBER,
72 	p_revision_num 		NUMBER )
73 RETURN NUMBER;
74 
75 FUNCTION get_po_total_quantity_invoiced (
76 	p_po_header_id		NUMBER,
77 	p_po_release_id		NUMBER,
78 	p_revision_num 		NUMBER )
79 RETURN NUMBER;
80 
81 
82 END POS_TOTALS_PO_SV;