APPS.GR_ITEM_GENERAL_PKG dependencies on GR_ITEM_GENERAL

Line 1: PACKAGE BODY GR_ITEM_GENERAL_PKG AS

1: PACKAGE BODY GR_ITEM_GENERAL_PKG AS
2: /*$Header: GRHIIG1B.pls 115.7 2002/10/25 20:48:23 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 157: INSERT INTO gr_item_general

153: IF FND_API.To_Boolean(l_key_exists) THEN
154: RAISE Item_Exists_Error;
155: END IF;
156:
157: INSERT INTO gr_item_general
158: (item_code,
159: item_group_code,
160: primary_cas_number,
161: ingredient_flag,

Line 481: UPDATE gr_item_general

477:
478: IF l_return_status <> 'S' THEN
479: RAISE Foreign_Key_Error;
480: ELSE
481: UPDATE gr_item_general
482: SET item_code = p_item_code,
483: item_group_code = p_item_group_code,
484: primary_cas_number = p_primary_cas_number,
485: ingredient_flag = p_ingredient_flag,

Line 673: FROM gr_item_general

669:
670: CURSOR c_lock_item
671: IS
672: SELECT *
673: FROM gr_item_general
674: WHERE rowid = p_rowid
675: FOR UPDATE NOWAIT;
676: LockItemRcd c_lock_item%ROWTYPE;
677: BEGIN

Line 888: DELETE FROM gr_item_general

884: IF l_return_status <> 'S' THEN
885: RAISE Check_Integrity_Error;
886: END IF;
887:
888: DELETE FROM gr_item_general
889: WHERE rowid = p_rowid;
890:
891: /* Check the commit flag and if set, then commit the work. */
892:

Line 1622: FROM gr_item_general ig

1618:
1619: CURSOR c_get_item_rowid
1620: IS
1621: SELECT ig.rowid
1622: FROM gr_item_general ig
1623: WHERE ig.item_code = p_item_code;
1624: ItemRecord c_get_item_rowid%ROWTYPE;
1625:
1626: BEGIN

Line 1656: END GR_ITEM_GENERAL_PKG;

1652: END IF;
1653:
1654: END Check_Primary_Key;
1655:
1656: END GR_ITEM_GENERAL_PKG;