DBA Data[Home] [Help]

APPS.QA_SOLUTION_CAR_PKG dependencies on MFG_LOOKUPS

Line 7: -- We are no longer using mfg_lookups to derive the lookup_code.

3:
4: -- Package Private Variables.
5:
6: -- Bug 3684073. Modified the constants to VARCHAR2 below.
7: -- We are no longer using mfg_lookups to derive the lookup_code.
8: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.
9: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.
10:
11: g_lookup_yes CONSTANT VARCHAR2(3) := 'YES';

Line 8: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.

4: -- Package Private Variables.
5:
6: -- Bug 3684073. Modified the constants to VARCHAR2 below.
7: -- We are no longer using mfg_lookups to derive the lookup_code.
8: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.
9: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.
10:
11: g_lookup_yes CONSTANT VARCHAR2(3) := 'YES';
12: g_lookup_no CONSTANT VARCHAR2(3) := 'NO';

Line 9: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.

5:
6: -- Bug 3684073. Modified the constants to VARCHAR2 below.
7: -- We are no longer using mfg_lookups to derive the lookup_code.
8: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.
9: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.
10:
11: g_lookup_yes CONSTANT VARCHAR2(3) := 'YES';
12: g_lookup_no CONSTANT VARCHAR2(3) := 'NO';
13:

Line 23: FUNCTION get_mfg_lookups_value (p_meaning VARCHAR2,

19: -------------------------------------------------------------------------------
20: -- Forward declaration of Local functions.
21: -------------------------------------------------------------------------------
22:
23: FUNCTION get_mfg_lookups_value (p_meaning VARCHAR2,
24: p_lookup_type VARCHAR2) RETURN NUMBER;
25:
26: FUNCTION get_organization_id (p_organization_code VARCHAR2) RETURN NUMBER;
27: FUNCTION get_plan_id(p_plan_name VARCHAR2) RETURN NUMBER;

Line 143: -- mfg_lookups because the value passed to this api would be the

139: -- Get the value entered in launch_action and Action_fired
140: -- Collection elements.
141:
142: -- Bug 3684073. We should not derive the lookup_code value from
143: -- mfg_lookups because the value passed to this api would be the
144: -- qa_plan_char_value_lookups.short_code, which is not a translated
145: -- column. The mfg_lookups view would have the lookup meaning in the
146: -- language used in the current session.
147: --

Line 145: -- column. The mfg_lookups view would have the lookup meaning in the

141:
142: -- Bug 3684073. We should not derive the lookup_code value from
143: -- mfg_lookups because the value passed to this api would be the
144: -- qa_plan_char_value_lookups.short_code, which is not a translated
145: -- column. The mfg_lookups view would have the lookup meaning in the
146: -- language used in the current session.
147: --
148: -- Commented the below piece of code and compared p_launch_action
149: -- and p_action_fired parameters below with the new constants to resolve

Line 152: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');

148: -- Commented the below piece of code and compared p_launch_action
149: -- and p_action_fired parameters below with the new constants to resolve
150: -- the value entered. kabalakr.
151:
152: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
153: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
154:
155: -- The Action Code should get executed only if
156: -- Launch_action is 'Yes' and Action_fired is 'No'

Line 153: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');

149: -- and p_action_fired parameters below with the new constants to resolve
150: -- the value entered. kabalakr.
151:
152: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
153: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
154:
155: -- The Action Code should get executed only if
156: -- Launch_action is 'Yes' and Action_fired is 'No'
157:

Line 296: FROM mfg_lookups

292: l_approval_status_name VARCHAR2(80);
293:
294: CURSOR c1(type VARCHAR2) IS
295: SELECT meaning
296: FROM mfg_lookups
297: WHERE lookup_type = type
298: AND lookup_code = 1;
299:
300: BEGIN

Line 303: -- from mfg_lookups.

299:
300: BEGIN
301:
302: -- Bug 2714477. Get the Status name and Approval status name
303: -- from mfg_lookups.
304:
305: OPEN c1('ECG_ECN_STATUS');
306: FETCH c1 INTO l_status_name;
307: CLOSE c1;

Line 381: FUNCTION get_mfg_lookups_value (p_meaning VARCHAR2,

377: END ENG_CHANGE_ORDER_INT;
378:
379:
380:
381: FUNCTION get_mfg_lookups_value (p_meaning VARCHAR2,
382: p_lookup_type VARCHAR2)
383: RETURN NUMBER IS
384:
385: l_lookup_code VARCHAR2(2);

Line 389: FROM mfg_lookups

385: l_lookup_code VARCHAR2(2);
386:
387: Cursor meaning_cur IS
388: SELECT lookup_code
389: FROM mfg_lookups
390: WHERE lookup_type = p_lookup_type
391: AND upper(meaning) = upper(ltrim(rtrim(p_meaning)));
392: BEGIN
393: OPEN meaning_cur;

Line 399: END get_mfg_lookups_value;

395: CLOSE meaning_cur;
396:
397: RETURN l_lookup_code;
398:
399: END get_mfg_lookups_value;
400:
401:
402:
403: FUNCTION get_plan_id(p_plan_name VARCHAR2)