APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_DSCP

Line 924: v_unit_discipline_rec IGS_PS_UNIT_DSCP%ROWTYPE;

920: PROCEDURE crspl_ins_unit_discipline (
921: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
922: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
923: AS
924: v_unit_discipline_rec IGS_PS_UNIT_DSCP%ROWTYPE;
925: CURSOR c_unit_discipline_rec IS
926: SELECT *
927: FROM IGS_PS_UNIT_DSCP
928: WHERE unit_cd = p_unit_cd AND

Line 927: FROM IGS_PS_UNIT_DSCP

923: AS
924: v_unit_discipline_rec IGS_PS_UNIT_DSCP%ROWTYPE;
925: CURSOR c_unit_discipline_rec IS
926: SELECT *
927: FROM IGS_PS_UNIT_DSCP
928: WHERE unit_cd = p_unit_cd AND
929: version_number = p_version_number;
930:
931: BEGIN

Line 935: IGS_PS_UNIT_DSCP_PKG.Insert_Row(

931: BEGIN
932: FOR v_unit_discipline_rec IN c_unit_discipline_rec LOOP
933: BEGIN
934: x_rowid := NULL;
935: IGS_PS_UNIT_DSCP_PKG.Insert_Row(
936: X_ROWID => x_rowid,
937: X_UNIT_CD => p_new_unit_cd,
938: X_VERSION_NUMBER => p_new_version_number,
939: X_DISCIPLINE_GROUP_CD => v_unit_discipline_rec.discipline_group_cd,

Line 2330: --- Check if the IGS_PS_UNIT_DSCP record exists for the old IGS_PS_UNIT code and

2326: --- substituted values.
2327: crspl_ins_teach_resp(
2328: p_old_unit_cd,
2329: p_old_version_number);
2330: --- Check if the IGS_PS_UNIT_DSCP record exists for the old IGS_PS_UNIT code and
2331: --- version number. If it does exist, create the new record with the
2332: --- substituted values.
2333: crspl_ins_unit_discipline(
2334: p_old_unit_cd,