[Home] [Help]
PACKAGE: APPS.IGF_AP_INST_APP
Source
1 PACKAGE igf_ap_inst_app AS
2 /* $Header: IGFAP50S.pls 120.0 2005/09/09 17:12:29 appldev noship $ */
3 /*
4 || Created By : Ulhas
5 || Created On : 04-JUL-2005
6 || Purpose : This package has all the procedures to do the updation related
7 || to institutional applications submiited by the student
8 ||
9 || Known limitations, enhancements or remarks :
10 || Change History :
11 || Who When What
12 ||
13 ||
14 ||
15 */
16
17 PROCEDURE update_ToDo_status(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
18 p_application_code igf_ap_appl_status_all.application_code%TYPE,
19 x_return_status OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE update_ToDo (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
23 p_application_code igf_ap_appl_status_all.application_code%TYPE,
24 p_status IN igf_ap_td_item_inst_all.status%TYPE,
25 x_return_status OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE update_app_status(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
29 p_application_code igf_ap_appl_status_all.application_code%TYPE,
30 p_application_status_code igf_ap_appl_status_all.application_status_code%TYPE,
31 x_return_status OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE update_Ant_Data_For_All_Terms (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
35 p_cal_type igs_ca_inst_all.cal_type%TYPE,
36 p_seq_number igs_ca_inst_all.sequence_number%TYPE,
37 p_ant_data_column VARCHAR2,
38 p_ant_data_value VARCHAR2,
39 x_return_status OUT NOCOPY VARCHAR2,
40 p_override_flag VARCHAR2
41 );
42
43 PROCEDURE update_Ant_Data_a_Term(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
44 p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
45 p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,
46 p_ant_data_column VARCHAR2,
47 p_ant_data_value VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 p_override_flag VARCHAR2
50 );
51
52 PROCEDURE raise_event_on_IA_submit(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
53 p_application_code igf_ap_appl_status_all.application_code%TYPE,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56
57 END igf_ap_inst_app;