eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RU_GEN_002 dependencies on IGS_RU_ITEM

Line 1259: p_item IN IGS_RU_ITEM.item%TYPE)

1255:
1256: */
1257: PROCEDURE delete_rule_items(
1258: p_rule_number IN IGS_RU_RULE.sequence_number%TYPE,
1259: p_item IN IGS_RU_ITEM.item%TYPE)
1260: IS
1261: CURSOR c_rule_items IS
1262: SELECT rowid, ri.*
1263: FROM IGS_RU_ITEM ri

Line 1263: FROM IGS_RU_ITEM ri

1259: p_item IN IGS_RU_ITEM.item%TYPE)
1260: IS
1261: CURSOR c_rule_items IS
1262: SELECT rowid, ri.*
1263: FROM IGS_RU_ITEM ri
1264: WHERE rul_sequence_number = p_rule_number
1265: AND item >= p_item ;
1266:
1267: CURSOR c_rule (p_rule_number IN IGS_RU_ITEM.RULE_NUMBER%TYPE) IS

Line 1267: CURSOR c_rule (p_rule_number IN IGS_RU_ITEM.RULE_NUMBER%TYPE) IS

1263: FROM IGS_RU_ITEM ri
1264: WHERE rul_sequence_number = p_rule_number
1265: AND item >= p_item ;
1266:
1267: CURSOR c_rule (p_rule_number IN IGS_RU_ITEM.RULE_NUMBER%TYPE) IS
1268: SELECT rowid, rule.*
1269: FROM IGS_RU_RULE rule
1270: WHERE sequence_number = p_rule_number;
1271:

Line 1273: CURSOR c_rule_set_mbr(p_set_number IN IGS_RU_ITEM.SET_NUMBER%TYPE) IS

1269: FROM IGS_RU_RULE rule
1270: WHERE sequence_number = p_rule_number;
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:

Line 1279: CURSOR C_rule_set (p_set_number IN IGS_RU_ITEM.SET_NUMBER%TYPE) IS

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
1280: SELECT rowid, rs.*
1281: FROM IGS_RU_SET rs
1282: WHERE sequence_number = p_set_number;
1283:

Line 1288: IGS_RU_ITEM_PKG.DELETE_ROW (

1284:
1285: BEGIN
1286: FOR c_rule_items_REC IN c_rule_items LOOP
1287:
1288: IGS_RU_ITEM_PKG.DELETE_ROW (
1289: X_ROWID => C_RULE_ITEMS_REC.ROWID );
1290:
1291: IF c_rule_items_rec.rule_number IS NOT NULL
1292: THEN

Line 1343: p_turin_function IN IGS_RU_ITEM.turin_function%TYPE,

1339: PROCEDURE make_rule_item(
1340: p_from IN VARCHAR2,
1341: p_rule_num IN NUMBER,
1342: p_item IN OUT NOCOPY NUMBER,
1343: p_turin_function IN IGS_RU_ITEM.turin_function%TYPE,
1344: p_rud_seq_num IN IGS_RU_DESCRIPTION.sequence_number%TYPE,
1345: p_rule_number IN IGS_RU_ITEM.rule_number%TYPE,
1346: p_set_number IN IGS_RU_ITEM.set_number%TYPE,
1347: p_value IN IGS_RU_ITEM.value%TYPE)

Line 1345: p_rule_number IN IGS_RU_ITEM.rule_number%TYPE,

1341: p_rule_num IN NUMBER,
1342: p_item IN OUT NOCOPY NUMBER,
1343: p_turin_function IN IGS_RU_ITEM.turin_function%TYPE,
1344: p_rud_seq_num IN IGS_RU_DESCRIPTION.sequence_number%TYPE,
1345: p_rule_number IN IGS_RU_ITEM.rule_number%TYPE,
1346: p_set_number IN IGS_RU_ITEM.set_number%TYPE,
1347: p_value IN IGS_RU_ITEM.value%TYPE)
1348: IS
1349: BEGIN DECLARE

Line 1346: p_set_number IN IGS_RU_ITEM.set_number%TYPE,

1342: p_item IN OUT NOCOPY NUMBER,
1343: p_turin_function IN IGS_RU_ITEM.turin_function%TYPE,
1344: p_rud_seq_num IN IGS_RU_DESCRIPTION.sequence_number%TYPE,
1345: p_rule_number IN IGS_RU_ITEM.rule_number%TYPE,
1346: p_set_number IN IGS_RU_ITEM.set_number%TYPE,
1347: p_value IN IGS_RU_ITEM.value%TYPE)
1348: IS
1349: BEGIN DECLARE
1350: v_named_rule IGS_RU_ITEM.named_rule%TYPE;

Line 1347: p_value IN IGS_RU_ITEM.value%TYPE)

1343: p_turin_function IN IGS_RU_ITEM.turin_function%TYPE,
1344: p_rud_seq_num IN IGS_RU_DESCRIPTION.sequence_number%TYPE,
1345: p_rule_number IN IGS_RU_ITEM.rule_number%TYPE,
1346: p_set_number IN IGS_RU_ITEM.set_number%TYPE,
1347: p_value IN IGS_RU_ITEM.value%TYPE)
1348: IS
1349: BEGIN DECLARE
1350: v_named_rule IGS_RU_ITEM.named_rule%TYPE;
1351: v_value IGS_RU_ITEM.value%TYPE;

Line 1350: v_named_rule IGS_RU_ITEM.named_rule%TYPE;

1346: p_set_number IN IGS_RU_ITEM.set_number%TYPE,
1347: p_value IN IGS_RU_ITEM.value%TYPE)
1348: IS
1349: BEGIN DECLARE
1350: v_named_rule IGS_RU_ITEM.named_rule%TYPE;
1351: v_value IGS_RU_ITEM.value%TYPE;
1352: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1353: X_ROWID VARCHAR2(25);
1354: BEGIN

Line 1351: v_value IGS_RU_ITEM.value%TYPE;

1347: p_value IN IGS_RU_ITEM.value%TYPE)
1348: IS
1349: BEGIN DECLARE
1350: v_named_rule IGS_RU_ITEM.named_rule%TYPE;
1351: v_value IGS_RU_ITEM.value%TYPE;
1352: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1353: X_ROWID VARCHAR2(25);
1354: BEGIN
1355: IF p_generate_rule = FALSE

Line 1400: IGS_RU_ITEM_PKG.INSERT_ROW (

1396: END IF;
1397: v_named_rule := NULL;
1398: END;
1399: END IF;
1400: IGS_RU_ITEM_PKG.INSERT_ROW (
1401: X_ROWID => X_ROWID,
1402: X_RUL_SEQUENCE_NUMBER => p_rule_num,
1403: X_ITEM => p_item,
1404: X_TURIN_FUNCTION => p_turin_function,