APPS.QLTDACTB dependencies on QLTSMENB

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

779: -- etc.) which need to be decoded from ID to meaning before the
780: -- comparison can be evaluated. Checking FK_LOOKUP_TYPE locally
781: -- saves us an unnecessary database hit.
782: IF fk_type_tab(i) in (0, 1, 3)
783: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),
784: QLTNINRB.NAME_IN(column_tab(i)));
785: ELSE result := QLTNINRB.NAME_IN(column_tab(i));
786: END IF;
787: done := FALSE;

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

2234: token_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2235:
2236: -- Convert all normalized element ID's into its values.
2237: -- ex. Item_id,locator_id converted to item_name, locator respectively
2238: -- For performance reason, dont call qltsmenb for char_id 2,39
2239:
2240: IF (prec.LOOKUP_TYPE in( 0,1,3) AND prec.char_id NOT IN (2, 39)) THEN
2241: token_value := QLTSMENB.LOOKUP(prec.CHAR_ID, token_value);
2242: END IF;

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

2237: -- ex. Item_id,locator_id converted to item_name, locator respectively
2238: -- For performance reason, dont call qltsmenb for char_id 2,39
2239:
2240: IF (prec.LOOKUP_TYPE in( 0,1,3) AND prec.char_id NOT IN (2, 39)) THEN
2241: token_value := QLTSMENB.LOOKUP(prec.CHAR_ID, token_value);
2242: END IF;
2243:
2244: -- Bug 2671638. Extending support to Sequence and Longcomment datatypes.
2245: IF token_datatype IN (1,4,5) THEN

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

2401: i := i + 1;
2402: ACTUAL_OUTPUT := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2403: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2404: (prec.LOOKUP_TYPE = 3) THEN
2405: ACTUAL_OUTPUT := QLTSMENB.LOOKUP(prec.CHAR_ID, ACTUAL_OUTPUT);
2406: end IF;
2407:
2408: -- Bug 10243514. Added following if conditions to
2409: -- convert canonical date format to user data format,

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

2750: token_char_id := prec.char_id;
2751: token_column_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2752: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2753: (prec.LOOKUP_TYPE = 3) THEN
2754: token_column_value := QLTSMENB.LOOKUP(prec.CHAR_ID,
2755: token_column_value);
2756: END IF;
2757: find_token := TRUE;
2758: END IF;