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_FUTURE_DT_TRANS dependencies on IGS_HE_ST_SPA

Line 398: -- Delete IGS_HE_ST_SPA_CC records

394: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
395: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
396: IS
397: BEGIN -- del_hssc
398: -- Delete IGS_HE_ST_SPA_CC records
399: DECLARE
400:
401: CURSOR c_hssc IS
402: SELECT he_spa_cc_id

Line 403: FROM IGS_HE_ST_SPA_CC hssc

399: DECLARE
400:
401: CURSOR c_hssc IS
402: SELECT he_spa_cc_id
403: FROM IGS_HE_ST_SPA_CC hssc
404: WHERE hssc.person_id = p_person_id
405: AND hssc.course_cd = p_course_cd;
406:
407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS

Line 407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS

403: FROM IGS_HE_ST_SPA_CC hssc
404: WHERE hssc.person_id = p_person_id
405: AND hssc.course_cd = p_course_cd;
406:
407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS
408: SELECT rowid
409: FROM IGS_HE_ST_SPA_CC hssc
410: WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
411: FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;

Line 409: FROM IGS_HE_ST_SPA_CC hssc

405: AND hssc.course_cd = p_course_cd;
406:
407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS
408: SELECT rowid
409: FROM IGS_HE_ST_SPA_CC hssc
410: WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
411: FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;
412:
413: v_hssc_del_exists c_hssc_del%ROWTYPE;

Line 417: -- Delete IGS_HE_ST_SPA_CC records

413: v_hssc_del_exists c_hssc_del%ROWTYPE;
414:
415: BEGIN
416: FOR v_hssc_rec IN c_hssc LOOP
417: -- Delete IGS_HE_ST_SPA_CC records
418: FOR v_hssc_del_exists IN c_hssc_del(v_hssc_rec.he_spa_cc_id) LOOP
419:
420: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(X_ROWID => v_hssc_del_exists.ROWID );
421:

Line 420: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(X_ROWID => v_hssc_del_exists.ROWID );

416: FOR v_hssc_rec IN c_hssc LOOP
417: -- Delete IGS_HE_ST_SPA_CC records
418: FOR v_hssc_del_exists IN c_hssc_del(v_hssc_rec.he_spa_cc_id) LOOP
419:
420: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(X_ROWID => v_hssc_del_exists.ROWID );
421:
422: END LOOP;
423:
424: END LOOP;

Line 450: -- Delete IGS_HE_ST_SPA records

446: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
447: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
448: IS
449: BEGIN -- del_hssa
450: -- Delete IGS_HE_ST_SPA records
451: DECLARE
452: CURSOR c_hssa IS
453: SELECT hesa_st_spa_id,person_id,course_cd
454: FROM IGS_HE_ST_SPA hssa

Line 454: FROM IGS_HE_ST_SPA hssa

450: -- Delete IGS_HE_ST_SPA records
451: DECLARE
452: CURSOR c_hssa IS
453: SELECT hesa_st_spa_id,person_id,course_cd
454: FROM IGS_HE_ST_SPA hssa
455: WHERE hssa.person_id = p_person_id
456: AND hssa.course_cd = p_course_cd;
457:
458: CURSOR c_hssa_del (

Line 459: cp_hesa_st_spa_id IGS_HE_ST_SPA.hesa_st_spa_id%TYPE) IS

455: WHERE hssa.person_id = p_person_id
456: AND hssa.course_cd = p_course_cd;
457:
458: CURSOR c_hssa_del (
459: cp_hesa_st_spa_id IGS_HE_ST_SPA.hesa_st_spa_id%TYPE) IS
460: SELECT rowid
461: FROM IGS_HE_ST_SPA hssa
462: WHERE hssa.hesa_st_spa_id = cp_hesa_st_spa_id
463: FOR UPDATE OF hssa.LAST_UPDATE_DATE NOWAIT ;

Line 461: FROM IGS_HE_ST_SPA hssa

457:
458: CURSOR c_hssa_del (
459: cp_hesa_st_spa_id IGS_HE_ST_SPA.hesa_st_spa_id%TYPE) IS
460: SELECT rowid
461: FROM IGS_HE_ST_SPA hssa
462: WHERE hssa.hesa_st_spa_id = cp_hesa_st_spa_id
463: FOR UPDATE OF hssa.LAST_UPDATE_DATE NOWAIT ;
464:
465:

Line 467: cp_person_id IGS_HE_ST_SPA_UT.person_id%TYPE,

463: FOR UPDATE OF hssa.LAST_UPDATE_DATE NOWAIT ;
464:
465:
466: CURSOR c_hssua (
467: cp_person_id IGS_HE_ST_SPA_UT.person_id%TYPE,
468: cp_course_cd IGS_HE_ST_SPA.course_cd%TYPE) IS
469: SELECT hesa_st_spau_id
470: FROM IGS_HE_ST_SPA_UT hssua
471: WHERE hssua.person_id = cp_person_id

Line 468: cp_course_cd IGS_HE_ST_SPA.course_cd%TYPE) IS

464:
465:
466: CURSOR c_hssua (
467: cp_person_id IGS_HE_ST_SPA_UT.person_id%TYPE,
468: cp_course_cd IGS_HE_ST_SPA.course_cd%TYPE) IS
469: SELECT hesa_st_spau_id
470: FROM IGS_HE_ST_SPA_UT hssua
471: WHERE hssua.person_id = cp_person_id
472: AND hssua.course_cd = cp_course_cd ;

Line 470: FROM IGS_HE_ST_SPA_UT hssua

466: CURSOR c_hssua (
467: cp_person_id IGS_HE_ST_SPA_UT.person_id%TYPE,
468: cp_course_cd IGS_HE_ST_SPA.course_cd%TYPE) IS
469: SELECT hesa_st_spau_id
470: FROM IGS_HE_ST_SPA_UT hssua
471: WHERE hssua.person_id = cp_person_id
472: AND hssua.course_cd = cp_course_cd ;
473:
474: CURSOR c_hssua_del (

Line 475: cp_hesa_st_spau_id IGS_HE_ST_SPA_UT.hesa_st_spau_id%TYPE) IS

471: WHERE hssua.person_id = cp_person_id
472: AND hssua.course_cd = cp_course_cd ;
473:
474: CURSOR c_hssua_del (
475: cp_hesa_st_spau_id IGS_HE_ST_SPA_UT.hesa_st_spau_id%TYPE) IS
476: SELECT rowid
477: FROM IGS_HE_ST_SPA_UT hssua
478: WHERE hssua.hesa_st_spau_id = cp_hesa_st_spau_id
479: FOR UPDATE OF hssua.LAST_UPDATE_DATE NOWAIT ;

Line 477: FROM IGS_HE_ST_SPA_UT hssua

473:
474: CURSOR c_hssua_del (
475: cp_hesa_st_spau_id IGS_HE_ST_SPA_UT.hesa_st_spau_id%TYPE) IS
476: SELECT rowid
477: FROM IGS_HE_ST_SPA_UT hssua
478: WHERE hssua.hesa_st_spau_id = cp_hesa_st_spau_id
479: FOR UPDATE OF hssua.LAST_UPDATE_DATE NOWAIT ;
480:
481: v_hssa_del_exists c_hssa_del%ROWTYPE;

Line 491: -- Delete unconfirmed IGS_HE_ST_SPA_UT records

487: FOR v_hssa_rec IN c_hssa LOOP
488: FOR v_hssua_rec IN c_hssua (v_hssa_rec.person_id,
489: v_hssa_rec.course_cd ) LOOP
490: BEGIN
491: -- Delete unconfirmed IGS_HE_ST_SPA_UT records
492: FOR v_hssua_del_rec in c_hssua_del(v_hssua_rec.hesa_st_spau_id)
493:
494: LOOP
495: IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(

Line 495: IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(

491: -- Delete unconfirmed IGS_HE_ST_SPA_UT records
492: FOR v_hssua_del_rec in c_hssua_del(v_hssua_rec.hesa_st_spau_id)
493:
494: LOOP
495: IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(
496: X_ROWID => v_hssua_del_rec.ROWID );
497: END LOOP;
498: EXCEPTION
499: WHEN e_resource_busy THEN

Line 503: l_entity_name := 'IGS_HE_ST_SPA_UT_ALL';

499: WHEN e_resource_busy THEN
500: IF c_hssua_del%ISOPEN THEN
501: CLOSE c_hssua_del;
502: END IF;
503: l_entity_name := 'IGS_HE_ST_SPA_UT_ALL';
504: EXIT;
505: END;
506: END LOOP;
507: IF l_entity_name IS NOT NULL THEN

Line 510: -- Delete IGS_HE_ST_SPA records

506: END LOOP;
507: IF l_entity_name IS NOT NULL THEN
508: EXIT;
509: END IF;
510: -- Delete IGS_HE_ST_SPA records
511: FOR v_hssa_del_exists IN c_hssa_del(v_hssa_rec.hesa_st_spa_id) LOOP
512:
513: IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(
514: X_ROWID => v_hssa_del_exists.rowid );

Line 513: IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(

509: END IF;
510: -- Delete IGS_HE_ST_SPA records
511: FOR v_hssa_del_exists IN c_hssa_del(v_hssa_rec.hesa_st_spa_id) LOOP
512:
513: IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(
514: X_ROWID => v_hssa_del_exists.rowid );
515: END LOOP;
516: END LOOP;
517: