APPS.GR_ITEM_DOC_STATUSES_PKG dependencies on GR_ITEM_DOC_STATUSES

Line 1: PACKAGE BODY GR_ITEM_DOC_STATUSES_PKG AS

1: PACKAGE BODY GR_ITEM_DOC_STATUSES_PKG AS
2: /*$Header: GRHIIDSB.pls 115.4 2002/10/25 20:37:50 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 84: INSERT INTO gr_item_doc_statuses

80: IF FND_API.To_Boolean(l_key_exists) THEN
81: RAISE Item_Exists_Error;
82: END IF;
83:
84: INSERT INTO gr_item_doc_statuses
85: (item_code,
86: document_code,
87: item_document_status,
88: item_document_version,

Line 267: UPDATE gr_item_doc_statuses

263:
264: IF l_return_status <> 'S' THEN
265: RAISE Foreign_Key_Error;
266: ELSE
267: UPDATE gr_item_doc_statuses
268: SET item_code = p_item_code,
269: document_code = p_document_code,
270: item_document_status = p_item_document_status,
271: item_document_version = p_item_document_version,

Line 386: FROM gr_item_doc_statuses

382:
383: CURSOR c_lock_item_doc_statuses
384: IS
385: SELECT *
386: FROM gr_item_doc_statuses
387: WHERE rowid = p_rowid
388: FOR UPDATE NOWAIT;
389: LockItemDocStatRcd c_lock_item_doc_statuses%ROWTYPE;
390:

Line 531: DELETE FROM gr_item_doc_statuses

527: IF l_return_status <> 'S' THEN
528: RAISE Check_Integrity_Error;
529: END IF;
530:
531: DELETE FROM gr_item_doc_statuses
532: WHERE rowid = p_rowid;
533:
534: /* Check the commit flag and if set, then commit the work. */
535:

Line 633: DELETE FROM gr_item_doc_statuses

629: RAISE Null_Delete_Option_Error;
630: ELSE
631: l_msg_token := p_item_code;
632:
633: DELETE FROM gr_item_doc_statuses
634: WHERE item_code = p_item_code;
635: END IF;
636: ELSIF p_delete_option = 'D' THEN
637: IF p_document_code IS NULL THEN

Line 643: DELETE FROM gr_item_doc_statuses

639: RAISE Null_Delete_Option_Error;
640: ELSE
641: l_msg_token := p_document_code;
642:
643: DELETE FROM gr_item_doc_statuses
644: WHERE document_code = p_document_code;
645: END IF;
646: END IF;
647:

Line 865: FROM gr_item_doc_statuses ids

861:
862: CURSOR c_get_item_doc_stat_rowid
863: IS
864: SELECT ids.rowid
865: FROM gr_item_doc_statuses ids
866: WHERE ids.item_code = p_item_code
867: AND ids.document_code = p_document_code;
868: ItemDocStatRecord c_get_item_doc_stat_rowid%ROWTYPE;
869:

Line 900: END GR_ITEM_DOC_STATUSES_PKG;

896: END IF;
897:
898: END Check_Primary_Key;
899:
900: END GR_ITEM_DOC_STATUSES_PKG;