APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_LOOKUPS_VIEW

Line 61: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,

57: ---------------------------------------------------------------------------------------
58: --
59: -- ## Forward Declaration of Trans_rec Procedure
60:
61: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
62: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
63: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
64: p_tot_rec_count IN OUT NOCOPY NUMBER);
65:

Line 69: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,

65:
66: PROCEDURE chg_originate(errbuf OUT NOCOPY VARCHAR2,
67: retcode OUT NOCOPY NUMBER,
68: p_award_year VARCHAR2,
69: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
70: p_org_id IN NUMBER,
71: school_type IN VARCHAR2,
72: p_school_code IN VARCHAR2
73: )

Line 103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##

99: ***************************************************************/
100:
101: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
102: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##

Line 260: SELECT meaning FROM igf_lookups_view

256: --have the same cost
257: --Bug 2332668
258:
259: CURSOR cur_get_parameters IS
260: SELECT meaning FROM igf_lookups_view
261: WHERE lookup_type='IGF_SL_DL_LOAN_CATG' AND lookup_code=p_dl_loan_catg AND enabled_flag = 'Y'
262:
263: UNION ALL
264:

Line 265: SELECT meaning FROM igf_lookups_view

261: WHERE lookup_type='IGF_SL_DL_LOAN_CATG' AND lookup_code=p_dl_loan_catg AND enabled_flag = 'Y'
262:
263: UNION ALL
264:
265: SELECT meaning FROM igf_lookups_view
266: WHERE lookup_type='IGF_GE_PARAMETERS' AND lookup_code IN ('AWARD_YEAR','LOAN_CATG','PARAMETER_PASS') AND enabled_flag = 'Y';
267:
268: -- Get the details of school meaning from lookups to print in the log file
269: CURSOR c_get_sch_code IS

Line 1097: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,

1093:
1094:
1095:
1096:
1097: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
1098: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
1099: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
1100: p_tot_rec_count IN OUT NOCOPY NUMBER)
1101: AS