[Home] [Help]
PACKAGE: APPS.DPP_COVEREDINVENTORY_PVT
Source
1 PACKAGE DPP_COVEREDINVENTORY_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvcovs.pls 120.0 2007/11/28 10:13:33 sdasan noship $ */
3 /* Contains Procedures - Select Covered Inventory from INV, Populate Covered Inventory in DPP */
4 DPP_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5 DPP_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6 DPP_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7
8 TYPE dpp_inv_hdr_rec_type IS RECORD
9 (
10 Transaction_Header_ID NUMBER,
11 Effective_Start_Date DATE,
12 Effective_End_Date DATE,
13 Org_ID NUMBER,
14 Execution_Detail_ID NUMBER,
15 Output_XML CLOB,
16 Provider_Process_Id VARCHAR2(240),
17 Provider_Process_Instance_id VARCHAR2(240),
18 Last_Updated_By NUMBER
19 );
20
21 TYPE dpp_inv_cov_rec_type IS RECORD
22 (
23 Transaction_Line_Id NUMBER,
24 Inventory_ITem_ID NUMBER,
25 UOM_Code VARCHAR2(3),
26 Onhand_Quantity NUMBER,
27 Covered_quantity NUMBER,
28 wh_line_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type
29 );
30
31 G_MISS_dpp_inv_cov_rec dpp_inv_cov_rec_type;
32 TYPE dpp_inv_cov_tbl_type IS TABLE OF dpp_inv_cov_rec_type INDEX BY BINARY_INTEGER;
33 G_MISS_dpp_inv_cov_tbl dpp_inv_cov_tbl_type;
34
35
36 TYPE dpp_inv_cov_wh_rec_type IS RECORD
37 (
38 Warehouse_id NUMBER,
39 Warehouse_Name VARCHAR2(240),
40 Covered_quantity NUMBER,
41 rct_line_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type
42 );
43
44 G_MISS_dpp_inv_cov_wh_rec dpp_inv_cov_wh_rec_type;
45 TYPE dpp_inv_cov_wh_tbl_type IS TABLE OF dpp_inv_cov_wh_rec_type INDEX BY BINARY_INTEGER;
46 G_MISS_dpp_inv_cov_wh_tbl dpp_inv_cov_wh_tbl_type;
47
48
49 TYPE dpp_inv_cov_rct_rec_type IS RECORD
50 (
51 Date_Received DATE,
52 Onhand_quantity NUMBER
53 );
54
55 G_MISS_dpp_inv_cov_rct_rec dpp_inv_cov_rct_rec_type;
56 TYPE dpp_inv_cov_rct_tbl_type IS TABLE OF dpp_inv_cov_rct_rec_type INDEX BY BINARY_INTEGER;
57 G_MISS_dpp_inv_cov_rct_tbl dpp_inv_cov_rct_tbl_type;
58
59 ---------------------------------------------------------------------
60 -- PROCEDURE
61 -- Select_CoveredInventory
62 --
63 -- PURPOSE
64 -- Select Covered Inventory
65 --
66 -- PARAMETERS
67 --
68 -- NOTES
69 -- 1.
70 -- 2.
71 ----------------------------------------------------------------------
72
73 PROCEDURE Select_CoveredInventory(
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
76 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
77 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 ,p_inv_hdr_rec IN dpp_inv_hdr_rec_type
82 ,p_covered_inv_tbl IN OUT NOCOPY dpp_inv_cov_tbl_type
83 );
84
85 ---------------------------------------------------------------------
86 -- PROCEDURE
87 -- Populate_CoveredInventory
88 --
89 -- PURPOSE
90 -- Populate Covered Inventory
91 --
92 -- PARAMETERS
93 --
94 -- NOTES
95 -- 1.
96 -- 2.
97 ----------------------------------------------------------------------
98
99 PROCEDURE Populate_CoveredInventory(
100 p_api_version IN NUMBER
101 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
102 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
103 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
104 ,x_return_status OUT NOCOPY VARCHAR2
105 ,x_msg_count OUT NOCOPY NUMBER
106 ,x_msg_data OUT NOCOPY VARCHAR2
107 ,p_inv_hdr_rec IN dpp_inv_hdr_rec_type
108 ,p_covered_inv_tbl IN dpp_inv_cov_tbl_type
109 );
110
111 PROCEDURE Update_CoveredInventory(
112 p_api_version IN NUMBER
113 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
114 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2
119 ,p_inv_hdr_rec IN dpp_inv_hdr_rec_type
120 ,p_covered_inv_tbl IN dpp_inv_cov_tbl_type
121 );
122
123 END DPP_COVEREDINVENTORY_PVT;