APPS.GR_COVER_LETTERS_B_PKG dependencies on GR_COVER_LETTERS_B

Line 1: PACKAGE BODY GR_COVER_LETTERS_B_PKG AS

1: PACKAGE BODY GR_COVER_LETTERS_B_PKG AS
2: /*$Header: GRHICLBB.pls 115.3 2002/10/24 21:17:01 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 71: INSERT INTO gr_cover_letters_b

67: IF FND_API.To_Boolean(l_key_exists) THEN
68: RAISE Item_Exists_Error;
69: END IF;
70:
71: INSERT INTO gr_cover_letters_b
72: (cover_letter_id,
73: orgn_code,
74: created_by,
75: creation_date,

Line 229: UPDATE gr_cover_letters_b

225:
226: IF l_return_status <> 'S' THEN
227: RAISE Foreign_Key_Error;
228: ELSE
229: UPDATE gr_cover_letters_b
230: SET cover_letter_id = p_cover_letter_id,
231: orgn_code = p_orgn_code,
232: created_by = p_created_by,
233: creation_date = p_creation_date,

Line 340: FROM gr_cover_letters_b

336:
337: CURSOR c_lock_letters_b
338: IS
339: SELECT *
340: FROM gr_cover_letters_b
341: WHERE rowid = p_rowid
342: FOR UPDATE NOWAIT;
343: LockLetterRcd c_lock_letters_b%ROWTYPE;
344:

Line 475: DELETE FROM gr_cover_letters_b

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

Line 716: FROM gr_cover_letters_b clb

712:
713: CURSOR c_get_letters_b_rowid
714: IS
715: SELECT clb.rowid
716: FROM gr_cover_letters_b clb
717: WHERE clb.cover_letter_id = p_cover_letter_id;
718: LetterBRecord c_get_letters_b_rowid%ROWTYPE;
719:
720: BEGIN

Line 750: END GR_COVER_LETTERS_B_PKG;

746: END IF;
747:
748: END Check_Primary_Key;
749:
750: END GR_COVER_LETTERS_B_PKG;