APPS.IGF_GR_RFMS_ORIG dependencies on IGF_GR_RFMS_BATCH

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 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 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 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: