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_RISK_SAFETY_PHRASES_PUB dependencies on GR_SAFETY_PHRASES_TL

Line 123: FROM gr_safety_phrases_TL

119: FROM fnd_languages
120: WHERE installed_flag IN ('I', 'B')
121: AND language_code not in
122: (SELECT language
123: FROM gr_safety_phrases_TL
124: WHERE safety_phrase_code = p_phrase_code);
125:
126: CURSOR Cur_count_risk_language IS
127: SELECT count (language_code)

Line 143: FROM gr_safety_phrases_TL

139: safetycode c_get_safety_phrase_code%ROWTYPE;
140:
141: CURSOR c_get_safety_phrase_tl IS
142: SELECT 1
143: FROM gr_safety_phrases_TL
144: WHERE safety_phrase_code = p_phrase_code
145: AND language = p_language;
146:
147: CURSOR c_get_risk_phrase_code IS

Line 276: -- need to add base row for language for GR_SAFETY_PHRASES_TL

272: GMD_API_PUB.Log_Message(msg_data);
273: RAISE LBins_err;
274: END IF;
275:
276: -- need to add base row for language for GR_SAFETY_PHRASES_TL
277: gr_safety_phrases_tl_pkg.insert_row(p_commit => 'T',
278: p_called_by_form => 'F',
279: p_safety_phrase_code => p_phrase_code,
280: p_language => p_language,

Line 277: gr_safety_phrases_tl_pkg.insert_row(p_commit => 'T',

273: RAISE LBins_err;
274: END IF;
275:
276: -- need to add base row for language for GR_SAFETY_PHRASES_TL
277: gr_safety_phrases_tl_pkg.insert_row(p_commit => 'T',
278: p_called_by_form => 'F',
279: p_safety_phrase_code => p_phrase_code,
280: p_language => p_language,
281: p_source_language => p_source_language,

Line 298: -- Insert a record into GR_SAFETY_PHRASES_TL for each installed language.

294: GMD_API_PUB.Log_Message(msg_data);
295: RAISE LCins_err;
296: END IF;
297:
298: -- Insert a record into GR_SAFETY_PHRASES_TL for each installed language.
299: OPEN Cur_count_language;
300: FETCH Cur_count_language INTO l_missing_count;
301: CLOSE Cur_count_language;
302: IF l_missing_count > 0 THEN

Line 303: gr_safety_phrases_tl_pkg.Add_Language (p_commit => 'T',

299: OPEN Cur_count_language;
300: FETCH Cur_count_language INTO l_missing_count;
301: CLOSE Cur_count_language;
302: IF l_missing_count > 0 THEN
303: gr_safety_phrases_tl_pkg.Add_Language (p_commit => 'T',
304: p_called_by_form => 'F',
305: p_safety_phrase_code => p_phrase_code,
306: p_language => p_language,
307: x_return_status => return_status,

Line 333: -- GR_SAFETY_PHRASES_TL. if it does, write an error to the log file.

329: END IF;
330: CLOSE c_get_safety_phrase_code;
331:
332: -- Validate that the value of Language for the specified property does not exist in the table
333: -- GR_SAFETY_PHRASES_TL. if it does, write an error to the log file.
334:
335: OPEN c_get_safety_phrase_tl;
336: FETCH c_get_safety_phrase_tl INTO dummy;
337: IF c_get_safety_phrase_tl%FOUND THEN

Line 345: -- The values for Source Language, Language and Description will be written to the GR_SAFETY_PHRASES_TL table;

341: RAISE LT_Exists_Error;
342: END IF;
343: CLOSE c_get_safety_phrase_tl;
344:
345: -- The values for Source Language, Language and Description will be written to the GR_SAFETY_PHRASES_TL table;
346: gr_safety_phrases_tl_pkg.insert_row(p_commit => 'T',
347: p_called_by_form => 'F',
348: p_safety_phrase_code => p_phrase_code,
349: p_language => p_language,

Line 346: gr_safety_phrases_tl_pkg.insert_row(p_commit => 'T',

342: END IF;
343: CLOSE c_get_safety_phrase_tl;
344:
345: -- The values for Source Language, Language and Description will be written to the GR_SAFETY_PHRASES_TL table;
346: gr_safety_phrases_tl_pkg.insert_row(p_commit => 'T',
347: p_called_by_form => 'F',
348: p_safety_phrase_code => p_phrase_code,
349: p_language => p_language,
350: p_source_language => p_source_language,

Line 601: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.

597: RAISE Row_Missing_Error;
598: END IF;
599: CLOSE c_get_language;
600: -- If the record for the specified safety phrase and language does not exist in the
601: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.
602: gr_safety_phrases_tl_pkg.Check_Primary_Key(
603: p_phrase_code,
604: p_language,
605: 'F',

Line 602: gr_safety_phrases_tl_pkg.Check_Primary_Key(

598: END IF;
599: CLOSE c_get_language;
600: -- If the record for the specified safety phrase and language does not exist in the
601: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.
602: gr_safety_phrases_tl_pkg.Check_Primary_Key(
603: p_phrase_code,
604: p_language,
605: 'F',
606: row_id,

Line 613: -- The value for Description will be updated GR_SAFETY_PHRASES_TL table for the specified language.

609: IF l_key_exists = 'N' THEN
610: l_msg_token := p_phrase_code|| ' ' || p_language;
611: RAISE Row_Missing_Error;
612: END IF;
613: -- The value for Description will be updated GR_SAFETY_PHRASES_TL table for the specified language.
614: UPDATE GR_SAFETY_PHRASES_TL
615: SET safety_phrase_description = p_phrase_text,
616: source_lang = p_source_language,
617: last_updated_by = FND_GLOBAL.USER_ID,

Line 614: UPDATE GR_SAFETY_PHRASES_TL

610: l_msg_token := p_phrase_code|| ' ' || p_language;
611: RAISE Row_Missing_Error;
612: END IF;
613: -- The value for Description will be updated GR_SAFETY_PHRASES_TL table for the specified language.
614: UPDATE GR_SAFETY_PHRASES_TL
615: SET safety_phrase_description = p_phrase_text,
616: source_lang = p_source_language,
617: last_updated_by = FND_GLOBAL.USER_ID,
618: last_update_date = SYSDATE,

Line 736: DELETE FROM gr_safety_phrases_tl

732: END IF;
733: CLOSE c_get_safety_phrase_code;
734: IF p_object = 'C' THEN
735: --Delete all the rows in tl and b tables for the passed safety phrase code
736: DELETE FROM gr_safety_phrases_tl
737: WHERE safety_phrase_code = p_phrase_code;
738:
739: DELETE FROM gr_safety_phrases_b
740: WHERE safety_phrase_code = p_phrase_code;

Line 763: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.

759: RAISE Row_Missing_Error;
760: END IF;
761: CLOSE c_get_language;
762: -- If the record for the specified safety phrase and language does not exist in the
763: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.
764: gr_safety_phrases_tl_pkg.Check_Primary_Key(
765: p_phrase_code,
766: p_language,
767: 'F',

Line 764: gr_safety_phrases_tl_pkg.Check_Primary_Key(

760: END IF;
761: CLOSE c_get_language;
762: -- If the record for the specified safety phrase and language does not exist in the
763: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.
764: gr_safety_phrases_tl_pkg.Check_Primary_Key(
765: p_phrase_code,
766: p_language,
767: 'F',
768: row_id,

Line 776: DELETE gr_safety_phrases_tl

772: RAISE Row_Missing_Error;
773: END IF;
774: -- delete form tl table for that language specific row
775:
776: DELETE gr_safety_phrases_tl
777: WHERE safety_phrase_code = p_phrase_code
778: and language = p_language;
779: IF SQL%NOTFOUND THEN
780: l_msg_token := p_phrase_code || ' ' || p_language;

Line 823: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.

819: RAISE Row_Missing_Error;
820: END IF;
821: CLOSE c_get_language;
822: -- If the record for the specified safety phrase and language does not exist in the
823: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.
824: gr_risk_phrases_tl_pkg.Check_Primary_Key(
825: p_phrase_code,
826: p_language,
827: 'F',