[Home] [Help]
PACKAGE: APPS.BEN_US_DATABASE_ITEMS_PKG
Source
1 package ben_us_database_items_pkg AUTHID CURRENT_USER as
2 /* $Header: beusdbip.pkh 120.0 2005/05/28 12:01:46 appldev noship $*/
3 --
4 --
5 /*
6 NAME
7 beusdbip.pkh
8 --
9 DESCRIPTION
10 See description in beusdbip.pkb
11 --
12 rem Generated By : pbodla
13 rem
14 rem Version Date Author Reason
15 rem -------------------------------------------------------------------------
16 rem 115.0 28/04/99 pbodla For seeding all Benefits routes and database items
17 rem
18
19 */
20 --
21 -- Procedures
22 --
23 PROCEDURE create_db_item(p_name VARCHAR2,
24 p_description VARCHAR2 DEFAULT NULL,
25 p_data_type VARCHAR2,
26 p_null_allowed VARCHAR2,
27 p_definition_text VARCHAR2,
28 p_user_entity_name VARCHAR2,
29 p_user_entity_description VARCHAR2 DEFAULT NULL,
30 p_route_name VARCHAR2,
31 p_param_value1 VARCHAR2 DEFAULT NULL,
32 p_param_value2 VARCHAR2 DEFAULT NULL,
33 p_param_value3 VARCHAR2 DEFAULT NULL,
34 p_route_description VARCHAR2 DEFAULT NULL,
35 p_route_text VARCHAR2 DEFAULT NULL,
36 p_context_name1 VARCHAR2 DEFAULT NULL,
37 p_context_name2 VARCHAR2 DEFAULT NULL,
38 p_context_name3 VARCHAR2 DEFAULT NULL,
39 p_context_name4 VARCHAR2 DEFAULT NULL,
40 p_context_name5 VARCHAR2 DEFAULT NULL,
41 p_context_name6 VARCHAR2 DEFAULT NULL,
42 p_context_name7 VARCHAR2 DEFAULT NULL,
43 p_context_name8 VARCHAR2 DEFAULT NULL,
44 p_context_name9 VARCHAR2 DEFAULT NULL,
45 p_context_name10 VARCHAR2 DEFAULT NULL,
46 p_param_name1 VARCHAR2 DEFAULT NULL,
47 p_param_type1 VARCHAR2 DEFAULT NULL,
48 p_param_name2 VARCHAR2 DEFAULT NULL,
49 p_param_type2 VARCHAR2 DEFAULT NULL,
50 p_param_name3 VARCHAR2 DEFAULT NULL,
51 p_param_type3 VARCHAR2 DEFAULT NULL);
52 --
53 end ben_us_database_items_pkg;