APPS.GR_EMEA_PKG dependencies on GR_EMEA

Line 1: PACKAGE BODY GR_EMEA_PKG AS

1: PACKAGE BODY GR_EMEA_PKG AS
2: /*$Header: GRHIIEUB.pls 115.8 2002/10/30 19:59:16 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 141: INSERT INTO gr_emea

137: IF FND_API.To_Boolean(l_key_exists) THEN
138: RAISE Item_Exists_Error;
139: END IF;
140:
141: INSERT INTO gr_emea
142: (item_code,
143: european_index_number,
144: eec_number,
145: consolidated_risk_phrase,

Line 433: UPDATE gr_emea

429:
430: IF l_return_status <> 'S' THEN
431: RAISE Foreign_Key_Error;
432: ELSE
433: UPDATE gr_emea
434: SET item_code = p_item_code,
435: european_index_number = p_european_index_number,
436: eec_number = p_eec_number,
437: consolidated_risk_phrase = p_consolidated_risk_phrase,

Line 609: FROM gr_emea

605:
606: CURSOR c_lock_item
607: IS
608: SELECT *
609: FROM gr_emea
610: WHERE rowid = p_rowid
611: FOR UPDATE NOWAIT;
612: LockItemRcd c_lock_item%ROWTYPE;
613: BEGIN

Line 808: DELETE FROM gr_emea

804: IF l_return_status <> 'S' THEN
805: RAISE Check_Integrity_Error;
806: END IF;
807:
808: DELETE FROM gr_emea
809: WHERE rowid = p_rowid;
810:
811: /* Check the commit flag and if set, then commit the work. */
812:

Line 1115: FROM gr_emea eur

1111:
1112: CURSOR c_get_item_rowid
1113: IS
1114: SELECT eur.rowid
1115: FROM gr_emea eur
1116: WHERE eur.item_code = p_item_code;
1117: ItemRecord c_get_item_rowid%ROWTYPE;
1118:
1119: BEGIN

Line 1149: END GR_EMEA_PKG;

1145: END IF;
1146:
1147: END Check_Primary_Key;
1148:
1149: END GR_EMEA_PKG;