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