[Home] [Help]
PACKAGE: APPS.XLA_CMP_COMMON_PKG
Source
1 PACKAGE xla_cmp_common_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacpcom.pkh 120.0 2004/06/02 11:42:18 aquaglia ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_cmp_common_pkg |
10 | |
11 | DESCRIPTION |
12 | Oracle Subledger Accounting Compiler Common Code |
13 | |
14 | HISTORY |
15 | 30-JAN-04 A.Quaglia Created |
16 | |
17 | |
18 | |
19 | |
20 | |
21 | |
22 | |
23 +======================================================================*/
24
25
26 G_COMPILE_STATUS_CODE_ERROR CONSTANT VARCHAR2(1) := 'E';
27 G_COMPILE_STATUS_CODE_UNCOMP CONSTANT VARCHAR2(1) := 'N';
28 G_COMPILE_STATUS_CODE_RUNNING CONSTANT VARCHAR2(1) := 'R';
29 G_COMPILE_STATUS_CODE_COMPILED CONSTANT VARCHAR2(1) := 'Y';
30 G_COMPILE_STATUS_CODE_DELETE CONSTANT VARCHAR2(1) := 'D';
31
32
33 TYPE lt_application_info IS RECORD
34 (
35 application_id PLS_INTEGER
36 ,application_name VARCHAR2(2000) --240 in the table
37 ,application_short_name VARCHAR2(50)
38 ,application_hash_id VARCHAR2(5)
39 ,oracle_username VARCHAR2(30)
40 ,product_abbreviation VARCHAR2(4)
41 ,apps_account VARCHAR2(30)
42 );
43
44
45 FUNCTION get_application_info
46 ( p_application_id IN NUMBER
47 ,p_application_info OUT NOCOPY lt_application_info
48 )
49 RETURN BOOLEAN
50 ;
51
52 FUNCTION get_user_name
53 ( p_user_id IN NUMBER
54 ,p_user_name OUT NOCOPY VARCHAR2
55 )
56 RETURN BOOLEAN
57 ;
58
59 PROCEDURE clob_to_varchar2s
60 (
61 p_clob IN CLOB
62 ,p_varchar2s OUT NOCOPY DBMS_SQL.VARCHAR2S
63 );
64
65 PROCEDURE varchar2s_to_clob
66 (
67 p_varchar2s IN DBMS_SQL.VARCHAR2S
68 ,x_clob OUT NOCOPY CLOB
69 );
70
71 PROCEDURE dump_text
72 (
73 p_text IN VARCHAR2
74 );
75
76 PROCEDURE dump_text
77 (
78 p_text IN DBMS_SQL.VARCHAR2S
79 );
80
81 PROCEDURE dump_text
82 (
83 p_text IN CLOB
84 );
85
86 FUNCTION bool_to_char(p_boolean IN BOOLEAN)
87 RETURN VARCHAR2;
88
89 FUNCTION replace_token
90 (
91 p_original_text IN CLOB
92 ,p_token IN VARCHAR2
93 ,p_replacement_text IN CLOB
94 )
95 RETURN CLOB;
96
97 END xla_cmp_common_pkg;