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_SU_STMPTOUT_PKG dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 4: old_references igs_as_su_stmptout_all%ROWTYPE;

1: PACKAGE BODY igs_as_su_stmptout_pkg AS
2: /* $Header: IGSDI26B.pls 120.3 2006/05/26 11:52:41 ijeddy ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_su_stmptout_all%ROWTYPE;
5: new_references igs_as_su_stmptout_all%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,

Line 5: new_references igs_as_su_stmptout_all%ROWTYPE;

1: PACKAGE BODY igs_as_su_stmptout_pkg AS
2: /* $Header: IGSDI26B.pls 120.3 2006/05/26 11:52:41 ijeddy ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_su_stmptout_all%ROWTYPE;
5: new_references igs_as_su_stmptout_all%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,
9: x_org_id IN NUMBER,

Line 70: FROM igs_as_su_stmptout_all

66: x_show_on_academic_histry_flag IN VARCHAR2
67: ) AS
68: CURSOR cur_old_ref_values IS
69: SELECT *
70: FROM igs_as_su_stmptout_all
71: WHERE ROWID = x_rowid;
72:
73: CURSOR c_grade_type (l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
74: l_version_number igs_as_grd_sch_grade.version_number%TYPE,

Line 349: v_grade igs_as_su_stmptout_all.grade%TYPE;

345: -------------------------------------------------------------------------------------------
346: PROCEDURE afterrowinsertupdate2 (p_inserting IN BOOLEAN, p_updating IN BOOLEAN, p_deleting IN BOOLEAN) AS
347: v_message_name VARCHAR2 (30);
348: v_rowid_saved BOOLEAN := FALSE;
349: v_grade igs_as_su_stmptout_all.grade%TYPE;
350: CURSOR c_sua (
351: cp_person_id igs_en_su_attempt.person_id%TYPE,
352: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
353: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

Line 362: v_person_id igs_as_su_stmptout_all.person_id%TYPE;

358: WHERE sua.person_id = cp_person_id
359: AND sua.course_cd = cp_course_cd
360: AND sua.uoo_id = cp_uoo_id;
361: v_sua_rec c_sua%ROWTYPE;
362: v_person_id igs_as_su_stmptout_all.person_id%TYPE;
363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;
364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;

Line 363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;

359: AND sua.course_cd = cp_course_cd
360: AND sua.uoo_id = cp_uoo_id;
361: v_sua_rec c_sua%ROWTYPE;
362: v_person_id igs_as_su_stmptout_all.person_id%TYPE;
363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;
364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;

Line 364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;

360: AND sua.uoo_id = cp_uoo_id;
361: v_sua_rec c_sua%ROWTYPE;
362: v_person_id igs_as_su_stmptout_all.person_id%TYPE;
363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;
364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;

Line 365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;

361: v_sua_rec c_sua%ROWTYPE;
362: v_person_id igs_as_su_stmptout_all.person_id%TYPE;
363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;
364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;

Line 366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;

362: v_person_id igs_as_su_stmptout_all.person_id%TYPE;
363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;
364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;
370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;

Line 367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;

363: v_course_cd igs_as_su_stmptout_all.course_cd%TYPE;
364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;
370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;
371: v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;

Line 368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;

364: v_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE;
365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;
370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;
371: v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
372:

Line 369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;

365: v_cal_type igs_as_su_stmptout_all.cal_type%TYPE;
366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;
370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;
371: v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
372:
373: --

Line 370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;

366: v_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE;
367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;
370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;
371: v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
372:
373: --
374: -- Check if there is a transfer for Unit

Line 581: UPDATE igs_as_su_stmptout_all

577: app_exception.raise_exception;
578: END IF;
579: -- Not necessary to check for lock as in the process of insert/updating
580: -- anyway, so will already have a lock.
581: UPDATE igs_as_su_stmptout_all
582: SET translated_grading_schema_cd = v_translated_grading_schema_cd,
583: translated_version_number = v_translated_version_number,
584: translated_grade = v_translated_grade,
585: translated_dt = v_translated_dt

Line 736: FROM igs_as_su_stmptout_all

732: )
733: RETURN BOOLEAN AS
734: CURSOR cur_rowid IS
735: SELECT ROWID
736: FROM igs_as_su_stmptout_all
737: WHERE person_id = x_person_id
738: AND course_cd = x_course_cd
739: AND outcome_dt = x_outcome_dt
740: AND grading_period_cd = x_grading_period_cd

Line 759: FROM igs_as_su_stmptout_all

755:
756: PROCEDURE get_ufk_igs_ca_inst (x_cal_type IN VARCHAR2, x_sequence_number IN NUMBER, x_start_dt IN DATE, x_end_dt IN DATE) AS
757: CURSOR cur_rowid IS
758: SELECT ROWID
759: FROM igs_as_su_stmptout_all
760: WHERE cal_type = x_cal_type
761: AND ci_sequence_number = x_sequence_number
762: AND ci_start_dt = x_start_dt
763: AND ci_end_dt = x_end_dt;

Line 781: FROM igs_as_su_stmptout_all

777:
778: PROCEDURE get_fk_igs_lookups_view (x_s_grade_creation_method_type IN VARCHAR2) IS
779: CURSOR cur_rowid IS
780: SELECT ROWID
781: FROM igs_as_su_stmptout_all
782: WHERE s_grade_creation_method_type = x_s_grade_creation_method_type;
783: lv_rowid cur_rowid%ROWTYPE;
784: BEGIN
785: OPEN cur_rowid;

Line 800: FROM igs_as_su_stmptout_all

796:
797: PROCEDURE get_fk_igs_en_su_attempt (x_person_id IN NUMBER, x_course_cd IN VARCHAR2, x_uoo_id IN NUMBER) AS
798: CURSOR cur_rowid IS
799: SELECT ROWID
800: FROM igs_as_su_stmptout_all
801: WHERE person_id = x_person_id
802: AND course_cd = x_course_cd
803: AND uoo_id = x_uoo_id;
804: lv_rowid cur_rowid%ROWTYPE;

Line 822: FROM igs_as_su_stmptout_all

818:
819: PROCEDURE get_fk_igs_as_grd_sch_grade (x_grading_schema_cd IN VARCHAR2, x_version_number IN NUMBER, x_grade IN VARCHAR2) AS
820: CURSOR cur_rowid IS
821: SELECT ROWID
822: FROM igs_as_su_stmptout_all
823: WHERE translated_grading_schema_cd = x_grading_schema_cd
824: AND translated_version_number = x_version_number
825: AND translated_grade = x_grade
826: OR (grading_schema_cd = x_grading_schema_cd

Line 1122: FROM igs_as_su_stmptout_all

1118: x_show_on_academic_histry_flag IN VARCHAR2
1119: ) AS
1120: CURSOR c IS
1121: SELECT ROWID
1122: FROM igs_as_su_stmptout_all
1123: WHERE person_id = x_person_id
1124: AND course_cd = x_course_cd
1125: AND outcome_dt = x_outcome_dt
1126: AND grading_period_cd = x_grading_period_cd

Line 1230: INSERT INTO igs_as_su_stmptout_all

1226: );
1227: IF (x_mode = 'S') THEN
1228: igs_sc_gen_001.set_ctx('R');
1229: END IF;
1230: INSERT INTO igs_as_su_stmptout_all
1231: (org_id, person_id, course_cd, unit_cd,
1232: cal_type, ci_sequence_number, ci_start_dt,
1233: ci_end_dt, outcome_dt, grading_schema_cd,
1234: version_number, grade, s_grade_creation_method_type,

Line 1402: FROM igs_as_su_stmptout_all

1398: mark_capped_flag,
1399: release_date,
1400: manual_override_flag,
1401: show_on_academic_histry_flag
1402: FROM igs_as_su_stmptout_all
1403: WHERE ROWID = x_rowid
1404: FOR UPDATE NOWAIT;
1405: tlinfo c1%ROWTYPE;
1406: BEGIN

Line 1779: UPDATE igs_as_su_stmptout_all

1775: END IF;
1776: IF (x_mode = 'S') THEN
1777: igs_sc_gen_001.set_ctx('R');
1778: END IF;
1779: UPDATE igs_as_su_stmptout_all
1780: SET ci_start_dt = new_references.ci_start_dt,
1781: ci_end_dt = new_references.ci_end_dt,
1782: grading_schema_cd = new_references.grading_schema_cd,
1783: version_number = new_references.version_number,

Line 1918: FROM igs_as_su_stmptout_all

1914: x_show_on_academic_histry_flag IN VARCHAR2
1915: ) AS
1916: CURSOR c1 IS
1917: SELECT ROWID
1918: FROM igs_as_su_stmptout_all
1919: WHERE person_id = x_person_id
1920: AND course_cd = x_course_cd
1921: AND outcome_dt = x_outcome_dt
1922: AND grading_period_cd = x_grading_period_cd

Line 2054: DELETE FROM igs_as_su_stmptout_all

2050: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
2051: IF (x_mode = 'S') THEN
2052: igs_sc_gen_001.set_ctx('R');
2053: END IF;
2054: DELETE FROM igs_as_su_stmptout_all
2055: WHERE ROWID = x_rowid;
2056: IF (SQL%NOTFOUND) THEN
2057: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2058: igs_ge_msg_stack.add;