1 PACKAGE igf_ap_li_prof_imp_proc AUTHID CURRENT_USER AS
2 /* $Header: IGFAP35S.pls 115.1 2003/06/12 16:39:20 rasahoo noship $ */
3 PROCEDURE main ( errbuf IN OUT NOCOPY VARCHAR2,
4 retcode IN OUT NOCOPY NUMBER,
5 p_award_year IN VARCHAR2,
6 p_batch_id IN NUMBER,
7 p_del_int IN VARCHAR2,
8 p_css_import IN VARCHAR2 DEFAULT NULL);
9
10
11 TYPE message_rec IS RECORD
12 (field_name VARCHAR2(30),
13 msg_text VARCHAR2(2000));
14 TYPE lookup_meaning_tab IS TABLE OF message_rec
15 INDEX BY BINARY_INTEGER;
16 lookup_meaning_table lookup_meaning_tab;
17
18 TYPE igf_ap_lkup_hash_table IS TABLE OF NUMBER
19 INDEX BY BINARY_INTEGER;
20 lookup_hash_table igf_ap_lkup_hash_table;
21
22
23 TYPE igf_ap_message_table IS TABLE OF message_rec
24 INDEX BY BINARY_INTEGER;
25 PROCEDURE css_import( errbuf IN OUT NOCOPY VARCHAR2,
26 retcode IN OUT NOCOPY NUMBER,
27 p_award_year IN VARCHAR2);
28
29
30 END igf_ap_li_prof_imp_proc;