1 package pay_nl_bal_upload AUTHID CURRENT_USER as
2 /* $Header: pynlupld.pkh 115.1 2003/08/28 06:28 karajago noship $ */
3 -------------------------------------------------------------------------------
4 -- NAME
5 -- expiry_date
6 -- PURPOSE
7 -- Returns the expiry date of a given dimension relative to a date.
8 -- ARGUMENTS
9 -- p_upload_date - the date on which the balance should be correct.
10 -- p_dimension_name - the dimension being set.
11 -- p_assignment_id - the assignment involved.
12 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
13 -- USES
14 -- NOTES
15 -- This is used by pay_balance_upload.dim_expiry_date.
16 -----------------------------------------------------------------------------
17 --
18 function expiry_date
19 (
20 p_upload_date date,
21 p_dimension_name varchar2,
22 p_assignment_id number,
23 p_original_entry_id number
24 ) return date ;
25 --
26 -----------------------------------------------------------------------------
27 -- NAME
28 -- is_supported
29 -- PURPOSE
30 -- Checks if the dimension is supported by the upload process.
31 -- ARGUMENTS
32 -- p_dimension_name - the balance dimension to be checked.
33 -- USES
34 -- NOTES
35 -- This is used by pay_balance_upload.validate_dimension.
36 -----------------------------------------------------------------------------
37 --
38 function is_supported
39 (
40 p_dimension_name varchar2
41 ) return number ;
42 --
43 -----------------------------------------------------------------------------
44 -- NAME
45 -- include_adjustment
46 -- PURPOSE
47 -- Given a dimension, and relevant contexts and details of an existing
48 -- balanmce adjustment, it will find out if the balance adjustment effects
49 -- the dimension to be set. Both the dimension to be set and the adjustment
50 -- are for the same assignment and balance.
51 -- ARGUMENTS
52 -- p_balance_type_id - the balance to be set.
53 -- p_dimension_name - the balance dimension to be set.
54 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
55 -- p_bal_adjustment_rec - details of an existing balance adjustment.
56 -- USES
57 -- NOTES
58 -- This is used by pay_balance_upload.get_current_value.
59 -----------------------------------------------------------------------------
60 --
61 function include_adjustment
62 (
63 p_balance_type_id number,
64 p_dimension_name varchar2,
65 p_original_entry_id number,
66 p_upload_date date,
67 p_batch_line_id number,
68 p_test_batch_line_id number
69 ) return number ;
70 --
71 -----------------------------------------------------------------------------
72 -- NAME
73 -- validate_batch_lines
74 -- PURPOSE
75 -- Applies NL 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
84 (
85 p_batch_id number
86 );
87 --
88 end pay_nl_bal_upload;