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_MANAGE_AWD dependencies on IGF_AP_FA_BASE_REC

Line 10: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

6: --------------------------------------------------------------------------------
7:
8:
9: PROCEDURE process_award(p_award_id IN igf_aw_award.award_id%TYPE,
10: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
11: p_run_mode IN VARCHAR2,
12: p_awd_proc_status IN VARCHAR2
13: ) IS
14: ------------------------------------------------------------------

Line 36: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

32: --
33: -- This cursor is opened for udpating awards based on run mode
34: --
35: CURSOR c_awd_mode(c_award_id igf_aw_award.award_id%TYPE,
36: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
37: c_run_mode VARCHAR2
38: ) IS
39: SELECT
40: awd.ROWID row_id,awd.*,fmast.fund_code

Line 65: CURSOR c_awd(c_award_id igf_aw_award.award_id%TYPE,c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

61:
62: --
63: -- This cursor is opened for udpating awards
64: --
65: CURSOR c_awd(c_award_id igf_aw_award.award_id%TYPE,c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
66: SELECT
67: awd.ROWID row_id,awd.*,fmast.fund_code
68: FROM
69: igf_aw_award_all awd,

Line 240: PROCEDURE lock_unlock_stud(p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

236: END process_award;
237:
238:
239: --Procedure to Lock/Unlock Award at the Student Level
240: PROCEDURE lock_unlock_stud(p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
241: p_run_mode IN VARCHAR2
242: ) IS
243: ------------------------------------------------------------------
244: --Created by : ridas, Oracle India

Line 258: CURSOR cur_upd_base (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

254: -------------------------------------------------------------------
255:
256:
257: --This cursor is to fetch person details
258: CURSOR cur_upd_base (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
259: c_run_mode VARCHAR2) IS
260: SELECT fab.*
261: FROM igf_ap_fa_base_rec fab
262: WHERE fab.base_id = c_base_id

Line 261: FROM igf_ap_fa_base_rec fab

257: --This cursor is to fetch person details
258: CURSOR cur_upd_base (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
259: c_run_mode VARCHAR2) IS
260: SELECT fab.*
261: FROM igf_ap_fa_base_rec fab
262: WHERE fab.base_id = c_base_id
263: AND NVL(lock_awd_flag,'N') <> DECODE(c_run_mode,'L','Y','N')
264: FOR UPDATE OF lock_coa_flag NOWAIT;
265:

Line 297: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Updating igf_ap_fa_base_rec_all with lock='||lv_lock_award_flag);

293: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
294: END IF;
295:
296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
297: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Updating igf_ap_fa_base_rec_all with lock='||lv_lock_award_flag);
298: END IF;
299:
300: igf_ap_fa_base_rec_pkg.update_row
301: (x_Mode => 'R',

Line 300: igf_ap_fa_base_rec_pkg.update_row

296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
297: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Updating igf_ap_fa_base_rec_all with lock='||lv_lock_award_flag);
298: END IF;
299:
300: igf_ap_fa_base_rec_pkg.update_row
301: (x_Mode => 'R',
302: x_rowid => cur_fbr_rec.row_id,
303: x_base_id => cur_fbr_rec.base_id,
304: x_ci_cal_type => cur_fbr_rec.ci_cal_type,

Line 446: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

442: p_award_year IN VARCHAR2,
443: p_award_period IN igf_aw_award_prd.award_prd_cd%TYPE,
444: p_run_type IN VARCHAR2,
445: p_pid_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
446: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
447: p_run_mode IN VARCHAR2,
448: p_awd_proc_status IN VARCHAR2,
449: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE
450: ) IS

Line 478: person_id igf_ap_fa_base_rec_all.person_id%TYPE,

474: TYPE CpregrpCurTyp IS REF CURSOR ;
475: cur_per_grp CpregrpCurTyp ;
476:
477: TYPE CpergrpTyp IS RECORD(
478: person_id igf_ap_fa_base_rec_all.person_id%TYPE,
479: person_number igs_pe_person_base_v.person_number%TYPE
480: );
481: per_grp_rec CpergrpTyp ;
482:

Line 486: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

482:
483:
484: --Cursor below retrieves all the students belonging to a given AWARD YEAR
485: CURSOR c_per_awd_yr(
486: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
487: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
488: ) IS
489: SELECT fa.base_id
490: FROM igf_ap_fa_base_rec_all fa

Line 487: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

483:
484: --Cursor below retrieves all the students belonging to a given AWARD YEAR
485: CURSOR c_per_awd_yr(
486: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
487: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
488: ) IS
489: SELECT fa.base_id
490: FROM igf_ap_fa_base_rec_all fa
491: WHERE fa.ci_cal_type = c_ci_cal_type

Line 490: FROM igf_ap_fa_base_rec_all fa

486: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
487: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
488: ) IS
489: SELECT fa.base_id
490: FROM igf_ap_fa_base_rec_all fa
491: WHERE fa.ci_cal_type = c_ci_cal_type
492: AND fa.ci_sequence_number = c_ci_sequence_number
493: ORDER BY fa.base_id;
494:

Line 523: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,

519: CURSOR c_awards(
520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,
521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,
522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
523: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE ,
524: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
525: ) IS
526: SELECT awd.award_id
527: FROM igf_aw_award_all awd

Line 557: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

553:
554:
555: --Cursor to retrieve all awards for the award year
556: CURSOR c_award_yr(
557: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
558: c_fund_id igf_aw_fund_mast_all.fund_id%TYPE
559: ) IS
560: SELECT awd.award_id
561: FROM igf_aw_award_all awd

Line 569: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

565:
566: lv_run_type VARCHAR2(100);
567: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
568: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
569: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
570: lv_err_msg fnd_new_messages.message_name%TYPE;
571:
572:
573: BEGIN