APPS.GR_TOXIC_ROUTES_B_PKG dependencies on GR_TOXIC_ROUTES_B

Line 1: PACKAGE BODY GR_TOXIC_ROUTES_B_PKG AS

1: PACKAGE BODY GR_TOXIC_ROUTES_B_PKG AS
2: /*$Header: GRHITRB.pls 115.7 2002/10/28 21:31:15 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 70: INSERT INTO gr_toxic_routes_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_routes_b
71: (toxic_route_code,
72: created_by,
73: creation_date,
74: last_updated_by,

Line 219: UPDATE gr_toxic_routes_b

215:
216: IF l_return_status <> 'S' THEN
217: RAISE Foreign_Key_Error;
218: ELSE
219: UPDATE gr_toxic_routes_b
220: SET toxic_route_code = p_toxic_route_code,
221: created_by = p_created_by,
222: creation_date = p_creation_date,
223: last_updated_by = p_last_updated_by,

Line 323: FROM gr_toxic_routes_b

319:
320: CURSOR c_lock_toxic_routes
321: IS
322: SELECT last_update_date
323: FROM gr_toxic_routes_b
324: WHERE rowid = p_rowid
325: FOR UPDATE NOWAIT;
326: LockRouteRcd c_lock_toxic_routes%ROWTYPE;
327: BEGIN

Line 458: DELETE FROM gr_toxic_routes_b

454: IF l_return_status <> 'S' THEN
455: RAISE Check_Integrity_Error;
456: END IF;
457:
458: DELETE FROM gr_toxic_routes_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_routes_b tr

659:
660: CURSOR c_get_toxic_route_rowid
661: IS
662: SELECT tr.rowid
663: FROM gr_toxic_routes_b tr
664: WHERE tr.toxic_route_code = p_toxic_route_code;
665: ToxicRouteRecord c_get_toxic_route_rowid%ROWTYPE;
666:
667: BEGIN

Line 695: END GR_TOXIC_ROUTES_B_PKG;

691: END IF;
692:
693: END Check_Primary_Key;
694:
695: END GR_TOXIC_ROUTES_B_PKG;