APPS.CN_SYIN_RULESETS_PKG dependencies on CN_RULESETS_ALL_TL

Line 89: insert into CN_RULESETS_ALL_TL (

85: 1,
86: x_org_id
87: );
88:
89: insert into CN_RULESETS_ALL_TL (
90: CREATED_BY,
91: LAST_UPDATE_DATE,
92: LAST_UPDATED_BY,
93: LAST_UPDATE_LOGIN,

Line 115: from CN_RULESETS_ALL_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from CN_RULESETS_ALL_TL T
116: where T.RULESET_ID = x_RULESET_ID
117: and T.LANGUAGE = L.language_code AND
118: T.ORG_ID=x_org_id);
119:

Line 176: update CN_RULESETS_ALL_TL set

172: if (sql%notfound) then
173: raise no_data_found;
174: end if;
175:
176: update CN_RULESETS_ALL_TL set
177: NAME = X_NAME,
178: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
179: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
180: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 196: delete from CN_RULESETS_ALL_TL

192: X_RULESET_ID in NUMBER,
193: X_ORG_ID IN NUMBER
194: ) is
195: begin
196: delete from CN_RULESETS_ALL_TL
197: where RULESET_ID = x_ruleset_id AND
198: ORG_ID=X_ORG_ID;
199:
200: if (sql%notfound) then

Line 216: delete from CN_RULESETS_ALL_TL T

212:
213: procedure ADD_LANGUAGE
214: is
215: begin
216: delete from CN_RULESETS_ALL_TL T
217: where not exists
218: (select NULL
219: from CN_RULESETS_ALL_B B
220: where B.RULESET_ID = T.ruleset_id

Line 224: update CN_RULESETS_ALL_TL T set (

220: where B.RULESET_ID = T.ruleset_id
221: and B.ORG_ID = T.ORG_ID
222: );
223:
224: update CN_RULESETS_ALL_TL T set (
225: NAME
226: ) = (select
227: B.NAME
228: from CN_RULESETS_ALL_TL B

Line 228: from CN_RULESETS_ALL_TL B

224: update CN_RULESETS_ALL_TL T set (
225: NAME
226: ) = (select
227: B.NAME
228: from CN_RULESETS_ALL_TL B
229: where B.RULESET_ID = T.RULESET_ID
230: and B.LANGUAGE = T.source_lang
231: and B.ORG_ID = T.ORG_ID )
232: where (

Line 238: from CN_RULESETS_ALL_TL SUBB, CN_RULESETS_ALL_TL SUBT

234: T.LANGUAGE
235: ) in (select
236: SUBT.RULESET_ID,
237: SUBT.LANGUAGE
238: from CN_RULESETS_ALL_TL SUBB, CN_RULESETS_ALL_TL SUBT
239: where SUBB.RULESET_ID = SUBT.RULESET_ID
240: and SUBB.LANGUAGE = SUBT.source_lang
241: and SUBB.ORG_ID = SUBT.ORG_ID
242: and (SUBB.NAME <> SUBT.name

Line 247: insert into CN_RULESETS_ALL_TL (

243: or (SUBB.NAME is null and SUBT.NAME is not null)
244: or (SUBB.NAME is not null and SUBT.NAME is null)
245: ));
246:
247: insert into CN_RULESETS_ALL_TL (
248: ORG_ID,
249: CREATED_BY,
250: LAST_UPDATE_DATE,
251: LAST_UPDATED_BY,

Line 269: from CN_RULESETS_ALL_TL B, FND_LANGUAGES L

265: B.NAME,
266: B.RULESET_ID,
267: L.LANGUAGE_CODE,
268: B.SOURCE_LANG
269: from CN_RULESETS_ALL_TL B, FND_LANGUAGES L
270: where L.INSTALLED_FLAG in ('I', 'B')
271: and B.LANGUAGE = userenv('LANG')
272: and not exists
273: (select NULL

Line 274: from CN_RULESETS_ALL_TL T

270: where L.INSTALLED_FLAG in ('I', 'B')
271: and B.LANGUAGE = userenv('LANG')
272: and not exists
273: (select NULL
274: from CN_RULESETS_ALL_TL T
275: where T.RULESET_ID = B.RULESET_ID
276: and T.LANGUAGE = L.LANGUAGE_CODE
277: and T.ORG_ID = B.ORG_ID );
278: end ADD_LANGUAGE;

Line 349: UPDATE cn_rulesets_all_tl SET

345: x_org_id
346: );
347: END IF;
348: -- Load The record to _TL table
349: UPDATE cn_rulesets_all_tl SET
350: name = x_name,
351: last_update_date = sysdate,
352: last_updated_by = user_id,
353: last_update_login = 0,

Line 360: INSERT INTO cn_rulesets_all_tl

356: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
357:
358: IF (SQL%NOTFOUND) THEN
359: -- Insert new record to _TL table
360: INSERT INTO cn_rulesets_all_tl
361: (ruleset_id,
362: name,
363: creation_date,
364: created_by,

Line 386: FROM cn_rulesets_all_tl t

382: FROM fnd_languages l
383: WHERE l.installed_flag IN ('I', 'B')
384: AND NOT EXISTS
385: (SELECT NULL
386: FROM cn_rulesets_all_tl t
387: WHERE t.ruleset_id = x_ruleset_id and t.org_id=x_org_id
388: AND t.language = l.language_code);
389: END IF;
390: << end_load_row >>

Line 417: UPDATE cn_rulesets_all_tl SET

413: ELSE
414: user_id := 0;
415: END IF;
416: -- Update the translation
417: UPDATE cn_rulesets_all_tl SET
418: name = x_name,
419: last_update_date = sysdate,
420: last_updated_by = user_id,
421: last_update_login = 0,