APPS.IGS_FI_VAL_FAS dependencies on IGS_LOOKUPS_VAL

Line 4: skharida 09-feb-2006 Bug# 5018036 - SQL Tuning, changed to IGS_LOOKUPS_VAL instead to IGS_LOOKUPS_VIEW.

1: PACKAGE BODY IGS_FI_VAL_FAS AS
2: /* $Header: IGSFI23B.pls 120.2 2006/02/23 21:33:05 skharida noship $ */
3: /* Who When What
4: skharida 09-feb-2006 Bug# 5018036 - SQL Tuning, changed to IGS_LOOKUPS_VAL instead to IGS_LOOKUPS_VIEW.
5: uudayapr 07-dec-2004 ENH# 3167098, Modified finp_val_fas_ass_ind.
6: shtatiko 24-DEC-2003 Enh# 3167098, Modified finp_val_fas_ass_ind.
7: uudayapr 12-dec-2003 Bug#3080983 Modified the cursor c_fadv in the Function
8: finp_val_fas_balance .

Line 52: v_system_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;

48: BEGIN --finp_val_fas_ass_ind
49: --validate IGS_FI_FEE_AS.course_cd has a course_attempt_status with a fee_ass_ind
50: --of 'Y'
51: DECLARE
52: v_system_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
53: v_fee_ass_ind IGS_LOOKUPS_VAL.fee_ass_ind%TYPE;
54: v_course_attempt_status IGS_LOOKUPS_VAL.lookup_code%TYPE;
55: -- added this variable for stroing the load calendar derived data.
56: l_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE;

Line 53: v_fee_ass_ind IGS_LOOKUPS_VAL.fee_ass_ind%TYPE;

49: --validate IGS_FI_FEE_AS.course_cd has a course_attempt_status with a fee_ass_ind
50: --of 'Y'
51: DECLARE
52: v_system_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
53: v_fee_ass_ind IGS_LOOKUPS_VAL.fee_ass_ind%TYPE;
54: v_course_attempt_status IGS_LOOKUPS_VAL.lookup_code%TYPE;
55: -- added this variable for stroing the load calendar derived data.
56: l_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE;
57: l_n_load_ci_seq_number igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE;

Line 54: v_course_attempt_status IGS_LOOKUPS_VAL.lookup_code%TYPE;

50: --of 'Y'
51: DECLARE
52: v_system_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
53: v_fee_ass_ind IGS_LOOKUPS_VAL.fee_ass_ind%TYPE;
54: v_course_attempt_status IGS_LOOKUPS_VAL.lookup_code%TYPE;
55: -- added this variable for stroing the load calendar derived data.
56: l_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE;
57: l_n_load_ci_seq_number igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE;
58: CURSOR c_strty IS

Line 60: FROM IGS_LOOKUPS_VAL strty

56: l_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE;
57: l_n_load_ci_seq_number igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE;
58: CURSOR c_strty IS
59: SELECT strty.system_generated_ind
60: FROM IGS_LOOKUPS_VAL strty
61: WHERE strty.lookup_code = p_transaction_type AND
62: strty.lookup_type = 'TRANSACTION_TYPE';
63:
64: -- Enh# 3167098, Removed reference to igs_fi_f_cat_cal_rel and igs_fi_stdnt_ps_att_cat_v

Line 226: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;

222: --This module validates IGS_FI_FEE_AS.SI_FI_S_TRN_TYPE.
223: --SI_FI_S_TRN_TYPE.transaction_cat must equal 'DEBT' and
224: --s_tranaction_type.system_generated_ind must equal 'N'
225: DECLARE
226: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
227: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
228: CURSOR c_strty IS
229: SELECT strty.transaction_cat,
230: strty.system_generated_ind

Line 227: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;

223: --SI_FI_S_TRN_TYPE.transaction_cat must equal 'DEBT' and
224: --s_tranaction_type.system_generated_ind must equal 'N'
225: DECLARE
226: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
227: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
228: CURSOR c_strty IS
229: SELECT strty.transaction_cat,
230: strty.system_generated_ind
231: FROM IGS_LOOKUPS_VAL strty

Line 231: FROM IGS_LOOKUPS_VAL strty

227: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
228: CURSOR c_strty IS
229: SELECT strty.transaction_cat,
230: strty.system_generated_ind
231: FROM IGS_LOOKUPS_VAL strty
232: WHERE lookup_code = p_transaction_type AND
233: lookup_type = 'TRANSACTION_TYPE';
234: BEGIN
235: --- Set the default message number

Line 381: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;

377: --This module validates IGS_FI_FEE_AS.comments.
378: --IGS_FI_FEE_AS.comments cannot be NULL when a manual fee assessment record is
379: --created
380: DECLARE
381: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
382: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
383: CURSOR c_strty IS
384: SELECT strty.transaction_cat,
385: strty.system_generated_ind

Line 382: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;

378: --IGS_FI_FEE_AS.comments cannot be NULL when a manual fee assessment record is
379: --created
380: DECLARE
381: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
382: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
383: CURSOR c_strty IS
384: SELECT strty.transaction_cat,
385: strty.system_generated_ind
386: FROM IGS_LOOKUPS_VAL strty

Line 386: FROM IGS_LOOKUPS_VAL strty

382: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
383: CURSOR c_strty IS
384: SELECT strty.transaction_cat,
385: strty.system_generated_ind
386: FROM IGS_LOOKUPS_VAL strty
387: WHERE lookup_code = p_transaction_type AND
388: lookup_type = 'TRANSACTION_TYPE';
389: BEGIN
390: --- Set the default message number

Line 432: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;

428: -- and IGS_FI_F_CAT_FEE_LBL_V.end_dt.
429: DECLARE
430: v_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
431: v_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
432: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
433: CURSOR c_daiv_sd IS
434: SELECT daiv.alias_val
435: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
436: IGS_CA_DA_INST_V daiv

Line 459: FROM IGS_LOOKUPS_VAL strty

455: fcflv.fee_cal_type = daiv.cal_type AND
456: fcflv.fee_ci_sequence_number = daiv.ci_sequence_number;
457: CURSOR c_strty IS
458: SELECT strty.transaction_cat
459: FROM IGS_LOOKUPS_VAL strty
460: WHERE strty.lookup_code = p_s_transaction_type
461: AND strty.lookup_type = 'TRANSACTION_TYPE';
462:
463: BEGIN