DBA Data[Home] [Help]

APPS.CSC_CHECK_RATINGS_PVT dependencies on CSC_CORE_UTILS_PVT

Line 75: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

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:

Line 76: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

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

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

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 ,

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

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,

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

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,

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

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,

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

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,

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

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,

Line 134: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

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: --

Line 135: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

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:

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

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,

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

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,

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

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,

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

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,

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

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,

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

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

Line 192: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

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: --

Line 193: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

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:

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

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,

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

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,

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

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

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

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,

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

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,