APPS.GR_RISK_SAFETY_PHRASES_PUB dependencies on GR_RISK_PHRASES_B

Line 149: FROM gr_risk_phrases_b

145: AND language = p_language;
146:
147: CURSOR c_get_risk_phrase_code IS
148: SELECT risk_phrase_code
149: FROM gr_risk_phrases_b
150: WHERE risk_phrase_code = p_phrase_code;
151: riskcode c_get_risk_phrase_code%ROWTYPE;
152:
153: CURSOR c_get_risk_phrase_tl IS

Line 371: -- GR_RISK_PHRASES_B.If it does, write an error to the log file

367:
368: ELSIF p_phrase_type = 'R' THEN
369: IF p_object = 'C' then
370: -- Validate that the value of Risk phrase code does not already exist in the table
371: -- GR_RISK_PHRASES_B.If it does, write an error to the log file
372: OPEN c_get_risk_phrase_code;
373: FETCH c_get_risk_phrase_code INTO riskcode;
374: IF c_get_risk_phrase_code%NOTFOUND THEN
375: null;

Line 384: -- insert a record for GR_RISK_PHRASES_B

380: RAISE LT_Exists_Error;
381: END IF;
382: CLOSE c_get_risk_phrase_code;
383:
384: -- insert a record for GR_RISK_PHRASES_B
385: gr_risk_phrases_b_pkg.Insert_Row
386: (p_commit => 'T',
387: p_called_by_form => 'F',
388: p_risk_phrase_code => p_phrase_code,

Line 385: gr_risk_phrases_b_pkg.Insert_Row

381: END IF;
382: CLOSE c_get_risk_phrase_code;
383:
384: -- insert a record for GR_RISK_PHRASES_B
385: gr_risk_phrases_b_pkg.Insert_Row
386: (p_commit => 'T',
387: p_called_by_form => 'F',
388: p_risk_phrase_code => p_phrase_code,
389: p_additional_text_indicator => 'N',

Line 483: -- GR_RISK_PHRASES_B.If it does, write an error to the log file

479: END IF; -- IF l_missing_count > 0 THEN
480:
481: ELSIF p_object = 'L' then
482: -- Validate that the value of Safety phrase code does not already exist in the table
483: -- GR_RISK_PHRASES_B.If it does, write an error to the log file
484: OPEN c_get_risk_phrase_code;
485: FETCH c_get_risk_phrase_code INTO safetycode;
486: IF c_get_risk_phrase_code%NOTFOUND THEN
487: x_return_status := 'E';

Line 639: UPDATE GR_RISK_PHRASES_B

635: RAISE LT_Exists_Error;
636: END IF;
637: CLOSE c_get_risk_phrase_code;
638: IF p_object = 'C' THEN
639: UPDATE GR_RISK_PHRASES_B
640: SET attribute_category = p_attribute_category ,
641: attribute1 = p_attribute1 ,
642: attribute2 = p_attribute2 ,
643: attribute3 = p_attribute3 ,

Line 799: DELETE FROM gr_risk_phrases_b

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;
801: IF SQL%NOTFOUND THEN
802: l_msg_token := p_phrase_code || ' ' || p_language;
803: RAISE Row_Missing_Error;