[Home] [Help]
PACKAGE: APPS.POS_TOTALS_PO_SV
Source
1 PACKAGE POS_TOTALS_PO_SV as
2 /* $Header: POSPOTOS.pls 120.1 2005/08/29 15:42:55 mji noship $ */
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
70 END POS_TOTALS_PO_SV;