9: SELECT
10: id,
11: value
12: FROM
13: eni_oltp_item_star
14: WHERE rownum = 1;
15:
16: r_first_item c_first_item%ROWTYPE;
17:
39: FUNCTION get_dbi_pme_c_params RETURN VARCHAR2 IS
40: l_first_item varchar2(50);
41: BEGIN
42: if eni_param_util_pkg.g_default_org <> null then
43: select id into l_first_item from eni_oltp_item_star
44: where organization_id = to_number(eni_param_util_pkg.g_default_org) and rownum = 1;
45: else
46: select id into l_first_item from eni_oltp_item_star
47: where rownum = 1;
42: if eni_param_util_pkg.g_default_org <> null then
43: select id into l_first_item from eni_oltp_item_star
44: where organization_id = to_number(eni_param_util_pkg.g_default_org) and rownum = 1;
45: else
46: select id into l_first_item from eni_oltp_item_star
47: where rownum = 1;
48: end if;
49: eni_param_util_pkg.g_default_org := null;
50: RETURN l_first_item;
129: FUNCTION get_dbi_pme_org RETURN VARCHAR2 IS
130: l_first_item_org varchar2(50);
131:
132: BEGIN
133: SELECT organization_id into l_first_item_org FROM eni_oltp_item_star
134: WHERE rownum = 1;
135:
136: g_default_org := l_first_item_org;
137: