[Home] [Help]
PACKAGE: APPS.PAY_CA_DATABASE_ITEMS_PKG
Source
1 package pay_ca_database_items_pkg as
2 /* $Header: pycadbip.pkh 120.0 2005/05/29 03:28:37 appldev noship $ */
3 --
4 -- Copyright (c) Oracle Corporation 1999. All rights reserved.
5 --
6 /*
7 NAME
8 pycadbip.pkh
9 --
10 DESCRIPTION
11 Provides a single function interface for the creation of database
12 items.
13 --
14 */
15 --
16 -- Procedures
17 --
18 PROCEDURE create_db_item(p_name VARCHAR2,
19 p_description VARCHAR2 DEFAULT NULL,
20 p_data_type VARCHAR2,
21 p_null_allowed VARCHAR2,
22 p_definition_text VARCHAR2,
23 p_user_entity_name VARCHAR2,
24 p_user_entity_description VARCHAR2 DEFAULT NULL,
25 p_route_name VARCHAR2,
26 p_param_value1 VARCHAR2 DEFAULT NULL,
27 p_param_value2 VARCHAR2 DEFAULT NULL,
28 p_route_description VARCHAR2 DEFAULT NULL,
29 p_route_text VARCHAR2 DEFAULT NULL,
30 p_context_name1 VARCHAR2 DEFAULT NULL,
31 p_context_name2 VARCHAR2 DEFAULT NULL,
32 p_context_name3 VARCHAR2 DEFAULT NULL,
33 p_context_name4 VARCHAR2 DEFAULT NULL,
34 p_param_name1 VARCHAR2 DEFAULT NULL,
35 p_param_type1 VARCHAR2 DEFAULT NULL,
36 p_param_name2 VARCHAR2 DEFAULT NULL,
37 p_param_type2 VARCHAR2 DEFAULT NULL);
38
39 PROCEDURE create_db_item(p_name VARCHAR2,
40 p_description VARCHAR2 DEFAULT NULL,
41 p_data_type VARCHAR2,
42 p_null_allowed VARCHAR2,
43 p_definition_text VARCHAR2,
44 p_user_entity_name VARCHAR2,
45 p_user_entity_description VARCHAR2 DEFAULT NULL,
46 p_route_name VARCHAR2,
47 p_param_value1 VARCHAR2 DEFAULT NULL,
48 p_param_value2 VARCHAR2 DEFAULT NULL,
49 p_route_description VARCHAR2 DEFAULT NULL,
50 p_route_text VARCHAR2 DEFAULT NULL,
51 p_context_name1 VARCHAR2 DEFAULT NULL,
52 p_context_name2 VARCHAR2 DEFAULT NULL,
53 p_context_name3 VARCHAR2 DEFAULT NULL,
54 p_context_name4 VARCHAR2 DEFAULT NULL,
55 p_param_name1 VARCHAR2 DEFAULT NULL,
56 p_param_type1 VARCHAR2 DEFAULT NULL,
57 p_param_name2 VARCHAR2 DEFAULT NULL,
58 p_param_type2 VARCHAR2 DEFAULT NULL,
59 p_legislation_code VARCHAR2 );
60
61 --
62 end pay_ca_database_items_pkg;