[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