APPS.GR_HAZARD_GROUPS_PKG dependencies on GR_HAZARD_GROUPS

Line 1: PACKAGE BODY GR_HAZARD_GROUPS_PKG AS

1: PACKAGE BODY GR_HAZARD_GROUPS_PKG AS
2: /*$Header: GRHIHGB.pls 115.6 2002/10/25 19:51:34 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 71: INSERT INTO gr_hazard_groups

67: IF FND_API.To_Boolean(l_key_exists) THEN
68: RAISE Item_Exists_Error;
69: END IF;
70:
71: INSERT INTO gr_hazard_groups
72: (hazard_group_code,
73: hazard_group_description,
74: created_by,
75: creation_date,

Line 224: UPDATE gr_hazard_groups

220:
221: IF l_return_status <> 'S' THEN
222: RAISE Foreign_Key_Error;
223: ELSE
224: UPDATE gr_hazard_groups
225: SET hazard_group_code = p_hazard_group_code,
226: hazard_group_description = p_hazard_group_description,
227: created_by = p_created_by,
228: creation_date = p_creation_date,

Line 330: FROM gr_hazard_groups

326:
327: CURSOR c_lock_hazard_groups
328: IS
329: SELECT *
330: FROM gr_hazard_groups
331: WHERE rowid = p_rowid
332: FOR UPDATE NOWAIT;
333: LockHazGrpRcd c_lock_hazard_groups%ROWTYPE;
334: BEGIN

Line 458: DELETE FROM gr_hazard_groups

454: IF l_return_status <> 'S' THEN
455: RAISE Check_Integrity_Error;
456: END IF;
457:
458: DELETE FROM gr_hazard_groups
459: WHERE rowid = p_rowid;
460:
461: /* Check the commit flag and if set, then commit the work. */
462:

Line 682: FROM gr_hazard_groups hg

678:
679: CURSOR c_get_hazard_group_rowid
680: IS
681: SELECT hg.rowid
682: FROM gr_hazard_groups hg
683: WHERE hg.hazard_group_code = p_hazard_group_code;
684: HazGrpRecord c_get_hazard_group_rowid%ROWTYPE;
685:
686: BEGIN

Line 714: END GR_HAZARD_GROUPS_PKG;

710: END IF;
711:
712: END Check_Primary_Key;
713:
714: END GR_HAZARD_GROUPS_PKG;