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.

[Home] [Help]

APPS.IGS_PS_GEN_003 dependencies on IGS_PS_OFR_UNIT_SET

Line 208: -- in the IGS_PS_OFR_UNIT_SET table.

204: RETURN VARCHAR2 AS
205: lv_param_values VARCHAR2(1080);
206: BEGIN -- crsp_get_cous_ind
207: -- This module returns Y if the IGS_PS_COURSE offering and IGS_PS_UNIT set exists
208: -- in the IGS_PS_OFR_UNIT_SET table.
209: DECLARE
210:
211: v_dummy VARCHAR2(1);
212: CURSOR c_cous IS

Line 214: FROM IGS_PS_OFR_UNIT_SET cous

210:
211: v_dummy VARCHAR2(1);
212: CURSOR c_cous IS
213: SELECT 'X'
214: FROM IGS_PS_OFR_UNIT_SET cous
215: WHERE cous.course_cd = p_course_cd AND
216: cous.crv_version_number = p_crv_version_number AND
217: cous.cal_type = p_cal_type AND
218: cous.unit_set_cd = p_unit_set_cd;

Line 259: -- IGS_PS_UNIT set from the IGS_PS_OFR_UNIT_SET table.

255: RETURN VARCHAR2 AS
256: lv_param_values VARCHAR2(1080);
257: BEGIN -- crsp_get_cous_subind
258: -- This module fetches the value for the only_as_sub_ind for a IGS_PS_COURSE offering
259: -- IGS_PS_UNIT set from the IGS_PS_OFR_UNIT_SET table.
260: DECLARE
261:
262: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;
263: CURSOR c_cous IS

Line 262: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;

258: -- This module fetches the value for the only_as_sub_ind for a IGS_PS_COURSE offering
259: -- IGS_PS_UNIT set from the IGS_PS_OFR_UNIT_SET table.
260: DECLARE
261:
262: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;
263: CURSOR c_cous IS
264: SELECT cous.only_as_sub_ind
265: FROM IGS_PS_OFR_UNIT_SET cous
266: WHERE cous.course_cd = p_course_cd AND

Line 265: FROM IGS_PS_OFR_UNIT_SET cous

261:
262: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;
263: CURSOR c_cous IS
264: SELECT cous.only_as_sub_ind
265: FROM IGS_PS_OFR_UNIT_SET cous
266: WHERE cous.course_cd = p_course_cd AND
267: cous.crv_version_number = p_crv_version_number AND
268: cous.cal_type = p_cal_type AND
269: cous.unit_set_cd = p_unit_set_cd AND

Line 840: -- This module inserts a record into the IGS_PS_OFR_UNIT_SET table.

836: p_only_as_sub_ind IN VARCHAR2 DEFAULT 'N')
837: AS
838: lv_param_values VARCHAR2(1080);
839: BEGIN -- crsp_ins_cous
840: -- This module inserts a record into the IGS_PS_OFR_UNIT_SET table.
841: -- The routine is used by the defaulting mechanism for a IGS_EN_UNIT_SET. This is
842: -- invoked from the 'Apply IGS_PS_UNIT Set to IGS_PS_COURSE Offerings' form (ie: CRSF4210)
843: -- and applies the unit_set_in context to all IGS_PS_COURSE offerings selected via
844: -- the screen.

Line 853: FROM IGS_PS_OFR_UNIT_SET cous

849: v_show_on_official_ntfctn_ind VARCHAR2(1);
850: v_dummy VARCHAR2(1);
851: CURSOR c_cous IS
852: SELECT 'X'
853: FROM IGS_PS_OFR_UNIT_SET cous
854: WHERE cous.course_cd = p_course_cd AND
855: cous.crv_version_number = p_crv_version_number AND
856: cous.cal_type = p_cal_type AND
857: cous.unit_set_cd = p_unit_set_cd AND

Line 876: IGS_PS_OFR_UNIT_SET_Pkg.Insert_Row(

872: FETCH c_cous INTO v_dummy;
873: IF (c_cous%NOTFOUND) THEN
874: CLOSE c_cous;
875:
876: IGS_PS_OFR_UNIT_SET_Pkg.Insert_Row(
877: X_ROWID => x_rowid,
878: X_COURSE_CD => p_course_cd,
879: X_CRV_VERSION_NUMBER => p_crv_version_number,
880: X_CAL_TYPE => p_cal_type,