1 package OZF_split_claim_PVT as
2 /* $Header: ozfvspcs.pls 120.1 2006/06/13 11:19:37 kdhulipa noship $ */
3
4 TYPE Child_Claim_type IS RECORD (
5 claim_id NUMBER ,
6 object_version_number NUMBER ,
7 claim_type_id NUMBER ,
8 amount NUMBER ,
9 line_amount_sum NUMBER ,
10 reason_code_id NUMBER ,
11 parent_claim_id NUMBER ,
12 parent_object_ver_num NUMBER ,
13 line_table VARCHAR2(4000) --Bugfix 5305296
14 );
15
16 TYPE Child_Claim_tbl_type IS TABLE of Child_Claim_type
17 INDEX BY BINARY_INTEGER;
18
19 TYPE Parent_Claim_type IS RECORD (
20 claim_id NUMBER ,
21 object_version_number NUMBER ,
22 amount_adjusted NUMBER
23 );
24
25 ---------------------------------------------------------------------
26 -- PROCEDURE
27 -- create_child_claim_tbl
28 --
29 -- PURPOSE
30 -- Split a child claim
31 --
32 -- PARAMETERS
33 -- p_claim : the new claim to be created.
34 -- p_line_tbl : the table of lines associated with this new claim if any.
35 --
36 -- NOTES
37 ----------------------------------------------------------------------
38 PROCEDURE create_child_claim_tbl (
39 p_api_version IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,p_child_claim_tbl IN Child_Claim_tbl_type
47 ,p_mode IN VARCHAR2
48 );
49 ---------------------------------------------------------------------
50 -- PROCEDURE
51 -- update_child_claim_tbl
52 --
53 -- PURPOSE
54 -- Update a child claim
55 --
56 -- PARAMETERS
57 -- p_claim : the claim to be update.
58 -- p_line_tbl : the table of lines associated with this claim if any.
59 --
60 -- NOTES
61 ----------------------------------------------------------------------
62 PROCEDURE update_child_claim_tbl (
63 p_api_version IN NUMBER
64 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
65 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
66 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_data OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,p_child_claim_tbl IN child_claim_tbl_type
71 ,p_mode IN VARCHAR2
72 );
73
74 END;
[Home] [Help]