1 package PAY_PAYWSLEE_PKG AUTHID CURRENT_USER as
2 /* $Header: paywslee.pkh 120.0.12020000.1 2012/06/28 16:39:42 appldev ship $ */
3 --
4 --type SevTabType IS TABLE OF PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE
5 type SevTabType IS TABLE OF VARCHAR2(80)
6 index by binary_integer;
7 type UomTabType IS TABLE OF PAY_INPUT_VALUES_F.UOM%TYPE
8 index by binary_integer;
9 type IvnTabType IS TABLE OF PAY_INPUT_VALUES_F.NAME%TYPE
10 index by binary_integer;
11 --
12 procedure get_input_value_names (
13 --
14 p_element_type_id in number,
15 p_name1 in out nocopy varchar2,
16 p_name2 in out nocopy varchar2,
17 p_name3 in out nocopy varchar2,
18 p_name4 in out nocopy varchar2,
19 p_name5 in out nocopy varchar2,
20 p_name6 in out nocopy varchar2,
21 p_name7 in out nocopy varchar2,
22 p_name8 in out nocopy varchar2,
23 p_name9 in out nocopy varchar2,
24 p_name10 in out nocopy varchar2,
25 p_name11 in out nocopy varchar2,
26 p_name12 in out nocopy varchar2,
27 p_name13 in out nocopy varchar2,
28 p_name14 in out nocopy varchar2,
29 p_name15 in out nocopy varchar2);
30 --
31 procedure get_input_value_names (
32 p_rows in out nocopy number,
33 p_element_type_id in number,
34 p_ivn_tab in out nocopy IvnTabType);
35 --
36 procedure get_entry_details (
37 --
38 p_element_entry_id in number,
39 p_element_link_id in number,
40 p_assignment_id in number,
41 p_effective_end_date in date,
42 p_full_name in out nocopy varchar2,
43 p_assignment_number in out nocopy varchar2,
44 p_screen_entry_value1 in out nocopy varchar2,
45 p_screen_entry_value2 in out nocopy varchar2,
46 p_screen_entry_value3 in out nocopy varchar2,
47 p_screen_entry_value4 in out nocopy varchar2,
48 p_screen_entry_value5 in out nocopy varchar2,
49 p_screen_entry_value6 in out nocopy varchar2,
50 p_screen_entry_value7 in out nocopy varchar2,
51 p_screen_entry_value8 in out nocopy varchar2,
52 p_screen_entry_value9 in out nocopy varchar2,
53 p_screen_entry_value10 in out nocopy varchar2,
54 p_screen_entry_value11 in out nocopy varchar2,
55 p_screen_entry_value12 in out nocopy varchar2,
56 p_screen_entry_value13 in out nocopy varchar2,
57 p_screen_entry_value14 in out nocopy varchar2,
58 p_screen_entry_value15 in out nocopy varchar2,
59 p_uom1 in out nocopy varchar2,
60 p_uom2 in out nocopy varchar2,
61 p_uom3 in out nocopy varchar2,
62 p_uom4 in out nocopy varchar2,
63 p_uom5 in out nocopy varchar2,
64 p_uom6 in out nocopy varchar2,
65 p_uom7 in out nocopy varchar2,
66 p_uom8 in out nocopy varchar2,
67 p_uom9 in out nocopy varchar2,
68 p_uom10 in out nocopy varchar2,
69 p_uom11 in out nocopy varchar2,
70 p_uom12 in out nocopy varchar2,
71 p_uom13 in out nocopy varchar2,
72 p_uom14 in out nocopy varchar2,
73 p_uom15 in out nocopy varchar2);
74 --
75 procedure get_entry_details (
76 --
77 p_rows in out nocopy number,
78 p_element_entry_id in number,
79 p_element_link_id in number,
80 p_assignment_id in number,
81 p_effective_end_date in date,
82 p_full_name in out nocopy varchar2,
83 p_assignment_number in out nocopy varchar2,
84 p_entry_value_tab in out nocopy SevTabType,
85 p_uom_tab in out nocopy UomTabType);
86 --
87 end PAY_PAYWSLEE_PKG;