DBA Data[Home] [Help]

PACKAGE: APPS.DPP_ERROR_PVT

Source


1 PACKAGE DPP_ERROR_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppverrs.pls 120.1 2007/12/13 12:21:13 sdasan noship $ */
3 TYPE DPP_ERROR_REC_TYPE IS RECORD
4 (
5     Transaction_Header_ID       NUMBER,
6     Org_ID                      NUMBER,
7     Execution_Detail_ID         NUMBER,
8     Output_XML	                CLOB, -- contains error details
9     Provider_Process_Id         VARCHAR2(240),
10 	  Provider_Process_Instance_id VARCHAR2(240),
11 	  Last_Updated_By             NUMBER
12 );
13 
14 TYPE dpp_lines_tbl_type IS TABLE OF DPP_TRANSACTION_LINES_ALL.TRANSACTION_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
15 
16 
17 ---------------------------------------------------------------------
18 -- PROCEDURE
19 --    Update_Error
20 --
21 -- PURPOSE
22 --    Update Error
23 --
24 -- PARAMETERS
25 --
26 -- NOTES
27 --    1.
28 --    2.
29 ----------------------------------------------------------------------
30 
31 PROCEDURE Update_Error(
32     p_api_version   	 IN 	  NUMBER
33    ,p_init_msg_list	     IN 	  VARCHAR2     := FND_API.G_FALSE
34    ,p_commit	         IN 	  VARCHAR2     := FND_API.G_FALSE
35    ,p_validation_level	 IN 	  NUMBER       := FND_API.G_VALID_LEVEL_FULL
36    ,x_return_status	     OUT 	NOCOPY  VARCHAR2
37    ,x_msg_count	         OUT 	NOCOPY   NUMBER
38    ,x_msg_data	         OUT 	NOCOPY   VARCHAR2
39    ,p_exe_update_rec	 IN       DPP_ERROR_REC_TYPE
40    ,p_lines_tbl	         IN       DPP_LINES_TBL_TYPE
41 );
42 
43 END DPP_ERROR_PVT;