[Home] [Help]
PACKAGE: APPS.IGF_AP_ISIR_IMPORT_PKG
Source
1 PACKAGE IGF_AP_ISIR_IMPORT_PKG AS
2 /* $Header: IGFAP01S.pls 120.0 2005/06/01 13:51:34 appldev noship $ */
3
4
5 PROCEDURE main_import_process (
6 errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY NUMBER,
8 p_org_id IN NUMBER,
9 p_award_year IN VARCHAR2,
10 p_force_add IN VARCHAR2,
11 p_create_inquiry IN VARCHAR2,
12 p_adm_source_type IN VARCHAR2,
13 p_match_code IN VARCHAR2,
14 p_rec_type IN VARCHAR2,
15 p_rec_status IN VARCHAR2,
16 p_message_class IN VARCHAR2,
17 p_school_type IN VARCHAR2,
18 p_school_code IN VARCHAR2,
19 p_del_int IN VARCHAR2,
20 p_spawn_process IN VARCHAR2,
21 p_upd_ant_val IN VARCHAR2 DEFAULT 'Y'
22 );
23
24 PROCEDURE validate_corrections (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
25 p_isir_id igf_ap_isir_matched.isir_id%TYPE);
26
27
28 PROCEDURE update_matched_isir (p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
29 p_system_record_type igf_ap_isir_matched_all.system_record_type%TYPE,
30 p_payment_isir igf_ap_isir_matched_all.payment_isir%TYPE,
31 p_active_isir igf_ap_isir_matched_all.active_isir%TYPE DEFAULT NULL);
32
33 PROCEDURE update_fabase (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
34 p_isir_corr_status igf_ap_fa_base_rec_all.isir_corr_status%TYPE,
35 p_isir_corr_status_date igf_ap_fa_base_rec_all.isir_corr_status_date%TYPE);
36
37 PROCEDURE update_isir_corr (p_isirc_id igf_ap_isir_corr_all.isirc_id%TYPE,
38 p_correction_status igf_ap_isir_corr_all.correction_status%TYPE DEFAULT NULL );
39
40 PROCEDURE prepare_message;
41
42 PROCEDURE create_message(document_id IN VARCHAR2,display_type IN VARCHAR2,document IN OUT NOCOPY VARCHAR2,
43 document_type IN OUT NOCOPY VARCHAR2);
44
45 PROCEDURE outside_corrections(itemtype IN VARCHAR2,itemkey IN VARCHAR2,actid IN NUMBER,funcmode IN VARCHAR2,resultout OUT NOCOPY VARCHAR2);
46
47 PROCEDURE send_message;
48
49
50 END IGF_AP_ISIR_IMPORT_PKG;