DBA Data[Home] [Help]

APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_GRD_SCHM

Line 2117: FROM igs_ps_unit_grd_schm

2113: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2114: AS
2115: CURSOR c_unit_grd_schm_det IS
2116: SELECT *
2117: FROM igs_ps_unit_grd_schm
2118: WHERE unit_code = p_unit_cd
2119: AND unit_version_number = p_version_number;
2120: v_unit_grading_schema_id igs_ps_unit_grd_schm.unit_grading_schema_id%TYPE;
2121: BEGIN

Line 2120: v_unit_grading_schema_id igs_ps_unit_grd_schm.unit_grading_schema_id%TYPE;

2116: SELECT *
2117: FROM igs_ps_unit_grd_schm
2118: WHERE unit_code = p_unit_cd
2119: AND unit_version_number = p_version_number;
2120: v_unit_grading_schema_id igs_ps_unit_grd_schm.unit_grading_schema_id%TYPE;
2121: BEGIN
2122:
2123: FOR c_unit_grd_schm_rec IN c_unit_grd_schm_det
2124: LOOP

Line 2126: igs_ps_unit_grd_schm_pkg.Insert_Row(

2122:
2123: FOR c_unit_grd_schm_rec IN c_unit_grd_schm_det
2124: LOOP
2125: x_rowid := NULL;
2126: igs_ps_unit_grd_schm_pkg.Insert_Row(
2127: x_rowid => x_rowid,
2128: x_unit_grading_schema_id => v_unit_grading_schema_id,
2129: x_unit_code => p_new_unit_cd,
2130: x_unit_version_number => p_new_version_number,