259:
260: PROCEDURE resale_pre_process
261: (
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266: p_batch_id IN NUMBER,
267: x_batch_status OUT NOCOPY VARCHAR2,
260: PROCEDURE resale_pre_process
261: (
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266: p_batch_id IN NUMBER,
267: x_batch_status OUT NOCOPY VARCHAR2,
268: x_return_status OUT NOCOPY VARCHAR2,
261: (
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266: p_batch_id IN NUMBER,
267: x_batch_status OUT NOCOPY VARCHAR2,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
271: );
272:
273: PROCEDURE Batch_Update (
274: p_api_version_number IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: p_batch_id IN NUMBER,
279: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
272:
273: PROCEDURE Batch_Update (
274: p_api_version_number IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: p_batch_id IN NUMBER,
279: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
280: x_return_status OUT NOCOPY VARCHAR2,
273: PROCEDURE Batch_Update (
274: p_api_version_number IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: p_batch_id IN NUMBER,
279: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
291:
292: PROCEDURE Validate_Batch
293: (
294: p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,
299: x_batch_status OUT NOCOPY VARCHAR2,
292: PROCEDURE Validate_Batch
293: (
294: p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,
299: x_batch_status OUT NOCOPY VARCHAR2,
300: x_return_status OUT NOCOPY VARCHAR2,
293: (
294: p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,
299: x_batch_status OUT NOCOPY VARCHAR2,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
304:
305: PROCEDURE Batch_Defaulting
306: (
307: p_api_version_number IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,
312: x_return_status OUT NOCOPY VARCHAR2,
305: PROCEDURE Batch_Defaulting
306: (
307: p_api_version_number IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
306: (
307: p_api_version_number IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2
528: );
529:
530: PROCEDURE DQM_processing (
531: p_api_version_number IN NUMBER,
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533: p_commit IN VARCHAR2 := FND_API.G_FALSE,
534: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
535: p_party_rec IN party_rec_type,
536: p_party_site_rec IN party_site_rec_type,
529:
530: PROCEDURE DQM_processing (
531: p_api_version_number IN NUMBER,
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533: p_commit IN VARCHAR2 := FND_API.G_FALSE,
534: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
535: p_party_rec IN party_rec_type,
536: p_party_site_rec IN party_site_rec_type,
537: p_contact_rec IN party_cntct_rec_type,
530: PROCEDURE DQM_processing (
531: p_api_version_number IN NUMBER,
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533: p_commit IN VARCHAR2 := FND_API.G_FALSE,
534: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
535: p_party_rec IN party_rec_type,
536: p_party_site_rec IN party_site_rec_type,
537: p_contact_rec IN party_cntct_rec_type,
538: x_party_id OUT NOCOPY NUMBER,
601: );
602:
603: PROCEDURE update_interface_line (
604: p_api_version_number IN NUMBER,
605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
606: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
607: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
608: p_int_line_tbl IN resale_line_int_tbl_type,
609: x_return_status OUT NOCOPY VARCHAR2,
602:
603: PROCEDURE update_interface_line (
604: p_api_version_number IN NUMBER,
605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
606: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
607: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
608: p_int_line_tbl IN resale_line_int_tbl_type,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
603: PROCEDURE update_interface_line (
604: p_api_version_number IN NUMBER,
605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
606: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
607: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
608: p_int_line_tbl IN resale_line_int_tbl_type,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2
612: );
613:
614: PROCEDURE update_interface_batch (
615: p_api_version_number IN NUMBER,
616: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
620: x_return_status OUT NOCOPY VARCHAR2,
613:
614: PROCEDURE update_interface_batch (
615: p_api_version_number IN NUMBER,
616: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
614: PROCEDURE update_interface_batch (
615: p_api_version_number IN NUMBER,
616: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
620: x_return_status OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,
622: x_msg_data OUT NOCOPY VARCHAR2