DBA Data[Home] [Help]

PACKAGE: APPS.IBC_RENDITIONS_PKG

Source


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;