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_AS_GEN_006 dependencies on IGS_AS_EXM_INS_SPVSR

Line 2101: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,

2097: WHERE esvv.exam_cal_type = p_exam_cal_type AND
2098: esvv.exam_ci_sequence_number = p_exam_ci_sequence_number AND
2099: esvv.venue_cd = p_venue_cd;
2100: FUNCTION asspl_val_sprvsr(
2101: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2102: p_ese_id IN OUT NOCOPY IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2103: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2104: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2105: p_ignore_warnings VARCHAR2,

Line 2103: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,

2099: esvv.venue_cd = p_venue_cd;
2100: FUNCTION asspl_val_sprvsr(
2101: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2102: p_ese_id IN OUT NOCOPY IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2103: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2104: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2105: p_ignore_warnings VARCHAR2,
2106: p_message_name OUT NOCOPY VARCHAR2)
2107: RETURN BOOLEAN

Line 2104: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,

2100: FUNCTION asspl_val_sprvsr(
2101: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2102: p_ese_id IN OUT NOCOPY IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2103: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2104: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2105: p_ignore_warnings VARCHAR2,
2106: p_message_name OUT NOCOPY VARCHAR2)
2107: RETURN BOOLEAN
2108: IS

Line 2112: v_exam_cal_type IGS_AS_EXM_INS_SPVSR.exam_cal_type%TYPE;

2108: IS
2109: BEGIN --asspl_val_sprvsr
2110: --Local function to validate the supervisor
2111: DECLARE
2112: v_exam_cal_type IGS_AS_EXM_INS_SPVSR.exam_cal_type%TYPE;
2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;
2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;
2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;

Line 2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;

2109: BEGIN --asspl_val_sprvsr
2110: --Local function to validate the supervisor
2111: DECLARE
2112: v_exam_cal_type IGS_AS_EXM_INS_SPVSR.exam_cal_type%TYPE;
2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;
2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;
2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;
2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;

Line 2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;

2110: --Local function to validate the supervisor
2111: DECLARE
2112: v_exam_cal_type IGS_AS_EXM_INS_SPVSR.exam_cal_type%TYPE;
2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;
2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;
2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;
2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;
2118: v_local_message_name VARCHAR2(30);

Line 2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;

2111: DECLARE
2112: v_exam_cal_type IGS_AS_EXM_INS_SPVSR.exam_cal_type%TYPE;
2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;
2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;
2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;
2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;
2118: v_local_message_name VARCHAR2(30);
2119: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;

Line 2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;

2112: v_exam_cal_type IGS_AS_EXM_INS_SPVSR.exam_cal_type%TYPE;
2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;
2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;
2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;
2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;
2118: v_local_message_name VARCHAR2(30);
2119: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;
2120: CURSOR c_esu IS

Line 2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;

2113: v_exam_ci_sequence_number IGS_AS_EXM_INS_SPVSR.exam_ci_sequence_number%TYPE;
2114: v_dt_alias IGS_AS_EXM_INS_SPVSR.dt_alias%TYPE;
2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;
2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;
2118: v_local_message_name VARCHAR2(30);
2119: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;
2120: CURSOR c_esu IS
2121: SELECT esu.EXAM_SUPERVISOR_TYPE

Line 2280: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,

2276: RETURN TRUE;
2277: END;
2278: END asspl_val_sprvsr;
2279: PROCEDURE asspl_ins_ve_sprvsr(
2280: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2281: p_ese_id IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2282: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2283: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2284: p_session_venue_ind VARCHAR2)

Line 2282: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,

2278: END asspl_val_sprvsr;
2279: PROCEDURE asspl_ins_ve_sprvsr(
2280: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2281: p_ese_id IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2282: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2283: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2284: p_session_venue_ind VARCHAR2)
2285: IS
2286: BEGIN --asspl_ins_ve_sprvsr

Line 2283: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,

2279: PROCEDURE asspl_ins_ve_sprvsr(
2280: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2281: p_ese_id IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2282: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2283: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2284: p_session_venue_ind VARCHAR2)
2285: IS
2286: BEGIN --asspl_ins_ve_sprvsr
2287: --Local procedure to insert the supervisor

Line 2330: -- Insert IGS_PE_PERSON into the IGS_AS_EXM_INS_SPVSR table. Put them into all exams

2326: );
2327: -- At a later date, a IGS_GE_S_LOG_ENTRY may be created to indicate successful
2328: -- insertion.
2329: ELSE
2330: -- Insert IGS_PE_PERSON into the IGS_AS_EXM_INS_SPVSR table. Put them into all exams
2331: -- for the IGS_GR_VENUE and session.
2332: FOR v_ei_rec IN c_ei LOOP
2333: BEGIN
2334: IGS_AS_EXM_INS_SPVSR_PKG.INSERT_ROW(

Line 2334: IGS_AS_EXM_INS_SPVSR_PKG.INSERT_ROW(

2330: -- Insert IGS_PE_PERSON into the IGS_AS_EXM_INS_SPVSR table. Put them into all exams
2331: -- for the IGS_GR_VENUE and session.
2332: FOR v_ei_rec IN c_ei LOOP
2333: BEGIN
2334: IGS_AS_EXM_INS_SPVSR_PKG.INSERT_ROW(
2335: X_ROWID => x_rowid,
2336: X_PERSON_ID => p_person_id,
2337: X_ASS_ID => v_ei_rec.ass_id,
2338: X_EXAM_CAL_TYPE => NULL,