[Home] [Help]
PACKAGE: APPS.DPP_CLAIMS_PVT
Source
1 PACKAGE DPP_CLAIMS_PVT AS
2 /* $Header: dppvclas.pls 120.2 2007/12/04 08:54:15 sdasan noship $ */
3
4 TYPE dpp_txn_hdr_rec_type IS RECORD
5 (
6 Transaction_Header_ID NUMBER,
7 Transaction_number VARCHAR2(240),
8 Org_ID NUMBER,
9 Vendor_ID NUMBER,
10 Vendor_site_ID NUMBER,
11 claim_ID NUMBER,
12 claim_status_code VARCHAR2(30),
13 claim_amount NUMBER,
14 currency_code VARCHAR2(15),
15 claim_type_flag VARCHAR2(30),
16 Execution_Detail_ID NUMBER,
17 Provider_Process_Id VARCHAR2(240),
18 Provider_Process_Instance_id VARCHAR2(240),
19 Last_Updated_By NUMBER,
20 Last_Update_Date DATE,
21 Attribute_Category VARCHAR2(30),
22 Attribute1 VARCHAR2(150),
23 Attribute2 VARCHAR2(150),
24 Attribute3 VARCHAR2(150),
25 Attribute4 VARCHAR2(150),
26 Attribute5 VARCHAR2(150),
27 Attribute6 VARCHAR2(150),
28 Attribute7 VARCHAR2(150),
29 Attribute8 VARCHAR2(150),
30 Attribute9 VARCHAR2(150),
31 Attribute10 VARCHAR2(150),
32 Attribute11 VARCHAR2(150),
33 Attribute12 VARCHAR2(150),
34 Attribute13 VARCHAR2(150),
35 Attribute14 VARCHAR2(150),
36 Attribute15 VARCHAR2(150)
37 );
38
39 TYPE dpp_txn_line_rec_type IS RECORD
40 (
41 Transaction_Line_ID NUMBER,
42 Inventory_Item_Id NUMBER,
43 Item_Number VARCHAR2(40),
44 cust_account_id NUMBER,
45 Claim_Line_Amount NUMBER,
46 Currency VARCHAR2(30),
47 Claim_Quantity NUMBER,
48 UOM VARCHAR2(30),
49 claim_ID NUMBER,
50 claim_status_code VARCHAR2(30),
51 claim_amount NUMBER,
52 Last_Updated_By NUMBER,
53 Last_Update_Date DATE,
54 Attribute_Category VARCHAR2(30),
55 Attribute1 VARCHAR2(150),
56 Attribute2 VARCHAR2(150),
57 Attribute3 VARCHAR2(150),
58 Attribute4 VARCHAR2(150),
59 Attribute5 VARCHAR2(150),
60 Attribute6 VARCHAR2(150),
61 Attribute7 VARCHAR2(150),
62 Attribute8 VARCHAR2(150),
63 Attribute9 VARCHAR2(150),
64 Attribute10 VARCHAR2(150),
65 Attribute11 VARCHAR2(150),
66 Attribute12 VARCHAR2(150),
67 Attribute13 VARCHAR2(150),
68 Attribute14 VARCHAR2(150),
69 Attribute15 VARCHAR2(150),
70 Update_Status VARCHAR2(30),
71 Reason_For_Failure VARCHAR2(240)
72 );
73
74 G_dpp_txn_line_rec dpp_txn_line_rec_type;
75 TYPE dpp_txn_line_tbl_type IS TABLE OF dpp_txn_line_rec_type INDEX BY BINARY_INTEGER;
76 g_dpp_txn_line_tbl dpp_txn_line_tbl_type;
77
78 ---------------------------------------------------------------------
79 -- PROCEDURE
80 -- Create_Claims
81 --
82 -- PURPOSE
83 -- Create Claims
84 --
85 -- PARAMETERS
86 --
87 -- NOTES
88 -- 1.
89 -- 2.
90 ----------------------------------------------------------------------
91
92 PROCEDURE Create_Claims(
93 p_api_version IN NUMBER
94 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
95 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 ,p_txn_hdr_rec IN dpp_txn_hdr_rec_type
101 ,p_txn_line_tbl IN dpp_txn_line_tbl_type
102 );
103 ---------------------------------------------------------------------
104 -- PROCEDURE
105 -- Update_Claims
106 --
107 -- PURPOSE
108 -- Update Claims
109 --
110 -- PARAMETERS
111 --
112 -- NOTES
113 -- 1.
114 -- 2.
115 ----------------------------------------------------------------------
116
117 PROCEDURE Update_Claims(
118 p_api_version IN NUMBER
119 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
120 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_msg_count OUT NOCOPY NUMBER
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 ,p_txn_hdr_rec IN OUT NOCOPY dpp_txn_hdr_rec_type
126 ,p_txn_line_tbl IN OUT NOCOPY dpp_txn_line_tbl_type
127 );
128
129 END DPP_CLAIMS_PVT;