PACKAGE: APPS.PAY_DATABASE_ITEMS_PKG

Source

1 package pay_database_items_pkg AUTHID CURRENT_USER as
2 /* $Header: pycadbis.pkh 120.2 2011/12/22 11:05:13 emunisek ship $ */
3 --
4 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5 --
6 /*
7    NAME
8       pycadbip.pkh
9 --
10    DESCRIPTION
11       See description in pycadbip.pkb
12 --
13   MODIFIED (DD-MON-YYYY)
14   RThirlby  20_JUL-1999      Created (Copy of pyusdbip.pkh, but with
15                              new legislation_code parameter.
16   RThirlby  29-FEB-2000      No changes for 11i upport.
17   EMunisek  13-NOV-2011 115.1   Changed parameter specification to
18                                 FF_ROUTES.TEXT%TYPE For Bug#13484606
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_route_description       VARCHAR2 DEFAULT NULL,
34 			 p_route_text              FF_ROUTES.TEXT%TYPE DEFAULT NULL,
35 			 p_context_name1           VARCHAR2 DEFAULT NULL,
36 			 p_context_name2           VARCHAR2 DEFAULT NULL,
37 			 p_context_name3           VARCHAR2 DEFAULT NULL,
38 			 p_context_name4           VARCHAR2 DEFAULT NULL,
39                          p_param_name1             VARCHAR2 DEFAULT NULL,
40 			 p_param_type1             VARCHAR2 DEFAULT NULL,
41 			 p_param_name2             VARCHAR2 DEFAULT NULL,
42                          p_param_type2             VARCHAR2 DEFAULT NULL,
43                          p_legislation_code        VARCHAR2 );
44 --
45 end pay_database_items_pkg;