[Home] [Help]
PACKAGE: APPS.IGF_AP_GEN
Source
1 PACKAGE igf_ap_gen AS
2 /* $Header: IGFAP36S.pls 120.2 2005/12/11 03:59:03 appldev ship $ */
3
4 /*=========================================================================
5 -- Copyright (c) 2003 Oracle Corp. Redwood Shores, California, USA
6 -- All rights reserved.
7 -- ========================================================================
8 --
9 -- DESCRIPTION
10 -- PL/SQL body for package: / IGF_AP_GEN
11 --
12 -- NOTES
13 -- Does all the generic functionalities required by legacy processes
14 ----------------------------------------------------------------------------------
15 -- HISTORY
16 ----------------------------------------------------------------------------------
17 -- who when what
18 -- bvisvana 09-Dec-2005 Bug # 4773795 Added procedure update_preflend_todo_status
19 -- veramach 11-Dec-2003 Bug# 3184891 Removed procedure write_log
20 -- brajendr 16-Oct-2003 Bug # 3085558, Added function get_isir_value
21 --
22 -- rasahoo 27-Nov-2003 Bug # 3026594 Added the fucntions get_cumulative_coa_amt
23 -- and get_individual_coa_amt
24 ----------------------------------------------------------------------------------*/
25
26 TYPE igf_ap_lookups_table IS TABLE OF VARCHAR2(227) INDEX BY BINARY_INTEGER;
27 TYPE igf_ap_lkup_hash_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
28 TYPE l_lookups_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
29 lookups_table DBMS_UTILITY.uncl_array;
30
31 l_lookups_rec l_lookups_table;
32 l_lookups_type_rec l_lookups_table;
33
34 lookup_hash_table igf_ap_lkup_hash_table;
35 indx NUMBER :=0;
36 g_request_id NUMBER := NULL;
37
38
39 FUNCTION get_lookup_meaning(
40 p_lookup_type IN VARCHAR2,
41 p_lookup_code IN VARCHAR2
42 ) RETURN VARCHAR2 ;
43
44 FUNCTION get_aw_lookup_meaning(
45 p_lookup_type IN VARCHAR2,
46 p_lookup_code IN VARCHAR2,
47 p_sys_award_year IN VARCHAR2
48 ) RETURN VARCHAR2 ;
49
50 FUNCTION check_profile RETURN VARCHAR2;
51
52 PROCEDURE check_person(
53 p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
54 p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
55 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
56 p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
57 p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
58 );
59
60
61 FUNCTION VALIDATE_CAL_INST(
62 p_cal_cat IN igs_ca_type.s_cal_cat%TYPE,
63 p_alt_code_one IN igs_ca_inst.alternate_code%TYPE,
64 p_alt_code_two IN igs_ca_inst.alternate_code%TYPE,
65 p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
66 p_sequence_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE
67 ) RETURN BOOLEAN;
68
69 FUNCTION check_batch(
70 p_batch_id IN NUMBER,
71 p_batch_type IN VARCHAR2
72 ) RETURN VARCHAR2;
73
74 FUNCTION get_isir_value(
75 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
76 p_sar_field_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE
77 ) RETURN VARCHAR2;
78
79 FUNCTION get_indv_efc_4_term(
80 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
81 p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
82 p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
83 p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
84 ) RETURN NUMBER;
85
86 FUNCTION get_individual_coa_amt(
87 p_ld_start_dt IN DATE,
88 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
89 ) RETURN NUMBER;
90
91 FUNCTION get_cumulative_coa_amt(
92 p_ld_start_dt IN DATE,
93 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
94 ) RETURN NUMBER;
95
96 PROCEDURE update_td_status(
97 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
98 p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,
99 p_status IN igf_ap_td_item_inst_all.status%TYPE,
100 p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
101 p_return_status OUT NOCOPY VARCHAR2
102 );
103
104 PROCEDURE update_preflend_todo_status ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
105 p_return_status OUT NOCOPY VARCHAR2
106 ) ;
107
108 END igf_ap_gen;