DBA Data[Home] [Help]

APPS.ENI_PARAM_UTIL_PKG dependencies on ENI_OLTP_ITEM_STAR

Line 13: eni_oltp_item_star

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:

Line 43: select id into l_first_item from eni_oltp_item_star

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;

Line 46: select id into l_first_item from eni_oltp_item_star

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;

Line 133: SELECT organization_id into l_first_item_org FROM eni_oltp_item_star

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: