[Home] [Help]
PACKAGE: APPS.JTF_TAE_SQL_LIB_PVT
Source
1 PACKAGE JTF_TAE_SQL_LIB_PVT AS
2 /* $Header: jtfvtsls.pls 120.0 2005/06/02 18:23:05 appldev ship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTF_TAE_SQL_LIB_PVT
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- This is to store the commonly used (hand-tuned) SQL
9 -- used by the TAE Generation Program
10 --
11 -- Procedures:
12 -- (see below for specification)
13 --
14 -- NOTES
15 -- This package is available for private use only
16 --
17 -- HISTORY
18 -- 08/04/02 JDOCHERT Created
19 --
20 -- End of Comments
21 --
22
23 --------------------------------------------------
24 --- GLOBAL Declarations Starts here -----
25 --------------------------------------------------
26 G_Debug BOOLEAN := FALSE;
27 g_ProgramStatus NUMBER := 0;
28
29 /* jdochert: 07/31/02 */
30 G_NEWLINE VARCHAR2(30) := FND_GLOBAL.Local_Chr(10);
31
32 G_INDENT VARCHAR2(30) := ' ';
33
34 G_INDENT1 VARCHAR2(30) := ' ';
35 G_INDENT2 VARCHAR2(30) := ' ';
36 G_INDENT3 VARCHAR2(30) := ' ';
37 G_INDENT4 VARCHAR2(30) := ' ';
38 G_INDENT5 VARCHAR2(30) := ' ';
39
40 --
41 -- Function to return Static Inline view SQL
42 --
43 --FUNCTION append_inlineview(p_input_string IN VARCHAR2)
44 --RETURN VARCHAR2;
45
46 /*********************************************************
47 ** Gets the Static pre-built, hand-tuned Index
48 ** Creation Statement for certain Qualifier Combinations
49 **********************************************************/
50 PROCEDURE get_qual_comb_index (
51 p_rel_prod IN NUMBER,
52 p_reverse_flag IN VARCHAR2,
53 p_source_id IN NUMBER,
54 p_trans_object_type_id IN NUMBER,
55 p_table_name IN VARCHAR2,
56 -- arpatel: 09/09/03 added run mode flag
57 p_run_mode IN VARCHAR2 := 'TAP',
58 x_statement OUT NOCOPY VARCHAR2,
59 alter_statement OUT NOCOPY VARCHAR2);
60
61 /*************************************************
62 ** Gets the Static pre-built, hand-tuned SQL
63 ** for certain Qualifier Combinations
64 **************************************************/
65 PROCEDURE get_qual_comb_sql (
66 p_rel_prod IN NUMBER,
67 p_source_id IN NUMBER,
68 p_trans_object_type_id IN NUMBER,
69 p_table_name IN VARCHAR2,
70 /* ARPATEL 03/11/2004 BUG#3489240 */
71 p_match_table_name IN VARCHAR2 := NULL,
72 -- dblee: 08/26/03 added new mode flag
73 p_new_mode_fetch IN CHAR := 'N',
74 x_sql OUT NOCOPY VARCHAR2);
75
76
77 END JTF_TAE_SQL_LIB_PVT;
78