APPS.AMS_IBA_PS_CNDCLSES_B_PKG dependencies on AMS_IBA_PS_CNDCLSES_TL

Line 81: INSERT INTO ams_iba_ps_cndclses_tl (

77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),
79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));
80:
81: INSERT INTO ams_iba_ps_cndclses_tl (
82: created_by,
83: creation_date,
84: last_updated_by,
85: last_update_date,

Line 110: FROM ams_iba_ps_cndclses_tl t

106: FROM fnd_languages l
107: WHERE l.installed_flag IN ('I', 'B')
108: AND NOT EXISTS
109: (SELECT null
110: FROM ams_iba_ps_cndclses_tl t
111: WHERE t.cnd_clause_id = DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id)
112: AND t.language = l.language_code);
113:
114: END Insert_Row;

Line 170: UPDATE ams_iba_ps_cndclses_tl SET

166: IF (SQL%NOTFOUND) THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169:
170: UPDATE ams_iba_ps_cndclses_tl SET
171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),
172: cnd_clause_description = DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, cnd_clause_description, p_CND_CLAUSE_DESCRIPTION),
173: last_update_date = SYSDATE,
174: last_updated_by = FND_GLOBAL.user_id,

Line 212: DELETE FROM AMS_IBA_PS_CNDCLSES_TL

208: If (SQL%NOTFOUND) then
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: End If;
211:
212: DELETE FROM AMS_IBA_PS_CNDCLSES_TL
213: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID;
214: If (SQL%NOTFOUND) then
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: End If;

Line 223: delete from AMS_IBA_PS_CNDCLSES_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from AMS_IBA_PS_CNDCLSES_TL T
224: where not exists
225: (select NULL
226: from AMS_IBA_PS_CNDCLSES_B B
227: where B.CND_CLAUSE_ID = T.CND_CLAUSE_ID

Line 230: update AMS_IBA_PS_CNDCLSES_TL T set (

226: from AMS_IBA_PS_CNDCLSES_B B
227: where B.CND_CLAUSE_ID = T.CND_CLAUSE_ID
228: );
229:
230: update AMS_IBA_PS_CNDCLSES_TL T set (
231: CND_CLAUSE_NAME,
232: CND_CLAUSE_DESCRIPTION
233: ) = (select
234: B.CND_CLAUSE_NAME,

Line 236: from AMS_IBA_PS_CNDCLSES_TL B

232: CND_CLAUSE_DESCRIPTION
233: ) = (select
234: B.CND_CLAUSE_NAME,
235: B.CND_CLAUSE_DESCRIPTION
236: from AMS_IBA_PS_CNDCLSES_TL B
237: where B.CND_CLAUSE_ID = T.CND_CLAUSE_ID
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.CND_CLAUSE_ID,

Line 245: from AMS_IBA_PS_CNDCLSES_TL SUBB, AMS_IBA_PS_CNDCLSES_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.CND_CLAUSE_ID,
244: SUBT.LANGUAGE
245: from AMS_IBA_PS_CNDCLSES_TL SUBB, AMS_IBA_PS_CNDCLSES_TL SUBT
246: where SUBB.CND_CLAUSE_ID = SUBT.CND_CLAUSE_ID
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.CND_CLAUSE_NAME <> SUBT.CND_CLAUSE_NAME
249: or SUBB.CND_CLAUSE_DESCRIPTION <> SUBT.CND_CLAUSE_DESCRIPTION

Line 254: insert into AMS_IBA_PS_CNDCLSES_TL (

250: or (SUBB.CND_CLAUSE_DESCRIPTION is null and SUBT.CND_CLAUSE_DESCRIPTION is not null)
251: or (SUBB.CND_CLAUSE_DESCRIPTION is not null and SUBT.CND_CLAUSE_DESCRIPTION is null)
252: ));
253:
254: insert into AMS_IBA_PS_CNDCLSES_TL (
255: LAST_UPDATE_DATE,
256: CREATION_DATE,
257: LAST_UPDATED_BY,
258: CREATED_BY,

Line 278: from AMS_IBA_PS_CNDCLSES_TL B, FND_LANGUAGES L

274: B.LAST_UPDATE_LOGIN,
275: B.OBJECT_VERSION_NUMBER,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: from AMS_IBA_PS_CNDCLSES_TL B, FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL

Line 283: from AMS_IBA_PS_CNDCLSES_TL T

279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL
283: from AMS_IBA_PS_CNDCLSES_TL T
284: where T.CND_CLAUSE_ID = B.CND_CLAUSE_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: end ADD_LANGUAGE;
287: