[Home] [Help]
PACKAGE: APPS.DPP_EXECUTIONDETAILS_PVT
Source
1 PACKAGE DPP_EXECUTIONDETAILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvexes.pls 120.3 2008/04/03 10:30:50 sdasan noship $ */
3
4 TYPE DPP_EXE_UPDATE_REC_TYPE IS RECORD(TRANSACTION_HEADER_ID NUMBER,
5 ORG_ID NUMBER,
6 EXECUTION_DETAIL_ID NUMBER,
7 OUTPUT_XML CLOB,
8 EXECUTION_STATUS VARCHAR2(10),
9 EXECUTION_END_DATE DATE,
10 PROVIDER_PROCESS_ID VARCHAR2(240),
11 PROVIDER_PROCESS_INSTANCE_ID VARCHAR2(240),
12 LAST_UPDATED_BY NUMBER,
13 LAST_UPDATE_LOGIN NUMBER);
14
15 G_DPP_EXE_UPDATE_REC DPP_EXE_UPDATE_REC_TYPE;
16
17 TYPE DPP_STATUS_UPDATE_REC_TYPE IS RECORD(TRANSACTION_LINE_ID NUMBER,
18 UPDATE_STATUS VARCHAR2(30));
19
20 G_DPP_STATUS_UPDATE_REC DPP_STATUS_UPDATE_REC_TYPE;
21
22 TYPE DPP_STATUS_UPDATE_TBL_TYPE IS TABLE OF DPP_STATUS_UPDATE_REC_TYPE INDEX BY BINARY_INTEGER ;
23
24 G_DPP_STATUS_UPDATE_TBL DPP_STATUS_UPDATE_TBL_TYPE;
25
26 ---------------------------------------------------------------------
27 -- PROCEDURE
28 -- Update_ExecutionDetails
29 --
30 -- PURPOSE
31 -- Update Execution Details
32 --
33 -- PARAMETERS
34 --
35 -- NOTES
36 -- 1.
37 -- 2.
38 ----------------------------------------------------------------------
39
40 PROCEDURE Update_ExecutionDetails(
41 p_api_version IN NUMBER
42 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
43 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
44 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2
48 ,p_EXE_UPDATE_rec IN OUT NOCOPY DPP_EXE_UPDATE_REC_TYPE
49 ,p_status_Update_tbl IN OUT NOCOPY dpp_status_Update_tbl_type
50 );
51
52
53 ---------------------------------------------------------------------
54 -- PROCEDURE
55 -- Update_ESB_InstanceID
56 --
57 -- PURPOSE
58 -- Update ESB Instance ID
59 --
60 -- PARAMETERS
61 --
62 -- NOTES
63 -- 1.
64 -- 2.
65 ----------------------------------------------------------------------
66
67 PROCEDURE Update_ESB_InstanceID(
68 p_api_version IN NUMBER
69 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
70 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 ,p_execution_detail_id IN NUMBER
76 ,p_esb_instance_id IN VARCHAR2
77 );
78
79 END DPP_ExecutionDetails_PVT;