1 PACKAGE Ibc_Renditions_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctrens.pls 120.1 2005/07/29 15:05:25 appldev ship $ */
3
4 -- MODIFICATION HISTORY
5 -- Person Date Comments
6 -- --------- ------ ------------------------------------------
7 -- vicho 11/05/2002 Remove G_MISS defaulting on UPDATE_ROW
8 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
9 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
10
11 PROCEDURE INSERT_ROW (
12 PX_ROWID IN OUT NOCOPY VARCHAR2,
13 Px_RENDITION_ID IN OUT NOCOPY NUMBER,
14 P_OBJECT_VERSION_NUMBER IN NUMBER,
15 P_LANGUAGE IN VARCHAR2,
16 P_FILE_ID IN NUMBER,
17 P_FILE_NAME IN VARCHAR2,
18 P_CITEM_VERSION_ID IN NUMBER,
19 P_MIME_TYPE IN VARCHAR2,
20 P_CREATION_DATE IN DATE DEFAULT NULL,
21 P_CREATED_BY IN NUMBER DEFAULT NULL,
22 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
23 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
24 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
25 );
26 PROCEDURE LOCK_ROW (
27 P_RENDITION_ID IN NUMBER,
28 P_OBJECT_VERSION_NUMBER IN NUMBER,
29 P_FILE_ID IN NUMBER,
30 P_FILE_NAME IN VARCHAR2,
31 P_CITEM_VERSION_ID IN NUMBER,
32 P_MIME_TYPE IN VARCHAR2
33 );
34 PROCEDURE UPDATE_ROW (
35 P_RENDITION_ID IN NUMBER DEFAULT NULL,
36 P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL,
37 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
38 P_FILE_ID IN NUMBER DEFAULT NULL,
39 P_FILE_NAME IN VARCHAR2 DEFAULT NULL,
40 P_CITEM_VERSION_ID IN NUMBER DEFAULT NULL,
41 P_MIME_TYPE IN VARCHAR2 DEFAULT NULL,
42 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
43 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
44 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
45 );
46
47 PROCEDURE DELETE_ROW (
48 P_RENDITION_ID IN NUMBER
49 );
50
51
52 PROCEDURE LOAD_ROW (
53 P_UPLOAD_MODE IN VARCHAR2 default null,
54 P_RENDITION_ID IN NUMBER,
55 P_LANGUAGE IN VARCHAR2,
56 P_FILE_ID IN NUMBER,
57 P_FILE_NAME IN VARCHAR2,
58 P_CITEM_VERSION_ID IN NUMBER,
59 P_mime_type IN VARCHAR2,
60 p_OWNER IN VARCHAR2,
61 p_LAST_UPDATE_DATE IN VARCHAR2 default null
62 );
63
64 PROCEDURE LOAD_SEED_ROW (
65 P_UPLOAD_MODE IN VARCHAR2,
66 P_RENDITION_ID IN NUMBER,
67 P_LANGUAGE IN VARCHAR2,
68 P_FILE_ID IN NUMBER,
69 P_FILE_NAME IN VARCHAR2,
70 P_CITEM_VERSION_ID IN NUMBER,
71 P_mime_type IN VARCHAR2,
72 p_OWNER IN VARCHAR2,
73 p_LAST_UPDATE_DATE IN VARCHAR2
74 );
75
76 END Ibc_Renditions_Pkg;