APPS.GR_PHRASE_CONCS_PKG dependencies on GR_PHRASE_CONCS

Line 1: PACKAGE BODY GR_PHRASE_CONCS_PKG AS

1: PACKAGE BODY GR_PHRASE_CONCS_PKG AS
2: /*$Header: GRHIPHCB.pls 115.5 2002/10/28 19:58:32 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 140: INSERT INTO gr_phrase_concs

136: IF FND_API.To_Boolean(l_key_exists) THEN
137: RAISE Label_Exists_Error;
138: END IF;
139:
140: INSERT INTO gr_phrase_concs
141: (phrase_code,
142: phrase_concentration_low,
143: phrase_concentration_high,
144: phrase_type_code,

Line 431: UPDATE gr_phrase_concs

427:
428: IF l_return_status <> 'S' THEN
429: RAISE Foreign_Key_Error;
430: ELSE
431: UPDATE gr_phrase_concs
432: SET phrase_code = p_phrase_code,
433: phrase_concentration_low = p_phrase_concentration_low,
434: phrase_concentration_high = p_phrase_concentration_high,
435: phrase_type_code = p_phrase_type_code,

Line 604: FROM gr_phrase_concs

600:
601: CURSOR c_lock_concs
602: IS
603: SELECT last_update_date
604: FROM gr_phrase_concs
605: WHERE rowid = p_rowid
606: FOR UPDATE NOWAIT;
607: LockConcRcd c_lock_concs%ROWTYPE;
608:

Line 814: DELETE FROM gr_phrase_concs

810: IF l_return_status <> 'S' THEN
811: RAISE Check_Integrity_Error;
812: END IF;
813:
814: DELETE FROM gr_phrase_concs
815: WHERE rowid = p_rowid;
816:
817: /* Check the commit flag and if set, then commit the work. */
818:

Line 900: DELETE FROM gr_phrase_concs

896: x_oracle_error := 0;
897: x_msg_data := NULL;
898: l_msg_token := p_phrase_code;
899:
900: DELETE FROM gr_phrase_concs
901: WHERE phrase_code = p_phrase_code;
902:
903: IF FND_API.To_Boolean(p_commit) THEN
904: COMMIT WORK;

Line 1151: FROM gr_phrase_concs phc

1147:
1148: CURSOR c_get_conc_rowid
1149: IS
1150: SELECT phc.rowid
1151: FROM gr_phrase_concs phc
1152: WHERE phc.phrase_code = p_phrase_code
1153: AND phc.phrase_concentration_low = p_phrase_concentration_low
1154: AND phc.phrase_concentration_high = p_phrase_concentration_high;
1155: ConcRecord c_get_conc_rowid%ROWTYPE;

Line 1186: END GR_PHRASE_CONCS_PKG;

1182: END IF;
1183:
1184: END Check_Primary_Key;
1185:
1186: END GR_PHRASE_CONCS_PKG;