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_SL_CL_RESP_R8

Line 563: the tables IGF_SL_CL_RESP_R1 and IGF_SL_CL_RESP_R8

559: Created By : mesriniv
560: Date Created By : 2000/12/07
561: Purpose : To Call Respective procedures which
562: will insert the format file(@1 and @8) data into
563: the tables IGF_SL_CL_RESP_R1 and IGF_SL_CL_RESP_R8
564: tables correspondingly.
565: Known Limitations,Enhancements or Remarks
566: Change History :
567: Who When What

Line 1165: and IGF_SL_CL_RESP_R8 tables

1161: /***************************************************************
1162: Created By : mesriniv
1163: Date Created By : 2000/12/07
1164: Purpose : To Insert File data into IGF_SL_CL_RESP_R1
1165: and IGF_SL_CL_RESP_R8 tables
1166: Known Limitations,Enhancements or Remarks
1167: Change History :
1168: Who When What
1169: masehgal 17-Feb-2002 # 2216956 FACR007

Line 1190: clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,

1186: WHERE file_type = p_file_type
1187: AND lort_id > Format_1_rec.lort_id;
1188:
1189: TYPE r8_rec_type IS RECORD (
1190: clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,
1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,

Line 1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,

1187: AND lort_id > Format_1_rec.lort_id;
1188:
1189: TYPE r8_rec_type IS RECORD (
1190: clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,
1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,

Line 1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,

1188:
1189: TYPE r8_rec_type IS RECORD (
1190: clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,
1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,

Line 1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,

1189: TYPE r8_rec_type IS RECORD (
1190: clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,
1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,

Line 1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,

1190: clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,
1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,

Line 1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,

1191: disb_date igf_sl_cl_resp_r8_all.disb_date%TYPE,
1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,

Line 1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,

1192: disb_gross_amt igf_sl_cl_resp_r8_all.disb_gross_amt%TYPE,
1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,

Line 1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,

1193: orig_fee igf_sl_cl_resp_r8_all.orig_fee%TYPE,
1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,

Line 1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,

1194: guarantee_fee igf_sl_cl_resp_r8_all.guarantee_fee%TYPE,
1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,

Line 1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,

1195: net_disb_amt igf_sl_cl_resp_r8_all.net_disb_amt%TYPE,
1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,
1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD

Line 1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,

1196: disb_hold_rel_ind igf_sl_cl_resp_r8_all.disb_hold_rel_ind%TYPE,
1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,
1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD
1204: direct_to_borr_flag igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE --temporarily stubbed out

Line 1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,

1197: disb_status igf_sl_cl_resp_r8_all.disb_status%TYPE,
1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,
1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD
1204: direct_to_borr_flag igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE --temporarily stubbed out
1205: );

Line 1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,

1198: guarnt_fee_paid igf_sl_cl_resp_r8_all.guarnt_fee_paid%TYPE,
1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,
1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD
1204: direct_to_borr_flag igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE --temporarily stubbed out
1205: );
1206:

Line 1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD

1199: orig_fee_paid igf_sl_cl_resp_r8_all.orig_fee_paid%TYPE,
1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,
1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD
1204: direct_to_borr_flag igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE --temporarily stubbed out
1205: );
1206:
1207: r8_rec r8_rec_type;

Line 1204: direct_to_borr_flag igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE --temporarily stubbed out

1200: layout_owner_code_txt igf_sl_cl_resp_r8_all.layout_owner_code_txt%TYPE,
1201: layout_version_code_txt igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE,
1202: record_code_txt igf_sl_cl_resp_r8_all.record_code_txt%TYPE,
1203: -- direct_to_borr_flag igf_sl_cl_resp_r8_all.direct_to_borr_flag%TYPE --akomurav changes according to FA163 TD
1204: direct_to_borr_flag igf_sl_cl_resp_r8_all.layout_version_code_txt%TYPE --temporarily stubbed out
1205: );
1206:
1207: r8_rec r8_rec_type;
1208:

Line 1770: igf_sl_cl_resp_r8_pkg.insert_row (

1766: FOR i IN 1..l_ind-1 LOOP
1767:
1768: l_row_id := NULL;
1769: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 13' || ' ';
1770: igf_sl_cl_resp_r8_pkg.insert_row (
1771: x_mode => 'R',
1772: x_rowid => l_row_id,
1773: x_clrp1_id => l_clrp1_id,
1774: x_clrp8_id => i,

Line 3335: CURSOR cur_count_new_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)

3331: WHERE NVL(external_loan_id_txt,loan_number) = p_loan_number)
3332: GROUP BY award_id;
3333:
3334: --Count the No.of Disbursements for the award id in Response8 Disbursements Table
3335: CURSOR cur_count_new_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3336: IS
3337: SELECT NVL(COUNT(resp8.clrp8_id),0) FROM igf_sl_cl_resp_r8_all resp8
3338: WHERE clrp1_id = loaded_1rec.clrp1_id
3339: AND resp8.resp_record_status = p_rec_status;

Line 3337: SELECT NVL(COUNT(resp8.clrp8_id),0) FROM igf_sl_cl_resp_r8_all resp8

3333:
3334: --Count the No.of Disbursements for the award id in Response8 Disbursements Table
3335: CURSOR cur_count_new_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3336: IS
3337: SELECT NVL(COUNT(resp8.clrp8_id),0) FROM igf_sl_cl_resp_r8_all resp8
3338: WHERE clrp1_id = loaded_1rec.clrp1_id
3339: AND resp8.resp_record_status = p_rec_status;
3340:
3341: -- Check if the Disb-Num and Disb_gross_amts are same between the File and

Line 3349: SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8

3345: ((
3346: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
3347: WHERE award_id = l_award_id
3348: MINUS
3349: SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8
3350: WHERE clrp1_id = loaded_1rec.clrp1_id
3351: )
3352: UNION ALL
3353: (SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8

Line 3353: (SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8

3349: SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8
3350: WHERE clrp1_id = loaded_1rec.clrp1_id
3351: )
3352: UNION ALL
3353: (SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8
3354: WHERE clrp1_id = loaded_1rec.clrp1_id
3355: MINUS
3356: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
3357: WHERE award_id = l_award_id

Line 3362: CURSOR cur_new_disbursements(p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)

3358: )
3359: );
3360:
3361: --select the NewDisbursements for the award id in Response8 Disbursements Table
3362: CURSOR cur_new_disbursements(p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3363: IS
3364: SELECT * FROM igf_sl_cl_resp_r8
3365: WHERE clrp1_id = loaded_1rec.clrp1_id
3366: AND resp_record_status = p_rec_status

Line 3364: SELECT * FROM igf_sl_cl_resp_r8

3360:
3361: --select the NewDisbursements for the award id in Response8 Disbursements Table
3362: CURSOR cur_new_disbursements(p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3363: IS
3364: SELECT * FROM igf_sl_cl_resp_r8
3365: WHERE clrp1_id = loaded_1rec.clrp1_id
3366: AND resp_record_status = p_rec_status
3367: ORDER By clrp8_id;
3368:

Line 3379: PROCEDURE update_resp8_rec_status(p_clrp1_id igf_sl_cl_resp_r8_all.clrp1_id%TYPE,

3375:
3376:
3377: --To update the Resp8 Records with Y as Record Status
3378:
3379: PROCEDURE update_resp8_rec_status(p_clrp1_id igf_sl_cl_resp_r8_all.clrp1_id%TYPE,
3380: p_clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
3381: p_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3382: AS
3383: /***************************************************************

Line 3380: p_clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,

3376:
3377: --To update the Resp8 Records with Y as Record Status
3378:
3379: PROCEDURE update_resp8_rec_status(p_clrp1_id igf_sl_cl_resp_r8_all.clrp1_id%TYPE,
3380: p_clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
3381: p_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3382: AS
3383: /***************************************************************
3384: Created By : mesriniv

Line 3381: p_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)

3377: --To update the Resp8 Records with Y as Record Status
3378:
3379: PROCEDURE update_resp8_rec_status(p_clrp1_id igf_sl_cl_resp_r8_all.clrp1_id%TYPE,
3380: p_clrp8_id igf_sl_cl_resp_r8_all.clrp8_id%TYPE,
3381: p_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3382: AS
3383: /***************************************************************
3384: Created By : mesriniv
3385: Date Created By : 2000/12/07

Line 3400: FROM igf_sl_cl_resp_r8

3396: --Select Response8 Records for Updation
3397: CURSOR cur_resp_r8
3398: IS
3399: SELECT *
3400: FROM igf_sl_cl_resp_r8
3401: WHERE clrp1_id = p_clrp1_id
3402: AND clrp8_id = NVL(p_clrp8_id, clrp8_id)
3403: AND resp_record_status = 'N';
3404: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;

Line 3404: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;

3400: FROM igf_sl_cl_resp_r8
3401: WHERE clrp1_id = p_clrp1_id
3402: AND clrp8_id = NVL(p_clrp8_id, clrp8_id)
3403: AND resp_record_status = 'N';
3404: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;
3405: BEGIN
3406:
3407: l_resp_record_status := p_resp_record_status;
3408: gv_debug_str := 'UPDATE_RESP8_REC_STATUS-1' || ' targetStatus - '|| l_resp_record_status || ' ';

Line 3414: igf_sl_cl_resp_r8_pkg.update_row (

3410: FOR resp_r8_rec in cur_resp_r8 LOOP
3411:
3412: gv_debug_str := gv_debug_str || 'UPDATE_RESP8_REC_STATUS-2' || ' ';
3413:
3414: igf_sl_cl_resp_r8_pkg.update_row (
3415: X_Mode => 'R',
3416: x_rowid => resp_r8_rec.row_id,
3417: x_clrp1_id => resp_r8_rec.clrp1_id,
3418: x_clrp8_id => resp_r8_rec.clrp8_id,

Line 3532: CURSOR cur_loc_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)

3528: bvisvana 05-Sept-2005 Bug # 4149649 - Shows disb details only for those with differences
3529: ***************************************************************/
3530: PROCEDURE show_differing_disb_details
3531: AS
3532: CURSOR cur_loc_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3533: IS
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;

Line 3534: SELECT clrp8.* FROM igf_sl_cl_resp_r8 clrp8

3530: PROCEDURE show_differing_disb_details
3531: AS
3532: CURSOR cur_loc_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3533: IS
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,

Line 3543: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%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;
3543: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;
3544:
3545: l_disb_title VARCHAR2(1000);
3546: l_disb_under_line VARCHAR2(1000);
3547: counter NUMBER;

Line 3649: CURSOR cur_loc_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)

3645: bvisvana 12-Sept-2005 Bug # 4575843
3646: Update the disb_accepted amt with the disb_gross_amt from response
3647: ***************************************************************/
3648: AS
3649: CURSOR cur_loc_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3650: IS
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;

Line 3651: SELECT clrp8.* FROM igf_sl_cl_resp_r8 clrp8

3647: ***************************************************************/
3648: AS
3649: CURSOR cur_loc_disb (p_rec_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE)
3650: IS
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,

Line 3660: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%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;
3660: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;
3661: BEGIN
3662:
3663: FOR loc_disb in cur_loc_disb('N') LOOP -- LOC Loop
3664: