APPS.GR_SUB_HEADINGS_B_PKG dependencies on GR_SUB_HEADINGS_B

Line 1: PACKAGE BODY GR_SUB_HEADINGS_B_PKG AS

1: PACKAGE BODY GR_SUB_HEADINGS_B_PKG AS
2: /*$Header: GRHISHBB.pls 115.3 2002/10/25 16:05:43 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_sub_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_sub_headings_b
74: (sub_heading_code,
75: sub_heading_print_font,
76: sub_heading_print_size,
77: created_by,

Line 235: UPDATE gr_sub_headings_b

231:
232: IF l_return_status <> 'S' THEN
233: RAISE Foreign_Key_Error;
234: ELSE
235: UPDATE gr_sub_headings_b
236: SET sub_heading_code = p_sub_heading_code,
237: sub_heading_print_font = p_sub_heading_print_font,
238: sub_heading_print_size = p_sub_heading_print_size,
239: created_by = p_created_by,

Line 348: FROM gr_sub_headings_b

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

Line 485: DELETE FROM gr_sub_headings_b

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

Line 735: FROM gr_sub_headings_b mhb

731:
732: CURSOR c_get_sub_hdg_b_rowid
733: IS
734: SELECT mhb.rowid
735: FROM gr_sub_headings_b mhb
736: WHERE mhb.sub_heading_code = p_sub_heading_code;
737: SubHdgBRecord c_get_sub_hdg_b_rowid%ROWTYPE;
738:
739: BEGIN

Line 769: END GR_SUB_HEADINGS_B_PKG;

765: END IF;
766:
767: END Check_Primary_Key;
768:
769: END GR_SUB_HEADINGS_B_PKG;