APPS.GR_DISPATCH_HISTORIES_PKG dependencies on GR_DISPATCH_HISTORIES

Line 1: PACKAGE BODY GR_DISPATCH_HISTORIES_PKG AS

1: PACKAGE BODY GR_DISPATCH_HISTORIES_PKG AS
2: /*$Header: GRHIDIHB.pls 115.5 2002/10/25 18:29:07 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 146: INSERT INTO gr_dispatch_histories

142: IF FND_API.To_Boolean(l_key_exists) THEN
143: RAISE Label_Exists_Error;
144: END IF;
145:
146: INSERT INTO gr_dispatch_histories
147: (document_code,
148: document_text_id,
149: item_code,
150: recipient_code,

Line 447: UPDATE gr_dispatch_histories

443:
444: IF l_return_status <> 'S' THEN
445: RAISE Foreign_Key_Error;
446: ELSE
447: UPDATE gr_dispatch_histories
448: SET document_code = p_document_code,
449: document_text_id = p_document_text_id,
450: item_code = p_item_code,
451: recipient_code = p_recipient_code,

Line 625: FROM gr_dispatch_histories

621:
622: CURSOR c_lock_dispatch
623: IS
624: SELECT *
625: FROM gr_dispatch_histories
626: WHERE rowid = p_rowid
627: FOR UPDATE NOWAIT;
628: LockDispatchRcd c_lock_dispatch%ROWTYPE;
629:

Line 827: DELETE FROM gr_dispatch_histories

823: IF l_return_status <> 'S' THEN
824: RAISE Check_Integrity_Error;
825: END IF;
826:
827: DELETE FROM gr_dispatch_histories
828: WHERE rowid = p_rowid;
829:
830: /* Check the commit flag and if set, then commit the work. */
831:

Line 931: DELETE FROM gr_dispatch_histories

927: RAISE Null_Delete_Option_Error;
928: ELSE
929: l_msg_token := p_item_code;
930:
931: DELETE FROM gr_dispatch_histories
932: WHERE item_code = p_item_code;
933: END IF;
934: ELSIF p_delete_option = 'D' THEN
935: IF p_document_code IS NULL THEN

Line 941: DELETE FROM gr_dispatch_histories

937: RAISE Null_Delete_Option_Error;
938: ELSE
939: l_msg_token := p_document_code;
940:
941: DELETE FROM gr_dispatch_histories
942: WHERE document_code = p_document_code;
943: END IF;
944: ELSIF p_delete_option = 'R' THEN
945: IF p_recipient_code IS NULL THEN

Line 951: DELETE FROM gr_dispatch_histories

947: RAISE Null_Delete_Option_Error;
948: ELSE
949: l_msg_token := p_recipient_code;
950:
951: DELETE FROM gr_dispatch_histories
952: WHERE recipient_code = p_recipient_code;
953: END IF;
954: ELSIF p_delete_option = 'C' THEN
955: IF p_item_code IS NULL OR

Line 962: DELETE FROM gr_dispatch_histories

958: RAISE Null_Delete_Option_Error;
959: ELSE
960: l_msg_token := p_item_code || ' ' || p_document_code;
961:
962: DELETE FROM gr_dispatch_histories
963: WHERE item_code = p_item_code
964: AND document_code = p_document_code;
965: END IF;
966: END IF;

Line 1275: FROM gr_dispatch_histories dih

1271:
1272: CURSOR c_get_dispatch_rowid
1273: IS
1274: SELECT dih.rowid
1275: FROM gr_dispatch_histories dih
1276: WHERE dih.document_code = p_document_code
1277: AND dih.document_text_id = p_document_text_id
1278: AND dih.item_code = p_item_code
1279: AND dih.recipient_code = p_recipient_code

Line 1312: END GR_DISPATCH_HISTORIES_PKG;

1308: END IF;
1309:
1310: END Check_Primary_Key;
1311:
1312: END GR_DISPATCH_HISTORIES_PKG;