APPS.FND_OAM_DS_POLICIES_PKG dependencies on FND_OAM_DS_POLICIES_TL

Line 39: insert into FND_OAM_DS_POLICIES_TL (

35: X_LAST_UPDATE_DATE,
36: X_LAST_UPDATE_LOGIN
37: );
38:
39: insert into FND_OAM_DS_POLICIES_TL (
40: POLICY_ID,
41: POLICY_NAME,
42: DESCRIPTION,
43: CREATED_BY,

Line 65: from FND_OAM_DS_POLICIES_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from FND_OAM_DS_POLICIES_TL T
66: where T.POLICY_ID = X_POLICY_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 109: from FND_OAM_DS_POLICIES_TL

105: cursor c1 is select
106: POLICY_NAME,
107: DESCRIPTION,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from FND_OAM_DS_POLICIES_TL
110: where POLICY_ID = X_POLICY_ID
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of POLICY_ID nowait;
113: begin

Line 172: update FND_OAM_DS_POLICIES_TL set

168: if (sql%notfound) then
169: raise no_data_found;
170: end if;
171:
172: update FND_OAM_DS_POLICIES_TL set
173: POLICY_NAME = X_POLICY_NAME,
174: DESCRIPTION = X_DESCRIPTION,
175: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
176: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 191: delete from FND_OAM_DS_POLICIES_TL

187: procedure DELETE_ROW (
188: X_POLICY_ID in NUMBER
189: ) is
190: begin
191: delete from FND_OAM_DS_POLICIES_TL
192: where POLICY_ID = X_POLICY_ID;
193:
194: if (sql%notfound) then
195: raise no_data_found;

Line 209: delete from FND_OAM_DS_POLICIES_TL T

205:
206: procedure ADD_LANGUAGE
207: is
208: begin
209: delete from FND_OAM_DS_POLICIES_TL T
210: where not exists
211: (select NULL
212: from FND_OAM_DS_POLICIES_B B
213: where B.POLICY_ID = T.POLICY_ID

Line 216: update FND_OAM_DS_POLICIES_TL T set (

212: from FND_OAM_DS_POLICIES_B B
213: where B.POLICY_ID = T.POLICY_ID
214: );
215:
216: update FND_OAM_DS_POLICIES_TL T set (
217: POLICY_NAME,
218: DESCRIPTION
219: ) = (select
220: B.POLICY_NAME,

Line 222: from FND_OAM_DS_POLICIES_TL B

218: DESCRIPTION
219: ) = (select
220: B.POLICY_NAME,
221: B.DESCRIPTION
222: from FND_OAM_DS_POLICIES_TL B
223: where B.POLICY_ID = T.POLICY_ID
224: and B.LANGUAGE = T.SOURCE_LANG)
225: where (
226: T.POLICY_ID,

Line 231: from FND_OAM_DS_POLICIES_TL SUBB, FND_OAM_DS_POLICIES_TL SUBT

227: T.LANGUAGE
228: ) in (select
229: SUBT.POLICY_ID,
230: SUBT.LANGUAGE
231: from FND_OAM_DS_POLICIES_TL SUBB, FND_OAM_DS_POLICIES_TL SUBT
232: where SUBB.POLICY_ID = SUBT.POLICY_ID
233: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
234: and (SUBB.POLICY_NAME <> SUBT.POLICY_NAME
235: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 240: insert into FND_OAM_DS_POLICIES_TL (

236: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
237: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
238: ));
239:
240: insert into FND_OAM_DS_POLICIES_TL (
241: POLICY_ID,
242: POLICY_NAME,
243: DESCRIPTION,
244: CREATED_BY,

Line 262: from FND_OAM_DS_POLICIES_TL B, FND_LANGUAGES L

258: B.LAST_UPDATE_DATE,
259: B.LAST_UPDATE_LOGIN,
260: L.LANGUAGE_CODE,
261: B.SOURCE_LANG
262: from FND_OAM_DS_POLICIES_TL B, FND_LANGUAGES L
263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL

Line 267: from FND_OAM_DS_POLICIES_TL T

263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL
267: from FND_OAM_DS_POLICIES_TL T
268: where T.POLICY_ID = B.POLICY_ID
269: and T.LANGUAGE = L.LANGUAGE_CODE);
270: end ADD_LANGUAGE;
271:

Line 283: UPDATE FND_OAM_DS_POLICIES_TL SET

279: )
280: is
281: begin
282:
283: UPDATE FND_OAM_DS_POLICIES_TL SET
284: policy_name = nvl(x_POLICY_NAME,policy_name),
285: last_update_date = nvl(x_last_update_date,sysdate),
286: last_updated_by = x_last_updated_by,
287: last_update_login = 0,