APPS.FND_TERRITORIES_PKG dependencies on FND_TERRITORIES_TL

Line 153: insert into FND_TERRITORIES_TL (

149: obsolete_flag,
150: X_ISO_TERRITORY_CODE
151: );
152:
153: insert into FND_TERRITORIES_TL (
154: TERRITORY_CODE,
155: TERRITORY_SHORT_NAME,
156: CREATED_BY,
157: CREATION_DATE,

Line 179: from FND_TERRITORIES_TL T

175: from FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')
177: and not exists
178: (select NULL
179: from FND_TERRITORIES_TL T
180: where T.TERRITORY_CODE = X_TERRITORY_CODE
181: and T.LANGUAGE = L.LANGUAGE_CODE);
182:
183: open c;

Line 224: from FND_TERRITORIES_TL

220: cursor c1 is select
221: TERRITORY_SHORT_NAME,
222: DESCRIPTION,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from FND_TERRITORIES_TL
225: where TERRITORY_CODE = X_TERRITORY_CODE
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of TERRITORY_CODE nowait;
228: begin

Line 419: update FND_TERRITORIES_TL set

415: if (sql%notfound) then
416: raise no_data_found;
417: end if;
418:
419: update FND_TERRITORIES_TL set
420: TERRITORY_SHORT_NAME = X_TERRITORY_SHORT_NAME,
421: DESCRIPTION = X_DESCRIPTION,
422: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
423: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 438: delete from FND_TERRITORIES_TL

434: procedure DELETE_ROW (
435: X_TERRITORY_CODE in VARCHAR2
436: ) is
437: begin
438: delete from FND_TERRITORIES_TL
439: where TERRITORY_CODE = X_TERRITORY_CODE;
440:
441: if (sql%notfound) then
442: raise no_data_found;

Line 462: delete from FND_TERRITORIES_TL T

458: /* as a quick workaround to fix the time-consuming table handler issue */
459: /* Eventually we'll need to turn them into a separate fix_language procedure */
460: /*
461:
462: delete from FND_TERRITORIES_TL T
463: where not exists
464: (select NULL
465: from FND_TERRITORIES B
466: where B.TERRITORY_CODE = T.TERRITORY_CODE

Line 469: update FND_TERRITORIES_TL T set (

465: from FND_TERRITORIES B
466: where B.TERRITORY_CODE = T.TERRITORY_CODE
467: );
468:
469: update FND_TERRITORIES_TL T set (
470: TERRITORY_SHORT_NAME,
471: DESCRIPTION
472: ) = (select
473: B.TERRITORY_SHORT_NAME,

Line 475: from FND_TERRITORIES_TL B

471: DESCRIPTION
472: ) = (select
473: B.TERRITORY_SHORT_NAME,
474: B.DESCRIPTION
475: from FND_TERRITORIES_TL B
476: where B.TERRITORY_CODE = T.TERRITORY_CODE
477: and B.LANGUAGE = T.SOURCE_LANG)
478: where (
479: T.TERRITORY_CODE,

Line 484: from FND_TERRITORIES_TL SUBB, FND_TERRITORIES_TL SUBT

480: T.LANGUAGE
481: ) in (select
482: SUBT.TERRITORY_CODE,
483: SUBT.LANGUAGE
484: from FND_TERRITORIES_TL SUBB, FND_TERRITORIES_TL SUBT
485: where SUBB.TERRITORY_CODE = SUBT.TERRITORY_CODE
486: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
487: and (SUBB.TERRITORY_SHORT_NAME <> SUBT.TERRITORY_SHORT_NAME
488: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 494: insert into FND_TERRITORIES_TL (

490: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
491: ));
492: */
493:
494: insert into FND_TERRITORIES_TL (
495: TERRITORY_CODE,
496: TERRITORY_SHORT_NAME,
497: CREATED_BY,
498: CREATION_DATE,

Line 516: from FND_TERRITORIES_TL B, FND_LANGUAGES L

512: B.LAST_UPDATE_LOGIN,
513: B.DESCRIPTION,
514: L.LANGUAGE_CODE,
515: B.SOURCE_LANG
516: from FND_TERRITORIES_TL B, FND_LANGUAGES L
517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL

Line 521: from FND_TERRITORIES_TL T

517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL
521: from FND_TERRITORIES_TL T
522: where T.TERRITORY_CODE = B.TERRITORY_CODE
523: and T.LANGUAGE = L.LANGUAGE_CODE);
524: end ADD_LANGUAGE;
525:

Line 598: from FND_TERRITORIES_TL

594: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
595:
596: select last_updated_by, last_update_date
597: into db_luby, db_ludate
598: from FND_TERRITORIES_TL
599: where TERRITORY_CODE = X_TERRITORY_CODE
600: and language = userenv('LANG');
601:
602: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 604: update FND_TERRITORIES_TL set

600: and language = userenv('LANG');
601:
602: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
603: db_ludate, X_CUSTOM_MODE)) then
604: update FND_TERRITORIES_TL set
605: DESCRIPTION = X_DESCRIPTION,
606: TERRITORY_SHORT_NAME = X_TERRITORY_SHORT_NAME,
607: LAST_UPDATE_DATE = f_ludate,
608: LAST_UPDATED_BY = f_luby,