1 package OZF_split_claim_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvspcs.pls 120.3 2011/12/05 09:07:17 bkunjan ship $ */
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 child_claim_id NUMBER --ER 12985686
15 );
16
17 TYPE Child_Claim_tbl_type IS TABLE of Child_Claim_type
18 INDEX BY BINARY_INTEGER;
19
20 TYPE Parent_Claim_type IS RECORD (
21 claim_id NUMBER ,
22 object_version_number NUMBER ,
23 amount_adjusted NUMBER
24 );
25
26 ---------------------------------------------------------------------
27 -- PROCEDURE
28 -- create_child_claim_tbl
29 --
30 -- PURPOSE
31 -- Split a child claim
32 --
33 -- PARAMETERS
34 -- p_claim : the new claim to be created.
35 -- p_line_tbl : the table of lines associated with this new claim if any.
36 --
37 -- NOTES
38 ----------------------------------------------------------------------
39 PROCEDURE create_child_claim_tbl (
40 p_api_version IN NUMBER
41 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,px_child_claim_tbl IN OUT NOCOPY Child_Claim_tbl_type
48 ,p_mode IN VARCHAR2
49 );
50 ---------------------------------------------------------------------
51 -- PROCEDURE
52 -- update_child_claim_tbl
53 --
54 -- PURPOSE
55 -- Update a child claim
56 --
57 -- PARAMETERS
58 -- p_claim : the claim to be update.
59 -- p_line_tbl : the table of lines associated with this claim if any.
60 --
61 -- NOTES
62 ----------------------------------------------------------------------
63 PROCEDURE update_child_claim_tbl (
64 p_api_version IN NUMBER
65 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,p_child_claim_tbl IN child_claim_tbl_type
72 ,p_mode IN VARCHAR2
73 );
74
75 END;