DBA Data[Home] [Help]

PACKAGE: APPS.IGS_AD_GRD_DATA_LOAD

Source


1 PACKAGE IGS_AD_GRD_DATA_LOAD AUTHID CURRENT_USER AS
2 /* $Header: IGSAD77S.pls 115.6 2002/11/28 21:41:49 nsidana ship $ */
3 
4 --Global Variables
5 
6 G_vtac_output_buffer		VARCHAR2(4000);
7 G_read_number 			NUMBER := 0;
8 G_test_only			VARCHAR2(5) := 'FALSE';
9 G_match_person_id		NUMBER(15)  := 0;
10 G_new_person_id			NUMBER(15)  := 0;
11 G_current_person_id		NUMBER(15)  := 0;
12 G_ret_val			NUMBER(2)   := 0;
13 G_aus_edu			VARCHAR2(5) := 'FALSE';
14 G_message_str			VARCHAR2(2000);
15 G_vtac_all_given_names		VARCHAR2(42);
16 
17 p_acad_cal_type		VARCHAR2(10);
18 p_acad_seq_num 		NUMBER(6);
19 p_adm_cal_type 		VARCHAR2(10);
20 p_adm_seq_num 		NUMBER(6);
21 p_fee_paying_appl_ind	VARCHAR2(10);
22 
23 -- Inserts a person and alternate person ID record with data from TAC
24 PROCEDURE admp_ins_vtac_offer  (
25   errbuf  			out NOCOPY varchar2,
26   retcode 			out NOCOPY number,
27   p_file_name	         	IN VARCHAR2 ,
28   p_offer_round			IN NUMBER,
29   p_acad_perd 			IN VARCHAR2,
30   p_adm_perd		      	IN VARCHAR2,
31   p_aus_addr_type		IN VARCHAR2,
32   p_os_addr_type		IN VARCHAR2,
33   p_alt_person_id_type		IN VARCHAR2,
34   p_override_adm_cat		IN VARCHAR2,
35   p_fee_payment			IN VARCHAR2,
36   p_fee_paying_hpo   		IN VARCHAR2,
37   p_pre_enrol_ind		IN VARCHAR2,
38   p_offer_letter_req_ind	IN VARCHAR2,
39   p_org_id			IN NUMBER);
40 
41 END IGS_AD_GRD_DATA_LOAD;	--End of Package Specification