APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_REF_CD

Line 1062: v_unit_ref_cd_rec IGS_PS_UNIT_REF_CD%ROWTYPE;

1058: PROCEDURE crspl_ins_unit_ref_cd (
1059: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1060: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1061: AS
1062: v_unit_ref_cd_rec IGS_PS_UNIT_REF_CD%ROWTYPE;
1063: CURSOR c_unit_ref_cd_rec IS
1064: SELECT *
1065: FROM IGS_PS_UNIT_REF_CD
1066: WHERE unit_cd = p_unit_cd AND

Line 1065: FROM IGS_PS_UNIT_REF_CD

1061: AS
1062: v_unit_ref_cd_rec IGS_PS_UNIT_REF_CD%ROWTYPE;
1063: CURSOR c_unit_ref_cd_rec IS
1064: SELECT *
1065: FROM IGS_PS_UNIT_REF_CD
1066: WHERE unit_cd = p_unit_cd AND
1067: version_number = p_version_number;
1068: BEGIN
1069: FOR v_unit_ref_cd_rec IN c_unit_ref_cd_rec LOOP

Line 1072: IGS_PS_UNIT_REF_CD_PKG.Insert_Row(

1068: BEGIN
1069: FOR v_unit_ref_cd_rec IN c_unit_ref_cd_rec LOOP
1070: BEGIN
1071: x_rowid :=NULL;
1072: IGS_PS_UNIT_REF_CD_PKG.Insert_Row(
1073: X_ROWID => x_rowid,
1074: X_UNIT_CD => p_new_unit_cd,
1075: X_VERSION_NUMBER => p_new_version_number,
1076: X_REFERENCE_CD_TYPE => v_unit_ref_cd_rec.reference_cd_type,

Line 2348: --- Check if the IGS_PS_UNIT_REF_CD exists for the old IGS_PS_UNIT code and version

2344: --- substituted values.
2345: crspl_ins_crs_unit_lvl(
2346: p_old_unit_cd,
2347: p_old_version_number);
2348: --- Check if the IGS_PS_UNIT_REF_CD exists for the old IGS_PS_UNIT code and version
2349: --- number. If it does exist, create the new record with the substituted
2350: --- values.
2351: crspl_ins_unit_ref_cd(
2352: p_old_unit_cd,