1 package pay_za_bal_upload as
2 /* $Header: pyzaupld.pkh 120.4 2005/07/04 03:07:16 kapalani 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 function expiry_date
18 (
19 p_upload_date date,
20 p_dimension_name varchar2,
21 p_assignment_id number,
22 p_original_entry_id number
23 ) return date;
24 pragma restrict_references(expiry_date, WNDS, WNPS);
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 -- Only a subset of the ZA dimensions are supported.
36 -- This is used by pay_balance_upload.validate_dimension.
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 -- balance 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 -- p_test_batch_line_id -
57 -- USES
58 -- NOTES
59 -- This is used by pay_balance_upload.get_current_value.
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 ZA 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 procedure validate_batch_lines
83 (
84 p_batch_id number
85 );
86
87 end pay_za_bal_upload;