APPS.GR_DOCUMENT_CODES_PKG dependencies on GR_DOCUMENT_CODES

Line 1: PACKAGE BODY GR_DOCUMENT_CODES_PKG AS

1: PACKAGE BODY GR_DOCUMENT_CODES_PKG AS
2: /*$Header: GRHIDCB.pls 115.13 2002/10/28 19:12:23 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 216: INSERT INTO gr_document_codes

212: IF FND_API.To_Boolean(l_key_exists) THEN
213: RAISE Label_Exists_Error;
214: END IF;
215:
216: INSERT INTO gr_document_codes
217: (document_code,
218: user_id,
219: document_version,
220: document_description,

Line 661: UPDATE gr_document_codes

657:
658: IF l_return_status <> 'S' THEN
659: RAISE Foreign_Key_Error;
660: ELSE
661: UPDATE gr_document_codes
662: SET document_code = p_document_code,
663: user_id = p_user_id,
664: document_version = p_document_version,
665: document_description = p_document_description,

Line 913: FROM gr_document_codes

909:
910: CURSOR c_lock_document
911: IS
912: SELECT *
913: FROM gr_document_codes
914: WHERE rowid = p_rowid
915: FOR UPDATE NOWAIT;
916: LockDocumentRcd c_lock_document%ROWTYPE;
917:

Line 1189: DELETE FROM gr_document_codes

1185: IF l_return_status <> 'S' THEN
1186: RAISE Check_Integrity_Error;
1187: END IF;
1188:
1189: DELETE FROM gr_document_codes
1190: WHERE rowid = p_rowid;
1191:
1192: /* Check the commit flag and if set, then commit the work. */
1193:

Line 1732: FROM gr_document_codes dc

1728:
1729: CURSOR c_get_document_rowid
1730: IS
1731: SELECT dc.rowid
1732: FROM gr_document_codes dc
1733: WHERE dc.document_code = p_document_code;
1734: DocumentRecord c_get_document_rowid%ROWTYPE;
1735:
1736: BEGIN

Line 1765: END GR_DOCUMENT_CODES_PKG;

1761: END IF;
1762:
1763: END Check_Primary_Key;
1764:
1765: END GR_DOCUMENT_CODES_PKG;