APPS.GR_ITEM_DOCUMENT_DTLS_PKG dependencies on GR_ITEM_DOCUMENT_DTLS

Line 1: PACKAGE BODY GR_ITEM_DOCUMENT_DTLS_PKG AS

1: PACKAGE BODY GR_ITEM_DOCUMENT_DTLS_PKG AS
2: /*$Header: GRHIIDDB.pls 115.6 2002/10/25 20:31:01 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 88: INSERT INTO gr_item_document_dtls

84: IF FND_API.To_Boolean(l_key_exists) THEN
85: RAISE Label_Exists_Error;
86: END IF;
87:
88: INSERT INTO gr_item_document_dtls
89: (item_code,
90: document_code,
91: phrase_code,
92: display_order,

Line 273: UPDATE gr_item_document_dtls

269:
270: IF l_return_status <> 'S' THEN
271: RAISE Foreign_Key_Error;
272: ELSE
273: UPDATE gr_item_document_dtls
274: SET item_code = p_item_code,
275: document_code = p_document_code,
276: phrase_code = p_phrase_code,
277: display_order = p_display_order,

Line 394: FROM gr_item_document_dtls

390:
391: CURSOR c_lock_item_doc_dtls
392: IS
393: SELECT *
394: FROM gr_item_document_dtls
395: WHERE rowid = p_rowid
396: FOR UPDATE NOWAIT;
397: LockItemDocDtlRcd c_lock_item_doc_dtls%ROWTYPE;
398:

Line 539: DELETE FROM gr_item_document_dtls

535: IF l_return_status <> 'S' THEN
536: RAISE Check_Integrity_Error;
537: END IF;
538:
539: DELETE FROM gr_item_document_dtls
540: WHERE rowid = p_rowid;
541:
542: /* Check the commit flag and if set, then commit the work. */
543:

Line 644: DELETE FROM gr_item_document_dtls

640: RAISE Null_Delete_Option_Error;
641: ELSE
642: l_msg_token := p_item_code;
643:
644: DELETE FROM gr_item_document_dtls
645: WHERE item_code = p_item_code;
646: END IF;
647: ELSIF p_delete_option = 'D' THEN
648: IF p_document_code IS NULL THEN

Line 654: DELETE FROM gr_item_document_dtls

650: RAISE Null_Delete_Option_Error;
651: ELSE
652: l_msg_token := p_document_code;
653:
654: DELETE FROM gr_item_document_dtls
655: WHERE document_code = p_document_code;
656: END IF;
657: ELSIF p_delete_option = 'P' THEN
658: IF p_phrase_code IS NULL THEN

Line 664: DELETE FROM gr_item_document_dtls

660: RAISE Null_Delete_Option_Error;
661: ELSE
662: l_msg_token := p_phrase_code;
663:
664: DELETE FROM gr_item_document_dtls
665: WHERE phrase_code = p_phrase_code;
666: END IF;
667: END IF;
668:

Line 988: FROM gr_item_document_dtls idd

984:
985: CURSOR c_get_item_doc_dtls_rowid
986: IS
987: SELECT idd.rowid
988: FROM gr_item_document_dtls idd
989: WHERE idd.item_code = p_item_code
990: AND idd.document_code = p_document_code
991: AND idd.phrase_code = p_phrase_code
992: AND idd.display_order = p_display_order;

Line 1024: END GR_ITEM_DOCUMENT_DTLS_PKG;

1020: END IF;
1021:
1022: END Check_Primary_Key;
1023:
1024: END GR_ITEM_DOCUMENT_DTLS_PKG;