[Home] [Help]
PACKAGE BODY: APPS.CS_INST_DETAIL_PUB
Source
1 PACKAGE BODY CS_Inst_Detail_PUB AS
2 -- $Header: cspinsdb.pls 120.0 2005/08/29 15:45:43 epajaril noship $
3
4 -- ---------------------------------------------------------
5 -- Define global variables
6 -- ---------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_Inst_Detail_PUB';
8 -- ---------------------------------------------------------
9
10 -- ---------------------------------------------------------
11 -- Define private procedures (not in package spec)
12 -- ---------------------------------------------------------
13
14 PROCEDURE Initialize_Line_Inst_Rec
15 (
16 p_line_inst_dtl_rec IN CS_Inst_Detail_PUB.Line_Inst_Dtl_Rec_Type,
17 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
18 x_line_inst_dtl_rec OUT NOCOPY CS_Inst_Detail_PUB.Line_Inst_Dtl_Rec_Type,
19 x_line_inst_dtl_desc_flex OUT NOCOPY CS_InstalledBase_PUB.DFF_Rec_Type
20 ) IS
21
22
23 BEGIN
24 null;
25 END Initialize_Line_Inst_Rec;
26
27 PROCEDURE Init_Line_Inst_Rec_For_Upd
28 (
29 p_line_inst_dtl_rec IN CS_Inst_Detail_PUB.Line_Inst_Dtl_Rec_Type,
30 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
31 p_old_line_inst_dtl_rec IN CS_Inst_Detail_PUB.Line_Inst_Dtl_Rec_Type,
32 p_old_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
33 x_line_inst_dtl_rec OUT NOCOPY CS_Inst_Detail_PUB.Line_Inst_Dtl_Rec_Type,
34 x_line_inst_dtl_desc_flex OUT NOCOPY CS_InstalledBase_PUB.DFF_Rec_Type
35 ) IS
36
37 BEGIN
38 null;
39 END Init_Line_Inst_Rec_For_Upd;
40
41 PROCEDURE Get_Line_Inst_Details
42 (
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_line_inst_detail_id IN NUMBER,
50 x_line_inst_dtl_rec OUT NOCOPY Line_Inst_Dtl_Rec_Type,
51 x_line_inst_dtl_desc_flex OUT NOCOPY CS_InstalledBase_PUB.DFF_Rec_Type
52 ) IS
53
54
55 BEGIN
56 null;
57 END Get_Line_Inst_Details;
58
59 /* Start of OverLoaded Procedure */
60
61 PROCEDURE Get_Line_Inst_Details
62 (
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_order_line_id IN NUMBER,
70 x_line_inst_dtl_tbl OUT NOCOPY Line_Inst_Dtl_Tbl_Type,
71 x_line_inst_dtl_tbl_count OUT NOCOPY NUMBER
72 ) IS
73
74 BEGIN
75 null;
76 END Get_Line_Inst_Details;
77
78
79 PROCEDURE Get_Rma_Line_Inst_Details
80 (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_rma_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
88 p_order_line_id IN NUMBER,
89 x_line_inst_dtl_tbl OUT NOCOPY CS_INST_DETAIL_PUB.Line_Inst_Dtl_Tbl_Type,
90 x_line_inst_dtl_tbl_count OUT NOCOPY NUMBER
91 ) IS
92
93 BEGIN
94 null;
95 END Get_Rma_Line_Inst_Details;
96
97
98 PROCEDURE Validate_Installation_Details
99 (
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
102 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
107 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
108 p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE
109 ) IS
110 BEGIN
111 null;
112 END Validate_Installation_Details;
113
114 PROCEDURE Create_Installation_Details
115 (
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
123 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
124 p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
125 x_line_inst_detail_id OUT NOCOPY NUMBER,
126 x_object_version_number OUT NOCOPY NUMBER -- was commented
127 ) IS
128
129 l_api_name CONSTANT VARCHAR2(30) := 'Create_Installation_Details';
130 l_api_version CONSTANT NUMBER := 1.0;
131 BEGIN
132 null;
133 END Create_Installation_Details;
134
135 PROCEDURE Update_Installation_Details
136 (
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
144 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
145 p_object_version_number IN NUMBER,
146 x_object_version_number OUT NOCOPY NUMBER -- was commented
147 ) IS
148
149
150 BEGIN
151 null;
152 END Update_Installation_Details;
153
154 PROCEDURE Delete_Installation_Details
155 (
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_line_inst_detail_id IN NUMBER--,
163 -- p_object_version_number IN NUMBER
164 ) IS
165 BEGIN
166 null;
167 END Delete_Installation_Details;
168
169
170 /* Added this Procedure for RMA returns Bug 1500577 shegde */
171
172 PROCEDURE Update_Inst_Details_RMA_Rcpt
173 (
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
176 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_rcpt_tbl IN RMA_RCPT_TBL_TYPE,
181 p_rcpt_tbl_count IN NUMBER,
182 p_order_line_id IN NUMBER,
183 p_cp_id IN NUMBER,
184 p_serial_flag IN VARCHAR2,
185 p_object_version_number IN NUMBER,
186 x_object_version_number OUT NOCOPY NUMBER
187 ) IS
188
189 BEGIN
190 null;
191 END Update_Inst_Details_RMA_Rcpt;
192
193
194 END CS_Inst_Detail_PUB;