APPS.CN_SYIN_RULES_PKG dependencies on CN_RULES_ALL_TL

Line 186: insert into CN_RULES_ALL_TL (

182: L_LAST_UPDATE_LOGIN,
183: L_ORG_ID
184: );
185:
186: insert into CN_RULES_ALL_TL (
187: NAME,
188: LAST_UPDATE_DATE,
189: LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN,

Line 214: from CN_RULES_ALL_TL T

210: from FND_LANGUAGES L
211: where L.INSTALLED_FLAG in ('I', 'B')
212: and not exists
213: (select NULL
214: from CN_RULES_ALL_TL T
215: where T.RULE_ID = L_RULE_ID
216: and T.RULESET_ID = L_RULESET_ID --RC 06-APR-99 Added code
217: and T.LANGUAGE = L.language_code AND
218: T.ORG_ID=L_ORG_ID);

Line 273: update CN_RULES_ALL_TL set

269: if (sql%notfound) then
270: raise no_data_found;
271: end if;
272:
273: update CN_RULES_ALL_TL set
274: NAME = X_NAME,
275: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
276: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
277: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 308: delete from CN_RULES_ALL_TL

304: DELETE cn_rules_hierarchy
305: WHERE rule_id = x_rule_id
306: AND ruleset_id = x_ruleset_id;
307:
308: delete from CN_RULES_ALL_TL
309: where RULE_ID = X_RULE_ID
310: and ruleset_id = x_ruleset_id
311: and ORG_ID=X_ORG_ID;
312:

Line 344: delete from CN_RULES_ALL_TL T

340:
341: procedure ADD_LANGUAGE
342: is
343: begin
344: delete from CN_RULES_ALL_TL T
345: where not exists
346: (select NULL
347: from CN_RULES_ALL_B B
348: where B.RULE_ID = T.RULE_ID

Line 353: update CN_RULES_ALL_TL T set (

349: and B.RULESET_ID = T.ruleset_id
350: and B.ORG_ID= T.ORG_ID
351: );
352:
353: update CN_RULES_ALL_TL T set (
354: NAME
355: ) = (select
356: B.NAME
357: from CN_RULES_ALL_TL B

Line 357: from CN_RULES_ALL_TL B

353: update CN_RULES_ALL_TL T set (
354: NAME
355: ) = (select
356: B.NAME
357: from CN_RULES_ALL_TL B
358: where B.RULE_ID = T.RULE_ID
359: and B.RULESET_ID = T.RULESET_ID
360: and B.LANGUAGE = T.source_lang
361: and B.ORG_ID= T.ORG_ID)

Line 370: from CN_RULES_ALL_TL SUBB, CN_RULES_ALL_TL SUBT

366: ) in (select
367: SUBT.RULE_ID,
368: SUBT.RULESET_ID,
369: SUBT.LANGUAGE
370: from CN_RULES_ALL_TL SUBB, CN_RULES_ALL_TL SUBT
371: where SUBB.RULE_ID = SUBT.RULE_ID
372: and SUBB.RULESET_ID = SUBT.RULESET_ID
373: and SUBB.LANGUAGE = SUBT.source_lang
374: and SUBB.ORG_ID=SUBT.ORG_ID

Line 381: insert into CN_RULES_ALL_TL (

377: or (SUBB.NAME is null and SUBT.NAME is not null)
378: or (SUBB.NAME is not null and SUBT.NAME is null)
379: ));
380:
381: insert into CN_RULES_ALL_TL (
382: NAME,
383: LAST_UPDATE_DATE,
384: LAST_UPDATED_BY,
385: LAST_UPDATE_LOGIN,

Line 405: from CN_RULES_ALL_TL B, FND_LANGUAGES L

401: B.RULE_ID,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG,
404: B.ORG_ID
405: from CN_RULES_ALL_TL B, FND_LANGUAGES L
406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL

Line 410: from CN_RULES_ALL_TL T

406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL
410: from CN_RULES_ALL_TL T
411: where T.RULE_ID = B.RULE_ID
412: and T.RULESET_ID = B.RULESET_ID
413: and T.LANGUAGE = L.language_code AND
414: T.ORG_ID=B.ORG_ID);

Line 935: UPDATE cn_rules_all_tl SET

931: x_org_id
932: );
933: END IF;
934: -- Load The record to _TL table
935: UPDATE cn_rules_all_tl SET
936: ruleset_id = x_ruleset_id,
937: name = x_name,
938: last_update_date = sysdate,
939: last_updated_by = user_id,

Line 948: INSERT INTO cn_rules_all_tl

944: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
945:
946: IF (SQL%NOTFOUND) THEN
947: -- Insert new record to _TL table
948: INSERT INTO cn_rules_all_tl
949: (rule_id,
950: ruleset_id,
951: name,
952: creation_date,

Line 976: FROM cn_rules_all_tl t

972: FROM fnd_languages l
973: WHERE l.installed_flag IN ('I', 'B')
974: AND NOT EXISTS
975: (SELECT NULL
976: FROM cn_rules_all_tl t
977: WHERE t.rule_id = x_rule_id and t.org_id=x_org_id
978: AND t.language = l.language_code);
979: END IF;
980: << end_load_row >>

Line 1009: UPDATE cn_rules_all_tl SET

1005: ELSE
1006: user_id := 0;
1007: END IF;
1008: -- Update the translation
1009: UPDATE cn_rules_all_tl SET
1010: name = x_name,
1011: last_update_date = sysdate,
1012: last_updated_by = user_id,
1013: last_update_login = 0,