PACKAGE: APPS.PAY_US_ARCHIVE_UTIL

Source

1 PACKAGE pay_us_archive_util AS
2 /* $Header: payusarchiveutil.pkh 120.0 2005/05/29 11:52:30 appldev noship $ */
3 
4    /*
5     +=====================================================================+
6     |              Copyright (c) 1997 Orcale Corporation                  |
7     |                 Redwood Shores, California, USA                     |
8     |                      All rights reserved.                           |
9     +=====================================================================+
10    Name        : payusarchiveutil.pkh
11    Description : This package contains utilities to fetch archived values.
12 
13    Change List
14    -----------
15 
16    Version Date      Author          Bug No.   Description of Change
17    -------+---------+---------------+---------+--------------------------
18    115.0   20-AUG-04  rsethupa       3393493   Created
19    115.1   08-NOV-04  rsethupa       3180532   Added function
20                                                get_ff_archive_value
21    115.2   10-NOV-04  meshah                   removed function
22                                                get_ff_archive_value and
23                                                moved it to
24                                                pay_us_reporting_utils_pkg
25                                                for extract reasons.
26    ----------------------------------------------------------------------
27    */
28    TYPE user_entity_record IS RECORD (
29       user_entity_id     NUMBER (15),
30       user_entity_name   VARCHAR2 (240)
31    );
32 
33    TYPE user_entity_tabrec IS TABLE OF user_entity_record
34       INDEX BY BINARY_INTEGER;
35 
36    ltr_user_entity_table   user_entity_tabrec;
37 
38    /*********************************************************************
39     Name        : get_archive_value
40 
41     Description : gets the archived value for a particular Action ID
42                   (Assignment Action or Payroll Action). Jurisdiction
43         code is optional.
44 
45     ********************************************************************/
46    FUNCTION get_archive_value (
47       p_action_id           NUMBER,
48       p_user_entity_name    VARCHAR2,
49       p_tax_unit_id         NUMBER,
50       p_jurisdiction_code   VARCHAR2 DEFAULT NULL
51    )
52       RETURN VARCHAR2;
53 
54 END pay_us_archive_util;