APPS.GR_EIN_NUMBERS_B_PKG dependencies on GR_EIN_NUMBERS_B

Line 1: PACKAGE BODY GR_EIN_NUMBERS_B_PKG AS

1: PACKAGE BODY GR_EIN_NUMBERS_B_PKG AS
2: /*$Header: GRHIEINB.pls 115.5 2002/10/29 16:41:58 mgrosser noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_ein_numbers_b

69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Item_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_ein_numbers_b
74: (european_index_number,
75: eec_number,
76: primary_cas_number,
77: chemical_formula,

Line 232: UPDATE gr_ein_numbers_b

228:
229: IF l_return_status <> 'S' THEN
230: RAISE Foreign_Key_Error;
231: ELSE
232: UPDATE gr_ein_numbers_b
233: SET european_index_number = p_european_index_number,
234: eec_number = p_eec_number,
235: primary_cas_number = p_primary_cas_number,
236: chemical_formula = p_chemical_formula,

Line 343: FROM gr_ein_numbers_b

339:
340: CURSOR c_lock_ein_number
341: IS
342: SELECT last_update_date
343: FROM gr_ein_numbers_b
344: WHERE rowid = p_rowid
345: FOR UPDATE NOWAIT;
346: LockEinRcd c_lock_ein_number%ROWTYPE;
347: BEGIN

Line 472: DELETE FROM gr_ein_numbers_b

468: IF l_return_status <> 'S' THEN
469: RAISE Check_Integrity_Error;
470: END IF;
471:
472: DELETE FROM gr_ein_numbers_b
473: WHERE rowid = p_rowid;
474:
475: /* Check the commit flag and if set, then commit the work. */
476:

Line 673: FROM gr_ein_numbers_b ein

669:
670: CURSOR c_get_ein_rowid
671: IS
672: SELECT ein.rowid
673: FROM gr_ein_numbers_b ein
674: WHERE ein.european_index_number = p_european_index_number;
675: EinRecord c_get_ein_rowid%ROWTYPE;
676:
677: BEGIN

Line 705: END GR_EIN_NUMBERS_B_PKG;

701: END IF;
702:
703: END Check_Primary_Key;
704:
705: END GR_EIN_NUMBERS_B_PKG;