APPS.CSC_PROF_CHECKS_PKG dependencies on CSC_PROF_CHECKS_B

Line 74: INSERT INTO CSC_PROF_CHECKS_b(

70: CLOSE C2;
71: End If;
72:
73: -- to_date(NULL) added to include timestamp during creation
74: INSERT INTO CSC_PROF_CHECKS_b(
75: CHECK_ID,
76: CHECK_NAME_CODE,
77: START_DATE_ACTIVE,
78: END_DATE_ACTIVE,

Line 179: Update CSC_PROF_CHECKS_B

175: p_APPLICATION_ID NUMBER)
176:
177: IS
178: BEGIN
179: Update CSC_PROF_CHECKS_B
180: SET
181: CHECK_NAME_CODE = p_CHECK_NAME_CODE,
182: START_DATE_ACTIVE = p_START_DATE_ACTIVE,
183: END_DATE_ACTIVE = p_END_DATE_ACTIVE,

Line 236: from CSC_PROF_CHECKS_B

232: THRESHOLD_RATING_CODE,
233: THRESHOLD_COLOR_CODE,
234: CHECK_LEVEL,
235: CHECK_UPPER_LOWER_FLAG
236: from CSC_PROF_CHECKS_B
237: where CHECK_ID = P_CHECK_ID
238: and object_version_number = P_OBJECT_VERSION_NUMBER
239: for update of CHECK_ID nowait;
240: recinfo c%rowtype;

Line 273: delete from CSC_PROF_CHECKS_B

269: if (sql%notfound) then
270: raise no_data_found;
271: end if;
272:
273: delete from CSC_PROF_CHECKS_B
274: where CHECK_ID = P_CHECK_ID
275: and OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER;
276:
277: if (sql%notfound) then

Line 288: from CSC_PROF_CHECKS_B B

284: begin
285: delete from CSC_PROF_CHECKS_TL T
286: where not exists
287: (select NULL
288: from CSC_PROF_CHECKS_B B
289: where B.CHECK_ID = T.CHECK_ID
290: );
291:
292: update CSC_PROF_CHECKS_TL T set (