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_SL_CL_ORIG_ACK dependencies on IGF_AW_AWARD

Line 278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,

274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
279: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
280: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE
281: );
282:

Line 601: CURSOR c_igf_aw_award_v (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

597:
598: rec_c_igf_sl_lor c_igf_sl_lor%ROWTYPE;
599:
600: -- bug# 5045781
601: CURSOR c_igf_aw_award_v (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
602: SELECT fmast.ci_cal_type ci_cal_type,
603: fmast.ci_sequence_number ci_sequence_number,
604: ci.alternate_code ci_alternate_code,
605: ci.start_dt ci_start_dt,

Line 614: FROM igf_aw_award_all awd,

610: pe.party_number person_number,
611: pit.api_person_id ssn,
612: pe.person_last_name || ',' || pe.person_first_name full_name,
613: awd.accepted_amt accepted_amt
614: FROM igf_aw_award_all awd,
615: igf_aw_fund_mast_all fmast,
616: igf_aw_fund_cat_all fcat,
617: igs_ca_inst ci,
618: igf_ap_fa_base_rec facon,

Line 637: rec_c_igf_aw_award_v c_igf_aw_award_v%ROWTYPE;

633: AND fmast.fund_id = awd.fund_id
634: AND awd.award_id = cp_n_award_id;
635:
636:
637: rec_c_igf_aw_award_v c_igf_aw_award_v%ROWTYPE;
638:
639: l_v_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
640: e_skip EXCEPTION;
641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;

Line 643: l_n_award_id igf_aw_award_all.award_id%TYPE;

639: l_v_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
640: e_skip EXCEPTION;
641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;
642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;

Line 1074: OPEN c_igf_aw_award_v (cp_n_award_id => l_n_award_id);

1070: IF ( g_v_cl_version = 'RELEASE-4' AND lv_resp_rec_type IN ('B','G','D','P') ) OR --MN 11-Jan-2005 earlier it was with l_v_rec_type_ind
1071: ( g_v_cl_version = 'RELEASE-5' AND TRIM(SUBSTR(Format_1_rec.record_data,992,2)) IN ('40', '30', '25') )
1072: THEN
1073:
1074: OPEN c_igf_aw_award_v (cp_n_award_id => l_n_award_id);
1075: FETCH c_igf_aw_award_v INTO rec_c_igf_aw_award_v ;
1076: CLOSE c_igf_aw_award_v;
1077: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 1';
1078: l_n_resp_guarantee_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,688,5))));

Line 1075: FETCH c_igf_aw_award_v INTO rec_c_igf_aw_award_v ;

1071: ( g_v_cl_version = 'RELEASE-5' AND TRIM(SUBSTR(Format_1_rec.record_data,992,2)) IN ('40', '30', '25') )
1072: THEN
1073:
1074: OPEN c_igf_aw_award_v (cp_n_award_id => l_n_award_id);
1075: FETCH c_igf_aw_award_v INTO rec_c_igf_aw_award_v ;
1076: CLOSE c_igf_aw_award_v;
1077: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 1';
1078: l_n_resp_guarantee_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,688,5))));
1079: l_n_resp_fls_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,464,5))));

Line 1076: CLOSE c_igf_aw_award_v;

1072: THEN
1073:
1074: OPEN c_igf_aw_award_v (cp_n_award_id => l_n_award_id);
1075: FETCH c_igf_aw_award_v INTO rec_c_igf_aw_award_v ;
1076: CLOSE c_igf_aw_award_v;
1077: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 1';
1078: l_n_resp_guarantee_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,688,5))));
1079: l_n_resp_fls_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,464,5))));
1080: l_n_resp_flu_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,469,5))));

Line 1086: IF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLS' THEN

1082: l_n_resp_alt_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,488,5))));
1083: l_d_loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
1084: l_d_loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1085: --MN 11-Jan-2005 Get Actual Approved Amount based on fed und code and validate that against the Award Accepted Amount
1086: IF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLS' THEN
1087: l_n_resp_actual_approved_amt := l_n_resp_fls_approved_amt;
1088: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLU' THEN
1089: l_n_resp_actual_approved_amt := l_n_resp_flu_approved_amt;
1090: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') IN ('FLP','GPLUSFL') THEN

Line 1088: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLU' THEN

1084: l_d_loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1085: --MN 11-Jan-2005 Get Actual Approved Amount based on fed und code and validate that against the Award Accepted Amount
1086: IF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLS' THEN
1087: l_n_resp_actual_approved_amt := l_n_resp_fls_approved_amt;
1088: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLU' THEN
1089: l_n_resp_actual_approved_amt := l_n_resp_flu_approved_amt;
1090: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') IN ('FLP','GPLUSFL') THEN
1091: l_n_resp_actual_approved_amt := l_n_resp_flp_approved_amt;
1092: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'ALT' THEN

Line 1090: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') IN ('FLP','GPLUSFL') THEN

1086: IF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLS' THEN
1087: l_n_resp_actual_approved_amt := l_n_resp_fls_approved_amt;
1088: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLU' THEN
1089: l_n_resp_actual_approved_amt := l_n_resp_flu_approved_amt;
1090: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') IN ('FLP','GPLUSFL') THEN
1091: l_n_resp_actual_approved_amt := l_n_resp_flp_approved_amt;
1092: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'ALT' THEN
1093: l_n_resp_actual_approved_amt := l_n_resp_alt_approved_amt;
1094: END IF;

Line 1092: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'ALT' THEN

1088: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLU' THEN
1089: l_n_resp_actual_approved_amt := l_n_resp_flu_approved_amt;
1090: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') IN ('FLP','GPLUSFL') THEN
1091: l_n_resp_actual_approved_amt := l_n_resp_flp_approved_amt;
1092: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'ALT' THEN
1093: l_n_resp_actual_approved_amt := l_n_resp_alt_approved_amt;
1094: END IF;
1095:
1096: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 1098: '|Fed Fund Type - ' || NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') ||

1094: END IF;
1095:
1096: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1097: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.AmountComparison',
1098: '|Fed Fund Type - ' || NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') ||
1099: '|Guaranteed Amount - ' || l_n_resp_guarantee_amt ||
1100: '|Approved Amount - ' || l_n_resp_actual_approved_amt ||
1101: '|Accepted Amount - ' || rec_c_igf_aw_award_v.accepted_amt ||
1102: '|g_v_cl_version - ' || g_v_cl_version ||

Line 1101: '|Accepted Amount - ' || rec_c_igf_aw_award_v.accepted_amt ||

1097: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.AmountComparison',
1098: '|Fed Fund Type - ' || NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') ||
1099: '|Guaranteed Amount - ' || l_n_resp_guarantee_amt ||
1100: '|Approved Amount - ' || l_n_resp_actual_approved_amt ||
1101: '|Accepted Amount - ' || rec_c_igf_aw_award_v.accepted_amt ||
1102: '|g_v_cl_version - ' || g_v_cl_version ||
1103: '|l_v_rec_type_ind - ' || l_v_rec_type_ind);
1104: END IF;
1105: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 2';

Line 1106: IF NVL(l_n_resp_guarantee_amt,0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0) OR

1102: '|g_v_cl_version - ' || g_v_cl_version ||
1103: '|l_v_rec_type_ind - ' || l_v_rec_type_ind);
1104: END IF;
1105: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 2';
1106: IF NVL(l_n_resp_guarantee_amt,0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0) OR
1107: NVL(l_n_resp_actual_approved_amt, 0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0)
1108: THEN
1109: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 3';
1110: raise_gamt_event (

Line 1107: NVL(l_n_resp_actual_approved_amt, 0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0)

1103: '|l_v_rec_type_ind - ' || l_v_rec_type_ind);
1104: END IF;
1105: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 2';
1106: IF NVL(l_n_resp_guarantee_amt,0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0) OR
1107: NVL(l_n_resp_actual_approved_amt, 0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0)
1108: THEN
1109: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 3';
1110: raise_gamt_event (
1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,

Line 1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,

1107: NVL(l_n_resp_actual_approved_amt, 0) <> NVL(rec_c_igf_aw_award_v.accepted_amt,0)
1108: THEN
1109: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 3';
1110: raise_gamt_event (
1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,
1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,
1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,
1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,
1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,

Line 1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,

1108: THEN
1109: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 3';
1110: raise_gamt_event (
1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,
1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,
1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,
1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,
1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,
1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,

Line 1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,

1109: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - GaMt Diff 3';
1110: raise_gamt_event (
1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,
1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,
1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,
1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,
1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,
1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,
1117: p_v_loan_number => l_loan_number,

Line 1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,

1110: raise_gamt_event (
1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,
1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,
1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,
1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,
1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,
1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,
1117: p_v_loan_number => l_loan_number,
1118: p_d_loan_per_begin_date => l_d_loan_per_begin_date,

Line 1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,

1111: p_v_ci_alternate_code => rec_c_igf_aw_award_v.ci_alternate_code,
1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,
1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,
1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,
1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,
1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,
1117: p_v_loan_number => l_loan_number,
1118: p_d_loan_per_begin_date => l_d_loan_per_begin_date,
1119: p_d_loan_per_end_date => l_d_loan_per_end_date,

Line 1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,

1112: p_d_ci_start_dt => rec_c_igf_aw_award_v.ci_start_dt,
1113: p_d_ci_end_dt => rec_c_igf_aw_award_v.ci_end_dt,
1114: p_v_person_number => rec_c_igf_aw_award_v.person_number,
1115: p_v_person_name => rec_c_igf_aw_award_v.full_name,
1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,
1117: p_v_loan_number => l_loan_number,
1118: p_d_loan_per_begin_date => l_d_loan_per_begin_date,
1119: p_d_loan_per_end_date => l_d_loan_per_end_date,
1120: p_v_loan_type => rec_c_igf_aw_award_v.fed_fund_code,

Line 1120: p_v_loan_type => rec_c_igf_aw_award_v.fed_fund_code,

1116: p_v_ssn => rec_c_igf_aw_award_v.ssn,
1117: p_v_loan_number => l_loan_number,
1118: p_d_loan_per_begin_date => l_d_loan_per_begin_date,
1119: p_d_loan_per_end_date => l_d_loan_per_end_date,
1120: p_v_loan_type => rec_c_igf_aw_award_v.fed_fund_code,
1121: p_n_award_accept_amt => rec_c_igf_aw_award_v.accepted_amt,
1122: p_n_guarantee_amt => l_n_resp_guarantee_amt,
1123: p_n_approved_amt => l_n_resp_actual_approved_amt
1124: );

Line 1121: p_n_award_accept_amt => rec_c_igf_aw_award_v.accepted_amt,

1117: p_v_loan_number => l_loan_number,
1118: p_d_loan_per_begin_date => l_d_loan_per_begin_date,
1119: p_d_loan_per_end_date => l_d_loan_per_end_date,
1120: p_v_loan_type => rec_c_igf_aw_award_v.fed_fund_code,
1121: p_n_award_accept_amt => rec_c_igf_aw_award_v.accepted_amt,
1122: p_n_guarantee_amt => l_n_resp_guarantee_amt,
1123: p_n_approved_amt => l_n_resp_actual_approved_amt
1124: );
1125: END IF;

Line 3538: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,

3534: SELECT clrp8.* FROM igf_sl_cl_resp_r8 clrp8
3535: WHERE clrp1_id = loaded_1rec.clrp1_id
3536: AND resp_record_status = p_rec_status;
3537:
3538: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,
3539: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
3540: SELECT adisb.* FROM igf_aw_awd_disb adisb
3541: WHERE award_id = p_award_id AND disb_num = p_disb_num
3542: FOR UPDATE OF manual_hold_ind NOWAIT;

Line 3655: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,

3651: SELECT clrp8.* FROM igf_sl_cl_resp_r8 clrp8
3652: WHERE clrp1_id = loaded_1rec.clrp1_id
3653: AND resp_record_status = p_rec_status;
3654:
3655: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,
3656: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
3657: SELECT adisb.* FROM igf_aw_awd_disb adisb
3658: WHERE award_id = p_award_id AND disb_num = p_disb_num
3659: FOR UPDATE OF manual_hold_ind NOWAIT;

Line 6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,

6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
6373: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
6374: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE
6375: ) AS
6376: ------------------------------------------------------------------