1 PACKAGE igr_gen_001 AS
2 /* $Header: IGSRT01S.pls 120.0 2005/06/02 04:27:30 appldev noship $ */
3 /****************************************************************************
4 Created By : RBODDU
5 Date Created On : 12-FEB-2003
6 Purpose : 2664699
7
8 Change History
9 Who When What
10 sjlaport 17-Feb-05 Added function Admp_Del_Eap_Eitpi for IGR pseudo product
11 jchin 14-Feb-05 Modified package for IGR pseudo product
12 sjlaport 07-Mar-05 Modified for APC - bug #3799487
13 (reverse chronological order - newest change first)
14 *****************************************************************************/
15 PROCEDURE admp_upd_eap_avail(
16 errbuf OUT NOCOPY VARCHAR2,
17 retcode OUT NOCOPY NUMBER,
18 p_process_status IN VARCHAR2 ,
19 p_package_unavailable IN VARCHAR2 ,
20 p_package_incomplete IN VARCHAR2 ,
21 p_responsible_user IN NUMBER,
22 p_default_user IN NUMBER DEFAULT NULL,
23 p_inq_src_type IN VARCHAR2,
24 p_product_category_id IN NUMBER DEFAULT NULL,
25 p_inq_date_low IN VARCHAR2 DEFAULT NULL,
26 p_inq_date_high IN VARCHAR2 DEFAULT NULL,
27 p_inq_info_type IN igr_i_info_types_v.info_type_id%type);
28
29 Function Admp_Del_Eap_Eitpi(
30 p_person_id IN NUMBER ,
31 p_enquiry_appl_number IN NUMBER ,
32 p_enquiry_information_type IN VARCHAR2 ,
33 p_message_name OUT NOCOPY VARCHAR2 )
34 RETURN BOOLEAN;
35
36 Function Admp_Ins_Eap_Eitpi(
37 p_person_id IN NUMBER ,
38 p_enquiry_appl_number IN NUMBER ,
39 p_enquiry_information_type IN VARCHAR2 ,
40 p_message_name OUT NOCOPY VARCHAR2 )
41 RETURN BOOLEAN;
42
43
44
45 END igr_gen_001;