1 package pay_kw_bal_upload as
2 -- $Header: pykwbaup.pkh 120.0 2006/04/09 23:42:53 adevanat noship $
3 --
4 -- Copyright (c) 1999 Oracle Corporation
5 -- All rights reserved
6 --
7 -- Date Author Bug/CR Num Notes
8 -- -----------+--------+----------+-----------------------------------------
9 -- 15-Feb-06 Anand MD Initial Version
10 --
11 -------------------------------------------------------------------------------
12 -- NAME
13 -- expiry_date
14 -- PURPOSE
15 -- Returns the expiry date of a given dimension relative to a date.
16 -- ARGUMENTS
17 -- p_upload_date - the date on which the balance should be correct.
18 -- p_dimension_name - the dimension being set.
19 -- p_assignment_id - the assignment involved.
20 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
21 -- USES
22 -- NOTES
23 -- This is used by pay_balance_upload.dim_expiry_date.
24 -----------------------------------------------------------------------------
25 --
26 function expiry_date
27 (
28 p_upload_date date,
29 p_dimension_name varchar2,
30 p_assignment_id number,
31 p_original_entry_id number
32 ) return date ;
33
34 -----------------------------------------------------------------------------
35 -- NAME
36 -- is_supported
37 -- PURPOSE
38 -- Checks if the dimension is supported by the upload process.
39 -- ARGUMENTS
40 -- p_dimension_name - the balance dimension to be checked.
41 -- USES
42 -- NOTES
43 -- Only a subset of the SG dimensions are supported and these have been
44 -- picked to allow effective migration to release 10.
45 -- This is used by pay_balance_upload.validate_dimension.
46 -----------------------------------------------------------------------------
47 --
48 function is_supported
49 (
50 p_dimension_name varchar2
51 ) return number;
52 --
53 -----------------------------------------------------------------------------
54 -- NAME
55 -- include_adjustment
56 -- PURPOSE
57 -- Given a dimension, and relevant contexts and details of an existing
58 -- balanmce adjustment, it will find out if the balance adjustment effects
59 -- the dimension to be set. Both the dimension to be set and the adjustment
60 -- are for the same assignment and balance.
61 -- ARGUMENTS
62 -- p_balance_type_id - the balance to be set.
63 -- p_dimension_name - the balance dimension to be set.
64 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
65 -- p_bal_adjustment_rec - details of an existing balance adjustment.
66 -- USES
67 -- NOTES
68 -- This is used by pay_balance_upload.get_current_value.
69 -----------------------------------------------------------------------------
70 --
71 function include_adjustment
72 (
73 p_balance_type_id number,
74 p_dimension_name varchar2,
75 p_original_entry_id number,
76 p_upload_date date,
77 p_batch_line_id number,
78 p_test_batch_line_id number
79 ) return number ;
80 --
81 -----------------------------------------------------------------------------
82 -- name
83 -- validate_batch_lines
84 -- purpose
85 -- applies bf specific validation to the batch.
86 -- arguments
87 -- p_batch_id - the batch to be validate_batch_linesd.
88 -- uses
89 -- notes
90 -- this is used by pay_balance_upload.validate_batch_lines.
91 -----------------------------------------------------------------------------
92 --
93 procedure validate_batch_lines ( p_batch_id number );
94 --
95 end pay_kw_bal_upload;