[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