1 PACKAGE INV_LOT_TRX_VALIDATION_PVT AS
2 /* $Header: INVVLTVS.pls 120.1 2005/06/17 06:57:04 appldev $ */
3
4 -- Global constant holding the package name
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_LOT_TRX_VALIDATION_PVT';
6
7 /*********************************************************************************************
8 * Procedure
9 * Validate_Lot_Split_Trx
10 * Description:
11 * This procedure will validate the records for lot split transactions,
12 * This will get all records for the lot split from mtl_transactions_interface
13 * then call the public validation APIs to validate the lots, the result lots, the
14 * the material status, the cost groups and the lot attributes
15 * Input Parameters:
16 * p_parent_id - The transaction_interface_id of the parent lot
17 *
18 * Output Parameters:
19 * x_return_status -- return status, S- success, E - error, U- unexpected error
20 * x_msg_count -- number of error message in the message stack.
21 * x_msg_data -- the error message on the top of the message stack.
22 * x_validation_status -- 'Y' if validation is successfull, 'N' if not successfull.
23 *
24 * Dependency:
25 * None.
26 *
27 * Called By:
28 * INV_TXN_MANAGER_PUB.process_transactions
29 **************************************************************************************************/
30
31 procedure validate_lot_split_trx(
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 x_validation_status OUT NOCOPY VARCHAR2,
36 p_parent_id IN NUMBER
37 );
38
39 /*********************************************************************************************
40 * Procedure
41 * Validate_Lot_Merge_trx
42 * Description:
43 * This procedure will validate the records for lot merge transactions,
44 * This will get all records for the lot split from mtl_transactions_interface
45 * then call the public validation APIs to validate the lots, the result lots, the
46 * the material status, the cost groups and the lot attributes
47 * Input Parameters:
48 * p_parent_id - The transaction_interface_id of the parent lot
49 *
50 * Output Parameters:
51 * x_return_status -- return status, S- success, E - error, U- unexpected error
52 * x_msg_count -- number of error message in the message stack.
53 * x_msg_data -- the error message on the top of the message stack.
54 * x_validation_status -- 'Y' if validation is successfull, 'N' if not successfull.
55 *
56 * Dependency:
57 * None.
58 *
59 * Called By:
60 * INV_TXN_MANAGER_PUB.process_transactions
61 **************************************************************************************************/
62 procedure validate_lot_merge_trx(
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 x_validation_status OUT NOCOPY VARCHAR2,
67 p_parent_id IN NUMBER
68 );
69
70 /*********************************************************************************************
71 * Procedure
72 * Validate_Lot_Translate_Trx
73 * Description:
74 * This procedure will validate the records for lot translate transactions,
75 * This will get all records for the lot split from mtl_transactions_interface
76 * then call the public validation APIs to validate the lots, the result lots, the
77 * the material status, the cost groups and the lot attributes
78 * Input Parameters:
79 * p_parent_id - The transaction_interface_id of the parent lot
80 *
81 * Output Parameters:
82 * x_return_status -- return status, S- success, E - error, U- unexpected error
83 * x_msg_count -- number of error message in the message stack.
84 * x_msg_data -- the error message on the top of the message stack.
85 * x_validation_status -- 'Y' if validation is successfull, 'N' if not successfull.
86 *
87 * Dependency:
88 * None.
89 *
90 * Called By:
91 * INV_TXN_MANAGER_PUB.process_transactions
92 **************************************************************************************************/
93
94 procedure validate_lot_translate_trx(
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 x_validation_status OUT NOCOPY VARCHAR2,
99 p_parent_id IN NUMBER
100 );
101
102 END INV_LOT_TRX_VALIDATION_PVT;