APPS.CSC_PROFILE_CHECK_RULES_PKG dependencies on CSC_PROF_CHECK_RULES_TL

Line 102: INSERT INTO CSC_PROF_CHECK_RULES_TL(

98: decode( p_RIGHT_PAREN, G_MISS_CHAR, NULL, p_RIGHT_PAREN),
99: decode( p_SEEDED_FLAG, G_MISS_CHAR, NULL, ps_SEEDED_FLAG),
100: x_object_version_number);
101:
102: INSERT INTO CSC_PROF_CHECK_RULES_TL(
103: CHECK_ID,
104: SEQUENCE,
105: EXPRESSION,
106: CREATED_BY,

Line 128: from CSC_PROF_CHECK_RULES_TL T

124: from FND_LANGUAGES L
125: where L.INSTALLED_FLAG in ('I', 'B')
126: and not exists
127: ( select NULL
128: from CSC_PROF_CHECK_RULES_TL T
129: where T.CHECK_ID = P_CHECK_ID
130: and t.sequence = p_sequence
131: and T.LANGUAGE = L.LANGUAGE_CODE );
132:

Line 173: update CSC_PROF_CHECK_RULES_TL set

169: where CHECK_ID = p_CHECK_ID
170: and SEQUENCE = p_SEQUENCE
171: returning OBJECT_VERSION_NUMBER INTO px_OBJECT_VERSION_NUMBER;
172:
173: update CSC_PROF_CHECK_RULES_TL set
174: EXPRESSION = p_EXPRESSION,
175: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
176: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
177: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 213: from CSC_PROF_CHECK_RULES_TL

209:
210: cursor c1 is select
211: EXPRESSION,
212: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
213: from CSC_PROF_CHECK_RULES_TL
214: where CHECK_ID = P_CHECK_ID
215: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
216: and SEQUENCE = p_SEQUENCE
217: for update of CHECK_ID nowait;

Line 236: delete from CSC_PROF_CHECK_RULES_TL

232: P_SEQUENCE NUMBER,
233: P_OBJECT_VERSION_NUMBER NUMBER
234: ) is
235: begin
236: delete from CSC_PROF_CHECK_RULES_TL
237: where CHECK_ID = P_CHECK_ID
238: and SEQUENCE = p_SEQUENCE;
239:
240: if (sql%notfound) then

Line 258: delete from CSC_PROF_CHECK_RULES_TL T

254:
255: procedure ADD_LANGUAGE
256: is
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

Line 266: update CSC_PROF_CHECK_RULES_TL T set (

262: where B.CHECK_ID = T.CHECK_ID
263: and B.SEQUENCE = T.SEQUENCE
264: );
265:
266: update CSC_PROF_CHECK_RULES_TL T set (
267: EXPRESSION
268: ) = (select
269: B.EXPRESSION
270: from CSC_PROF_CHECK_RULES_TL B

Line 270: from CSC_PROF_CHECK_RULES_TL B

266: update CSC_PROF_CHECK_RULES_TL T set (
267: EXPRESSION
268: ) = (select
269: B.EXPRESSION
270: from CSC_PROF_CHECK_RULES_TL B
271: where B.CHECK_ID = T.CHECK_ID
272: and B.SEQUENCE = T.SEQUENCE
273: and B.LANGUAGE = T.SOURCE_LANG)
274: where (

Line 282: from CSC_PROF_CHECK_RULES_TL SUBB, CSC_PROF_CHECK_RULES_TL SUBT

278: ) in (select
279: SUBT.CHECK_ID,
280: SUBT.SEQUENCE,
281: SUBT.LANGUAGE
282: from CSC_PROF_CHECK_RULES_TL SUBB, CSC_PROF_CHECK_RULES_TL SUBT
283: where SUBB.CHECK_ID = SUBT.CHECK_ID
284: and SUBB.SEQUENCE = SUBT.SEQUENCE
285: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
286: and (SUBB.EXPRESSION <> SUBT.EXPRESSION

Line 291: insert into CSC_PROF_CHECK_RULES_TL (

287: or (SUBB.EXPRESSION is null and SUBT.EXPRESSION is not null)
288: or (SUBB.EXPRESSION is not null and SUBT.EXPRESSION is null)
289: ));
290:
291: insert into CSC_PROF_CHECK_RULES_TL (
292: CHECK_ID,
293: SEQUENCE,
294: EXPRESSION,
295: CREATED_BY,

Line 313: from CSC_PROF_CHECK_RULES_TL B, FND_LANGUAGES L

309: B.LAST_UPDATE_DATE,
310: B.LAST_UPDATE_LOGIN,
311: L.LANGUAGE_CODE,
312: B.SOURCE_LANG
313: from CSC_PROF_CHECK_RULES_TL B, FND_LANGUAGES L
314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL

Line 318: from CSC_PROF_CHECK_RULES_TL T

314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL
318: from CSC_PROF_CHECK_RULES_TL T
319: where T.CHECK_ID = B.CHECK_ID
320: and T.SEQUENCE = B.SEQUENCE
321: and T.LANGUAGE = L.LANGUAGE_CODE);
322: end ADD_LANGUAGE;

Line 333: UPDATE csc_prof_check_rules_tl

329: p_expression IN VARCHAR2,
330: p_owner IN VARCHAR2)
331: IS
332: BEGIN
333: UPDATE csc_prof_check_rules_tl
334: SET expression = NVL(p_expression,expression),
335: last_update_date = sysdate,
336: last_updated_by = fnd_load_util.owner_id(p_owner), /* removed the decode logic for R12 mandate DECODE(p_owner, 'SEED', 1, 0), */
337: last_update_login = 0,