APPS.GR_EUROHAZARDS_B_PKG dependencies on GR_EUROHAZARDS_B

Line 1: PACKAGE BODY GR_EUROHAZARDS_B_PKG AS

1: PACKAGE BODY GR_EUROHAZARDS_B_PKG AS
2: /*$Header: GRHIEHB.pls 115.6 2002/10/30 20:01:09 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_eurohazards_b

69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Item_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_eurohazards_b
74: (hazard_classification_code,
75: hazard_group_code,
76: calculation_hierarchy,
77: created_by,

Line 230: UPDATE gr_eurohazards_b

226:
227: IF l_return_status <> 'S' THEN
228: RAISE Foreign_Key_Error;
229: ELSE
230: UPDATE gr_eurohazards_b
231: SET hazard_classification_code = p_hazard_classification_code,
232: hazard_group_code = p_hazard_group_code,
233: calculation_hierarchy = p_calculation_hierarchy,
234: created_by = p_created_by,

Line 337: FROM gr_eurohazards_b

333:
334: CURSOR c_lock_eurohazards
335: IS
336: SELECT last_update_date
337: FROM gr_eurohazards_b
338: WHERE rowid = p_rowid
339: FOR UPDATE NOWAIT;
340: LockHazardRcd c_lock_eurohazards%ROWTYPE;
341: BEGIN

Line 481: DELETE FROM gr_eurohazards_b

477: IF l_return_status <> 'S' THEN
478: RAISE Check_Integrity_Error;
479: END IF;
480:
481: DELETE FROM gr_eurohazards_b
482: WHERE rowid = p_rowid;
483:
484: /* Check the commit flag and if set, then commit the work. */
485:

Line 755: FROM gr_eurohazards_b eh

751:
752: CURSOR c_get_hazard_classn_rowid
753: IS
754: SELECT eh.rowid
755: FROM gr_eurohazards_b eh
756: WHERE eh.hazard_classification_code = p_hazard_classification_code;
757: HazardRecord c_get_hazard_classn_rowid%ROWTYPE;
758:
759: BEGIN

Line 787: END GR_EUROHAZARDS_B_PKG;

783: END IF;
784:
785: END Check_Primary_Key;
786:
787: END GR_EUROHAZARDS_B_PKG;