[Home] [Help]
PACKAGE: APPS.FND_ODF_GEN
Source
1 PACKAGE fnd_odf_gen AUTHID CURRENT_USER AS
2 /* $Header: fndpodfs.pls 120.4 2006/02/15 01:54 vkhatri noship $ */
3
4
5 PROCEDURE odfgen_xml (p_objType IN VARCHAR2,
6 p_objName IN VARCHAR2,
7 p_schemaName IN VARCHAR2,
8 p_concatVar IN VARCHAR2,
9 p_appshortName IN VARCHAR2,
10 p_objMode IN VARCHAR2,
11 p_includeTrigger IN VARCHAR2,
12 p_includeSequence IN VARCHAR2,
13 p_includePolicy IN VARCHAR2,
14 p_objInfo OUT NOCOPY VARCHAR2,
15 p_policyCtr OUT NOCOPY NUMBER,
16 p_triggerCtr OUT NOCOPY NUMBER,
17 p_sequenceCtr OUT NOCOPY NUMBER,
18 p_sysName OUT NOCOPY NUMBER,
19 p_retXML OUT NOCOPY CLOB);
20
21
22
23 PROCEDURE get_fnd_table_metadata(p_tableName IN VARCHAR2,
24 p_owner IN VARCHAR2,
25 p_ASNAME IN VARCHAR2,
26 p_retXml OUT NOCOPY CLOB);
27
28 PROCEDURE get_fnd_view_metadata(p_viewName IN VARCHAR2,
29 p_owner IN VARCHAR2,
30 p_ASNAME IN VARCHAR2,
31 p_retXml OUT NOCOPY CLOB);
32
33 PROCEDURE get_fnd_mview_metadata(p_mviewName IN VARCHAR2,
34 p_owner IN VARCHAR2,
35 p_ASNAME IN VARCHAR2,
36 p_retXml OUT NOCOPY CLOB);
37
38 PROCEDURE get_xml_sequence(p_seqNameList IN VARCHAR2,
39 p_schemaName IN VARCHAR2,
40 p_seqCount OUT NOCOPY NUMBER,
41 p_SeqListing OUT NOCOPY VARCHAR2,
42 p_retVal OUT NOCOPY CLOB);
43
44 PROCEDURE get_xml_policy(p_tableName IN VARCHAR2,
45 p_schemaName IN VARCHAR2,
46 p_includePolicy IN VARCHAR2,
47 p_policyCount OUT NOCOPY NUMBER,
48 p_PolicyListing OUT NOCOPY VARCHAR2,
49 p_retVal OUT NOCOPY CLOB);
50
51 PROCEDURE is_temp_iot ( p_object_name IN VARCHAR2,
52 p_schemaName IN VARCHAR2,
53 p_type OUT NOCOPY VARCHAR2);
54
55 PROCEDURE get_ddl_comment(p_objName IN VARCHAR2,
56 p_schemaName IN VARCHAR2,
57 p_retVal OUT NOCOPY CLOB);
58
59 PROCEDURE get_fnd_tab_col_metadata(p_objName IN VARCHAR2,
60 p_owner IN VARCHAR2,
61 p_ASNAME IN VARCHAR2,
62 p_retXml OUT NOCOPY CLOB);
63
64 PROCEDURE get_fnd_primary_key_metadata(p_objName IN VARCHAR2,
65 p_owner IN VARCHAR2,
66 p_ASNAME IN VARCHAR2,
67 p_retXml OUT NOCOPY CLOB);
68
69 PROCEDURE get_fnd_foreign_key_metadata(p_objName IN VARCHAR2,
70 p_owner IN VARCHAR2,
71 p_ASNAME IN VARCHAR2,
72 p_retXml OUT NOCOPY CLOB);
73
74 PROCEDURE get_fnd_histogram_metadata(p_objName IN VARCHAR2,
75 p_owner IN VARCHAR2,
76 p_ASNAME IN VARCHAR2,
77 p_retXml OUT NOCOPY CLOB);
78
79 PROCEDURE get_fnd_tablespace_metadata(p_objName IN VARCHAR2,
80 p_owner IN VARCHAR2,
81 p_ASNAME IN VARCHAR2,
82 p_retXml OUT NOCOPY CLOB);
83
84 PROCEDURE get_type_attr(p_typeName IN VARCHAR2,
85 p_owner IN VARCHAR2,
86 p_ASNAME IN VARCHAR2,
87 p_retXml OUT NOCOPY CLOB);
88
89 PROCEDURE get_type_method(p_typeName IN VARCHAR2,
90 p_owner IN VARCHAR2,
91 p_ASNAME IN VARCHAR2,
92 p_retXml OUT NOCOPY CLOB);
93
94 PROCEDURE get_type_method_params_results(p_typeName IN VARCHAR2,
95 p_owner IN VARCHAR2,
96 p_ASNAME IN VARCHAR2,
97 p_retXml OUT NOCOPY CLOB);
98
99
100 END fnd_odf_gen;
101
102
103
104