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.

[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on IGS_PS_UNIT_VER

Line 286: igs_ps_unit_ver_all uv,

282: sua.ci_end_dt,
283: sua.uoo_id,
284: sua.no_assessment_ind
285: FROM igs_en_su_attempt_all sua,
286: igs_ps_unit_ver_all uv,
287: igs_as_unit_class_all uc
288: WHERE ((cp_assess_cal_type IS NOT NULL
289: AND EXISTS (
290: SELECT 'x'

Line 913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,

909: App_Exception.Raise_Exception;
910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table

Line 914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )

910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table
918: DECLARE

Line 928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

924: SELECT COUNT(*)
925: FROM IGS_AS_ITEM_ASSESSOR
926: WHERE ass_id = cp_ass_id;
927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
930: SELECT coord_person_id
931: FROM IGS_PS_UNIT_VER
932: WHERE unit_cd = cp_unit_cd AND

Line 929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

925: FROM IGS_AS_ITEM_ASSESSOR
926: WHERE ass_id = cp_ass_id;
927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
930: SELECT coord_person_id
931: FROM IGS_PS_UNIT_VER
932: WHERE unit_cd = cp_unit_cd AND
933: version_number = cp_version_number;

Line 931: FROM IGS_PS_UNIT_VER

927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
930: SELECT coord_person_id
931: FROM IGS_PS_UNIT_VER
932: WHERE unit_cd = cp_unit_cd AND
933: version_number = cp_version_number;
934: CURSOR c_asst IS
935: SELECT ASS_ASSESSOR_TYPE

Line 943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;

939: v_aia_count NUMBER;
940: v_uv_rec c_uv%ROWTYPE;
941: v_asst_rec c_asst%ROWTYPE;
942: v_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE;
943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;
945: BEGIN
946: -- Initialise all the variables
947: v_ass_id := p_ass_id;

Line 944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;

940: v_uv_rec c_uv%ROWTYPE;
941: v_asst_rec c_asst%ROWTYPE;
942: v_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE;
943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;
945: BEGIN
946: -- Initialise all the variables
947: v_ass_id := p_ass_id;
948: v_unit_cd := p_unit_cd;

Line 1337: IGS_PS_UNIT_VER uv

1333: uv.version_number,
1334: uv.short_title
1335: FROM
1336: IGS_EN_SU_ATTEMPT sua,
1337: IGS_PS_UNIT_VER uv
1338: WHERE
1339: sua.person_id = cp_person_id AND
1340: sua.course_cd = cp_course_cd AND
1341: sua.uoo_id = cp_uoo_id AND

Line 1732: cp_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,

1728: -- within the nominated teaching period, org unit and mode.
1729: CURSOR c_uoo(
1730: cp_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE,
1731: cp_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1732: cp_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
1733: cp_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE,
1734: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE) IS
1735: SELECT uv.owner_org_unit_cd,
1736: uv.owner_ou_start_dt,

Line 1733: cp_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE,

1729: CURSOR c_uoo(
1730: cp_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE,
1731: cp_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1732: cp_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
1733: cp_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE,
1734: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE) IS
1735: SELECT uv.owner_org_unit_cd,
1736: uv.owner_ou_start_dt,
1737: uc.UNIT_MODE,

Line 1742: IGS_PS_UNIT_VER uv,

1738: uv.unit_cd,
1739: uv.version_number,
1740: uoo.uoo_id
1741: FROM IGS_PS_UNIT_OFR_OPT uoo,
1742: IGS_PS_UNIT_VER uv,
1743: IGS_AS_UNIT_CLASS uc
1744: WHERE uoo.unit_cd = uv.unit_cd AND
1745: uoo.version_number = uv.version_number AND
1746: uoo.UNIT_CLASS = uc.UNIT_CLASS AND