APPS.GR_PHRASE_TYPES_PKG dependencies on GR_PHRASE_TYPES

Line 1: PACKAGE BODY GR_PHRASE_TYPES_PKG AS

1: PACKAGE BODY GR_PHRASE_TYPES_PKG AS
2: /*$Header: GRHIPTB.pls 115.5 2002/10/28 20:23:01 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 71: INSERT INTO gr_phrase_types

67: IF FND_API.To_Boolean(l_key_exists) THEN
68: RAISE Item_Exists_Error;
69: END IF;
70:
71: INSERT INTO gr_phrase_types
72: (phrase_type_code,
73: phrase_type_description,
74: created_by,
75: creation_date,

Line 224: UPDATE gr_phrase_types

220:
221: IF l_return_status <> 'S' THEN
222: RAISE Foreign_Key_Error;
223: ELSE
224: UPDATE gr_phrase_types
225: SET phrase_type_code = p_phrase_type_code,
226: phrase_type_description = p_phrase_type_description,
227: created_by = p_created_by,
228: creation_date = p_creation_date,

Line 330: FROM gr_phrase_types

326:
327: CURSOR c_lock_phrase_types
328: IS
329: SELECT *
330: FROM gr_phrase_types
331: WHERE rowid = p_rowid
332: FOR UPDATE NOWAIT;
333: LockTypeRcd c_lock_phrase_types%ROWTYPE;
334: BEGIN

Line 459: DELETE FROM gr_phrase_types

455: IF l_return_status <> 'S' THEN
456: RAISE Check_Integrity_Error;
457: END IF;
458:
459: DELETE FROM gr_phrase_types
460: WHERE rowid = p_rowid;
461:
462: /* Check the commit flag and if set, then commit the work. */
463:

Line 682: FROM gr_phrase_types rc

678:
679: CURSOR c_get_phrase_type_rowid
680: IS
681: SELECT rc.rowid
682: FROM gr_phrase_types rc
683: WHERE rc.phrase_type_code = p_phrase_type_code;
684: TypeRecord c_get_phrase_type_rowid%ROWTYPE;
685:
686: BEGIN

Line 714: END GR_PHRASE_TYPES_PKG;

710: END IF;
711:
712: END Check_Primary_Key;
713:
714: END GR_PHRASE_TYPES_PKG;