eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_RULE dependencies on IGF_AP_FA_BASE_REC

Line 11: -- igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126

7: -- svuppala 14-Oct-04 Bug # 3416936 Modified TBH call to addeded field
8: -- Eligible for Additional Unsubsidized Loans
9: -- ugummall 26-SEP-2003 FA 126 - Multiple FA Offices
10: -- added new parameter assoc_org_num to TBH call
11: -- igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126
12: --
13: --
14: -- Bug ID :2613546
15: -- adhawan 28-OCT-2002 The Run procedure has been modified with the new parameters

Line 35: -- | IGF_AP_FA_BASE_RECORD_PKG. |

31: -- adhawan
32: -- 2313791 22-apr-2002 Added messages when the Group or the Cost of Attendance is assigned to the Student
33: -- | gvarapra 14-sep-2004 FA138 - ISIR Enhancements |
34: -- | Changed arguments in call to |
35: -- | IGF_AP_FA_BASE_RECORD_PKG. |
36: ------------------------------------------------------------------------
37: --
38:
39:

Line 171: || igf_ap_fa_base_rec_pkg.update_row

167: || ridas 08-FEB-2006 Bug #5021084. Added new parameter 'lv_group_type' in
168: || call to igf_ap_ss_pkg.get_pid
169: || rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
170: || added new parameter award_fmly_contribution_type to
171: || igf_ap_fa_base_rec_pkg.update_row
172: || ugummall 26-SEP-2003 FA 126 - Multiple FA Offices
173: || added new parameter assoc_org_num to TBH call
174: || igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126
175: ||

Line 174: || igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126

170: || added new parameter award_fmly_contribution_type to
171: || igf_ap_fa_base_rec_pkg.update_row
172: || ugummall 26-SEP-2003 FA 126 - Multiple FA Offices
173: || added new parameter assoc_org_num to TBH call
174: || igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126
175: ||
176: || rasahoo 27-aug-2003 Removed the call to IGF_AP_OSS_PROCESS.GET_OSS_DETAILS
177: || as part of obsoletion of FA base record history
178: || masehgal 11-Nov-2002 FA 101 - SAP Obsoletion

Line 190: CURSOR c_year ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%type ,

186: WHERE cal_type = cp_ci_cal_type AND
187: sequence_NUMBER = cp_ci_sequence_NUMBER;
188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
189:
190: CURSOR c_year ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%type ,
191: x_ci_sequence_NUMBER igf_ap_fa_base_rec.ci_sequence_NUMBER%type )
192: IS
193: SELECT
194: fa.base_id ,

Line 191: x_ci_sequence_NUMBER igf_ap_fa_base_rec.ci_sequence_NUMBER%type )

187: sequence_NUMBER = cp_ci_sequence_NUMBER;
188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
189:
190: CURSOR c_year ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%type ,
191: x_ci_sequence_NUMBER igf_ap_fa_base_rec.ci_sequence_NUMBER%type )
192: IS
193: SELECT
194: fa.base_id ,
195: fa.person_id,

Line 198: igf_ap_fa_base_rec fa,

194: fa.base_id ,
195: fa.person_id,
196: hz.party_number
197: FROM
198: igf_ap_fa_base_rec fa,
199: hz_parties hz
200: WHERE
201: fa.ci_cal_type = x_ci_cal_type AND
202: fa.ci_sequence_NUMBER = x_ci_sequence_NUMBER AND

Line 222: CURSOR c_fabase ( x_base_id igf_ap_fa_base_rec.base_id%type )

218: group_cd = cp_group_cd;
219:
220: l_rule_cd c_rule_cd%rowtype ;
221:
222: CURSOR c_fabase ( x_base_id igf_ap_fa_base_rec.base_id%type )
223: IS
224: SELECT
225: fabase.*
226: FROM

Line 227: igf_ap_fa_base_rec fabase

223: IS
224: SELECT
225: fabase.*
226: FROM
227: igf_ap_fa_base_rec fabase
228: WHERE
229: fabase.base_id = x_base_id ;
230:
231: --Cursor below retrieves all the person belonging to a person id group

Line 245: CURSOR c_check_group(p_base_id igf_ap_fa_base_rec.base_id%type ) IS

241: TYPE CstudTyp IS RECORD ( party_id hz_parties.party_id%TYPE, party_number hz_parties.party_number%TYPE);
242: l_stud CstudTyp ;
243:
244:
245: CURSOR c_check_group(p_base_id igf_ap_fa_base_rec.base_id%type ) IS
246: SELECT target_group from igf_ap_fa_base_rec
247: WHERE base_id=p_base_id;
248: l_check_group c_check_group%ROWTYPE;
249:

Line 246: SELECT target_group from igf_ap_fa_base_rec

242: l_stud CstudTyp ;
243:
244:
245: CURSOR c_check_group(p_base_id igf_ap_fa_base_rec.base_id%type ) IS
246: SELECT target_group from igf_ap_fa_base_rec
247: WHERE base_id=p_base_id;
248: l_check_group c_check_group%ROWTYPE;
249:
250:

Line 254: l_curr_base_id igf_ap_fa_base_rec.base_id%type ;

250:
251: l_fabase c_fabase%rowtype ;
252:
253: l_stud_proc BOOLEAN ;
254: l_curr_base_id igf_ap_fa_base_rec.base_id%type ;
255:
256: ln_person_id igs_ad_ps_appl_inst.person_id%TYPE;
257: l_person_NUMBER igf_ap_fa_con_v.person_NUMBER%TYPE;
258:

Line 267: CURSOR c_get_base_id(lp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE, lp_ci_seq_num igf_ap_fa_base_rec.ci_sequence_number%TYPE, lp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS

263: WHERE group_id = lp_per_id;
264: lv_desc igs_pe_persid_group_all.description%TYPE;
265:
266: -- Get
267: CURSOR c_get_base_id(lp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE, lp_ci_seq_num igf_ap_fa_base_rec.ci_sequence_number%TYPE, lp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
268: SELECT fa.base_id
269: FROM igf_ap_fa_base_rec fa
270: WHERE fa.ci_cal_type = lp_ci_cal_type
271: AND fa.ci_sequence_number = lp_ci_seq_num

Line 269: FROM igf_ap_fa_base_rec fa

265:
266: -- Get
267: CURSOR c_get_base_id(lp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE, lp_ci_seq_num igf_ap_fa_base_rec.ci_sequence_number%TYPE, lp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
268: SELECT fa.base_id
269: FROM igf_ap_fa_base_rec fa
270: WHERE fa.ci_cal_type = lp_ci_cal_type
271: AND fa.ci_sequence_number = lp_ci_seq_num
272: AND fa.person_id = lp_person_id;
273: l_get_base_id c_get_base_id%ROWTYPE;

Line 393: igf_ap_fa_base_rec_pkg.update_row(

389: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
390: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
391:
392: IF NVL(l_fabase.lock_awd_flag,'N') = 'N' THEN
393: igf_ap_fa_base_rec_pkg.update_row(
394: x_rowid => l_fabase.row_id,
395: x_base_id => l_fabase.base_id,
396: x_ci_cal_type => l_fabase.ci_cal_type,
397: x_person_id => l_fabase.person_id,