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_RISK_PHRASES_TL

Line 132: FROM gr_risk_phrases_TL

128: FROM fnd_languages
129: WHERE installed_flag IN ('I', 'B')
130: AND language_code not in
131: (SELECT language
132: FROM gr_risk_phrases_TL
133: WHERE risk_phrase_code = p_phrase_code);
134:
135: CURSOR c_get_safety_phrase_code IS
136: SELECT safety_phrase_code

Line 155: FROM gr_risk_phrases_TL

151: riskcode c_get_risk_phrase_code%ROWTYPE;
152:
153: CURSOR c_get_risk_phrase_tl IS
154: SELECT 1
155: FROM gr_risk_phrases_TL
156: WHERE risk_phrase_code = p_phrase_code
157: AND language = p_language;
158:
159: L_MSG_TOKEN VARCHAR2(100);

Line 438: -- need to add base row for language for GR_RISK_PHRASES_TL

434: GMD_API_PUB.Log_Message(msg_data);
435: RAISE LBins_err;
436: END IF;
437:
438: -- need to add base row for language for GR_RISK_PHRASES_TL
439: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',
440: p_called_by_form => 'F',
441: p_risk_phrase_code => p_phrase_code,
442: p_language => p_language,

Line 439: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',

435: RAISE LBins_err;
436: END IF;
437:
438: -- need to add base row for language for GR_RISK_PHRASES_TL
439: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',
440: p_called_by_form => 'F',
441: p_risk_phrase_code => p_phrase_code,
442: p_language => p_language,
443: p_source_language => p_source_language,

Line 460: -- Insert a record into GR_RISK_PHRASES_TL for each installed language.

456: GMD_API_PUB.Log_Message(msg_data);
457: RAISE LCins_err;
458: END IF;
459:
460: -- Insert a record into GR_RISK_PHRASES_TL for each installed language.
461: OPEN Cur_count_risk_language;
462: FETCH Cur_count_risk_language INTO l_missing_count;
463: CLOSE Cur_count_risk_language;
464: IF l_missing_count > 0 THEN

Line 465: gr_risk_phrases_tl_pkg.Add_Language (p_commit => 'T',

461: OPEN Cur_count_risk_language;
462: FETCH Cur_count_risk_language INTO l_missing_count;
463: CLOSE Cur_count_risk_language;
464: IF l_missing_count > 0 THEN
465: gr_risk_phrases_tl_pkg.Add_Language (p_commit => 'T',
466: p_called_by_form => 'F',
467: p_risk_phrase_code => p_phrase_code,
468: p_language => p_language,
469: x_return_status => return_status,

Line 495: -- GR_RISK_PHRASES_TL.If it does, write an error to the log file.

491: END IF;
492: CLOSE c_get_risk_phrase_code;
493:
494: -- Validate that the value of Language for the specified risk phrase does not exist in the table
495: -- GR_RISK_PHRASES_TL.If it does, write an error to the log file.
496:
497: OPEN c_get_risk_phrase_tl;
498: FETCH c_get_risk_phrase_tl INTO dummy;
499: IF c_get_risk_phrase_tl%FOUND THEN

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

503: RAISE LT_Exists_Error;
504: END IF;
505: CLOSE c_get_risk_phrase_tl;
506:
507: -- The values for Source Language, Language and Description will be written to the GR_RISK_PHRASES_TL table;
508: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',
509: p_called_by_form => 'F',
510: p_risk_phrase_code => p_phrase_code,
511: p_language => p_language,

Line 508: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',

504: END IF;
505: CLOSE c_get_risk_phrase_tl;
506:
507: -- The values for Source Language, Language and Description will be written to the GR_RISK_PHRASES_TL table;
508: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',
509: p_called_by_form => 'F',
510: p_risk_phrase_code => p_phrase_code,
511: p_language => p_language,
512: p_source_language => p_source_language,

Line 696: -- GR_RISK_PHRASES_TL table,an error will be written to the log file.

692: RAISE Row_Missing_Error;
693: END IF;
694: CLOSE c_get_language;
695: -- If the record for the specified risk phrase and language does not exist in the
696: -- GR_RISK_PHRASES_TL table,an error will be written to the log file.
697: gr_risk_phrases_tl_pkg.Check_Primary_Key(
698: p_phrase_code,
699: p_language,
700: 'F',

Line 697: gr_risk_phrases_tl_pkg.Check_Primary_Key(

693: END IF;
694: CLOSE c_get_language;
695: -- If the record for the specified risk phrase and language does not exist in the
696: -- GR_RISK_PHRASES_TL table,an error will be written to the log file.
697: gr_risk_phrases_tl_pkg.Check_Primary_Key(
698: p_phrase_code,
699: p_language,
700: 'F',
701: row_id,

Line 708: -- The value for Description will be updated GR_RISK_PHRASES_TL table for the specified language.

704: IF l_key_exists = 'N' THEN
705: l_msg_token := p_phrase_code|| ' ' || p_language;
706: RAISE Row_Missing_Error;
707: END IF;
708: -- The value for Description will be updated GR_RISK_PHRASES_TL table for the specified language.
709: UPDATE GR_RISK_PHRASES_TL
710: SET risk_description = p_phrase_text,
711: source_lang = p_source_language,
712: last_updated_by = FND_GLOBAL.USER_ID,

Line 709: UPDATE GR_RISK_PHRASES_TL

705: l_msg_token := p_phrase_code|| ' ' || p_language;
706: RAISE Row_Missing_Error;
707: END IF;
708: -- The value for Description will be updated GR_RISK_PHRASES_TL table for the specified language.
709: UPDATE GR_RISK_PHRASES_TL
710: SET risk_description = p_phrase_text,
711: source_lang = p_source_language,
712: last_updated_by = FND_GLOBAL.USER_ID,
713: last_update_date = SYSDATE,

Line 796: DELETE FROM gr_risk_phrases_tl

792: END IF;
793: CLOSE c_get_risk_phrase_code;
794: IF p_object = 'C' THEN
795: --Delete all the rows in tl and b tables for the passed risk phrase code
796: DELETE FROM gr_risk_phrases_tl
797: WHERE risk_phrase_code = p_phrase_code;
798:
799: DELETE FROM gr_risk_phrases_b
800: WHERE risk_phrase_code = p_phrase_code;

Line 824: gr_risk_phrases_tl_pkg.Check_Primary_Key(

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',
828: row_id,

Line 836: DELETE gr_risk_phrases_tl

832: RAISE Row_Missing_Error;
833: END IF;
834: -- delete form tl table for that language specific row
835:
836: DELETE gr_risk_phrases_tl
837: WHERE risk_phrase_code = p_phrase_code
838: and language = p_language;
839: IF SQL%NOTFOUND THEN
840: l_msg_token := p_phrase_code || ' ' || p_language;