APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_LVL

Line 1011: v_crs_unit_lvl_rec IGS_PS_UNIT_LVL%ROWTYPE;

1007: PROCEDURE crspl_ins_crs_unit_lvl (
1008: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1009: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1010: AS
1011: v_crs_unit_lvl_rec IGS_PS_UNIT_LVL%ROWTYPE;
1012: CURSOR c_crs_unit_lvl_rec IS
1013: SELECT *
1014: FROM IGS_PS_UNIT_LVL
1015: WHERE unit_cd = p_unit_cd AND

Line 1014: FROM IGS_PS_UNIT_LVL

1010: AS
1011: v_crs_unit_lvl_rec IGS_PS_UNIT_LVL%ROWTYPE;
1012: CURSOR c_crs_unit_lvl_rec IS
1013: SELECT *
1014: FROM IGS_PS_UNIT_LVL
1015: WHERE unit_cd = p_unit_cd AND
1016: version_number = p_version_number;
1017:
1018: l_org_id NUMBER(15);

Line 1027: IGS_PS_UNIT_LVL_PKG.Insert_Row(

1023: x_rowid := NULL;
1024:
1025: l_org_id := igs_ge_gen_003.get_org_id;
1026: -- ijeddy, Bug# 3181938 removed course_type from the parameters.
1027: IGS_PS_UNIT_LVL_PKG.Insert_Row(
1028: X_ROWID => x_rowid,
1029: X_UNIT_CD => p_new_unit_cd,
1030: X_VERSION_NUMBER => p_new_version_number,
1031: X_UNIT_LEVEL => v_crs_unit_lvl_rec.unit_level,

Line 2342: --- Check if the IGS_PS_UNIT_LVL record exists for the old IGS_PS_UNIT code and

2338: --- substituted values.
2339: crspl_ins_unit_categorisation(
2340: p_old_unit_cd,
2341: p_old_version_number);
2342: --- Check if the IGS_PS_UNIT_LVL record exists for the old IGS_PS_UNIT code and
2343: --- version number. If it does exist, create the new record with the
2344: --- substituted values.
2345: crspl_ins_crs_unit_lvl(
2346: p_old_unit_cd,