1 PACKAGE PO_LOCATIONS_SV2 AUTHID CURRENT_USER as
2 /* $Header: POXCOL1S.pls 120.1 2006/02/14 12:26:02 dreddy noship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PO_LOCATIONS_SV2
6
7 DESCRIPTION: Contains a single validation function for location
8 that takes arguments indicating what kind of
9 location is being validated.
10
11 CLIENT/SERVER: Server
12
13 LIBRARY NAME
14
15 OWNER: Liza Broadbent
16
17 PROCEDURE/FUNCTION NAMES:
18 val_location()
19
20
21 HISTORY: 11-15-95 LBROADBE Created
22
23 ===========================================================================*/
24 /*===========================================================================
25 FUNCTION NAME: val_location()
26
27 DESCRIPTION: Validates destination locations. The x_ship_to
28 and x_receiving parameters should be set to 'Y'
29 by the calling routine if these flags should be
30 checked. The x_val_internal parameter should be
31 set to 'Y' if you want to verify that a row exists
32 in po_location_associations for this location. The
33 function returns FALSE if the locations is invalid
34 for any of the relevant business rules.
35
36 RETURN VALUE: boolean
37
38
39 PARAMETERS: x_location_id,
40 x_destination_org_id,
41 x_ship_to,
42 x_receiving,
43 x_val_internal
44 x_source_org_id (Bug 5028505)
45
46 DESIGN REFERENCES:
47
48 ALGORITHM:
49
50 NOTES:
51
52 OPEN ISSUES:
53
54 CLOSED ISSUES:
55
56 CHANGE HISTORY: Created 15-NOV-95 LBROADBE
57 ===========================================================================*/
58 function val_location(x_location_id in number,
59 x_destination_org_id in number,
60 x_ship_to in varchar2,
61 x_receiving in varchar2,
62 x_val_internal in varchar2,
63 x_source_org_id in number default null) return boolean;
64
65 END PO_LOCATIONS_SV2;