APPS.GR_DOC_HDR_FTR_PKG dependencies on GR_DOC_HDR_FTR

Line 1: PACKAGE BODY GR_DOC_HDR_FTR_PKG AS

1: PACKAGE BODY GR_DOC_HDR_FTR_PKG AS
2: /*$Header: GRHIDHFB.pls 115.1 2002/10/28 23:03:24 mgrosser noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 80: INSERT INTO gr_doc_hdr_ftr

76: IF FND_API.To_Boolean(l_key_exists) THEN
77: RAISE Item_Exists_Error;
78: END IF;
79:
80: INSERT INTO gr_doc_hdr_ftr
81: (document_code,
82: line_type,
83: line_no,
84: left_label_code,

Line 248: UPDATE gr_doc_hdr_ftr

244:
245: IF l_return_status <> 'S' THEN
246: RAISE Foreign_Key_Error;
247: ELSE
248: UPDATE gr_doc_hdr_ftr
249: SET left_label_code = p_left_label_code,
250: right_label_code = p_right_label_code,
251: last_updated_by = p_last_updated_by,
252: last_update_date = p_last_update_date,

Line 356: FROM gr_doc_hdr_ftr

352:
353: CURSOR c_lock_doc_hdr_ftr
354: IS
355: SELECT last_update_date
356: FROM gr_doc_hdr_ftr
357: WHERE rowid = p_rowid
358: FOR UPDATE NOWAIT;
359: LockDHFRcd c_lock_doc_hdr_ftr%ROWTYPE;
360: BEGIN

Line 493: DELETE FROM gr_doc_hdr_ftr

489: IF l_return_status <> 'S' THEN
490: RAISE Check_Integrity_Error;
491: END IF;
492:
493: DELETE FROM gr_doc_hdr_ftr
494: WHERE rowid = p_rowid;
495:
496: /* Check the commit flag and if set, then commit the work. */
497:

Line 756: FROM gr_doc_hdr_ftr dhf

752:
753: CURSOR c_get_dhf_rowid
754: IS
755: SELECT dhf.rowid
756: FROM gr_doc_hdr_ftr dhf
757: WHERE document_code = p_document_code
758: AND line_type = p_line_type
759: AND line_no = p_line_no;
760: DHFRecord c_get_dhf_rowid%ROWTYPE;

Line 790: END GR_DOC_HDR_FTR_PKG;

786: END IF;
787:
788: END Check_Primary_Key;
789:
790: END GR_DOC_HDR_FTR_PKG;