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