APPS.GR_MAIN_HEADINGS_B_PKG dependencies on GR_MAIN_HEADINGS_B

Line 1: PACKAGE BODY GR_MAIN_HEADINGS_B_PKG AS

1: PACKAGE BODY GR_MAIN_HEADINGS_B_PKG AS
2: /*$Header: GRHIMHBB.pls 115.3 2002/10/28 16:42:58 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_main_headings_b

69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Item_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_main_headings_b
74: (main_heading_code,
75: main_heading_print_font,
76: main_heading_print_size,
77: created_by,

Line 235: UPDATE gr_main_headings_b

231:
232: IF l_return_status <> 'S' THEN
233: RAISE Foreign_Key_Error;
234: ELSE
235: UPDATE gr_main_headings_b
236: SET main_heading_code = p_main_heading_code,
237: main_heading_print_font = p_main_heading_print_font,
238: main_heading_print_size = p_main_heading_print_size,
239: created_by = p_created_by,

Line 348: FROM gr_main_headings_b

344:
345: CURSOR c_lock_main_hdg_b
346: IS
347: SELECT *
348: FROM gr_main_headings_b
349: WHERE rowid = p_rowid
350: FOR UPDATE NOWAIT;
351: LockMainHdgRcd c_lock_main_hdg_b%ROWTYPE;
352:

Line 485: DELETE FROM gr_main_headings_b

481: IF l_return_status <> 'S' THEN
482: RAISE Check_Integrity_Error;
483: END IF;
484:
485: DELETE FROM gr_main_headings_b
486: WHERE rowid = p_rowid;
487:
488: /* Check the commit flag and if set, then commit the work. */
489:

Line 743: FROM gr_main_headings_b mhb

739:
740: CURSOR c_get_main_hdg_b_rowid
741: IS
742: SELECT mhb.rowid
743: FROM gr_main_headings_b mhb
744: WHERE mhb.main_heading_code = p_main_heading_code;
745: MainHdgBRecord c_get_main_hdg_b_rowid%ROWTYPE;
746:
747: BEGIN

Line 777: END GR_MAIN_HEADINGS_B_PKG;

773: END IF;
774:
775: END Check_Primary_Key;
776:
777: END GR_MAIN_HEADINGS_B_PKG;