eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_BISM dependencies on FND_USER

Line 11: -- IN: p_user_id - FND User id, integer

7: -------------------------------------------------------------------------------
8: -- GET_BISM_SUBJECT_ID - Given a user_id eg. 1008187, returns the
9: -- bism subject id
10: --
11: -- IN: p_user_id - FND User id, integer
12: -- OUT: l_subject_id - bism_subjects.subject_id, raw
13: -------------------------------------------------------------------------------
14:
15: FUNCTION get_bism_subject_id (

Line 16: p_user_id IN fnd_user.user_id%TYPE)

12: -- OUT: l_subject_id - bism_subjects.subject_id, raw
13: -------------------------------------------------------------------------------
14:
15: FUNCTION get_bism_subject_id (
16: p_user_id IN fnd_user.user_id%TYPE)
17: return bism_subjects.subject_id%TYPE
18:
19: IS
20: l_subject_id bism_subjects.subject_id%TYPE;

Line 29: subject_name = (SELECT user_name FROM fnd_user WHERE user_id = p_user_id);

25: FROM
26: bism_subjects
27: WHERE
28: subject_type = 'u' and
29: subject_name = (SELECT user_name FROM fnd_user WHERE user_id = p_user_id);
30:
31: return l_subject_id;
32:
33: END;

Line 40: -- IN: p_user_id - FND User id, varchar2

36: -- GET_BISM_SUBJECT_ID - Given a varchar2 user_id eg. '1008187',
37: -- returns the raw bism subject id.
38: -- calls.
39: --
40: -- IN: p_user_id - FND User id, varchar2
41: -- OUT: l_subject_id - bism_subjects.subject_id, raw
42: -------------------------------------------------------------------------------
43:
44:

Line 60: subject_name = (SELECT user_name FROM fnd_user WHERE user_id = p_user_id);

56: FROM
57: bism_subjects
58: WHERE
59: subject_type = 'u' and
60: subject_name = (SELECT user_name FROM fnd_user WHERE user_id = p_user_id);
61:
62: return l_subject_id;
63:
64: END;

Line 71: -- IN: p_user_name - FND User name e.g. JSMITH

67: -------------------------------------------------------------------------------
68: -- GET_BISM_SUBJECT_ID_FROM_NAME - Given a user_name eg. 'JSMITH', returns the
69: -- bism subject id
70: --
71: -- IN: p_user_name - FND User name e.g. JSMITH
72: -- OUT: l_subject_id - bism_subjects.subject_id, raw
73: -------------------------------------------------------------------------------
74:
75: FUNCTION get_bism_subject_id_from_name (

Line 76: p_user_name IN fnd_user.user_name%TYPE)

72: -- OUT: l_subject_id - bism_subjects.subject_id, raw
73: -------------------------------------------------------------------------------
74:
75: FUNCTION get_bism_subject_id_from_name (
76: p_user_name IN fnd_user.user_name%TYPE)
77: return bism_subjects.subject_id%TYPE
78:
79: IS
80: l_subject_id bism_subjects.subject_id%TYPE;

Line 108: l_user_name fnd_user.user_name%TYPE;

104: p_resp_key IN fnd_responsibility.responsibility_key%TYPE)
105: return bism_subjects.subject_id%TYPE
106:
107: IS
108: l_user_name fnd_user.user_name%TYPE;
109: subject_id bism_subjects.subject_id%TYPE;
110: BEGIN
111:
112: SELECT

Line 167: p_user_id IN FND_USER.USER_ID%TYPE default NULL)

163: -------------------------------------------------------------------------------
164:
165: FUNCTION get_bism_object_desc (
166: p_object_path IN varchar2,
167: p_user_id IN FND_USER.USER_ID%TYPE default NULL)
168: return BISM_OBJECTS.DESCRIPTION%TYPE
169:
170: IS
171:

Line 202: -- IN: p_user_id - fnd_user.user_id, varchar2

198: -- userid, deletes the object
199: --
200: -- IN: p_folder_path - path 'oracle/apps/zpb/BusArea...', varchar2
201: -- IN: p_object_name - object name 'USERDIR', varchar2
202: -- IN: p_user_id - fnd_user.user_id, varchar2
203: -------------------------------------------------------------------------------
204:
205: PROCEDURE delete_bism_object (
206: p_folder_path varchar2,

Line 243: -- IN: p_user_id - fnd_user.user_id, number

239: -- DELETE_BISM_FOLDER - Given an folder path and user id,
240: -- deletes the BISM folder
241: --
242: -- IN: p_folder_path - path 'oracle/apps/zpb/BusArea25/...', varchar2
243: -- IN: p_user_id - fnd_user.user_id, number
244: -------------------------------------------------------------------------------
245:
246: PROCEDURE delete_bism_folder (
247: p_folder_path varchar2,

Line 248: p_user_id IN fnd_user.user_id%TYPE)

244: -------------------------------------------------------------------------------
245:
246: PROCEDURE delete_bism_folder (
247: p_folder_path varchar2,
248: p_user_id IN fnd_user.user_id%TYPE)
249:
250: IS
251:
252: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

Line 279: -- IN: p_user_id - fnd_user.user_id, integer

275: -- user_id must be valid bibeans id, but does
276: -- not require write access to folder for deletion.
277: --
278: -- IN: p_folder_path - path 'oracle/apps/zpb/BusArea25/...', varchar2
279: -- IN: p_user_id - fnd_user.user_id, integer
280: -------------------------------------------------------------------------------
281:
282: PROCEDURE delete_bism_folder_wo_security (
283: p_folder_path varchar2,

Line 284: p_user_id IN fnd_user.user_id%TYPE)

280: -------------------------------------------------------------------------------
281:
282: PROCEDURE delete_bism_folder_wo_security (
283: p_folder_path varchar2,
284: p_user_id IN fnd_user.user_id%TYPE)
285:
286: IS
287:
288: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;