[Home] [Help]
PACKAGE: APPS.OZF_MASS_SETTLEMENT_PVT
Source
1 PACKAGE OZF_MASS_SETTLEMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvmsts.pls 120.2.12010000.2 2008/08/01 06:20:54 bkunjan ship $ */
3
4 TYPE group_claim_rec IS RECORD(
5 claim_id NUMBER,
6 claim_class VARCHAR2(30),
7 claim_number VARCHAR2(30),
8 claim_type_id NUMBER,
9 reason_code_id NUMBER,
10 cust_account_id NUMBER,
11 amount_settled NUMBER,
12 currency_code VARCHAR2(15),
13 bill_to_site_id NUMBER,
14 org_id NUMBER
15 );
16
17
18 TYPE open_claim_rec IS RECORD(
19 claim_id NUMBER,
20 claim_class VARCHAR2(30),
21 claim_number VARCHAR2(30),
22 amount_settled NUMBER
23 );
24
25 TYPE open_claim_tbl IS TABLE OF open_claim_rec
26 INDEX BY BINARY_INTEGER;
27
28 TYPE open_transaction_rec IS RECORD(
29 customer_trx_id NUMBER,
30 cust_trx_type_id NUMBER,
31 trx_class VARCHAR2(30),
32 trx_number VARCHAR2(30),
33 amount_settled NUMBER
34 );
35
36 TYPE open_transaction_tbl IS TABLE OF open_transaction_rec
37 INDEX BY BINARY_INTEGER;
38
39 TYPE claim_payment_method_rec IS RECORD(
40 payment_method VARCHAR2(30),
41 gl_date DATE,
42 wo_rec_trx_id NUMBER,
43 amount_settled NUMBER,
44 wo_adj_trx_id NUMBER --//Bug 5345095
45 );
46
47 TYPE claim_payment_method_tbl IS TABLE OF claim_payment_method_rec
48 INDEX BY BINARY_INTEGER;
49
50 ---------------------------------------------------------------------
51 -- PROCEDURE
52 -- Settle_Mass_Settlement
53 --
54 -- NOTES
55 --
56 -- HISTORY
57 -- 10-AUG-2001 mchang Create.
58 ---------------------------------------------------------------------
59 PROCEDURE Settle_Mass_Settlement(
60 p_api_version IN NUMBER
61 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
62 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
63 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68
69 ,p_group_claim_rec IN group_claim_rec
70 ,p_open_claim_tbl IN open_claim_tbl
71 ,p_open_transaction_tbl IN open_transaction_tbl
72 ,p_payment_method_tbl IN claim_payment_method_tbl
73
74 ,x_claim_group_id OUT NOCOPY NUMBER
75 ,x_claim_group_number OUT NOCOPY VARCHAR2
76 --,x_split_claim_tbl OUT NOCOPY open_claim_tbl
77 );
78 ---------------------------------------------------------------------
79
80
81 ---------------------------------------------------------------------
82 -- PROCEDURE
83 -- Start_Mass_Payment
84 --
85 -- NOTES
86 --
87 -- HISTORY
88 -- 10-AUG-2001 mchang Create.
89 ---------------------------------------------------------------------
90 PROCEDURE Start_Mass_Payment(
91 p_group_claim_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER
95 );
96 ---------------------------------------------------------------------
97
98 ---------------------------------------------------------------------
99 -- PROCEDURE
100 -- Start_Mass_Payment
101 --
102 -- NOTES
103 --
104 -- HISTORY
105 -- 17-FEB-2006 sshivali Create.
106 ---------------------------------------------------------------------
107 PROCEDURE Reject_Mass_Payment(
108 p_group_claim_id IN NUMBER,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER
112 );
113
114 ---------------------------------------------------------------------
115 END OZF_MASS_SETTLEMENT_PVT;