1 PACKAGE IBC_CONTENT_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ibctctys.pls 120.2 2005/07/12 03:42:24 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Content_Types table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11 -- vicho 11/13/2002 Added Overloaded procedures for OA UI
12 -- shitij.vatsa 02/11/2003 Added parameter p_subitem_version_id
13 -- to the APIs
14 -- vicho 07/24/03 Fixed p_encrypt_flag to type, VARCHAR2
15 -- Subir Anshumali 06/03/2005 Declared OUT and IN OUT arguments as references using the NOCOPY hint.
16 -- Sharma 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
17 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
18
19 PROCEDURE INSERT_ROW (
20 x_rowid OUT NOCOPY VARCHAR2
21 ,p_content_type_code IN VARCHAR2
22 ,p_content_type_status IN VARCHAR2
23 ,p_application_id IN NUMBER
24 ,p_request_id IN NUMBER
25 ,p_object_version_number IN NUMBER
26 ,p_content_type_name IN VARCHAR2
27 ,p_description IN VARCHAR2
28 ,p_creation_date IN DATE DEFAULT NULL
29 ,p_created_by IN NUMBER DEFAULT NULL
30 ,p_last_update_date IN DATE DEFAULT NULL
31 ,p_last_updated_by IN NUMBER DEFAULT NULL
32 ,p_last_update_login IN NUMBER DEFAULT NULL
33 ,p_encrypt_flag IN VARCHAR2 DEFAULT NULL
34 ,p_OWNER_FND_USER_ID IN NUMBER DEFAULT NULL
35
36 );
37
38 PROCEDURE LOCK_ROW (
39 p_CONTENT_TYPE_CODE IN VARCHAR2,
40 p_CONTENT_TYPE_STATUS IN VARCHAR2,
41 p_APPLICATION_ID IN NUMBER,
42 p_REQUEST_ID IN NUMBER,
43 p_OBJECT_VERSION_NUMBER IN NUMBER,
44 p_CONTENT_TYPE_NAME IN VARCHAR2,
45 p_DESCRIPTION IN VARCHAR2
46 );
47 PROCEDURE UPDATE_ROW (
48 p_content_type_code IN VARCHAR2
49 ,p_application_id IN NUMBER DEFAULT NULL
50 ,p_content_type_name IN VARCHAR2 DEFAULT NULL
51 ,p_content_type_status IN VARCHAR2 DEFAULT NULL
52 ,p_description IN VARCHAR2 DEFAULT NULL
53 ,p_last_updated_by IN NUMBER DEFAULT NULL
54 ,p_last_update_date IN DATE DEFAULT NULL
55 ,p_last_update_login IN NUMBER DEFAULT NULL
56 ,p_object_version_number IN NUMBER DEFAULT NULL
57 ,p_request_id IN NUMBER DEFAULT NULL
58 ,p_encrypt_flag IN VARCHAR2 DEFAULT NULL
59 ,p_OWNER_FND_USER_ID IN NUMBER DEFAULT NULL
60 );
61
62 PROCEDURE DELETE_ROW (
63 p_CONTENT_TYPE_CODE IN VARCHAR2
64 );
65 PROCEDURE ADD_LANGUAGE;
66
67 PROCEDURE LOAD_SEED_ROW (
68 p_UPLOAD_MODE IN VARCHAR2,
69 p_CONTENT_TYPE_CODE IN VARCHAR2,
70 p_APPLICATION_ID IN NUMBER,
71 p_CONTENT_TYPE_NAME IN VARCHAR2,
72 p_CONTENT_TYPE_STATUS IN VARCHAR2,
73 p_DESCRIPTION IN VARCHAR2,
74 p_OWNER IN VARCHAR2,
75 p_OWNER_FND_USER_ID IN NUMBER DEFAULT NULL,
76 p_encrypt_flag IN VARCHAR2 DEFAULT NULL,
77 p_LAST_UPDATE_DATE IN VARCHAR2);
78
79 PROCEDURE LOAD_ROW (
80 p_UPLOAD_MODE IN VARCHAR2,
81 p_CONTENT_TYPE_CODE IN VARCHAR2,
82 p_APPLICATION_ID IN NUMBER,
83 p_CONTENT_TYPE_NAME IN VARCHAR2,
84 p_CONTENT_TYPE_STATUS IN VARCHAR2,
85 p_DESCRIPTION IN VARCHAR2,
86 p_OWNER IN VARCHAR2,
87 p_OWNER_FND_USER_ID IN NUMBER DEFAULT NULL,
88 p_encrypt_flag IN VARCHAR2 DEFAULT NULL,
89 p_LAST_UPDATE_DATE IN VARCHAR2);
90
91 PROCEDURE TRANSLATE_ROW (
92 p_UPLOAD_MODE IN VARCHAR2,
93 p_CONTENT_TYPE_CODE IN VARCHAR2,
94 p_CONTENT_TYPE_NAME IN VARCHAR2,
95 p_DESCRIPTION IN VARCHAR2,
96 p_OWNER IN VARCHAR2,
97 p_LAST_UPDATE_DATE IN VARCHAR2);
98
99
100 PROCEDURE INSERT_ROW (
101 X_ROWID IN OUT NOCOPY VARCHAR2,
102 X_CONTENT_TYPE_CODE IN VARCHAR2,
103 X_APPLICATION_ID IN NUMBER,
104 X_OWNER_FND_USER_ID IN NUMBER,
105 X_CONTENT_TYPE_STATUS IN VARCHAR2,
106 X_REQUEST_ID IN NUMBER,
107 -- x_program_update_date IN DATE,
108 -- x_program_application_id IN NUMBER,
109 -- x_program_id IN NUMBER,
110 X_OBJECT_VERSION_NUMBER IN NUMBER,
111 X_SECURITY_GROUP_ID IN NUMBER,
112 X_CONTENT_TYPE_NAME IN VARCHAR2,
113 X_DESCRIPTION IN VARCHAR2,
114 X_CREATION_DATE IN DATE,
115 X_CREATED_BY IN NUMBER,
116 X_LAST_UPDATE_DATE IN DATE,
117 X_LAST_UPDATED_BY IN NUMBER,
118 X_LAST_UPDATE_LOGIN IN NUMBER,
119 X_encrypt_flag IN VARCHAR2 DEFAULT NULL
120 );
121
122 procedure LOCK_ROW (
123 X_CONTENT_TYPE_CODE in VARCHAR2,
124 X_CONTENT_TYPE_STATUS in VARCHAR2 DEFAULT NULL,
125 X_ENCRYPT_FLAG in VARCHAR2 DEFAULT NULL,
126 X_APPLICATION_ID in NUMBER DEFAULT NULL,
127 X_REQUEST_ID in NUMBER DEFAULT NULL,
128 X_OWNER_FND_USER_ID in NUMBER DEFAULT NULL,
129 X_OBJECT_VERSION_NUMBER in NUMBER DEFAULT NULL,
130 X_SECURITY_GROUP_ID IN NUMBER DEFAULT NULL,
131 X_CONTENT_TYPE_NAME in VARCHAR2 DEFAULT NULL,
132 X_DESCRIPTION in VARCHAR2 DEFAULT NULL
133 );
134
135 PROCEDURE UPDATE_ROW (
136 X_CONTENT_TYPE_CODE IN VARCHAR2,
137 X_APPLICATION_ID IN NUMBER,
138 X_OWNER_FND_USER_ID IN NUMBER,
139 -- x_program_update_date IN DATE,
140 -- x_program_application_id IN NUMBER,
141 -- x_program_id IN NUMBER,
142 X_CONTENT_TYPE_STATUS IN VARCHAR2,
143 X_REQUEST_ID IN NUMBER,
144 X_OBJECT_VERSION_NUMBER IN NUMBER,
145 X_SECURITY_GROUP_ID IN NUMBER,
146 X_CONTENT_TYPE_NAME IN VARCHAR2,
147 X_DESCRIPTION IN VARCHAR2,
148 X_LAST_UPDATE_DATE IN DATE,
149 X_LAST_UPDATED_BY IN NUMBER,
150 X_LAST_UPDATE_LOGIN IN NUMBER,
151 X_encrypt_flag IN VARCHAR2 DEFAULT NULL
152 );
153
154 PROCEDURE DELETE_ROW (
155 X_CONTENT_TYPE_CODE IN VARCHAR2
156 );
157
158 PROCEDURE COPY_ROW(P_content_type_code IN VARCHAR2
159 );
160
161 PROCEDURE Sync_Content_types(p_new_content_type_code IN VARCHAR2
162 ,p_old_content_type_code IN VARCHAR2
163 );
164
165
166 END Ibc_Content_Types_Pkg;