APPS.GR_PHRASE_GROUP_ASSOC_PKG dependencies on GR_PHRASE_GROUP_ASSOC

Line 1: PACKAGE BODY GR_PHRASE_GROUP_ASSOC_PKG AS

1: PACKAGE BODY GR_PHRASE_GROUP_ASSOC_PKG AS
2: /*$Header: GRHIPGAB.pls 115.5 2002/10/28 20:16:14 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_phrase_group_assoc

72: IF FND_API.To_Boolean(l_key_exists) THEN
73: RAISE Item_Exists_Error;
74: END IF;
75:
76: INSERT INTO gr_phrase_group_assoc
77: (phrase_group_code,
78: phrase_code,
79: language_code,
80: sequence_number,

Line 238: UPDATE gr_phrase_group_assoc

234:
235: IF l_return_status <> 'S' THEN
236: RAISE Foreign_Key_Error;
237: ELSE
238: UPDATE gr_phrase_group_assoc
239: SET phrase_group_code = p_phrase_group_code,
240: phrase_code = p_phrase_code,
241: language_code = p_language_code,
242: sequence_number = p_sequence_number,

Line 347: FROM gr_phrase_group_assoc

343:
344: CURSOR c_lock_phrase_group_assoc
345: IS
346: SELECT last_update_date
347: FROM gr_phrase_group_assoc
348: WHERE rowid = p_rowid
349: FOR UPDATE NOWAIT;
350: LockGroupRcd c_lock_phrase_group_assoc%ROWTYPE;
351: BEGIN

Line 493: DELETE FROM gr_phrase_group_assoc

489: IF l_return_status <> 'S' THEN
490: RAISE Check_Integrity_Error;
491: END IF;
492:
493: DELETE FROM gr_phrase_group_assoc
494: WHERE rowid = p_rowid;
495:
496: /* Check the commit flag and if set, then commit the work. */
497:

Line 579: DELETE FROM gr_phrase_group_assoc

575: x_oracle_error := 0;
576: x_msg_data := NULL;
577: l_msg_token := p_phrase_group_code;
578:
579: DELETE FROM gr_phrase_group_assoc
580: WHERE phrase_group_code = p_phrase_group_code;
581:
582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;

Line 797: FROM gr_phrase_group_assoc pga

793:
794: CURSOR c_get_group_assoc_rowid
795: IS
796: SELECT pga.rowid
797: FROM gr_phrase_group_assoc pga
798: WHERE pga.phrase_group_code = p_phrase_group_code
799: AND pga.phrase_code = p_phrase_code;
800: AssocRecord c_get_group_assoc_rowid%ROWTYPE;
801:

Line 830: END GR_PHRASE_GROUP_ASSOC_PKG;

826: END IF;
827:
828: END Check_Primary_Key;
829:
830: END GR_PHRASE_GROUP_ASSOC_PKG;