[Home] [Help]
PACKAGE: APPS.IGF_AP_ISIR_GEN_PKG
Source
1 PACKAGE IGF_AP_ISIR_GEN_PKG AS
2 /* $Header: IGFAP47S.pls 120.0 2005/06/01 13:39:41 appldev noship $ */
3 ------------------------------------------------------------------
4 --Created by : ugummall, Oracle India
5 --Date created: 04-AUG-2004
6 --
7 --Purpose: Generic routines used in self-service pages and ISIR Import Process.
8 --
9 --
10 --Known limitations/enhancements and/or remarks:
11 --
12 --Change History:
13 --Who When What
14 --brajendr 02-Nov-2004 Bug 3031287 FA152 and FA137 COA Updates and Repackaging
15 -- Added procedure upd_ant_data_awd_prc_status for Updating Anticipated Data and Award Prcoess status
16 -------------------------------------------------------------------
17 PROCEDURE attach_isir( cp_si_id IN igf_ap_isir_ints_all.si_id%TYPE ,
18 cp_batch_year IN igf_ap_isir_ints_all.batch_year_num%TYPE,
19 cp_message_out OUT NOCOPY VARCHAR2);
20 FUNCTION can_unlock_isir (
21 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
22 p_user_id IN fnd_user.user_id%TYPE
23 ) RETURN VARCHAR2;
24
25
26 FUNCTION update_lock_status (
27 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
28 p_user_id IN fnd_user.user_id%TYPE DEFAULT NULL
29 ) RETURN VARCHAR2;
30
31
32 FUNCTION is_awards_exists(
33 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
34 ) RETURN VARCHAR2;
35
36 FUNCTION chk_pell_orig (
37 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38 p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
39 ) RETURN VARCHAR2;
40
41 FUNCTION make_awarding_isir (
42 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
43 p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
44 ) RETURN VARCHAR2;
45
46
47 FUNCTION are_corrections_exists (
48 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
49 ) RETURN VARCHAR2;
50
51 FUNCTION is_awarding_pymnt_isir_exists (
52 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
53 ) RETURN VARCHAR2;
54
55 PROCEDURE delete_isir_validations (
56 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
57 p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE delete_isir (
64 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
65 p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2
69 );
70
71
72 PROCEDURE delete_person_match ( p_si_id IN NUMBER);
73
74
75 PROCEDURE delete_interface_record(
76 p_si_id IN NUMBER,
77 lv_status OUT NOCOPY VARCHAR2
78 );
79
80 PROCEDURE delete_int_records ( p_si_ids VARCHAR2 );
81
82
83 PROCEDURE is_isir_exists(
84 p_si_id IN NUMBER,
85 p_batch_year IN NUMBER,
86 p_status OUT NOCOPY VARCHAR2
87 );
88
89 FUNCTION get_isir_message_class (
90 p_message_class IN igf_ap_isir_matched_all.message_class_txt%TYPE
91 ) RETURN VARCHAR2;
92
93 PROCEDURE upd_ant_data_awd_prc_status(
94 p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
95 p_new_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
96 p_upd_ant_val IN VARCHAR2,
97 p_anticip_status OUT NOCOPY VARCHAR2,
98 p_awd_prc_status OUT NOCOPY VARCHAR2
99 );
100
101 END igf_ap_isir_gen_pkg;