APPS.IGS_RU_GEN_002 dependencies on IGS_PS_UNIT_VER

Line 393: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE := '%4$@G!))^';

389: RETURN BOOLEAN IS
390: v_char VARCHAR2(1);
391: v_count NUMBER;
392: v_no_units BOOLEAN := TRUE;
393: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE := '%4$@G!))^';
394: v_max_count NUMBER;
395: BEGIN
396: gv_select_count := 0;
397: consume_leading_spaces(p_rule);

Line 419: FROM IGS_PS_UNIT_VER

415: ELSE
416: /* count the number of units selected, remember their might be wildcards*/
417: SELECT count(*)
418: INTO v_count
419: FROM IGS_PS_UNIT_VER
420: /*WHERE unit_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1)); --Bug 2395891/2543627 --space not accepted in user defined rules*/
421: WHERE unit_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1)); --nshee
422: IF v_count = 0
423: THEN

Line 429: FROM IGS_PS_UNIT_VER

425: check if to many selected units (1000)
426: */
427: SELECT count(*)
428: INTO v_max_count
429: FROM IGS_PS_UNIT_VER
430: /*WHERE unit_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1))||'%'; --Bug 2395891/2543627 --space not accepted in user defined rules*/
431: WHERE unit_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1))||'%';--nshee
432: IF v_max_count > 1000
433: THEN

Line 448: FROM IGS_PS_UNIT_VER

444: SELECT unit_cd,
445: version_number,
446: unit_status,
447: short_title
448: FROM IGS_PS_UNIT_VER
449: /*WHERE unit_cd LIKE UPPER(SUBSTR(p_rule,1,v_ii - 1))||'%' --Bug 2395891/2543627 --space not accepted in user defined rules*/
450: WHERE unit_cd LIKE UPPER(SUBSTR(REPLACE(p_rule,cst_spacemod,' '),1,v_ii - 1))||'%' --nshee
451: ORDER BY unit_cd,version_number DESC )
452: LOOP