APPS.GR_PHRASE_GROUP_CODES_PKG dependencies on GR_PHRASE_GROUP_CODES

Line 1: PACKAGE BODY GR_PHRASE_GROUP_CODES_PKG AS

1: PACKAGE BODY GR_PHRASE_GROUP_CODES_PKG AS
2: /*$Header: GRHIPGCB.pls 115.7 2002/10/28 20:19:31 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 71: INSERT INTO gr_phrase_group_codes

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

Line 224: UPDATE gr_phrase_group_codes

220:
221: IF l_return_status <> 'S' THEN
222: RAISE Foreign_Key_Error;
223: ELSE
224: UPDATE gr_phrase_group_codes
225: SET phrase_group_code = p_phrase_group_code,
226: phrase_group_description = p_phrase_group_description,
227: created_by = p_created_by,
228: creation_date = p_creation_date,

Line 330: FROM gr_phrase_group_codes

326:
327: CURSOR c_lock_phrase_group_codes
328: IS
329: SELECT last_update_date
330: FROM gr_phrase_group_codes
331: WHERE rowid = p_rowid
332: FOR UPDATE NOWAIT;
333: LockGroupRcd c_lock_phrase_group_codes%ROWTYPE;
334: BEGIN

Line 469: DELETE FROM gr_phrase_group_codes

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

Line 732: FROM gr_phrase_group_codes pgc

728:
729: CURSOR c_get_phrase_group_rowid
730: IS
731: SELECT pgc.rowid
732: FROM gr_phrase_group_codes pgc
733: WHERE pgc.phrase_group_code = p_phrase_group_code;
734: GroupRecord c_get_phrase_group_rowid%ROWTYPE;
735:
736: BEGIN

Line 764: END GR_PHRASE_GROUP_CODES_PKG;

760: END IF;
761:
762: END Check_Primary_Key;
763:
764: END GR_PHRASE_GROUP_CODES_PKG;