DBA Data[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;