1 PACKAGE inv_comingling_utils AS
2 /* $Header: INVCOMUS.pls 120.0 2005/05/25 05:28:10 appldev noship $ */
3
4 /*
5 ** -------------------------------------------------------------------------
6 ** Procedure: comingle_check
7 ** Description:
8 ** Output:
9 ** x_return_status
10 ** return status indicating success, error, unexpected error
11 ** x_msg_count
12 ** number of messages in message list
13 ** x_msg_data
14 ** if the number of messages in message list is 1, contains
15 ** message text
16 ** x_comingling_occurs
17 ** Y: Co-mingling occurs as a result of transaction
18 ** N: Co-mingling does not occur as a result of transaction
19 ** x_count
20 ** Minimum Number of co-mingling instances for given data
21 ** Input:
22 ** p_organization_id number
23 ** Organization where cost group assignment/transaction occurs
24 ** For receipts, this will be the source organization,
25 ** For subinventory and staging transfers, this will be the source organization.
26 ** (Source Organization = Destination Organization)
27 ** For inter-organization transfers, this will be transfer organization
28 ** (Source Organization <> Destination Organization)
29 ** p_inventory_item_id number
30 ** Identifier of item involved in cost group assignment/transaction
31 ** p_revision varchar2
32 ** Revision of item involved
33 ** p_lot_number varchar2
34 ** Lot number of item
35 ** p_subinventory_code varchar2
36 ** Subinventory where the transaction occurs
37 ** For receipts, this will be source subinventory
38 ** For subinventory, staging and inter-organization transfers,
39 ** this will be transfer subinventory
40 ** p_locator_id number
41 ** Locator where the transaction occurs
42 ** For receipts, this will be source locator
43 ** For subinventory, staging and inter-organization transfers,
44 ** this will be transfer locator
45 ** p_lpn_id number
46 ** LPN into which material is packed
47 ** p_cost_group_id number
48 ** identifier of cost group that is used in the transaction
49 **
50 **
51 ** Returns:
52 ** none
53 ** --------------------------------------------------------------------------
54 */
55
56 procedure comingle_check(
57 x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60 , x_comingling_occurs OUT NOCOPY VARCHAR2
61 , x_count OUT NOCOPY NUMBER
62 , p_organization_id IN NUMBER
63 , p_inventory_item_id IN NUMBER
64 , p_revision IN VARCHAR2
65 , p_lot_number IN VARCHAR2
66 , p_subinventory_code IN VARCHAR2
67 , p_locator_id IN NUMBER
68 , p_lpn_id IN NUMBER
69 , p_cost_group_id IN NUMBER);
70
71 procedure comingle_check
72 (x_return_status OUT NOCOPY VARCHAR2
73 , x_msg_count OUT NOCOPY NUMBER
74 , x_msg_data OUT NOCOPY VARCHAR2
75 , x_comingling_occurs OUT NOCOPY VARCHAR2
76 , p_transaction_temp_id IN NUMBER);
77
78 procedure comingle_check
79 (x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 ,x_comingling_occurs OUT NOCOPY VARCHAR2
83 ,p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE);
84
85 end inv_comingling_utils;