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_COA_UPDATE dependencies on IGF_AW_COA_GEN

Line 188: p_base_details IN igf_aw_coa_gen.base_details,

184: -- This function check whether the student attributes are matching with the COA Rate Order or not
185: -- If matching it returns the new calculated amount
186: FUNCTION is_attrib_matching(
187: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
188: p_base_details IN igf_aw_coa_gen.base_details,
189: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
190: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
191: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
192: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));

331: ELSE
332:
333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:
339: l_counter := 2;

Line 344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));

340: END IF;
341:
342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:
348: l_counter := 2;

Line 353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));

349: END IF;
350:
351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:
357: l_counter := 2;

Line 362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));

358: END IF;
359:
360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:
366: l_counter := 2;

Line 371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));

367: END IF;
368:
369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:
375: l_counter := 2;

Line 380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));

376: END IF;
377:
378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:
384: l_counter := 2;

Line 389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));

385: END IF;
386:
387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: l_counter := 2;

Line 398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));

394: END IF;
395:
396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:
402: l_counter := 2;

Line 407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));

403: END IF;
404:
405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:
411: l_counter := 2;

Line 533: l_base_details igf_aw_coa_gen.base_details;

529: AND ROWNUM = 1;
530:
531: l_rate_ord_exists c_rate_ord_exists%ROWTYPE;
532:
533: l_base_details igf_aw_coa_gen.base_details;
534: ln_amount NUMBER;
535: ln_rate_order NUMBER;
536: lv_coa_itm_update VARCHAR2(1);
537: lv_award_proc_status igf_aw_award_all.awd_proc_status_code%TYPE;

Line 601: l_base_details := igf_aw_coa_gen.getBaseDetails(p_base_id,l_terms.ld_cal_type,l_terms.ld_sequence_number);

597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','Fetching student attributes for base_id:'||p_base_id);
599: END IF;
600:
601: l_base_details := igf_aw_coa_gen.getBaseDetails(p_base_id,l_terms.ld_cal_type,l_terms.ld_sequence_number);
602:
603: --Rate Order found against the student attributes
604: IF is_attrib_matching(p_base_id,
605: l_base_details,

Line 684: lv_award_proc_status := igf_aw_coa_gen.set_awd_proc_status(p_base_id);

680: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
681: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','lv_coa_itm_update = Y');
682: END IF;
683:
684: lv_award_proc_status := igf_aw_coa_gen.set_awd_proc_status(p_base_id);
685: END IF;
686:
687: EXCEPTION
688: WHEN E_SKIP_STUDENT THEN