[Home] [Help]
PACKAGE: APPS.IBC_CONTENT_ITEMS_PKG
Source
1 PACKAGE Ibc_Content_Items_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctcons.pls 120.1 2005/07/29 14:56:00 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Content_Items 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 -- shitij.vatsa 02/11/2003 Added parameter p_subitem_version_id
12 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
13 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
14
15
16 PROCEDURE INSERT_ROW (
17 x_rowid OUT NOCOPY VARCHAR2
18 ,px_content_item_id IN OUT NOCOPY NUMBER
19 ,p_content_type_code IN VARCHAR2
20 ,p_item_reference_code IN VARCHAR2
21 ,p_directory_node_id IN NUMBER
22 ,p_parent_item_id IN NUMBER
23 ,p_live_citem_version_id IN NUMBER
24 ,p_content_item_status IN VARCHAR2
25 ,p_locked_by_user_id IN NUMBER
26 ,p_wd_restricted_flag IN VARCHAR2
27 ,p_base_language IN VARCHAR2
28 ,p_translation_required_flag IN VARCHAR2
29 ,p_owner_resource_id IN NUMBER
30 ,p_owner_resource_type IN VARCHAR2
31 ,p_application_id IN NUMBER DEFAULT NULL
32 ,p_request_id IN NUMBER
33 ,p_object_version_number IN NUMBER DEFAULT 1
34 ,p_creation_date IN DATE DEFAULT NULL
35 ,p_created_by IN NUMBER DEFAULT NULL
36 ,p_last_update_date IN DATE DEFAULT NULL
37 ,p_last_updated_by IN NUMBER DEFAULT NULL
38 ,p_last_update_login IN NUMBER DEFAULT NULL
39 ,p_encrypt_flag IN VARCHAR2 DEFAULT NULL
40 );
41
42 PROCEDURE LOCK_ROW (
43 p_CONTENT_ITEM_ID IN NUMBER,
44 p_CONTENT_TYPE_CODE IN VARCHAR2,
45 p_ITEM_REFERENCE_CODE IN VARCHAR2,
46 p_DIRECTORY_NODE_ID IN NUMBER,
47 p_parent_item_ID IN NUMBER,
48 p_LIVE_CITEM_VERSION_ID IN NUMBER,
49 p_CONTENT_ITEM_STATUS IN VARCHAR2,
50 p_LOCKED_BY_USER_ID IN NUMBER,
51 p_WD_RESTRICTED_FLAG IN VARCHAR2,
52 p_BASE_LANGUAGE IN VARCHAR2,
53 p_TRANSLATION_REQUIRED_FLAG IN VARCHAR2,
54 p_OWNER_RESOURCE_ID IN NUMBER,
55 p_APPLICATION_ID IN NUMBER,
56 p_REQUEST_ID IN NUMBER,
57 p_OBJECT_VERSION_NUMBER IN NUMBER
58 );
59 PROCEDURE UPDATE_ROW (
60 p_content_item_id IN NUMBER
61 ,p_content_type_code IN VARCHAR2 DEFAULT NULL
62 ,p_item_reference_code IN VARCHAR2 DEFAULT NULL
63 ,p_directory_node_id IN NUMBER DEFAULT NULL
64 ,p_parent_item_id IN NUMBER DEFAULT NULL
65 ,p_live_citem_version_id IN NUMBER DEFAULT NULL
66 ,p_content_item_status IN VARCHAR2 DEFAULT NULL
67 ,p_locked_by_user_id IN NUMBER DEFAULT NULL
68 ,p_wd_restricted_flag IN VARCHAR2 DEFAULT NULL
69 ,p_base_language IN VARCHAR2 DEFAULT NULL
70 ,p_translation_required_flag IN VARCHAR2 DEFAULT NULL
71 ,p_owner_resource_id IN NUMBER DEFAULT NULL
72 ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
73 ,p_application_id IN NUMBER DEFAULT NULL
74 ,p_request_id IN NUMBER DEFAULT NULL
75 ,px_object_version_number IN OUT NOCOPY NUMBER
76 ,p_last_update_date IN DATE DEFAULT NULL
77 ,p_last_updated_by IN NUMBER DEFAULT NULL
78 ,p_last_update_login IN NUMBER DEFAULT NULL
79 ,p_encrypt_flag IN VARCHAR2 DEFAULT NULL
80 );
81
82 PROCEDURE DELETE_ROW (
83 p_CONTENT_ITEM_ID IN NUMBER
84 );
85
86 PROCEDURE LOAD_ROW (
87 p_UPLOAD_MODE VARCHAR2,
88 p_CONTENT_ITEM_ID NUMBER,
89 p_ITEM_REFERENCE_CODE VARCHAR2,
90 p_CONTENT_TYPE_CODE VARCHAR2,
91 p_DIRECTORY_NODE_ID NUMBER,
92 p_parent_item_ID IN NUMBER ,--DEFAULT NULL,
93 p_LIVE_CITEM_VERSION_ID NUMBER,
94 p_CONTENT_ITEM_STATUS VARCHAR2,
95 p_LOCKED_BY_USER_ID NUMBER,
96 --p_REUSABLE_FLAG VARCHAR2 DEFAULT NULL,
97 p_WD_RESTRICTED_FLAG VARCHAR2,
98 p_BASE_LANGUAGE VARCHAR2,
99 p_TRANSLATION_REQUIRED_FLAG VARCHAR2,
100 p_OWNER_RESOURCE_ID NUMBER,
101 p_OWNER_RESOURCE_TYPE VARCHAR2,
102 p_APPLICATION_ID NUMBER,
103 p_OWNER IN VARCHAR2,
104 p_ENCRYPT_FLAG IN VARCHAR2 DEFAULT NULL,
105 p_LAST_UPDATE_DATE VARCHAR2);
106
107 PROCEDURE LOAD_SEED_ROW (
108 p_UPLOAD_MODE VARCHAR2,
109 p_CONTENT_ITEM_ID NUMBER,
110 p_ITEM_REFERENCE_CODE VARCHAR2,
111 p_CONTENT_TYPE_CODE VARCHAR2,
112 p_DIRECTORY_NODE_ID NUMBER,
113 p_parent_item_ID IN NUMBER ,--DEFAULT NULL,
114 p_LIVE_CITEM_VERSION_ID NUMBER,
115 p_CONTENT_ITEM_STATUS VARCHAR2,
116 p_LOCKED_BY_USER_ID NUMBER,
117 --p_REUSABLE_FLAG VARCHAR2 DEFAULT NULL,
118 p_WD_RESTRICTED_FLAG VARCHAR2,
119 p_BASE_LANGUAGE VARCHAR2,
120 p_TRANSLATION_REQUIRED_FLAG VARCHAR2,
121 p_OWNER_RESOURCE_ID NUMBER,
122 p_OWNER_RESOURCE_TYPE VARCHAR2,
123 p_APPLICATION_ID NUMBER,
124 p_OWNER IN VARCHAR2,
125 p_ENCRYPT_FLAG IN VARCHAR2 DEFAULT NULL,
126 p_LAST_UPDATE_DATE VARCHAR2);
127
128
129 END Ibc_Content_Items_Pkg;