1 PACKAGE GMD_ITEM_TECHNICAL_DATA_PVT AS
2 /* $Header: GMDVITDS.pls 120.3 2005/08/24 08:18:09 srsriran noship $ */
3
4
5 --Start of comments
6 --+========================================================================+
7 --| API Name : INSERT_ITEM_TECHNICAL_DATA_HDR |
8 --| TYPE : Private |
9 --| Function : Inserts the Item technical data header record |
10 --| Notes : |
11 --| |
12 --| HISTORY |
13 --| S.Sriram 21-Feb-2005 Created |
14 --+========================================================================+
15 -- End of comments
16
17 PROCEDURE INSERT_ITEM_TECHNICAL_DATA_HDR
18 (
19 p_api_version IN NUMBER
20 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21 , p_commit IN VARCHAR2 := FND_API.G_FALSE
22 , x_return_status OUT NOCOPY VARCHAR2
23 , x_msg_count OUT NOCOPY NUMBER
24 , x_msg_data OUT NOCOPY VARCHAR2
25 , x_tech_data_id IN OUT NOCOPY NUMBER
26 , p_organization_id IN NUMBER
27 , p_inventory_item_id IN NUMBER
28 , p_lot_no IN VARCHAR2
29 , p_lot_organization_id IN NUMBER
30 , p_formula_id IN NUMBER
31 , p_batch_id IN NUMBER
32 , p_delete_mark IN NUMBER
33 , p_text_code IN NUMBER
34 , p_creation_date IN DATE
35 , p_created_by IN NUMBER
36 , p_last_update_date IN DATE
37 , p_last_updated_by IN NUMBER
38 , p_last_update_login IN NUMBER
39 );
40
41 --Start of comments
42 --+========================================================================+
43 --| API Name : INSERT_ITEM_TECHNICAL_DATA_DTL |
44 --| TYPE : Private |
45 --| Function : Inserts the Item technical data detail records |
46 --| Notes : |
47 --| |
48 --| HISTORY |
49 --| S.Sriram 21-Feb-2005 Created |
50 --+========================================================================+
51 -- End of comments
52
53 PROCEDURE INSERT_ITEM_TECHNICAL_DATA_DTL
54 (
55 p_api_version IN NUMBER
56 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
57 , p_commit IN VARCHAR2 := FND_API.G_FALSE
58 , x_return_status OUT NOCOPY VARCHAR2
59 , x_msg_count OUT NOCOPY NUMBER
60 , x_msg_data OUT NOCOPY VARCHAR2
61 , x_tech_data_id IN OUT NOCOPY NUMBER
62 , x_tech_parm_id IN OUT NOCOPY NUMBER
63 , p_sort_seq IN NUMBER
64 , p_text_data IN VARCHAR2
65 , p_num_data IN NUMBER
66 , p_boolean_data IN NUMBER
67 , p_text_code IN NUMBER
68 , p_creation_date IN DATE
69 , p_created_by IN NUMBER
70 , p_last_update_date IN DATE
71 , p_last_updated_by IN NUMBER
72 , p_last_update_login IN NUMBER
73 );
74
75 --Start of comments
76 --+========================================================================+
77 --| API Name : UPDATE_ITEM_TECHNICAL_DATA |
78 --| TYPE : Private |
79 --| Function : Updates the Item technical data detail records |
80 --| Notes : |
81 --| |
82 --| HISTORY |
83 --| S.Sriram 21-Feb-2005 Created |
84 --+========================================================================+
85 -- End of comments
86
87 PROCEDURE UPDATE_ITEM_TECHNICAL_DATA
88 (
89 p_api_version IN NUMBER
90 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
91 , p_commit IN VARCHAR2 := FND_API.G_FALSE
92 , x_return_status OUT NOCOPY VARCHAR2
93 , x_msg_count OUT NOCOPY NUMBER
94 , x_msg_data OUT NOCOPY VARCHAR2
95 , p_tech_data_id IN NUMBER
96 , x_tech_parm_id IN OUT NOCOPY NUMBER
97 , p_sort_seq IN NUMBER
98 , p_text_data IN VARCHAR2
99 , p_num_data IN NUMBER
100 , p_boolean_data IN NUMBER
101 , p_text_code IN NUMBER
102 , p_last_update_date IN DATE
103 , p_last_updated_by IN NUMBER
104 , p_last_update_login IN NUMBER
105 );
106
107 --Start of comments
108 --+========================================================================+
109 --| API Name : DELETE_ITEM_TECHNICAL_DATA |
110 --| TYPE : Private |
111 --| Function : Deletes the Item technical data |
112 --| Notes : |
113 --| |
114 --| HISTORY |
115 --| S.Sriram 21-Feb-2005 Created |
116 --+========================================================================+
117 -- End of comments
118
119 PROCEDURE DELETE_ITEM_TECHNICAL_DATA
120 (
121 p_api_version IN NUMBER
122 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123 , p_commit IN VARCHAR2 := FND_API.G_FALSE
124 , x_return_status OUT NOCOPY VARCHAR2
125 , x_msg_count OUT NOCOPY NUMBER
126 , x_msg_data OUT NOCOPY VARCHAR2
127 , p_tech_data_id IN NUMBER
128 );
129
130 --Start of comments
131 --+========================================================================+
132 --| API Name : FETCH_ITEM_TECHNICAL_DATA |
133 --| TYPE : Private |
134 --| Function : Fetches the Item technical data based on the input parm's|
135 --| passed. |
136 --| Notes : |
137 --| |
138 --| HISTORY |
139 --| S.Sriram 21-Feb-2005 Created |
140 --+========================================================================+
141 -- End of comments
142
143 PROCEDURE FETCH_ITEM_TECHNICAL_DATA (
144 p_api_version IN NUMBER
145 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
146 , x_msg_count OUT NOCOPY NUMBER
147 , x_msg_data OUT NOCOPY VARCHAR2
148 , p_header_rec IN GMD_ITEM_TECHNICAL_DATA_PUB.technical_data_hdr_rec
149 , x_dtl_tbl OUT NOCOPY GMD_ITEM_TECHNICAL_DATA_PUB.technical_data_dtl_tab
150 , x_return_status OUT NOCOPY VARCHAR2
151 );
152
153 END GMD_ITEM_TECHNICAL_DATA_PVT ;
154