APPS.ZPB_BISM dependencies on BISM_OBJECTS

Line 134: return bism_objects.folder_id%TYPE

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:
138: l_folder_id bism_objects.object_id%TYPE;

Line 138: l_folder_id bism_objects.object_id%TYPE;

134: return bism_objects.folder_id%TYPE
135:
136: IS
137:
138: l_folder_id bism_objects.object_id%TYPE;
139: v_objid_out BISM_OBJECTS.OBJECT_ID%TYPE;
140: v_typeid_out BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
141: v_objname_out BISM_OBJECTS.OBJECT_NAME%TYPE;
142:

Line 139: v_objid_out BISM_OBJECTS.OBJECT_ID%TYPE;

135:
136: IS
137:
138: l_folder_id bism_objects.object_id%TYPE;
139: v_objid_out BISM_OBJECTS.OBJECT_ID%TYPE;
140: v_typeid_out BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
141: v_objname_out BISM_OBJECTS.OBJECT_NAME%TYPE;
142:
143: BEGIN

Line 140: v_typeid_out BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;

136: IS
137:
138: l_folder_id bism_objects.object_id%TYPE;
139: v_objid_out BISM_OBJECTS.OBJECT_ID%TYPE;
140: v_typeid_out BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
141: v_objname_out BISM_OBJECTS.OBJECT_NAME%TYPE;
142:
143: BEGIN
144:

Line 141: v_objname_out BISM_OBJECTS.OBJECT_NAME%TYPE;

137:
138: l_folder_id bism_objects.object_id%TYPE;
139: v_objid_out BISM_OBJECTS.OBJECT_ID%TYPE;
140: v_typeid_out BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
141: v_objname_out BISM_OBJECTS.OBJECT_NAME%TYPE;
142:
143: BEGIN
144:
145: bism_core.lookuphelper(UTL_RAW.CAST_TO_RAW (BIBEANS_ROOT_FOLDER),

Line 168: return BISM_OBJECTS.DESCRIPTION%TYPE

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:
172: l_bism_object_id BISM_OBJECTS.OBJECT_ID%TYPE;

Line 172: l_bism_object_id BISM_OBJECTS.OBJECT_ID%TYPE;

168: return BISM_OBJECTS.DESCRIPTION%TYPE
169:
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

Line 173: l_bism_object_desc BISM_OBJECTS.DESCRIPTION%TYPE;

169:
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:

Line 189: from bism_objects

185: l_bism_object_id := get_bism_object_id(p_object_path, l_bism_subject_id);
186:
187: select description
188: into l_bism_object_desc
189: from bism_objects
190: where object_id = l_bism_object_id;
191:
192: return l_bism_object_desc;
193:

Line 207: p_object_name BISM_OBJECTS.OBJECT_NAME%TYPE,

203: -------------------------------------------------------------------------------
204:
205: PROCEDURE delete_bism_object (
206: p_folder_path varchar2,
207: p_object_name BISM_OBJECTS.OBJECT_NAME%TYPE,
208: p_user_id varchar2 default NULL)
209:
210: IS
211:

Line 212: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

208: p_user_id varchar2 default NULL)
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

Line 252: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

248: p_user_id IN fnd_user.user_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

Line 288: l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

284: p_user_id IN fnd_user.user_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