APPS.PO_UN_NUMBERS_PKG dependencies on PO_UN_NUMBERS_TL

Line 99: insert into PO_UN_NUMBERS_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into PO_UN_NUMBERS_TL (
100: UN_NUMBER_ID,
101: UN_NUMBER,
102: DESCRIPTION,
103: CREATED_BY,

Line 125: from PO_UN_NUMBERS_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from PO_UN_NUMBERS_TL T
126: where T.UN_NUMBER_ID = X_UN_NUMBER_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 192: from PO_UN_NUMBERS_TL

188: cursor c1 is select
189: UN_NUMBER,
190: DESCRIPTION,
191: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
192: from PO_UN_NUMBERS_TL
193: where UN_NUMBER_ID = X_UN_NUMBER_ID
194: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
195: for update of UN_NUMBER_ID nowait;
196: begin

Line 322: update PO_UN_NUMBERS_TL set

318: if (sql%notfound) then
319: raise no_data_found;
320: end if;
321:
322: update PO_UN_NUMBERS_TL set
323: UN_NUMBER = X_UN_NUMBER,
324: DESCRIPTION = X_DESCRIPTION,
325: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
326: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 341: delete from PO_UN_NUMBERS_TL

337: procedure DELETE_ROW (
338: X_UN_NUMBER_ID in NUMBER
339: ) is
340: begin
341: delete from PO_UN_NUMBERS_TL
342: where UN_NUMBER_ID = X_UN_NUMBER_ID;
343:
344: if (sql%notfound) then
345: raise no_data_found;

Line 359: delete from PO_UN_NUMBERS_TL T

355:
356: procedure ADD_LANGUAGE
357: is
358: begin
359: delete from PO_UN_NUMBERS_TL T
360: where not exists
361: (select NULL
362: from PO_UN_NUMBERS_B B
363: where B.UN_NUMBER_ID = T.UN_NUMBER_ID

Line 366: update PO_UN_NUMBERS_TL T set (

362: from PO_UN_NUMBERS_B B
363: where B.UN_NUMBER_ID = T.UN_NUMBER_ID
364: );
365:
366: update PO_UN_NUMBERS_TL T set (
367: UN_NUMBER,
368: DESCRIPTION
369: ) = (select
370: B.UN_NUMBER,

Line 372: from PO_UN_NUMBERS_TL B

368: DESCRIPTION
369: ) = (select
370: B.UN_NUMBER,
371: B.DESCRIPTION
372: from PO_UN_NUMBERS_TL B
373: where B.UN_NUMBER_ID = T.UN_NUMBER_ID
374: and B.LANGUAGE = T.SOURCE_LANG)
375: where (
376: T.UN_NUMBER_ID,

Line 381: from PO_UN_NUMBERS_TL SUBB, PO_UN_NUMBERS_TL SUBT

377: T.LANGUAGE
378: ) in (select
379: SUBT.UN_NUMBER_ID,
380: SUBT.LANGUAGE
381: from PO_UN_NUMBERS_TL SUBB, PO_UN_NUMBERS_TL SUBT
382: where SUBB.UN_NUMBER_ID = SUBT.UN_NUMBER_ID
383: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
384: and (SUBB.UN_NUMBER <> SUBT.UN_NUMBER
385: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 388: insert into PO_UN_NUMBERS_TL (

384: and (SUBB.UN_NUMBER <> SUBT.UN_NUMBER
385: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
386: ));
387:
388: insert into PO_UN_NUMBERS_TL (
389: UN_NUMBER_ID,
390: UN_NUMBER,
391: DESCRIPTION,
392: CREATED_BY,

Line 410: from PO_UN_NUMBERS_TL B, FND_LANGUAGES L

406: B.LAST_UPDATE_DATE,
407: B.LAST_UPDATE_LOGIN,
408: L.LANGUAGE_CODE,
409: B.SOURCE_LANG
410: from PO_UN_NUMBERS_TL B, FND_LANGUAGES L
411: where L.INSTALLED_FLAG in ('I', 'B')
412: and B.LANGUAGE = userenv('LANG')
413: and not exists
414: (select NULL

Line 415: from PO_UN_NUMBERS_TL T

411: where L.INSTALLED_FLAG in ('I', 'B')
412: and B.LANGUAGE = userenv('LANG')
413: and not exists
414: (select NULL
415: from PO_UN_NUMBERS_TL T
416: where T.UN_NUMBER_ID = B.UN_NUMBER_ID
417: and T.LANGUAGE = L.LANGUAGE_CODE);
418: end ADD_LANGUAGE;
419: