APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_LOOKUP_VALUES

Line 217: FROM IGS_Lookup_values LKV

213: WHERE PE.party_id = p_person_id;
214:
215: CURSOR cur_step(p_lookup_type VARCHAR2, p_step VARCHAR2) IS
216: SELECT LKV.meaning
217: FROM IGS_Lookup_values LKV
218: WHERE lkv.lookup_type = p_lookup_type AND
219: LKV.lookup_code = p_step;
220:
221:

Line 786: CURSOR cur_step_meaning (cp_step_Type IGS_LOOKUP_VALUES.LOOKUP_CODE%TYPE) IS

782: WHERE party_id = p_party_id;
783:
784: l_person_number hz_parties.party_number%TYPE;
785:
786: CURSOR cur_step_meaning (cp_step_Type IGS_LOOKUP_VALUES.LOOKUP_CODE%TYPE) IS
787: SELECT meaning
788: FROM igs_lookup_values
789: WHERE lookup_code = cp_step_Type
790: AND (LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'

Line 788: FROM igs_lookup_values

784: l_person_number hz_parties.party_number%TYPE;
785:
786: CURSOR cur_step_meaning (cp_step_Type IGS_LOOKUP_VALUES.LOOKUP_CODE%TYPE) IS
787: SELECT meaning
788: FROM igs_lookup_values
789: WHERE lookup_code = cp_step_Type
790: AND (LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'
791: OR LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE');
792:

Line 800: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

796: -- procedure to check whether record exist, otherwise create new override record for Person Steps
797: PROCEDURE enrp_chk_pers_over(p_elgb_step IN VARCHAR2, p_is_teach_cal IN BOOLEAN
798: )AS
799:
800: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
801: l_step_override_limit igs_en_elgb_ovr_step.STEP_OVERRIDE_LIMIT%TYPE;
802: l_rowid VARCHAR2(30);
803: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;
804:

Line 889: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

885: igs_ca_inst ci
886: WHERE elgb.elgb_override_id = p_elgb_override_id
887: AND elgb.cal_type = ci.cal_type
888: AND elgb.ci_sequence_number = ci.sequence_number;
889: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
890: l_rowid VARCHAR2(30);
891: l_elgb_ovr_step_id NUMBER;
892: l_step_override_limit NUMBER := NULL;
893: l_ci_end_dt igs_ca_inst.end_dt%TYPE;

Line 1082: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

1078: --ptandon 02-Jul-2003 Modified to allow unit level override for multiple units/unit sections
1079: to a student in case of same unit step type if the override is for a
1080: different unit section. Bug# 3033214
1081: ------------------------------------------------------------------------------------------------------*/
1082: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
1083: l_rowid VARCHAR2(30);
1084: l_elgb_ovr_step_id NUMBER(15);
1085: l_elgb_ovr_step_uoo_id NUMBER(15);
1086: l_step_override_limit NUMBER(6,3) := NULL;