APPS.GR_EIN_HAZARDS_PKG dependencies on GR_EIN_HAZARDS

Line 1: PACKAGE BODY GR_EIN_HAZARDS_PKG AS

1: PACKAGE BODY GR_EIN_HAZARDS_PKG AS
2: /*$Header: GRHIEIHB.pls 115.3 2002/10/29 16:39:46 mgrosser noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_ein_hazards

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

Line 228: UPDATE gr_ein_hazards

224:
225: IF l_return_status <> 'S' THEN
226: RAISE Foreign_Key_Error;
227: ELSE
228: UPDATE gr_ein_hazards
229: SET european_index_number = p_european_index_number,
230: hazard_classification_code = p_hazard_classification_code,
231: created_by = p_created_by,
232: creation_date = p_creation_date,

Line 335: FROM gr_ein_hazards

331:
332: CURSOR c_lock_ein_hazard
333: IS
334: SELECT last_update_date
335: FROM gr_ein_hazards
336: WHERE rowid = p_rowid
337: FOR UPDATE NOWAIT;
338: LockEinRcd c_lock_ein_hazard%ROWTYPE;
339: BEGIN

Line 466: DELETE FROM gr_ein_hazards

462: IF l_return_status <> 'S' THEN
463: RAISE Check_Integrity_Error;
464: END IF;
465:
466: DELETE FROM gr_ein_hazards
467: WHERE rowid = p_rowid;
468:
469: /* Check the commit flag and if set, then commit the work. */
470:

Line 551: DELETE FROM gr_ein_hazards

547: x_oracle_error := 0;
548: x_msg_data := NULL;
549: l_msg_token := p_european_index_number;
550:
551: DELETE FROM gr_ein_hazards
552: WHERE european_index_number = p_european_index_number;
553:
554: IF FND_API.To_Boolean(p_commit) THEN
555: COMMIT WORK;

Line 738: FROM gr_ein_hazards eih

734:
735: CURSOR c_get_eih_rowid
736: IS
737: SELECT eih.rowid
738: FROM gr_ein_hazards eih
739: WHERE eih.european_index_number = p_european_index_number
740: AND eih.hazard_classification_code = p_hazard_classification_code;
741: EihRecord c_get_eih_rowid%ROWTYPE;
742:

Line 771: END GR_EIN_HAZARDS_PKG;

767: END IF;
768:
769: END Check_Primary_Key;
770:
771: END GR_EIN_HAZARDS_PKG;