1 package body pay_ch_bal_upload as
2 /* $Header: pychupld.pkb 115.0 99/07/17 05:52:36 porting ship $ */
3 /*
4 Copyright (c) Oracle Corporation 1995 All rights reserved
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pychupld.pkb
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 -- Date constants.
23 --
24 START_OF_TIME constant date := to_date('01/01/0001','DD/MM/YYYY');
25 END_OF_TIME constant date := to_date('31/12/4712','DD/MM/YYYY');
26 --
27 -----------------------------------------------------------------------------
28 -- NAME
29 -- expiry_date
30 -- PURPOSE
31 -- Returns the expiry date of a given dimension relative to a date.
32 -- ARGUMENTS
33 -- p_upload_date - the date on which the balance should be correct.
34 -- p_dimension_name - the dimension being set.
35 -- p_assignment_id - the assignment involved.
36 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
37 -- USES
38 -- NOTES
39 -- This is used by pay_balance_upload.dim_expiry_date.
40 -- If the expiry date cannot be derived then it is set to the end of time
41 -- to indicate that a failure has occured. The process that uses the
42 -- expiry date knows this rule and acts accordingly.
43 -----------------------------------------------------------------------------
44 --
45 function expiry_date
46 (
47 p_upload_date date
48 ,p_dimension_name varchar2
49 ,p_assignment_id number
50 ,p_original_entry_id number
51 ) return date is
52 --
53 -- Returns the date on which the assignment transferred payroll prior to
54 -- the upload date NB. the payroll is the one the assignment is assigned to
55 -- on the upload date.
56 --
57 l_expiry_date date;
58 --
59 begin
60 --
61 return (l_expiry_date);
62 --
63 end expiry_date;
64 --
65 -----------------------------------------------------------------------------
66 -- NAME
67 -- is_supported
68 -- PURPOSE
69 -- Checks if the dimension is supported by the upload process.
70 -- ARGUMENTS
71 -- p_dimension_name - the balance dimension to be checked.
72 -- USES
73 -- NOTES
74 -- Only a subset of the CH dimensions are supported.
75 -- This is used by pay_balance_upload.validate_dimension.
76 -----------------------------------------------------------------------------
77 --
78 function is_supported
79 (
80 p_dimension_name varchar2
81 ) return boolean is
82 begin
83 --
84 hr_utility.trace('Entering pay_ch_bal_upload.is_supported stub');
85 --
86 hr_utility.trace('Exiting pay_ch_bal_upload.is_supported stub');
87 --
88 return (TRUE);
89 --
90 end is_supported;
91 --
92 -----------------------------------------------------------------------------
93 -- NAME
94 -- include_adjustment
95 -- PURPOSE
96 -- Given a dimension, and relevant contexts and details of an existing
97 -- balanmce adjustment, it will find out if the balance adjustment effects
98 -- the dimension to be set. Both the dimension to be set and the adjustment
99 -- are for the same assignment and balance.
100 -- ARGUMENTS
101 -- p_balance_type_id - the balance to be set.
102 -- p_dimension_name - the balance dimension to be set.
103 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
104 -- p_bal_adjustment_rec - details of an existing balance adjustment.
105 -- USES
106 -- NOTES
107 -- This is used by pay_balance_upload.get_current_value.
108 -----------------------------------------------------------------------------
109 --
110 function include_adjustment
111 (
112 p_balance_type_id number
113 ,p_dimension_name varchar2
114 ,p_original_entry_id number
115 ,p_bal_adjustment_rec pay_balance_upload.csr_balance_adjustment%rowtype
116 ) return boolean is
117 --
118 begin
119 --
120 hr_utility.trace('Entering pay_ch_bal_upload.include_adjustment stub');
121 --
122 hr_utility.trace('Exiting pay_ch_bal_upload.include_adjustment stub');
123 --
124 return (TRUE);
125 --
126 end include_adjustment;
127 --
128 -----------------------------------------------------------------------------
129 -- NAME
130 -- validate_batch_lines
131 -- PURPOSE
132 -- Applies CH specific validation to the batch.
133 -- ARGUMENTS
134 -- p_batch_id - the batch to be validate_batch_linesd.
135 -- USES
136 -- NOTES
137 -- This is used by pay_balance_upload.validate_batch_lines.
138 -----------------------------------------------------------------------------
139 --
140 procedure validate_batch_lines
141 (
142 p_batch_id number
143 ) is
144 begin
145 --
146 hr_utility.trace('Entering pay_ch_bal_upload.validate_batch_lines stub');
147 --
148 hr_utility.trace('Exiting pay_ch_bal_upload.validate_batch_lines stub');
149 --
150 end validate_batch_lines;
151 --
152 end pay_ch_bal_upload;
[Home] [Help]