APPS.IGF_AW_MANAGE_AWD dependencies on IGF_AW_AWARD_ALL

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