PACKAGE: APPS.IGS_DA_PURGE_RQST_PKG

Source

1 PACKAGE igs_da_purge_rqst_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSDA11S.pls 115.1 2003/04/22 03:56:36 ddey noship $ */
3 /**************************************************************************************************************************
4 
5    Change History:
6    Who         When            What
7    DDEY        31-March-2003
8    1. Package Created for deleting the request by an Administrator and the Student.
9    2. The Job is written to purge the Data, in the base tables based on the parameters passed.
10 ******************************************************************************************************************************/
11 
12 
13 PROCEDURE delete_row(
14                                p_batch_id          IN NUMBER,
15                                x_status            OUT NOCOPY VARCHAR2
16                      ) ;
17 
18 
19 
20 PROCEDURE purge_request(
21                                ERRBUF    OUT NOCOPY VARCHAR2 ,
22                                RETCODE   OUT NOCOPY NUMBER ,
23 			       p_c_start_date IN VARCHAR2 ,
24                                p_c_end_date IN VARCHAR2,
25                                p_c_request_number IN NUMBER,
26                                p_requestor_id  IN NUMBER,
27                                p_responsibility IN VARCHAR2,
28                                p_request_status IN VARCHAR2,
29                                p_request_type IN VARCHAR2
30                           ) ;
31 
32 
33 END igs_da_purge_rqst_pkg;