1 PACKAGE pay_ca_bal_upload AUTHID CURRENT_USER AS
2 /* $Header: pycaupld.pkh 115.2 2003/03/28 01:41:49 pganguly ship $ */
3 /*
4 Copyright (c) Oracle Corporation 1995 All rights reserved
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pycaupld.pkh
9 DESCRIPTION
10 Provides support for the upload of balances based on CA dimensions.
11 EXTERNAL
12 expiry_date
13 include_adjustment
14 is_supported
15 validate_batch_lines
16 INTERNAL
17 MODIFIED (DD-MON-YYYY)
18 110.0 A.Logue 11-Jul-1997 created.
19 115.1 JARTHURT 31-JUL-2000 Added addition context level support
20 parameters.
21 115.2 P.Ganguly 27-MAR-2003 Added set verify off, dbdrv for GSCC
22 */
23 --
24 -----------------------------------------------------------------------------
25 -- NAME
26 -- expiry_date
27 -- PURPOSE
28 -- Returns the expiry date of a given dimension relative to a date.
29 -- ARGUMENTS
30 -- p_upload_date - the date on which the balance should be correct.
31 -- p_dimension_name - the dimension being set.
32 -- p_assignment_id - the assignment involved.
33 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
34 -- USES
35 -- NOTES
36 -- This is used by pay_balance_upload.dim_expiry_date.
37 -----------------------------------------------------------------------------
38 --
39 function expiry_date
40 (
41 p_upload_date date
42 ,p_dimension_name varchar2
43 ,p_assignment_id number
44 ,p_original_entry_id number
45 ) return date;
46 --
47 pragma restrict_references(expiry_date, WNDS, WNPS);
48 --
49 -----------------------------------------------------------------------------
50 -- NAME
51 -- is_supported
52 -- PURPOSE
53 -- Checks if the dimension is supported by the upload process.
54 -- ARGUMENTS
55 -- p_dimension_name - the balance dimension to be checked.
56 -- USES
57 -- NOTES
58 -- Only a subset of the CA dimensions are supported.
59 -- This is used by pay_balance_upload.validate_dimension.
60 -----------------------------------------------------------------------------
61 --
62 function is_supported
63 (
64 p_dimension_name varchar2
65 ) return number;
66 --
67 -----------------------------------------------------------------------------
68 -- NAME
69 -- include_adjustment
70 -- PURPOSE
71 -- Given a dimension, and relevant contexts and details of an existing
72 -- balanmce adjustment, it will find out if the balance adjustment effects
73 -- the dimension to be set. Both the dimension to be set and the adjustment
74 -- are for the same assignment and balance.
75 -- ARGUMENTS
76 -- p_balance_type_id - the balance to be set.
77 -- p_dimension_name - the balance dimension to be set.
78 -- p_jurisdiction_code - JURISDICTION_CODE context
79 -- p_original_entry_id - ORIGINAL_ENTRY_ID context.
80 -- p_upload_date -
81 -- p_batch_line_id -
82 -- p_test_batch_line_id -
83 -- USES
84 -- NOTES
85 -- This is used by pay_balance_upload.get_current_value.
86 -----------------------------------------------------------------------------
87 --
88 function include_adjustment
89 (
90 p_balance_type_id number
91 ,p_dimension_name varchar2
92 ,p_original_entry_id number
93 ,p_upload_date date
94 ,p_batch_line_id number
95 ,p_test_batch_line_id number
96 ) return number;
97 --
98 -----------------------------------------------------------------------------
99 -- NAME
100 -- validate_batch_lines
101 -- PURPOSE
102 -- Applies CA specific validation to the batch.
103 -- ARGUMENTS
104 -- p_batch_id - the batch to be validate_batch_linesd.
105 -- USES
106 -- NOTES
107 -- This is used by pay_balance_upload.validate_batch_lines.
108 -----------------------------------------------------------------------------
109 --
110 procedure validate_batch_lines
111 (
112 p_batch_id number
113 );
114 --
115 END pay_ca_bal_upload;