1 PACKAGE GMD_ITEM_TECHNICAL_DATA_PUB AS
2 /* $Header: GMDPITDS.pls 120.3.12010000.1 2008/07/24 09:56:36 appldev ship $ */
3
4 -- Header record type
5 TYPE technical_data_hdr_rec IS RECORD
6 (Tech_Data_Id gmd_technical_data_hdr.Tech_Data_Id%TYPE,
7 Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8 Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9 Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10 Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11 Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12 Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
13 Text_Code gmd_technical_data_hdr.Text_Code%TYPE );
14
15 -- Detail record type
16 TYPE technical_data_dtl_rec IS RECORD
17 (Tech_Parm_Id gmd_technical_data_dtl.Tech_Parm_Id%TYPE,
18 Sort_Seq gmd_technical_data_dtl.Sort_Seq%TYPE,
19 Tech_Data VARCHAR2(2000),
20 Text_Code gmd_technical_data_dtl.Text_Code%TYPE);
21
22 -- Detail record table
23 TYPE technical_data_dtl_tab IS TABLE OF technical_data_dtl_rec
24 INDEX BY BINARY_INTEGER;
25
26 --Start of comments
27 --+========================================================================+
28 --| API Name : INSERT_ITEM_TECHNICAL_DATA |
29 --| TYPE : Public |
30 --| Function : Inserts the Item technical data |
31 --| Notes : |
32 --| |
33 --| HISTORY |
34 --| S.Sriram 21-Feb-2005 Created |
35 --+========================================================================+
36 -- End of comments
37
38 PROCEDURE INSERT_ITEM_TECHNICAL_DATA
39 (
40 p_api_version IN NUMBER
41 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42 , p_commit IN VARCHAR2 := FND_API.G_FALSE
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_msg_count OUT NOCOPY NUMBER
45 , x_msg_data OUT NOCOPY VARCHAR2
46 , p_header_rec IN OUT NOCOPY technical_data_hdr_rec
47 , p_dtl_tbl IN technical_data_dtl_tab
48 );
49
50 --Start of comments
51 --+========================================================================+
52 --| API Name : UPDATE_ITEM_TECHNICAL_DATA |
53 --| TYPE : Public |
54 --| Function : Updates the Item technical data |
55 --| Notes : |
56 --| |
57 --| HISTORY |
58 --| S.Sriram 21-Feb-2005 Created |
59 --+========================================================================+
60 -- End of comments
61
62 PROCEDURE UPDATE_ITEM_TECHNICAL_DATA
63 (
64 p_api_version IN NUMBER
65 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66 , p_commit IN VARCHAR2 := FND_API.G_FALSE
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , p_tech_data_id IN NUMBER
71 , p_dtl_tbl IN technical_data_dtl_tab
72 );
73
74 --Start of comments
75 --+========================================================================+
76 --| API Name : DELETE_ITEM_TECHNICAL_DATA |
77 --| TYPE : Public |
78 --| Function : Deletes the Item technical data |
79 --| Notes : |
80 --| |
81 --| HISTORY |
82 --| S.Sriram 21-Feb-2005 Created |
83 --+========================================================================+
84 -- End of comments
85
86 PROCEDURE DELETE_ITEM_TECHNICAL_DATA
87 (
88 p_api_version IN NUMBER
89 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90 , p_commit IN VARCHAR2 := FND_API.G_FALSE
91 , x_return_status OUT NOCOPY VARCHAR2
92 , x_msg_count OUT NOCOPY NUMBER
93 , x_msg_data OUT NOCOPY VARCHAR2
94 , p_tech_data_id IN NUMBER
95 );
96
97 --Start of comments
98 --+========================================================================+
99 --| API Name : FETCH_ITEM_TECHNICAL_DATA |
100 --| TYPE : Public |
101 --| Function : Fetches the Item technical data based on the input parm's|
102 --| passed. |
103 --| Notes : |
104 --| |
105 --| HISTORY |
106 --| S.Sriram 21-Feb-2005 Created |
107 --+========================================================================+
108 -- End of comments
109
110 PROCEDURE FETCH_ITEM_TECHNICAL_DATA (
111 p_api_version IN NUMBER
112 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113 , x_msg_count OUT NOCOPY NUMBER
114 , x_msg_data OUT NOCOPY VARCHAR2
115 , p_header_rec IN technical_data_hdr_rec
116 , x_dtl_tbl OUT NOCOPY technical_data_dtl_tab
117 , x_return_status OUT NOCOPY VARCHAR2
118 );
119
120 END GMD_ITEM_TECHNICAL_DATA_PUB ;
121