[Home] [Help]
PACKAGE: APPS.OZF_DENORM_QUERIES_PVT_W
Source
1 package ozf_denorm_queries_pvt_w as
2 /* $Header: ozfwofds.pls 120.0 2005/06/01 00:24:05 appldev noship $ */
3 procedure rosetta_table_copy_in_p1(t OUT NOCOPY ozf_denorm_queries_pvt.stringarray, a0 JTF_VARCHAR2_TABLE_4000);
4 procedure rosetta_table_copy_out_p1(t ozf_denorm_queries_pvt.stringarray, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000);
5
6 procedure create_denorm_queries(p_api_version NUMBER
7 , p_init_msg_list VARCHAR2
8 , p_commit VARCHAR2
9 , p_validation_level NUMBER
10 , x_return_status OUT NOCOPY VARCHAR2
11 , x_msg_count OUT NOCOPY NUMBER
12 , x_msg_data OUT NOCOPY VARCHAR2
13 , x_denorm_query_id OUT NOCOPY NUMBER
14 , p4_a0 NUMBER := 0-1962.0724
15 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
16 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20 , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21 , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22 , p4_a8 DATE := fnd_api.g_miss_date
23 , p4_a9 NUMBER := 0-1962.0724
24 , p4_a10 DATE := fnd_api.g_miss_date
25 , p4_a11 NUMBER := 0-1962.0724
26 , p4_a12 NUMBER := 0-1962.0724
27 , p4_a13 NUMBER := 0-1962.0724
28 , p4_a14 NUMBER := 0-1962.0724
29 );
30 procedure update_denorm_queries(p_api_version NUMBER
31 , p_init_msg_list VARCHAR2
32 , p_commit VARCHAR2
33 , p_validation_level NUMBER
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2
37 , p4_a0 NUMBER := 0-1962.0724
38 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
39 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43 , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44 , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45 , p4_a8 DATE := fnd_api.g_miss_date
46 , p4_a9 NUMBER := 0-1962.0724
47 , p4_a10 DATE := fnd_api.g_miss_date
48 , p4_a11 NUMBER := 0-1962.0724
49 , p4_a12 NUMBER := 0-1962.0724
50 , p4_a13 NUMBER := 0-1962.0724
51 , p4_a14 NUMBER := 0-1962.0724
52 );
53 procedure validate_denorm_queries(p_api_version NUMBER
54 , p_init_msg_list VARCHAR2
55 , p_validation_level NUMBER
56 , p_validation_mode VARCHAR2
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60 , p4_a0 NUMBER := 0-1962.0724
61 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
62 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66 , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67 , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68 , p4_a8 DATE := fnd_api.g_miss_date
69 , p4_a9 NUMBER := 0-1962.0724
70 , p4_a10 DATE := fnd_api.g_miss_date
71 , p4_a11 NUMBER := 0-1962.0724
72 , p4_a12 NUMBER := 0-1962.0724
73 , p4_a13 NUMBER := 0-1962.0724
74 , p4_a14 NUMBER := 0-1962.0724
75 );
76 procedure check_denorm_queries_items(p_validation_mode VARCHAR2
77 , x_return_status OUT NOCOPY VARCHAR2
78 , p0_a0 NUMBER := 0-1962.0724
79 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
80 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86 , p0_a8 DATE := fnd_api.g_miss_date
87 , p0_a9 NUMBER := 0-1962.0724
88 , p0_a10 DATE := fnd_api.g_miss_date
89 , p0_a11 NUMBER := 0-1962.0724
90 , p0_a12 NUMBER := 0-1962.0724
91 , p0_a13 NUMBER := 0-1962.0724
92 , p0_a14 NUMBER := 0-1962.0724
93 );
94 procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
95 , p0_a0 NUMBER := 0-1962.0724
96 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
97 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103 , p0_a8 DATE := fnd_api.g_miss_date
104 , p0_a9 NUMBER := 0-1962.0724
105 , p0_a10 DATE := fnd_api.g_miss_date
106 , p0_a11 NUMBER := 0-1962.0724
107 , p0_a12 NUMBER := 0-1962.0724
108 , p0_a13 NUMBER := 0-1962.0724
109 , p0_a14 NUMBER := 0-1962.0724
110 );
111 procedure init_denorm_queries_rec(p0_a0 OUT NOCOPY NUMBER
112 , p0_a1 OUT NOCOPY VARCHAR2
113 , p0_a2 OUT NOCOPY VARCHAR2
114 , p0_a3 OUT NOCOPY VARCHAR2
115 , p0_a4 OUT NOCOPY VARCHAR2
116 , p0_a5 OUT NOCOPY VARCHAR2
117 , p0_a6 OUT NOCOPY VARCHAR2
118 , p0_a7 OUT NOCOPY VARCHAR2
119 , p0_a8 OUT NOCOPY DATE
120 , p0_a9 OUT NOCOPY NUMBER
121 , p0_a10 OUT NOCOPY DATE
122 , p0_a11 OUT NOCOPY NUMBER
123 , p0_a12 OUT NOCOPY NUMBER
124 , p0_a13 OUT NOCOPY NUMBER
125 , p0_a14 OUT NOCOPY NUMBER
126 );
127 procedure complete_denorm_queries_rec(p1_a0 OUT NOCOPY NUMBER
128 , p1_a1 OUT NOCOPY VARCHAR2
129 , p1_a2 OUT NOCOPY VARCHAR2
130 , p1_a3 OUT NOCOPY VARCHAR2
131 , p1_a4 OUT NOCOPY VARCHAR2
132 , p1_a5 OUT NOCOPY VARCHAR2
133 , p1_a6 OUT NOCOPY VARCHAR2
134 , p1_a7 OUT NOCOPY VARCHAR2
135 , p1_a8 OUT NOCOPY DATE
136 , p1_a9 OUT NOCOPY NUMBER
137 , p1_a10 OUT NOCOPY DATE
138 , p1_a11 OUT NOCOPY NUMBER
139 , p1_a12 OUT NOCOPY NUMBER
140 , p1_a13 OUT NOCOPY NUMBER
141 , p1_a14 OUT NOCOPY NUMBER
142 , p0_a0 NUMBER := 0-1962.0724
143 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
144 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150 , p0_a8 DATE := fnd_api.g_miss_date
151 , p0_a9 NUMBER := 0-1962.0724
152 , p0_a10 DATE := fnd_api.g_miss_date
153 , p0_a11 NUMBER := 0-1962.0724
154 , p0_a12 NUMBER := 0-1962.0724
155 , p0_a13 NUMBER := 0-1962.0724
156 , p0_a14 NUMBER := 0-1962.0724
157 );
158 procedure string_length_check(sqlst VARCHAR2
159 , sarray OUT NOCOPY JTF_VARCHAR2_TABLE_4000
160 );
161 end ozf_denorm_queries_pvt_w;