APPS.QLTDACTB dependencies on QLTSMENB

Line 744: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),

740: -- etc.) which need to be decoded from ID to meaning before the
741: -- comparison can be evaluated. Checking FK_LOOKUP_TYPE locally
742: -- saves us an unnecessary database hit.
743: IF fk_type_tab(i) in (0, 1, 3)
744: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),
745: QLTNINRB.NAME_IN(column_tab(i)));
746: ELSE result := QLTNINRB.NAME_IN(column_tab(i));
747: END IF;
748: done := FALSE;

Line 2149: -- For performance reason, dont call qltsmenb for char_id 2,39

2145: token_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2146:
2147: -- Convert all normalized element ID's into its values.
2148: -- ex. Item_id,locator_id converted to item_name, locator respectively
2149: -- For performance reason, dont call qltsmenb for char_id 2,39
2150:
2151: IF (prec.LOOKUP_TYPE in( 0,1,3) AND prec.char_id NOT IN (2, 39)) THEN
2152: token_value := QLTSMENB.LOOKUP(prec.CHAR_ID, token_value);
2153: END IF;

Line 2152: token_value := QLTSMENB.LOOKUP(prec.CHAR_ID, token_value);

2148: -- ex. Item_id,locator_id converted to item_name, locator respectively
2149: -- For performance reason, dont call qltsmenb for char_id 2,39
2150:
2151: IF (prec.LOOKUP_TYPE in( 0,1,3) AND prec.char_id NOT IN (2, 39)) THEN
2152: token_value := QLTSMENB.LOOKUP(prec.CHAR_ID, token_value);
2153: END IF;
2154:
2155: -- Bug 2671638. Extending support to Sequence and Longcomment datatypes.
2156: IF token_datatype IN (1,4,5) THEN

Line 2305: ACTUAL_OUTPUT := QLTSMENB.LOOKUP(prec.CHAR_ID, ACTUAL_OUTPUT);

2301: i := i + 1;
2302: ACTUAL_OUTPUT := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2303: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2304: (prec.LOOKUP_TYPE = 3) THEN
2305: ACTUAL_OUTPUT := QLTSMENB.LOOKUP(prec.CHAR_ID, ACTUAL_OUTPUT);
2306: end IF;
2307:
2308: /*kashyap, rkaza 06/14/2002. as part of fix for Bug 2408728 */
2309: IF (qa_chars_api.datatype(prec.char_id) = 4) THEN

Line 2625: token_column_value := QLTSMENB.LOOKUP(prec.CHAR_ID,

2621: token_char_id := prec.char_id;
2622: token_column_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2623: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2624: (prec.LOOKUP_TYPE = 3) THEN
2625: token_column_value := QLTSMENB.LOOKUP(prec.CHAR_ID,
2626: token_column_value);
2627: END IF;
2628: find_token := TRUE;
2629: END IF;