APPS.IGS_RU_GEN_002 dependencies on IGS_PS_VER

Line 627: v_member_cd IGS_PS_VER.course_cd%TYPE := '%4@!)^';

623: RETURN BOOLEAN IS
624: v_char VARCHAR2(1);
625: v_count NUMBER;
626: v_no_members BOOLEAN := TRUE;
627: v_member_cd IGS_PS_VER.course_cd%TYPE := '%4@!)^';
628: v_max_count NUMBER;
629: BEGIN
630: consume_leading_spaces(p_rule);
631: FOR v_ii IN 1 .. 200 /*LENGTH(p_rule) */

Line 656: FROM IGS_PS_VER

652: count the number of members selected, remember their might be wildcards
653: */
654: SELECT count(*)
655: INTO v_count
656: FROM IGS_PS_VER
657: /*WHERE course_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1));--Bug 2395891/2543627 --space not accepted in user defined rules*/
658: WHERE course_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1));--nshee
659: IF v_count = 0
660: THEN

Line 666: FROM IGS_PS_VER

662: check if to many selected set members (1000)
663: */
664: SELECT count(*)
665: INTO v_max_count
666: FROM IGS_PS_VER
667: /*WHERE course_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1))||'%';--Bug 2395891/2543627 --space not accepted in user defined rules*/
668: WHERE course_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1))||'%';--nshee
669: IF v_max_count > 1000
670: THEN

Line 685: FROM IGS_PS_VER

681: SELECT course_cd,
682: version_number,
683: course_status,
684: short_title
685: FROM IGS_PS_VER
686: /*WHERE course_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1))||'%'--Bug 2395891/2543627 --space not accepted in user defined rules*/
687: WHERE course_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1))||'%'--nshee
688: ORDER BY course_cd,version_number DESC )
689: LOOP