138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2 ,
140: x_msg_count OUT NOCOPY NUMBER ,
141: x_msg_data OUT NOCOPY VARCHAR2 ,
142: p_shop_list_ids IN jtf_number_table ,
143: p_obj_ver_numbers IN jtf_number_table
144: );
145:
146:
139: x_return_status OUT NOCOPY VARCHAR2 ,
140: x_msg_count OUT NOCOPY NUMBER ,
141: x_msg_data OUT NOCOPY VARCHAR2 ,
142: p_shop_list_ids IN jtf_number_table ,
143: p_obj_ver_numbers IN jtf_number_table
144: );
145:
146:
147: PROCEDURE Delete_All_Lines(
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2 ,
152: x_msg_count OUT NOCOPY NUMBER ,
153: x_msg_data OUT NOCOPY VARCHAR2 ,
154: p_shop_list_ids IN jtf_number_table ,
155: p_obj_ver_numbers IN jtf_number_table
156: );
157:
158:
151: x_return_status OUT NOCOPY VARCHAR2 ,
152: x_msg_count OUT NOCOPY NUMBER ,
153: x_msg_data OUT NOCOPY VARCHAR2 ,
154: p_shop_list_ids IN jtf_number_table ,
155: p_obj_ver_numbers IN jtf_number_table
156: );
157:
158:
159: PROCEDURE Delete_Lines(
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2 ,
164: x_msg_count OUT NOCOPY NUMBER ,
165: x_msg_data OUT NOCOPY VARCHAR2 ,
166: p_shop_list_line_ids IN jtf_number_table ,
167: p_obj_ver_numbers IN jtf_number_table
168: );
169:
170:
163: x_return_status OUT NOCOPY VARCHAR2 ,
164: x_msg_count OUT NOCOPY NUMBER ,
165: x_msg_data OUT NOCOPY VARCHAR2 ,
166: p_shop_list_line_ids IN jtf_number_table ,
167: p_obj_ver_numbers IN jtf_number_table
168: );
169:
170:
171: PROCEDURE Save(
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: p_sl_line_ids IN jtf_number_table ,
194: p_sl_line_ovns IN jtf_number_table := NULL ,
195: p_mode IN VARCHAR2 := 'MERGE' ,
196: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_sl_header_rec IN SL_Header_Rec_Type ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: p_sl_line_ids IN jtf_number_table ,
194: p_sl_line_ovns IN jtf_number_table := NULL ,
195: p_mode IN VARCHAR2 := 'MERGE' ,
196: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_sl_header_rec IN SL_Header_Rec_Type ,
198: x_sl_header_id OUT NOCOPY NUMBER
222: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
223: x_return_status OUT NOCOPY VARCHAR2 ,
224: x_msg_count OUT NOCOPY NUMBER ,
225: x_msg_data OUT NOCOPY VARCHAR2 ,
226: p_sl_line_ids IN jtf_number_table ,
227: p_sl_line_ovns IN jtf_number_table := NULL ,
228: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
223: x_return_status OUT NOCOPY VARCHAR2 ,
224: x_msg_count OUT NOCOPY NUMBER ,
225: x_msg_data OUT NOCOPY VARCHAR2 ,
226: p_sl_line_ids IN jtf_number_table ,
227: p_sl_line_ovns IN jtf_number_table := NULL ,
228: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,