APPS.IBC_RENDITIONS_PKG dependencies on IBC_RENDITIONS

Line 1: PACKAGE BODY Ibc_Renditions_Pkg AS

1: PACKAGE BODY Ibc_Renditions_Pkg AS
2: /* $Header: ibctrenb.pls 120.2 2005/07/29 15:06:15 appldev ship $ */
3:
4:
5: -- MODIFICATION HISTORY

Line 28: CURSOR C IS SELECT ROWID FROM IBC_RENDITIONS

24: p_LAST_UPDATE_DATE IN DATE,
25: p_LAST_UPDATED_BY IN NUMBER,
26: p_LAST_UPDATE_LOGIN IN NUMBER
27: ) IS
28: CURSOR C IS SELECT ROWID FROM IBC_RENDITIONS
29: WHERE RENDITION_ID = Px_RENDITION_ID;
30: CURSOR c2 IS SELECT ibc_renditions_s1.NEXTVAL FROM dual;
31: BEGIN
32:

Line 30: CURSOR c2 IS SELECT ibc_renditions_s1.NEXTVAL FROM dual;

26: p_LAST_UPDATE_LOGIN IN NUMBER
27: ) IS
28: CURSOR C IS SELECT ROWID FROM IBC_RENDITIONS
29: WHERE RENDITION_ID = Px_RENDITION_ID;
30: CURSOR c2 IS SELECT ibc_renditions_s1.NEXTVAL FROM dual;
31: BEGIN
32:
33: -- Primary key validation check
34:

Line 43: INSERT INTO IBC_RENDITIONS (

39: FETCH c2 INTO px_rendition_ID;
40: CLOSE c2;
41: END IF;
42:
43: INSERT INTO IBC_RENDITIONS (
44: FILE_ID,
45: FILE_NAME,
46: mime_type,
47: RENDITION_ID,

Line 98: FROM IBC_RENDITIONS

94: OBJECT_VERSION_NUMBER,
95: FILE_ID,
96: FILE_NAME,
97: CITEM_VERSION_ID
98: FROM IBC_RENDITIONS
99: WHERE RENDITION_ID = P_RENDITION_ID
100: FOR UPDATE OF RENDITION_ID NOWAIT;
101: recinfo c%ROWTYPE;
102:

Line 139: UPDATE IBC_RENDITIONS SET

135: P_LAST_UPDATED_BY IN NUMBER,
136: P_LAST_UPDATE_LOGIN IN NUMBER
137: ) IS
138: BEGIN
139: UPDATE IBC_RENDITIONS SET
140: FILE_ID = DECODE(P_FILE_ID,NULL,FILE_ID,P_FILE_ID),
141: FILE_NAME = DECODE(P_FILE_NAME,NULL,FILE_NAME,P_FILE_NAME),
142: MIME_TYPE = DECODE(P_MIME_TYPE,NULL,MIME_TYPE,P_MIME_TYPE),
143: CITEM_VERSION_ID = DECODE(P_CITEM_VERSION_ID,NULL,CITEM_VERSION_ID,P_CITEM_VERSION_ID),

Line 168: DELETE FROM IBC_RENDITIONS

164: P_RENDITION_ID IN NUMBER
165: ) IS
166: BEGIN
167:
168: DELETE FROM IBC_RENDITIONS
169: WHERE RENDITION_ID = P_RENDITION_ID;
170:
171: IF (SQL%NOTFOUND) THEN
172: RAISE NO_DATA_FOUND;

Line 208: FROM IBC_RENDITIONS

204: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
205:
206: -- get updatedby and update_date values if existing in db
207: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
208: FROM IBC_RENDITIONS
209: WHERE RENDITION_ID = P_RENDITION_ID;
210:
211:
212: IF l_file_name IS NULL THEN

Line 271: Ibc_Renditions_Pkg.LOAD_ROW(

267: BEGIN
268: IF (p_UPLOAD_MODE = 'NLS') THEN
269: NULL;
270: ELSE
271: Ibc_Renditions_Pkg.LOAD_ROW(
272: P_UPLOAD_MODE => P_UPLOAD_MODE,
273: P_RENDITION_ID => P_RENDITION_ID,
274: P_LANGUAGE => P_LANGUAGE,
275: P_FILE_ID => P_FILE_ID,

Line 288: END Ibc_Renditions_Pkg;

284:
285: END LOAD_SEED_ROW;
286:
287:
288: END Ibc_Renditions_Pkg;