APPS.IGS_AS_GEN_006 dependencies on IGS_AS_EXMVNU_SESAVL

Line 1968: -- Default the IGS_AS_EXMVNU_SESAVL records for all venues within an

1964: p_exam_cal_type igs_ca_inst.cal_type%type;
1965: p_exam_ci_sequence_number igs_ca_inst.sequence_number%type;
1966:
1967: BEGIN -- assp_ins_dflt_evsa_a
1968: -- Default the IGS_AS_EXMVNU_SESAVL records for all venues within an
1969: -- examination period.
1970: -- It will set all open venues to be available for all sessions.
1971: --set the org id
1972: igs_ge_gen_003.set_org_id(p_org_id);

Line 2008: FROM IGS_AS_EXMVNU_SESAVL evsa

2004: WHERE exam_cal_type = p_exam_cal_type AND
2005: exam_ci_sequence_number = p_exam_ci_sequence_number AND
2006: NOT EXISTS (
2007: SELECT 'x'
2008: FROM IGS_AS_EXMVNU_SESAVL evsa
2009: WHERE evsa.ese_id = es.ese_id AND
2010: evsa.venue_cd = cp_venue_cd
2011: );
2012: BEGIN

Line 2017: IGS_AS_EXMVNU_SESAVL_PKG.INSERT_ROW(

2013: FOR v_ve_rec IN c_ve LOOP
2014: FOR v_es_rec IN c_es(
2015: v_ve_rec.venue_cd) LOOP
2016: x_rowid := NULL;
2017: IGS_AS_EXMVNU_SESAVL_PKG.INSERT_ROW(
2018: X_ROWID => x_rowid,
2019: X_ORG_ID => p_org_id,
2020: X_VENUE_CD => v_ve_rec.venue_cd,
2021: X_EXAM_CAL_TYPE => v_es_rec.exam_cal_type,