1 package pay_jp_bal_upload as
2 /* $Header: pyjpupld.pkh 120.1 2006/04/24 00:53:56 ttagawa noship $ */
3 /*
4 Copyright (c) Oracle Corporation 1995 All rights reserved
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pyjpupld.pkh
9 DESCRIPTION
10 Stub File.
11 Provides support for the upload of balances based on JP 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 115.1 Keyazawa 12-OCT-1999 Remove the pragma.
21 115.2 Ttagawa 18-OCT-2002 dbdrv added.
22 115.3 ttagawa 21-Apr-2006 "in" added to input parameters.
23 */
24 --
25 -----------------------------------------------------------------------------
26 -- NAME
27 -- expiry_date
28 -- PURPOSE
29 -- Returns the expiry date of a given dimension relative to a date.
30 -- ARGUMENTS
31 -- p_upload_date - the date on which the balance should be correct.
32 -- p_dimension_name - the dimension being set.
33 -- p_assignment_id - the assignment involved.
34 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
35 -- USES
36 -- NOTES
37 -- This is used by pay_balance_upload.dim_expiry_date.
38 -----------------------------------------------------------------------------
39 --
40 function expiry_date
41 (
42 p_upload_date in date
43 ,p_dimension_name in varchar2
44 ,p_assignment_id in number
45 ,p_original_entry_id in number
46 ) return date;
47 --
48 -- pragma restrict_references(expiry_date, WNDS, WNPS);
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 JP dimensions are supported.
60 -- This is used by pay_balance_upload.validate_dimension.
61 -----------------------------------------------------------------------------
62 --
63 function is_supported
64 (
65 p_dimension_name in varchar2
66 ) return boolean;
67 --
68 -----------------------------------------------------------------------------
69 -- NAME
70 -- include_adjustment
71 -- PURPOSE
72 -- Given a dimension, and relevant contexts and details of an existing
73 -- balanmce adjustment, it will find out if the balance adjustment effects
74 -- the dimension to be set. Both the dimension to be set and the adjustment
75 -- are for the same assignment and balance.
76 -- ARGUMENTS
77 -- p_balance_type_id - the balance to be set.
78 -- p_dimension_name - the balance dimension to be set.
79 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
80 -- p_bal_adjustment_rec - details of an existing balance adjustment.
81 -- USES
82 -- NOTES
83 -- This is used by pay_balance_upload.get_current_value.
84 -----------------------------------------------------------------------------
85 --
86 function include_adjustment
87 (
88 p_balance_type_id in number
89 ,p_dimension_name in varchar2
90 ,p_original_entry_id in number
91 ,p_bal_adjustment_rec in pay_balance_upload.csr_balance_adjustment%rowtype
92 ) return boolean;
93 --
94 -----------------------------------------------------------------------------
95 -- NAME
96 -- validate_batch_lines
97 -- PURPOSE
98 -- Applies JP specific validation to the batch.
99 -- ARGUMENTS
100 -- p_batch_id - the batch to be validate_batch_linesd.
101 -- USES
102 -- NOTES
103 -- This is used by pay_balance_upload.validate_batch_lines.
104 -----------------------------------------------------------------------------
105 --
106 procedure validate_batch_lines
107 (
108 p_batch_id in number
109 );
110 --
111 end pay_jp_bal_upload;