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_GR_RFMS_DISB_ORIG dependencies on IGF_GR_RFMS

Line 1: PACKAGE BODY igf_gr_rfms_disb_orig AS

1: PACKAGE BODY igf_gr_rfms_disb_orig AS
2: /* $Header: IGFGR03B.pls 120.4 2006/02/08 23:46:42 ridas ship $ */
3:
4: ------------------------------------------------------------------------
5: -- bvisvana 07-July-2005 Bug # 4008991 - IGF_GR_BATCH_DOES_NOT_EXIST replaced by IGF_SL_GR_BATCH_DOES_NO_EXIST

Line 84: l_base_id igf_gr_rfms.base_id%TYPE,

80: -- for preparing Origination File
81:
82: -- FA 126. This cursor cur_rfms_disb is modified to include reporting and attending pell ids.
83: CURSOR cur_rfms_disb(
84: l_base_id igf_gr_rfms.base_id%TYPE,
85: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
86: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
87: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
88: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE

Line 85: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,

81:
82: -- FA 126. This cursor cur_rfms_disb is modified to include reporting and attending pell ids.
83: CURSOR cur_rfms_disb(
84: l_base_id igf_gr_rfms.base_id%TYPE,
85: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
86: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
87: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
88: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
89: ) IS

Line 86: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,

82: -- FA 126. This cursor cur_rfms_disb is modified to include reporting and attending pell ids.
83: CURSOR cur_rfms_disb(
84: l_base_id igf_gr_rfms.base_id%TYPE,
85: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
86: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
87: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
88: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
89: ) IS
90: SELECT rfmd.*,

Line 87: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,

83: CURSOR cur_rfms_disb(
84: l_base_id igf_gr_rfms.base_id%TYPE,
85: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
86: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
87: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
88: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
89: ) IS
90: SELECT rfmd.*,
91: rfms.inst_cross_ref_cd,

Line 88: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE

84: l_base_id igf_gr_rfms.base_id%TYPE,
85: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
86: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
87: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
88: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
89: ) IS
90: SELECT rfmd.*,
91: rfms.inst_cross_ref_cd,
92: rfms.base_id,

Line 100: FROM igf_gr_rfms rfms ,

96: rfms.ci_sequence_number,
97: rfms.rep_pell_id,
98: rfms.attending_campus_id,
99: rfms.pell_amount
100: FROM igf_gr_rfms rfms ,
101: igf_gr_rfms_disb rfmd,
102: igf_gr_pell_setup setup
103: WHERE rfms.base_id = NVL(l_base_id,rfms.base_id)
104: AND rfms.ci_cal_type = l_ci_cal_type

Line 101: igf_gr_rfms_disb rfmd,

97: rfms.rep_pell_id,
98: rfms.attending_campus_id,
99: rfms.pell_amount
100: FROM igf_gr_rfms rfms ,
101: igf_gr_rfms_disb rfmd,
102: igf_gr_pell_setup setup
103: WHERE rfms.base_id = NVL(l_base_id,rfms.base_id)
104: AND rfms.ci_cal_type = l_ci_cal_type
105: AND rfms.ci_sequence_number = l_ci_sequence_number

Line 132: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE) IS

128: FOR UPDATE OF disb_ack_act_status NOWAIT;
129: rec_rfms_disb cur_rfms_disb%ROWTYPE;
130:
131: PROCEDURE upd_rfms_disb(p_rec_disb_orig cur_rfms_disb%ROWTYPE,
132: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE) IS
133:
134: ------------------------------------------------------------------------------
135: --
136: -- Created By : sjadhav

Line 154: igf_gr_rfms_disb_pkg.update_row (

150: ------------------------------------------------------------------------------
151:
152: BEGIN
153:
154: igf_gr_rfms_disb_pkg.update_row (
155: x_rowid => p_rec_disb_orig.row_id,
156: x_rfmd_id => p_rec_disb_orig.rfmd_id ,
157: x_origination_id => p_rec_disb_orig.origination_id,
158: x_disb_ref_num => p_rec_disb_orig.disb_ref_num,

Line 179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');

175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END upd_rfms_disb;
183:

Line 188: p_rfmb_id IN igf_gr_rfms_batch.rfmb_id%TYPE)

184:
185: PROCEDURE prepare_data
186: ( p_rfms_rec IN cur_rfms_disb%ROWTYPE,
187: p_num_of_records IN OUT NOCOPY NUMBER,
188: p_rfmb_id IN igf_gr_rfms_batch.rfmb_id%TYPE)
189: IS
190: ------------------------------------------------------------------------------
191: --
192: -- Created By : sjadhav

Line 306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');

302: RAISE;
303:
304: WHEN OTHERS THEN
305: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309:
310: END prepare_data;

Line 314: p_origination_id igf_gr_rfms.origination_id%TYPE ) IS

310: END prepare_data;
311:
312: PROCEDURE log_message
313: (p_batch_id VARCHAR2,
314: p_origination_id igf_gr_rfms.origination_id%TYPE ) IS
315:
316: ------------------------------------------------------------------------------
317: --
318: -- Created By : sjadhav

Line 352: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');

348:
349: EXCEPTION
350: WHEN others THEN
351: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
352: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END log_message;
356:

Line 357: PROCEDURE out_message( p_origination_id igf_gr_rfms_disb.origination_id%TYPE,

353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END log_message;
356:
357: PROCEDURE out_message( p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
358: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
359: IS
360: ------------------------------------------------------------------------------
361: --

Line 358: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)

354: app_exception.raise_exception;
355: END log_message;
356:
357: PROCEDURE out_message( p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
358: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
359: IS
360: ------------------------------------------------------------------------------
361: --
362: -- Created By : sjadhav

Line 400: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');

396:
397: EXCEPTION
398: WHEN others THEN
399: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
400: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: END out_message;
404:

Line 406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,

402: app_exception.raise_exception;
403: END out_message;
404:
405:
406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,
408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)
409: IS
410: ------------------------------------------------------------------------------

Line 407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,

403: END out_message;
404:
405:
406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,
408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)
409: IS
410: ------------------------------------------------------------------------------
411: --

Line 408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)

404:
405:
406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,
408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)
409: IS
410: ------------------------------------------------------------------------------
411: --
412: -- Created By : sjadhav

Line 430: CURSOR cur_err_desc(l_err_cd igf_gr_rfms_error.edit_code%TYPE) IS

426: l_msg_str_1 VARCHAR2(1000) DEFAULT NULL;
427: l_msg_str_2 VARCHAR2(1000) DEFAULT NULL;
428: l_msg_str_3 VARCHAR2(1000) DEFAULT NULL;
429:
430: CURSOR cur_err_desc(l_err_cd igf_gr_rfms_error.edit_code%TYPE) IS
431: SELECT
432: igf_gr_rfms_error.message
433: FROM igf_gr_rfms_error
434: WHERE

Line 432: igf_gr_rfms_error.message

428: l_msg_str_3 VARCHAR2(1000) DEFAULT NULL;
429:
430: CURSOR cur_err_desc(l_err_cd igf_gr_rfms_error.edit_code%TYPE) IS
431: SELECT
432: igf_gr_rfms_error.message
433: FROM igf_gr_rfms_error
434: WHERE
435: igf_gr_rfms_error.edit_code = l_err_cd;
436:

Line 433: FROM igf_gr_rfms_error

429:
430: CURSOR cur_err_desc(l_err_cd igf_gr_rfms_error.edit_code%TYPE) IS
431: SELECT
432: igf_gr_rfms_error.message
433: FROM igf_gr_rfms_error
434: WHERE
435: igf_gr_rfms_error.edit_code = l_err_cd;
436:
437: l_count NUMBER DEFAULT 1;

Line 435: igf_gr_rfms_error.edit_code = l_err_cd;

431: SELECT
432: igf_gr_rfms_error.message
433: FROM igf_gr_rfms_error
434: WHERE
435: igf_gr_rfms_error.edit_code = l_err_cd;
436:
437: l_count NUMBER DEFAULT 1;
438: l_error_code igf_gr_rfms_error.edit_code%TYPE;
439: l_msg_desc VARCHAR2(4000) DEFAULT NULL;

Line 438: l_error_code igf_gr_rfms_error.edit_code%TYPE;

434: WHERE
435: igf_gr_rfms_error.edit_code = l_err_cd;
436:
437: l_count NUMBER DEFAULT 1;
438: l_error_code igf_gr_rfms_error.edit_code%TYPE;
439: l_msg_desc VARCHAR2(4000) DEFAULT NULL;
440:
441: BEGIN
442:

Line 484: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');

480: EXCEPTION
481:
482: WHEN others THEN
483: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
484: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
485: igs_ge_msg_stack.add;
486: app_exception.raise_exception;
487:
488: END log_rej_message;

Line 503: -- Purpose : This procedure reads the data from igf_gr_rfms table

499: --
500: -- Created By : sjadhav
501: --
502: -- Date Created On : 2001/01/03
503: -- Purpose : This procedure reads the data from igf_gr_rfms table
504: -- for the paricular award year and base id and loads the data
505: -- into a datafile after formatting
506: --
507: -- Know limitations, enhancements or remarks

Line 539: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

535: l_trailer VARCHAR2(1000);
536: l_num_of_rec NUMBER DEFAULT 0;
537: l_amount_total NUMBER DEFAULT 0;
538:
539: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;
540: l_batch_id VARCHAR2(60);
541: l_running_orig_id VARCHAR2(30);
542: l_last_disb_rec VARCHAR2(1);
543: l_valid_rec BOOLEAN;

Line 547: l_base_id igf_gr_rfms.base_id%TYPE

543: l_valid_rec BOOLEAN;
544: I NUMBER;
545:
546: CURSOR cur_pymnt_isir(
547: l_base_id igf_gr_rfms.base_id%TYPE
548: ) IS
549: SELECT isir.transaction_num
550: FROM igf_ap_isir_matched isir
551: WHERE isir.base_id = l_base_id

Line 573: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS

569: AND att.attending_pell_cd = cp_attending_pell;
570: l_attending_pell_exists cur_attending_pell%ROWTYPE;
571:
572: -- To get sum of disbursement amounts.
573: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
574: SELECT SUM(disb_amt) disb_amt_tot
575: FROM igf_gr_rfms_disb
576: WHERE origination_id = cp_origination_id;
577: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;

Line 575: FROM igf_gr_rfms_disb

571:
572: -- To get sum of disbursement amounts.
573: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
574: SELECT SUM(disb_amt) disb_amt_tot
575: FROM igf_gr_rfms_disb
576: WHERE origination_id = cp_origination_id;
577: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;
578:
579: BEGIN

Line 582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);

578:
579: BEGIN
580:
581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);

Line 583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);

579: BEGIN
580:
581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;

Line 584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);

580:
581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;
588:

Line 585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);

581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;
588:
589: -- FA 126. Passed extra parameters p_reporting_pell and p_attending_pell to this cursor.

Line 586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);

582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;
588:
589: -- FA 126. Passed extra parameters p_reporting_pell and p_attending_pell to this cursor.
590: OPEN cur_rfms_disb(p_base_id,p_ci_cal_type,p_ci_sequence_number, p_reporting_pell, p_attending_pell);

Line 643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');

639: -- Student in Context has changed so do the Transaction Check as well Attending Pell child check.
640: l_running_orig_id := rec_rfms_disb.origination_id ;
641: l_valid_rec := TRUE;
642:
643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');
644: fnd_message.set_token('ORIG_ID',l_running_orig_id);
645: fnd_file.put_line(fnd_file.log,fnd_message.get);
646:
647: -- Get The Payment ISIR Transaction Number

Line 762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');

758: WHEN next_record THEN
759: RAISE;
760: WHEN OTHERS THEN
761: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');
763: igs_ge_msg_stack.add;
764: app_exception.raise_exception;
765: END rfms_disb_orig;
766:

Line 800: CURSOR cur_gr_rfmb_disb ( p_batch_id igf_gr_rfms_batch.batch_id%TYPE)

796: lv_message fnd_new_messages.message_name%TYPE;
797: SYSTEM_STATUS VARCHAR2(20);
798: ----Bug #2938258
799:
800: CURSOR cur_gr_rfmb_disb ( p_batch_id igf_gr_rfms_batch.batch_id%TYPE)
801: IS
802: SELECT
803: rfmb_id
804: FROM

Line 805: igf_gr_rfms_batch

801: IS
802: SELECT
803: rfmb_id
804: FROM
805: igf_gr_rfms_batch
806: WHERE batch_id = p_batch_id;
807:
808: cur_get_rfmb_disb cur_gr_rfmb_disb%ROWTYPE;
809: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

Line 809: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

805: igf_gr_rfms_batch
806: WHERE batch_id = p_batch_id;
807:
808: cur_get_rfmb_disb cur_gr_rfmb_disb%ROWTYPE;
809: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;
810: --end -Bug #2938258
811: BEGIN
812:
813: igf_gr_gen.process_pell_ack (g_ver_num,

Line 846: l_origination_id igf_gr_rfms.origination_id%TYPE;

842:
843: DECLARE
844:
845: l_actual_rec NUMBER DEFAULT 0;
846: l_origination_id igf_gr_rfms.origination_id%TYPE;
847: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
848: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
849: l_chk_flag BOOLEAN DEFAULT FALSE;
850:

Line 847: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

843: DECLARE
844:
845: l_actual_rec NUMBER DEFAULT 0;
846: l_origination_id igf_gr_rfms.origination_id%TYPE;
847: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
848: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
849: l_chk_flag BOOLEAN DEFAULT FALSE;
850:
851: CURSOR cur_award(l_origination_id igf_gr_rfms.origination_id%TYPE) IS

Line 848: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

844:
845: l_actual_rec NUMBER DEFAULT 0;
846: l_origination_id igf_gr_rfms.origination_id%TYPE;
847: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
848: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
849: l_chk_flag BOOLEAN DEFAULT FALSE;
850:
851: CURSOR cur_award(l_origination_id igf_gr_rfms.origination_id%TYPE) IS
852: SELECT

Line 851: CURSOR cur_award(l_origination_id igf_gr_rfms.origination_id%TYPE) IS

847: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
848: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
849: l_chk_flag BOOLEAN DEFAULT FALSE;
850:
851: CURSOR cur_award(l_origination_id igf_gr_rfms.origination_id%TYPE) IS
852: SELECT
853: *
854: FROM
855: igf_gr_rfms

Line 855: igf_gr_rfms

851: CURSOR cur_award(l_origination_id igf_gr_rfms.origination_id%TYPE) IS
852: SELECT
853: *
854: FROM
855: igf_gr_rfms
856: WHERE
857: origination_id = l_origination_id;
858:
859: rec_award cur_award%ROWTYPE;

Line 869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,

865: WHERE
866: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
867: AND file_type = 'GR_RFMS_DISB_ORIG';
868:
869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,
870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
871: IS
872: SELECT *
873: FROM igf_gr_rfms_disb

Line 870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)

866: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
867: AND file_type = 'GR_RFMS_DISB_ORIG';
868:
869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,
870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
871: IS
872: SELECT *
873: FROM igf_gr_rfms_disb
874: WHERE

Line 873: FROM igf_gr_rfms_disb

869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,
870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
871: IS
872: SELECT *
873: FROM igf_gr_rfms_disb
874: WHERE
875: origination_id = l_origination_id AND
876: disb_ref_num = l_disb_ref_num
877: FOR UPDATE OF edit_code NOWAIT;

Line 880: l_rfms igf_gr_rfms_disb%ROWTYPE;

876: disb_ref_num = l_disb_ref_num
877: FOR UPDATE OF edit_code NOWAIT;
878:
879: rec_disb_orig cur_disb_orig%ROWTYPE;
880: l_rfms igf_gr_rfms_disb%ROWTYPE;
881: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE;
882:
883: BEGIN
884:

Line 881: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE;

877: FOR UPDATE OF edit_code NOWAIT;
878:
879: rec_disb_orig cur_disb_orig%ROWTYPE;
880: l_rfms igf_gr_rfms_disb%ROWTYPE;
881: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE;
882:
883: BEGIN
884:
885: FOR rec_data IN c_rfms_data LOOP

Line 987: igf_gr_rfms_disb_pkg.update_row (

983: l_rfms.pymt_prd_start_dt := rec_disb_orig.accpt_pymt_prd_start_dt;
984: l_rfms.disb_status_dt := TRUNC(SYSDATE);
985:
986: lp_count := lp_count + 1;
987: igf_gr_rfms_disb_pkg.update_row (
988: x_rowid => rec_disb_orig.row_id,
989: x_rfmd_id => l_rfms.rfmd_id ,
990: x_origination_id => l_rfms.origination_id,
991: x_disb_ref_num => l_rfms.disb_ref_num,

Line 1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');

1093: WHEN igf_gr_gen.file_not_loaded THEN
1094: RAISE;
1095: WHEN OTHERS THEN
1096: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');
1098: igs_ge_msg_stack.add;
1099: app_exception.raise_exception;
1100: END rfms_disb_ack;
1101:

Line 1110: base_id IN igf_gr_rfms_all.base_id%TYPE,

1106: award_year IN VARCHAR2,
1107: p_reporting_pell IN VARCHAR2,
1108: p_attending_pell IN VARCHAR2,
1109: p_trans_type IN VARCHAR2,
1110: base_id IN igf_gr_rfms_all.base_id%TYPE,
1111: p_dummy IN VARCHAR2,
1112: p_pers_id_grp IN NUMBER
1113: )
1114: AS

Line 1161: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

1157: --(reverse chronological order - newest change first)
1158: --
1159: ------------------------------------------------------------------------------
1160:
1161: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1162: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1163: ln_base_id NUMBER;
1164: lv_status VARCHAR2(1);
1165: l_list VARCHAR2(32767);

Line 1162: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

1158: --
1159: ------------------------------------------------------------------------------
1160:
1161: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1162: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1163: ln_base_id NUMBER;
1164: lv_status VARCHAR2(1);
1165: l_list VARCHAR2(32767);
1166: TYPE base_idRefCur IS REF CURSOR;

Line 1281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(A)calling rfms_disb_orig with base_id:'||ln_base_id);

1277: Main logic starts here.
1278: */
1279: IF ln_base_id IS NOT NULL THEN
1280: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(A)calling rfms_disb_orig with base_id:'||ln_base_id);
1282: END IF;
1283: --call the main processing routine
1284: rfms_disb_orig(l_ci_cal_type,l_ci_sequence_number,ln_base_id, p_reporting_pell, p_attending_pell);
1285:

Line 1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(B)calling rfms_disb_orig with attedning pell:'||p_attending_pell);

1284: rfms_disb_orig(l_ci_cal_type,l_ci_sequence_number,ln_base_id, p_reporting_pell, p_attending_pell);
1285:
1286: ELSIF p_attending_pell IS NOT NULL THEN
1287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(B)calling rfms_disb_orig with attedning pell:'||p_attending_pell);
1289: END IF;
1290: --call the main processing routine
1291: rfms_disb_orig(l_ci_cal_type,l_ci_sequence_number,ln_base_id, p_reporting_pell, p_attending_pell);
1292:

Line 1311: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(C)calling rfms_disb_orig with base_id:'||ln_base_id);

1307:
1308: WHILE c_base_id%FOUND LOOP
1309: BEGIN
1310: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1311: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(C)calling rfms_disb_orig with base_id:'||ln_base_id);
1312: END IF;
1313:
1314: l_record := NVL(l_record,0) + 1;
1315: --call the main processing routine

Line 1388: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

1384: -- (reverse chronological order - newest change first)
1385: --
1386: ------------------------------------------------------------------------------
1387:
1388: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1389: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1390:
1391: BEGIN
1392:

Line 1389: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

1385: --
1386: ------------------------------------------------------------------------------
1387:
1388: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1389: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1390:
1391: BEGIN
1392:
1393: retcode := 0;

Line 1482: END igf_gr_rfms_disb_orig;

1478: igs_ge_msg_stack.conc_exception_hndl;
1479:
1480: END main_ack;
1481:
1482: END igf_gr_rfms_disb_orig;