1 PACKAGE Ibc_Citem_Version_Labels_Pkg AS
2 /* $Header: ibctcvls.pls 120.1 2005/07/29 15:07:20 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Citem_Version_Labels 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 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
12 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
13
14 PROCEDURE INSERT_ROW (
15 x_rowid OUT NOCOPY VARCHAR2
16 ,p_content_item_id IN NUMBER
17 ,p_label_code IN VARCHAR2
18 ,p_citem_version_id IN NUMBER
19 ,p_object_version_number IN NUMBER
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
27 PROCEDURE LOCK_ROW (
28 p_CONTENT_ITEM_ID IN NUMBER,
29 p_LABEL_CODE IN VARCHAR2,
30 p_CITEM_VERSION_ID IN NUMBER,
31 p_OBJECT_VERSION_NUMBER IN NUMBER
32 );
33
34 PROCEDURE UPDATE_ROW (
35 p_content_item_id IN NUMBER
36 ,p_label_code IN VARCHAR2
37 ,p_citem_version_id IN NUMBER DEFAULT NULL
38 ,p_last_updated_by IN NUMBER DEFAULT NULL
39 ,p_last_update_date IN DATE DEFAULT NULL
40 ,p_last_update_login IN NUMBER DEFAULT NULL
41 ,p_object_version_number IN NUMBER DEFAULT NULL
42 );
43
44 PROCEDURE DELETE_ROW (
45 p_CONTENT_ITEM_ID IN NUMBER,
46 p_LABEL_CODE IN VARCHAR2
47 );
48
49 PROCEDURE LOAD_ROW (
50 p_UPLOAD_MODE IN VARCHAR2,
51 p_CONTENT_ITEM_ID IN NUMBER,
52 p_LABEL_CODE IN VARCHAR2,
53 p_CITEM_VERSION_ID IN NUMBER,
54 p_OWNER IN VARCHAR2,
55 p_LAST_UPDATE_DATE IN VARCHAR2);
56
57 PROCEDURE LOAD_SEED_ROW (
58 p_UPLOAD_MODE IN VARCHAR2,
59 p_CONTENT_ITEM_ID IN NUMBER,
60 p_LABEL_CODE IN VARCHAR2,
61 p_CITEM_VERSION_ID IN NUMBER,
62 p_OWNER IN VARCHAR2,
63 p_LAST_UPDATE_DATE IN VARCHAR2);
64
65
66 END Ibc_Citem_Version_Labels_Pkg;