DBA Data[Home] [Help]

PACKAGE: APPS.PAY_US_CONTR_DBI

Source


1 package pay_us_contr_dbi AUTHID CURRENT_USER as
2 /* $Header: pyuscont.pkh 120.1 2011/12/22 12:26:33 emunisek ship $ */
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;