[Home] [Help]
PACKAGE: APPS.IGF_AP_SS_PKG
Source
1 PACKAGE IGF_AP_SS_PKG AS
2 /* $Header: IGFAP30S.pls 120.2 2006/02/08 23:08:44 ridas ship $ */
3
4
5 PROCEDURE set_internal_isir(
6 p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,
7 p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE
8 );
9
10 FUNCTION get_pid(
11 p_pid_grp IN igs_pe_persid_group.group_id%TYPE,
12 p_status OUT NOCOPY VARCHAR2,
13 p_group_type OUT NOCOPY igs_pe_persid_group_v.group_type%TYPE
14 ) RETURN VARCHAR2;
15
16 PROCEDURE save_as_correction_isir(
17 p_org_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
18 p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
19 p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
20 p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
21 p_corr_status IN VARCHAR2 DEFAULT 'READY',
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 x_return_status OUT NOCOPY VARCHAR2,
25 p_msg_name OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE create_simulation_isir(
29 p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_return_status OUT NOCOPY VARCHAR2
33 );
34
35
36 PROCEDURE compute_efc(
37 p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
38 p_system_award_year IN VARCHAR2,
39 p_ignore_warnings IN VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE get_dynamic_dates(
46 p_sys_award_year IN VARCHAR2,
47 p_current_year OUT NOCOPY VARCHAR2,
48 p_next_year OUT NOCOPY VARCHAR2,
49 p_award_year OUT NOCOPY VARCHAR2,
50 p_legal_res_dt OUT NOCOPY VARCHAR2,
51 p_first_bachlor OUT NOCOPY VARCHAR2,
52 p_born_before OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE get_internal_isir_id (
56 p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,
57 p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE
58 );
59
60 PROCEDURE insert_into_todo(
61 p_base_id NUMBER,
62 p_seq_num NUMBER,
63 p_status VARCHAR2,
64 p_req_for_app VARCHAR2,
65 p_freq_attempt NUMBER,
66 p_max_attempt NUMBER
67 );
68
69 END IGF_AP_SS_PKG;