1 PACKAGE Ibc_Compound_Relations_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctcrls.pls 120.1 2005/07/29 15:03:04 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Compound_Relations 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 -- to the APIs
13 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
14 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
15
16 PROCEDURE INSERT_ROW (
17 x_rowid OUT NOCOPY VARCHAR2
18 ,px_compound_relation_id IN OUT NOCOPY NUMBER
19 ,p_content_item_id IN NUMBER
20 ,p_attribute_type_code IN VARCHAR2
21 ,p_content_type_code IN VARCHAR2
22 ,p_citem_version_id IN NUMBER
23 ,p_object_version_number IN NUMBER
24 ,p_sort_order IN NUMBER
25 ,p_creation_date IN DATE DEFAULT NULL
26 ,p_created_by IN NUMBER DEFAULT NULL
27 ,p_last_update_date IN DATE DEFAULT NULL
28 ,p_last_updated_by IN NUMBER DEFAULT NULL
29 ,p_last_update_login IN NUMBER DEFAULT NULL
30 ,p_subitem_version_id IN NUMBER DEFAULT NULL
31 );
32
33 PROCEDURE LOCK_ROW (
34 p_compound_relation_id IN NUMBER,
35 p_CONTENT_ITEM_ID IN NUMBER,
36 p_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
37 p_CONTENT_TYPE_CODE IN VARCHAR2,
38 p_CITEM_VERSION_ID IN NUMBER,
39 p_OBJECT_VERSION_NUMBER IN NUMBER,
40 p_SORT_ORDER IN NUMBER
41 );
42
43 PROCEDURE UPDATE_ROW (
44 p_compound_relation_id IN NUMBER
45 ,p_attribute_type_code IN VARCHAR2 DEFAULT NULL
46 ,p_citem_version_id IN NUMBER DEFAULT NULL
47 ,p_content_item_id IN NUMBER DEFAULT NULL
48 ,p_content_type_code IN VARCHAR2 DEFAULT NULL
49 ,p_last_updated_by IN NUMBER DEFAULT NULL
50 ,p_last_update_date IN DATE DEFAULT NULL
51 ,p_last_update_login IN NUMBER DEFAULT NULL
52 ,p_object_version_number IN NUMBER DEFAULT NULL
53 ,p_sort_order IN NUMBER DEFAULT NULL
54 ,p_subitem_version_id IN NUMBER DEFAULT NULL
55 );
56
57 PROCEDURE DELETE_ROW (
58 p_compound_relation_id IN NUMBER
59 );
60
61 PROCEDURE LOAD_ROW (
62 p_UPLOAD_MODE IN VARCHAR2,
63 p_CONTENT_ITEM_ID NUMBER,
64 p_ATTRIBUTE_TYPE_CODE VARCHAR2,
65 p_CONTENT_TYPE_CODE VARCHAR2,
66 p_COMPOUND_RELATION_ID NUMBER,
67 p_CITEM_VERSION_ID NUMBER,
68 p_SORT_ORDER NUMBER,
69 p_OWNER IN VARCHAR2,
70 p_subitem_version_id IN NUMBER DEFAULT NULL,
71 p_LAST_UPDATE_DATE IN VARCHAR2);
72
73 PROCEDURE LOAD_SEED_ROW (
74 p_UPLOAD_MODE IN VARCHAR2,
75 p_CONTENT_ITEM_ID NUMBER,
76 p_ATTRIBUTE_TYPE_CODE VARCHAR2,
77 p_CONTENT_TYPE_CODE VARCHAR2,
78 p_COMPOUND_RELATION_ID NUMBER,
79 p_CITEM_VERSION_ID NUMBER,
80 p_SORT_ORDER NUMBER,
81 p_OWNER IN VARCHAR2,
82 p_subitem_version_id IN NUMBER DEFAULT NULL,
83 p_LAST_UPDATE_DATE IN VARCHAR2);
84
85 END Ibc_Compound_Relations_Pkg;