1 PACKAGE pay_es_bal_upload AUTHID CURRENT_USER AS
2 /* $Header: pyesbupl.pkh 120.1 2005/05/31 02:01 vbattu 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 (p_upload_date DATE
19 ,p_dimension_name VARCHAR2
20 ,p_assignment_id NUMBER
21 ,p_original_entry_id NUMBER) RETURN DATE ;
22 --
23 -----------------------------------------------------------------------------
24 -- NAME
25 -- is_supported
26 -- PURPOSE
27 -- Checks if the dimension is supported by the upload process.
28 -- ARGUMENTS
29 -- p_dimension_name - the balance dimension to be checked.
30 -- USES
31 -- NOTES
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 -- include_adjustment
40 -- PURPOSE
41 -- Given a dimension, and relevant contexts and details of an existing
42 -- balanmce adjustment, it will find out if the balance adjustment effects
43 -- the dimension to be set. Both the dimension to be set and the adjustment
44 -- are for the same assignment and balance.
45 -- ARGUMENTS
46 -- p_balance_type_id - the balance to be set.
47 -- p_dimension_name - the balance dimension to be set.
48 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
49 -- p_bal_adjustment_rec - details of an existing balance adjustment.
50 -- USES
51 -- NOTES
52 -- This is used by pay_balance_upload.get_current_value.
53 -----------------------------------------------------------------------------
54 --
55 FUNCTION include_adjustment(p_balance_type_id NUMBER
56 ,p_dimension_name VARCHAR2
57 ,p_original_entry_id NUMBER
58 ,p_upload_date DATE
59 ,p_batch_line_id NUMBER
60 ,p_test_batch_line_id NUMBER) RETURN NUMBER ;
61 --
62 -----------------------------------------------------------------------------
63 -- NAME
64 -- get_tax_unit
65 -- PURPOSE
66 -- Returns the legal company an assignment is associated with at
67 -- particular point in time.
68 -- ARGUMENTS
69 -- p_assignment_id - the assignment
70 -- p_effective_date - the date on which the information is required.
71 -- USES
72 -- NOTES
73 -----------------------------------------------------------------------------
74 --
75 FUNCTION get_tax_unit ( p_assignment_id NUMBER
76 ,p_effective_date DATE) RETURN NUMBER;
77 --
78 -----------------------------------------------------------------------------
79 -- NAME
80 -- validate_batch_lines
81 -- PURPOSE
82 -- Applies ES specific validation to the batch.
83 -- ARGUMENTS
84 -- p_batch_id - the batch to be validate_batch_linesd.
85 -- USES
86 -- NOTES
87 -- This is used by pay_balance_upload.validate_batch_lines.
88 -----------------------------------------------------------------------------
89 --
90 PROCEDURE validate_batch_lines (p_batch_id NUMBER);
91 --
92 END pay_es_bal_upload;