APPS.QA_LOCATION dependencies on QA_CHAR_INDEXES_PKG

Line 21: -- qa_char_indexes_pkg. Part of Bug 3930666.

17: l_status integer;
18:
19: --
20: -- Completely modified to take advantage of the new
21: -- qa_char_indexes_pkg. Part of Bug 3930666.
22: -- bso Tue Apr 5 17:50:48 PDT 2005
23: --
24:
25: BEGIN

Line 31: -- using the efficient qa_char_indexes_pkg.

27: hr_utility.set_location('QA_LOCATION.QA_PREDEL_VALIDATION', 1);
28:
29: --
30: -- Bug 3930666. Construct the decode statement
31: -- using the efficient qa_char_indexes_pkg.
32: --
33: l_status := qa_char_indexes_pkg.construct_decode_function(
34: qa_ss_const.LOCATION, 'QR.', l_most_common, final);
35:

Line 33: l_status := qa_char_indexes_pkg.construct_decode_function(

29: --
30: -- Bug 3930666. Construct the decode statement
31: -- using the efficient qa_char_indexes_pkg.
32: --
33: l_status := qa_char_indexes_pkg.construct_decode_function(
34: qa_ss_const.LOCATION, 'QR.', l_most_common, final);
35:
36: IF l_status = qa_char_indexes_pkg.ERR_ELEMENT_NOT_IN_USE THEN
37: -- Great! Element not in use, simply return.

Line 36: IF l_status = qa_char_indexes_pkg.ERR_ELEMENT_NOT_IN_USE THEN

32: --
33: l_status := qa_char_indexes_pkg.construct_decode_function(
34: qa_ss_const.LOCATION, 'QR.', l_most_common, final);
35:
36: IF l_status = qa_char_indexes_pkg.ERR_ELEMENT_NOT_IN_USE THEN
37: -- Great! Element not in use, simply return.
38: RETURN;
39:
40: ELSIF l_status < 0 THEN

Line 59: -- qa_char_indexes_pkg which returns a DECODE

55: -- Bug 3930666. Use bind variable to prevent error
56: -- when single-quote appears in loc_code.
57: --
58: -- Coding is greatly simplified using
59: -- qa_char_indexes_pkg which returns a DECODE
60: -- function such as DECODE(qr.plan_id, 111, qr.CHARACTER1,
61: -- 112, qr.CHARACTER2, qr.CHARACTER4) or a simple
62: -- qr.CHARACTER1 if all reside in the same column.
63: -- All we need to do is to prefix this function with