APPS.IGF_GR_YTD_LOAD_DATA dependencies on IGF_GR_RFMS

Line 23: g_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;

19: invalid_version EXCEPTION; -- Thrown if the award year doesn't matches with that on the flat file.
20:
21: g_ver_num VARCHAR2(30) DEFAULT NULL; -- Flat File Version Number
22: g_c_alt_code VARCHAR2(80) DEFAULT NULL; -- To hold alternate code.
23: g_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
24: g_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
25:
26:
27: PROCEDURE split_into_orig_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,

Line 24: g_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

20:
21: g_ver_num VARCHAR2(30) DEFAULT NULL; -- Flat File Version Number
22: g_c_alt_code VARCHAR2(80) DEFAULT NULL; -- To hold alternate code.
23: g_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
24: g_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
25:
26:
27: PROCEDURE split_into_orig_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,
28: p_ytd_orig_row OUT NOCOPY igf_gr_ytd_orig%ROWTYPE)

Line 42: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,

38: Who When What
39: smvk 11-Feb-2003 Bug # 2758812. Added '2003-2004' in g_ver_num checking.
40: ***************************************************************/
41:
42: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,
43: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
44: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
45: IS
46: SELECT

Line 43: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,

39: smvk 11-Feb-2003 Bug # 2758812. Added '2003-2004' in g_ver_num checking.
40: ***************************************************************/
41:
42: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,
43: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
44: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
45: IS
46: SELECT
47: COUNT(origination_id) rec_count

Line 44: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)

40: ***************************************************************/
41:
42: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,
43: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
44: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
45: IS
46: SELECT
47: COUNT(origination_id) rec_count
48: FROM

Line 49: igf_gr_rfms

45: IS
46: SELECT
47: COUNT(origination_id) rec_count
48: FROM
49: igf_gr_rfms
50: WHERE
51: ci_cal_type = p_ci_cal_type AND
52: ci_sequence_number = p_ci_sequence_number AND
53: p_orig_id = origination_id;

Line 226: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,

222: Who When What
223: smvk 11-Feb-2003 Bug # 2758812. Added '2003-2004' in g_ver_num checking.
224: ***************************************************************/
225:
226: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,
227: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
228: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
229: IS
230: SELECT

Line 227: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,

223: smvk 11-Feb-2003 Bug # 2758812. Added '2003-2004' in g_ver_num checking.
224: ***************************************************************/
225:
226: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,
227: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
228: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
229: IS
230: SELECT
231: COUNT(origination_id) rec_count

Line 228: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)

224: ***************************************************************/
225:
226: CURSOR cur_get_orig ( p_orig_id igf_gr_rfms_all.origination_id%TYPE,
227: p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
228: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
229: IS
230: SELECT
231: COUNT(origination_id) rec_count
232: FROM

Line 233: igf_gr_rfms

229: IS
230: SELECT
231: COUNT(origination_id) rec_count
232: FROM
233: igf_gr_rfms
234: WHERE
235: ci_cal_type = p_ci_cal_type AND
236: ci_sequence_number = p_ci_sequence_number AND
237: p_orig_id = origination_id;