[Home] [Help]
PACKAGE: APPS.IGF_AW_GEN_004
Source
1 PACKAGE igf_aw_gen_004 AS
2 /* $Header: IGFAW13S.pls 120.2 2006/05/29 07:41:12 bvisvana noship $ */
3 /*************************************************************
4 Change History
5 Who When What
6 mnade 6/6/2005 FA 157 - 4382371 - Changes in award notification letter.
7 Also added get_base_id_for_person function.
8 veramach Oct 2004 FA 152/FA 137 - Changes to wrappers to
9 bring in the awarding period setup
10 veramach 06-OCT-2003 FA 124
11 Added functions efc_i,is_inas_integrated,unmetneed_i,need_i
12 ***************************************************************/
13
14
15 PROCEDURE corp_pre_process (
16 p_document_id IN NUMBER DEFAULT NULL,
17 p_select_type IN VARCHAR2 DEFAULT NULL,
18 p_sys_ltr_code IN VARCHAR2 DEFAULT NULL,
19 p_person_id IN NUMBER DEFAULT NULL,
20 p_list_id IN NUMBER DEFAULT NULL,
21 p_letter_type IN VARCHAR2 DEFAULT NULL,
22 p_parameter_1 IN VARCHAR2 DEFAULT NULL,
23 p_parameter_2 IN VARCHAR2 DEFAULT NULL,
24 p_parameter_3 IN VARCHAR2 DEFAULT NULL,
25 p_parameter_4 IN VARCHAR2 DEFAULT NULL,
26 p_parameter_5 IN VARCHAR2 DEFAULT NULL,
27 p_parameter_6 IN VARCHAR2 DEFAULT NULL,
28 p_parameter_7 IN VARCHAR2 DEFAULT NULL,
29 p_parameter_8 IN VARCHAR2 DEFAULT NULL,
30 p_parameter_9 IN VARCHAR2 DEFAULT NULL,
31 p_flag IN VARCHAR2 DEFAULT NULL,
32 p_sql_stmt OUT NOCOPY VARCHAR2,
33 p_exception OUT NOCOPY VARCHAR2
34 );
35
36 FUNCTION efc_i(
37 l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
39 ) RETURN NUMBER;
40
41 FUNCTION get_award_data (
42 p_person_id IN NUMBER,
43 p_fund_id IN VARCHAR2,
44 p_param1 IN VARCHAR2,
45 p_param2 IN VARCHAR2 DEFAULT NULL,
46 p_param3 IN VARCHAR2 DEFAULT NULL,
47 p_param4 IN VARCHAR2 DEFAULT NULL,
48 p_param5 IN VARCHAR2 DEFAULT NULL,
49 p_param6 IN VARCHAR2 DEFAULT NULL,
50 p_param7 IN VARCHAR2 DEFAULT NULL,
51 p_flag IN VARCHAR2 DEFAULT NULL
52 ) RETURN VARCHAR2;
53
54 FUNCTION get_headings (
55 p_person_id IN NUMBER,
56 p_param1 IN VARCHAR2,
57 p_param2 IN VARCHAR2 DEFAULT NULL,
58 p_param3 IN VARCHAR2 DEFAULT NULL,
59 p_param4 IN VARCHAR2 DEFAULT NULL,
60 p_param5 IN VARCHAR2 DEFAULT NULL,
61 p_param6 IN VARCHAR2 DEFAULT NULL,
62 p_param7 IN VARCHAR2 DEFAULT NULL,
63 p_flag IN VARCHAR2 DEFAULT NULL
64 )
65 RETURN VARCHAR2;
66
67 FUNCTION get_term_total (
68 p_person_id IN NUMBER,
69 p_param1 IN VARCHAR2,
70 p_param2 IN VARCHAR2 DEFAULT NULL,
71 p_param3 IN VARCHAR2 DEFAULT NULL,
72 p_param4 IN VARCHAR2 DEFAULT NULL,
73 p_param5 IN VARCHAR2 DEFAULT NULL,
74 p_param6 IN VARCHAR2 DEFAULT NULL,
75 p_param7 IN VARCHAR2 DEFAULT NULL,
76 p_flag IN VARCHAR2 DEFAULT NULL
77 )
78 RETURN VARCHAR2;
79
80 FUNCTION is_inas_integrated RETURN BOOLEAN;
81
82 PROCEDURE loan_disbursement_update (
83 p_person_id IN NUMBER,
84 p_award_year IN VARCHAR2
85 );
86
87 PROCEDURE missing_items_update (
88 p_person_id IN NUMBER,
89 p_award_year IN VARCHAR2
90 );
91
92 PROCEDURE award_letter_update (
93 p_person_id IN NUMBER,
94 p_award_year IN VARCHAR2,
95 p_award_prd_cd IN VARCHAR
96 );
97
98
99 FUNCTION get_award_desc(
100 p_person_id IN NUMBER,
101 p_cal_type IN VARCHAR2,
102 p_sequence_number IN NUMBER
103 ) RETURN VARCHAR2;
104
105 PRAGMA RESTRICT_REFERENCES(get_award_desc,WNDS,WNPS);
106 FUNCTION get_corr_cust_text(
107 p_person_id IN number
108 )
109 RETURN varchar2;
110 PRAGMA RESTRICT_REFERENCES(get_corr_cust_text,WNDS,WNPS);
111
112 FUNCTION efc_f(
113 l_base_id IN NUMBER,
114 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
115 ) RETURN NUMBER;
116
117 FUNCTION unmetneed_f(
118 l_base_id IN NUMBER,
119 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
120 ) RETURN NUMBER;
121
122 FUNCTION unmetneed_i(
123 l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
124 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
125 ) RETURN NUMBER;
126
127 FUNCTION need_f(
128 l_base_id IN NUMBER,
129 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
130 ) RETURN NUMBER;
131
132 FUNCTION need_i(
133 l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
134 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
135 ) RETURN NUMBER;
136
137 FUNCTION get_base_id_for_person (
138 p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
139 p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
140 p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
141 ) RETURN NUMBER ;
142
143 -- bvisvana - bug 3724328 - For Code refactoring (Issue with huge person id groups)
144 TYPE person_id_array IS TABLE OF VARCHAR2(30);
145 FUNCTION get_person_id RETURN person_id_array PIPELINED;
146
147
148 END igf_aw_gen_004;