eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SE_GEN_001 dependencies on IGF_LOOKUPS_VIEW

Line 33: FROM igf_lookups_view

29: AND sequence_number = cp_ci_sequence_number;
30:
31: CURSOR c_get_parameters IS
32: SELECT meaning, lookup_code
33: FROM igf_lookups_view
34: WHERE lookup_type='IGF_GE_PARAMETERS'
35: AND lookup_code IN ('AWARD_YEAR','FUND_CODE','PERSON_NUMBER','PARAMETER_PASS');
36:
37: CURSOR c_person_dtls (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

Line 50: l_award_year igf_lookups_view.meaning%TYPE;

46: FROM igf_aw_fund_mast
47: WHERE fund_id = c_fund_id;
48:
49: parameter_rec c_get_parameters%ROWTYPE;
50: l_award_year igf_lookups_view.meaning%TYPE;
51: l_fund_code igf_lookups_view.meaning%TYPE;
52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;

Line 51: l_fund_code igf_lookups_view.meaning%TYPE;

47: WHERE fund_id = c_fund_id;
48:
49: parameter_rec c_get_parameters%ROWTYPE;
50: l_award_year igf_lookups_view.meaning%TYPE;
51: l_fund_code igf_lookups_view.meaning%TYPE;
52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;

Line 52: l_person_number igf_lookups_view.meaning%TYPE;

48:
49: parameter_rec c_get_parameters%ROWTYPE;
50: l_award_year igf_lookups_view.meaning%TYPE;
51: l_fund_code igf_lookups_view.meaning%TYPE;
52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;
56: l_base_id igs_pe_person.person_number%TYPE := NULL;

Line 53: l_para_pass igf_lookups_view.meaning%TYPE;

49: parameter_rec c_get_parameters%ROWTYPE;
50: l_award_year igf_lookups_view.meaning%TYPE;
51: l_fund_code igf_lookups_view.meaning%TYPE;
52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;
56: l_base_id igs_pe_person.person_number%TYPE := NULL;
57:

Line 131: FROM igf_lookups_view

127: -------------------------------------------------------------------------------------
128:
129: CURSOR c_get_parameters IS
130: SELECT meaning, lookup_code
131: FROM igf_lookups_view
132: WHERE lookup_type = 'IGF_GE_PARAMETERS'
133: AND lookup_code IN ('FUND_CODE','PERSON_NUMBER','AWARD_ID');
134:
135: parameter_rec c_get_parameters%ROWTYPE;

Line 136: l_fund_code igf_lookups_view.meaning%TYPE;

132: WHERE lookup_type = 'IGF_GE_PARAMETERS'
133: AND lookup_code IN ('FUND_CODE','PERSON_NUMBER','AWARD_ID');
134:
135: parameter_rec c_get_parameters%ROWTYPE;
136: l_fund_code igf_lookups_view.meaning%TYPE;
137: l_person_number igf_lookups_view.meaning%TYPE;
138: l_award_id igf_lookups_view.meaning%TYPE;
139:
140: BEGIN

Line 137: l_person_number igf_lookups_view.meaning%TYPE;

133: AND lookup_code IN ('FUND_CODE','PERSON_NUMBER','AWARD_ID');
134:
135: parameter_rec c_get_parameters%ROWTYPE;
136: l_fund_code igf_lookups_view.meaning%TYPE;
137: l_person_number igf_lookups_view.meaning%TYPE;
138: l_award_id igf_lookups_view.meaning%TYPE;
139:
140: BEGIN
141:

Line 138: l_award_id igf_lookups_view.meaning%TYPE;

134:
135: parameter_rec c_get_parameters%ROWTYPE;
136: l_fund_code igf_lookups_view.meaning%TYPE;
137: l_person_number igf_lookups_view.meaning%TYPE;
138: l_award_id igf_lookups_view.meaning%TYPE;
139:
140: BEGIN
141:
142: -- Get all the Parameters

Line 189: FROM igf_lookups_view

185:
186: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
187: CURSOR c_get_parameters IS
188: SELECT meaning, lookup_code
189: FROM igf_lookups_view
190: WHERE lookup_type='IGF_GE_PARAMETERS'
191: AND lookup_code IN ('BATCH_ID','AUTH_ID','VALIDATION_LVL','PARAMETER_PASS');
192:
193: parameter_rec c_get_parameters%ROWTYPE;

Line 194: l_batch_id igf_lookups_view.meaning%TYPE;

190: WHERE lookup_type='IGF_GE_PARAMETERS'
191: AND lookup_code IN ('BATCH_ID','AUTH_ID','VALIDATION_LVL','PARAMETER_PASS');
192:
193: parameter_rec c_get_parameters%ROWTYPE;
194: l_batch_id igf_lookups_view.meaning%TYPE;
195: l_auth_id igf_lookups_view.meaning%TYPE;
196: l_validation_lvl igf_lookups_view.meaning%TYPE;
197: l_para_pass igf_lookups_view.meaning%TYPE;
198:

Line 195: l_auth_id igf_lookups_view.meaning%TYPE;

191: AND lookup_code IN ('BATCH_ID','AUTH_ID','VALIDATION_LVL','PARAMETER_PASS');
192:
193: parameter_rec c_get_parameters%ROWTYPE;
194: l_batch_id igf_lookups_view.meaning%TYPE;
195: l_auth_id igf_lookups_view.meaning%TYPE;
196: l_validation_lvl igf_lookups_view.meaning%TYPE;
197: l_para_pass igf_lookups_view.meaning%TYPE;
198:
199: BEGIN

Line 196: l_validation_lvl igf_lookups_view.meaning%TYPE;

192:
193: parameter_rec c_get_parameters%ROWTYPE;
194: l_batch_id igf_lookups_view.meaning%TYPE;
195: l_auth_id igf_lookups_view.meaning%TYPE;
196: l_validation_lvl igf_lookups_view.meaning%TYPE;
197: l_para_pass igf_lookups_view.meaning%TYPE;
198:
199: BEGIN
200:

Line 197: l_para_pass igf_lookups_view.meaning%TYPE;

193: parameter_rec c_get_parameters%ROWTYPE;
194: l_batch_id igf_lookups_view.meaning%TYPE;
195: l_auth_id igf_lookups_view.meaning%TYPE;
196: l_validation_lvl igf_lookups_view.meaning%TYPE;
197: l_para_pass igf_lookups_view.meaning%TYPE;
198:
199: BEGIN
200:
201: -- Get all the Parameters

Line 300: FROM igf_lookups_view

296:
297: -- Cursor used to get the Language transulated tokens
298: CURSOR c_get_tokens IS
299: SELECT meaning, lookup_code
300: FROM igf_lookups_view
301: WHERE lookup_type = 'IGF_MATCH_CRITERIA'
302: AND lookup_code = 'SSN';
303:
304: CURSOR c_hzp (cv_person_id hz_parties.party_id%TYPE ) IS

Line 1007: FROM igf_lookups_view

1003: AND flag = 'A';
1004:
1005: CURSOR c_get_se_errors(c_error_cd igf_se_payment_int.error_code%TYPE) IS
1006: SELECT meaning
1007: FROM igf_lookups_view
1008: WHERE lookup_type = 'IGF_STUD_EMP_ERROR'
1009: AND lookup_code = c_error_cd;
1010:
1011: CURSOR cur_pymt_int IS

Line 1026: l_error_meaming igf_lookups_view.meaning%TYPE;

1022: l_batch_id igf_se_payment_int.batch_id%TYPE;
1023: l_auth_id igf_se_payment_int.auth_id%TYPE;
1024: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
1025: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
1026: l_error_meaming igf_lookups_view.meaning%TYPE;
1027: l_level VARCHAR2(1);
1028: l_auth_count NUMBER(2) DEFAULT 0;
1029: l_rowid VARCHAR2(30);
1030: skip_record EXCEPTION;