DBA Data[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;