35: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
36:
37: TYPE Inst_detail_rec_type IS RECORD
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
36:
37: TYPE Inst_detail_rec_type IS RECORD
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
37: TYPE Inst_detail_rec_type IS RECORD
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
58: );
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
58: );
59: G_MISS_Inst_detail_Rec Inst_detail_Rec_Type;
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
58: );
59: G_MISS_Inst_detail_Rec Inst_detail_Rec_Type;
60: TYPE Inst_detail_Tbl_type IS TABLE OF Inst_detail_Rec_type
64:
65:
66: TYPE Contact_Rec_Type IS RECORD
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
65:
66: TYPE Contact_Rec_Type IS RECORD
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
66: TYPE Contact_Rec_Type IS RECORD
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
76: );
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
76: );
77:
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
76: );
77:
78:
124:
125:
126: TYPE Cascade_Line_Rec_Type IS RECORD
127: (
128: LINE_ID NUMBER := FND_API.G_MISS_NUM,
129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130: QTY_FACTOR NUMBER := 1,
131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132: );
125:
126: TYPE Cascade_Line_Rec_Type IS RECORD
127: (
128: LINE_ID NUMBER := FND_API.G_MISS_NUM,
129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130: QTY_FACTOR NUMBER := 1,
131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132: );
133:
127: (
128: LINE_ID NUMBER := FND_API.G_MISS_NUM,
129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130: QTY_FACTOR NUMBER := 1,
131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132: );
133:
134:
135: G_MISS_Cascade_Line_Rec Cascade_Line_Rec_Type;
142:
143:
144: TYPE Line_Inst_Rec_Type IS RECORD
145: (
146: LINE_ID NUMBER := FND_API.G_MISS_NUM,
147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148: QUANTITY NUMBER := FND_API.G_MISS_NUM
149: );
150:
143:
144: TYPE Line_Inst_Rec_Type IS RECORD
145: (
146: LINE_ID NUMBER := FND_API.G_MISS_NUM,
147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148: QUANTITY NUMBER := FND_API.G_MISS_NUM
149: );
150:
151:
144: TYPE Line_Inst_Rec_Type IS RECORD
145: (
146: LINE_ID NUMBER := FND_API.G_MISS_NUM,
147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148: QUANTITY NUMBER := FND_API.G_MISS_NUM
149: );
150:
151:
152: G_MISS_Line_Inst_Rec Line_Inst_Rec_Type;
175: --
176: -- Standard IN Parameters:
177: -- p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: --
181: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
182: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
183: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
198:
199: PROCEDURE Create_Installation_Detail
200: (
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
199: PROCEDURE Create_Installation_Detail
200: (
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
207: -- p_object_version_number IN NUMBER,
219: --
220: -- Standard IN Parameters:
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: --
225: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
226: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
227: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
242:
243: PROCEDURE Update_Installation_Detail
244: (
245: p_api_version_number IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
249: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
250: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
243: PROCEDURE Update_Installation_Detail
244: (
245: p_api_version_number IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
249: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
250: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251: p_object_version_number IN NUMBER,
250: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251: p_object_version_number IN NUMBER,
252: p_line_inst_dtl_tbl IN Inst_Detail_Tbl_Type,
253: p_contact_tbl IN contact_tbl_type DEFAULT G_MISS_Contact_Tbl,
254: p_cascade_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE );
255:
256:
257: --------------------------------------------------------------------------
258:
264: --
265: -- Standard IN Parameters:
266: -- p_api_version_number IN NUMBER Required
267: -- p_init_msg_list IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: --
270: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
271: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
272: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
286:
287: PROCEDURE Delete_Installation_Detail
288: (
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
291: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
293: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
294: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
287: PROCEDURE Delete_Installation_Detail
288: (
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
291: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
293: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
294: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
295: p_line_inst_dtl_id IN NUMBER
298:
299: PROCEDURE Autocreate_systems
300: (
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
306: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
299: PROCEDURE Autocreate_systems
300: (
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
306: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
307: -- p_system_tbl IN OUT NOCOPY /* file.sql.39 change */ System_Tbl_Type
311:
312: PROCEDURE Update_Inst_Details_ORDER
313: (
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
318: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
319: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
312: PROCEDURE Update_Inst_Details_ORDER
313: (
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
318: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
319: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
320: p_quote_line_shipment_id IN NUMBER,
323:
324:
325: PROCEDURE CASCADE_DETAILS_YN(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
328: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
330: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
331: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
324:
325: PROCEDURE CASCADE_DETAILS_YN(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
328: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
330: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
331: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
332: p_object_version_number IN NUMBER,