APPS.GR_TOXIC_SPECIES_B_PKG dependencies on GR_TOXIC_SPECIES_B

Line 1: PACKAGE BODY GR_TOXIC_SPECIES_B_PKG AS

1: PACKAGE BODY GR_TOXIC_SPECIES_B_PKG AS
2: /*$Header: GRHITSB.pls 115.9 2002/10/28 21:41:44 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_toxic_species_b

69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Item_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_toxic_species_b
74: (toxic_species_code,
75: /* Bug 1323951 M. Thomas 28-Jan-2002 Added the following for Toxicity Calculation */
76: hierarchy_seq,
77: /* Bug 1323951 M. Thomas 28-Jan-2002 End of the changes for Toxicity Calculation */

Line 231: UPDATE gr_toxic_species_b

227:
228: IF l_return_status <> 'S' THEN
229: RAISE Foreign_Key_Error;
230: ELSE
231: UPDATE gr_toxic_species_b
232: SET toxic_species_code = p_toxic_species_code,
233: /* Bug 1323951 M. Thomas 28-Jan-2002 Added the following for Toxicity Calculation */
234: hierarchy_seq = p_hierarchy_seq,
235: /* Bug 1323951 M. Thomas 28-Jan-2002 End of the changes for Toxicity Calculation */

Line 338: FROM gr_toxic_species_b

334:
335: CURSOR c_lock_toxic_species
336: IS
337: SELECT last_update_date
338: FROM gr_toxic_species_b
339: WHERE rowid = p_rowid
340: FOR UPDATE NOWAIT;
341: LockSpeciesRcd c_lock_toxic_species%ROWTYPE;
342:

Line 477: DELETE FROM gr_toxic_species_b

473: IF l_return_status <> 'S' THEN
474: RAISE Check_Integrity_Error;
475: END IF;
476:
477: DELETE FROM gr_toxic_species_b
478: WHERE rowid = p_rowid;
479:
480: /* Check the commit flag and if set, then commit the work. */
481:

Line 681: FROM gr_toxic_species_b ts

677:
678: CURSOR c_get_toxic_species_rowid
679: IS
680: SELECT ts.rowid
681: FROM gr_toxic_species_b ts
682: WHERE ts.toxic_species_code = p_toxic_species_code;
683: ToxicSpeciesRecord c_get_toxic_species_rowid%ROWTYPE;
684:
685: BEGIN

Line 713: END GR_TOXIC_SPECIES_B_PKG;

709: END IF;
710:
711: END Check_Primary_Key;
712:
713: END GR_TOXIC_SPECIES_B_PKG;