APPS.ZPB_AW dependencies on ZPB_BUSINESS_AREAS

Line 191: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)

187: -- uses the Business Area in context, or
188: -- the business area currently logged in as
189: -------------------------------------------------------------------------------
190: function GET_ANNOTATION_AW
191: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
192: return ZPB_BUSINESS_AREAS.ANNOTATION_AW%type is
193: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
194: l_annotation_aw ZPB_BUSINESS_AREAS.ANNOTATION_AW%type;
195: begin

Line 192: return ZPB_BUSINESS_AREAS.ANNOTATION_AW%type is

188: -- the business area currently logged in as
189: -------------------------------------------------------------------------------
190: function GET_ANNOTATION_AW
191: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
192: return ZPB_BUSINESS_AREAS.ANNOTATION_AW%type is
193: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
194: l_annotation_aw ZPB_BUSINESS_AREAS.ANNOTATION_AW%type;
195: begin
196: l_business_area_id := nvl(p_business_area_id,

Line 193: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

189: -------------------------------------------------------------------------------
190: function GET_ANNOTATION_AW
191: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
192: return ZPB_BUSINESS_AREAS.ANNOTATION_AW%type is
193: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
194: l_annotation_aw ZPB_BUSINESS_AREAS.ANNOTATION_AW%type;
195: begin
196: l_business_area_id := nvl(p_business_area_id,
197: sys_context('ZPB_CONTEXT', 'business_area_id'));

Line 194: l_annotation_aw ZPB_BUSINESS_AREAS.ANNOTATION_AW%type;

190: function GET_ANNOTATION_AW
191: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
192: return ZPB_BUSINESS_AREAS.ANNOTATION_AW%type is
193: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
194: l_annotation_aw ZPB_BUSINESS_AREAS.ANNOTATION_AW%type;
195: begin
196: l_business_area_id := nvl(p_business_area_id,
197: sys_context('ZPB_CONTEXT', 'business_area_id'));
198: if (l_business_area_id is null) then

Line 206: from ZPB_BUSINESS_AREAS

202: end if;
203:
204: select ANNOTATION_AW
205: into l_annotation_aw
206: from ZPB_BUSINESS_AREAS
207: where BUSINESS_AREA_ID = l_business_area_id;
208:
209: return l_annotation_aw;
210: end GET_ANNOTATION_AW;

Line 236: p_business_area_id in ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)

232: --
233: -- IN: p_user (varchar2) - The FND_USER USER_ID
234: -------------------------------------------------------------------------------
235: function GET_PERSONAL_AW (p_user in varchar2,
236: p_business_area_id in ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
237: return ZPB_USERS.PERSONAL_AW%type is
238: l_user FND_USER.USER_ID%type;
239: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
240: l_personal_aw ZPB_USERS.PERSONAL_AW%type;

Line 239: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

235: function GET_PERSONAL_AW (p_user in varchar2,
236: p_business_area_id in ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
237: return ZPB_USERS.PERSONAL_AW%type is
238: l_user FND_USER.USER_ID%type;
239: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
240: l_personal_aw ZPB_USERS.PERSONAL_AW%type;
241: begin
242: l_business_area_id := nvl(p_business_area_id,
243: sys_context('ZPB_CONTEXT', 'business_area_id'));

Line 281: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)

277: -- uses the Business Area in context, or
278: -- the business area currently logged in as
279: -------------------------------------------------------------------------------
280: function GET_SHARED_AW
281: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
282: return ZPB_BUSINESS_AREAS.DATA_AW%type is
283: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
284: l_shared_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
285: begin

Line 282: return ZPB_BUSINESS_AREAS.DATA_AW%type is

278: -- the business area currently logged in as
279: -------------------------------------------------------------------------------
280: function GET_SHARED_AW
281: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
282: return ZPB_BUSINESS_AREAS.DATA_AW%type is
283: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
284: l_shared_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
285: begin
286: l_business_area_id := nvl(p_business_area_id,

Line 283: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

279: -------------------------------------------------------------------------------
280: function GET_SHARED_AW
281: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
282: return ZPB_BUSINESS_AREAS.DATA_AW%type is
283: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
284: l_shared_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
285: begin
286: l_business_area_id := nvl(p_business_area_id,
287: sys_context('ZPB_CONTEXT', 'business_area_id'));

Line 284: l_shared_aw ZPB_BUSINESS_AREAS.DATA_AW%type;

280: function GET_SHARED_AW
281: (p_business_area_id IN ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type)
282: return ZPB_BUSINESS_AREAS.DATA_AW%type is
283: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
284: l_shared_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
285: begin
286: l_business_area_id := nvl(p_business_area_id,
287: sys_context('ZPB_CONTEXT', 'business_area_id'));
288: if (l_business_area_id is null) then

Line 296: from ZPB_BUSINESS_AREAS

292: end if;
293:
294: select DATA_AW
295: into l_shared_aw
296: from ZPB_BUSINESS_AREAS
297: where BUSINESS_AREA_ID = l_business_area_id;
298:
299: return l_shared_aw;
300: end GET_SHARED_AW;

Line 505: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

501: p_analysis_cycle_id IN NUMBER,
502: p_shared_rw IN VARCHAR2:=FND_API.G_FALSE,
503: p_annot_rw IN VARCHAR2:=FND_API.G_FALSE)
504: is
505: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
506: begin
507:
508: -- support both analysis cycle ids and current instance ids
509: begin