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 407: update FND_TERRITORIES_TL set

403: if (sql%notfound) then
404: raise no_data_found;
405: end if;
406:
407: update FND_TERRITORIES_TL set
408: TERRITORY_SHORT_NAME = X_TERRITORY_SHORT_NAME,
409: DESCRIPTION = X_DESCRIPTION,
410: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
411: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 426: delete from FND_TERRITORIES_TL

422: procedure DELETE_ROW (
423: X_TERRITORY_CODE in VARCHAR2
424: ) is
425: begin
426: delete from FND_TERRITORIES_TL
427: where TERRITORY_CODE = X_TERRITORY_CODE;
428:
429: if (sql%notfound) then
430: raise no_data_found;

Line 450: delete from FND_TERRITORIES_TL T

446: /* as a quick workaround to fix the time-consuming table handler issue */
447: /* Eventually we'll need to turn them into a separate fix_language procedure */
448: /*
449:
450: delete from FND_TERRITORIES_TL T
451: where not exists
452: (select NULL
453: from FND_TERRITORIES B
454: where B.TERRITORY_CODE = T.TERRITORY_CODE

Line 457: update FND_TERRITORIES_TL T set (

453: from FND_TERRITORIES B
454: where B.TERRITORY_CODE = T.TERRITORY_CODE
455: );
456:
457: update FND_TERRITORIES_TL T set (
458: TERRITORY_SHORT_NAME,
459: DESCRIPTION
460: ) = (select
461: B.TERRITORY_SHORT_NAME,

Line 463: from FND_TERRITORIES_TL B

459: DESCRIPTION
460: ) = (select
461: B.TERRITORY_SHORT_NAME,
462: B.DESCRIPTION
463: from FND_TERRITORIES_TL B
464: where B.TERRITORY_CODE = T.TERRITORY_CODE
465: and B.LANGUAGE = T.SOURCE_LANG)
466: where (
467: T.TERRITORY_CODE,

Line 472: from FND_TERRITORIES_TL SUBB, FND_TERRITORIES_TL SUBT

468: T.LANGUAGE
469: ) in (select
470: SUBT.TERRITORY_CODE,
471: SUBT.LANGUAGE
472: from FND_TERRITORIES_TL SUBB, FND_TERRITORIES_TL SUBT
473: where SUBB.TERRITORY_CODE = SUBT.TERRITORY_CODE
474: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
475: and (SUBB.TERRITORY_SHORT_NAME <> SUBT.TERRITORY_SHORT_NAME
476: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 482: insert into FND_TERRITORIES_TL (

478: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
479: ));
480: */
481:
482: insert into FND_TERRITORIES_TL (
483: TERRITORY_CODE,
484: TERRITORY_SHORT_NAME,
485: CREATED_BY,
486: CREATION_DATE,

Line 504: from FND_TERRITORIES_TL B, FND_LANGUAGES L

500: B.LAST_UPDATE_LOGIN,
501: B.DESCRIPTION,
502: L.LANGUAGE_CODE,
503: B.SOURCE_LANG
504: from FND_TERRITORIES_TL B, FND_LANGUAGES L
505: where L.INSTALLED_FLAG in ('I', 'B')
506: and B.LANGUAGE = userenv('LANG')
507: and not exists
508: (select NULL

Line 509: from FND_TERRITORIES_TL T

505: where L.INSTALLED_FLAG in ('I', 'B')
506: and B.LANGUAGE = userenv('LANG')
507: and not exists
508: (select NULL
509: from FND_TERRITORIES_TL T
510: where T.TERRITORY_CODE = B.TERRITORY_CODE
511: and T.LANGUAGE = L.LANGUAGE_CODE);
512: end ADD_LANGUAGE;
513:

Line 586: from FND_TERRITORIES_TL

582: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
583:
584: select last_updated_by, last_update_date
585: into db_luby, db_ludate
586: from FND_TERRITORIES_TL
587: where TERRITORY_CODE = X_TERRITORY_CODE
588: and language = userenv('LANG');
589:
590: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 592: update FND_TERRITORIES_TL set

588: and language = userenv('LANG');
589:
590: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
591: db_ludate, X_CUSTOM_MODE)) then
592: update FND_TERRITORIES_TL set
593: DESCRIPTION = X_DESCRIPTION,
594: TERRITORY_SHORT_NAME = X_TERRITORY_SHORT_NAME,
595: LAST_UPDATE_DATE = f_ludate,
596: LAST_UPDATED_BY = f_luby,