APPS.IGS_RU_GEN_002 dependencies on IGS_EN_UNIT_SET

Line 511: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE := '#@*&!Vv9(';

507: BEGIN DECLARE
508: v_char VARCHAR2(1);
509: v_count NUMBER;
510: v_no_units BOOLEAN := TRUE;
511: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE := '#@*&!Vv9(';
512: v_max_count NUMBER;
513: BEGIN
514: consume_leading_spaces(p_rule);
515: FOR v_ii IN 1 .. 200

Line 539: FROM IGS_EN_UNIT_SET

535: count the number of UNIT sets selected, remember their might be wildcards
536: */
537: SELECT count(*)
538: INTO v_count
539: FROM IGS_EN_UNIT_SET
540: /* WHERE unit_set_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1)); commented by nshee as part of fix of bug 2381638 and 2395891 and added the next line */
541: WHERE unit_set_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1));
542: IF v_count = 0
543: THEN

Line 549: FROM IGS_EN_UNIT_SET

545: check if to many selected set members (1000)
546: */
547: SELECT count(*)
548: INTO v_max_count
549: FROM IGS_EN_UNIT_SET
550: /*WHERE unit_set_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1))||'%';--Bug 2395891/2543627 --space not accepted in user defined rules*/
551: WHERE unit_set_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1))||'%';--nshee
552: IF v_max_count > 1000
553: THEN

Line 568: FROM IGS_EN_UNIT_SET

564: SELECT unit_set_cd,
565: version_number,
566: unit_set_status,
567: short_title
568: FROM IGS_EN_UNIT_SET
569: /*WHERE unit_set_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1))||'%'--Bug 2395891/2543627 --space not accepted in user defined rules*/
570: WHERE unit_set_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1))||'%'--nshee
571: ORDER BY unit_set_cd,version_number DESC )
572: LOOP