APPS.IGS_AS_SUAO_LGCY_PUB dependencies on IGS_AS_GRD_SCH_GRADE

Line 801: igs_as_grd_sch_grade ggs

797: IS
798: SELECT
799: 'X'
800: FROM
801: igs_as_grd_sch_grade ggs
802: WHERE
803: grading_schema_cd = p_lgcy_suo_rec.incomp_grading_schema_cd AND
804: version_number = p_lgcy_suo_rec.incomp_version_number AND
805: grade = p_lgcy_suo_rec.incomp_default_grade;

Line 857: igs_as_grd_sch_grade ggs

853: IS
854: SELECT
855: 'X'
856: FROM
857: igs_as_grd_sch_grade ggs
858: WHERE
859: grading_schema_cd = p_lgcy_suo_rec.incomp_grading_schema_cd AND
860: version_number = p_lgcy_suo_rec.incomp_version_number AND
861: grade = p_lgcy_suo_rec.incomp_default_grade AND

Line 1147: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE ,

1143:
1144:
1145: -- get the grade for the corresponding grading schem /version number at unitsection/unit level
1146: CURSOR cur_get_grade (
1147: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE ,
1148: cp_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE ,
1149: cp_grade IGS_AS_GRD_SCH_GRADE.GRADE%TYPE
1150: )
1151: IS

Line 1148: cp_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE ,

1144:
1145: -- get the grade for the corresponding grading schem /version number at unitsection/unit level
1146: CURSOR cur_get_grade (
1147: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE ,
1148: cp_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE ,
1149: cp_grade IGS_AS_GRD_SCH_GRADE.GRADE%TYPE
1150: )
1151: IS
1152: SELECT

Line 1149: cp_grade IGS_AS_GRD_SCH_GRADE.GRADE%TYPE

1145: -- get the grade for the corresponding grading schem /version number at unitsection/unit level
1146: CURSOR cur_get_grade (
1147: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE ,
1148: cp_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE ,
1149: cp_grade IGS_AS_GRD_SCH_GRADE.GRADE%TYPE
1150: )
1151: IS
1152: SELECT
1153: 'X'

Line 1155: igs_as_grd_sch_grade

1151: IS
1152: SELECT
1153: 'X'
1154: FROM
1155: igs_as_grd_sch_grade
1156: WHERE
1157: grading_schema_cd = cp_grading_schema_cd AND
1158: version_number = cp_version_number AND
1159: grade = cp_grade;

Line 1280: igs_as_grd_sch_grade ggs

1276: IS
1277: SELECT
1278: 'X'
1279: FROM
1280: igs_as_grd_sch_grade ggs
1281: WHERE
1282: grading_schema_cd = p_lgcy_suo_rec.grading_schema_cd AND
1283: version_number = p_lgcy_suo_rec.version_number AND
1284: s_result_type = 'INCOMP';

Line 1535: Check whether foreign key with table igs_as_grd_sch_grade exists.

1531: /*************************************** Validation 3 ******************************************/
1532: gen_log_info('Start of Validation 3');
1533:
1534: /*
1535: Check whether foreign key with table igs_as_grd_sch_grade exists.
1536: */
1537:
1538: IF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
1539: X_GRADING_SCHEMA_CD => p_lgcy_suo_rec.grading_schema_cd ,

Line 1538: IF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (

1534: /*
1535: Check whether foreign key with table igs_as_grd_sch_grade exists.
1536: */
1537:
1538: IF NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
1539: X_GRADING_SCHEMA_CD => p_lgcy_suo_rec.grading_schema_cd ,
1540: X_VERSION_NUMBER => p_lgcy_suo_rec.version_number ,
1541: X_GRADE => p_lgcy_suo_rec.grade
1542: )

Line 1545: Foreign key with the table igs_as_grd_sch_grade does not exists.

1541: X_GRADE => p_lgcy_suo_rec.grade
1542: )
1543: THEN
1544: /*
1545: Foreign key with the table igs_as_grd_sch_grade does not exists.
1546: Set an error message to stack and set x_return_status to 'E' and proceed
1547: to the next step
1548: */
1549: