DBA Data[Home] [Help]

PACKAGE: APPS.PAY_UK_ELE_ENTRIES_PKG

Source


1 PACKAGE PAY_UK_ELE_ENTRIES_PKG AUTHID CURRENT_USER as
2 /* $Header: pygbeent.pkh 120.0.12010000.1 2008/07/27 22:43:48 appldev ship $ */
3 --
4 /*  +=======================================================================+
5     |           Copyright (c) 1993 Oracle Corporation                       |
6     |              Redwood Shores, California, USA                          |
7     |                   All rights reserved.                                |
8     +=======================================================================+
9   Name
10     pay_uk_ele_entries_pkg
11   Purpose
12     Supports the PAYE block in the NI block in the form PAYGBTAX.
13 
14 Notes
15 
16   History
17     19-AUG-94  H.Minton   40.0         Date created.
18     14-JAN-97  T.Inekuku  40.5         Included new I. Value in update to
19                                        NI procedure.
20     06-OCT-00  G.Butler   115.1	       Updated parameters in update_paye_entries
21     				       procedure to include x_entry_information1
22     				       ,x_entry_information2 and x_entry_information_category
23     10-Jun-02  K.Thampan  115.2        Add dbdrv command
24     24-Jan-03  M.Ahmad    115.3        Added NOCOPY
25 ============================================================================*/
26 --
27 -----------------------------------------------------------------------------
28 -- Name                                                                    --
29 --   update_paye_entries                                                   --
30 -- Purpose                                                                 --
31 --   calls the hr_element_entry_api to perform updates to the PAYE element.--
32 -----------------------------------------------------------------------------
33 --
34 PROCEDURE update_paye_entries(
35                             x_dt_update_mode     varchar2,
36                             x_session_date       date,
37                             x_element_entry_id   number,
38                             x_input_value_id1    number,
39                             x_entry_value1       varchar2,
40                             x_input_value_id2    number,
41                             x_entry_value2       varchar2,
42                             x_input_value_id4    number,
43                             x_entry_value4       varchar2,
44                             x_input_value_id5    number,
45                             x_entry_value5       varchar2,
46                             x_input_value_id3    number,
47                             x_entry_value3       varchar2,
48                             x_input_value_id6    number,
49                             x_entry_value6       varchar2,
50                             x_entry_information1 varchar2,
51                             x_entry_information2 varchar2,
52                             x_entry_information_category varchar2,
53                             p_effective_end_date in out nocopy date);
54 -----------------------------------------------------------------------------
55 -- Name                                                                    --
56 --   get_paye_formula_id                                                   --
57 -- Purpose                                                                 --
58 --   this function finds the formula id for the validation of the PAYE     --
59 --   tax_code element entry value.
60 -----------------------------------------------------------------------------
61 --
62 FUNCTION get_paye_formula_id RETURN NUMBER;
63 -----------------------------------------------------------------------------
64 --
65 -----------------------------------------------------------------------------
66 -- Name                                                                    --
67 --   update_ni_entries                                                     --
68 -- Purpose                                                                 --
69 --   calls the hr_element_entry_api to perform updates to the NI element.  --
70 -----------------------------------------------------------------------------
71 --
72 PROCEDURE update_ni_entries(
73                             x_dt_update_mode     varchar2,
74                             x_session_date       date,
75                             x_element_entry_id   number,
76                             x_input_value_id1    number,
77                             x_entry_value1       varchar2,
78                             x_input_value_id2    number,
79                             x_entry_value2       varchar2,
80                             x_input_value_id3    number,
81                             x_entry_value3       varchar2,
82                             x_input_value_id4    number,
83                             x_entry_value4       varchar2,
84                             x_input_value_id5    number,
85                             x_entry_value5       varchar2,
86                             x_input_value_id6    number,
87                             x_entry_value6       varchar2,
88                             x_input_value_id7    number,
89                             x_entry_value7       varchar2,
90                             x_input_value_id8    number,
91                             x_entry_value8       varchar2,
92                             p_effective_end_date in out nocopy date);
93 
94 -------------------------------------------------------------------------------
95 end PAY_UK_ELE_ENTRIES_PKG;