[Home] [Help]
PACKAGE: APPS.PAY_US_CONTR_DBI
Source
1 package pay_us_contr_dbi as
2 /* $Header: pyuscont.pkh 120.0 2005/05/29 09:19:46 appldev noship $ */
3 /*
4 --
5 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
6 --
7 /*
8 NAME
9 pyuscont.pkh
10 --
11 DESCRIPTION
12 Procedures required to create the startup data for US Benefit Contribution
13 Database Items, and procedures required to create the Database Items
14 Dynamically on creation of Input Values.
15
16 These procedures create the following objects
17
18 Routes
19 ------
20 COVERAGE_VALUES
21 CONTRIBUTION_VALUES
22
23 Database Items
24 --------------
25 <ENTITY_NAME>_COVERAGE_VALUE
26 <ENTITY_NAME>_EE_CONTR_VALUE
27 <ENTITY_NAME>_ER_CONTR_VALUE
28
29 Name Date Change Details
30 -------- ---------- -----------------------------------------------
31 JRhodes 20-OCT-1993 Created
32 RFine 05-OCT-1994 Prepended 'PAY_' to package name as per standards
33 RFine 15-MAY-1995 Changed 'show errors' from package body to package.
34
35 */
36 --
37 PROCEDURE create_usdbi_startup;
38 --
39 PROCEDURE create_contr_items
40 (p_input_value_id IN NUMBER
41 ,p_effective_date IN DATE
42 ,p_start_string IN VARCHAR2
43 ,p_end_string IN VARCHAR2
44 ,p_data_type IN VARCHAR2
45 );
46 --
47 END pay_us_contr_dbi;