APPS.GR_TOXIC_EFFECT_B_PKG dependencies on GR_TOXIC_EFFECTS_B

Line 70: INSERT INTO gr_toxic_effects_b

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

Line 218: UPDATE gr_toxic_effects_b

214:
215: IF l_return_status <> 'S' THEN
216: RAISE Foreign_Key_Error;
217: ELSE
218: UPDATE gr_toxic_effects_b
219: SET toxic_effect_code = p_toxic_effect_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_toxic_effects_b

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

Line 458: DELETE FROM gr_toxic_effects_b

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

Line 663: FROM gr_toxic_effects_b te

659:
660: CURSOR c_get_toxic_effect_rowid
661: IS
662: SELECT te.rowid
663: FROM gr_toxic_effects_b te
664: WHERE te.toxic_effect_code = p_toxic_effect_code;
665: ToxicEffectRecord c_get_toxic_effect_rowid%ROWTYPE;
666:
667: BEGIN