[Home] [Help]
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
1549: -- Get the value entered in confirm_action Collection element.
1550:
1551: -- Bug 3684073. We should not derive the lookup_code value from
1552: -- mfg_lookups because the value passed to this api would be the
1553: -- qa_plan_char_value_lookups.short_code, which is not a translated
1554: -- column. The mfg_lookups view would have the lookup meaning in the
1555: -- language used in the current session.
1556: --
1557: -- Commented the below piece of code and compared p_launch_action
1908: -- Get the value entered in confirm_action Collection element.
1909:
1910: -- Bug 3684073. We should not derive the lookup_code value from
1911: -- mfg_lookups because the value passed to this api would be the
1912: -- qa_plan_char_value_lookups.short_code, which is not a translated
1913: -- column. The mfg_lookups view would have the lookup meaning in the
1914: -- language used in the current session.
1915: --
1916: -- Commented the below piece of code and compared p_launch_action
2133: -- Get the value entered in confirm_action Collection element.
2134:
2135: -- Bug 3684073. We should not derive the lookup_code value from
2136: -- mfg_lookups because the value passed to this api would be the
2137: -- qa_plan_char_value_lookups.short_code, which is not a translated
2138: -- column. The mfg_lookups view would have the lookup meaning in the
2139: -- language used in the current session.
2140: --
2141: -- Commented the below piece of code and compared p_launch_action
2577: -- Get the value entered in confirm_action Collection element.
2578:
2579: -- Bug 3684073. We should not derive the lookup_code value from
2580: -- mfg_lookups because the value passed to this api would be the
2581: -- qa_plan_char_value_lookups.short_code, which is not a translated
2582: -- column. The mfg_lookups view would have the lookup meaning in the
2583: -- language used in the current session.
2584: --
2585: -- Commented the below piece of code and compared p_launch_action
2954: -- Get the value entered in confirm_action Collection element.
2955:
2956: -- Bug 3684073. We should not derive the lookup_code value from
2957: -- mfg_lookups because the value passed to this api would be the
2958: -- qa_plan_char_value_lookups.short_code, which is not a translated
2959: -- column. The mfg_lookups view would have the lookup meaning in the
2960: -- language used in the current session.
2961: --
2962: -- Commented the below piece of code and compared p_launch_action
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 := 'No' ;
3856: l_action_fired := get_short_code(p_plan_id, l_action_fired_char_id, 'NO');
3857:
3865: -- Bug 2595276. kabalakr.
3866:
3867: -- anagarwa Fri Jul 2 16:30:00 PDT 2004
3868: -- bug 3736593 action fired element cannot be validated.
3869: -- following function looks for values in qa_plan_char_value_lookups and
3870: -- if not found, it executes the sql validation string
3871: --l_action_fired := 'Yes' ;
3872: l_action_fired := get_short_code(p_plan_id, l_action_fired_char_id, 'YES');
3873:
4043: END get_organization_id;
4044:
4045: -- anagarwa Fri Jul 2 16:30:00 PDT 2004
4046: -- bug 3736593 action fired element cannot be validated.
4047: -- following function looks for values in qa_plan_char_value_lookups and
4048: -- if not found, it executes the sql validation string
4049: FUNCTION get_short_code(p_plan_id NUMBER,
4050: p_char_id NUMBER,
4051: p_short_code IN VARCHAR2)
4056: sql_string VARCHAR2(3000);
4057:
4058: CURSOR c IS
4059: SELECT short_code
4060: FROM qa_plan_char_value_lookups
4061: WHERE plan_id = p_plan_id
4062: AND char_id = p_char_id
4063: AND upper(short_code) = upper(p_short_code);
4064: