1 PACKAGE PO_LINES_PKG_SCU AUTHID CURRENT_USER as
2 /* $Header: POXPIL5S.pls 115.2 2002/11/25 22:42:54 sbull ship $ */
3
4 /* The following procedure is used to check uniqueness of Line Numbers.
5 ** Created By : SIYER */
6
7 procedure check_unique(X_rowid VARCHAR2,
8 X_line_num NUMBER,
9 X_po_header_id NUMBER
10 );
11
12
13 /*===========================================================================
14 PROCEDURE NAME: select_ship_total
15
16 DESCRIPTION: Gets the total quantity against all shipments
17 of a given line.
18
19
20 PARAMETERS: X_po_line_id IN NUMBER
21 X_total IN OUT NUMBER
22 X_total_RTOT_DB IN OUT NUMBER
23
24 DESIGN REFERENCES:
25
26
27 ALGORITHM:
28
29 NOTES:
30
31 OPEN ISSUES:
32
33 CLOSED ISSUES:
34
35 CHANGE HISTORY: SIYER 08/95 Created
36
37 ===========================================================================*/
38
39 procedure select_ship_total ( X_po_line_id IN NUMBER,
40 X_total IN OUT NOCOPY NUMBER,
41 X_total_RTOT_DB IN OUT NOCOPY NUMBER);
42
43
44
45 END PO_LINES_PKG_SCU;