PACKAGE: APPS.EGO_GENERIC_TEMP_DML_PVT

Source

1 PACKAGE EGO_GENERIC_TEMP_DML_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOVGTDS.pls 120.1 2010/11/15 06:17:15 nendrapu noship $ */
3 
4 G_RET_STS_SUCCESS         CONSTANT  VARCHAR2(1)  :=  FND_API.g_RET_STS_SUCCESS;     --'S'
5 G_RET_STS_ERROR           CONSTANT  VARCHAR2(1)  :=  FND_API.g_RET_STS_ERROR;       --'E'
6 G_RET_STS_UNEXP_ERROR     CONSTANT  VARCHAR2(1)  :=  FND_API.g_RET_STS_UNEXP_ERROR; --'U'
7 
8 G_PKG_NAME                CONSTANT  VARCHAR2(50) := 'EGO_GENERIC_TEMP_DML_PVT';
9 
10 G_CURRENT_USER_ID         NUMBER := FND_GLOBAL.User_Id;
11 G_CURRENT_LOGIN_ID        NUMBER := FND_GLOBAL.Login_Id;
12 
13 G_FALSE                   CONSTANT  VARCHAR2(1)  :=  FND_API.G_FALSE; -- 'F'
14 G_TRUE                    CONSTANT  VARCHAR2(1)  :=  FND_API.G_TRUE;  -- 'T'
15 
16 
17 --  ============================================================================
18 --  Name        : INSERT_ROW
19 --  Description : This procedure is used to insert data in the EGO_GENERIC_TEMP table
20 --
21 --  Parameters:
22 --        IN    :
23 --                p_generic_temp_tbl  IN    EGO_GENERIC_TEMP_TBL_TYPE
24 --
25 --
26 --  ============================================================================
27 
28  PROCEDURE Insert_Row ( p_api_version       IN NUMBER
29                        --,p_commit            IN VARCHAR2 DEFAULT G_FALSE
30                        ,p_generic_temp_tbl  IN  Ego_Generic_Temp_Tbl_Type
31                        ,x_return_status     OUT NOCOPY VARCHAR2
32                        ,x_msg_data          OUT NOCOPY VARCHAR2
33                        ,x_msg_count         OUT NOCOPY NUMBER
34                       );
35 
36 END EGO_GENERIC_TEMP_DML_PVT;
37