DBA Data[Home] [Help]

APPS.ZPB_AW dependencies on FND_USER

Line 218: -- IN: p_user (varchar2) - The FND_USER USER_ID

214: --
215: -- Returns the un-qualified (schema not prepended) code aw name for
216: -- this user.
217: --
218: -- IN: p_user (varchar2) - The FND_USER USER_ID
219: -------------------------------------------------------------------------------
220: function GET_CODE_AW (p_user in varchar2)
221: return varchar2 is
222: begin

Line 233: -- IN: p_user (varchar2) - The FND_USER USER_ID

229: --
230: -- Returns the un-qualified (schema not prepended) personal aw name for
231: -- this user.
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

Line 238: l_user FND_USER.USER_ID%type;

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;
241: begin
242: l_business_area_id := nvl(p_business_area_id,

Line 551: p_user IN FND_USER.USER_ID%type,

547: := FND_API.G_VALID_LEVEL_FULL,
548: x_return_status OUT NOCOPY varchar2,
549: x_msg_count OUT NOCOPY number,
550: x_msg_data OUT NOCOPY varchar2,
551: p_user IN FND_USER.USER_ID%type,
552: p_business_area_id IN NUMBER,
553: p_attach_readwrite IN VARCHAR2,
554: p_sync_shared IN VARCHAR2,
555: p_detach_all IN VARCHAR2 :=FND_API.G_FALSE)