APPS.XNP_SV_STATUS_TYPES_PKG dependencies on XNP_SV_STATUS_TYPES_TL

Line 49: insert into XNP_SV_STATUS_TYPES_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into XNP_SV_STATUS_TYPES_TL (
50: STATUS_TYPE_CODE,
51: DISPLAY_NAME,
52: DESCRIPTION,
53: CREATED_BY,

Line 75: from XNP_SV_STATUS_TYPES_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from XNP_SV_STATUS_TYPES_TL T
76: where T.STATUS_TYPE_CODE = X_STATUS_TYPE_CODE
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from XNP_SV_STATUS_TYPES_TL

110: cursor c1 is select
111: DISPLAY_NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from XNP_SV_STATUS_TYPES_TL
115: where STATUS_TYPE_CODE = X_STATUS_TYPE_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of STATUS_TYPE_CODE nowait;
118: begin

Line 184: update XNP_SV_STATUS_TYPES_TL set

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: update XNP_SV_STATUS_TYPES_TL set
185: DISPLAY_NAME = X_DISPLAY_NAME,
186: DESCRIPTION = X_DESCRIPTION,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from XNP_SV_STATUS_TYPES_TL

199: procedure DELETE_ROW (
200: X_STATUS_TYPE_CODE in VARCHAR2
201: ) is
202: begin
203: delete from XNP_SV_STATUS_TYPES_TL
204: where STATUS_TYPE_CODE = X_STATUS_TYPE_CODE;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 221: delete from XNP_SV_STATUS_TYPES_TL T

217:
218: procedure ADD_LANGUAGE
219: is
220: begin
221: delete from XNP_SV_STATUS_TYPES_TL T
222: where not exists
223: (select NULL
224: from XNP_SV_STATUS_TYPES_B B
225: where B.STATUS_TYPE_CODE = T.STATUS_TYPE_CODE

Line 228: update XNP_SV_STATUS_TYPES_TL T set (

224: from XNP_SV_STATUS_TYPES_B B
225: where B.STATUS_TYPE_CODE = T.STATUS_TYPE_CODE
226: );
227:
228: update XNP_SV_STATUS_TYPES_TL T set (
229: DISPLAY_NAME,
230: DESCRIPTION
231: ) = (select
232: B.DISPLAY_NAME,

Line 234: from XNP_SV_STATUS_TYPES_TL B

230: DESCRIPTION
231: ) = (select
232: B.DISPLAY_NAME,
233: B.DESCRIPTION
234: from XNP_SV_STATUS_TYPES_TL B
235: where B.STATUS_TYPE_CODE = T.STATUS_TYPE_CODE
236: and B.LANGUAGE = T.SOURCE_LANG)
237: where (
238: T.STATUS_TYPE_CODE,

Line 243: from XNP_SV_STATUS_TYPES_TL SUBB, XNP_SV_STATUS_TYPES_TL SUBT

239: T.LANGUAGE
240: ) in (select
241: SUBT.STATUS_TYPE_CODE,
242: SUBT.LANGUAGE
243: from XNP_SV_STATUS_TYPES_TL SUBB, XNP_SV_STATUS_TYPES_TL SUBT
244: where SUBB.STATUS_TYPE_CODE = SUBT.STATUS_TYPE_CODE
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
247: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 252: insert into XNP_SV_STATUS_TYPES_TL (

248: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
249: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
250: ));
251:
252: insert into XNP_SV_STATUS_TYPES_TL (
253: STATUS_TYPE_CODE,
254: DISPLAY_NAME,
255: DESCRIPTION,
256: CREATED_BY,

Line 274: from XNP_SV_STATUS_TYPES_TL B, FND_LANGUAGES L

270: B.LAST_UPDATE_DATE,
271: B.LAST_UPDATE_LOGIN,
272: L.LANGUAGE_CODE,
273: B.SOURCE_LANG
274: from XNP_SV_STATUS_TYPES_TL B, FND_LANGUAGES L
275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL

Line 279: from XNP_SV_STATUS_TYPES_TL T

275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL
279: from XNP_SV_STATUS_TYPES_TL T
280: where T.STATUS_TYPE_CODE = B.STATUS_TYPE_CODE
281: and T.LANGUAGE = L.LANGUAGE_CODE);
282: end ADD_LANGUAGE;
283: procedure LOAD_ROW (

Line 344: UPDATE XNP_SV_STATUS_TYPES_TL

340: X_DESCRIPTION in VARCHAR2,
341: X_OWNER in VARCHAR2) IS
342: BEGIN
343: -- Only update rows which have not been altered by user
344: UPDATE XNP_SV_STATUS_TYPES_TL
345: SET description = X_DESCRIPTION,
346: display_name = X_DISPLAY_NAME,
347: source_lang = userenv('LANG'),
348: last_update_date = sysdate,