1: PACKAGE BODY eni_param_util_pkg AS
2: /*$Header: ENIPUTPB.pls 120.1 2006/02/22 04:51:10 lparihar noship $*/
3: -- Retrieve the default parameter values
4: -- for the Product Performance - Development
5: -- parameter portlet
38: --up a random record.
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
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;
48: end if;
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;
51: END get_dbi_pme_c_params;
52:
53: FUNCTION get_dbi_pms_params RETURN VARCHAR2 IS
138: RETURN l_first_item_org;
139: END get_dbi_pme_org;
140:
141:
142: END eni_param_util_pkg;