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_AW_AWARD

Line 9: PROCEDURE process_award(p_award_id IN igf_aw_award.award_id%TYPE,

5: -- Who When What
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

Line 35: CURSOR c_awd_mode(c_award_id igf_aw_award.award_id%TYPE,

31:
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

Line 42: igf_aw_award_all awd,

38: ) IS
39: SELECT
40: awd.ROWID row_id,awd.*,fmast.fund_code
41: FROM
42: igf_aw_award_all awd,
43: igf_aw_fund_mast_all fmast
44: WHERE
45: awd.award_id = c_award_id AND
46: awd.base_id = c_base_id AND

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 69: igf_aw_award_all awd,

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,
70: igf_aw_fund_mast_all fmast
71: WHERE
72: awd.award_id = c_award_id AND
73: awd.base_id = c_base_id AND

Line 81: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;

77: awd.publish_in_ss_flag NOWAIT;
78:
79: lc_awd c_awd%ROWTYPE;
80:
81: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;
82: lv_publish_in_ss_flag igf_aw_award_all.publish_in_ss_flag%TYPE;
83: lv_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
84:
85: BEGIN

Line 82: lv_publish_in_ss_flag igf_aw_award_all.publish_in_ss_flag%TYPE;

78:
79: lc_awd c_awd%ROWTYPE;
80:
81: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;
82: lv_publish_in_ss_flag igf_aw_award_all.publish_in_ss_flag%TYPE;
83: lv_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
84:
85: BEGIN
86: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 83: lv_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;

79: lc_awd c_awd%ROWTYPE;
80:
81: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;
82: lv_publish_in_ss_flag igf_aw_award_all.publish_in_ss_flag%TYPE;
83: lv_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
84:
85: BEGIN
86: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
87: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Starting process_award with award_id:'||p_award_id);

Line 159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Updating igf_aw_award_all with lock='||lv_lock_award_flag||' and process_status='||lv_awd_proc_status_code);

155: lv_awd_proc_status_code := p_awd_proc_status;
156: END IF;
157:
158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Updating igf_aw_award_all with lock='||lv_lock_award_flag||' and process_status='||lv_awd_proc_status_code);
160: END IF;
161:
162: igf_aw_award_pkg.update_row (
163: x_mode => 'R',

Line 162: igf_aw_award_pkg.update_row (

158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Updating igf_aw_award_all with lock='||lv_lock_award_flag||' and process_status='||lv_awd_proc_status_code);
160: END IF;
161:
162: igf_aw_award_pkg.update_row (
163: x_mode => 'R',
164: x_rowid => lc_awd.ROW_ID,
165: x_award_id => lc_awd.AWARD_ID,
166: x_fund_id => lc_awd.FUND_ID,

Line 268: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;

264: FOR UPDATE OF lock_coa_flag NOWAIT;
265:
266: cur_fbr_rec cur_upd_base%ROWTYPE;
267:
268: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;
269:
270: BEGIN
271:
272: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 443: p_award_period IN igf_aw_award_prd.award_prd_cd%TYPE,

439: PROCEDURE run(
440: errbuf OUT NOCOPY VARCHAR2,
441: retcode OUT NOCOPY NUMBER,
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,

Line 520: c_ci_cal_type igf_aw_award_prd.ci_cal_type%TYPE,

516:
517:
518: --Cursor to filter out those awards that fall within the awarding period
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

Line 521: c_ci_sequence_number igf_aw_award_prd.ci_sequence_number%TYPE,

517:
518: --Cursor to filter out those awards that fall within the awarding period
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

Line 522: c_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,

518: --Cursor to filter out those awards that fall within the awarding period
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

Line 527: FROM igf_aw_award_all awd

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
528: WHERE awd.base_id = c_base_id AND
529: awd.fund_id = NVL(c_fund_id, awd.fund_id) AND
530: NOT EXISTS
531: (SELECT disb.ld_cal_type,

Line 561: FROM igf_aw_award_all awd

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
562: WHERE awd.base_id = c_base_id AND
563: awd.fund_id = NVL(c_fund_id, awd.fund_id);
564:
565: