APPS.IGS_RU_GEN_006 dependencies on IGS_RU_ITEM

Line 497: p_rule_number IN IGS_RU_ITEM.rul_sequence_number%TYPE,

493: /*
494: Convert the stored IGS_RU_RULE into a readable form
495: */
496: FUNCTION display_rule (
497: p_rule_number IN IGS_RU_ITEM.rul_sequence_number%TYPE,
498: p_rule_item IN OUT NOCOPY IGS_RU_ITEM.item%TYPE )
499: RETURN VARCHAR2 IS
500: BEGIN DECLARE
501: v_rule VARCHAR2(2000);

Line 498: p_rule_item IN OUT NOCOPY IGS_RU_ITEM.item%TYPE )

494: Convert the stored IGS_RU_RULE into a readable form
495: */
496: FUNCTION display_rule (
497: p_rule_number IN IGS_RU_ITEM.rul_sequence_number%TYPE,
498: p_rule_item IN OUT NOCOPY IGS_RU_ITEM.item%TYPE )
499: RETURN VARCHAR2 IS
500: BEGIN DECLARE
501: v_rule VARCHAR2(2000);
502: v_rule_item IGS_RU_ITEM.item%TYPE;

Line 502: v_rule_item IGS_RU_ITEM.item%TYPE;

498: p_rule_item IN OUT NOCOPY IGS_RU_ITEM.item%TYPE )
499: RETURN VARCHAR2 IS
500: BEGIN DECLARE
501: v_rule VARCHAR2(2000);
502: v_rule_item IGS_RU_ITEM.item%TYPE;
503: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
504: v_parenthesis_ind IGS_RU_DESCRIPTION.parenthesis_ind%TYPE;
505: v_action IGS_RU_DESCRIPTION.s_return_type%TYPE;
506: v_display IGS_RU_DESCRIPTION.rule_description%TYPE;

Line 517: FROM IGS_RU_ITEM

513: rule_number,
514: derived_rule,
515: set_number,
516: value
517: FROM IGS_RU_ITEM
518: WHERE rul_sequence_number = p_rule_number
519: AND item > p_rule_item
520: ORDER BY item ASC )
521: LOOP

Line 616: v_rule_item IGS_RU_ITEM.item%TYPE := -1;

612: Rulp_Get_Rule
613: */
614: BEGIN
615: DECLARE
616: v_rule_item IGS_RU_ITEM.item%TYPE := -1;
617: BEGIN
618: /*
619: return IGS_RU_RULE, replace internal spaces for real spaces
620: */