DBA Data[Home] [Help]

APPS.ENI_PARAM_UTIL_PKG dependencies on ENI_PARAM_UTIL_PKG

Line 1: PACKAGE BODY eni_param_util_pkg AS

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

Line 42: if eni_param_util_pkg.g_default_org <> null then

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

Line 44: where organization_id = to_number(eni_param_util_pkg.g_default_org) and rownum = 1;

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;

Line 49: eni_param_util_pkg.g_default_org := null;

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

Line 142: END eni_param_util_pkg;

138: RETURN l_first_item_org;
139: END get_dbi_pme_org;
140:
141:
142: END eni_param_util_pkg;