DBA Data[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;