APPS.IGS_RU_GEN_006 dependencies on IGS_RU_SET

Line 132: -- nsinha 10/9/2003 Bug#: 3193855 : Change the reference of igs_ru_set with igs_ru_description.

128: --nsinha 12-Mar-2002 Bug# 2233951: Modified the logic to
129: -- SELECT the next value of the sequence number
130: -- differently when the data is for SEED DB.
131: --
132: -- nsinha 10/9/2003 Bug#: 3193855 : Change the reference of igs_ru_set with igs_ru_description.
133: -- for CURSOR cur_max_plus_one.
134: -------------------------------------------------------------------
135: v_rud_sequence_number NUMBER;
136: v_count NUMBER DEFAULT 0;

Line 153: FROM igs_ru_description -- Changed By: Navin.Sinha On: 10/9/2003 Fix: Change the reference of igs_ru_set with igs_ru_description.

149: SELECT (sequence_number + 1) sequence_number
150: FROM igs_ru_description
151: WHERE sequence_number =
152: (SELECT MAX (sequence_number)
153: FROM igs_ru_description -- Changed By: Navin.Sinha On: 10/9/2003 Fix: Change the reference of igs_ru_set with igs_ru_description.
154: WHERE sequence_number < 499999)
155: FOR UPDATE OF sequence_number NOWAIT;
156: BEGIN
157: IF p_description_number IS NULL THEN

Line 410: p_set_number IN IGS_RU_SET.sequence_number%TYPE )

406: /*
407: return set string
408: */
409: FUNCTION show_set (
410: p_set_number IN IGS_RU_SET.sequence_number%TYPE )
411: RETURN VARCHAR2 IS
412: BEGIN DECLARE
413: v_more BOOLEAN;
414: v_set VARCHAR2(255);

Line 421: FROM IGS_RU_SET_MEMBER

417: v_set := '{';
418: FOR set_members IN (
419: SELECT unit_cd,
420: versions
421: FROM IGS_RU_SET_MEMBER
422: WHERE rs_sequence_number = p_set_number
423: ORDER BY unit_cd )
424: LOOP
425: IF v_more