APPS.GR_ITEM_GROUPS_B_PKG dependencies on GR_ITEM_GROUPS_B

Line 1: PACKAGE BODY GR_ITEM_GROUPS_B_PKG AS

1: PACKAGE BODY GR_ITEM_GROUPS_B_PKG AS
2: /*$Header: GRHIIGB.pls 115.6 2002/10/25 20:52:37 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 74: INSERT INTO gr_item_groups_b

70: IF FND_API.To_Boolean(l_key_exists) THEN
71: RAISE Item_Exists_Error;
72: END IF;
73:
74: INSERT INTO gr_item_groups_b
75: (item_group_code,
76: consolidate_toxicity_data,
77: consolidate_exposure_data,
78: created_by,

Line 230: UPDATE gr_item_groups_b

226:
227: IF l_return_status <> 'S' THEN
228: RAISE Foreign_Key_Error;
229: ELSE
230: UPDATE gr_item_groups_b
231: SET item_group_code = p_item_group_code,
232: consolidate_toxicity_data = p_consolidate_toxicity_data,
233: consolidate_exposure_data = p_consolidate_exposure_data,
234: created_by = p_created_by,

Line 339: FROM gr_item_groups_b

335:
336: CURSOR c_lock_item_groups
337: IS
338: SELECT *
339: FROM gr_item_groups_b
340: WHERE rowid = p_rowid
341: FOR UPDATE NOWAIT;
342: LockGroupRcd c_lock_item_groups%ROWTYPE;
343:

Line 468: DELETE FROM gr_item_groups_b

464: IF l_return_status <> 'S' THEN
465: RAISE Check_Integrity_Error;
466: END IF;
467:
468: DELETE FROM gr_item_groups_b
469: WHERE rowid = p_rowid;
470:
471: /* Check the commit flag and if set, then commit the work. */
472:

Line 669: FROM gr_item_groups_b ig

665:
666: CURSOR c_get_item_group_rowid
667: IS
668: SELECT ig.rowid
669: FROM gr_item_groups_b ig
670: WHERE ig.item_group_code = p_item_group_code;
671: ItemGroupRecord c_get_item_group_rowid%ROWTYPE;
672:
673: BEGIN

Line 701: END GR_ITEM_GROUPS_B_PKG;

697: END IF;
698:
699: END Check_Primary_Key;
700:
701: END GR_ITEM_GROUPS_B_PKG;