1 PACKAGE CN_GET_COMM_PMT_PAID_GRP AS
2 -- $Header: cnggcpps.pls 120.0 2005/08/08 00:16:34 appldev noship $
3
4 -- -------------------------------------------------------------------------+
5 -- Get the compensation earned and compensation paid from OIC.
6 -- -------------------------------------------------------------------------+
7 -- Start of comments
8 -- API name : get_comm_and_paid_pmt
9 -- Type : Group.
10 -- Function :
11 -- Pre-reqs : None.
12 -- Parameters :
13 -- IN : p_api_version IN NUMBER Required
14 -- p_init_msg_list IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_validation_level IN NUMBER Optional
17 -- Default = FND_API.G_VALID_LEVEL_FULL
18 -- p_person_id IN NUMBER Required
19 -- p_start_date IN DATE Required
20 -- p_end_date IN DATE Required
21 -- p_target_currency_code IN VARCHAR2 Required
22 -- p_proration_flag IN VARCHAR2 Optional
23 --
24 -- OUT : x_return_status OUT VARCHAR2(1)
25 -- x_msg_count OUT NUMBER
26 -- x_msg_data OUT VARCHAR2(2000)
27 -- x_comp_earned OUT NUMBER
28 -- x_comp_paid OUT NUMBER
29 -- x_new_start_date OUT DATE
30 -- x_new_end_date OUT DATE
31 --
32 -- Version : Current version 1.0
33 --
34 -- Notes : Note text
35 --
36 -- End of comments
37 PROCEDURE get_comm_and_paid_pmt
38 (
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
42 p_person_id IN NUMBER,
43 p_start_date IN DATE,
44 p_end_date IN DATE,
45 p_target_currency_code IN VARCHAR2,
46 p_proration_flag IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_comp_earned OUT NOCOPY NUMBER,
51 x_comp_paid OUT NOCOPY NUMBER,
52 x_new_start_date OUT NOCOPY Date,
53 x_new_end_date OUT NOCOPY Date
54 );
55
56 END CN_GET_COMM_PMT_PAID_GRP;