APPS.GR_REGION_LANGUAGES_PKG dependencies on GR_REGION_LANGUAGES

Line 1: PACKAGE BODY GR_REGION_LANGUAGES_PKG AS

1: PACKAGE BODY GR_REGION_LANGUAGES_PKG AS
2: /*$Header: GRHIRGLB.pls 115.1 2002/10/25 17:26:46 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 72: INSERT INTO gr_region_languages

68: IF FND_API.To_Boolean(l_key_exists) THEN
69: RAISE Item_Exists_Error;
70: END IF;
71:
72: INSERT INTO gr_region_languages
73: (region_code,
74: language,
75: created_by,
76: creation_date,

Line 226: UPDATE gr_region_languages

222:
223: IF l_return_status <> 'S' THEN
224: RAISE Foreign_Key_Error;
225: ELSE
226: UPDATE gr_region_languages
227: SET region_code = p_region_code,
228: language = p_language,
229: created_by = p_created_by,
230: creation_date = p_creation_date,

Line 332: FROM gr_region_languages

328:
329: CURSOR c_lock_regions
330: IS
331: SELECT *
332: FROM gr_region_languages
333: WHERE rowid = p_rowid
334: FOR UPDATE NOWAIT;
335: LockRegionRcd c_lock_regions%ROWTYPE;
336: BEGIN

Line 461: DELETE FROM gr_region_languages

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

Line 547: DELETE FROM gr_region_languages

543: x_oracle_error := 0;
544: x_msg_data := NULL;
545: l_msg_token := p_region_code;
546:
547: DELETE FROM gr_region_languages
548: WHERE region_code = p_region_code;
549:
550: IF FND_API.To_Boolean(p_commit) THEN
551: COMMIT WORK;

Line 704: FROM gr_region_languages rc

700:
701: CURSOR c_get_region_rowid
702: IS
703: SELECT rc.rowid
704: FROM gr_region_languages rc
705: WHERE rc.region_code = p_region_code
706: AND rc.language = p_language;
707: RegionRecord c_get_region_rowid%ROWTYPE;
708:

Line 737: END GR_REGION_LANGUAGES_PKG;

733: END IF;
734:
735: END Check_Primary_Key;
736:
737: END GR_REGION_LANGUAGES_PKG;