1 PACKAGE PO_SUBINVENTORIES_S2 AUTHID CURRENT_USER as
2 /* $Header: POXCOS2S.pls 115.2 2002/11/25 23:37:33 sbull ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PO_SUBINVENTORIES_S2
6
7 DESCRIPTION: This package contains new subinventory validation
8 routines released on 11/17/95. One of the relevant
9 changes from the previous versions is there is no
10 longer a separate source and destination subinventory
11 validation procedure; there is only one which handles
12 either case.
13
14 CLIENT/SERVER: Server
15
16 OWNER: Liza Broadbent
17
18 FUNCTION/PROCEDURE: val_subinventory()
19 val_mrp_src_sub()
20
21 ===========================================================================*/
22 /*===========================================================================
23 FUNCTION NAME: val_subinventory
24
25 DESCRIPTION: Validation for either a source or destination
26 subinventory which returns FALSE if the sub is
27 invalid. Set the x_validation_type parameter
28 to either -- DESTINATION or SOURCE -- to indicate
29 which validation to perform. The error type is
30 used to determine what message the calling procedure
31 should display if the function returns FALSE.
32
33
34
35 RETURN VALUE: boolean
36
37
38 PARAMETERS: x_dest_subinventory,
39 x_destination_org_id,
40 x_source_type,
41 x_source_subinventory,
42 x_source_org_id,
43 x_transaction_date,
44 x_item_id,
45 x_destination_type,
46 x_validation_type
47
48 DESIGN REFERENCES:
49
50 ALGORITHM:
51
52 NOTES:
53
54 OPEN ISSUES:
55
56 CLOSED ISSUES:
57
58 CHANGE HISTORY: Created 15-NOV-95 LBROADBE
59 Modified 25-JAN-96 Ramana Mulpury
60
61 ===========================================================================*/
62 function val_subinventory(x_dest_subinventory in varchar2,
63 x_destination_org_id in number,
64 x_source_type in varchar2,
65 x_source_subinventory in varchar2,
66 x_source_org_id in number,
67 x_transaction_date in date,
68 x_item_id in number,
69 x_destination_type in varchar2,
70 x_validation_type in varchar2,
71 x_error_type in out NOCOPY varchar2)return boolean;
72
73 /*===========================================================================
74 FUNCTION NAME: val_mrp_src_sub()
75
76 DESCRIPTION: Checks whether the source and destination orgs are the
77 same. If so, it then checks to see if the item is
78 MPR planned in this common org. If it is, the source
79 subinventory must be non-nettable. The function
80 returns FALSE if the validation fails.
81
82 RETURN VALUE: boolean
83
84
85 PARAMETERS: x_subinventory,
86 x_source_org_id,
87 x_destination_org_id,
88 x_item_id
89
90 DESIGN REFERENCES:
91
92 ALGORITHM:
93
94 NOTES:
95
96 OPEN ISSUES:
97
98 CLOSED ISSUES:
99
100 CHANGE HISTORY: Created 15-NOV-95 LBROADBE
101 ===========================================================================*/
102 function val_mrp_src_sub(x_subinventory in varchar2,
103 x_source_org_id in number,
104 x_destination_org_id in number,
105 x_item_id in number) return boolean;
106
107 END PO_SUBINVENTORIES_S2;