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_OTHER_NAMES_TL_PKG dependencies on GR_OTHER_NAMES_TL

Line 1: PACKAGE BODY GR_OTHER_NAMES_TL_PKG AS

1: PACKAGE BODY GR_OTHER_NAMES_TL_PKG AS
2: /*$Header: GRHIONTB.pls 115.13 2002/10/28 17:03:11 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 82: INSERT INTO gr_other_names_tl

78: IF FND_API.To_Boolean(l_key_exists) THEN
79: RAISE Item_Exists_Error;
80: END IF;
81:
82: INSERT INTO gr_other_names_tl
83: (item_code,
84: language,
85: orgn_code,
86: synonym_sequence_number,

Line 259: UPDATE gr_other_names_tl

255:
256: IF l_return_status <> 'S' THEN
257: RAISE Foreign_Key_Error;
258: ELSE
259: UPDATE gr_other_names_tl
260: SET item_code = p_item_code,
261: language = p_language,
262: orgn_code = p_orgn_code,
263: synonym_sequence_number = p_synonym_sequence_number,

Line 382: FROM gr_other_names_tl ion

378: ion.last_updated_by,
379: ion.last_update_date,
380: ion.last_update_login,
381: ion.language
382: FROM gr_other_names_tl ion
383: WHERE ion.item_code = p_item_code
384: AND ion.orgn_code = p_orgn_code
385: AND (ion.language = l_language OR
386: synonym_sequence_number NOT IN (SELECT synonym_sequence_number

Line 387: FROM gr_other_names_tl

383: WHERE ion.item_code = p_item_code
384: AND ion.orgn_code = p_orgn_code
385: AND (ion.language = l_language OR
386: synonym_sequence_number NOT IN (SELECT synonym_sequence_number
387: FROM gr_other_names_tl
388: WHERE item_code = p_item_code
389: AND orgn_code = p_orgn_code
390: AND language = l_language));
391: OtherNameDesc c_get_descs%ROWTYPE;

Line 396: FROM gr_other_names_tl ion

392:
393: CURSOR c_get_descs_sequence
394: IS
395: SELECT 1
396: FROM gr_other_names_tl ion
397: WHERE ion.item_code = p_item_code
398: AND ion.orgn_code = p_orgn_code
399: AND ion.language = l_language
400: AND ion.synonym_sequence_number = l_synonym_sequence;

Line 422: delete from GR_OTHER_NAMES_TL T

418: l_msg_token := p_item_code || ' ' || p_orgn_code || ' ' || p_language;
419:
420: /* Remove translations with no base row */
421:
422: delete from GR_OTHER_NAMES_TL T
423: where not exists
424: (select NULL
425: from GR_ITEM_GENERAL B,
426: SY_ORGN_MST S

Line 433: update gr_other_names_tl t set (

429: );
430:
431: /* Redefault translations from the source language */
432:
433: update gr_other_names_tl t set (
434: item_other_name ) =
435: ( select
436: B.ITEM_OTHER_NAME
437: from GR_OTHER_NAMES_TL B

Line 437: from GR_OTHER_NAMES_TL B

433: update gr_other_names_tl t set (
434: item_other_name ) =
435: ( select
436: B.ITEM_OTHER_NAME
437: from GR_OTHER_NAMES_TL B
438: where B.ITEM_CODE = T.ITEM_CODE
439: and B.ORGN_CODE = T.ORGN_CODE
440: and B.LANGUAGE = T.SOURCE_LANG
441: and B.SYNONYM_SEQUENCE_NUMBER = T.SYNONYM_SEQUENCE_NUMBER)

Line 450: from GR_OTHER_NAMES_TL SUBB, GR_OTHER_NAMES_TL SUBT

446: ) in (select
447: SUBT.ITEM_CODE,
448: SUBT.ORGN_CODE,
449: SUBT.LANGUAGE
450: from GR_OTHER_NAMES_TL SUBB, GR_OTHER_NAMES_TL SUBT
451: where SUBB.ITEM_CODE = SUBT.ITEM_CODE
452: and SUBB.ORGN_CODE = SUBT.ORGN_CODE
453: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
454: and (SUBB.ITEM_OTHER_NAME <> SUBT.ITEM_OTHER_NAME

Line 496: INSERT INTO gr_other_names_tl

492: OPEN c_get_descs_sequence;
493: FETCH c_get_descs_sequence INTO l_exists;
494: IF c_get_descs_sequence%NOTFOUND THEN
495: CLOSE c_get_descs_sequence;
496: INSERT INTO gr_other_names_tl
497: (item_code,
498: language,
499: orgn_code,
500: synonym_sequence_number,

Line 613: FROM gr_other_names_tl

609:
610: CURSOR c_lock_other_name_tl
611: IS
612: SELECT *
613: FROM gr_other_names_tl
614: WHERE rowid = p_rowid
615: FOR UPDATE NOWAIT;
616: LockOtherNameRcd c_lock_other_name_tl%ROWTYPE;
617:

Line 756: DELETE FROM gr_other_names_tl

752: IF l_return_status <> 'S' THEN
753: RAISE Check_Integrity_Error;
754: END IF;
755:
756: DELETE FROM gr_other_names_tl
757: WHERE rowid = p_rowid;
758:
759: /* Check the commit flag and if set, then commit the work. */
760:

Line 861: DELETE FROM gr_other_names_tl

857: RAISE Null_Delete_Option_Error;
858: ELSE
859: l_msg_token := p_item_code;
860:
861: DELETE FROM gr_other_names_tl
862: WHERE item_code = p_item_code;
863: END IF;
864: ELSIF p_delete_option = 'O' THEN
865: IF p_orgn_code IS NULL THEN

Line 871: DELETE FROM gr_other_names_tl

867: RAISE Null_Delete_Option_Error;
868: ELSE
869: l_msg_token := p_orgn_code;
870:
871: DELETE FROM gr_other_names_tl
872: WHERE orgn_code = p_orgn_code;
873: END IF;
874: ELSIF p_delete_option = 'B' THEN
875: IF p_item_code IS NULL OR

Line 882: DELETE FROM gr_other_names_tl

878: RAISE Null_Delete_Option_Error;
879: ELSE
880: l_msg_token := p_item_code || ' ' || p_orgn_code;
881:
882: DELETE FROM gr_other_names_tl
883: WHERE item_code = p_item_code
884: AND orgn_code = p_orgn_code;
885: END IF;
886: END IF;

Line 1181: FROM gr_other_names_tl ion

1177:
1178: CURSOR c_get_other_name_tl_rowid
1179: IS
1180: SELECT ion.rowid
1181: FROM gr_other_names_tl ion
1182: WHERE ion.item_code = p_item_code
1183: AND ion.orgn_code = p_orgn_code
1184: AND ion.language = p_language
1185: AND ion.synonym_sequence_number = p_synonym_sequence_number;

Line 1223: delete from GR_OTHER_NAMES_TL T

1219: to be called from GRNLINS.sql. Generated from tltblgen. */
1220:
1221: PROCEDURE NEW_LANGUAGE IS
1222: begin
1223: delete from GR_OTHER_NAMES_TL T
1224: where not exists
1225: (select NULL
1226: from GR_ITEM_GENERAL B,
1227: SY_ORGN_MST S

Line 1234: update gr_other_names_tl t set (

1230: );
1231:
1232: /* Redefault translations from the source language */
1233:
1234: update gr_other_names_tl t set (
1235: item_other_name ) =
1236: ( select
1237: B.ITEM_OTHER_NAME
1238: from GR_OTHER_NAMES_TL B

Line 1238: from GR_OTHER_NAMES_TL B

1234: update gr_other_names_tl t set (
1235: item_other_name ) =
1236: ( select
1237: B.ITEM_OTHER_NAME
1238: from GR_OTHER_NAMES_TL B
1239: where B.ITEM_CODE = T.ITEM_CODE
1240: and B.ORGN_CODE = T.ORGN_CODE
1241: and B.LANGUAGE = T.SOURCE_LANG
1242: and B.SYNONYM_SEQUENCE_NUMBER = T.SYNONYM_SEQUENCE_NUMBER)

Line 1251: from GR_OTHER_NAMES_TL SUBB, GR_OTHER_NAMES_TL SUBT

1247: ) in (select
1248: SUBT.ITEM_CODE,
1249: SUBT.ORGN_CODE,
1250: SUBT.LANGUAGE
1251: from GR_OTHER_NAMES_TL SUBB, GR_OTHER_NAMES_TL SUBT
1252: where SUBB.ITEM_CODE = SUBT.ITEM_CODE
1253: and SUBB.ORGN_CODE = SUBT.ORGN_CODE
1254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1255: and (SUBB.ITEM_OTHER_NAME <> SUBT.ITEM_OTHER_NAME

Line 1260: insert into GR_OTHER_NAMES_TL (

1256: or (SUBB.ITEM_OTHER_NAME is null and SUBT.ITEM_OTHER_NAME is not null)
1257: or (SUBB.ITEM_OTHER_NAME is not null and SUBT.ITEM_OTHER_NAME is null)
1258: ));
1259:
1260: insert into GR_OTHER_NAMES_TL (
1261: ITEM_CODE,
1262: ORGN_CODE,
1263: SYNONYM_SEQUENCE_NUMBER,
1264: ITEM_OTHER_NAME,

Line 1284: from GR_OTHER_NAMES_TL B, FND_LANGUAGES L

1280: B.LAST_UPDATE_DATE,
1281: B.LAST_UPDATE_LOGIN,
1282: L.LANGUAGE_CODE,
1283: B.SOURCE_LANG
1284: from GR_OTHER_NAMES_TL B, FND_LANGUAGES L
1285: where L.INSTALLED_FLAG in ('I', 'B')
1286: and B.LANGUAGE = userenv('LANG')
1287: and not exists
1288: (select NULL

Line 1289: from GR_OTHER_NAMES_TL T

1285: where L.INSTALLED_FLAG in ('I', 'B')
1286: and B.LANGUAGE = userenv('LANG')
1287: and not exists
1288: (select NULL
1289: from GR_OTHER_NAMES_TL T
1290: where T.ITEM_CODE = B.ITEM_CODE
1291: and T.ORGN_CODE = B.ORGN_CODE
1292: and T.LANGUAGE = L.LANGUAGE_CODE);
1293: end NEW_LANGUAGE;

Line 1295: END GR_OTHER_NAMES_TL_PKG;

1291: and T.ORGN_CODE = B.ORGN_CODE
1292: and T.LANGUAGE = L.LANGUAGE_CODE);
1293: end NEW_LANGUAGE;
1294:
1295: END GR_OTHER_NAMES_TL_PKG;