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.ORG_FREIGHT_TL_PKG dependencies on ORG_FREIGHT_TL

Line 1: package body ORG_FREIGHT_TL_PKG as

1: package body ORG_FREIGHT_TL_PKG as
2: /* $Header: INVORFCB.pls 120.1 2005/06/17 17:10:47 appldev $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_FREIGHT_CODE in VARCHAR2,

Line 54: cursor C is select ROWID from ORG_FREIGHT_TL

50: X_LAST_UPDATE_DATE in DATE,
51: X_LAST_UPDATED_BY in NUMBER,
52: X_LAST_UPDATE_LOGIN in NUMBER
53: ) is
54: cursor C is select ROWID from ORG_FREIGHT_TL
55: where FREIGHT_CODE = X_FREIGHT_CODE
56: and ORGANIZATION_ID = X_ORGANIZATION_ID
57: and LANGUAGE = userenv('LANG')
58: ;

Line 60: insert into ORG_FREIGHT_TL (

56: and ORGANIZATION_ID = X_ORGANIZATION_ID
57: and LANGUAGE = userenv('LANG')
58: ;
59: begin
60: insert into ORG_FREIGHT_TL (
61: FREIGHT_CODE,
62: FREIGHT_CODE_TL,
63: ORGANIZATION_ID,
64: LAST_UPDATE_DATE,

Line 166: from ORG_FREIGHT_TL T

162: from FND_LANGUAGES L
163: where L.INSTALLED_FLAG in ('I', 'B')
164: and not exists
165: (select NULL
166: from ORG_FREIGHT_TL T
167: where T.FREIGHT_CODE = X_FREIGHT_CODE
168: and T.ORGANIZATION_ID = X_ORGANIZATION_ID
169: and T.LANGUAGE = L.LANGUAGE_CODE);
170:

Line 270: from ORG_FREIGHT_TL

266: DESCRIPTION,
267: FREIGHT_CODE,
268: FREIGHT_CODE_TL,
269: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
270: from ORG_FREIGHT_TL
271: where FREIGHT_CODE = X_FREIGHT_CODE
272: and ORGANIZATION_ID = X_ORGANIZATION_ID
273: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
274: for update of FREIGHT_CODE nowait;

Line 420: update ORG_FREIGHT_TL set

416: X_LAST_UPDATED_BY in NUMBER,
417: X_LAST_UPDATE_LOGIN in NUMBER
418: ) as
419: begin
420: update ORG_FREIGHT_TL set
421: DISABLE_DATE = X_DISABLE_DATE,
422: DISTRIBUTION_ACCOUNT = X_DISTRIBUTION_ACCOUNT,
423: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
424: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 483: delete from ORG_FREIGHT_TL

479: X_FREIGHT_CODE in VARCHAR2,
480: X_ORGANIZATION_ID in NUMBER
481: ) as
482: begin
483: delete from ORG_FREIGHT_TL
484: where FREIGHT_CODE = X_FREIGHT_CODE
485: and ORGANIZATION_ID = X_ORGANIZATION_ID;
486:
487: if (sql%notfound) then

Line 496: update ORG_FREIGHT_TL T set (

492:
493: procedure ADD_LANGUAGE
494: as
495: begin
496: update ORG_FREIGHT_TL T set (
497: DESCRIPTION,
498: FREIGHT_CODE_TL
499: ) = (select
500: B.DESCRIPTION,

Line 502: from ORG_FREIGHT_TL B

498: FREIGHT_CODE_TL
499: ) = (select
500: B.DESCRIPTION,
501: B.FREIGHT_CODE
502: from ORG_FREIGHT_TL B
503: where B.FREIGHT_CODE = T.FREIGHT_CODE
504: and B.ORGANIZATION_ID = T.ORGANIZATION_ID
505: and B.LANGUAGE = T.SOURCE_LANG)
506: where (

Line 516: from ORG_FREIGHT_TL SUBB, ORG_FREIGHT_TL SUBT

512: SUBT.FREIGHT_CODE_TL,
513: SUBT.FREIGHT_CODE,
514: SUBT.ORGANIZATION_ID,
515: SUBT.LANGUAGE
516: from ORG_FREIGHT_TL SUBB, ORG_FREIGHT_TL SUBT
517: where SUBB.FREIGHT_CODE = SUBT.FREIGHT_CODE
518: and SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
519: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
520: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 526: insert into ORG_FREIGHT_TL (

522: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
523: or SUBB.FREIGHT_CODE <> SUBT.FREIGHT_CODE
524: ));
525:
526: insert into ORG_FREIGHT_TL (
527: FREIGHT_CODE_TL,
528: FREIGHT_CODE,
529: ORGANIZATION_ID,
530: LAST_UPDATE_DATE,

Line 628: from ORG_FREIGHT_TL B, FND_LANGUAGES L

624: B.GLOBAL_ATTRIBUTE20,
625: B.GLOBAL_ATTRIBUTE_CATEGORY,
626: L.LANGUAGE_CODE,
627: B.SOURCE_LANG
628: from ORG_FREIGHT_TL B, FND_LANGUAGES L
629: where L.INSTALLED_FLAG in ('I', 'B')
630: and B.LANGUAGE = userenv('LANG')
631: and not exists
632: (select NULL

Line 633: from ORG_FREIGHT_TL T

629: where L.INSTALLED_FLAG in ('I', 'B')
630: and B.LANGUAGE = userenv('LANG')
631: and not exists
632: (select NULL
633: from ORG_FREIGHT_TL T
634: where T.FREIGHT_CODE = B.FREIGHT_CODE
635: and T.ORGANIZATION_ID = B.ORGANIZATION_ID
636: and T.LANGUAGE = L.LANGUAGE_CODE);
637: end ADD_LANGUAGE;

Line 703: org_freight_tl_pkg.Update_row(

699: into org_id
700: from mtl_parameters
701: where organization_code = X_ORGANIZATION_CODE;
702:
703: org_freight_tl_pkg.Update_row(
704: X_FREIGHT_CODE => X_FREIGHT_CODE,
705: X_FREIGHT_CODE_TL => X_FREIGHT_CODE_TL,
706: X_ORGANIZATION_ID => org_id,
707: X_DISABLE_DATE => X_DISABLE_DATE,

Line 752: org_freight_tl_pkg.insert_row(

748: X_LAST_UPDATED_BY => user_id,
749: X_LAST_UPDATE_LOGIN => 0);
750: exception
751: when no_data_found then
752: org_freight_tl_pkg.insert_row(
753: X_ROWID => row_id,
754: X_FREIGHT_CODE => X_FREIGHT_CODE,
755: X_FREIGHT_CODE_TL=> X_FREIGHT_CODE_TL,
756: X_ORGANIZATION_ID => org_id,

Line 815: update ORG_FREIGHT_TL set

811: X_OWNER in VARCHAR2)
812: as
813: Begin
814:
815: update ORG_FREIGHT_TL set
816: FREIGHT_CODE_TL = X_FREIGHT_CODE_TL,
817: DESCRIPTION = X_DESCRIPTION,
818: LAST_UPDATE_DATE = sysdate,
819: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),

Line 828: end ORG_FREIGHT_TL_PKG;

824: and ORGANIZATION_ID = X_ORGANIZATION_ID;
825:
826: end TRANSLATE_ROW;
827:
828: end ORG_FREIGHT_TL_PKG;