APPS.IGS_PS_GEN_008 dependencies on IGS_AS_APPR_GRD_SCH

Line 2205: FROM igs_as_appr_grd_sch

2201: )
2202: AS
2203: CURSOR c_appr_grd_sch IS
2204: SELECT *
2205: FROM igs_as_appr_grd_sch
2206: WHERE unit_cd = p_unit_cd AND
2207: version_number = p_version_number AND
2208: closed_ind = 'N';
2209: CURSOR c_max_ver_grd_sch(

Line 2210: p_grading_schema_cd igs_as_appr_grd_sch.grading_schema_cd%TYPE)

2206: WHERE unit_cd = p_unit_cd AND
2207: version_number = p_version_number AND
2208: closed_ind = 'N';
2209: CURSOR c_max_ver_grd_sch(
2210: p_grading_schema_cd igs_as_appr_grd_sch.grading_schema_cd%TYPE)
2211: IS
2212: SELECT MAX(version_number)
2213: FROM igs_as_grd_schema
2214: WHERE grading_schema_cd = p_grading_schema_cd;

Line 2215: l_appr_grd_sch igs_as_appr_grd_sch%ROWTYPE;

2211: IS
2212: SELECT MAX(version_number)
2213: FROM igs_as_grd_schema
2214: WHERE grading_schema_cd = p_grading_schema_cd;
2215: l_appr_grd_sch igs_as_appr_grd_sch%ROWTYPE;
2216: l_max_ver_grd_sch igs_as_grd_schema.version_number%TYPE;
2217: l_message_name fnd_new_messages.message_name%TYPE;
2218: l_rowid VARCHAR(30);
2219:

Line 2237: igs_as_appr_grd_sch_pkg.insert_row(

2233: l_appr_grd_sch.grading_schema_cd,
2234: l_max_ver_grd_sch,
2235: l_message_name) THEN
2236: l_rowid := NULL;
2237: igs_as_appr_grd_sch_pkg.insert_row(
2238: x_rowid => l_rowid,
2239: x_unit_cd => p_new_unit_cd,
2240: x_version_number => p_new_version_number,
2241: x_assessment_type => l_appr_grd_sch.assessment_type,