APPS.IGS_ST_GEN_004 dependencies on IGS_ST_GVT_SPSHT_CTL

Line 236: v_sub_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;

232: v_dummy VARCHAR2(1);
233: v_other_detail VARCHAR2(255);
234: v_ess_rec_found BOOLEAN DEFAULT FALSE;
235: v_message_name VARCHAR2(30) DEFAULT NULL;
236: v_sub_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
237: -- define the submission census dates
238: -- these can be changed if required
239: v_submission_1_census_dt DATE :=
240: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'03/31');

Line 243: v_ess_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE;

239: v_submission_1_census_dt DATE :=
240: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'03/31');
241: v_submission_2_census_dt DATE :=
242: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'08/31');
243: v_ess_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE;
244: v_effective_dt DATE;
245: v_unit_effective_dt DATE;
246: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
247: v_derived_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 379: FROM IGS_ST_GVT_SPSHT_CTL gsc

375: ORDER BY Person_id;
376:
377: CURSOR c_govt_snpsht_ctl IS
378: SELECT gsc.submission_yr
379: FROM IGS_ST_GVT_SPSHT_CTL gsc
380: WHERE gsc.submission_yr = p_submission_yr AND
381: gsc.submission_number = p_submission_number;
382: CURSOR c_gsc_upd IS
383: SELECT rowid, gsc.*

Line 384: FROM IGS_ST_GVT_SPSHT_CTL gsc

380: WHERE gsc.submission_yr = p_submission_yr AND
381: gsc.submission_number = p_submission_number;
382: CURSOR c_gsc_upd IS
383: SELECT rowid, gsc.*
384: FROM IGS_ST_GVT_SPSHT_CTL gsc
385: WHERE gsc.submission_yr = p_submission_yr AND
386: gsc.submission_number = p_submission_number
387: FOR UPDATE OF gsc.ess_snapshot_dt_time NOWAIT;
388: CURSOR c_gsc IS

Line 390: FROM IGS_ST_GVT_SPSHT_CTL gsc

386: gsc.submission_number = p_submission_number
387: FOR UPDATE OF gsc.ess_snapshot_dt_time NOWAIT;
388: CURSOR c_gsc IS
389: SELECT gsc.ess_snapshot_dt_time
390: FROM IGS_ST_GVT_SPSHT_CTL gsc
391: WHERE gsc.submission_yr = p_submission_yr AND
392: gsc.submission_number = 2;
393: CURSOR c_essc IS
394: SELECT essc.snapshot_dt_time

Line 428: cp_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS

424: FROM IGS_EN_ATD_MODE atm
425: WHERE atm.govt_attendance_mode = '3'
426: ORDER BY atm.attendance_mode ASC;
427: CURSOR c_enr_snpsht_rec (
428: cp_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS
429: SELECT ess.ci_cal_type,
430: ess.ci_sequence_number,
431: ess.person_id,
432: ess.course_cd,

Line 1241: IGS_ST_GVT_SPSHT_CTL_PKG.UPDATE_ROW(

1237: BEGIN
1238: FOR v_gsc_upd_rec IN c_gsc_upd LOOP
1239:
1240: v_gsc_upd_rec.ess_snapshot_dt_time := v_ess_snapshot_dt_time;
1241: IGS_ST_GVT_SPSHT_CTL_PKG.UPDATE_ROW(
1242: X_ROWID => v_gsc_upd_rec.rowid,
1243: X_SUBMISSION_YR => v_gsc_upd_rec.submission_yr,
1244: X_SUBMISSION_NUMBER => v_gsc_upd_rec.submission_number,
1245: X_ESS_SNAPSHOT_DT_TIME => v_gsc_upd_rec.ess_snapshot_dt_time,

Line 1266: IGS_ST_GVT_SPSHT_CTL_PKG.UPDATE_ROW(

1262: BEGIN
1263: FOR v_gsc_upd_rec IN c_gsc_upd LOOP
1264:
1265: v_gsc_upd_rec.ess_snapshot_dt_time := v_ess_snapshot_dt_time;
1266: IGS_ST_GVT_SPSHT_CTL_PKG.UPDATE_ROW(
1267: X_ROWID => v_gsc_upd_rec.rowid,
1268: X_SUBMISSION_YR => v_gsc_upd_rec.submission_yr,
1269: X_SUBMISSION_NUMBER => v_gsc_upd_rec.submission_number,
1270: X_ESS_SNAPSHOT_DT_TIME => v_gsc_upd_rec.ess_snapshot_dt_time,