40: FUNCTION get_plan_id(p_plan_name VARCHAR2) RETURN NUMBER;
41:
42: -- anagarwa Fri Jul 2 16:30:00 PDT 2004
43: -- bug 3736593 action fired element cannot be validated.
44: -- following function looks for values in qa_plan_char_value_lookups and
45: -- if not found, it executes the sql validation string
46: TYPE LookupCur IS REF CURSOR;
47: FUNCTION get_short_code(p_plan_id NUMBER,
48: p_char_id NUMBER,
199: -- Get the value entered in confirm_action Collection element.
200:
201: -- Bug 3684073. We should not derive the lookup_code value from
202: -- mfg_lookups because the value passed to this api would be the
203: -- qa_plan_char_value_lookups.short_code, which is not a translated
204: -- column. The mfg_lookups view would have the lookup meaning in the
205: -- language used in the current session.
206: --
207: -- Commented the below piece of code and compared p_launch_action
648: -- Get the value entered in confirm_action Collection element.
649:
650: -- Bug 3684073. We should not derive the lookup_code value from
651: -- mfg_lookups because the value passed to this api would be the
652: -- qa_plan_char_value_lookups.short_code, which is not a translated
653: -- column. The mfg_lookups view would have the lookup meaning in the
654: -- language used in the current session.
655: --
656: -- Commented the below piece of code and compared p_launch_action
1095: -- Get the value entered in confirm_action Collection element.
1096:
1097: -- Bug 3684073. We should not derive the lookup_code value from
1098: -- mfg_lookups because the value passed to this api would be the
1099: -- qa_plan_char_value_lookups.short_code, which is not a translated
1100: -- column. The mfg_lookups view would have the lookup meaning in the
1101: -- language used in the current session.
1102: --
1103: -- Commented the below piece of code and compared p_launch_action
1545: -- Get the value entered in confirm_action Collection element.
1546:
1547: -- Bug 3684073. We should not derive the lookup_code value from
1548: -- mfg_lookups because the value passed to this api would be the
1549: -- qa_plan_char_value_lookups.short_code, which is not a translated
1550: -- column. The mfg_lookups view would have the lookup meaning in the
1551: -- language used in the current session.
1552: --
1553: -- Commented the below piece of code and compared p_launch_action
1904: -- Get the value entered in confirm_action Collection element.
1905:
1906: -- Bug 3684073. We should not derive the lookup_code value from
1907: -- mfg_lookups because the value passed to this api would be the
1908: -- qa_plan_char_value_lookups.short_code, which is not a translated
1909: -- column. The mfg_lookups view would have the lookup meaning in the
1910: -- language used in the current session.
1911: --
1912: -- Commented the below piece of code and compared p_launch_action
2129: -- Get the value entered in confirm_action Collection element.
2130:
2131: -- Bug 3684073. We should not derive the lookup_code value from
2132: -- mfg_lookups because the value passed to this api would be the
2133: -- qa_plan_char_value_lookups.short_code, which is not a translated
2134: -- column. The mfg_lookups view would have the lookup meaning in the
2135: -- language used in the current session.
2136: --
2137: -- Commented the below piece of code and compared p_launch_action
2570: -- Get the value entered in confirm_action Collection element.
2571:
2572: -- Bug 3684073. We should not derive the lookup_code value from
2573: -- mfg_lookups because the value passed to this api would be the
2574: -- qa_plan_char_value_lookups.short_code, which is not a translated
2575: -- column. The mfg_lookups view would have the lookup meaning in the
2576: -- language used in the current session.
2577: --
2578: -- Commented the below piece of code and compared p_launch_action
2938: -- Get the value entered in confirm_action Collection element.
2939:
2940: -- Bug 3684073. We should not derive the lookup_code value from
2941: -- mfg_lookups because the value passed to this api would be the
2942: -- qa_plan_char_value_lookups.short_code, which is not a translated
2943: -- column. The mfg_lookups view would have the lookup meaning in the
2944: -- language used in the current session.
2945: --
2946: -- Commented the below piece of code and compared p_launch_action
3833: -- Bug 2595276. kabalakr.
3834:
3835: -- anagarwa Fri Jul 2 16:30:00 PDT 2004
3836: -- bug 3736593 action fired element cannot be validated.
3837: -- following function looks for values in qa_plan_char_value_lookups and
3838: -- if not found, it executes the sql validation string
3839: --l_action_fired := 'No' ;
3840: l_action_fired := get_short_code(p_plan_id, l_action_fired_char_id, 'NO');
3841:
3849: -- Bug 2595276. kabalakr.
3850:
3851: -- anagarwa Fri Jul 2 16:30:00 PDT 2004
3852: -- bug 3736593 action fired element cannot be validated.
3853: -- following function looks for values in qa_plan_char_value_lookups and
3854: -- if not found, it executes the sql validation string
3855: --l_action_fired := 'Yes' ;
3856: l_action_fired := get_short_code(p_plan_id, l_action_fired_char_id, 'YES');
3857:
4027: END get_organization_id;
4028:
4029: -- anagarwa Fri Jul 2 16:30:00 PDT 2004
4030: -- bug 3736593 action fired element cannot be validated.
4031: -- following function looks for values in qa_plan_char_value_lookups and
4032: -- if not found, it executes the sql validation string
4033: FUNCTION get_short_code(p_plan_id NUMBER,
4034: p_char_id NUMBER,
4035: p_short_code IN VARCHAR2)
4040: sql_string VARCHAR2(3000);
4041:
4042: CURSOR c IS
4043: SELECT short_code
4044: FROM qa_plan_char_value_lookups
4045: WHERE plan_id = p_plan_id
4046: AND char_id = p_char_id
4047: AND upper(short_code) = upper(p_short_code);
4048: