APPS.GR_ITEM_RISK_PHRASES_PKG dependencies on GR_ITEM_RISK_PHRASES

Line 1: PACKAGE BODY GR_ITEM_RISK_PHRASES_PKG AS

1: PACKAGE BODY GR_ITEM_RISK_PHRASES_PKG AS
2: /*$Header: GRHIIRPB.pls 115.5 2002/10/25 21:07:35 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 85: INSERT INTO gr_item_risk_phrases

81: IF FND_API.To_Boolean(l_key_exists) THEN
82: RAISE Item_Exists_Error;
83: END IF;
84:
85: INSERT INTO gr_item_risk_phrases
86: (item_code,
87: risk_phrase_code,
88: temperature,
89: temperature_scale,

Line 257: UPDATE gr_item_risk_phrases

253:
254: IF l_return_status <> 'S' THEN
255: RAISE Foreign_Key_Error;
256: ELSE
257: UPDATE gr_item_risk_phrases
258: SET item_code = p_item_code,
259: risk_phrase_code = p_risk_phrase_code,
260: temperature = p_temperature,
261: temperature_scale = p_temperature_scale,

Line 370: FROM gr_item_risk_phrases

366:
367: CURSOR c_lock_item_risks
368: IS
369: SELECT *
370: FROM gr_item_risk_phrases
371: WHERE rowid = p_rowid
372: FOR UPDATE NOWAIT;
373: LockRiskRcd c_lock_item_risks%ROWTYPE;
374: BEGIN

Line 512: DELETE FROM gr_item_risk_phrases

508: IF l_return_status <> 'S' THEN
509: RAISE Check_Integrity_Error;
510: END IF;
511:
512: DELETE FROM gr_item_risk_phrases
513: WHERE rowid = p_rowid;
514:
515: /* Check the commit flag and if set, then commit the work. */
516:

Line 614: DELETE FROM gr_item_risk_phrases

610: RAISE Null_Delete_Option_Error;
611: ELSE
612: l_msg_token := p_item_code;
613:
614: DELETE FROM gr_item_risk_phrases
615: WHERE item_code = p_item_code;
616: END IF;
617: ELSIF p_delete_option = 'R' THEN
618: IF p_risk_phrase_code IS NULL THEN

Line 624: DELETE FROM gr_item_risk_phrases

620: RAISE Null_Delete_Option_Error;
621: ELSE
622: l_msg_token := p_risk_phrase_code;
623:
624: DELETE FROM gr_item_risk_phrases
625: WHERE risk_phrase_code = p_risk_phrase_code;
626: END IF;
627: END IF;
628:

Line 860: FROM gr_item_risk_phrases irp

856:
857: CURSOR c_get_risk_phrase_rowid
858: IS
859: SELECT irp.rowid
860: FROM gr_item_risk_phrases irp
861: WHERE irp.item_code = p_item_code
862: AND irp.risk_phrase_code = p_risk_phrase_code;
863: ItemRiskRecord c_get_risk_phrase_rowid%ROWTYPE;
864:

Line 895: END GR_ITEM_RISK_PHRASES_PKG;

891: END IF;
892:
893: END Check_Primary_Key;
894:
895: END GR_ITEM_RISK_PHRASES_PKG;