1 PACKAGE gme_cancel_batch_pvt AS
2 /* $Header: GMEVCCBS.pls 120.1 2005/06/03 12:25:37 appldev $ */
3 /*
4 REM *********************************************************************
5 REM *
6 REM * FILE: GMEVCCBS.pls
7 REM * PURPOSE: Package Specification for the GME batch cancel api
8 REM * AUTHOR: Pawan Kumar, OPM Development
9 REM * DATE: 28th April 2001
10 REM * HISTORY:
11 REM * ========
12 REM *
13 REM **********************************************************************
14 */
15 PROCEDURE cancel_batch (
16 p_batch_header_rec IN gme_batch_header%ROWTYPE
17 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
18 ,x_return_status OUT NOCOPY VARCHAR2);
19
20 PROCEDURE purge_batch_exceptions (
21 p_batch_header_rec IN gme_batch_header%ROWTYPE
22 ,p_delete_invis_mo IN VARCHAR2 := 'F'
23 ,p_delete_reservations IN VARCHAR2 := 'F'
24 ,p_delete_trans_pairs IN VARCHAR2 := 'F'
25 ,x_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE delete_pending_lots (
28 p_batch_id IN NUMBER
29 ,p_material_detail_id IN NUMBER DEFAULT NULL
30 ,x_return_status OUT NOCOPY VARCHAR2);
31 END gme_cancel_batch_pvt;