APPS.GR_SAFETY_PHRASES_B_PKG dependencies on GR_SAFETY_PHRASES_B

Line 1: PACKAGE BODY GR_SAFETY_PHRASES_B_PKG AS

1: PACKAGE BODY GR_SAFETY_PHRASES_B_PKG AS
2: /*$Header: GRHISPB.pls 115.7 2002/10/28 20:01:27 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 136: INSERT INTO gr_safety_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_safety_phrases_b
137: (safety_phrase_code,
138: additional_text_type,
139: lookup_type,
140: lookup_code,

Line 421: UPDATE gr_safety_phrases_b

417:
418: IF l_return_status <> 'S' THEN
419: RAISE Foreign_Key_Error;
420: ELSE
421: UPDATE gr_safety_phrases_b
422: SET safety_phrase_code = p_safety_phrase_code,
423: additional_text_type = p_additional_text_type,
424: lookup_type = p_lookup_type,
425: lookup_code = p_lookup_code,

Line 592: FROM gr_safety_phrases_b

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

Line 799: DELETE FROM gr_safety_phrases_b

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

Line 1095: FROM gr_safety_phrases_b sp

1091:
1092: CURSOR c_get_safety_rowid
1093: IS
1094: SELECT sp.rowid
1095: FROM gr_safety_phrases_b sp
1096: WHERE sp.safety_phrase_code = p_safety_phrase_code;
1097: SafetyRecord c_get_safety_rowid%ROWTYPE;
1098:
1099: BEGIN

Line 1127: END GR_SAFETY_PHRASES_B_PKG;

1123: END IF;
1124:
1125: END Check_Primary_Key;
1126:
1127: END GR_SAFETY_PHRASES_B_PKG;