1 package pay_nz_bal_upload AUTHID CURRENT_USER as
2 /* $Header: pynzbaup.pkh 120.1 2008/07/16 10:11:40 vamittal noship $ */
3 --
4 -- Change List
5 -- ----------
6 -- DATE Name Vers Bug No Description
7 -- -----------+---------------+--------+--------+--------------------+
8 -- 13-Aug-1999 sclarke 1.0 Created
9 -- 22-Jun-2000 sclarke 1336508 remove pragmas from expiry_date
10 -- 12-Jun-2001 apunekar 1818152 Added parameter p_test_batch_line_id to function include_adjustment
11 -- -----------+---------------+--------+--------+--------------------+
12 --
13 function expiry_date
14 ( p_upload_date date
15 , p_dimension_name varchar2
16 , p_assignment_id number
17 , p_original_entry_id number
18 )
19 return date;
20 --
21 -----------------------------------------------------------------------------
22 -- name
23 -- is_supported
24 -- purpose
25 -- checks if the dimension is supported by the upload process.
26 -- arguments
27 -- p_dimension_name - the balance dimension to be checked.
28 -- uses
29 -- notes
30 -- only a subset of the bf dimensions are supported and these have been
31 -- picked to allow effective migration to release 10.
32 -- this is used by pay_balance_upload.validate_dimension.
33 -----------------------------------------------------------------------------
34 --
35 function is_supported( p_dimension_name varchar2 ) return number;
36 --
37 -----------------------------------------------------------------------------
38 -- name
39
40 -- include_adjustment
41 -- purpose
42 -- given a dimension, and relevant contexts and details of an existing
43 -- balanmce adjustment, it will find out if the balance adjustment effects
44 -- the dimension to be set. both the dimension to be set and the adjustment
45 -- are for the same assignment and balance. the adjustment also lies between
46 -- the expiry date of the new balance and the date on which it is to set.
47 -- arguments
48 -- p_balance_type_id - the balance to be set.
49 -- p_dimension_name - the balance dimension to be set.
50 -- p_tax_unit_id - tax_unit_id context.
51 -- p_jurisdiction_code - jurisdiction_code context.
52 -- p_original_entry_id - original_entry_id context.
53 -- p_bal_adjustment_rec - details of an existing balance adjustment.
54 -- uses
55 -- notes
56 -- all the bf dimensions affect each other when they share the same context
57 -- values so there is no special support required for individual dimensions.
58 -- this is used by pay_balance_upload.get_current_value.
59 -----------------------------------------------------------------------------
60 --
61 function include_adjustment
62 ( p_balance_type_id number
63 , p_dimension_name varchar2
64 , p_original_entry_id number
65 , p_upload_date date
66 , p_batch_line_id number
67 , p_test_batch_line_id number
68 )
69 return number;
70 --
71 -----------------------------------------------------------------------------
72 -- name
73 -- validate_batch_lines
74 -- purpose
75 -- applies bf specific validation to the batch.
76 -- arguments
77 -- p_batch_id - the batch to be validate_batch_linesd.
78 -- uses
79 -- notes
80 -- this is used by pay_balance_upload.validate_batch_lines.
81 -----------------------------------------------------------------------------
82 --
83 procedure validate_batch_lines ( p_batch_id number );
84 --
85 end pay_nz_bal_upload;