APPS.GR_SAFETY_CATEGORIES_B_PKG dependencies on GR_SAFETY_CATEGORIES_B

Line 1: PACKAGE BODY GR_SAFETY_CATEGORIES_B_PKG AS

1: PACKAGE BODY GR_SAFETY_CATEGORIES_B_PKG AS
2: /*$Header: GRHICABB.pls 115.2 2002/10/28 16:50:51 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 69: INSERT INTO gr_safety_categories_b

65: IF FND_API.To_Boolean(l_key_exists) THEN
66: RAISE Item_Exists_Error;
67: END IF;
68:
69: INSERT INTO gr_safety_categories_b
70: (safety_category_code,
71: last_updated_by,
72: last_update_login,
73: last_update_date,

Line 223: UPDATE gr_safety_categories_b

219:
220: IF l_return_status <> 'S' THEN
221: RAISE Foreign_Key_Error;
222: ELSE
223: UPDATE gr_safety_categories_b
224: SET safety_category_code = p_safety_category_code,
225: last_updated_by = p_last_updated_by,
226: last_update_login = p_last_update_login,
227: last_update_date = p_last_update_date,

Line 332: FROM gr_safety_categories_b

328:
329: CURSOR c_lock_safety_cat_b
330: IS
331: SELECT *
332: FROM gr_safety_categories_b
333: WHERE rowid = p_rowid
334: FOR UPDATE NOWAIT;
335: LockCategoryRcd c_lock_safety_cat_b%ROWTYPE;
336:

Line 465: DELETE FROM gr_safety_categories_b

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

Line 719: FROM gr_safety_categories_b scb

715:
716: CURSOR c_get_category_b_rowid
717: IS
718: SELECT scb.rowid
719: FROM gr_safety_categories_b scb
720: WHERE scb.safety_category_code = p_safety_category_code;
721: CategoryBRecord c_get_category_b_rowid%ROWTYPE;
722:
723: BEGIN

Line 753: END GR_SAFETY_CATEGORIES_B_PKG;

749: END IF;
750:
751: END Check_Primary_Key;
752:
753: END GR_SAFETY_CATEGORIES_B_PKG;