APPS.IGS_RU_GEN_002 dependencies on IGS_RU_RET_TYPE

Line 42: IGS_RU_RET_TYPE.s_return_type%TYPE

38: TYPE t_LOV IS TABLE OF
39: r_LOV
40: INDEX BY BINARY_INTEGER;
41: TYPE t_param_list IS TABLE OF
42: IGS_RU_RET_TYPE.s_return_type%TYPE
43: INDEX BY BINARY_INTEGER;
44:
45: /*
46: CONSTANTS

Line 76: gv_param_type IGS_RU_RET_TYPE.s_return_type%TYPE;

72: list of parameter return types
73: */
74: gt_param_list t_param_list;
75: gv_params NUMBER;
76: gv_param_type IGS_RU_RET_TYPE.s_return_type%TYPE;
77: /*
78: string termiate character
79: */
80: gv_string_terminate VARCHAR2(10);

Line 1142: FROM IGS_RU_RET_TYPE

1138: p_string := p_description;
1139: ELSE
1140: FOR return_types IN (
1141: SELECT s_return_type
1142: FROM IGS_RU_RET_TYPE
1143: WHERE s_return_type LIKE SUBSTR(p_description,v_hash + 1,1)||'%'
1144: ORDER BY s_return_type DESC )
1145: LOOP
1146: IF SUBSTR(p_description,v_hash + 1,LENGTH(return_types.s_return_type))

Line 1174: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;

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;
1178: WHILE breakdown_desc(v_string,v_action,v_rule_description)

Line 1199: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;

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;
1203: WHILE breakdown_desc(v_string,v_action,v_rule_description)

Line 1220: p_return_type IGS_RU_RET_TYPE.s_return_type%TYPE )

1216: check if this parameter type is allowed
1217:
1218: */
1219: FUNCTION valid_param_type (
1220: p_return_type IGS_RU_RET_TYPE.s_return_type%TYPE )
1221: RETURN BOOLEAN IS
1222: BEGIN
1223: FOR v_ii IN 1 .. gv_params
1224: LOOP

Line 1238: p_return_type IGS_RU_RET_TYPE.s_return_type%TYPE,

1234: check if this parameter is of valid type
1235:
1236: */
1237: FUNCTION valid_param (
1238: p_return_type IGS_RU_RET_TYPE.s_return_type%TYPE,
1239: p_param NUMBER )
1240: RETURN BOOLEAN IS
1241: BEGIN
1242: IF gt_param_list(p_param) = p_return_type

Line 1546: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;

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;
1550: v_first BOOLEAN;

Line 1720: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;

1716: RETURN BOOLEAN IS
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;

Line 1727: v_type IGS_RU_RET_TYPE.s_return_type%TYPE;

1723: v_return BOOLEAN;
1724: v_item NUMBER;
1725: v_new_rule NUMBER;
1726: v_new_item NUMBER;
1727: v_type IGS_RU_RET_TYPE.s_return_type%TYPE;
1728: v_evaluate BOOLEAN;
1729: v_number NUMBER;
1730: v_set_type IGS_RU_SET.set_type%TYPE;
1731: v_next_action IGS_RU_RET_TYPE.s_return_type%TYPE;

Line 1731: v_next_action IGS_RU_RET_TYPE.s_return_type%TYPE;

1727: v_type IGS_RU_RET_TYPE.s_return_type%TYPE;
1728: v_evaluate BOOLEAN;
1729: v_number NUMBER;
1730: v_set_type IGS_RU_SET.set_type%TYPE;
1731: v_next_action IGS_RU_RET_TYPE.s_return_type%TYPE;
1732: BEGIN
1733: /*
1734: special actions
1735: */