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.GR_EIN_NUMBERS_TL_PKG dependencies on GR_EIN_NUMBERS_TL

Line 1: PACKAGE BODY GR_EIN_NUMBERS_TL_PKG AS

1: PACKAGE BODY GR_EIN_NUMBERS_TL_PKG AS
2: /*$Header: GRHIEITB.pls 115.4 2003/08/05 18:04:35 gkelly noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_ein_numbers_tl

72: IF FND_API.To_Boolean(l_key_exists) THEN
73: RAISE Item_Exists_Error;
74: END IF;
75:
76: INSERT INTO gr_ein_numbers_tl
77: (european_index_number,
78: language,
79: description,
80: source_lang,

Line 238: UPDATE gr_ein_numbers_tl

234:
235: IF l_return_status <> 'S' THEN
236: RAISE Foreign_Key_Error;
237: ELSE
238: UPDATE gr_ein_numbers_tl
239: SET european_index_number = p_european_index_number,
240: language = p_language,
241: description = p_description,
242: source_lang = p_source_lang,

Line 352: FROM gr_ein_numbers_tl eit

348: eit.creation_date,
349: eit.last_updated_by,
350: eit.last_update_date,
351: eit.last_update_login
352: FROM gr_ein_numbers_tl eit
353: WHERE eit.european_index_number = p_european_index_number
354: AND eit.language = l_language;
355: TypeDesc c_get_descs%ROWTYPE;
356:

Line 376: delete from GR_EIN_NUMBERS_TL T

372: l_msg_token := p_european_index_number || ' ' || p_language;
373:
374: /* Remove translations with no base row */
375:
376: delete from GR_EIN_NUMBERS_TL T
377: where not exists
378: (select NULL
379: from GR_EIN_NUMBERS_B B
380: where B.EUROPEAN_INDEX_NUMBER = T.EUROPEAN_INDEX_NUMBER

Line 385: update gr_ein_numbers_tl t set (

381: );
382:
383: /* Redefault translations from the source language */
384:
385: update gr_ein_numbers_tl t set (
386: description ) =
387: ( select
388: B.DESCRIPTION
389: from GR_EIN_NUMBERS_TL B

Line 389: from GR_EIN_NUMBERS_TL B

385: update gr_ein_numbers_tl t set (
386: description ) =
387: ( select
388: B.DESCRIPTION
389: from GR_EIN_NUMBERS_TL B
390: where B.EUROPEAN_INDEX_NUMBER = T.EUROPEAN_INDEX_NUMBER
391: and B.LANGUAGE = T.SOURCE_LANG)
392: where (
393: T.EUROPEAN_INDEX_NUMBER,

Line 398: from GR_EIN_NUMBERS_TL SUBB, GR_EIN_NUMBERS_TL SUBT

394: T.LANGUAGE
395: ) in (select
396: SUBT.EUROPEAN_INDEX_NUMBER,
397: SUBT.LANGUAGE
398: from GR_EIN_NUMBERS_TL SUBB, GR_EIN_NUMBERS_TL SUBT
399: where SUBB.EUROPEAN_INDEX_NUMBER = SUBT.EUROPEAN_INDEX_NUMBER
400: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
401: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
402: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 440: INSERT INTO gr_ein_numbers_tl

436: OPEN c_get_descs;
437: FETCH c_get_descs INTO TypeDesc;
438: IF c_get_descs%NOTFOUND THEN
439: CLOSE c_get_descs;
440: INSERT INTO gr_ein_numbers_tl
441: (european_index_number,
442: language,
443: description,
444: source_lang,

Line 547: FROM gr_ein_numbers_tl

543:
544: CURSOR c_lock_ein_number
545: IS
546: SELECT last_update_date
547: FROM gr_ein_numbers_tl
548: WHERE rowid = p_rowid
549: FOR UPDATE NOWAIT;
550: LockEinRcd c_lock_ein_number%ROWTYPE;
551: BEGIN

Line 678: DELETE FROM gr_ein_numbers_tl

674: IF l_return_status <> 'S' THEN
675: RAISE Check_Integrity_Error;
676: END IF;
677:
678: DELETE FROM gr_ein_numbers_tl
679: WHERE rowid = p_rowid;
680:
681: /* Check the commit flag and if set, then commit the work. */
682:

Line 763: DELETE FROM gr_ein_numbers_tl

759: x_oracle_error := 0;
760: x_msg_data := NULL;
761: l_msg_token := p_european_index_number;
762:
763: DELETE FROM gr_ein_numbers_tl
764: WHERE european_index_number = p_european_index_number;
765:
766: IF FND_API.To_Boolean(p_commit) THEN
767: COMMIT WORK;

Line 984: FROM gr_ein_numbers_tl ein

980:
981: CURSOR c_get_ein_rowid
982: IS
983: SELECT ein.rowid
984: FROM gr_ein_numbers_tl ein
985: WHERE ein.european_index_number = p_european_index_number
986: AND ein.language = p_language;
987: EinRecord c_get_ein_rowid%ROWTYPE;
988:

Line 1033: delete from GR_EIN_NUMBERS_TL T

1029: ===================================================================== */
1030: PROCEDURE NEW_LANGUAGE
1031: is
1032: begin
1033: delete from GR_EIN_NUMBERS_TL T
1034: where not exists
1035: (select NULL
1036: from GR_EIN_NUMBERS_B B
1037: where B.EUROPEAN_INDEX_NUMBER = T.EUROPEAN_INDEX_NUMBER

Line 1040: update GR_EIN_NUMBERS_TL T set (

1036: from GR_EIN_NUMBERS_B B
1037: where B.EUROPEAN_INDEX_NUMBER = T.EUROPEAN_INDEX_NUMBER
1038: );
1039:
1040: update GR_EIN_NUMBERS_TL T set (
1041: DESCRIPTION
1042: ) = (select
1043: B.DESCRIPTION
1044: from GR_EIN_NUMBERS_TL B

Line 1044: from GR_EIN_NUMBERS_TL B

1040: update GR_EIN_NUMBERS_TL T set (
1041: DESCRIPTION
1042: ) = (select
1043: B.DESCRIPTION
1044: from GR_EIN_NUMBERS_TL B
1045: where B.EUROPEAN_INDEX_NUMBER = T.EUROPEAN_INDEX_NUMBER
1046: and B.LANGUAGE = T.SOURCE_LANG)
1047: where (
1048: T.EUROPEAN_INDEX_NUMBER,

Line 1053: from GR_EIN_NUMBERS_TL SUBB, GR_EIN_NUMBERS_TL SUBT

1049: T.LANGUAGE
1050: ) in (select
1051: SUBT.EUROPEAN_INDEX_NUMBER,
1052: SUBT.LANGUAGE
1053: from GR_EIN_NUMBERS_TL SUBB, GR_EIN_NUMBERS_TL SUBT
1054: where SUBB.EUROPEAN_INDEX_NUMBER = SUBT.EUROPEAN_INDEX_NUMBER
1055: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1056: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1057: ));

Line 1059: insert into GR_EIN_NUMBERS_TL (

1055: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1056: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1057: ));
1058:
1059: insert into GR_EIN_NUMBERS_TL (
1060: DESCRIPTION,
1061: CREATED_BY,
1062: CREATION_DATE,
1063: LAST_UPDATED_BY,

Line 1079: from GR_EIN_NUMBERS_TL B, FND_LANGUAGES L

1075: B.LAST_UPDATE_LOGIN,
1076: B.EUROPEAN_INDEX_NUMBER,
1077: L.LANGUAGE_CODE,
1078: B.SOURCE_LANG
1079: from GR_EIN_NUMBERS_TL B, FND_LANGUAGES L
1080: where L.INSTALLED_FLAG in ('I', 'B')
1081: and B.LANGUAGE = userenv('LANG')
1082: and not exists
1083: (select NULL

Line 1084: from GR_EIN_NUMBERS_TL T

1080: where L.INSTALLED_FLAG in ('I', 'B')
1081: and B.LANGUAGE = userenv('LANG')
1082: and not exists
1083: (select NULL
1084: from GR_EIN_NUMBERS_TL T
1085: where T.EUROPEAN_INDEX_NUMBER = B.EUROPEAN_INDEX_NUMBER
1086: and T.LANGUAGE = L.LANGUAGE_CODE);
1087:
1088: END NEW_LANGUAGE;

Line 1090: END GR_EIN_NUMBERS_TL_PKG;

1086: and T.LANGUAGE = L.LANGUAGE_CODE);
1087:
1088: END NEW_LANGUAGE;
1089:
1090: END GR_EIN_NUMBERS_TL_PKG;