APPS.GR_RISK_SAFETY_PHRASES_PUB dependencies on GR_SAFETY_PHRASES_B

Line 137: FROM gr_safety_phrases_b

133: WHERE risk_phrase_code = p_phrase_code);
134:
135: CURSOR c_get_safety_phrase_code IS
136: SELECT safety_phrase_code
137: FROM gr_safety_phrases_b
138: WHERE safety_phrase_code = p_phrase_code;
139: safetycode c_get_safety_phrase_code%ROWTYPE;
140:
141: CURSOR c_get_safety_phrase_tl IS

Line 209: -- GR_SAFETY_PHRASES_B.If it does, write an error to the log file

205:
206: IF p_phrase_type = 'S' THEN
207: IF p_object = 'C' then
208: -- Validate that the value of Safety phrase code does not already exist in the table
209: -- GR_SAFETY_PHRASES_B.If it does, write an error to the log file
210: OPEN c_get_safety_phrase_code;
211: FETCH c_get_safety_phrase_code INTO safetycode;
212: IF c_get_safety_phrase_code%NOTFOUND THEN
213: null;

Line 222: -- insert a record for GR_SAFETY_PHRASES_B

218: RAISE LT_Exists_Error;
219: END IF;
220: CLOSE c_get_safety_phrase_code;
221:
222: -- insert a record for GR_SAFETY_PHRASES_B
223: gr_safety_phrases_b_pkg.Insert_Row
224: (p_commit => 'T',
225: p_called_by_form => 'F',
226: p_safety_phrase_code => p_phrase_code,

Line 223: gr_safety_phrases_b_pkg.Insert_Row

219: END IF;
220: CLOSE c_get_safety_phrase_code;
221:
222: -- insert a record for GR_SAFETY_PHRASES_B
223: gr_safety_phrases_b_pkg.Insert_Row
224: (p_commit => 'T',
225: p_called_by_form => 'F',
226: p_safety_phrase_code => p_phrase_code,
227: p_additional_text_type => 'N',

Line 321: -- GR_SAFETY_PHRASES_B.If it does, write an error to the log file

317: END IF; -- IF l_missing_count > 0 THEN
318:
319: ELSIF p_object = 'L' then
320: -- Validate that the value of Safety phrase code does not already exist in the table
321: -- GR_SAFETY_PHRASES_B.If it does, write an error to the log file
322: OPEN c_get_safety_phrase_code;
323: FETCH c_get_safety_phrase_code INTO safetycode;
324: IF c_get_safety_phrase_code%NOTFOUND THEN
325: x_return_status := 'E';

Line 532: -- GR_SAFETY_PHRASES_B.If it does, write an error to the log file

528: END IF; -- IF p_object = 'C' then
529: END IF; -- IF p_phrase_type = 'S' THEN
530: ELSIF p_action = 'U' then
531: -- Validate that the value of Safety phrase code does not already exist in the table
532: -- GR_SAFETY_PHRASES_B.If it does, write an error to the log file
533: IF p_phrase_type = 'S' THEN
534: OPEN c_get_safety_phrase_code;
535: FETCH c_get_safety_phrase_code INTO safetycode;
536: IF c_get_safety_phrase_code%NOTFOUND THEN

Line 544: UPDATE GR_SAFETY_PHRASES_B

540: RAISE LT_Exists_Error;
541: END IF;
542: CLOSE c_get_safety_phrase_code;
543: IF p_object = 'C' THEN
544: UPDATE GR_SAFETY_PHRASES_B
545: SET attribute_category = p_attribute_category ,
546: attribute1 = p_attribute1 ,
547: attribute2 = p_attribute2 ,
548: attribute3 = p_attribute3 ,

Line 739: DELETE FROM gr_safety_phrases_b

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;
741: IF SQL%NOTFOUND THEN
742: l_msg_token := p_phrase_code || ' ' || p_language;
743: RAISE Row_Missing_Error;