APPS.EDW_ITEMS_PKG dependencies on EDW_LOCAL_INSTANCE

Line 24: l_instance_code edw_local_instance.instance_code%TYPE;

20: p_item_category in varchar2 DEFAULT null,
21: p_instance_code in varchar2 DEFAULT null)
22: return VARCHAR2 IS
23:
24: l_instance_code edw_local_instance.instance_code%TYPE;
25: l_item_category mtl_categories_kfv.category_id%TYPE;
26:
27: cursor c1 is
28: select instance_code

Line 29: from edw_local_instance;

25: l_item_category mtl_categories_kfv.category_id%TYPE;
26:
27: cursor c1 is
28: select instance_code
29: from edw_local_instance;
30:
31: cursor c2 is
32: select category_id
33: from mtl_categories_kfv

Line 93: l_instance_code edw_local_instance.instance_code%TYPE;

89: p_item_category_id in NUMBER DEFAULT null,
90: p_instance_code in varchar2 DEFAULT null)
91: return VARCHAR2 IS
92:
93: l_instance_code edw_local_instance.instance_code%TYPE;
94:
95: cursor c1 is
96: select instance_code
97: from edw_local_instance;

Line 97: from edw_local_instance;

93: l_instance_code edw_local_instance.instance_code%TYPE;
94:
95: cursor c1 is
96: select instance_code
97: from edw_local_instance;
98:
99: BEGIN
100:
101: if p_organization_id = -1 then

Line 148: l_instance_code edw_local_instance.instance_code%TYPE;

144: p_revision in VARCHAR2,
145: p_instance_code in VARCHAR2 := null)
146: return VARCHAR2 IS
147:
148: l_instance_code edw_local_instance.instance_code%TYPE;
149:
150: cursor c1 is
151: select instance_code
152: from edw_local_instance;

Line 152: from edw_local_instance;

148: l_instance_code edw_local_instance.instance_code%TYPE;
149:
150: cursor c1 is
151: select instance_code
152: from edw_local_instance;
153:
154: BEGIN
155:
156: if p_instance_code is null then

Line 186: l_instance_code edw_local_instance.instance_code%TYPE;

182: p_category_id IN NUMBER,
183: p_instance_code IN VARCHAR2 DEFAULT NULL)
184: RETURN VARCHAR2 IS
185:
186: l_instance_code edw_local_instance.instance_code%TYPE;
187:
188: CURSOR c1 IS
189: SELECT instance_code
190: FROM edw_local_instance;

Line 190: FROM edw_local_instance;

186: l_instance_code edw_local_instance.instance_code%TYPE;
187:
188: CURSOR c1 IS
189: SELECT instance_code
190: FROM edw_local_instance;
191:
192: BEGIN
193:
194: IF p_instance_code IS NULL THEN