APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_CATEGORY

Line 965: v_unit_cat_rec IGS_PS_UNIT_CATEGORY%ROWTYPE;

961: PROCEDURE crspl_ins_unit_categorisation (
962: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
963: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
964: AS
965: v_unit_cat_rec IGS_PS_UNIT_CATEGORY%ROWTYPE;
966: CURSOR c_unit_cat_rec IS
967: SELECT *
968: FROM IGS_PS_UNIT_CATEGORY
969: WHERE unit_cd = p_unit_cd AND

Line 968: FROM IGS_PS_UNIT_CATEGORY

964: AS
965: v_unit_cat_rec IGS_PS_UNIT_CATEGORY%ROWTYPE;
966: CURSOR c_unit_cat_rec IS
967: SELECT *
968: FROM IGS_PS_UNIT_CATEGORY
969: WHERE unit_cd = p_unit_cd AND
970: version_number = p_version_number;
971:
972: l_org_id NUMBER(15);

Line 980: IGS_PS_UNIT_CATEGORY_PKG.Insert_Row(

976: BEGIN
977: x_rowid := NULL;
978: l_org_id := igs_ge_gen_003.get_org_id;
979:
980: IGS_PS_UNIT_CATEGORY_PKG.Insert_Row(
981: X_ROWID => x_rowid,
982: X_UNIT_CD => p_new_unit_cd,
983: X_VERSION_NUMBER => p_new_version_number,
984: X_UNIT_CAT => v_unit_cat_rec.unit_cat,

Line 2336: --- Check if the IGS_PS_UNIT_CATEGORY record exists for the old IGS_PS_UNIT code and

2332: --- substituted values.
2333: crspl_ins_unit_discipline(
2334: p_old_unit_cd,
2335: p_old_version_number);
2336: --- Check if the IGS_PS_UNIT_CATEGORY record exists for the old IGS_PS_UNIT code and
2337: --- version number. If it does exist, create the new record with the
2338: --- substituted values.
2339: crspl_ins_unit_categorisation(
2340: p_old_unit_cd,