1 PACKAGE Ibc_Cv_Label_Grp AUTHID CURRENT_USER AS
2 /* $Header: ibcgcvls.pls 115.3 2002/11/15 00:48:06 svatsa ship $ */
3
4 -- Purpose: API to Populate Citem Version Labels.
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 NOCOPY
11
12 -- Package name : IBC_CV_LABEL_GRP
13 -- Purpose :
14 -- History :
15 -- NOTE :
16 -- End of Comments
17
18
19
20 -- Default number of records fetch per call
21 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
22
23 TYPE CV_Label_Rec_Type IS RECORD(
24 CONTENT_ITEM_ID NUMBER
25 ,CITEM_VERSION_ID NUMBER
26 ,LABEL_CODE VARCHAR2(30)
27 ,CREATED_BY NUMBER
28 ,CREATION_DATE DATE
29 ,LAST_UPDATED_BY NUMBER
30 ,LAST_UPDATE_DATE DATE
31 ,LAST_UPDATE_LOGIN NUMBER
32 ,OBJECT_VERSION_NUMBER NUMBER
33 );
34
35 G_MISS_CV_Label_Rec CV_Label_Rec_Type;
36
37 TYPE CV_Label_TBL_Type IS TABLE OF CV_Label_Rec_Type;
38
39 G_MISS_CV_Label_TBL CV_Label_TBL_Type;
40
41
42 -- *******************************************************
43 -- Start of Comments
44 -- *******************************************************
45 -- API Name: Create_CV_Label
46 -- Type : Public
47 -- Pre-Req :
48 -- Parameters:
49 -- IN
50 -- p_api_version_number IN NUMBER Required
51 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
52 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
53 -- P_CV_Label_Rec IN CV_Label_Rec_Type Required
54 -- P_Sub_Directory_Tbl IN Sub_Directory_Tbl_Type Required
55 --
56 -- OUT:
57 -- x_return_status OUT NOCOPY VARCHAR2
58 -- x_msg_count OUT NOCOPY NUMBER
59 -- x_msg_data OUT NOCOPY VARCHAR2
60 --
61 -- End of Comments
62 --
63 PROCEDURE Create_CV_Label(
64 P_Api_Version_Number IN NUMBER
65 ,P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE
66 ,P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE
67 ,P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
68 ,P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type := Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec
69 ,x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type
70 ,X_Return_Status OUT NOCOPY VARCHAR2
71 ,X_Msg_Count OUT NOCOPY NUMBER
72 ,X_Msg_Data OUT NOCOPY VARCHAR2
73 );
74
75
76 -- *******************************************************
77 -- Start of Comments
78 -- *******************************************************
79 -- API Name: Update_CV_Label
80 -- Type : Public
81 -- Pre-Req :
82 -- Parameters:
83 -- IN
84 -- p_api_version_number IN NUMBER Required
85 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87 -- P_CV_Label_Rec IN CV_Label_Rec_Type Required
88 -- P_Sub_Directory_Tbl IN Sub_Directory_Tbl_Type Required
89 --
90 -- OUT:
91 -- x_return_status OUT NOCOPY VARCHAR2
92 -- x_msg_count OUT NOCOPY NUMBER
93 -- x_msg_data OUT NOCOPY VARCHAR2
94 --
95 -- End of Comments
96 --
97
98
99 PROCEDURE Update_CV_Label(
100 P_Api_Version_Number IN NUMBER
101 ,P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE
102 ,P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE
103 ,P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
104 ,P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type := Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec
105 ,x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type
106 ,X_Return_Status OUT NOCOPY VARCHAR2
107 ,X_Msg_Count OUT NOCOPY NUMBER
108 ,X_Msg_Data OUT NOCOPY VARCHAR2
109 );
110
111 -- *******************************************************
112 -- Start of Comments
113 -- *******************************************************
114 -- API Name: Delete_CV_Label
115 -- Type : Public
116 -- Pre-Req :
117 -- Parameters:
118 -- IN
119 -- p_api_version_number IN NUMBER Required
120 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
121 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
122 -- P_CV_Label_Code IN VARCHAR2 Required
123 --
124 -- OUT:
125 -- x_return_status OUT NOCOPY VARCHAR2
126 -- x_msg_count OUT NOCOPY NUMBER
127 -- x_msg_data OUT NOCOPY VARCHAR2
128 --
129 -- End of Comments
130 --
131
132 PROCEDURE delete_CV_Label(
133 P_Api_Version_Number IN NUMBER
134 ,P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE
135 ,P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE
136 ,P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
137 ,P_Label_Code IN VARCHAR2
138 ,P_content_item_id IN NUMBER
139 ,X_Return_Status OUT NOCOPY VARCHAR2
140 ,X_Msg_Count OUT NOCOPY NUMBER
141 ,X_Msg_Data OUT NOCOPY VARCHAR2
142 );
143
144 PROCEDURE Upsert_Cv_Labels(
145 p_label_code IN VARCHAR2
146 ,p_content_item_ids IN JTF_NUMBER_TABLE
147 ,p_version_number IN JTF_NUMBER_TABLE
148 ,p_commit IN VARCHAR2
149 ,p_api_version_number IN NUMBER
150 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
151 ,x_return_status OUT NOCOPY VARCHAR2
152 ,x_msg_count OUT NOCOPY NUMBER
153 ,x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE Upsert_Cv_Labels(
157 p_label_code IN VARCHAR2
158 ,p_content_item_ids IN JTF_NUMBER_TABLE
159 ,p_citem_version_ids IN JTF_NUMBER_TABLE
160 ,p_commit IN VARCHAR2
161 ,p_api_version_number IN NUMBER
162 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
163 ,x_return_status OUT NOCOPY VARCHAR2
164 ,x_msg_count OUT NOCOPY NUMBER
165 ,x_msg_data OUT NOCOPY VARCHAR2
166 );
167
168 PROCEDURE Delete_Cv_Labels(
169 p_label_code IN VARCHAR2
170 ,p_content_item_ids IN JTF_NUMBER_TABLE
171 ,p_commit IN VARCHAR2
172 ,p_api_version_number IN NUMBER
173 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
174 ,x_return_status OUT NOCOPY VARCHAR2
175 ,x_msg_count OUT NOCOPY NUMBER
176 ,x_msg_data OUT NOCOPY VARCHAR2
177 );
178 END Ibc_Cv_Label_Grp;