APPS.GR_DISPATCH_HISTORY_PVT dependencies on GR_DISPATCH_HISTORY

Line 1: PACKAGE BODY GR_DISPATCH_HISTORY_PVT AS

1: PACKAGE BODY GR_DISPATCH_HISTORY_PVT AS
2: /* $Header: GRVDSPHB.pls 120.5 2005/10/19 12:22:14 pbamb noship $ */
3:
4: PROCEDURE log_msg(p_msg_text IN VARCHAR2);
5:

Line 12: G_PKG_NAME CONSTANT varchar2(30) := 'GR_DISPATCH_HISTORY_PVT';

8: -- msg level threshhold gobal
9: -- variable.
10: G_debug_level NUMBER := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
11: -- to decide to log a debug msg.
12: G_PKG_NAME CONSTANT varchar2(30) := 'GR_DISPATCH_HISTORY_PVT';
13:
14: g_log_head CONSTANT VARCHAR2(50) := 'gr.plsql.'|| G_PKG_NAME || '.';
15:
16: --------------------------------------------------------------------------------

Line 186: SELECT gr_dispatch_history_s.nextval

182: WHERE request_id = -12345;
183:
184: --Cursor used to retrieve the next dispatch history id
185: CURSOR c_get_dispatch_history_id IS
186: SELECT gr_dispatch_history_s.nextval
187: FROM DUAL;
188:
189: INVALID_VALUE EXCEPTION;
190: INVALID_USER_ID EXCEPTION;

Line 614: INSERT INTO GR_DISPATCH_HISTORY (

610: FETCH c_get_dispatch_history_id INTO l_dispatch_history_id;
611: CLOSE c_get_dispatch_history_id;
612:
613:
614: INSERT INTO GR_DISPATCH_HISTORY (
615: dispatch_history_id ,
616: document_id ,
617: item ,
618: organization_id ,

Line 991: END GR_DISPATCH_HISTORY_PVT; -- Package body

987: WHEN OTHERS THEN
988: p_item_desc := NULL;
989: END;
990:
991: END GR_DISPATCH_HISTORY_PVT; -- Package body