71: -- Parameters:
72: -- IN
73: -- p_api_version_number IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
76: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
77: -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
78: --
79: -- OUT:
72: -- IN
73: -- p_api_version_number IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
76: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
77: -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
78: --
79: -- OUT:
80: -- x_return_status OUT VARCHAR2
85: -- End of Comments
86: --
87: PROCEDURE Create_check_ratings(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: px_CHECK_RATING_ID IN OUT NOCOPY NUMBER ,
93: p_CHECK_ID IN NUMBER ,
86: --
87: PROCEDURE Create_check_ratings(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: px_CHECK_RATING_ID IN OUT NOCOPY NUMBER ,
93: p_CHECK_ID IN NUMBER ,
94: p_CHECK_RATING_GRADE IN VARCHAR2,
87: PROCEDURE Create_check_ratings(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: px_CHECK_RATING_ID IN OUT NOCOPY NUMBER ,
93: p_CHECK_ID IN NUMBER ,
94: p_CHECK_RATING_GRADE IN VARCHAR2,
95: p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,
110: );
111:
112: PROCEDURE Create_check_ratings(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
115: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
117: px_Check_Rating_ID IN OUT NOCOPY NUMBER,
118: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
111:
112: PROCEDURE Create_check_ratings(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
115: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
117: px_Check_Rating_ID IN OUT NOCOPY NUMBER,
118: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
119: X_Return_Status OUT NOCOPY VARCHAR2,
112: PROCEDURE Create_check_ratings(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
115: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
117: px_Check_Rating_ID IN OUT NOCOPY NUMBER,
118: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
119: X_Return_Status OUT NOCOPY VARCHAR2,
120: X_Msg_Count OUT NOCOPY NUMBER,
130: -- Parameters:
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
136: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
137: -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
138: --
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
136: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
137: -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
138: --
139: -- OUT:
145: -- End of Comments
146: --
147: PROCEDURE Update_check_ratings(
148: P_Api_Version_Number IN NUMBER,
149: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
152: p_CHECK_RATING_ID IN NUMBER,
153: p_CHECK_ID IN NUMBER,
146: --
147: PROCEDURE Update_check_ratings(
148: P_Api_Version_Number IN NUMBER,
149: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
152: p_CHECK_RATING_ID IN NUMBER,
153: p_CHECK_ID IN NUMBER,
154: p_CHECK_RATING_GRADE IN VARCHAR2,
147: PROCEDURE Update_check_ratings(
148: P_Api_Version_Number IN NUMBER,
149: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
152: p_CHECK_RATING_ID IN NUMBER,
153: p_CHECK_ID IN NUMBER,
154: p_CHECK_RATING_GRADE IN VARCHAR2,
155: p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,
169: );
170:
171: PROCEDURE Update_check_ratings(
172: P_Api_Version_Number IN NUMBER,
173: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
174: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
176: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
177: X_Return_Status OUT NOCOPY VARCHAR2,
170:
171: PROCEDURE Update_check_ratings(
172: P_Api_Version_Number IN NUMBER,
173: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
174: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
176: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
177: X_Return_Status OUT NOCOPY VARCHAR2,
178: X_Msg_Count OUT NOCOPY NUMBER,
171: PROCEDURE Update_check_ratings(
172: P_Api_Version_Number IN NUMBER,
173: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
174: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
176: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
177: X_Return_Status OUT NOCOPY VARCHAR2,
178: X_Msg_Count OUT NOCOPY NUMBER,
179: X_Msg_Data OUT NOCOPY VARCHAR2
188: -- Parameters:
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
194: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
195: -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
196: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
194: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
195: -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
196: --
197: -- OUT:
203: -- End of Comments
204: --
205: PROCEDURE Delete_check_ratings(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
208: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
209: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
210: P_CHECK_RATING_ID IN NUMBER,
211: X_Return_Status OUT NOCOPY VARCHAR2,
204: --
205: PROCEDURE Delete_check_ratings(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
208: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
209: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
210: P_CHECK_RATING_ID IN NUMBER,
211: X_Return_Status OUT NOCOPY VARCHAR2,
212: X_Msg_Count OUT NOCOPY NUMBER,
205: PROCEDURE Delete_check_ratings(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
208: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
209: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
210: P_CHECK_RATING_ID IN NUMBER,
211: X_Return_Status OUT NOCOPY VARCHAR2,
212: X_Msg_Count OUT NOCOPY NUMBER,
213: X_Msg_Data OUT NOCOPY VARCHAR2
218: -- Item level validation procedures
219: --
220:
221: PROCEDURE Validate_check_ratings(
222: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
223: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
224: P_Validation_mode IN VARCHAR2,
225: p_CHK_RATING_REC IN CHK_RATING_Rec_Type,
226: X_Return_Status OUT NOCOPY VARCHAR2,
219: --
220:
221: PROCEDURE Validate_check_ratings(
222: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
223: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
224: P_Validation_mode IN VARCHAR2,
225: p_CHK_RATING_REC IN CHK_RATING_Rec_Type,
226: X_Return_Status OUT NOCOPY VARCHAR2,
227: X_Msg_Count OUT NOCOPY NUMBER,