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_FIELD_NAME_PROPERTIES_PUB dependencies on GR_PROPERTIES_TL

Line 106: FROM GR_PROPERTIES_TL

102: FROM fnd_languages
103: WHERE installed_flag IN ('I', 'B')
104: AND language_code not in
105: (SELECT language
106: FROM GR_PROPERTIES_TL
107: WHERE PROPERTY_ID = p_PROPERTY_ID);
108:
109: CURSOR c_get_property_id is
110: SELECT 1

Line 122: CURSOR c_get_gr_properties_tl

118: GR_PROPERTIES_B B
119: where B.PROPERTY_ID = p_property_id
120: and property_type_indicator = 'F';
121:
122: CURSOR c_get_gr_properties_tl
123: IS
124: SELECT 1
125: FROM gr_properties_tl prt
126: WHERE prt.property_id = p_property_id

Line 125: FROM gr_properties_tl prt

121:
122: CURSOR c_get_gr_properties_tl
123: IS
124: SELECT 1
125: FROM gr_properties_tl prt
126: WHERE prt.property_id = p_property_id
127: AND prt.language = p_language;
128:
129: L_MSG_TOKEN VARCHAR2(100);

Line 295: -- need to add base row for language for GR_PROPERTIES_TL

291: END IF;
292:
293:
294:
295: -- need to add base row for language for GR_PROPERTIES_TL
296:
297: gr_properties_tl_pkg.insert_row(
298: p_commit => 'F',
299: p_called_by_form => 'F',

Line 297: gr_properties_tl_pkg.insert_row(

293:
294:
295: -- need to add base row for language for GR_PROPERTIES_TL
296:
297: gr_properties_tl_pkg.insert_row(
298: p_commit => 'F',
299: p_called_by_form => 'F',
300: p_property_id => p_property_id,
301: p_language => p_language,

Line 325: -- Insert a record into GR_PROPERTIES_TL for each installed language.

321: RAISE LCins_err;
322: END IF;
323:
324:
325: -- Insert a record into GR_PROPERTIES_TL for each installed language.
326:
327: OPEN Cur_count_language;
328: FETCH Cur_count_language INTO l_missing_count;
329: CLOSE Cur_count_language;

Line 332: gr_properties_tl_pkg.Add_Language

328: FETCH Cur_count_language INTO l_missing_count;
329: CLOSE Cur_count_language;
330: IF l_missing_count > 0 THEN
331:
332: gr_properties_tl_pkg.Add_Language
333: (p_commit => 'F',
334: p_called_by_form => 'F',
335: p_property_id => p_property_id,
336: p_language => p_language,

Line 410: OPEN c_get_gr_properties_tl;

406: l_msg_token := l_property_id;
407: RAISE Row_Missing_Error;
408: END IF;
409:
410: OPEN c_get_gr_properties_tl;
411: FETCH c_get_gr_properties_tl INTO dummy;
412: IF c_get_gr_properties_tl%FOUND THEN
413: x_return_status := 'E';
414: l_msg_token := p_property_id|| ' ' || p_language;

Line 411: FETCH c_get_gr_properties_tl INTO dummy;

407: RAISE Row_Missing_Error;
408: END IF;
409:
410: OPEN c_get_gr_properties_tl;
411: FETCH c_get_gr_properties_tl INTO dummy;
412: IF c_get_gr_properties_tl%FOUND THEN
413: x_return_status := 'E';
414: l_msg_token := p_property_id|| ' ' || p_language;
415: CLOSE c_get_gr_properties_tl;

Line 412: IF c_get_gr_properties_tl%FOUND THEN

408: END IF;
409:
410: OPEN c_get_gr_properties_tl;
411: FETCH c_get_gr_properties_tl INTO dummy;
412: IF c_get_gr_properties_tl%FOUND THEN
413: x_return_status := 'E';
414: l_msg_token := p_property_id|| ' ' || p_language;
415: CLOSE c_get_gr_properties_tl;
416: RAISE LT_Exists_Error;

Line 415: CLOSE c_get_gr_properties_tl;

411: FETCH c_get_gr_properties_tl INTO dummy;
412: IF c_get_gr_properties_tl%FOUND THEN
413: x_return_status := 'E';
414: l_msg_token := p_property_id|| ' ' || p_language;
415: CLOSE c_get_gr_properties_tl;
416: RAISE LT_Exists_Error;
417: END IF;
418: CLOSE c_get_gr_properties_tl;
419:

Line 418: CLOSE c_get_gr_properties_tl;

414: l_msg_token := p_property_id|| ' ' || p_language;
415: CLOSE c_get_gr_properties_tl;
416: RAISE LT_Exists_Error;
417: END IF;
418: CLOSE c_get_gr_properties_tl;
419:
420:
421: gr_properties_tl_pkg.insert_row(
422: p_commit => 'F',

Line 421: gr_properties_tl_pkg.insert_row(

417: END IF;
418: CLOSE c_get_gr_properties_tl;
419:
420:
421: gr_properties_tl_pkg.insert_row(
422: p_commit => 'F',
423: p_called_by_form => 'F',
424: p_property_id => p_property_id,
425: p_language => p_language,

Line 575: -- does not exist in the GR_PROPERTIES_TL table, an error will be written to the log file

571: END IF;
572: CLOSE c_get_language;
573:
574: -- If the record for the specified phrase code and language
575: -- does not exist in the GR_PROPERTIES_TL table, an error will be written to the log file
576:
577:
578: gr_properties_tl_pkg.Check_Primary_Key(
579: p_property_id,

Line 578: gr_properties_tl_pkg.Check_Primary_Key(

574: -- If the record for the specified phrase code and language
575: -- does not exist in the GR_PROPERTIES_TL table, an error will be written to the log file
576:
577:
578: gr_properties_tl_pkg.Check_Primary_Key(
579: p_property_id,
580: p_language,
581: 'F',
582: row_id,

Line 589: -- The value for Property Description will be updated GR_PROPERTIES_TL table for the specified language.

585: IF l_key_exists = 'N' THEN
586: l_msg_token := p_property_id|| ' ' || p_language;
587: RAISE Row_Missing_Error;
588: END IF;
589: -- The value for Property Description will be updated GR_PROPERTIES_TL table for the specified language.
590:
591: UPDATE GR_PROPERTIES_TL
592: SET description = p_description,
593: last_updated_by = FND_GLOBAL.USER_ID,

Line 591: UPDATE GR_PROPERTIES_TL

587: RAISE Row_Missing_Error;
588: END IF;
589: -- The value for Property Description will be updated GR_PROPERTIES_TL table for the specified language.
590:
591: UPDATE GR_PROPERTIES_TL
592: SET description = p_description,
593: last_updated_by = FND_GLOBAL.USER_ID,
594: last_update_date = SYSDATE,
595: last_update_login = l_last_update_login

Line 621: gr_properties_tl_pkg.Check_Primary_Key

617:
618: -- Validate that the value of Language for the specified property exists in the
619: -- table GR_PROPERTY_VALUES_TL. If it does, write an error to the log file.
620:
621: gr_properties_tl_pkg.Check_Primary_Key
622: (p_property_id,
623: p_language,
624: 'F',
625: row_id,

Line 683: -- Delete all of the property related records in the GR_PROPERTIES_B, GR_PROPERTIES_TL and GR_PROPERTY_VALUES_TL tables.

679:
680:
681: IF p_object = 'C' then
682:
683: -- Delete all of the property related records in the GR_PROPERTIES_B, GR_PROPERTIES_TL and GR_PROPERTY_VALUES_TL tables.
684:
685: delete from GR_PROPERTY_VALUES_TL T
686: where t.PROPERTY_ID = p_PROPERTY_ID;
687:

Line 688: delete from GR_PROPERTIES_TL T

684:
685: delete from GR_PROPERTY_VALUES_TL T
686: where t.PROPERTY_ID = p_PROPERTY_ID;
687:
688: delete from GR_PROPERTIES_TL T
689: where t.PROPERTY_ID = p_PROPERTY_ID;
690:
691: DELETE FROM GR_PROPERTIES_B
692: where PROPERTY_ID = p_PROPERTY_ID;

Line 722: --and language does not exist in the GR_PROPERTIES_TL table, an error will be written to the log file.

718: CLOSE c_get_language;
719:
720:
721: -- if the record for the property_id
722: --and language does not exist in the GR_PROPERTIES_TL table, an error will be written to the log file.
723:
724: gr_properties_tl_pkg.Check_Primary_Key
725: (p_property_id,
726: p_language,

Line 724: gr_properties_tl_pkg.Check_Primary_Key

720:
721: -- if the record for the property_id
722: --and language does not exist in the GR_PROPERTIES_TL table, an error will be written to the log file.
723:
724: gr_properties_tl_pkg.Check_Primary_Key
725: (p_property_id,
726: p_language,
727: 'F',
728: row_id,

Line 736: -- Delete the record in GR_PROPERTIES_TL table for the specified language

732: l_msg_token := p_property_id || ' ' || p_language;
733: RAISE LT_Exists_Error;
734: END IF;
735:
736: -- Delete the record in GR_PROPERTIES_TL table for the specified language
737:
738: delete from GR_PROPERTIES_TL
739: WHERE property_id = p_property_id
740: and language = p_language;

Line 738: delete from GR_PROPERTIES_TL

734: END IF;
735:
736: -- Delete the record in GR_PROPERTIES_TL table for the specified language
737:
738: delete from GR_PROPERTIES_TL
739: WHERE property_id = p_property_id
740: and language = p_language;
741: IF SQL%NOTFOUND THEN
742: l_msg_token := p_property_id || ' ' || p_language;