APPS.FND_OAM_DS_PSETS_PKG dependencies on FND_OAM_DS_PSETS_TL

Line 33: insert into FND_OAM_DS_PSETS_TL (

29: X_LAST_UPDATE_DATE,
30: X_LAST_UPDATE_LOGIN
31: );
32:
33: insert into FND_OAM_DS_PSETS_TL (
34: POLICYSET_ID,
35: POLICYSET_NAME,
36: DESCRIPTION,
37: CREATED_BY,

Line 59: from FND_OAM_DS_PSETS_TL T

55: from FND_LANGUAGES L
56: where L.INSTALLED_FLAG in ('I', 'B')
57: and not exists
58: (select NULL
59: from FND_OAM_DS_PSETS_TL T
60: where T.POLICYSET_ID = X_POLICYSET_ID
61: and T.LANGUAGE = L.LANGUAGE_CODE);
62:
63: open c;

Line 99: from FND_OAM_DS_PSETS_TL

95: cursor c1 is select
96: POLICYSET_NAME,
97: DESCRIPTION,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from FND_OAM_DS_PSETS_TL
100: where POLICYSET_ID = X_POLICYSET_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of POLICYSET_ID nowait;
103: begin

Line 148: update FND_OAM_DS_PSETS_TL set

144: if (sql%notfound) then
145: raise no_data_found;
146: end if;
147:
148: update FND_OAM_DS_PSETS_TL set
149: POLICYSET_NAME = X_POLICYSET_NAME,
150: DESCRIPTION = X_DESCRIPTION,
151: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 167: delete from FND_OAM_DS_PSETS_TL

163: procedure DELETE_ROW (
164: X_POLICYSET_ID in NUMBER
165: ) is
166: begin
167: delete from FND_OAM_DS_PSETS_TL
168: where POLICYSET_ID = X_POLICYSET_ID;
169:
170: if (sql%notfound) then
171: raise no_data_found;

Line 185: delete from FND_OAM_DS_PSETS_TL T

181:
182: procedure ADD_LANGUAGE
183: is
184: begin
185: delete from FND_OAM_DS_PSETS_TL T
186: where not exists
187: (select NULL
188: from FND_OAM_DS_PSETS_B B
189: where B.POLICYSET_ID = T.POLICYSET_ID

Line 192: update FND_OAM_DS_PSETS_TL T set (

188: from FND_OAM_DS_PSETS_B B
189: where B.POLICYSET_ID = T.POLICYSET_ID
190: );
191:
192: update FND_OAM_DS_PSETS_TL T set (
193: POLICYSET_NAME,
194: DESCRIPTION
195: ) = (select
196: B.POLICYSET_NAME,

Line 198: from FND_OAM_DS_PSETS_TL B

194: DESCRIPTION
195: ) = (select
196: B.POLICYSET_NAME,
197: B.DESCRIPTION
198: from FND_OAM_DS_PSETS_TL B
199: where B.POLICYSET_ID = T.POLICYSET_ID
200: and B.LANGUAGE = T.SOURCE_LANG)
201: where (
202: T.POLICYSET_ID,

Line 207: from FND_OAM_DS_PSETS_TL SUBB, FND_OAM_DS_PSETS_TL SUBT

203: T.LANGUAGE
204: ) in (select
205: SUBT.POLICYSET_ID,
206: SUBT.LANGUAGE
207: from FND_OAM_DS_PSETS_TL SUBB, FND_OAM_DS_PSETS_TL SUBT
208: where SUBB.POLICYSET_ID = SUBT.POLICYSET_ID
209: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
210: and (SUBB.POLICYSET_NAME <> SUBT.POLICYSET_NAME
211: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 216: insert into FND_OAM_DS_PSETS_TL (

212: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
213: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
214: ));
215:
216: insert into FND_OAM_DS_PSETS_TL (
217: POLICYSET_ID,
218: POLICYSET_NAME,
219: DESCRIPTION,
220: CREATED_BY,

Line 238: from FND_OAM_DS_PSETS_TL B, FND_LANGUAGES L

234: B.LAST_UPDATE_DATE,
235: B.LAST_UPDATE_LOGIN,
236: L.LANGUAGE_CODE,
237: B.SOURCE_LANG
238: from FND_OAM_DS_PSETS_TL B, FND_LANGUAGES L
239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL

Line 243: from FND_OAM_DS_PSETS_TL T

239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL
243: from FND_OAM_DS_PSETS_TL T
244: where T.POLICYSET_ID = B.POLICYSET_ID
245: and T.LANGUAGE = L.LANGUAGE_CODE);
246: end ADD_LANGUAGE;
247:

Line 259: UPDATE FND_OAM_DS_PSETS_TL SET

255: )
256: is
257: begin
258:
259: UPDATE FND_OAM_DS_PSETS_TL SET
260: POLICYSET_NAME = nvl(x_POLICYSET_NAME,POLICYSET_NAME),
261: last_update_date = nvl(x_last_update_date,sysdate),
262: last_updated_by = x_last_updated_by,
263: last_update_login = 0,