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

Line 1: PACKAGE BODY igf_gr_rfms_orig AS

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

Line 94: CURSOR cur_rfms(l_base_id igf_gr_rfms.base_id%TYPE,

90: --
91:
92: -- FA 126. This cursor cur_rfms is modified to include reporting and attending pell ids.
93:
94: CURSOR cur_rfms(l_base_id igf_gr_rfms.base_id%TYPE,
95: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
96: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
97: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
98: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE

Line 95: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,

91:
92: -- FA 126. This cursor cur_rfms is modified to include reporting and attending pell ids.
93:
94: CURSOR cur_rfms(l_base_id igf_gr_rfms.base_id%TYPE,
95: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
96: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
97: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
98: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
99: )

Line 96: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,

92: -- FA 126. This cursor cur_rfms is modified to include reporting and attending pell ids.
93:
94: CURSOR cur_rfms(l_base_id igf_gr_rfms.base_id%TYPE,
95: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
96: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
97: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
98: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
99: )
100: IS

Line 97: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,

93:
94: CURSOR cur_rfms(l_base_id igf_gr_rfms.base_id%TYPE,
95: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
96: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
97: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
98: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
99: )
100: IS
101: SELECT

Line 98: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE

94: CURSOR cur_rfms(l_base_id igf_gr_rfms.base_id%TYPE,
95: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
96: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
97: cp_reporting_pell igf_gr_rfms.rep_pell_id%TYPE,
98: cp_attending_pell igf_gr_rfms.attending_campus_id%TYPE
99: )
100: IS
101: SELECT
102: rfms.*

Line 104: igf_gr_rfms rfms

100: IS
101: SELECT
102: rfms.*
103: FROM
104: igf_gr_rfms rfms
105: WHERE
106: rfms.orig_action_code = 'R' AND
107: rfms.base_id = NVL(l_base_id,rfms.base_id) AND
108: rfms.ci_cal_type = l_ci_cal_type AND

Line 119: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE) IS

115:
116:
117:
118: PROCEDURE update_orig_rec(p_rfms_rec cur_rfms%ROWTYPE,
119: p_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE) IS
120: --
121: -- This procedure updates the rfms origination records
122: -- which are being sent to the external processor
123: -- orig_action_code is updated to 'S' to indicate that

Line 129: igf_gr_rfms_pkg.update_row(

125: -- Update the RFMB_ID field in IGFGR004
126: --
127: BEGIN
128:
129: igf_gr_rfms_pkg.update_row(
130: x_rowid => p_rfms_rec.row_id,
131: x_origination_id => p_rfms_rec.origination_id,
132: x_ci_cal_type => p_rfms_rec.ci_cal_type,
133: x_ci_sequence_number => p_rfms_rec.ci_sequence_number,

Line 188: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.UPDATE_ORIG_REC');

184: x_document_id_txt => p_rfms_rec.document_id_txt );
185: EXCEPTION
186: WHEN OTHERS THEN
187: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
188: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.UPDATE_ORIG_REC');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191:
192: END update_orig_rec;

Line 197: p_rfmb_id IN igf_gr_rfms_batch.rfmb_id%TYPE,

193:
194: PROCEDURE prepare_data
195: ( p_rfms_rec cur_rfms%ROWTYPE,
196: p_num_of_records IN OUT NOCOPY NUMBER,
197: p_rfmb_id IN igf_gr_rfms_batch.rfmb_id%TYPE,
198: p_originated IN OUT NOCOPY VARCHAR2,
199: p_enrl_status_mesgnum IN NUMBER ) IS
200: ------------------------------------------------------------------------
201: --

Line 230: -- This cursor gets disb_dates from igf_gr_rfms_disb

226: l_person_id hz_parties.party_id%TYPE;
227: student_dtl_cur igf_sl_gen.person_dtl_cur;
228: student_dtl_rec igf_sl_gen.person_dtl_rec;
229:
230: -- This cursor gets disb_dates from igf_gr_rfms_disb
231: -- for a particualr origination
232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS
233: SELECT disb_dt
234: FROM igf_gr_rfms_disb

Line 232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS

228: student_dtl_rec igf_sl_gen.person_dtl_rec;
229:
230: -- This cursor gets disb_dates from igf_gr_rfms_disb
231: -- for a particualr origination
232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS
233: SELECT disb_dt
234: FROM igf_gr_rfms_disb
235: WHERE origination_id = l_orig_id
236: ORDER BY disb_ref_num;

Line 234: FROM igf_gr_rfms_disb

230: -- This cursor gets disb_dates from igf_gr_rfms_disb
231: -- for a particualr origination
232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS
233: SELECT disb_dt
234: FROM igf_gr_rfms_disb
235: WHERE origination_id = l_orig_id
236: ORDER BY disb_ref_num;
237: l_disbursement_dates VARCHAR2(400);
238:

Line 382: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));

378: -- Since we are going to write the record to file, print log message if we had been set enrollment_status.
379: IF p_enrl_status_mesgnum = 1 THEN
380: -- default to 'Others'
381: fnd_message.set_name('IGF','IGF_GR_DEFAULT_ENRL_STAT');
382: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
383: fnd_file.put_line(fnd_file.log,fnd_message.get);
384: ELSIF p_enrl_status_mesgnum = 2 THEN
385: -- set to pell attendance code.
386: fnd_message.set_name('IGF','IGF_GR_SET_ENRL_STAT');

Line 387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));

383: fnd_file.put_line(fnd_file.log,fnd_message.get);
384: ELSIF p_enrl_status_mesgnum = 2 THEN
385: -- set to pell attendance code.
386: fnd_message.set_name('IGF','IGF_GR_SET_ENRL_STAT');
387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389: END IF;
390:
391: fnd_file.put_line(fnd_file.output,UPPER(l_data));

Line 411: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.PREPARE_DATA');

407: RAISE;
408:
409: WHEN OTHERS THEN
410: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
411: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.PREPARE_DATA');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414:
415: END prepare_data;

Line 420: p_origination_id igf_gr_rfms.origination_id%TYPE ) IS

416:
417:
418: PROCEDURE log_message
419: (p_batch_id VARCHAR2,
420: p_origination_id igf_gr_rfms.origination_id%TYPE ) IS
421:
422: ---------------------------------------------------------------------
423: --
424: -- Created By : sjadhav

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

455:
456: EXCEPTION
457: WHEN others THEN
458: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
459: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
460: igs_ge_msg_stack.add;
461: app_exception.raise_exception;
462:
463: END log_message;

Line 466: PROCEDURE out_message(p_origination_id igf_gr_rfms.origination_id%TYPE) IS

462:
463: END log_message;
464:
465:
466: PROCEDURE out_message(p_origination_id igf_gr_rfms.origination_id%TYPE) IS
467:
468: ---------------------------------------------------------------------
469: --
470: -- Created By : sjadhav

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

503:
504: EXCEPTION
505: WHEN others THEN
506: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
507: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510:
511:

Line 516: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms.origination_id%TYPE,

512: END out_message;
513:
514:
515:
516: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms.origination_id%TYPE,
517: p_orig_reject_code igf_gr_rfms.orig_reject_code%TYPE) IS
518:
519: ---------------------------------------------------------------------
520: --

Line 517: p_orig_reject_code igf_gr_rfms.orig_reject_code%TYPE) IS

513:
514:
515:
516: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms.origination_id%TYPE,
517: p_orig_reject_code igf_gr_rfms.orig_reject_code%TYPE) IS
518:
519: ---------------------------------------------------------------------
520: --
521: -- Created By : sjadhav

Line 541: l_error_code igf_gr_rfms_error.edit_code%TYPE;

537: l_msg_str_3 VARCHAR2(1000) DEFAULT NULL;
538:
539:
540: l_count NUMBER DEFAULT 1;
541: l_error_code igf_gr_rfms_error.edit_code%TYPE;
542: l_msg_desc VARCHAR2(4000) DEFAULT NULL;
543:
544: BEGIN
545:

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

573:
574: EXCEPTION
575: WHEN others THEN
576: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
578: igs_ge_msg_stack.add;
579: app_exception.raise_exception;
580:
581:

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

595: --
596: -- Created By : sjadhav
597: --
598: -- Date Created On : 2001/01/03
599: -- Purpose : This procedure reads the data from igf_gr_rfms table
600: -- for the paricular award year and base id and loads the data
601: -- into a datafile after formatting
602: --
603: -- Know limitations, enhancements or remarks

Line 647: CURSOR cur_pymnt_isir( cp_base_id igf_gr_rfms.base_id%TYPE ) IS

643: -- (reverse chronological order - newest change first)
644: --
645: -------------------------------------------------------------------------------
646:
647: CURSOR cur_pymnt_isir( cp_base_id igf_gr_rfms.base_id%TYPE ) IS
648: SELECT isir.transaction_num
649: FROM igf_ap_isir_matched isir
650: WHERE isir.base_id = cp_base_id
651: AND isir.payment_isir = 'Y' ;

Line 679: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;

675: l_amount_total NUMBER DEFAULT 0;
676: l_batch_id VARCHAR2(60);
677: l_originated VARCHAR2(1);
678:
679: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
680: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
681: l_pell_mat VARCHAR2(10);
682: l_isir_present BOOLEAN := FALSE;
683:

Line 680: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;

676: l_batch_id VARCHAR2(60);
677: l_originated VARCHAR2(1);
678:
679: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
680: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
681: l_pell_mat VARCHAR2(10);
682: l_isir_present BOOLEAN := FALSE;
683:
684: -- FA 131 - COD Updates Build cursors and variables. 03-DEC-2003 ugummall.

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

688: WHERE award_id = cp_award_id
689: GROUP BY base_attendance_type_code;
690: rec_base_attendance_type_code cur_base_attendance_type_code%ROWTYPE;
691:
692: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
693: SELECT sum(disb_amt) disb_amt_tot
694: FROM igf_gr_rfms_disb
695: WHERE origination_id = cp_origination_id;
696: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;

Line 694: FROM igf_gr_rfms_disb

690: rec_base_attendance_type_code cur_base_attendance_type_code%ROWTYPE;
691:
692: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
693: SELECT sum(disb_amt) disb_amt_tot
694: FROM igf_gr_rfms_disb
695: WHERE origination_id = cp_origination_id;
696: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;
697:
698: TYPE PersonIdGroupType IS REF CURSOR ;

Line 702: l_pell_amt igf_gr_rfms.pell_amount%TYPE;

698: TYPE PersonIdGroupType IS REF CURSOR ;
699: refcur_persid_check PersonIdGroupType;
700: lv_persid NUMBER(1);
701:
702: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
703: l_return_status VARCHAR2(1);
704: l_return_mesg_text VARCHAR2(2000);
705:
706: -- Variables for the dynamic person id group

Line 1012: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.RFMS_ORIG');

1008: WHEN persid_grp_sql_stmt_error THEN
1009: RAISE;
1010: WHEN OTHERS THEN
1011: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1012: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.RFMS_ORIG');
1013: igs_ge_msg_stack.add;
1014: app_exception.raise_exception;
1015:
1016: END rfms_orig;

Line 1050: CURSOR cur_gr_rfmb ( p_batch_id igf_gr_rfms_batch.batch_id%TYPE)

1046: lv_message fnd_new_messages.message_name%TYPE;
1047: SYSTEM_STATUS VARCHAR2(20);
1048:
1049: ----Bug #2938258
1050: CURSOR cur_gr_rfmb ( p_batch_id igf_gr_rfms_batch.batch_id%TYPE)
1051: IS
1052: SELECT
1053: rfmb_id
1054: FROM

Line 1055: igf_gr_rfms_batch

1051: IS
1052: SELECT
1053: rfmb_id
1054: FROM
1055: igf_gr_rfms_batch
1056: WHERE batch_id = p_batch_id;
1057:
1058: cur_get_rfmb cur_gr_rfmb%ROWTYPE;
1059: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

Line 1059: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;

1055: igf_gr_rfms_batch
1056: WHERE batch_id = p_batch_id;
1057:
1058: cur_get_rfmb cur_gr_rfmb%ROWTYPE;
1059: l_rfmb_id igf_gr_rfms_batch.rfmb_id%TYPE;
1060: -----
1061:
1062: BEGIN
1063:

Line 1097: l_origination_id igf_gr_rfms.origination_id%TYPE;

1093: IF l_number_rec > 0 THEN
1094:
1095: DECLARE
1096: l_actual_rec NUMBER DEFAULT 0;
1097: l_origination_id igf_gr_rfms.origination_id%TYPE;
1098: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1099: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1100:
1101:

Line 1098: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

1094:
1095: DECLARE
1096: l_actual_rec NUMBER DEFAULT 0;
1097: l_origination_id igf_gr_rfms.origination_id%TYPE;
1098: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1099: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1100:
1101:
1102: l_chk_flag BOOLEAN DEFAULT FALSE;

Line 1099: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

1095: DECLARE
1096: l_actual_rec NUMBER DEFAULT 0;
1097: l_origination_id igf_gr_rfms.origination_id%TYPE;
1098: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1099: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1100:
1101:
1102: l_chk_flag BOOLEAN DEFAULT FALSE;
1103:

Line 1105: CURSOR cur_get_pell(l_origination_id igf_gr_rfms.origination_id%TYPE) IS

1101:
1102: l_chk_flag BOOLEAN DEFAULT FALSE;
1103:
1104:
1105: CURSOR cur_get_pell(l_origination_id igf_gr_rfms.origination_id%TYPE) IS
1106: SELECT rfms.*
1107: FROM
1108: igf_gr_rfms rfms
1109: WHERE

Line 1108: igf_gr_rfms rfms

1104:
1105: CURSOR cur_get_pell(l_origination_id igf_gr_rfms.origination_id%TYPE) IS
1106: SELECT rfms.*
1107: FROM
1108: igf_gr_rfms rfms
1109: WHERE
1110: rfms.origination_id = l_origination_id
1111: FOR UPDATE OF origination_id NOWAIT;
1112:

Line 1125: l_rfms igf_gr_rfms%ROWTYPE ;

1121: WHERE
1122: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1) AND
1123: file_type = 'GR_RFMS_ORIG';
1124:
1125: l_rfms igf_gr_rfms%ROWTYPE ;
1126: rec_data c_rfms_data%ROWTYPE;
1127:
1128: ln_pell_awd NUMBER;
1129:

Line 1273: igf_gr_rfms_pkg.update_row (

1269: --
1270:
1271: END IF;
1272: lp_count := lp_count + 1;
1273: igf_gr_rfms_pkg.update_row (
1274: x_rowid => get_pell_rec.row_id,
1275: x_origination_id => l_rfms.origination_id,
1276: x_ci_cal_type => l_rfms.ci_cal_type,
1277: x_ci_sequence_number => l_rfms.ci_sequence_number,

Line 1392: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.RFMS_ACK');

1388: WHEN igf_gr_gen.file_not_loaded THEN
1389: RAISE;
1390: WHEN OTHERS THEN
1391: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1392: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.RFMS_ACK');
1393: igs_ge_msg_stack.add;
1394: app_exception.raise_exception;
1395: END rfms_ack;
1396:

Line 1402: base_id IN igf_gr_rfms_all.base_id%TYPE,

1398: retcode OUT NOCOPY NUMBER,
1399: award_year IN VARCHAR2,
1400: p_reporting_pell IN VARCHAR2,
1401: p_attending_pell IN VARCHAR2,
1402: base_id IN igf_gr_rfms_all.base_id%TYPE,
1403: p_persid_grp IN VARCHAR2,
1404: p_orig_run_mode IN VARCHAR2 )
1405: AS
1406:

Line 1449: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

1445: FROM igs_pe_persid_group_all
1446: WHERE group_id = cp_persid_grp;
1447: rec_person_group cur_person_group%ROWTYPE;
1448:
1449: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1450: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1451: ln_base_id NUMBER;
1452: l_msg_str_1 VARCHAR2(1000);
1453: l_msg_str_2 VARCHAR2(1000);

Line 1450: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

1446: WHERE group_id = cp_persid_grp;
1447: rec_person_group cur_person_group%ROWTYPE;
1448:
1449: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1450: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1451: ln_base_id NUMBER;
1452: l_msg_str_1 VARCHAR2(1000);
1453: l_msg_str_2 VARCHAR2(1000);
1454: l_msg_str_3 VARCHAR2(1000);

Line 1618: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

1614: -- (reverse chronological order - newest change first)
1615: --tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1616: ----------------------------------------------------------------------
1617:
1618: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1619: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1620:
1621: BEGIN
1622: igf_aw_gen.set_org_id(NULL);

Line 1619: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

1615: --tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1616: ----------------------------------------------------------------------
1617:
1618: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1619: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1620:
1621: BEGIN
1622: igf_aw_gen.set_org_id(NULL);
1623: retcode := 0;

Line 1718: END igf_gr_rfms_orig;

1714: igs_ge_msg_stack.conc_exception_hndl;
1715:
1716: END main_ack;
1717:
1718: END igf_gr_rfms_orig;