75: -- End of Comments
76: --
77: PROCEDURE Create_csc_prof_group_cat(
78: P_Api_Version_Number IN NUMBER,
79: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
80: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
81: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
82: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
83: p_GROUP_ID IN NUMBER,
76: --
77: PROCEDURE Create_csc_prof_group_cat(
78: P_Api_Version_Number IN NUMBER,
79: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
80: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
81: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
82: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
83: p_GROUP_ID IN NUMBER,
84: p_CATEGORY_CODE IN VARCHAR2,
77: PROCEDURE Create_csc_prof_group_cat(
78: P_Api_Version_Number IN NUMBER,
79: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
80: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
81: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
82: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
83: p_GROUP_ID IN NUMBER,
84: p_CATEGORY_CODE IN VARCHAR2,
85: p_CATEGORY_SEQUENCE IN NUMBER,
95: );
96:
97: PROCEDURE Create_csc_prof_group_cat(
98: P_Api_Version_Number IN NUMBER,
99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102: PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,
96:
97: PROCEDURE Create_csc_prof_group_cat(
98: P_Api_Version_Number IN NUMBER,
99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102: PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,
104: X_Return_Status OUT NOCOPY VARCHAR2,
97: PROCEDURE Create_csc_prof_group_cat(
98: P_Api_Version_Number IN NUMBER,
99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102: PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,
104: X_Return_Status OUT NOCOPY VARCHAR2,
105: X_Msg_Count OUT NOCOPY NUMBER,
129: -- End of Comments
130: --
131: PROCEDURE Update_csc_prof_group_cat(
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
134: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
135: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
136: p_GROUP_CATEGORY_ID IN NUMBER,
137: p_GROUP_ID IN NUMBER,
130: --
131: PROCEDURE Update_csc_prof_group_cat(
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
134: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
135: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
136: p_GROUP_CATEGORY_ID IN NUMBER,
137: p_GROUP_ID IN NUMBER,
138: p_CATEGORY_CODE IN VARCHAR2,
131: PROCEDURE Update_csc_prof_group_cat(
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
134: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
135: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
136: p_GROUP_CATEGORY_ID IN NUMBER,
137: p_GROUP_ID IN NUMBER,
138: p_CATEGORY_CODE IN VARCHAR2,
139: p_CATEGORY_SEQUENCE IN NUMBER,
149: );
150:
151: PROCEDURE Update_csc_prof_group_cat(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
157: X_Return_Status OUT NOCOPY VARCHAR2,
150:
151: PROCEDURE Update_csc_prof_group_cat(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
157: X_Return_Status OUT NOCOPY VARCHAR2,
158: X_Msg_Count OUT NOCOPY NUMBER,
151: PROCEDURE Update_csc_prof_group_cat(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
157: X_Return_Status OUT NOCOPY VARCHAR2,
158: X_Msg_Count OUT NOCOPY NUMBER,
159: X_Msg_Data OUT NOCOPY VARCHAR2
183: --
184:
185: PROCEDURE Delete_csc_prof_group_cat(
186: P_Api_Version_Number IN NUMBER,
187: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
188: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
189: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
190: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
191: X_Return_Status 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 := CSC_CORE_UTILS_PVT.G_FALSE,
188: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
189: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
190: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
191: X_Return_Status OUT NOCOPY VARCHAR2,
192: X_Msg_Count OUT NOCOPY NUMBER,
185: PROCEDURE Delete_csc_prof_group_cat(
186: P_Api_Version_Number IN NUMBER,
187: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
188: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
189: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
190: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
191: X_Return_Status OUT NOCOPY VARCHAR2,
192: X_Msg_Count OUT NOCOPY NUMBER,
193: X_Msg_Data OUT NOCOPY VARCHAR2
203: --
204: -- End of Comments
205:
206: PROCEDURE Validate_GROUP_CATEGORY_ID (
207: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
208: P_Validation_mode IN VARCHAR2,
209: P_GROUP_CATEGORY_ID IN NUMBER,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
219: --
220: -- End of Comments
221:
222: PROCEDURE Validate_GROUP_ID (
223: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
224: P_Validation_mode IN VARCHAR2,
225: P_GROUP_ID IN NUMBER,
226: X_Return_Status OUT NOCOPY VARCHAR2,
227: X_Msg_Count OUT NOCOPY NUMBER,
235: --
236: -- End of Comments
237:
238: PROCEDURE Validate_CATEGORY_CODE (
239: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
240: P_Validation_mode IN VARCHAR2,
241: P_CATEGORY_CODE IN VARCHAR2,
242: P_GROUP_ID IN NUMBER,
243: X_Return_Status OUT NOCOPY VARCHAR2,
252: --
253: -- End of Comments
254:
255: PROCEDURE Validate_CATEGORY_SEQUENCE (
256: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
257: P_Validation_mode IN VARCHAR2,
258: P_CATEGORY_SEQUENCE IN NUMBER,
259: X_Return_Status OUT NOCOPY VARCHAR2,
260: X_Msg_Count OUT NOCOPY NUMBER,
274: --
275: -- End of Comments
276:
277: PROCEDURE Validate_csc_prof_group_cat(
278: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
279: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
280: P_Validation_mode IN VARCHAR2,
281: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
282: X_Return_Status OUT NOCOPY VARCHAR2,
275: -- End of Comments
276:
277: PROCEDURE Validate_csc_prof_group_cat(
278: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
279: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
280: P_Validation_mode IN VARCHAR2,
281: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
282: X_Return_Status OUT NOCOPY VARCHAR2,
283: X_Msg_Count OUT NOCOPY NUMBER,