PACKAGE: APPS.PAY_US_DATABASE_ITEMS_PKG

Source

1 package pay_us_database_items_pkg AUTHID CURRENT_USER as
2 /* $Header: pyusdbip.pkh 120.2 2011/12/21 12:37:08 emunisek noship $ */
3 --
4 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5 --
6 /*
7    NAME
8       pyusdbip.pkh
9 --
10    DESCRIPTION
11       See description in pyusdbip.pkb
12 --
13   MODIFIED (DD-MON-YYYY)
14   S Panwar  18-SEP-1995      Created
15   M Reid    06-JUN-1997 40.2 Removed show errors
16   EMunisek  13-NOV-2011 115.2   Changed parameter specification to
17                                 FF_ROUTES.TEXT%TYPE For Bug#13484606
18 */
19 --
20 -- Procedures
21 --
22 PROCEDURE create_db_item(p_name                    VARCHAR2,
23                          p_description             VARCHAR2 DEFAULT NULL,
24                          p_data_type               VARCHAR2,
25                          p_null_allowed            VARCHAR2,
26 			 p_definition_text         VARCHAR2,
27                          p_user_entity_name        VARCHAR2,
28 			 p_user_entity_description VARCHAR2 DEFAULT NULL,
29                          p_route_name              VARCHAR2,
30                          p_param_value1            VARCHAR2 DEFAULT NULL,
31 			 p_param_value2            VARCHAR2 DEFAULT NULL,
32                          p_route_description       VARCHAR2 DEFAULT NULL,
33 			 p_route_text              FF_ROUTES.TEXT%TYPE DEFAULT NULL,
34 			 p_context_name1           VARCHAR2 DEFAULT NULL,
35 			 p_context_name2           VARCHAR2 DEFAULT NULL,
36 			 p_context_name3           VARCHAR2 DEFAULT NULL,
37 			 p_context_name4           VARCHAR2 DEFAULT NULL,
38                          p_param_name1             VARCHAR2 DEFAULT NULL,
39 			 p_param_type1             VARCHAR2 DEFAULT NULL,
40 			 p_param_name2             VARCHAR2 DEFAULT NULL,
41                          p_param_type2             VARCHAR2 DEFAULT NULL);
42 --
43 end pay_us_database_items_pkg;