DBA Data[Home] [Help]

PACKAGE: APPS.PAY_JP_BAL_UPLOAD

Source


1 package pay_jp_bal_upload as
2 /* $Header: pyjpupld.pkh 120.1 2006/04/24 00:53:56 ttagawa noship $  */
3 /*
4  Copyright (c) Oracle Corporation 1995 All rights reserved
5  PRODUCT
6   Oracle*Payroll
7  NAME
8   pyjpupld.pkh
9  DESCRIPTION
10   Stub File.
11   Provides support for the upload of balances based on JP dimensions.
12  EXTERNAL
13   expiry_date
14   include_adjustment
15   is_supported
16   validate_batch_lines
17  INTERNAL
18  MODIFIED (DD-MON-YYYY)
19   110.0  A.Logue     11-Jul-1997        created.
20   115.1  Keyazawa    12-OCT-1999        Remove the pragma.
21   115.2  Ttagawa     18-OCT-2002        dbdrv added.
22   115.3  ttagawa     21-Apr-2006        "in" added to input parameters.
23 */
24  --
25   -----------------------------------------------------------------------------
26   -- NAME
27   --  expiry_date
28   -- PURPOSE
29   --  Returns the expiry date of a given dimension relative to a date.
30   -- ARGUMENTS
31   --  p_upload_date       - the date on which the balance should be correct.
32   --  p_dimension_name    - the dimension being set.
33   --  p_assignment_id     - the assignment involved.
34   --  p_original_entry_id - ORIGINAL_ENTRY_ID context.
35   -- USES
36   -- NOTES
37   --  This is used by pay_balance_upload.dim_expiry_date.
38   -----------------------------------------------------------------------------
39  --
40  function expiry_date
41  (
42   p_upload_date        in date
43  ,p_dimension_name     in varchar2
44  ,p_assignment_id      in number
45  ,p_original_entry_id  in number
46  ) return date;
47  --
48 -- pragma restrict_references(expiry_date, WNDS, WNPS);
49  --
50   -----------------------------------------------------------------------------
51   -- NAME
52   --  is_supported
53   -- PURPOSE
54   --  Checks if the dimension is supported by the upload process.
55   -- ARGUMENTS
56   --  p_dimension_name - the balance dimension to be checked.
57   -- USES
58   -- NOTES
59   --  Only a subset of the JP dimensions are supported.
60   --  This is used by pay_balance_upload.validate_dimension.
61   -----------------------------------------------------------------------------
62  --
63  function is_supported
64  (
65   p_dimension_name  in varchar2
66  ) return boolean;
67  --
68   -----------------------------------------------------------------------------
69   -- NAME
70   --  include_adjustment
71   -- PURPOSE
72   --  Given a dimension, and relevant contexts and details of an existing
73   --  balanmce adjustment, it will find out if the balance adjustment effects
74   --  the dimension to be set. Both the dimension to be set and the adjustment
75   --  are for the same assignment and balance.
76   -- ARGUMENTS
77   --  p_balance_type_id    - the balance to be set.
78   --  p_dimension_name     - the balance dimension to be set.
79   --  p_original_entry_id  - ORIGINAL_ENTRY_ID context.
80   --  p_bal_adjustment_rec - details of an existing balance adjustment.
81   -- USES
82   -- NOTES
83   --  This is used by pay_balance_upload.get_current_value.
84   -----------------------------------------------------------------------------
85  --
86  function include_adjustment
87  (
88   p_balance_type_id     in number
89  ,p_dimension_name      in varchar2
90  ,p_original_entry_id   in number
91  ,p_bal_adjustment_rec  in pay_balance_upload.csr_balance_adjustment%rowtype
92  ) return boolean;
93  --
94   -----------------------------------------------------------------------------
95   -- NAME
96   --  validate_batch_lines
97   -- PURPOSE
98  --  Applies JP specific validation to the batch.
99   -- ARGUMENTS
100   --  p_batch_id - the batch to be validate_batch_linesd.
101   -- USES
102   -- NOTES
103   --  This is used by pay_balance_upload.validate_batch_lines.
104   -----------------------------------------------------------------------------
105  --
106  procedure validate_batch_lines
107  (
108   p_batch_id  in number
109  );
110  --
111 end pay_jp_bal_upload;