APPS.GR_EIN_SAFETY_PKG dependencies on GR_EIN_SAFETY

Line 1: PACKAGE BODY GR_EIN_SAFETY_PKG AS

1: PACKAGE BODY GR_EIN_SAFETY_PKG AS
2: /*$Header: GRHIEISB.pls 115.3 2002/10/29 16:49:00 mgrosser noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_ein_safety

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

Line 228: UPDATE gr_ein_safety

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

Line 335: FROM gr_ein_safety

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

Line 466: DELETE FROM gr_ein_safety

462: IF l_return_status <> 'S' THEN
463: RAISE Check_Integrity_Error;
464: END IF;
465:
466: DELETE FROM gr_ein_safety
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_safety

547: x_oracle_error := 0;
548: x_msg_data := NULL;
549: l_msg_token := p_european_index_number;
550:
551: DELETE FROM gr_ein_safety
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_safety eis

734:
735: CURSOR c_get_eis_rowid
736: IS
737: SELECT eis.rowid
738: FROM gr_ein_safety eis
739: WHERE eis.european_index_number = p_european_index_number
740: AND eis.safety_phrase_code = p_safety_phrase_code;
741: EisRecord c_get_eis_rowid%ROWTYPE;
742:

Line 771: END GR_EIN_SAFETY_PKG;

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