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_DESCRIPTION

Line 35: select_item IGS_RU_DESCRIPTION.rule_description%TYPE,

31: TYPE t_number IS TABLE OF
32: NUMBER(6)
33: INDEX BY BINARY_INTEGER;
34: TYPE r_LOV IS RECORD (
35: select_item IGS_RU_DESCRIPTION.rule_description%TYPE,
36: description VARCHAR2(2000),
37: selectable VARCHAR2(1) );
38: TYPE t_LOV IS TABLE OF
39: r_LOV

Line 1067: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;

1063: p_string IN VARCHAR2,
1064: p_rule IN OUT NOCOPY VARCHAR2)
1065: RETURN BOOLEAN IS
1066: BEGIN DECLARE
1067: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1068: v_string_length NUMBER;
1069: v_sub_rule IGS_RU_DESCRIPTION.rule_description%TYPE;
1070: BEGIN
1071: IF p_rule IS NULL

Line 1069: v_sub_rule IGS_RU_DESCRIPTION.rule_description%TYPE;

1065: RETURN BOOLEAN IS
1066: BEGIN DECLARE
1067: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1068: v_string_length NUMBER;
1069: v_sub_rule IGS_RU_DESCRIPTION.rule_description%TYPE;
1070: BEGIN
1071: IF p_rule IS NULL
1072: THEN
1073: RETURN FALSE;

Line 1118: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,

1114: return FALSE if description is NULL
1115:
1116: */
1117: FUNCTION breakdown_desc (
1118: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
1119: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
1120: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
1121: RETURN BOOLEAN IS
1122: BEGIN DECLARE

Line 1119: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,

1115:
1116: */
1117: FUNCTION breakdown_desc (
1118: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
1119: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
1120: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
1121: RETURN BOOLEAN IS
1122: BEGIN DECLARE
1123: v_hash NUMBER;

Line 1120: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )

1116: */
1117: FUNCTION breakdown_desc (
1118: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
1119: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
1120: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
1121: RETURN BOOLEAN IS
1122: BEGIN DECLARE
1123: v_hash NUMBER;
1124: BEGIN

Line 1172: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;

1168: FUNCTION count_params(
1169: p_rule_description IN VARCHAR2)
1170: RETURN NUMBER IS
1171: BEGIN DECLARE
1172: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1173: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1174: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1175: v_count NUMBER := 0;
1176: BEGIN

Line 1173: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;

1169: p_rule_description IN VARCHAR2)
1170: RETURN NUMBER IS
1171: BEGIN DECLARE
1172: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1173: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1174: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1175: v_count NUMBER := 0;
1176: BEGIN
1177: v_rule_description := p_rule_description;

Line 1197: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;

1193: FUNCTION set_params(
1194: p_rule_description IN VARCHAR2)
1195: RETURN NUMBER IS
1196: BEGIN DECLARE
1197: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1198: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1199: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1200: v_count NUMBER := 0;
1201: BEGIN

Line 1198: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;

1194: p_rule_description IN VARCHAR2)
1195: RETURN NUMBER IS
1196: BEGIN DECLARE
1197: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1198: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1199: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1200: v_count NUMBER := 0;
1201: BEGIN
1202: v_rule_description := p_rule_description;

Line 1344: p_rud_seq_num IN IGS_RU_DESCRIPTION.sequence_number%TYPE,

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)
1348: IS

Line 1352: v_rule_description IGS_RU_DESCRIPTION.rule_description%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
1356: THEN

Line 1379: FROM IGS_RU_DESCRIPTION

1375: set number of parameters for called RULE
1376: */
1377: SELECT rule_description
1378: INTO v_rule_description
1379: FROM IGS_RU_DESCRIPTION
1380: WHERE sequence_number = p_rud_seq_num;
1381: v_value := count_params(v_rule_description);
1382: /*
1383: add evaluate RULE item

Line 1545: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;

1541: p_item IN OUT NOCOPY NUMBER)
1542: RETURN BOOLEAN IS
1543: BEGIN DECLARE
1544: v_rule VARCHAR2(2000);
1545: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1546: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1547: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1548: v_number NUMBER;
1549: v_item NUMBER;

Line 1547: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;

1543: BEGIN DECLARE
1544: v_rule VARCHAR2(2000);
1545: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
1546: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1547: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1548: v_number NUMBER;
1549: v_item NUMBER;
1550: v_first BOOLEAN;
1551: BEGIN

Line 1568: FROM IGS_RU_DESCRIPTION RUD,

1564: SELECT RUD.sequence_number,
1565: s_turin_function,
1566: rule_description,
1567: description
1568: FROM IGS_RU_DESCRIPTION RUD,
1569: IGS_RU_GROUP_SET RGS
1570: WHERE s_return_type = p_type
1571: AND rule_description NOT LIKE '#'||p_type||'%'
1572: AND RUD.sequence_number = RGS.rud_sequence_number

Line 1721: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;

1717: BEGIN DECLARE
1718: v_rule VARCHAR2(2000);
1719: v_string VARCHAR2(2000);
1720: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1721: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
1722: v_first_action BOOLEAN;
1723: v_return BOOLEAN;
1724: v_item NUMBER;
1725: v_new_rule NUMBER;

Line 1911: FROM IGS_RU_DESCRIPTION RUD,

1907: SELECT RUD.sequence_number,
1908: s_turin_function,
1909: rule_description,
1910: description
1911: FROM IGS_RU_DESCRIPTION RUD,
1912: IGS_RU_GROUP_SET RGS
1913: WHERE s_return_type = p_type
1914: AND rule_description LIKE '#'||p_type||'%'
1915: AND RUD.sequence_number = RGS.rud_sequence_number