APPS.IGS_EN_SVS_AUTH_CAL_PKG dependencies on IGS_EN_ELGB_OVR_STEP

Line 244: FROM IGS_EN_ELGB_OVR_STEP eos

240: AND sac.ci_sequence_number = x_ci_sequence_number ;
241:
242: CURSOR c_eos (cp_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE) IS
243: SELECT eos.rowid row_id, step_override_type, step_override_limit
244: FROM IGS_EN_ELGB_OVR_STEP eos
245: WHERE elgb_override_id = cp_elgb_override_id
246: AND STEP_OVERRIDE_TYPE IN ('FMIN_CRDT','FATD_TYPE');
247:
248: l_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE;

Line 249: l_step_override_type IGS_EN_ELGB_OVR_STEP.step_override_type%TYPE;

245: WHERE elgb_override_id = cp_elgb_override_id
246: AND STEP_OVERRIDE_TYPE IN ('FMIN_CRDT','FATD_TYPE');
247:
248: l_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE;
249: l_step_override_type IGS_EN_ELGB_OVR_STEP.step_override_type%TYPE;
250: l_step_override_limit IGS_EN_ELGB_OVR_STEP.step_override_limit%TYPE;
251: l_person_id HZ_PARTIES.PARTY_ID%TYPE;
252: l_dummy VARCHAR2(10);
253: l_rowid VARCHAR2(25);

Line 250: l_step_override_limit IGS_EN_ELGB_OVR_STEP.step_override_limit%TYPE;

246: AND STEP_OVERRIDE_TYPE IN ('FMIN_CRDT','FATD_TYPE');
247:
248: l_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE;
249: l_step_override_type IGS_EN_ELGB_OVR_STEP.step_override_type%TYPE;
250: l_step_override_limit IGS_EN_ELGB_OVR_STEP.step_override_limit%TYPE;
251: l_person_id HZ_PARTIES.PARTY_ID%TYPE;
252: l_dummy VARCHAR2(10);
253: l_rowid VARCHAR2(25);
254:

Line 276: IGS_EN_ELGB_OVR_STEP_PKG.DELETE_ROW(c_eos_rec.row_id);

272: FETCH c_another_auth INTO l_dummy;
273: IF c_another_auth%NOTFOUND THEN
274: CLOSE c_another_auth;
275: FOR c_eos_rec in c_eos(l_elgb_override_id) LOOP
276: IGS_EN_ELGB_OVR_STEP_PKG.DELETE_ROW(c_eos_rec.row_id);
277: END LOOP;
278: ELSE
279: CLOSE c_another_auth;
280: END IF;

Line 388: FROM IGS_EN_ELGB_OVR_STEP eos,

384: x_ci_sequence_number IN NUMBER) IS
385:
386: CURSOR c_step_exists IS
387: SELECT 'X'
388: FROM IGS_EN_ELGB_OVR_STEP eos,
389: IGS_EN_ELGB_OVR eo,
390: IGS_EN_SVS_AUTH esa
391: WHERE esa.sevis_auth_id = x_sevis_auth_id
392: AND esa.person_id = eo.person_id

Line 423: FROM IGS_EN_ELGB_OVR_STEP eos, IGS_EN_ELGB_OVR eo

419: CURSOR c_ovr_step (cp_person_id hz_parties.party_id%TYPE,
420: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
421: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS
422: SELECT STEP_OVERRIDE_TYPE, STEP_OVERRIDE_LIMIT
423: FROM IGS_EN_ELGB_OVR_STEP eos, IGS_EN_ELGB_OVR eo
424: WHERE eo.elgb_override_id = eos.elgb_override_id
425: AND eo.person_id = cp_person_id
426: AND eo.cal_type = cp_cal_type
427: AND eo.ci_sequence_number = cp_ci_sequence_number

Line 436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;

432: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
433: l_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
434: l_person_id hz_parties.party_id%TYPE;
435: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;
437: l_limit IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_LIMIT%TYPE;
438:
439: l_rowid VARCHAR2(25);
440: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;

Line 437: l_limit IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_LIMIT%TYPE;

433: l_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
434: l_person_id hz_parties.party_id%TYPE;
435: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;
437: l_limit IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_LIMIT%TYPE;
438:
439: l_rowid VARCHAR2(25);
440: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;
441:

Line 440: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;

436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;
437: l_limit IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_LIMIT%TYPE;
438:
439: l_rowid VARCHAR2(25);
440: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;
441:
442: l_dummy VARCHAR2(1);
443:
444:

Line 498: igs_en_elgb_ovr_step_pkg.insert_row (

494:
495: l_rowid := NULL;
496: l_elgb_ovr_step_id := NULL;
497:
498: igs_en_elgb_ovr_step_pkg.insert_row (
499: x_mode => 'R',
500: x_rowid => l_rowid,
501: x_elgb_ovr_step_id => l_elgb_ovr_step_id,
502: x_elgb_override_id => l_elgb_override_id,