1 package pay_fr_bal_upload AUTHID CURRENT_USER as
2 /* $Header: pyfrupld.pkh 120.0 2005/05/29 05:12 appldev 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 (in caps).
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 (in caps).
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 -- validate_batch_lines
46 -- PURPOSE
47 -- Applies FR specific validation to the batch.
48 -- ARGUMENTS
49 -- p_batch_id - the batch to be validated.
50 -- USES
51 -- NOTES
52 -- This is used by pay_balance_upload.validate_batch_lines.
53 -----------------------------------------------------------------------------
54 --
55 procedure validate_batch_lines
56 (
57 p_batch_id number
58 );
59 --
60 -----------------------------------------------------------------------------
61 -- NAME
62 -- create_structure
63 -- PURPOSE
64 -- Creates the structure for Balance Upload
65 -- ARGUMENTS
66 -- p_batch_id - the batch for which a structure needs to be generated
67 -- NOTES
68 -- This is called from the SRS
69 -----------------------------------------------------------------------------
70 --
71 procedure create_structure(p_business_group_id in number,
72 p_batch_id in number);
73 --
74 procedure create_structure(
75 errbuf out NOCOPY varchar2,
76 retcode out NOCOPY number,
77 p_business_group_id in number,
78 p_batch_id in number);
79 end pay_fr_bal_upload;