[Home] [Help]
PACKAGE: APPS.CN_WKSHT_GET_PUB
Source
1 PACKAGE CN_wksht_get_pub AUTHID CURRENT_USER as
2 -- $Header: cnpwkgts.pls 115.20 2003/07/24 02:54:17 achung ship $
3
4 TYPE Wksht_rec IS RECORD
5 ( payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
6 salesrep_id cn_salesreps.salesrep_id%TYPE,
7 salesrep_name cn_salesreps.name%TYPE,
8 resource_id cn_salesreps.resource_id%TYPE,
9 employee_number cn_salesreps.employee_number%TYPE,
10 current_earnings NUMBER,
11 pmt_amount_earnings NUMBER,
12 pmt_amount_diff NUMBER,
13 pmt_amount_adj NUMBER,
14 pmt_amount_adj_rec NUMBER,
15 Pmt_amount_total NUMBER,
16 held_amount NUMBER,
17 worksheet_status cn_lookups.meaning%TYPE,
18 worksheet_status_code cn_lookups.lookup_code%TYPE,
19 Analyst_name cn_salesreps.assigned_to_user_name%TYPE,
20 object_version_number NUMBER,
21 view_notes VARCHAR2(1),
22 view_ced VARCHAR2(1),
23 status_by fnd_user.user_name%TYPE,
24 cost_center cn_salesreps.cost_center%TYPE,
25 charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE,
26 notes cn_lookups.meaning%TYPE
27 );
28
29 TYPE wksht_tbl IS TABLE OF wksht_rec INDEX BY BINARY_INTEGER;
30
31 --============================================================================
32 -- Start of Comments
33 --
34 -- API name : Get_srp_wksht
35 -- Type : Public.
36 -- Pre-reqs : None.
37 -- Usage : To get a salesreps's trx for a given payrun
38 -- Parameters :
39 -- IN : p_api_version IN NUMBER Require
40 -- p_init_msg_list IN VARCHAR2 Optional
41 -- Default = FND_API.G_FALSE
42 -- p_commit IN VARCHAR2 Optional
43 -- Default = FND_API.G_FALSE
44 -- p_validation_level IN NUMBER Optional
45 -- Default = FND_API.G_VALID_LEVEL_FULL
46 -- OUT : x_return_status OUT VARCHAR2(1)
47 -- x_msg_count OUT NUMBER
48 -- x_msg_data OUT VARCHAR2(2000)
49 -- IN : p_Payrun_id IN cn_payruns.id%TYPE
50 --
51 -- OUT : x_loading_status OUT
52 -- Detailed Error Message
53 -- Version : Current version 1.0
54 -- Initial version 1.0
55 --
56 -- End of comments
57 --============================================================================
58
59 PROCEDURE get_srp_wksht
60 (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2,
63 p_commit IN VARCHAR2,
64 p_validation_level IN NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_start_record IN NUMBER,
69 p_increment_count IN NUMBER,
70 p_payrun_id IN NUMBER,
71 p_salesrep_name IN VARCHAR2,
72 p_employee_number IN VARCHAR2,
73 p_analyst_name IN VARCHAR2,
74 p_my_analyst IN VARCHAR2,
75 p_unassigned IN VARCHAR2,
76 p_worksheet_status IN VARCHAR2,
77 p_currency_code IN VARCHAR2,
78 p_order_by IN VARCHAR2,
79 x_wksht_tbl OUT NOCOPY wksht_tbl,
80 x_tot_amount_earnings OUT NOCOPY NUMBER,
81 x_tot_amount_adj OUT NOCOPY NUMBER,
82 x_tot_amount_adj_rec OUT NOCOPY NUMBER,
83 x_tot_amount_total OUT NOCOPY NUMBER,
84 x_tot_held_amount OUT NOCOPY NUMBER,
85 x_tot_ced OUT NOCOPY NUMBER,
86 x_tot_earn_diff OUT NOCOPY NUMBER,
87 x_total_records OUT NOCOPY NUMBER
88 );
89 END CN_wksht_get_pub;