APPS.IGF_AP_LI_AWARDS_PKG dependencies on IGF_AW_AWARD

Line 29: lv_award_id igf_aw_award.award_id%TYPE := NULL;

25: l_error VARCHAR2(80);
26: l_person_number VARCHAR2(80);
27: l_batch_id VARCHAR2(80);
28: lv_row_id VARCHAR2(80) := NULL;
29: lv_award_id igf_aw_award.award_id%TYPE := NULL;
30: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
31: lv_base_id igf_aw_award.base_id%TYPE := NULL;
32: l_del_message VARCHAR2(200);
33: l_batch_desc VARCHAR2(80);

Line 31: lv_base_id igf_aw_award.base_id%TYPE := NULL;

27: l_batch_id VARCHAR2(80);
28: lv_row_id VARCHAR2(80) := NULL;
29: lv_award_id igf_aw_award.award_id%TYPE := NULL;
30: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
31: lv_base_id igf_aw_award.base_id%TYPE := NULL;
32: l_del_message VARCHAR2(200);
33: l_batch_desc VARCHAR2(80);
34: l_yes_no VARCHAR2(10);
35: l_award_yr VARCHAR2(80);

Line 117: FROM igf_aw_award AW

113: cp_fund_id NUMBER)
114: IS
115: SELECT award_id,
116: AW.ROWID ROW_ID
117: FROM igf_aw_award AW
118: WHERE AW.base_id = cp_base_id
119: AND AW.fund_id = cp_fund_id;
120:
121: l_award_id c_award_exists%ROWTYPE;

Line 134: || veramach 1-NOV-2003 #3160568 Added adplans_id in the calls to igf_aw_award_pkg.insert_row and igf_aw_award_pkg.update_row

130: || Change History :
131: || Who When What
132: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
133: || bvisvana 11-Jul-2005 FA 157 and FA 140 - Added x_notification_status_code,x_notification_status_code,x_publish_in_ss_flag for TBH impact
134: || veramach 1-NOV-2003 #3160568 Added adplans_id in the calls to igf_aw_award_pkg.insert_row and igf_aw_award_pkg.update_row
135: || (reverse chronological order - newest change first)
136: */
137:
138: BEGIN

Line 300: igf_aw_award_pkg.insert_row(

296: l_error_flag := TRUE;
297: ELSE
298: -- THE RECORD HAS TO BE INSERTED IN THE AWARD TABLE AS THE AWARD DOES NOT EXIST
299: IF l_error_flag = FALSE THEN
300: igf_aw_award_pkg.insert_row(
301: x_mode => 'R',
302: x_award_id => lv_award_id,
303: x_fund_id => l_fund_id.fund_id,
304: x_base_id => lv_base_id,

Line 355: igf_aw_award_pkg.update_row(

351: ELSE -- This means that award id is not null
352: IF NVL(l_interface.import_record_type,'X') = 'U' THEN
353: --UPDATE THE AWARD RECORD AS THE RECORD ALREADY EXISTS AND THE UPDATE FLAG IS 'U'
354: IF l_error_flag = FALSE THEN
355: igf_aw_award_pkg.update_row(
356: x_mode => 'R',
357: x_award_id => l_award_id.award_id,
358: x_fund_id => l_fund_id.fund_id,
359: x_base_id => lv_base_id,

Line 410: fnd_message.set_name('IGF','IGF_AW_AWARD_EXISTS');

406: -- AS THE AWARD ALREADY EXISTS SO IT CAN NOT BE UPDATED
407: fnd_message.set_name('IGF','IGF_SE_FUND_CODE');
408: fnd_message.set_token('TOKEN',l_interface.fund_code);
409: l_message_str := RPAD(l_error,12) || fnd_message.get;
410: fnd_message.set_name('IGF','IGF_AW_AWARD_EXISTS');
411: g_log_tab_index := g_log_tab_index + 1;
412: g_log_tab(g_log_tab_index).person_number := l_interface.person_number;
413: g_log_tab(g_log_tab_index).message_text := l_message_str || ' ' || fnd_message.get;
414: l_error_flag := TRUE;