DBA Data[Home] [Help]

PACKAGE: APPS.IGS_AD_PG_DATA_LOAD

Source


1 PACKAGE IGS_AD_PG_DATA_LOAD AUTHID CURRENT_USER AS
2 /* $Header: IGSAD78S.pls 115.5 2002/11/28 21:42:06 nsidana ship $ */
3 
4 	--Global Variables
5 G_vtac_pg_output_buffer			VARCHAR2(4000);
6 G_pg_read_number 			NUMBER := 0;
7 G_pg_test_only				VARCHAR2(5) := 'FALSE';
8 G_pg_match_person_id			NUMBER(15)  := 0;
9 G_pg_new_person_id			NUMBER(15)  := 0;
10 G_pg_current_person_id			NUMBER(15)  := 0;
11 G_pg_ret_val				NUMBER(2)   := 0;
12 G_pg_aus_edu				VARCHAR2(5) := 'FALSE';
13 G_pg_message_str			VARCHAR2(2000);
14 G_vtac_pg_all_given_names		VARCHAR2(42);
15 
16 p_acad_cal_type				VARCHAR2(10);
17 p_acad_seq_num		 		NUMBER(6);
18 p_adm_cal_type 				VARCHAR2(10);
19 p_adm_seq_num 				NUMBER(6);
20 
21 
22 
23 PROCEDURE admp_ins_vtac_pg_off  (
24       errbuf 				out NOCOPY varchar2,
25       retcode 				out NOCOPY number,
26       p_file_name			IN VARCHAR2 ,
27       p_offer_round			IN NUMBER,
28       p_acad_perd 			IN VARCHAR2,
29       p_adm_perd			IN VARCHAR2,
30       p_aus_addr_type			IN VARCHAR2,
31       p_os_addr_type			IN VARCHAR2,
32       p_alt_person_id_type		IN VARCHAR2,
33       p_override_adm_cat		IN VARCHAR2,
34       p_pre_enrol_ind			IN VARCHAR2,
35       p_offer_letter_req_ind		IN VARCHAR2,
36       p_org_id				IN NUMBER);
37 
38 
39 END IGS_AD_PG_DATA_LOAD;	--End of Package Specification