1 PACKAGE PO_DIST_S as
2 /* $Header: POXPOPDS.pls 120.1.12000000.2 2007/10/17 11:55:13 ppadilam ship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_DIST_S
5 DESCRIPTION: Contains the server side Distribution APIS
6 CLIENT/SERVER: Server
7 LIBRARY NAME:
8 OWNER: KPOWELL
9 PROCEDURE NAMES: get_total_dist_qty()
10 val_distribution_exists()
11 ===========================================================================*/
12 /*===========================================================================
13 PROCEDURE NAME: get_total_dist_qty()
14 DESCRIPTION: Gets the remaining distribution quantity so
15 it can be defaulted on to the distribution.
16 PARAMETERS: X_po_line_location_id IN NUMBER
17 X_total_quantity IN OUT NOCOPY NUMBER
18 DESIGN REFERENCES:
19 ALGORITHM: Get the total quantity for all distributions
20 against the shipment.
21 NOTES:
22 OPEN ISSUES:
23 CLOSED ISSUES:
24 CHANGE HISTORY: KPOWELL 4/20 Created
25 ===========================================================================*/
26 PROCEDURE test_get_total_dist_qty
27 (X_po_line_location_id IN NUMBER);
28 PROCEDURE get_total_dist_qty
29 (X_po_line_location_id IN NUMBER,
30 X_total_quantity IN OUT NOCOPY NUMBER);
31 /*===========================================================================
32 PROCEDURE NAME: val_distribution_exists()
33 DESCRIPTION: Validates if a distribution exists for a
34 shipment
35 PARAMETERS: X_po_line_location_id IN NUMBER
36 RETURN BOOLEAN
37 DESIGN REFERENCES:
38 ALGORITHM: Validate if a distribution exists for a
39 shipment
40 NOTES:
41 OPEN ISSUES:
42 CLOSED ISSUES:
43 CHANGE HISTORY: KPOWELL 4/20 Created
44 ===========================================================================*/
45 FUNCTION val_distribution_exists
46 (X_po_line_location_id IN NUMBER) RETURN BOOLEAN;
47 PROCEDURE test_val_distribution_exists
48 (X_po_line_location_id IN NUMBER);
49
50 /* passed two extra parameters into this function
51 Distribution_Num - bug 1046786
52 Destination_Subinventory - bug 1001768 */
53
54 FUNCTION val_approval_status
55 (X_distribution_id IN NUMBER,
56 X_distribution_num IN NUMBER,
57 X_deliver_to_person_id IN NUMBER,
58 X_quantity_ordered IN NUMBER,
59 X_amount_ordered IN NUMBER, -- Bug 5409088
60 X_rate IN NUMBER,
61 X_rate_date IN DATE,
62 X_gl_encumbered_date IN DATE,
63 X_charge_account_id IN NUMBER,
64 X_project_id IN NUMBER, -- Bug # 6408034
65 --< Shared Proc FPJ Start >
66 p_dest_charge_account_id IN NUMBER,
67 --< Shared Proc FPJ End >
68
69 X_recovery_rate IN NUMBER,
70 X_destination_subinventory IN VARCHAR2 ) RETURN NUMBER;
71
72 END PO_DIST_S;