APPS.AMS_CONTENT_RULES_B_PKG dependencies on AMS_CONTENT_RULES_TL

Line 126: INSERT INTO AMS_CONTENT_RULES_TL(

122: -- ADDED BY PRAGEORG ON 5/29/2006
123: , DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
124: );
125:
126: INSERT INTO AMS_CONTENT_RULES_TL(
127: content_rule_id,
128: last_update_date,
129: last_updated_by,
130: creation_date,

Line 150: from ams_content_rules_tl T

146: from FND_LANGUAGES L
147: where L.INSTALLED_FLAG in ('I', 'B')
148: and not exists
149: (select NULL
150: from ams_content_rules_tl T
151: where T.content_rule_ID = px_content_rule_id
152: and T.LANGUAGE = L.LANGUAGE_CODE);
153:
154: open c;

Line 223: update AMS_CONTENT_RULES_TL

219:
220: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID
221: AND object_version_number = p_object_version_number;
222:
223: update AMS_CONTENT_RULES_TL
224: set
225: last_update_date=DECODE( p_last_updated_date, FND_API.g_miss_date, last_update_date, p_last_updated_date),
226: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
227: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 257: DELETE FROM AMS_CONTENT_RULES_TL

253: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID;
254: If (SQL%NOTFOUND) then
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257: DELETE FROM AMS_CONTENT_RULES_TL
258: WHERE CONTENT_RULE_ID = p_CONTENT_RULE_ID;
259: If (SQL%NOTFOUND) then
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;

Line 376: delete from AMS_CONTENT_RULES_TL T

372:
373: procedure ADD_LANGUAGE
374: is
375: begin
376: delete from AMS_CONTENT_RULES_TL T
377: where not exists
378: (select NULL
379: from AMS_CONTENT_RULES_B B
380: where B.content_rule_id = T.content_rule_id

Line 383: update AMS_CONTENT_RULES_TL T set (

379: from AMS_CONTENT_RULES_B B
380: where B.content_rule_id = T.content_rule_id
381: );
382:
383: update AMS_CONTENT_RULES_TL T set (
384: email_subject
385: ) = (select
386: B.email_subject
387: from AMS_CONTENT_RULES_tl B

Line 387: from AMS_CONTENT_RULES_tl B

383: update AMS_CONTENT_RULES_TL T set (
384: email_subject
385: ) = (select
386: B.email_subject
387: from AMS_CONTENT_RULES_tl B
388: where B.content_rule_id = T.content_rule_id
389: and B.LANGUAGE = T.SOURCE_LANG)
390: where (
391: T.content_rule_id,

Line 396: from AMS_CONTENT_RULES_TL SUBB, AMS_CONTENT_RULES_TL SUBT

392: T.LANGUAGE
393: ) in (select
394: SUBT.content_rule_id,
395: SUBT.LANGUAGE
396: from AMS_CONTENT_RULES_TL SUBB, AMS_CONTENT_RULES_TL SUBT
397: where SUBB.content_rule_id = SUBT.content_rule_id
398: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
399: and (SUBB.email_subject <> SUBT.email_subject
400: ));

Line 402: insert into AMS_CONTENT_RULES_TL (

398: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
399: and (SUBB.email_subject <> SUBT.email_subject
400: ));
401:
402: insert into AMS_CONTENT_RULES_TL (
403: CONTENT_RULE_ID,
404: CREATED_BY,
405: CREATION_DATE,
406: EMAIL_SUBJECT,

Line 424: from AMS_CONTENT_RULES_TL B, FND_LANGUAGES L

420: B.LAST_UPDATE_LOGIN,
421: B.LAST_UPDATED_BY,
422: B.SECURITY_GROUP_ID,
423: B.SOURCE_LANG
424: from AMS_CONTENT_RULES_TL B, FND_LANGUAGES L
425: where L.INSTALLED_FLAG in ('I', 'B')
426: and B.LANGUAGE = userenv('LANG')
427: and not exists
428: (select NULL

Line 429: from AMS_CONTENT_RULES_TL T

425: where L.INSTALLED_FLAG in ('I', 'B')
426: and B.LANGUAGE = userenv('LANG')
427: and not exists
428: (select NULL
429: from AMS_CONTENT_RULES_TL T
430: where T.content_rule_id = B.content_rule_id
431: and T.LANGUAGE = L.LANGUAGE_CODE);
432: end ADD_LANGUAGE;
433: