APPS.GR_EXPOSURE_TYPES_B_PKG dependencies on GR_EXPOSURE_TYPES_B

Line 1: PACKAGE BODY GR_EXPOSURE_TYPES_B_PKG AS

1: PACKAGE BODY GR_EXPOSURE_TYPES_B_PKG AS
2: /*$Header: GRHIETB.pls 115.8 2002/10/29 20:46:41 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 70: INSERT INTO gr_exposure_types_b

66: IF FND_API.To_Boolean(l_key_exists) THEN
67: RAISE Item_Exists_Error;
68: END IF;
69:
70: INSERT INTO gr_exposure_types_b
71: (exposure_type_code,
72: created_by,
73: creation_date,
74: last_updated_by,

Line 218: UPDATE gr_exposure_types_b

214:
215: IF l_return_status <> 'S' THEN
216: RAISE Foreign_Key_Error;
217: ELSE
218: UPDATE gr_exposure_types_b
219: SET exposure_type_code = p_exposure_type_code,
220: created_by = p_created_by,
221: creation_date = p_creation_date,
222: last_updated_by = p_last_updated_by,

Line 322: FROM gr_exposure_types_b

318:
319: CURSOR c_lock_exposure_type
320: IS
321: SELECT last_update_date
322: FROM gr_exposure_types_b
323: WHERE rowid = p_rowid
324: FOR UPDATE NOWAIT;
325: LockExposureRcd c_lock_exposure_type%ROWTYPE;
326: BEGIN

Line 458: DELETE FROM gr_exposure_types_b

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

Line 662: FROM gr_exposure_types_b et

658:
659: CURSOR c_get_expo_type_rowid
660: IS
661: SELECT et.rowid
662: FROM gr_exposure_types_b et
663: WHERE et.exposure_type_code = p_exposure_type_code;
664: ExposureTypeRecord c_get_expo_type_rowid%ROWTYPE;
665:
666: BEGIN

Line 694: END GR_EXPOSURE_TYPES_B_PKG;

690: END IF;
691:
692: END Check_Primary_Key;
693:
694: END GR_EXPOSURE_TYPES_B_PKG;