1 PACKAGE gme_cancel_batch_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVCCBS.pls 120.1.12010000.2 2009/03/23 13:37:46 gmurator ship $ */
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 * G. Muratore 22-MAR-09 Bug 8312658
14 REM * New parameter p_recursive added. 'R' value will initiate recursive logic.
15 REM * PROCEDURE: purge_batch_exceptions
16 REM **********************************************************************
17 */
18 PROCEDURE cancel_batch (
19 p_batch_header_rec IN gme_batch_header%ROWTYPE
20 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
21 ,x_return_status OUT NOCOPY VARCHAR2);
22
23 PROCEDURE purge_batch_exceptions (
24 p_batch_header_rec IN gme_batch_header%ROWTYPE
25 ,p_delete_invis_mo IN VARCHAR2 := 'F'
26 ,p_delete_reservations IN VARCHAR2 := 'F'
27 ,p_delete_trans_pairs IN VARCHAR2 := 'F'
28 ,p_recursive IN VARCHAR2 := 'N'
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31 PROCEDURE delete_pending_lots (
32 p_batch_id IN NUMBER
33 ,p_material_detail_id IN NUMBER DEFAULT NULL
34 ,x_return_status OUT NOCOPY VARCHAR2);
35 END gme_cancel_batch_pvt;