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_004 dependencies on IGS_AS_MARK_SHEET

Line 219: CURSOR c_chk_mark_sheets (cp_mark_sheet igs_as_mark_sheet.sheet_number%TYPE) IS

215: WHERE EXISTS ( SELECT *
216: FROM igs_as_ins_grd_entry iaige
217: WHERE iaige.keying_time = cp_keying_time
218: AND iaige.keying_who = cp_keying_who);
219: CURSOR c_chk_mark_sheets (cp_mark_sheet igs_as_mark_sheet.sheet_number%TYPE) IS
220: SELECT 'x'
221: FROM DUAL
222: WHERE EXISTS ( SELECT *
223: FROM igs_as_msht_su_atmpt iamsa

Line 704: v_mss_mark_sheet igs_as_mark_sheet.sheet_number%TYPE;

700: DECLARE
701: -- select the mark sheets to produce based on parameters
702: e_resource_busy EXCEPTION;
703: --PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
704: v_mss_mark_sheet igs_as_mark_sheet.sheet_number%TYPE;
705: v_ms_sequence_number igs_as_mark_sheet.sheet_number%TYPE;
706: v_group_sequence_number igs_as_mark_sheet.group_sequence_number%TYPE;
707: cst_no CONSTANT CHAR := 'N';
708: v_duplicate_sheet BOOLEAN DEFAULT FALSE;

Line 705: v_ms_sequence_number igs_as_mark_sheet.sheet_number%TYPE;

701: -- select the mark sheets to produce based on parameters
702: e_resource_busy EXCEPTION;
703: --PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
704: v_mss_mark_sheet igs_as_mark_sheet.sheet_number%TYPE;
705: v_ms_sequence_number igs_as_mark_sheet.sheet_number%TYPE;
706: v_group_sequence_number igs_as_mark_sheet.group_sequence_number%TYPE;
707: cst_no CONSTANT CHAR := 'N';
708: v_duplicate_sheet BOOLEAN DEFAULT FALSE;
709: v_not_duplicate BOOLEAN;

Line 706: v_group_sequence_number igs_as_mark_sheet.group_sequence_number%TYPE;

702: e_resource_busy EXCEPTION;
703: --PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
704: v_mss_mark_sheet igs_as_mark_sheet.sheet_number%TYPE;
705: v_ms_sequence_number igs_as_mark_sheet.sheet_number%TYPE;
706: v_group_sequence_number igs_as_mark_sheet.group_sequence_number%TYPE;
707: cst_no CONSTANT CHAR := 'N';
708: v_duplicate_sheet BOOLEAN DEFAULT FALSE;
709: v_not_duplicate BOOLEAN;
710: v_duplicate_ind VARCHAR2 (1) := 'N';

Line 712: v_sheet_number igs_as_mark_sheet.sheet_number%TYPE;

708: v_duplicate_sheet BOOLEAN DEFAULT FALSE;
709: v_not_duplicate BOOLEAN;
710: v_duplicate_ind VARCHAR2 (1) := 'N';
711: v_ins_ms BOOLEAN DEFAULT FALSE;
712: v_sheet_number igs_as_mark_sheet.sheet_number%TYPE;
713: v_person_id igs_as_msht_su_atmpt.person_id%TYPE;
714: v_course_cd igs_as_msht_su_atmpt.course_cd%TYPE;
715: v_unit_cd igs_as_msht_su_atmpt.unit_cd%TYPE;
716: v_cal_type igs_as_msht_su_atmpt.cal_type%TYPE;

Line 780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE

776: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
777: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
778: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE
781: ) IS
782: SELECT sheet_number
783: FROM igs_as_mark_sheet ms
784: WHERE ms.unit_cd = cp_uop_unit_cd

Line 783: FROM igs_as_mark_sheet ms

779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE
781: ) IS
782: SELECT sheet_number
783: FROM igs_as_mark_sheet ms
784: WHERE ms.unit_cd = cp_uop_unit_cd
785: AND ms.version_number = cp_uop_version_number
786: AND ms.cal_type = cp_uop_cal_type
787: AND ms.ci_sequence_number = cp_uop_ci_sequence_number

Line 790: CURSOR c_mssua1 (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS

786: AND ms.cal_type = cp_uop_cal_type
787: AND ms.ci_sequence_number = cp_uop_ci_sequence_number
788: AND ms.sheet_number <> cp_ms_sequence_number
789: AND ms.grading_period_cd = p_grading_period_cd;
790: CURSOR c_mssua1 (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS
791: SELECT mssua.person_id
792: FROM igs_as_msht_su_atmpt mssua
793: WHERE mssua.sheet_number = cp_ms_sequence_number;
794: CURSOR c_mss (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS

Line 794: CURSOR c_mss (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS

790: CURSOR c_mssua1 (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS
791: SELECT mssua.person_id
792: FROM igs_as_msht_su_atmpt mssua
793: WHERE mssua.sheet_number = cp_ms_sequence_number;
794: CURSOR c_mss (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS
795: SELECT mss.sheet_number
796: FROM igs_as_mark_sheet mss
797: WHERE mss.sheet_number = cp_ms_sequence_number
798: FOR UPDATE OF duplicate_ind NOWAIT;

Line 796: FROM igs_as_mark_sheet mss

792: FROM igs_as_msht_su_atmpt mssua
793: WHERE mssua.sheet_number = cp_ms_sequence_number;
794: CURSOR c_mss (cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE) IS
795: SELECT mss.sheet_number
796: FROM igs_as_mark_sheet mss
797: WHERE mss.sheet_number = cp_ms_sequence_number
798: FOR UPDATE OF duplicate_ind NOWAIT;
799: CURSOR c_mssua2 (
800: cp_ms_mark_sheet IN igs_as_mark_sheet.sheet_number%TYPE,

Line 800: cp_ms_mark_sheet IN igs_as_mark_sheet.sheet_number%TYPE,

796: FROM igs_as_mark_sheet mss
797: WHERE mss.sheet_number = cp_ms_sequence_number
798: FOR UPDATE OF duplicate_ind NOWAIT;
799: CURSOR c_mssua2 (
800: cp_ms_mark_sheet IN igs_as_mark_sheet.sheet_number%TYPE,
801: cp_mssua1_person_id IN igs_as_msht_su_atmpt.person_id%TYPE
802: ) IS
803: SELECT sheet_number,
804: person_id,

Line 817: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL

813: FROM igs_as_msht_su_atmpt mssua2
814: WHERE mssua2.sheet_number = cp_ms_mark_sheet
815: AND mssua2.person_id = cp_mssua1_person_id;
816: CURSOR c_get_nxt_seq_no IS
817: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
818: FROM DUAL;
819: CURSOR c_get_nxt_grp_seq_no IS
820: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
821: FROM DUAL;

Line 820: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL

816: CURSOR c_get_nxt_seq_no IS
817: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
818: FROM DUAL;
819: CURSOR c_get_nxt_grp_seq_no IS
820: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
821: FROM DUAL;
822: ----------------------------------------ASSPL_INS_MSSUA_SORT--------------------
823: -- procedure used to mainly insert student records (orderd by
824: -- PERSON_ID/SURNAME) into MSSUA

Line 833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,

829: lp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
830: lp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,
834: lp_group_sequence_number IN igs_as_mark_sheet.group_sequence_number%TYPE,
835: lp_uoo_id IN NUMBER
836: ) IS
837: -- select the students to be included (where p_assess_cal_type is specified)

Line 834: lp_group_sequence_number IN igs_as_mark_sheet.group_sequence_number%TYPE,

830: lp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,
834: lp_group_sequence_number IN igs_as_mark_sheet.group_sequence_number%TYPE,
835: lp_uoo_id IN NUMBER
836: ) IS
837: -- select the students to be included (where p_assess_cal_type is specified)
838: -- in mark sheets and ORDER BY person_id

Line 1072: -- get the next IGS_AS_MARK_SHEET.group_sequence_number for the new mark sheet

1068: OR (p_sort_by NOT IN ('ID', 'SURNAME')) THEN
1069: p_group_sequence_number := NULL;
1070: RETURN FALSE;
1071: END IF;
1072: -- get the next IGS_AS_MARK_SHEET.group_sequence_number for the new mark sheet
1073: OPEN c_get_nxt_grp_seq_no;
1074: FETCH c_get_nxt_grp_seq_no INTO v_group_sequence_number;
1075: CLOSE c_get_nxt_grp_seq_no;
1076: -- select the mark sheets to produce based on the input parameters

Line 1078: -- store IGS_AS_MARK_SHEET.sheet_number and create mark sheet record

1074: FETCH c_get_nxt_grp_seq_no INTO v_group_sequence_number;
1075: CLOSE c_get_nxt_grp_seq_no;
1076: -- select the mark sheets to produce based on the input parameters
1077: FOR v_uop_rec IN c_uop (p_assess_cal_type, p_assess_sequence_number, p_teach_cal_type, p_teach_sequence_number) LOOP
1078: -- store IGS_AS_MARK_SHEET.sheet_number and create mark sheet record
1079: OPEN c_get_nxt_seq_no;
1080: FETCH c_get_nxt_seq_no INTO v_ms_sequence_number;
1081: CLOSE c_get_nxt_seq_no;
1082: DECLARE

Line 1088: igs_as_mark_sheet_pkg.insert_row (

1084: l_org_id NUMBER (15);
1085: BEGIN
1086: -- get org_id
1087: l_org_id := igs_ge_gen_003.get_org_id;
1088: igs_as_mark_sheet_pkg.insert_row (
1089: x_mode => 'R',
1090: x_rowid => l_rowid6,
1091: x_org_id => l_org_id,
1092: x_sheet_number => v_ms_sequence_number,

Line 1151: -- open cursor in which the update of IGS_AS_MARK_SHEET.duplicate_ind is based on

1147: EXIT;
1148: END LOOP;
1149: IF v_not_duplicate = FALSE THEN
1150: v_duplicate_sheet := TRUE;
1151: -- open cursor in which the update of IGS_AS_MARK_SHEET.duplicate_ind is based on
1152: -- if table is busy, update will be abandoned without waiting (NO_WAIT)
1153: OPEN c_mss (v_ms_sequence_number);
1154: FETCH c_mss INTO v_mss_mark_sheet;
1155: UPDATE igs_as_mark_sheet_all

Line 1155: UPDATE igs_as_mark_sheet_all

1151: -- open cursor in which the update of IGS_AS_MARK_SHEET.duplicate_ind is based on
1152: -- if table is busy, update will be abandoned without waiting (NO_WAIT)
1153: OPEN c_mss (v_ms_sequence_number);
1154: FETCH c_mss INTO v_mss_mark_sheet;
1155: UPDATE igs_as_mark_sheet_all
1156: SET duplicate_ind = 'Y'
1157: WHERE CURRENT OF c_mss;
1158: CLOSE c_mss;
1159: EXIT;

Line 1165: DELETE igs_as_mark_sheet_all

1161: END LOOP;
1162: END LOOP;
1163: IF v_ins_ms = TRUE THEN
1164: -- Delete sheets which were created but have no students.
1165: DELETE igs_as_mark_sheet_all
1166: WHERE group_sequence_number = v_group_sequence_number
1167: AND NOT EXISTS ( SELECT sheet_number
1168: FROM igs_as_msht_su_atmpt
1169: WHERE sheet_number = igs_as_mark_sheet_all.sheet_number);

Line 1169: WHERE sheet_number = igs_as_mark_sheet_all.sheet_number);

1165: DELETE igs_as_mark_sheet_all
1166: WHERE group_sequence_number = v_group_sequence_number
1167: AND NOT EXISTS ( SELECT sheet_number
1168: FROM igs_as_msht_su_atmpt
1169: WHERE sheet_number = igs_as_mark_sheet_all.sheet_number);
1170: p_group_sequence_number := v_group_sequence_number;
1171: RETURN TRUE;
1172: ELSE
1173: p_group_sequence_number := NULL;