APPS.IGF_SL_DL_RECORD dependencies on IGF_SL_DL_FILE_TYPE

Line 39: p_rec_length igf_sl_dl_file_type.rec_length%TYPE;

35: -- the passed in parameters are not used
36: --
37: */
38:
39: p_rec_length igf_sl_dl_file_type.rec_length%TYPE;
40:
41: PROCEDURE DLHeader_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
42: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
43: p_cal_type igs_ca_inst.cal_type%TYPE,

Line 45: p_file_type igf_sl_dl_file_type.dl_file_type%TYPE,

41: PROCEDURE DLHeader_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
42: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
43: p_cal_type igs_ca_inst.cal_type%TYPE,
44: p_cal_seq_num igs_ca_inst.sequence_number%TYPE,
45: p_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
46: p_school_code IN VARCHAR2,
47: p_dbth_id IN OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
48: p_batch_id IN OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
49: p_mesg_class IN OUT NOCOPY igf_sl_dl_batch.message_class%TYPE,

Line 73: lv_message_class igf_sl_dl_file_type.message_class%TYPE;

69: changed the header and the orig record as per 2002-2003 file format changes
70: (reverse chronological order - newest change first)
71: ***************************************************************/
72:
73: lv_message_class igf_sl_dl_file_type.message_class%TYPE;
74: lv_batch_type igf_sl_dl_file_type.batch_type%TYPE;
75: lv_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
76:
77: BEGIN

Line 74: lv_batch_type igf_sl_dl_file_type.batch_type%TYPE;

70: (reverse chronological order - newest change first)
71: ***************************************************************/
72:
73: lv_message_class igf_sl_dl_file_type.message_class%TYPE;
74: lv_batch_type igf_sl_dl_file_type.batch_type%TYPE;
75: lv_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
76:
77: BEGIN
78:

Line 75: lv_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;

71: ***************************************************************/
72:
73: lv_message_class igf_sl_dl_file_type.message_class%TYPE;
74: lv_batch_type igf_sl_dl_file_type.batch_type%TYPE;
75: lv_cycle_year igf_sl_dl_file_type.cycle_year%TYPE;
76:
77: BEGIN
78:
79: -- Message Class, Batch Type and Cycle Year have been predefined for each Version+Filetype

Line 80: -- in igf_sl_dl_file_type seed data table.

76:
77: BEGIN
78:
79: -- Message Class, Batch Type and Cycle Year have been predefined for each Version+Filetype
80: -- in igf_sl_dl_file_type seed data table.
81: p_mesg_class := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
82: p_dl_loan_catg, 'MESSAGE-CLASS');
83: lv_batch_type := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
84: p_dl_loan_catg, 'BATCH-TYPE');

Line 164: --it is better we check if the IGF_SL_DL_FILE_TYPE (Seeded Table-Latest File Versions to

160: EXCEPTION
161: --Added this Exception as part of the Bug :- 2255281.
162: --DL Version Change
163: --This is to ensure that even if the DL Setup has the particular version specified,
164: --it is better we check if the IGF_SL_DL_FILE_TYPE (Seeded Table-Latest File Versions to
165: --shipped every time new Version Comes in) has the File Type Details.
166: --DL Setup picks up the Version from Lookups for LOOKUP_TYPE='IGF_SL_DL_VERSION'
167: WHEN NO_DATA_FOUND THEN
168: fnd_message.set_name('IGF','IGF_SL_DL_NO_VERSION');