[Home] [Help]
PACKAGE: APPS.OZF_MASS_SETTLEMENT_PVT
Source
1 PACKAGE OZF_MASS_SETTLEMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvmsts.pls 120.4 2010/11/23 10:13:48 hbandi 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 comments varchar2(2000)
16 );
17
18
19 TYPE open_claim_rec IS RECORD(
20 claim_id NUMBER,
21 claim_class VARCHAR2(30),
22 claim_number VARCHAR2(30),
23 amount_settled NUMBER,
24 comments varchar2(2000)
25 );
26
27 TYPE open_claim_tbl IS TABLE OF open_claim_rec
28 INDEX BY BINARY_INTEGER;
29
30 TYPE open_transaction_rec IS RECORD(
31 customer_trx_id NUMBER,
32 cust_trx_type_id NUMBER,
33 trx_class VARCHAR2(30),
34 trx_number VARCHAR2(30),
35 amount_settled NUMBER
36 );
37
38 TYPE open_transaction_tbl IS TABLE OF open_transaction_rec
39 INDEX BY BINARY_INTEGER;
40
41 TYPE claim_payment_method_rec IS RECORD(
42 payment_method VARCHAR2(30),
43 gl_date DATE,
44 wo_rec_trx_id NUMBER,
45 amount_settled NUMBER,
46 wo_adj_trx_id NUMBER, --//Bug 5345095
47 comments varchar2(2000)
48 );
49
50 TYPE claim_payment_method_tbl IS TABLE OF claim_payment_method_rec
51 INDEX BY BINARY_INTEGER;
52
53 ---------------------------------------------------------------------
54 -- PROCEDURE
55 -- Settle_Mass_Settlement
56 --
57 -- NOTES
58 --
59 -- HISTORY
60 -- 10-AUG-2001 mchang Create.
61 ---------------------------------------------------------------------
62 PROCEDURE Settle_Mass_Settlement(
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
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71
72 ,p_group_claim_rec IN group_claim_rec
73 ,p_open_claim_tbl IN open_claim_tbl
74 ,p_open_transaction_tbl IN open_transaction_tbl
75 ,p_payment_method_tbl IN claim_payment_method_tbl
76
77 ,x_claim_group_id OUT NOCOPY NUMBER
78 ,x_claim_group_number OUT NOCOPY VARCHAR2
79 --,x_split_claim_tbl OUT NOCOPY open_claim_tbl
80 );
81 ---------------------------------------------------------------------
82
83
84 ---------------------------------------------------------------------
85 -- PROCEDURE
86 -- Start_Mass_Payment
87 --
88 -- NOTES
89 --
90 -- HISTORY
91 -- 10-AUG-2001 mchang Create.
92 ---------------------------------------------------------------------
93 PROCEDURE Start_Mass_Payment(
94 p_group_claim_id IN NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER
98 );
99 ---------------------------------------------------------------------
100
101 ---------------------------------------------------------------------
102 -- PROCEDURE
103 -- Start_Mass_Payment
104 --
105 -- NOTES
106 --
107 -- HISTORY
108 -- 17-FEB-2006 sshivali Create.
109 ---------------------------------------------------------------------
110 PROCEDURE Reject_Mass_Payment(
111 p_group_claim_id IN NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER
115 );
116
117 ---------------------------------------------------------------------
118 END OZF_MASS_SETTLEMENT_PVT;