APPS.CSC_PROFILE_CHECK_RULES_PKG dependencies on CSC_PROF_CHECK_RULES_B

Line 67: INSERT INTO CSC_PROF_CHECK_RULES_B(

63: End If;
64: */
65: x_object_version_number := 1;
66:
67: INSERT INTO CSC_PROF_CHECK_RULES_B(
68: CHECK_ID,
69: SEQUENCE,
70: CREATED_BY,
71: CREATION_DATE,

Line 154: Update CSC_PROF_CHECK_RULES_B

150: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER)
151:
152: IS
153: BEGIN
154: Update CSC_PROF_CHECK_RULES_B
155: SET
156: SEQUENCE = p_SEQUENCE,
157: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
158: LAST_UPDATE_DATE =p_LAST_UPDATE_DATE,

Line 203: from CSC_PROF_CHECK_RULES_B

199: COMPARISON_OPERATOR,
200: EXPR_TO_BLOCK_ID,
201: RIGHT_PAREN,
202: OBJECT_VERSION_NUMBER
203: from CSC_PROF_CHECK_RULES_B
204: where CHECK_ID = P_CHECK_ID
205: and SEQUENCE = p_SEQUENCE
206: and object_version_number = P_OBJECT_VERSION_NUMBER
207: for update of CHECK_ID nowait;

Line 244: delete from CSC_PROF_CHECK_RULES_B

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: delete from CSC_PROF_CHECK_RULES_B
245: where CHECK_ID = P_CHECK_ID
246: and SEQUENCE = P_SEQUENCE
247: and OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER;
248:

Line 261: from CSC_PROF_CHECK_RULES_B B

257: begin
258: delete from CSC_PROF_CHECK_RULES_TL T
259: where not exists
260: (select NULL
261: from CSC_PROF_CHECK_RULES_B B
262: where B.CHECK_ID = T.CHECK_ID
263: and B.SEQUENCE = T.SEQUENCE
264: );
265: