1 package pay_uk_bal_upload AUTHID CURRENT_USER as
2 /* $Header: pyukupld.pkh 115.2 2004/02/06 07:58:55 amills ship $ */
3 /*
4 Copyright (c) Oracle Corporation 1995 All rights reserved
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pyukupld.pkh
9 DESCRIPTION
10 Provides support for the upload of balances based on UK dimensions.
11 EXTERNAL
12 expiry_date
13 include_adjustment
14 is_supported
15 validate_batch_lines
16 INTERNAL
17 MODIFIED (DD-MON-YYYY)
18 40.0 J.S.Hobbs 16-May-1995 created.
19 40.1 J.M.ALLOUN 30-JUL-1996 Added error handling.
20 40.6 N.Bristow 18-DEC-1996 Header comment was not properly
21 commentted out.
22 115.1 A.Mills 25-JUN-2003 Added dbdrv commands.
23 115.2 A.Mills 06-FEB-2004 Removed pragma R.R. on expiry_date
24 */
25 --
26 -----------------------------------------------------------------------------
27 -- NAME
28 -- expiry_date
29 -- PURPOSE
30 -- Returns the expiry date of a given dimension relative to a date.
31 -- ARGUMENTS
32 -- p_upload_date - the date on which the balance should be correct.
33 -- p_dimension_name - the dimension being set.
34 -- p_assignment_id - the assignment involved.
35 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
36 -- USES
37 -- NOTES
38 -- This is used by pay_balance_upload.dim_expiry_date.
39 -----------------------------------------------------------------------------
40 --
41 function expiry_date
42 (
43 p_upload_date date
44 ,p_dimension_name varchar2
45 ,p_assignment_id number
46 ,p_original_entry_id number
47 ) return date;
48 --
49 --
50 -----------------------------------------------------------------------------
51 -- NAME
52 -- is_supported
53 -- PURPOSE
54 -- Checks if the dimension is supported by the upload process.
55 -- ARGUMENTS
56 -- p_dimension_name - the balance dimension to be checked.
57 -- USES
58 -- NOTES
59 -- Only a subset of the UK dimensions are supported and these have been
60 -- picked to allow effective migration to release 10.
61 -- This is used by pay_balance_upload.validate_dimension.
62 -----------------------------------------------------------------------------
63 --
64 function is_supported
65 (
66 p_dimension_name varchar2
67 ) return boolean;
68 --
69 -----------------------------------------------------------------------------
70 -- NAME
71 -- include_adjustment
72 -- PURPOSE
73 -- Given a dimension, and relevant contexts and details of an existing
74 -- balanmce adjustment, it will find out if the balance adjustment effects
75 -- the dimension to be set. Both the dimension to be set and the adjustment
76 -- are for the same assignment and balance.
77 -- ARGUMENTS
78 -- p_balance_type_id - the balance to be set.
79 -- p_dimension_name - the balance dimension to be set.
80 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
81 -- p_bal_adjustment_rec - details of an existing balance adjustment.
82 -- USES
83 -- NOTES
84 -- This is used by pay_balance_upload.get_current_value.
85 -----------------------------------------------------------------------------
86 --
87 function include_adjustment
88 (
89 p_balance_type_id number
90 ,p_dimension_name varchar2
91 ,p_original_entry_id number
92 ,p_bal_adjustment_rec pay_balance_upload.csr_balance_adjustment%rowtype
93 ) return boolean;
94 --
95 -----------------------------------------------------------------------------
96 -- NAME
97 -- validate_batch_lines
98 -- PURPOSE
99 -- Applies UK specific validation to the batch.
100 -- ARGUMENTS
101 -- p_batch_id - the batch to be validate_batch_linesd.
102 -- USES
103 -- NOTES
104 -- This is used by pay_balance_upload.validate_batch_lines.
105 -----------------------------------------------------------------------------
106 --
107 procedure validate_batch_lines
108 (
109 p_batch_id number
110 );
111 --
112 end pay_uk_bal_upload;