APPS.GR_EXPOSURE_AUTHS_B_PKG dependencies on GR_EXPOSURE_AUTHS_B

Line 1: PACKAGE BODY GR_EXPOSURE_AUTHS_B_PKG AS

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

Line 70: INSERT INTO gr_exposure_auths_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_auths_b
71: (exposure_authority_code,
72: created_by,
73: creation_date,
74: last_updated_by,

Line 220: UPDATE gr_exposure_auths_b

216:
217: IF l_return_status <> 'S' THEN
218: RAISE Foreign_Key_Error;
219: ELSE
220: UPDATE gr_exposure_auths_b
221: SET exposure_authority_code = p_exposure_authority_code,
222: created_by = p_created_by,
223: creation_date = p_creation_date,
224: last_updated_by = p_last_updated_by,

Line 325: FROM gr_exposure_auths_b

321:
322: CURSOR c_lock_exposure_auth
323: IS
324: SELECT last_update_date
325: FROM gr_exposure_auths_b
326: WHERE rowid = p_rowid
327: FOR UPDATE NOWAIT;
328: LockExposureRcd c_lock_exposure_auth%ROWTYPE;
329: BEGIN

Line 459: DELETE FROM gr_exposure_auths_b

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

Line 660: FROM gr_exposure_auths_b ea

656:
657: CURSOR c_get_expo_auth_rowid
658: IS
659: SELECT ea.rowid
660: FROM gr_exposure_auths_b ea
661: WHERE ea.exposure_authority_code = p_exposure_authority_code;
662: ExposureAuthRecord c_get_expo_auth_rowid%ROWTYPE;
663:
664: BEGIN

Line 692: END GR_EXPOSURE_AUTHS_B_PKG;

688: END IF;
689:
690: END Check_Primary_Key;
691:
692: END GR_EXPOSURE_AUTHS_B_PKG;