[Home] [Help]
PACKAGE: APPS.IBE_M_IBC_INT_PVT
Source
1 PACKAGE IBE_M_IBC_INT_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVIBCS.pls 115.0 2002/11/18 23:20:10 jshang noship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30):='IBE_M_IBC_INT_PVT';
5 g_api_version CONSTANT NUMBER := 1.0;
6
7 FUNCTION getTransLang(p_citem_version_id IN NUMBER,
8 p_base_language IN VARCHAR2)
9 RETURN VARCHAR2;
10
11 FUNCTION getLang(p_citem_version_id IN NUMBER)
12 RETURN VARCHAR2;
13
14 FUNCTION getLiveStatus(p_citem_id IN NUMBER, p_citem_version_id IN NUMBER)
15 RETURN VARCHAR2;
16
17 FUNCTION getLiveVersion(p_citem_id IN NUMBER)
18 RETURN NUMBER;
19
20 FUNCTION getStore(p_citem_id IN NUMBER)
21 RETURN VARCHAR2;
22
23 FUNCTION getAvalVersion(p_citem_id IN NUMBER)
24 RETURN NUMBER;
25
26 FUNCTION getAvalVersionId(p_citem_id IN NUMBER)
27 RETURN NUMBER;
28
29
30 PRAGMA RESTRICT_REFERENCES(getTransLang, WNDS, WNPS);
31 PRAGMA RESTRICT_REFERENCES(getLang, WNDS, WNPS);
32 PRAGMA RESTRICT_REFERENCES(getLiveStatus, WNDS, WNPS);
33 PRAGMA RESTRICT_REFERENCES(getLiveVersion, WNDS, WNPS);
34 PRAGMA RESTRICT_REFERENCES(getStore, WNDS, WNPS);
35 PRAGMA RESTRICT_REFERENCES(getAvalVersion, WNDS, WNPS);
36 PRAGMA RESTRICT_REFERENCES(getAvalVersionId, WNDS, WNPS);
37
38 PROCEDURE Batch_Update_Labels(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 p_content_item_id_tbl IN JTF_NUMBER_TABLE,
43 p_version_number_tbl IN JTF_NUMBER_TABLE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2);
47
48 PROCEDURE Update_Label_Association(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 p_old_content_item_id IN NUMBER DEFAULT NULL,
53 p_old_version_number IN NUMBER DEFAULT NULL,
54 p_new_content_item_id IN NUMBER,
55 p_new_version_number IN NUMBER,
56 p_media_object_id IN NUMBER DEFAULT NULL,
57 p_association_type_code IN VARCHAR2 DEFAULT NULL,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2);
61
62 PROCEDURE Delete_Label_Association(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 p_content_item_id IN NUMBER,
67 p_version_number IN NUMBER,
68 p_media_object_id IN NUMBER,
69 p_association_type_code IN VARCHAR2 DEFAULT NULL,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74 PROCEDURE Get_Object_Name(
75 p_association_type_code IN VARCHAR2,
76 p_associated_object_val1 IN VARCHAR2,
77 p_associated_object_val2 IN VARCHAR2,
78 p_associated_object_val3 IN VARCHAR2,
79 p_associated_object_val4 IN VARCHAR2,
80 p_associated_object_val5 IN VARCHAR2,
81 x_object_name OUT NOCOPY VARCHAR2,
82 x_object_code OUT NOCOPY VARCHAR2,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2);
86 END IBE_M_IBC_INT_PVT;