1 Package AHL_PRD_MATERIAL_TXN_CUHK AUTHID CURRENT_USER AS
2 /*$Header: AHLCMTXS.pls 120.1 2007/10/26 22:32:21 sracha noship $*/
3
4 ------------------------
5 -- Declare Procedures --
6 ------------------------
7 -- Start of Comments --
8 --
9 -- Procedure name : PERFORM_MTL_TXN_PRE
10 -- Type : Public
11 -- Function : Provide User Hooks for the customer to add validations/default values
12 -- before Material Issue or Return.
13 -- Pre-reqs :
14 --
15 -- Standard IN Parameters :
16 --
17 -- Standard OUT Parameters :
18 -- x_return_status OUT VARCHAR2 Required
19 -- x_msg_count OUT NUMBER Required
20 -- x_msg_data OUT VARCHAR2 Required
21 --
22 -- PERFORM_MTLTXN_PRE Parameters :
23 -- p_x_material_txn_tbl IN OUT AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type Required
24 -- Record structure containing transaction details.
25 -- see $AHL_TOP/patch/115/sql/AHLPMTXS.pls for attribute details.
26 --
27 -- Version :
28 -- Initial Version 1.0
29 --
30 -- End of Comments --
31
32 PROCEDURE PERFORM_MTLTXN_PRE (
33 p_x_material_txn_tbl IN OUT NOCOPY AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 --Start of Comments --
40 --
41 -- Procedure name : PERFORM_MTLTXN_POST
42 -- Type : Public
43 -- Function : Provide User Hooks for the customer for post-processing
44 -- after Material Return or Material Issue transactions.
45 -- Pre-reqs :
46 --
47 -- Standard IN Parameters :
48 --
49 -- Standard OUT Parameters :
50 -- x_return_status OUT VARCHAR2 Required
51 -- x_msg_count OUT NUMBER Required
52 -- x_msg_data OUT VARCHAR2 Required
53 --
54 -- PERFORM_MTLTXN_POST Parameters :
55 -- p_material_txn_tbl IN AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type Required
56 -- Record structure containing transaction details.
57 -- see $AHL_TOP/patch/115/sql/AHLPMTXS.pls for attribute details.
58 --
59 -- Version :
60 -- Initial Version 1.0
61 --
62 -- End of Comments --
63
64 PROCEDURE PERFORM_MTLTXN_POST (
65 p_material_txn_tbl IN OUT NOCOPY AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71
72 END AHL_PRD_MATERIAL_TXN_CUHK;