APPS.GR_PHRASES_B_PKG dependencies on GR_PHRASES_B

Line 1: PACKAGE BODY GR_PHRASES_B_PKG AS

1: PACKAGE BODY GR_PHRASES_B_PKG AS
2: /*$Header: GRHIPHRB.pls 115.6 2002/10/28 19:49:24 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 134: INSERT INTO gr_phrases_b

130: IF FND_API.To_Boolean(l_key_exists) THEN
131: RAISE Label_Exists_Error;
132: END IF;
133:
134: INSERT INTO gr_phrases_b
135: (phrase_code,
136: main_heading_code,
137: sub_heading_code,
138: attribute_category,

Line 415: UPDATE gr_phrases_b

411:
412: IF l_return_status <> 'S' THEN
413: RAISE Foreign_Key_Error;
414: ELSE
415: UPDATE gr_phrases_b
416: SET phrase_code = p_phrase_code,
417: main_heading_code = p_main_heading_code,
418: sub_heading_code = p_sub_heading_code,
419: attribute_category = p_attribute_category,

Line 584: FROM gr_phrases_b

580:
581: CURSOR c_lock_phrase
582: IS
583: SELECT last_update_date
584: FROM gr_phrases_b
585: WHERE rowid = p_rowid
586: FOR UPDATE NOWAIT;
587: LockPhraseRcd c_lock_phrase%ROWTYPE;
588:

Line 788: DELETE FROM gr_phrases_b

784: IF l_return_status <> 'S' THEN
785: RAISE Check_Integrity_Error;
786: END IF;
787:
788: DELETE FROM gr_phrases_b
789: WHERE rowid = p_rowid;
790:
791: /* Check the commit flag and if set, then commit the work. */
792:

Line 1234: FROM gr_phrases_b phr

1230:
1231: CURSOR c_get_phrase_rowid
1232: IS
1233: SELECT phr.rowid
1234: FROM gr_phrases_b phr
1235: WHERE phr.phrase_code = p_phrase_code;
1236: PhraseRecord c_get_phrase_rowid%ROWTYPE;
1237:
1238: BEGIN

Line 1267: END GR_PHRASES_B_PKG;

1263: END IF;
1264:
1265: END Check_Primary_Key;
1266:
1267: END GR_PHRASES_B_PKG;