1 package pay_ch_bal_upload AUTHID CURRENT_USER as
2 /* $Header: pychupld.pkh 115.0 99/07/17 05:52:39 porting ship $ */
3 /*
4 Copyright (c) Oracle Corporation 1995 All rights reserved
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pychupld.pkh
9 DESCRIPTION
10 Stub File.
11 Provides support for the upload of balances based on CH dimensions.
12 EXTERNAL
13 expiry_date
14 include_adjustment
15 is_supported
16 validate_batch_lines
17 INTERNAL
18 MODIFIED (DD-MON-YYYY)
19 110.0 A.Logue 11-Jul-1997 created.
20 */
21 --
22 -----------------------------------------------------------------------------
23 -- NAME
24 -- expiry_date
25 -- PURPOSE
26 -- Returns the expiry date of a given dimension relative to a date.
27 -- ARGUMENTS
28 -- p_upload_date - the date on which the balance should be correct.
29 -- p_dimension_name - the dimension being set.
30 -- p_assignment_id - the assignment involved.
31 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
32 -- USES
33 -- NOTES
34 -- This is used by pay_balance_upload.dim_expiry_date.
35 -----------------------------------------------------------------------------
36 --
37 function expiry_date
38 (
39 p_upload_date date
40 ,p_dimension_name varchar2
41 ,p_assignment_id number
42 ,p_original_entry_id number
43 ) return date;
44 --
45 pragma restrict_references(expiry_date, WNDS, WNPS);
46 --
47 -----------------------------------------------------------------------------
48 -- NAME
49 -- is_supported
50 -- PURPOSE
51 -- Checks if the dimension is supported by the upload process.
52 -- ARGUMENTS
53 -- p_dimension_name - the balance dimension to be checked.
54 -- USES
55 -- NOTES
56 -- Only a subset of the CH dimensions are supported.
57 -- This is used by pay_balance_upload.validate_dimension.
58 -----------------------------------------------------------------------------
59 --
60 function is_supported
61 (
62 p_dimension_name varchar2
63 ) return boolean;
64 --
65 -----------------------------------------------------------------------------
66 -- NAME
67 -- include_adjustment
68 -- PURPOSE
69 -- Given a dimension, and relevant contexts and details of an existing
70 -- balanmce adjustment, it will find out if the balance adjustment effects
71 -- the dimension to be set. Both the dimension to be set and the adjustment
72 -- are for the same assignment and balance.
73 -- ARGUMENTS
74 -- p_balance_type_id - the balance to be set.
75 -- p_dimension_name - the balance dimension to be set.
76 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
77 -- p_bal_adjustment_rec - details of an existing balance adjustment.
78 -- USES
79 -- NOTES
80 -- This is used by pay_balance_upload.get_current_value.
81 -----------------------------------------------------------------------------
82 --
83 function include_adjustment
84 (
85 p_balance_type_id number
86 ,p_dimension_name varchar2
87 ,p_original_entry_id number
88 ,p_bal_adjustment_rec pay_balance_upload.csr_balance_adjustment%rowtype
89 ) return boolean;
90 --
91 -----------------------------------------------------------------------------
92 -- NAME
93 -- validate_batch_lines
94 -- PURPOSE
95 -- Applies CH specific validation to the batch.
96 -- ARGUMENTS
97 -- p_batch_id - the batch to be validate_batch_linesd.
98 -- USES
99 -- NOTES
100 -- This is used by pay_balance_upload.validate_batch_lines.
101 -----------------------------------------------------------------------------
102 --
103 procedure validate_batch_lines
104 (
105 p_batch_id number
106 );
107 --
108 end pay_ch_bal_upload;