APPS.AMS_IBA_PS_RULEGRPS_B_PKG dependencies on AMS_IBA_PS_RULEGRPS_TL

Line 79: INSERT INTO AMS_IBA_PS_RULEGRPS_TL(

75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
77:
78:
79: INSERT INTO AMS_IBA_PS_RULEGRPS_TL(
80: RULEGROUP_NAME,
81: RULEGROUP_DESCRIPTION,
82: RULEGROUP_ID,
83: CREATED_BY,

Line 109: FROM AMS_IBA_PS_RULEGRPS_TL t

105: FROM fnd_languages l
106: WHERE l.installed_flag in ('I', 'B')
107: AND NOT EXISTS(
108: SELECT NULL
109: FROM AMS_IBA_PS_RULEGRPS_TL t
110: WHERE t.rulegroup_id = DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id)
111: AND t.language = l.language_code
112: );
113:

Line 168: UPDATE ams_iba_ps_rulegrps_tl SET

164: IF (SQL%NOTFOUND) THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: UPDATE ams_iba_ps_rulegrps_tl SET
169: rulegroup_name = decode( p_rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_name),
170: rulegroup_description = decode( p_rule_description, FND_API.G_MISS_CHAR, rulegroup_description, p_rule_description),
171: last_update_date = SYSDATE,
172: last_updated_by = FND_GLOBAL.user_id,

Line 213: DELETE FROM AMS_IBA_PS_RULEGRPS_TL

209: If (SQL%NOTFOUND) then
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: End If;
212:
213: DELETE FROM AMS_IBA_PS_RULEGRPS_TL
214: WHERE RULEGROUP_ID = P_RULEGROUP_ID;
215:
216: If (SQL%NOTFOUND) then
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 238: delete from AMS_IBA_PS_RULEGRPS_TL T

234:
235: procedure ADD_LANGUAGE
236: is
237: begin
238: delete from AMS_IBA_PS_RULEGRPS_TL T
239: where not exists
240: (select NULL
241: from AMS_IBA_PS_RULEGRPS_B B
242: where B.RULEGROUP_ID = T.RULEGROUP_ID

Line 245: update AMS_IBA_PS_RULEGRPS_TL T set (

241: from AMS_IBA_PS_RULEGRPS_B B
242: where B.RULEGROUP_ID = T.RULEGROUP_ID
243: );
244:
245: update AMS_IBA_PS_RULEGRPS_TL T set (
246: RULEGROUP_NAME,
247: RULEGROUP_DESCRIPTION
248: ) = (select
249: B.RULEGROUP_NAME,

Line 251: from AMS_IBA_PS_RULEGRPS_TL B

247: RULEGROUP_DESCRIPTION
248: ) = (select
249: B.RULEGROUP_NAME,
250: B.RULEGROUP_DESCRIPTION
251: from AMS_IBA_PS_RULEGRPS_TL B
252: where B.RULEGROUP_ID = T.RULEGROUP_ID
253: and B.LANGUAGE = T.SOURCE_LANG)
254: where (
255: T.RULEGROUP_ID,

Line 260: from AMS_IBA_PS_RULEGRPS_TL SUBB, AMS_IBA_PS_RULEGRPS_TL SUBT

256: T.LANGUAGE
257: ) in (select
258: SUBT.RULEGROUP_ID,
259: SUBT.LANGUAGE
260: from AMS_IBA_PS_RULEGRPS_TL SUBB, AMS_IBA_PS_RULEGRPS_TL SUBT
261: where SUBB.RULEGROUP_ID = SUBT.RULEGROUP_ID
262: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
263: and (SUBB.RULEGROUP_NAME <> SUBT.RULEGROUP_NAME
264: or SUBB.RULEGROUP_DESCRIPTION <> SUBT.RULEGROUP_DESCRIPTION

Line 269: insert into AMS_IBA_PS_RULEGRPS_TL (

265: or (SUBB.RULEGROUP_DESCRIPTION is null and SUBT.RULEGROUP_DESCRIPTION is not null)
266: or (SUBB.RULEGROUP_DESCRIPTION is not null and SUBT.RULEGROUP_DESCRIPTION is null)
267: ));
268:
269: insert into AMS_IBA_PS_RULEGRPS_TL (
270: LAST_UPDATE_DATE,
271: CREATION_DATE,
272: LAST_UPDATED_BY,
273: CREATED_BY,

Line 293: from AMS_IBA_PS_RULEGRPS_TL B, FND_LANGUAGES L

289: B.LAST_UPDATE_LOGIN,
290: B.OBJECT_VERSION_NUMBER,
291: L.LANGUAGE_CODE,
292: B.SOURCE_LANG
293: from AMS_IBA_PS_RULEGRPS_TL B, FND_LANGUAGES L
294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL

Line 298: from AMS_IBA_PS_RULEGRPS_TL T

294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL
298: from AMS_IBA_PS_RULEGRPS_TL T
299: where T.RULEGROUP_ID = B.RULEGROUP_ID
300: and T.LANGUAGE = L.LANGUAGE_CODE);
301: end ADD_LANGUAGE;
302: