eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_TERRITORIES_PKG dependencies on FND_TERRITORIES_PKG

Line 1: package body FND_TERRITORIES_PKG as

1: package body FND_TERRITORIES_PKG as
2: /* $Header: AFNLDTIB.pls 120.4.12010000.2 2008/07/31 13:20:46 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 24: FND_TERRITORIES_PKG.INSERT_ROW(

20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: begin
24: FND_TERRITORIES_PKG.INSERT_ROW(
25: X_ROWID,
26: X_TERRITORY_CODE,
27: X_EU_CODE,
28: X_ISO_NUMERIC_CODE,

Line 66: FND_TERRITORIES_PKG.INSERT_ROW(

62: X_LAST_UPDATE_LOGIN in NUMBER,
63: X_OBSOLETE_FLAG in VARCHAR2
64: ) is
65: begin
66: FND_TERRITORIES_PKG.INSERT_ROW(
67: X_ROWID,
68: X_TERRITORY_CODE,
69: X_EU_CODE,
70: X_ISO_NUMERIC_CODE,

Line 293: FND_TERRITORIES_PKG.UPDATE_ROW(

289: X_LAST_UPDATED_BY in NUMBER,
290: X_LAST_UPDATE_LOGIN in NUMBER
291: ) is
292: begin
293: FND_TERRITORIES_PKG.UPDATE_ROW(
294: X_TERRITORY_CODE,
295: X_EU_CODE,
296: X_ISO_NUMERIC_CODE,
297: X_ALTERNATE_TERRITORY_CODE,

Line 329: FND_TERRITORIES_PKG.UPDATE_ROW(

325: X_LAST_UPDATE_LOGIN in NUMBER,
326: X_OBSOLETE_FLAG in VARCHAR2
327: ) is
328: begin
329: FND_TERRITORIES_PKG.UPDATE_ROW(
330: X_TERRITORY_CODE,
331: X_EU_CODE,
332: X_ISO_NUMERIC_CODE,
333: X_ALTERNATE_TERRITORY_CODE,

Line 733: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,

729: -- Bug4648984 Moved sql to inside exception block to handle the
730: -- no data found.
731:
732: select
733: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,
734: null, u.iso_numeric_code,
735: x_iso_numeric_code),
736: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
737: null, u.alternate_territory_code,

Line 736: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,

732: select
733: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,
734: null, u.iso_numeric_code,
735: x_iso_numeric_code),
736: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
737: null, u.alternate_territory_code,
738: x_alternate_territory_code),
739: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
740: null, u.nls_territory,

Line 739: decode(x_nls_territory, fnd_territories_pkg.null_char, null,

735: x_iso_numeric_code),
736: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
737: null, u.alternate_territory_code,
738: x_alternate_territory_code),
739: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
740: null, u.nls_territory,
741: x_nls_territory),
742: decode(x_address_style, fnd_territories_pkg.null_char, null,
743: null, u.address_style,

Line 742: decode(x_address_style, fnd_territories_pkg.null_char, null,

738: x_alternate_territory_code),
739: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
740: null, u.nls_territory,
741: x_nls_territory),
742: decode(x_address_style, fnd_territories_pkg.null_char, null,
743: null, u.address_style,
744: x_address_style),
745: decode(x_address_validation, fnd_territories_pkg.null_char, null,
746: null, u.address_validation,

Line 745: decode(x_address_validation, fnd_territories_pkg.null_char, null,

741: x_nls_territory),
742: decode(x_address_style, fnd_territories_pkg.null_char, null,
743: null, u.address_style,
744: x_address_style),
745: decode(x_address_validation, fnd_territories_pkg.null_char, null,
746: null, u.address_validation,
747: x_address_validation),
748: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
749: null, u.bank_info_style,

Line 748: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,

744: x_address_style),
745: decode(x_address_validation, fnd_territories_pkg.null_char, null,
746: null, u.address_validation,
747: x_address_validation),
748: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
749: null, u.bank_info_style,
750: x_bank_info_style),
751: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
752: null, u.bank_info_validation,

Line 751: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,

747: x_address_validation),
748: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
749: null, u.bank_info_style,
750: x_bank_info_style),
751: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
752: null, u.bank_info_validation,
753: x_bank_info_validation),
754: decode(x_eu_code, fnd_territories_pkg.null_char, null,
755: null, u.eu_code,

Line 754: decode(x_eu_code, fnd_territories_pkg.null_char, null,

750: x_bank_info_style),
751: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
752: null, u.bank_info_validation,
753: x_bank_info_validation),
754: decode(x_eu_code, fnd_territories_pkg.null_char, null,
755: null, u.eu_code,
756: x_eu_code),
757: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,
758: null, u.iso_territory_code,

Line 757: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,

753: x_bank_info_validation),
754: decode(x_eu_code, fnd_territories_pkg.null_char, null,
755: null, u.eu_code,
756: x_eu_code),
757: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,
758: null, u.iso_territory_code,
759: x_iso_territory_code)
760: into l_iso_numeric_code, l_alternate_territory_code, l_nls_territory,
761: l_address_style, l_address_validation, l_bank_info_style,

Line 771: FND_TERRITORIES_PKG.UPDATE_ROW(

767: -- INSERT_ROW procedure calls.
768:
769: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
770: db_ludate, X_CUSTOM_MODE)) then
771: FND_TERRITORIES_PKG.UPDATE_ROW(
772: X_TERRITORY_CODE,
773: L_EU_CODE,
774: L_ISO_NUMERIC_CODE,
775: L_ALTERNATE_TERRITORY_CODE,

Line 796: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,

792: -- bug7270106 - Need to correctly translate the provided NULL value
793: -- for inserting.
794:
795: select
796: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,
797: null, null,x_iso_numeric_code),
798: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
799: null, null, x_alternate_territory_code),
800: decode(x_nls_territory, fnd_territories_pkg.null_char, null,

Line 798: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,

794:
795: select
796: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,
797: null, null,x_iso_numeric_code),
798: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
799: null, null, x_alternate_territory_code),
800: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
801: null, null, x_nls_territory),
802: decode(x_address_style, fnd_territories_pkg.null_char, null,

Line 800: decode(x_nls_territory, fnd_territories_pkg.null_char, null,

796: decode(x_iso_numeric_code, fnd_territories_pkg.null_char, null,
797: null, null,x_iso_numeric_code),
798: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
799: null, null, x_alternate_territory_code),
800: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
801: null, null, x_nls_territory),
802: decode(x_address_style, fnd_territories_pkg.null_char, null,
803: null, null, x_address_style),
804: decode(x_address_validation, fnd_territories_pkg.null_char, null,

Line 802: decode(x_address_style, fnd_territories_pkg.null_char, null,

798: decode(x_alternate_territory_code,fnd_territories_pkg.null_char, null,
799: null, null, x_alternate_territory_code),
800: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
801: null, null, x_nls_territory),
802: decode(x_address_style, fnd_territories_pkg.null_char, null,
803: null, null, x_address_style),
804: decode(x_address_validation, fnd_territories_pkg.null_char, null,
805: null, null, x_address_validation),
806: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,

Line 804: decode(x_address_validation, fnd_territories_pkg.null_char, null,

800: decode(x_nls_territory, fnd_territories_pkg.null_char, null,
801: null, null, x_nls_territory),
802: decode(x_address_style, fnd_territories_pkg.null_char, null,
803: null, null, x_address_style),
804: decode(x_address_validation, fnd_territories_pkg.null_char, null,
805: null, null, x_address_validation),
806: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
807: null, null, x_bank_info_style),
808: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,

Line 806: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,

802: decode(x_address_style, fnd_territories_pkg.null_char, null,
803: null, null, x_address_style),
804: decode(x_address_validation, fnd_territories_pkg.null_char, null,
805: null, null, x_address_validation),
806: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
807: null, null, x_bank_info_style),
808: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
809: null, null, x_bank_info_validation),
810: decode(x_eu_code, fnd_territories_pkg.null_char, null,

Line 808: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,

804: decode(x_address_validation, fnd_territories_pkg.null_char, null,
805: null, null, x_address_validation),
806: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
807: null, null, x_bank_info_style),
808: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
809: null, null, x_bank_info_validation),
810: decode(x_eu_code, fnd_territories_pkg.null_char, null,
811: null, null, x_eu_code),
812: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,

Line 810: decode(x_eu_code, fnd_territories_pkg.null_char, null,

806: decode(x_bank_info_style, fnd_territories_pkg.null_char, null,
807: null, null, x_bank_info_style),
808: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
809: null, null, x_bank_info_validation),
810: decode(x_eu_code, fnd_territories_pkg.null_char, null,
811: null, null, x_eu_code),
812: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,
813: null, null, x_iso_territory_code)
814: into l_iso_numeric_code, l_alternate_territory_code, l_nls_territory,

Line 812: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,

808: decode(x_bank_info_validation, fnd_territories_pkg.null_char, null,
809: null, null, x_bank_info_validation),
810: decode(x_eu_code, fnd_territories_pkg.null_char, null,
811: null, null, x_eu_code),
812: decode(x_iso_territory_code, fnd_territories_pkg.null_char, null,
813: null, null, x_iso_territory_code)
814: into l_iso_numeric_code, l_alternate_territory_code, l_nls_territory,
815: l_address_style, l_address_validation, l_bank_info_style,
816: l_bank_info_validation, l_eu_code, l_iso_territory_code

Line 819: FND_TERRITORIES_PKG.INSERT_ROW(

815: l_address_style, l_address_validation, l_bank_info_style,
816: l_bank_info_validation, l_eu_code, l_iso_territory_code
817: from dual;
818:
819: FND_TERRITORIES_PKG.INSERT_ROW(
820: X_ROWID,
821: X_TERRITORY_CODE,
822: L_EU_CODE,
823: L_ISO_NUMERIC_CODE,

Line 842: end FND_TERRITORIES_PKG;

838: L_ISO_TERRITORY_CODE);
839: end;
840: end LOAD_ROW;
841:
842: end FND_TERRITORIES_PKG;