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 BISM_SUBJECTS

Line 12: -- OUT: l_subject_id - bism_subjects.subject_id, raw

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 (
16: p_user_id IN fnd_user.user_id%TYPE)

Line 17: return bism_subjects.subject_id%TYPE

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;
21: BEGIN

Line 20: l_subject_id bism_subjects.subject_id%TYPE;

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;
21: BEGIN
22:
23: SELECT subject_id
24: INTO l_subject_id

Line 26: bism_subjects

22:
23: SELECT subject_id
24: INTO l_subject_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:

Line 41: -- OUT: l_subject_id - bism_subjects.subject_id, raw

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:
45: FUNCTION get_bism_subject_id (

Line 47: return bism_subjects.subject_id%TYPE

43:
44:
45: FUNCTION get_bism_subject_id (
46: p_user_id IN varchar2)
47: return bism_subjects.subject_id%TYPE
48:
49: IS
50: l_subject_id bism_subjects.subject_id%TYPE;
51:

Line 50: l_subject_id bism_subjects.subject_id%TYPE;

46: p_user_id IN varchar2)
47: return bism_subjects.subject_id%TYPE
48:
49: IS
50: l_subject_id bism_subjects.subject_id%TYPE;
51:
52: BEGIN
53:
54: SELECT subject_id

Line 57: bism_subjects

53:
54: SELECT subject_id
55: INTO l_subject_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:

Line 72: -- OUT: l_subject_id - bism_subjects.subject_id, raw

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 (
76: p_user_name IN fnd_user.user_name%TYPE)

Line 77: return bism_subjects.subject_id%TYPE

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;
81: BEGIN

Line 80: l_subject_id bism_subjects.subject_id%TYPE;

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;
81: BEGIN
82:
83: SELECT subject_id
84: INTO l_subject_id

Line 86: bism_subjects

82:
83: SELECT subject_id
84: INTO l_subject_id
85: FROM
86: bism_subjects
87: WHERE
88: subject_name = upper(p_user_name) and
89: subject_type = 'u';
90:

Line 100: -- OUT: l_subject_id - bism_subjects.subject_id, raw

96: -- GET_BISM_SUBJECT_ID_FROM_RESP - Given a responsibility key eg.' ZPB_MANAGER_RESP',
97: -- returns the bism subject id
98: --
99: -- IN: p_resp_key - FND responsibility key e.g. ZPB_MANAGER_RESP, varchar2
100: -- OUT: l_subject_id - bism_subjects.subject_id, raw
101: -------------------------------------------------------------------------------
102:
103: FUNCTION get_bism_subject_id_from_resp (
104: p_resp_key IN fnd_responsibility.responsibility_key%TYPE)

Line 105: return bism_subjects.subject_id%TYPE

101: -------------------------------------------------------------------------------
102:
103: FUNCTION get_bism_subject_id_from_resp (
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;

Line 109: subject_id bism_subjects.subject_id%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
113: subject_id into subject_id

Line 115: bism_subjects

111:
112: SELECT
113: subject_id into subject_id
114: FROM
115: bism_subjects
116: WHERE subject_name = p_resp_key AND
117: subject_type = 'g';
118:
119: return subject_id;

Line 127: -- IN: p_bism_subject_id - bism_subjects.subject_id, raw

123: -------------------------------------------------------------------------------
124: -- GET_BISM_OBJECT_ID - Given an object path, returns the bism object id
125: --
126: -- IN: p_object_path - path 'oracle/apps/zpb/BusArea...', varchar2
127: -- IN: p_bism_subject_id - bism_subjects.subject_id, raw
128: -- OUT: l_folder_id - bism_subjects.folder_id, raw
129: -------------------------------------------------------------------------------
130:
131: FUNCTION get_bism_object_id (

Line 128: -- OUT: l_folder_id - bism_subjects.folder_id, raw

124: -- GET_BISM_OBJECT_ID - Given an object path, returns the bism object id
125: --
126: -- IN: p_object_path - path 'oracle/apps/zpb/BusArea...', varchar2
127: -- IN: p_bism_subject_id - bism_subjects.subject_id, raw
128: -- OUT: l_folder_id - bism_subjects.folder_id, raw
129: -------------------------------------------------------------------------------
130:
131: FUNCTION get_bism_object_id (
132: p_object_path IN varchar2,

Line 133: p_bism_subject_id IN bism_subjects.subject_id%TYPE)

129: -------------------------------------------------------------------------------
130:
131: FUNCTION get_bism_object_id (
132: p_object_path IN varchar2,
133: p_bism_subject_id IN bism_subjects.subject_id%TYPE)
134: return bism_objects.folder_id%TYPE
135:
136: IS
137:

Line 174: l_bism_subject_id BISM_SUBJECTS.subject_id%TYPE;

170: IS
171:
172: l_bism_object_id BISM_OBJECTS.OBJECT_ID%TYPE;
173: l_bism_object_desc BISM_OBJECTS.DESCRIPTION%TYPE;
174: l_bism_subject_id BISM_SUBJECTS.subject_id%TYPE;
175:
176: BEGIN
177:
178: -- use apps id if null passed in.

Line 213: l_bism_subject_id bism_subjects.subject_id%TYPE;

209:
210: IS
211:
212: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;
213: l_bism_subject_id bism_subjects.subject_id%TYPE;
214:
215: BEGIN
216: BEGIN
217:

Line 253: l_bism_subject_id bism_subjects.subject_id%TYPE;

249:
250: IS
251:
252: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;
253: l_bism_subject_id bism_subjects.subject_id%TYPE;
254:
255: BEGIN
256: BEGIN
257:

Line 289: l_bism_subject_id bism_subjects.subject_id%TYPE;

285:
286: IS
287:
288: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;
289: l_bism_subject_id bism_subjects.subject_id%TYPE;
290:
291: BEGIN
292: BEGIN
293: l_bism_subject_id := zpb_bism.get_bism_subject_id(p_user_id);