APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 73: CURSOR c_grade_type (l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

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,
75: l_grade igs_as_grd_sch_grade.grade%TYPE) IS
76: SELECT 'X'
77: FROM igs_as_grd_sch_grade

Line 74: l_version_number igs_as_grd_sch_grade.version_number%TYPE,

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,
75: l_grade igs_as_grd_sch_grade.grade%TYPE) IS
76: SELECT 'X'
77: FROM igs_as_grd_sch_grade
78: WHERE grading_schema_cd = l_grading_schema_cd

Line 75: l_grade igs_as_grd_sch_grade.grade%TYPE) IS

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,
75: l_grade igs_as_grd_sch_grade.grade%TYPE) IS
76: SELECT 'X'
77: FROM igs_as_grd_sch_grade
78: WHERE grading_schema_cd = l_grading_schema_cd
79: AND version_number = l_version_number

Line 77: FROM igs_as_grd_sch_grade

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,
75: l_grade igs_as_grd_sch_grade.grade%TYPE) IS
76: SELECT 'X'
77: FROM igs_as_grd_sch_grade
78: WHERE grading_schema_cd = l_grading_schema_cd
79: AND version_number = l_version_number
80: and grade = l_grade
81: and s_result_type = 'INCOMP';

Line 661: ELSIF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (

657: OR (new_references.grade IS NULL)
658: )
659: ) THEN
660: NULL;
661: ELSIF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
662: new_references.grading_schema_cd,
663: new_references.version_number,
664: new_references.grade
665: ) THEN

Line 711: ELSIF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (

707: OR (new_references.translated_grade IS NULL)
708: )
709: ) THEN
710: NULL;
711: ELSIF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
712: new_references.translated_grading_schema_cd,
713: new_references.translated_version_number,
714: new_references.translated_grade
715: ) THEN

Line 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

815: END IF;
816: CLOSE cur_rowid;
817: END get_fk_igs_en_su_attempt;
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

Line 842: END get_fk_igs_as_grd_sch_grade;

838: app_exception.raise_exception;
839: RETURN;
840: END IF;
841: CLOSE cur_rowid;
842: END get_fk_igs_as_grd_sch_grade;
843:
844: PROCEDURE before_dml (
845: p_action IN VARCHAR2,
846: x_rowid IN VARCHAR2,

Line 915: FROM igs_as_grd_sch_grade gsg

911: AND sua.uoo_id = x_uoo_id;
912: l_sua_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
913: CURSOR c_gsg_result_type IS
914: SELECT gsg.s_result_type
915: FROM igs_as_grd_sch_grade gsg
916: WHERE gsg.grading_schema_cd = x_grading_schema_cd
917: AND gsg.version_number = x_version_number
918: AND gsg.grade = x_grade;
919: l_gsg_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

Line 919: l_gsg_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

915: FROM igs_as_grd_sch_grade gsg
916: WHERE gsg.grading_schema_cd = x_grading_schema_cd
917: AND gsg.version_number = x_version_number
918: AND gsg.grade = x_grade;
919: l_gsg_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
920: BEGIN
921: set_column_values (
922: p_action,
923: x_rowid,