eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SVS_AUTH_CAL_PKG dependencies on IGS_EN_ELGB_OVR

Line 227: IGS_EN_ELGB_OVR eeo

223:
224: CURSOR c_auth IS
225: SELECT eeo.ELGB_OVERRIDE_ID, esa.person_id
226: FROM IGS_EN_SVS_AUTH esa,
227: IGS_EN_ELGB_OVR eeo
228: WHERE esa.SEVIS_AUTH_ID = x_sevis_auth_id
229: AND esa.person_id = eeo.person_id
230: AND eeo.cal_type = x_cal_type
231: AND eeo.ci_sequence_number = x_ci_sequence_number;

Line 242: CURSOR c_eos (cp_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE) IS

238: AND esa.sevis_auth_id = sac.sevis_auth_id
239: AND sac.cal_type = x_cal_type
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');

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 248: l_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE;

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;
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);

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 389: IGS_EN_ELGB_OVR eo,

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
393: AND eo.cal_type = x_cal_type

Line 400: FROM IGS_EN_SVS_AUTH esa, IGS_EN_ELGB_OVR eo

396: AND eos.STEP_OVERRIDE_TYPE IN ('FMIN_CRDT','FATD_TYPE');
397:
398: CURSOR c_ovr IS
399: SELECT eo.ELGB_OVERRIDE_ID
400: FROM IGS_EN_SVS_AUTH esa, IGS_EN_ELGB_OVR eo
401: WHERE esa.sevis_auth_id = x_sevis_auth_id
402: AND esa.person_id = eo.person_id
403: AND eo.cal_type = x_cal_type
404: AND eo.ci_sequence_number = X_ci_sequence_number;

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 435: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;

431:
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);

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 463: igs_en_elgb_ovr_pkg.insert_row (

459: IF c_ovr%NOTFOUND THEN
460: l_rowid := NULL;
461: l_elgb_override_id := NULL;
462:
463: igs_en_elgb_ovr_pkg.insert_row (
464: x_mode => 'R',
465: x_rowid => l_rowid,
466: x_elgb_override_id => l_elgb_override_id,
467: x_person_id => l_person_id,

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,