APPS.IGF_GR_GEN dependencies on IGF_GR_RFMS_BATCH

Line 612: p_rfmb_id OUT NOCOPY igf_gr_rfms_batch.rfmb_id%TYPE,

608: FUNCTION get_pell_header (p_ver_num IN VARCHAR2,
609: p_cycle_year IN VARCHAR2,
610: p_rep_pell_id IN igf_gr_pell_setup_all.rep_pell_id%TYPE,
611: p_batch_type IN VARCHAR2,
612: p_rfmb_id OUT NOCOPY igf_gr_rfms_batch.rfmb_id%TYPE,
613: p_batch_id OUT NOCOPY VARCHAR2,
614: p_ci_cal_type IN VARCHAR2,
615: p_ci_sequence_number IN NUMBER)
616: RETURN VARCHAR2

Line 678: -- Insert Batch ID of this batch into igf_gr_Rfms_batch table

674: -- Header Record Length=100, this is same length as that of data record
675: --
676:
677: --
678: -- Insert Batch ID of this batch into igf_gr_Rfms_batch table
679: --
680:
681:
682: l_rowid := NULL;

Line 684: igf_gr_rfms_batch_pkg.insert_row (

680:
681:
682: l_rowid := NULL;
683:
684: igf_gr_rfms_batch_pkg.insert_row (
685: x_rowid => l_rowid,
686: x_rfmb_id => p_rfmb_id,
687: x_batch_id => p_batch_id,
688: x_data_rec_length => ln_data_rec_len,

Line 839: CURSOR cur_rfms_batch ( p_batch_id igf_gr_rfms_batch_all.batch_id%TYPE)

835: file_type = p_file_type;
836:
837: trailer_rec cur_trailer%ROWTYPE;
838:
839: CURSOR cur_rfms_batch ( p_batch_id igf_gr_rfms_batch_all.batch_id%TYPE)
840: IS
841: SELECT *
842: FROM
843: igf_gr_rfms_batch

Line 843: igf_gr_rfms_batch

839: CURSOR cur_rfms_batch ( p_batch_id igf_gr_rfms_batch_all.batch_id%TYPE)
840: IS
841: SELECT *
842: FROM
843: igf_gr_rfms_batch
844: WHERE
845: batch_id = p_batch_id
846: FOR UPDATE OF rfms_ack_dt NOWAIT;
847:

Line 920: -- Update the igf_gr_rfms_batch table to reflect new values

916:
917: IF LTRIM(RTRIM(l_file_name)) = 'GRANT HDR' THEN -- Remove LIKE, put =
918:
919: --
920: -- Update the igf_gr_rfms_batch table to reflect new values
921: -- This is done only for #O and #D Files
922: --
923: IF p_file_type IN ('GR_RFMS_ORIG','GR_RFMS_DISB_ORIG') THEN
924: OPEN cur_rfms_batch(p_batch_id);

Line 931: igf_gr_rfms_batch_pkg.update_row (

927: CLOSE cur_rfms_batch;
928: RAISE batch_not_in_system;
929: END IF;
930:
931: igf_gr_rfms_batch_pkg.update_row (
932: x_rowid => rfms_batch_rec.row_id,
933: x_rfmb_id => rfms_batch_rec.rfmb_id,
934: x_batch_id => rfms_batch_rec.batch_id,
935: x_data_rec_length => rfms_batch_rec.data_rec_length,

Line 1405: igf_gr_rfms_batch batch

1401: SELECT
1402: batch.rfms_ack_batch_id
1403: FROM
1404: igf_gr_rfms pell,
1405: igf_gr_rfms_batch batch
1406: WHERE
1407: origination_id = p_orig_id AND
1408: pell.rfmb_id = batch.rfmb_id AND
1409: batch.rfms_ack_batch_id IS NOT NULL;

Line 2932: p_batch_id IN igf_gr_rfms_batch_all.batch_id%TYPE,

2928:
2929: END update_pell_status;
2930:
2931: PROCEDURE match_file_version (p_version IN igf_lookups_view.lookup_code%TYPE,
2932: p_batch_id IN igf_gr_rfms_batch_all.batch_id%TYPE,
2933: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE)
2934: IS
2935:
2936: --