[Home] [Help]
PACKAGE: APPS.CSC_PROF_GROUP_CAT_PUB
Source
1 PACKAGE CSC_PROF_GROUP_CAT_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppcas.pls 115.8 2002/11/29 07:27:33 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROF_GROUP_CAT_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:PROF_GRP_CAT_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- ROW_ID
19 -- GROUP_CATEGORY_ID
20 -- GROUP_ID
21 -- CATEGORY_CODE
22 -- CATEGORY_SEQUENCE
23 -- CREATED_BY
24 -- CREATION_DATE
25 -- LAST_UPDATED_BY
26 -- LAST_UPDATE_DATE
27 -- LAST_UPDATE_LOGIN
28 -- SEEDED_FLAG
29 --
30 -- Required:
31 -- Defaults:
32 --
33 -- End of Comments
34
35 TYPE PROF_GRP_CAT_Rec_Type IS RECORD
36 (
37 ROW_ID ROWID,
38 GROUP_CATEGORY_ID NUMBER,
39 GROUP_ID NUMBER,
40 CATEGORY_CODE VARCHAR2(30),
41 CATEGORY_SEQUENCE NUMBER,
42 CREATED_BY NUMBER,
43 CREATION_DATE DATE,
44 LAST_UPDATED_BY NUMBER,
45 LAST_UPDATE_DATE DATE,
46 LAST_UPDATE_LOGIN NUMBER,
47 SEEDED_FLAG VARCHAR2(3)
48 );
49
50 G_MISS_PROF_GRP_CAT_REC PROF_GRP_CAT_Rec_Type;
51 TYPE PROF_GRP_CAT_Tbl_Type IS TABLE OF PROF_GRP_CAT_Rec_Type
52 INDEX BY BINARY_INTEGER;
53 G_MISS_PROF_GRP_CAT_TBL PROF_GRP_CAT_Tbl_Type;
54
55 TYPE PROF_GRP_CAT_sort_rec_type IS RECORD
56 (
57 -- Please define your own sort by record here.
58 GROUP_CATEGORY_ID NUMBER := NULL
59 );
60
61 -- *******************************************************
62 -- Start of Comments
63 -- *******************************************************
64 -- API Name: Create_csc_prof_group_cat
65 -- Type : Public
66 -- Pre-Req :
67 -- Parameters:
68 -- IN
69 -- p_api_version_number IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
71 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
72 -- P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type Required
73 --
74 -- OUT :
75 -- x_return_status OUT NOCOPY VARCHAR2
76 -- x_msg_count OUT NOCOPY NUMBER
77 -- x_msg_data OUT NOCOPY VARCHAR2
78 -- Version : Current version 1.0
79 --
80 -- End of Comments
81 --
82
83 PROCEDURE Create_csc_prof_group_cat(
84 P_Api_Version_Number IN NUMBER,
85 P_Init_Msg_List IN VARCHAR2,
86 P_Commit IN VARCHAR2,
87 px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
88 p_GROUP_ID NUMBER DEFAULT NULL,
89 p_CATEGORY_CODE VARCHAR2 DEFAULT NULL,
90 p_CATEGORY_SEQUENCE NUMBER DEFAULT NULL,
91 p_CREATED_BY NUMBER DEFAULT NULL,
92 p_CREATION_DATE DATE DEFAULT NULL,
93 p_LAST_UPDATED_BY NUMBER DEFAULT NULL,
94 p_LAST_UPDATE_DATE DATE DEFAULT NULL,
95 p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
96 p_SEEDED_FLAG VARCHAR2 DEFAULT NULL,
97 X_Return_Status OUT NOCOPY VARCHAR2,
98 X_Msg_Count OUT NOCOPY NUMBER,
99 X_Msg_Data OUT NOCOPY VARCHAR2
100 );
101
102
103
104 PROCEDURE Create_csc_prof_group_cat(
105 P_Api_Version_Number IN NUMBER,
106 P_Init_Msg_List IN VARCHAR2,
107 P_Commit IN VARCHAR2,
108 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
109 PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
110 X_Return_Status OUT NOCOPY VARCHAR2,
111 X_Msg_Count OUT NOCOPY NUMBER,
112 X_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115 -- *******************************************************
116 -- Start of Comments
117 -- *******************************************************
118 -- API Name: Update_csc_prof_group_cat
119 -- Type : Public
120 -- Pre-Req :
121 -- Parameters:
122 -- IN
123 -- p_api_version_number IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126 -- P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type Required
127 --
128 -- OUT :
129 -- x_return_status OUT NOCOPY VARCHAR2
130 -- x_msg_count OUT NOCOPY NUMBER
131 -- x_msg_data OUT NOCOPY VARCHAR2
132 -- Version : Current version 1.0
133 --
134 -- End of Comments
135 --
136
137 PROCEDURE Update_csc_prof_group_cat(
138 P_Api_Version_Number IN NUMBER DEFAULT NULL,
139 P_Init_Msg_List IN VARCHAR2 DEFAULT NULL,
140 P_Commit IN VARCHAR2 DEFAULT NULL,
141 p_GROUP_CATEGORY_ID IN NUMBER DEFAULT NULL,
142 p_GROUP_ID NUMBER DEFAULT NULL,
143 p_CATEGORY_CODE VARCHAR2 DEFAULT NULL,
144 p_CATEGORY_SEQUENCE NUMBER DEFAULT NULL,
145 p_CREATED_BY NUMBER DEFAULT NULL,
146 p_CREATION_DATE DATE DEFAULT NULL,
147 p_LAST_UPDATED_BY NUMBER DEFAULT NULL,
148 p_LAST_UPDATE_DATE DATE DEFAULT NULL,
149 p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
150 p_SEEDED_FLAG VARCHAR2 DEFAULT NULL,
151 X_Return_Status OUT NOCOPY VARCHAR2,
152 X_Msg_Count OUT NOCOPY NUMBER,
153 X_Msg_Data OUT NOCOPY VARCHAR2
154 );
155
156
157 PROCEDURE Update_csc_prof_group_cat(
158 P_Api_Version_Number IN NUMBER,
159 P_Init_Msg_List IN VARCHAR2,
160 P_Commit IN VARCHAR2,
161 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
162 X_Return_Status OUT NOCOPY VARCHAR2,
163 X_Msg_Count OUT NOCOPY NUMBER,
164 X_Msg_Data OUT NOCOPY VARCHAR2
165 );
166
167 -- *******************************************************
168 -- Start of Comments
169 -- *******************************************************
170 -- API Name: Delete_csc_prof_group_cat
171 -- Type : Public
172 -- Pre-Req :
173 -- Parameters:
174 -- IN
175 -- p_api_version_number IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178 -- P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type Required
179 --
180 -- OUT :
181 -- x_return_status OUT NOCOPY VARCHAR2
182 -- x_msg_count OUT NOCOPY NUMBER
183 -- x_msg_data OUT NOCOPY VARCHAR2
184 --
185 PROCEDURE Delete_csc_prof_group_cat(
186 P_Api_Version_Number IN NUMBER,
187 P_Init_Msg_List IN VARCHAR2,
188 P_Commit IN VARCHAR2,
189 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
190 X_Return_Status OUT NOCOPY VARCHAR2,
191 X_Msg_Count OUT NOCOPY NUMBER,
192 X_Msg_Data OUT NOCOPY VARCHAR2
193 );
194
195
196 End CSC_PROF_GROUP_CAT_PUB;