[Home] [Help]
PACKAGE: APPS.XLA_CMP_CREATE_PKG
Source
1 PACKAGE xla_cmp_create_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacpdbo.pkh 120.4 2004/06/18 08:08:38 aquaglia ship $ */
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_cmp_create_pkg |
10 | |
11 | DESCRIPTION |
12 | This is a XLA private package, which contains all the APIs required |
13 | for creation packages (spec and body) in the database |
14 | |
15 | |
16 | HISTORY |
17 | 25-JUN-2002 K.Boussema Created |
18 | 22-APR-2003 K.Boussema Included error messages |
19 | 02-JUN-2004 A.Quaglia Added push_database_object, execute_dml |
20 | 18-JUN-2004 A.Quaglia push_database_object: changed IN OUT into IN |
21 +===========================================================================*/
22 --
23 --
24 C_SPECIFICATION CONSTANT VARCHAR2(30) := 'PACKAGE';
25 C_BODY CONSTANT VARCHAR2(30) := 'PACKAGE BODY';
26
27 G_STANDARD_MESSAGE CONSTANT VARCHAR2(1)
28 := xla_exceptions_pkg.C_STANDARD_MESSAGE;
29 G_OA_MESSAGE CONSTANT VARCHAR2(1)
30 := xla_exceptions_pkg.C_OA_MESSAGE;
31 --
32 --
33 --+==========================================================================+
34 --| |
35 --| |
36 --| PUBLIC Functions |
37 --| |
38 --| |
39 --+==========================================================================+
40 --
41 FUNCTION CreateSpecPackage(
42 p_product_rule_name IN VARCHAR2
43 , p_package_name IN VARCHAR2
44 , p_package_text IN VARCHAR2
45 )
46 RETURN BOOLEAN
47 ;
48 --+==========================================================================+
49 --| |
50 --| |
51 --| PUBLIC Functions |
52 --| |
53 --| |
54 --+==========================================================================+
55 --
56 FUNCTION CreateBodyPackage(
57 p_product_rule_name IN VARCHAR2
58 , p_package_name IN VARCHAR2
59 , p_package_text IN DBMS_SQL.VARCHAR2S
60 )
61 RETURN BOOLEAN
62 ;
63
64
65 --Additions for the Transaction Account Builder
66 FUNCTION push_database_object
67 (
68 p_object_name IN VARCHAR2
69 ,p_object_type IN VARCHAR2
70 ,p_object_owner IN VARCHAR2
71 ,p_apps_account IN VARCHAR2
72 ,p_msg_mode IN VARCHAR2
73 ,p_ddl_text IN CLOB
74 )
75 RETURN BOOLEAN;
76
77 FUNCTION execute_dml
78 (
79 p_dml_text IN CLOB
80 ,p_msg_mode IN VARCHAR2
81 )
82 RETURN BOOLEAN;
83
84 --
85 --
86 END xla_cmp_create_pkg; -- end of package spec