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_PS_GEN_008 dependencies on IGS_PS_UNIT_FLD_STDY

Line 2160: FROM igs_ps_unit_fld_stdy

2156: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2157: AS
2158: CURSOR c_unit_fld_stdy_det IS
2159: SELECT *
2160: FROM igs_ps_unit_fld_stdy
2161: WHERE unit_code = p_unit_cd
2162: AND version_number = p_version_number;
2163: v_unit_field_of_study_id igs_ps_unit_fld_stdy.unit_field_of_study_id%TYPE;
2164: BEGIN

Line 2163: v_unit_field_of_study_id igs_ps_unit_fld_stdy.unit_field_of_study_id%TYPE;

2159: SELECT *
2160: FROM igs_ps_unit_fld_stdy
2161: WHERE unit_code = p_unit_cd
2162: AND version_number = p_version_number;
2163: v_unit_field_of_study_id igs_ps_unit_fld_stdy.unit_field_of_study_id%TYPE;
2164: BEGIN
2165:
2166: FOR c_unit_fld_stdy_rec IN c_unit_fld_stdy_det
2167: LOOP

Line 2169: igs_ps_unit_fld_stdy_pkg.Insert_Row(

2165:
2166: FOR c_unit_fld_stdy_rec IN c_unit_fld_stdy_det
2167: LOOP
2168: x_rowid := NULL;
2169: igs_ps_unit_fld_stdy_pkg.Insert_Row(
2170: x_rowid => x_rowid,
2171: x_unit_field_of_study_id => v_unit_field_of_study_id,
2172: x_unit_code => p_new_unit_cd,
2173: x_version_number => p_new_version_number,