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_AD_GEN_001 dependencies on IGS_AS_SU_SETATMPT

Line 691: -- (2) Delete IGS_AS_SU_SETATMPT records

687: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
688: RETURN BOOLEAN
689: IS
690: BEGIN -- admpl_del_susa
691: -- (2) Delete IGS_AS_SU_SETATMPT records
692: DECLARE
693: CURSOR c_susa IS
694: SELECT
695: susa.unit_set_cd,

Line 697: FROM IGS_AS_SU_SETATMPT susa

693: CURSOR c_susa IS
694: SELECT
695: susa.unit_set_cd,
696: susa.sequence_number
697: FROM IGS_AS_SU_SETATMPT susa
698: WHERE susa.person_id = p_person_id AND
699: susa.course_cd = p_course_cd
700: START WITH
701: susa.person_id = p_person_id AND

Line 711: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

707: PRIOR susa.unit_set_cd = susa.parent_unit_set_cd AND
708: PRIOR susa.sequence_number = susa.parent_sequence_number
709: ORDER BY LEVEL DESC;
710: CURSOR c_susa_del (
711: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
712: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
713: SELECT ROWID, susa.*
714: FROM IGS_AS_SU_SETATMPT susa
715: WHERE susa.person_id = p_person_id AND

Line 712: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

708: PRIOR susa.sequence_number = susa.parent_sequence_number
709: ORDER BY LEVEL DESC;
710: CURSOR c_susa_del (
711: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
712: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
713: SELECT ROWID, susa.*
714: FROM IGS_AS_SU_SETATMPT susa
715: WHERE susa.person_id = p_person_id AND
716: susa.course_cd = p_course_cd AND

Line 714: FROM IGS_AS_SU_SETATMPT susa

710: CURSOR c_susa_del (
711: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
712: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
713: SELECT ROWID, susa.*
714: FROM IGS_AS_SU_SETATMPT susa
715: WHERE susa.person_id = p_person_id AND
716: susa.course_cd = p_course_cd AND
717: susa.unit_set_cd = cp_unit_set_cd AND
718: susa.sequence_number = cp_sequence_number

Line 724: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

720: susa.LAST_UPDATE_DATE NOWAIT;
721: v_susa_del_exists c_susa_del%ROWTYPE;
722:
723:
724: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
725: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
726: SELECT hesa_en_susa_id
727: FROM IGS_HE_EN_SUSA hes
728: WHERE hes.person_id = p_person_id AND

Line 725: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

721: v_susa_del_exists c_susa_del%ROWTYPE;
722:
723:
724: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
725: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
726: SELECT hesa_en_susa_id
727: FROM IGS_HE_EN_SUSA hes
728: WHERE hes.person_id = p_person_id AND
729: hes.course_cd = p_course_cd AND

Line 740: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

736: FROM IGS_HE_EN_SUSA hes
737: WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
738: FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;
739:
740: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
741: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
742: SELECT he_susa_cc_id
743: FROM IGS_HE_EN_SUSA_CC hesc
744: WHERE hesc.person_id = p_person_id AND

Line 741: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

737: WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
738: FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;
739:
740: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
741: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
742: SELECT he_susa_cc_id
743: FROM IGS_HE_EN_SUSA_CC hesc
744: WHERE hesc.person_id = p_person_id AND
745: hesc.course_cd = p_course_cd AND

Line 820: -- Delete unconfirmed IGS_AS_SU_SETATMPT

816: IF l_entity_name IS NOT NULL THEN
817: EXIT;
818: END IF;
819:
820: -- Delete unconfirmed IGS_AS_SU_SETATMPT
821: FOR v_susa_del_exists IN c_susa_del(
822: v_susa_rec.unit_set_cd,
823: v_susa_rec.sequence_number) LOOP
824: IGS_AS_SU_SETATMPT_PKG.DELETE_ROW (

Line 824: IGS_AS_SU_SETATMPT_PKG.DELETE_ROW (

820: -- Delete unconfirmed IGS_AS_SU_SETATMPT
821: FOR v_susa_del_exists IN c_susa_del(
822: v_susa_rec.unit_set_cd,
823: v_susa_rec.sequence_number) LOOP
824: IGS_AS_SU_SETATMPT_PKG.DELETE_ROW (
825: X_ROWID => V_SUSA_DEL_EXISTS.ROWID );
826: END LOOP;
827:
828: END LOOP;

Line 867: l_entity_name := 'IGS_AS_SU_SETATMPT';

863: END IF;
864: -- Must reset database trigger validation if been turned off
865: IGS_GE_MNT_SDTT.genp_del_sdtt(
866: 'ADMP_DEL_SCA_UNCONF');
867: l_entity_name := 'IGS_AS_SU_SETATMPT';
868: RETURN FALSE;
869: WHEN OTHERS THEN
870: IF c_susa%ISOPEN THEN
871: CLOSE c_susa;

Line 2080: -- Delete IGS_AS_SU_SETATMPT (11)

2076: v_process_next := TRUE;
2077: END IF;
2078: END IF;
2079:
2080: -- Delete IGS_AS_SU_SETATMPT (11)
2081: IF NOT v_process_next THEN
2082: IF NOT admpl_del_susa(
2083: v_sca_rec.person_id,
2084: v_sca_rec.course_cd) THEN