11: -- cannot be based on a record type that is non-scalar.
12:
13: TYPE Line_Inst_Dtl_Rec_Type IS RECORD
14: (
15: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
16: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12:
13: TYPE Line_Inst_Dtl_Rec_Type IS RECORD
14: (
15: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
16: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
13: TYPE Line_Inst_Dtl_Rec_Type IS RECORD
14: (
15: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
16: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
14: (
15: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
16: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
16: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
16: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
18: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
21: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
22: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
23: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
24: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
32: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Added shegde
25: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
32: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Added shegde
33: --desc_flex DFF_Rec_Type
26: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
32: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Added shegde
33: --desc_flex DFF_Rec_Type
34: );
27: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
32: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Added shegde
33: --desc_flex DFF_Rec_Type
34: );
35:
28: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
32: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Added shegde
33: --desc_flex DFF_Rec_Type
34: );
35:
36: TYPE Line_Inst_Dtl_Tbl_Type is TABLE OF Line_Inst_Dtl_Rec_Type
38:
39:
40: TYPE Rma_Rcpt_Rec_Type IS RECORD
41: (
42: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
44: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM
45: );
46:
39:
40: TYPE Rma_Rcpt_Rec_Type IS RECORD
41: (
42: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
44: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM
45: );
46:
47: TYPE Rma_Rcpt_Tbl_Type is TABLE OF Rma_Rcpt_Rec_Type
40: TYPE Rma_Rcpt_Rec_Type IS RECORD
41: (
42: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
44: rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM
45: );
46:
47: TYPE Rma_Rcpt_Tbl_Type is TABLE OF Rma_Rcpt_Rec_Type
48: INDEX BY BINARY_INTEGER;
50: --------------------------------------------------------------------------
51: PROCEDURE Get_Line_Inst_Details
52: (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
51: PROCEDURE Get_Line_Inst_Details
52: (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_line_inst_detail_id IN NUMBER,
65:
66: PROCEDURE Get_Line_Inst_Details
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
66: PROCEDURE Get_Line_Inst_Details
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_order_line_id IN NUMBER,
80:
81: PROCEDURE Get_rma_line_Inst_Details
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
81: PROCEDURE Get_rma_line_Inst_Details
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_rma_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
85: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_rma_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
90: p_order_line_id IN NUMBER,
91: x_line_inst_dtl_tbl OUT NOCOPY CS_INST_DETAIL_PUB.Line_Inst_Dtl_Tbl_Type,
92: x_line_inst_dtl_tbl_count OUT NOCOPY NUMBER
93: );
105: --
106: -- Standard IN Parameters:
107: -- p_api_version IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: --
111: -- Standard OUT NOCOPY Parameters:
112: -- x_return_status OUT NOCOPY VARCHAR2(1)
113: -- x_msg_count OUT NOCOPY NUMBER
128:
129: PROCEDURE Create_Installation_Details
130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
129: PROCEDURE Create_Installation_Details
130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
138: p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
139: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140: x_line_inst_detail_id OUT NOCOPY NUMBER,
141: x_object_version_number OUT NOCOPY NUMBER -- was commented
142: );
143:
152: --
153: -- Standard IN Parameters:
154: -- p_api_version IN NUMBER Required
155: -- p_init_msg_list IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: --
158: -- Standard OUT NOCOPY Parameters:
159: -- x_return_status OUT NOCOPY VARCHAR2(1)
160: -- x_msg_count OUT NOCOPY NUMBER
175:
176: PROCEDURE Update_Installation_Details
177: (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
176: PROCEDURE Update_Installation_Details
177: (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
198: --
199: -- Standard IN Parameters:
200: -- p_api_version IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional
202: -- Default = FND_API.G_FALSE
203: --
204: -- Standard OUT NOCOPY Parameters:
205: -- x_return_status OUT NOCOPY VARCHAR2(1)
206: -- x_msg_count OUT NOCOPY NUMBER
220:
221: PROCEDURE Delete_Installation_Details
222: (
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
221: PROCEDURE Delete_Installation_Details
222: (
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_line_inst_detail_id IN NUMBER--,
234:
235: PROCEDURE Update_Inst_Details_RMA_Rcpt
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
239: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
235: PROCEDURE Update_Inst_Details_RMA_Rcpt
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
239: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_rcpt_tbl IN RMA_RCPT_TBL_TYPE,