DBA Data[Home] [Help]

APPS.CSC_PROF_GROUP_CAT_PVT dependencies on CSC_CORE_UTILS_PVT

Line 79: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 80: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 81: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 133: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 134: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 135: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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

Line 187: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 188: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 189: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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

Line 207: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 223: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 239: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 256: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 278: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 279: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,