APPS.GR_RISK_PHRASES_B_PKG dependencies on GR_RISK_PHRASES_B

Line 1: PACKAGE BODY GR_RISK_PHRASES_B_PKG AS

1: PACKAGE BODY GR_RISK_PHRASES_B_PKG AS
2: /*$Header: GRHIRPB.pls 115.5 2002/10/28 16:16:46 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 136: INSERT INTO gr_risk_phrases_b

132: IF FND_API.To_Boolean(l_key_exists) THEN
133: RAISE Item_Exists_Error;
134: END IF;
135:
136: INSERT INTO gr_risk_phrases_b
137: (risk_phrase_code,
138: additional_text_indicator,
139: lookup_type,
140: lookup_code,

Line 420: UPDATE gr_risk_phrases_b

416:
417: IF l_return_status <> 'S' THEN
418: RAISE Foreign_Key_Error;
419: ELSE
420: UPDATE gr_risk_phrases_b
421: SET risk_phrase_code = p_risk_phrase_code,
422: additional_text_indicator = p_additional_text_indicator,
423: lookup_type = p_lookup_type,
424: lookup_code = p_lookup_code,

Line 591: FROM gr_risk_phrases_b

587:
588: CURSOR c_lock_risk
589: IS
590: SELECT last_update_date
591: FROM gr_risk_phrases_b
592: WHERE rowid = p_rowid
593: FOR UPDATE NOWAIT;
594: LockSafetyRcd c_lock_risk%ROWTYPE;
595: BEGIN

Line 798: DELETE FROM gr_risk_phrases_b

794: IF l_return_status <> 'S' THEN
795: RAISE Check_Integrity_Error;
796: END IF;
797:
798: DELETE FROM gr_risk_phrases_b
799: WHERE rowid = p_rowid;
800:
801: /* Check the commit flag and if set, then commit the work. */
802:

Line 1262: FROM gr_risk_phrases_b sp

1258:
1259: CURSOR c_get_risk_rowid
1260: IS
1261: SELECT sp.rowid
1262: FROM gr_risk_phrases_b sp
1263: WHERE sp.risk_phrase_code = p_risk_phrase_code;
1264: RiskRecord c_get_risk_rowid%ROWTYPE;
1265:
1266: BEGIN

Line 1294: END GR_RISK_PHRASES_B_PKG;

1290: END IF;
1291:
1292: END Check_Primary_Key;
1293:
1294: END GR_RISK_PHRASES_B_PKG;