[Home] [Help]
PACKAGE: APPS.CSD_BULK_RECEIVE_UTIL
Source
1 PACKAGE CSD_BULK_RECEIVE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: csdubrus.pls 120.3.12010000.3 2008/12/22 21:36:54 swai ship $ */
3
4 /* ---------------------------------------------------------*/
5 /* Define global variables */
6 /* ---------------------------------------------------------*/
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_BULK_RECEIVE_UTIL';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvbuts.pls';
9
10 /*--------------------------------------------------*/
11 /* Record name : Bulk_Receive_Rec */
12 /* description : Bulk Receive Rec record type */
13 /* definition */
14 /*--------------------------------------------------*/
15 TYPE BULK_RECEIVE_REC IS RECORD
16 (
17 BULK_RECEIVE_ID NUMBER,
18 TRANSACTION_NUMBER NUMBER,
19 ORIG_PARTY_ID NUMBER,
20 ORIG_CUST_ACCOUNT_ID NUMBER,
21 PARTY_ID NUMBER,
22 CUST_ACCOUNT_ID NUMBER,
23 SERIAL_NUMBER VARCHAR2(30),
24 INVENTORY_ITEM_ID NUMBER,
25 INSTANCE_ID NUMBER,
26 QUANTITY NUMBER,
27 UOM_CODE VARCHAR2(3),
28 STATUS VARCHAR2(30),
29 PROCESS_STATUS VARCHAR2(30),
30 CHANGE_OWNER_FLAG VARCHAR2(1),
31 INTERNAL_SR_FLAG VARCHAR2(1),
32 WARNING_FLAG VARCHAR2(1),
33 WARNING_REASON_CODE VARCHAR2(80),
34 INCIDENT_ID NUMBER,
35 REPAIR_LINE_ID NUMBER,
36 ATTRIBUTE_CATEGORY VARCHAR2(30),
37 ATTRIBUTE1 VARCHAR2(150),
38 ATTRIBUTE2 VARCHAR2(150),
39 ATTRIBUTE3 VARCHAR2(150),
40 ATTRIBUTE4 VARCHAR2(150),
41 ATTRIBUTE5 VARCHAR2(150),
42 ATTRIBUTE6 VARCHAR2(150),
43 ATTRIBUTE7 VARCHAR2(150),
44 ATTRIBUTE8 VARCHAR2(150),
45 ATTRIBUTE9 VARCHAR2(150),
46 ATTRIBUTE10 VARCHAR2(150),
47 ATTRIBUTE11 VARCHAR2(150),
48 ATTRIBUTE12 VARCHAR2(150),
49 ATTRIBUTE13 VARCHAR2(150),
50 ATTRIBUTE14 VARCHAR2(150),
51 ATTRIBUTE15 VARCHAR2(150),
52 OBJECT_VERSION_NUMBER NUMBER,
53 CREATED_BY NUMBER(15),
54 CREATION_DATE DATE,
55 LAST_UPDATED_BY NUMBER(15),
56 LAST_UPDATE_DATE DATE,
57 LAST_UPDATE_LOGIN NUMBER(15)
58 );
59
60
61 /*--------------------------------------------------*/
62 /* Record name : Bulk_AutoReceive_Rec */
63 /* description : Bulk AutoReceive Record definition */
64 /* */
65 /*--------------------------------------------------*/
66 TYPE BULK_AUTORCV_REC IS RECORD
67 (
68
69 BULK_RECEIVE_ID NUMBER,
70 REPAIR_LINE_ID NUMBER,
71 ORDER_LINE_ID NUMBER,
72 ORDER_HEADER_ID NUMBER
73
74 );
75
76 TYPE BULK_AUTORCV_TBL IS TABLE OF BULK_AUTORCV_REC INDEX BY BINARY_INTEGER;
77
78
79 /*-----------------------------------------------------------------*/
80 /* procedure name: validate_bulk_receive_rec */
81 /* description : Validate Bulk Receive record definition */
82 /* */
83 /*-----------------------------------------------------------------*/
84 PROCEDURE validate_bulk_receive_rec
85 (
86 p_party_id IN NUMBER,
87 p_quantity IN NUMBER,
88 p_serial_number IN VARCHAR2,
89 p_inventory_item_id IN NUMBER,
90 x_warning_flag OUT NOCOPY VARCHAR2,
91 x_warning_reason_code OUT NOCOPY VARCHAR2,
92 x_change_owner_flag OUT NOCOPY VARCHAR2,
93 x_internal_sr_flag OUT NOCOPY VARCHAR2
94 );
95
96 /*-----------------------------------------------------------------*/
97 /* procedure name: create_blkrcv_sr */
98 /* description : Procedure to create Service Request */
99 /* */
100 /*-----------------------------------------------------------------*/
101 PROCEDURE create_blkrcv_sr
102 (
103 p_bulk_receive_rec IN csd_bulk_receive_util.bulk_receive_rec,
104 p_sr_notes_tbl IN cs_servicerequest_pub.notes_table,
105 x_incident_id OUT NOCOPY NUMBER,
106 x_incident_number OUT NOCOPY VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 /*-----------------------------------------------------------------*/
113 /* procedure name: create_blkrcv_ro */
114 /* description : Procedure to create Repair Orders */
115 /* */
116 /*-----------------------------------------------------------------*/
117 PROCEDURE create_blkrcv_ro
118 (
119 p_bulk_receive_id IN NUMBER,
120 x_repair_line_id OUT NOCOPY NUMBER,
121 x_repair_number OUT NOCOPY VARCHAR2,
122 x_ro_status OUT NOCOPY VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2
126 ) ;
127
128 /*------------------------------------------------------------------*/
129 /* procedure name: create_blkrcv_default_prod_txn */
130 /* description : Procedure to create Default Product Transactions */
131 /* */
132 /*------------------------------------------------------------------*/
133 PROCEDURE create_blkrcv_default_prod_txn
134 (
135 p_bulk_receive_id IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 /*-----------------------------------------------------------------*/
142 /* procedure name: change_blkrcv_ib_owner */
143 /* description : Procedure to Change the Install Base Owner */
144 /* */
145 /*-----------------------------------------------------------------*/
146 PROCEDURE change_blkrcv_ib_owner
147 (
148 p_bulk_receive_id IN NUMBER,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154 /*-----------------------------------------------------------------*/
155 /* procedure name: bulk_auto_receive */
156 /* description : Procedure to Auto Receive */
157 /* */
158 /*-----------------------------------------------------------------*/
159 PROCEDURE bulk_auto_receive
160 (
161 p_bulk_autorcv_tbl IN OUT NOCOPY csd_bulk_receive_util.bulk_autorcv_tbl,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2
165 );
166
167 /*-----------------------------------------------------------------*/
168 /* procedure name: write_to_conc_log */
169 /* description : Procedure to write the error stack to the the */
170 /* Concurrent log */
171 /*-----------------------------------------------------------------*/
172 PROCEDURE write_to_conc_log
173 (
174 p_msg_count IN NUMBER,
175 p_msg_data IN VARCHAR2
176 );
177
178 /*-----------------------------------------------------------------*/
179 /* procedure name: write_to_conc_output */
180 /* description : Procedure to write the output to the Concurrent */
181 /* Output */
182 /*-----------------------------------------------------------------*/
183 PROCEDURE write_to_conc_output
184 (
185 p_transaction_number IN NUMBER
186 );
187
188 -- swai: bug 7657379
189 -- added function to get default repair type and use bulk receiving
190 -- profile option value as backup default value.
191 /*-----------------------------------------------------------------*/
192 /* function name: get_bulk_rcv_def_repair_type */
193 /* description : Function to get the default repair type for */
194 /* bulk receiving, based on defaulting rules and */
195 /* bulk receiving profile option. */
196 /* Output Repair Type ID */
197 /*-----------------------------------------------------------------*/
198 FUNCTION get_bulk_rcv_def_repair_type
199 (
200 p_incident_id IN NUMBER,
201 p_ro_inventory_item_id IN NUMBER
202 ) return NUMBER;
203
204 -- swai: bug 7663674
205 -- added function to get default rma subinv and use bulk receiving
206 -- profile option value as backup default value.
207 /*-----------------------------------------------------------------*/
208 /* function name: get_bulk_rcv_def_sub_inv */
209 /* description : Function to get the default rma subinv for */
210 /* bulk receiving, based on defaulting rules and */
211 /* bulk receiving profile option. */
212 /* Output RMA Subinventory Code */
213 /*-----------------------------------------------------------------*/
214 FUNCTION get_bulk_rcv_def_sub_inv
215 (
216 p_repair_line_id IN NUMBER
217 ) return VARCHAR2;
218
219 END CSD_BULK_RECEIVE_UTIL;