APPS.IGS_RU_GEN_002 dependencies on IGS_RU_SET_MEMBER

Line 754: v_new_versions IGS_RU_SET_MEMBER.versions%TYPE;

750: v_lower NUMBER;
751: v_upper NUMBER;
752: vt_version t_number; /* array of version numbers */
753: v_max_ver NUMBER := 0;
754: v_new_versions IGS_RU_SET_MEMBER.versions%TYPE;
755: BEGIN
756: IF p_current_versions IS NULL OR
757: p_extra_versions IS NULL
758: THEN

Line 881: v_unit_cd IGS_RU_SET_MEMBER.unit_cd%TYPE;

877: p_unit IN VARCHAR2)
878: IS
879: v_unit VARCHAR2(200);
880: v_dot NUMBER;
881: v_unit_cd IGS_RU_SET_MEMBER.unit_cd%TYPE;
882: v_versions VARCHAR2(100); /* bigger to allow for spaces etc*/
883: v_current_versions IGS_RU_SET_MEMBER.versions%TYPE;
884: v_new_versions IGS_RU_SET_MEMBER.versions%TYPE;
885: X_ROWID VARCHAR2(25);

Line 883: v_current_versions IGS_RU_SET_MEMBER.versions%TYPE;

879: v_unit VARCHAR2(200);
880: v_dot NUMBER;
881: v_unit_cd IGS_RU_SET_MEMBER.unit_cd%TYPE;
882: v_versions VARCHAR2(100); /* bigger to allow for spaces etc*/
883: v_current_versions IGS_RU_SET_MEMBER.versions%TYPE;
884: v_new_versions IGS_RU_SET_MEMBER.versions%TYPE;
885: X_ROWID VARCHAR2(25);
886:
887: CURSOR C_RSMBR IS

Line 884: v_new_versions IGS_RU_SET_MEMBER.versions%TYPE;

880: v_dot NUMBER;
881: v_unit_cd IGS_RU_SET_MEMBER.unit_cd%TYPE;
882: v_versions VARCHAR2(100); /* bigger to allow for spaces etc*/
883: v_current_versions IGS_RU_SET_MEMBER.versions%TYPE;
884: v_new_versions IGS_RU_SET_MEMBER.versions%TYPE;
885: X_ROWID VARCHAR2(25);
886:
887: CURSOR C_RSMBR IS
888: SELECT ROWID, rsmbr.*

Line 889: FROM IGS_RU_SET_MEMBER rsmbr

885: X_ROWID VARCHAR2(25);
886:
887: CURSOR C_RSMBR IS
888: SELECT ROWID, rsmbr.*
889: FROM IGS_RU_SET_MEMBER rsmbr
890: WHERE rs_sequence_number = p_set_number
891: AND unit_cd = v_unit_cd;
892:
893: BEGIN

Line 919: IGS_RU_SET_MEMBER_PKG.INSERT_ROW (

915: v_versions := REPLACE(v_versions,']');
916: END IF;
917: IF v_unit_cd IS NOT NULL
918: THEN
919: IGS_RU_SET_MEMBER_PKG.INSERT_ROW (
920: X_ROWID => X_ROWID,
921: X_RS_SEQUENCE_NUMBER => p_set_number,
922: X_UNIT_CD => v_unit_cd,
923: X_VERSIONS => v_versions );

Line 930: FROM IGS_RU_SET_MEMBER

926: EXCEPTION
927: WHEN DUP_VAL_ON_INDEX THEN
928: SELECT versions
929: INTO v_current_versions
930: FROM IGS_RU_SET_MEMBER
931: WHERE rs_sequence_number = p_set_number
932: AND unit_cd = v_unit_cd;
933: /*
934: rationalise new versions with existing versions

Line 940: IGS_RU_SET_MEMBER_PKG.UPDATE_ROW (

936: */
937: v_new_versions := do_versions(v_current_versions,v_versions);
938:
939: FOR C_RSMBR_REC IN C_RSMBR LOOP
940: IGS_RU_SET_MEMBER_PKG.UPDATE_ROW (
941: X_ROWID => C_RSMBR_REC.ROWID,
942: X_RS_SEQUENCE_NUMBER => C_RSMBR_REC.RS_SEQUENCE_NUMBER,
943: X_UNIT_CD => C_RSMBR_REC.UNIT_CD ,
944: X_VERSIONS => v_new_versions );

Line 1275: FROM IGS_RU_SET_MEMBER rsmbr

1271:
1272:
1273: CURSOR c_rule_set_mbr(p_set_number IN IGS_RU_ITEM.SET_NUMBER%TYPE) IS
1274: SELECT rowid, rsmbr.*
1275: FROM IGS_RU_SET_MEMBER rsmbr
1276: WHERE rs_sequence_number =p_set_number;
1277:
1278:
1279: CURSOR C_rule_set (p_set_number IN IGS_RU_ITEM.SET_NUMBER%TYPE) IS

Line 1320: IGS_RU_SET_MEMBER_PKG.DELETE_ROW (X_ROWID => C_RULE_SET_MBR_REC.ROWID);

1316: /*
1317: remove set members
1318: */
1319: FOR c_rule_set_mbr_rec IN c_rule_set_mbr(c_rule_items_rec.set_number) LOOP
1320: IGS_RU_SET_MEMBER_PKG.DELETE_ROW (X_ROWID => C_RULE_SET_MBR_REC.ROWID);
1321: END LOOP;
1322:
1323: /*
1324: remove set