APPS.GR_PROPERTIES_B_PKG dependencies on GR_PROPERTIES_B

Line 1: PACKAGE BODY GR_PROPERTIES_B_PKG AS

1: PACKAGE BODY GR_PROPERTIES_B_PKG AS
2: /*$Header: GRHIPROB.pls 115.5 2002/10/25 14:34:59 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 78: INSERT INTO gr_properties_b

74: IF FND_API.To_Boolean(l_key_exists) THEN
75: RAISE Item_Exists_Error;
76: END IF;
77:
78: INSERT INTO gr_properties_b
79: (property_id,
80: property_type_indicator,
81: length,
82: precision,

Line 247: UPDATE gr_properties_b

243:
244: IF l_return_status <> 'S' THEN
245: RAISE Foreign_Key_Error;
246: ELSE
247: UPDATE gr_properties_b
248: SET property_id = p_property_id,
249: property_type_indicator = p_property_type_indicator,
250: length = p_length,
251: precision = p_precision,

Line 361: FROM gr_properties_b

357:
358: CURSOR c_lock_properties
359: IS
360: SELECT *
361: FROM gr_properties_b
362: WHERE rowid = p_rowid
363: FOR UPDATE NOWAIT;
364: LockPropRcd c_lock_properties%ROWTYPE;
365: BEGIN

Line 498: DELETE FROM gr_properties_b

494: IF l_return_status <> 'S' THEN
495: RAISE Check_Integrity_Error;
496: END IF;
497:
498: DELETE FROM gr_properties_b
499: WHERE rowid = p_rowid;
500:
501: /* Check the commit flag and if set, then commit the work. */
502:

Line 739: FROM gr_properties_b pro

735:
736: CURSOR c_get_property_rowid
737: IS
738: SELECT pro.rowid
739: FROM gr_properties_b pro
740: WHERE pro.property_id = p_property_id;
741: PropertyRecord c_get_property_rowid%ROWTYPE;
742:
743: BEGIN

Line 771: END GR_PROPERTIES_B_PKG;

767: END IF;
768:
769: END Check_Primary_Key;
770:
771: END GR_PROPERTIES_B_PKG;