PACKAGE: APPS.FEM_TABLE_PUBLISH_PKG

Source

1 PACKAGE FEM_TABLE_PUBLISH_PKG AS
2 /* $Header: FEMVDIPUBS.pls 120.1 2007/07/27 10:36:34 gdonthir noship $ */
3 
4 
5 
6   --------------------------------------------------------------------------------
7                            -- Declare all global variables --
8   --------------------------------------------------------------------------------
9 
10      g_log_level_1                CONSTANT  NUMBER      := fnd_log.level_statement;
11      g_log_level_2                CONSTANT  NUMBER      := fnd_log.level_procedure;
12      g_log_level_3                CONSTANT  NUMBER      := fnd_log.level_event;
13      g_log_level_4                CONSTANT  NUMBER      := fnd_log.level_exception;
14      g_log_level_5                CONSTANT  NUMBER      := fnd_log.level_error;
15      g_log_level_6                CONSTANT  NUMBER      := fnd_log.level_unexpected;
16 
17      g_block                      CONSTANT VARCHAR2(30) := 'FEM_TABLE_PUBLISH_PKG';
18 
19 
20 PROCEDURE Generate_XML_CP(
21   x_retcode        OUT NOCOPY NUMBER,
22   x_errbuff        OUT NOCOPY VARCHAR2,
23   p_diObjDefId IN NUMBER,
24   p_view IN VARCHAR2,
25   p_comp_totals IN VARCHAR2
26  );
27 
28 PROCEDURE Generate_XML(
29   x_retcode        OUT NOCOPY NUMBER,
30   x_errbuff        OUT NOCOPY VARCHAR2,
31   p_diObjDefId IN NUMBER,
32   x_xml_result OUT NOCOPY CLOB,
33   p_mode IN VARCHAR2,
34   p_view IN VARCHAR2,
35   p_comp_totals IN VARCHAR2);
36 
37 PROCEDURE Run_Report(
38  x_req_id OUT NOCOPY NUMBER,
39  x_retcode OUT NOCOPY NUMBER,
40  x_errbuff OUT NOCOPY VARCHAR2,
41  x_xml_result OUT NOCOPY CLOB,
42  p_diObjDefId IN NUMBER,
43  p_gen_mode IN VARCHAR2,
44  p_gen_format IN VARCHAR2,
45  p_gen_template IN VARCHAR2,
46  p_view IN VARCHAR2,
47  p_comp_totals IN VARCHAR2,
48  p_diQuery IN VARCHAR2
49 );
50 
51 PROCEDURE Generate_Cust_XML_CP
52 (
53  x_retcode OUT NOCOPY NUMBER,
54  x_errbuff OUT NOCOPY VARCHAR2,
55  p_diObjDefId IN NUMBER,
56  p_diQuery IN VARCHAR2,
57  p_view IN VARCHAR2
58 );
59 
60 --Bug#6174477: Add view option parameter
61 PROCEDURE Generate_Cust_XML
62 (
63  p_diObjDefId IN NUMBER,
64  p_diQuery IN VARCHAR2,
65  p_mode IN VARCHAR2,
66  p_view IN VARCHAR2,
67  x_xml_result OUT NOCOPY CLOB
68 );
69 
70 
71 PROCEDURE getConditionPredicate(
72 p_condObjId IN NUMBER,
73 p_tableName IN VARCHAR2,
74 p_whereClause OUT NOCOPY CLOB);
75 
76 END FEM_TABLE_PUBLISH_PKG;