1 PACKAGE pay_fi_bal_upload AUTHID CURRENT_USER AS
2 /* $Header: pyfibupl.pkh 120.0.12000000.1 2007/04/26 11:46:46 dbehera 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 (p_upload_date IN DATE,
20 p_dimension_name IN VARCHAR2,
21 p_assignment_id IN NUMBER,
22 p_original_entry_id IN NUMBER)
23 RETURN DATE ;
24 --
25 -----------------------------------------------------------------------------
26 -- NAME
27 -- is_supported
28 -- PURPOSE
29 -- Checks if the dimension is supported by the upload process.
30 -- ARGUMENTS
31 -- p_dimension_name - the balance dimension to be checked.
32 -- USES
33 -- NOTES
34 -- This is used by pay_balance_upload.validate_dimension.
35 -----------------------------------------------------------------------------
36 --
37 FUNCTION is_supported (p_dimension_name VARCHAR2) RETURN NUMBER ;
38 --
39 -----------------------------------------------------------------------------
40 -- NAME
41 -- include_adjustment
42 -- PURPOSE
43 -- Given a dimension, and relevant contexts and details of an existing
44 -- balanmce adjustment, it will find out if the balance adjustment effects
45 -- the dimension to be set. Both the dimension to be set and the adjustment
46 -- are for the same assignment and balance.
47 -- ARGUMENTS
48 -- p_balance_type_id - the balance to be set.
49 -- p_dimension_name - the balance dimension to be set.
50 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
51 -- USES
52 -- NOTES
53 -- This is used by pay_balance_upload.get_current_value.
54 -----------------------------------------------------------------------------
55 --
56 FUNCTION include_adjustment
57 (
58 p_balance_type_id NUMBER
59 ,p_dimension_name VARCHAR2
60 ,p_original_entry_id NUMBER
61 ,p_upload_date DATE
62 ,p_batch_line_id NUMBER
63 ,p_test_batch_line_id NUMBER
64 ) RETURN NUMBER ;
65 --
66 -----------------------------------------------------------------------------
67 -- NAME
68 -- validate_batch_lines
69 -- PURPOSE
70 -- Applies ES specific validation to the batch.
71 -- ARGUMENTS
72 -- p_batch_id - the batch to be validate_batch_linesd.
73 -- USES
74 -- NOTES
75 -- This is used by pay_balance_upload.validate_batch_lines.
76 -----------------------------------------------------------------------------
77 --
78 PROCEDURE validate_batch_lines (p_batch_id NUMBER);
79 --
80 END pay_fi_bal_upload;