14: , x_msg_count OUT NOCOPY NUMBER
15: , x_msg_data OUT NOCOPY VARCHAR2
16: , x_list_query_id OUT NOCOPY NUMBER
17: , p7_a0 NUMBER := 0-1962.0724
18: , p7_a1 DATE := fnd_api.g_miss_date
19: , p7_a2 NUMBER := 0-1962.0724
20: , p7_a3 DATE := fnd_api.g_miss_date
21: , p7_a4 NUMBER := 0-1962.0724
22: , p7_a5 NUMBER := 0-1962.0724
16: , x_list_query_id OUT NOCOPY NUMBER
17: , p7_a0 NUMBER := 0-1962.0724
18: , p7_a1 DATE := fnd_api.g_miss_date
19: , p7_a2 NUMBER := 0-1962.0724
20: , p7_a3 DATE := fnd_api.g_miss_date
21: , p7_a4 NUMBER := 0-1962.0724
22: , p7_a5 NUMBER := 0-1962.0724
23: , p7_a6 NUMBER := 0-1962.0724
24: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a3 DATE := fnd_api.g_miss_date
21: , p7_a4 NUMBER := 0-1962.0724
22: , p7_a5 NUMBER := 0-1962.0724
23: , p7_a6 NUMBER := 0-1962.0724
24: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
25: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a4 NUMBER := 0-1962.0724
22: , p7_a5 NUMBER := 0-1962.0724
23: , p7_a6 NUMBER := 0-1962.0724
24: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
25: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a5 NUMBER := 0-1962.0724
23: , p7_a6 NUMBER := 0-1962.0724
24: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
25: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a6 NUMBER := 0-1962.0724
24: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
25: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a14 NUMBER := 0-1962.0724
24: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
25: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a14 NUMBER := 0-1962.0724
32: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
25: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a14 NUMBER := 0-1962.0724
32: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a16 NUMBER := 0-1962.0724
26: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
27: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a14 NUMBER := 0-1962.0724
32: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a16 NUMBER := 0-1962.0724
34: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
29: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a14 NUMBER := 0-1962.0724
32: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a16 NUMBER := 0-1962.0724
34: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a19 NUMBER := 0-1962.0724
30: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a14 NUMBER := 0-1962.0724
32: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a16 NUMBER := 0-1962.0724
34: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a19 NUMBER := 0-1962.0724
37: , p7_a20 NUMBER := 0-1962.0724
38: );
31: , p7_a14 NUMBER := 0-1962.0724
32: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a16 NUMBER := 0-1962.0724
34: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a19 NUMBER := 0-1962.0724
37: , p7_a20 NUMBER := 0-1962.0724
38: );
39: procedure create_list_query(p_api_version_number NUMBER
45: , x_msg_data OUT NOCOPY VARCHAR2
46: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
47: , x_parent_list_query_id OUT NOCOPY NUMBER
48: , p7_a0 NUMBER := 0-1962.0724
49: , p7_a1 DATE := fnd_api.g_miss_date
50: , p7_a2 NUMBER := 0-1962.0724
51: , p7_a3 DATE := fnd_api.g_miss_date
52: , p7_a4 NUMBER := 0-1962.0724
53: , p7_a5 NUMBER := 0-1962.0724
47: , x_parent_list_query_id OUT NOCOPY NUMBER
48: , p7_a0 NUMBER := 0-1962.0724
49: , p7_a1 DATE := fnd_api.g_miss_date
50: , p7_a2 NUMBER := 0-1962.0724
51: , p7_a3 DATE := fnd_api.g_miss_date
52: , p7_a4 NUMBER := 0-1962.0724
53: , p7_a5 NUMBER := 0-1962.0724
54: , p7_a6 NUMBER := 0-1962.0724
55: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a3 DATE := fnd_api.g_miss_date
52: , p7_a4 NUMBER := 0-1962.0724
53: , p7_a5 NUMBER := 0-1962.0724
54: , p7_a6 NUMBER := 0-1962.0724
55: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a4 NUMBER := 0-1962.0724
53: , p7_a5 NUMBER := 0-1962.0724
54: , p7_a6 NUMBER := 0-1962.0724
55: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a5 NUMBER := 0-1962.0724
54: , p7_a6 NUMBER := 0-1962.0724
55: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a6 NUMBER := 0-1962.0724
55: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a14 NUMBER := 0-1962.0724
55: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a14 NUMBER := 0-1962.0724
63: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a14 NUMBER := 0-1962.0724
63: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a16 NUMBER := 0-1962.0724
57: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a14 NUMBER := 0-1962.0724
63: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a16 NUMBER := 0-1962.0724
65: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a14 NUMBER := 0-1962.0724
63: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a16 NUMBER := 0-1962.0724
65: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a18 NUMBER := 0-1962.0724
67: , p7_a19 NUMBER := 0-1962.0724
61: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a14 NUMBER := 0-1962.0724
63: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a16 NUMBER := 0-1962.0724
65: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a18 NUMBER := 0-1962.0724
67: , p7_a19 NUMBER := 0-1962.0724
68: );
69: procedure update_list_query(p_api_version_number NUMBER
74: , x_msg_count OUT NOCOPY NUMBER
75: , x_msg_data OUT NOCOPY VARCHAR2
76: , x_object_version_number OUT NOCOPY NUMBER
77: , p7_a0 NUMBER := 0-1962.0724
78: , p7_a1 DATE := fnd_api.g_miss_date
79: , p7_a2 NUMBER := 0-1962.0724
80: , p7_a3 DATE := fnd_api.g_miss_date
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
76: , x_object_version_number OUT NOCOPY NUMBER
77: , p7_a0 NUMBER := 0-1962.0724
78: , p7_a1 DATE := fnd_api.g_miss_date
79: , p7_a2 NUMBER := 0-1962.0724
80: , p7_a3 DATE := fnd_api.g_miss_date
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a3 DATE := fnd_api.g_miss_date
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p7_a5 NUMBER := 0-1962.0724
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a14 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 NUMBER := 0-1962.0724
86: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 NUMBER := 0-1962.0724
94: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 NUMBER := 0-1962.0724
94: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a19 NUMBER := 0-1962.0724
90: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 NUMBER := 0-1962.0724
94: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a19 NUMBER := 0-1962.0724
97: , p7_a20 NUMBER := 0-1962.0724
98: );
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 NUMBER := 0-1962.0724
94: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a19 NUMBER := 0-1962.0724
97: , p7_a20 NUMBER := 0-1962.0724
98: );
99: procedure update_list_query(p_api_version_number NUMBER
105: , x_msg_data OUT NOCOPY VARCHAR2
106: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
107: , x_object_version_number OUT NOCOPY NUMBER
108: , p7_a0 NUMBER := 0-1962.0724
109: , p7_a1 DATE := fnd_api.g_miss_date
110: , p7_a2 NUMBER := 0-1962.0724
111: , p7_a3 DATE := fnd_api.g_miss_date
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724
107: , x_object_version_number OUT NOCOPY NUMBER
108: , p7_a0 NUMBER := 0-1962.0724
109: , p7_a1 DATE := fnd_api.g_miss_date
110: , p7_a2 NUMBER := 0-1962.0724
111: , p7_a3 DATE := fnd_api.g_miss_date
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a3 DATE := fnd_api.g_miss_date
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a5 NUMBER := 0-1962.0724
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a14 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a14 NUMBER := 0-1962.0724
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a14 NUMBER := 0-1962.0724
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a16 NUMBER := 0-1962.0724
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a14 NUMBER := 0-1962.0724
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a16 NUMBER := 0-1962.0724
125: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a14 NUMBER := 0-1962.0724
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a16 NUMBER := 0-1962.0724
125: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a18 NUMBER := 0-1962.0724
127: , p7_a19 NUMBER := 0-1962.0724
121: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a14 NUMBER := 0-1962.0724
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a16 NUMBER := 0-1962.0724
125: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a18 NUMBER := 0-1962.0724
127: , p7_a19 NUMBER := 0-1962.0724
128: );
129: procedure validate_list_query(p_api_version_number NUMBER
132: , x_return_status OUT NOCOPY VARCHAR2
133: , x_msg_count OUT NOCOPY NUMBER
134: , x_msg_data OUT NOCOPY VARCHAR2
135: , p3_a0 NUMBER := 0-1962.0724
136: , p3_a1 DATE := fnd_api.g_miss_date
137: , p3_a2 NUMBER := 0-1962.0724
138: , p3_a3 DATE := fnd_api.g_miss_date
139: , p3_a4 NUMBER := 0-1962.0724
140: , p3_a5 NUMBER := 0-1962.0724
134: , x_msg_data OUT NOCOPY VARCHAR2
135: , p3_a0 NUMBER := 0-1962.0724
136: , p3_a1 DATE := fnd_api.g_miss_date
137: , p3_a2 NUMBER := 0-1962.0724
138: , p3_a3 DATE := fnd_api.g_miss_date
139: , p3_a4 NUMBER := 0-1962.0724
140: , p3_a5 NUMBER := 0-1962.0724
141: , p3_a6 NUMBER := 0-1962.0724
142: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p3_a3 DATE := fnd_api.g_miss_date
139: , p3_a4 NUMBER := 0-1962.0724
140: , p3_a5 NUMBER := 0-1962.0724
141: , p3_a6 NUMBER := 0-1962.0724
142: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
139: , p3_a4 NUMBER := 0-1962.0724
140: , p3_a5 NUMBER := 0-1962.0724
141: , p3_a6 NUMBER := 0-1962.0724
142: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
140: , p3_a5 NUMBER := 0-1962.0724
141: , p3_a6 NUMBER := 0-1962.0724
142: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
141: , p3_a6 NUMBER := 0-1962.0724
142: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
149: , p3_a14 NUMBER := 0-1962.0724
142: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
149: , p3_a14 NUMBER := 0-1962.0724
150: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
149: , p3_a14 NUMBER := 0-1962.0724
150: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
151: , p3_a16 NUMBER := 0-1962.0724
144: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
149: , p3_a14 NUMBER := 0-1962.0724
150: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
151: , p3_a16 NUMBER := 0-1962.0724
152: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
149: , p3_a14 NUMBER := 0-1962.0724
150: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
151: , p3_a16 NUMBER := 0-1962.0724
152: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
153: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
154: , p3_a19 NUMBER := 0-1962.0724
148: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
149: , p3_a14 NUMBER := 0-1962.0724
150: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
151: , p3_a16 NUMBER := 0-1962.0724
152: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
153: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
154: , p3_a19 NUMBER := 0-1962.0724
155: , p3_a20 NUMBER := 0-1962.0724
156: );
149: , p3_a14 NUMBER := 0-1962.0724
150: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
151: , p3_a16 NUMBER := 0-1962.0724
152: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
153: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
154: , p3_a19 NUMBER := 0-1962.0724
155: , p3_a20 NUMBER := 0-1962.0724
156: );
157: procedure check_list_query_items(p_validation_mode VARCHAR2
156: );
157: procedure check_list_query_items(p_validation_mode VARCHAR2
158: , x_return_status OUT NOCOPY VARCHAR2
159: , p0_a0 NUMBER := 0-1962.0724
160: , p0_a1 DATE := fnd_api.g_miss_date
161: , p0_a2 NUMBER := 0-1962.0724
162: , p0_a3 DATE := fnd_api.g_miss_date
163: , p0_a4 NUMBER := 0-1962.0724
164: , p0_a5 NUMBER := 0-1962.0724
158: , x_return_status OUT NOCOPY VARCHAR2
159: , p0_a0 NUMBER := 0-1962.0724
160: , p0_a1 DATE := fnd_api.g_miss_date
161: , p0_a2 NUMBER := 0-1962.0724
162: , p0_a3 DATE := fnd_api.g_miss_date
163: , p0_a4 NUMBER := 0-1962.0724
164: , p0_a5 NUMBER := 0-1962.0724
165: , p0_a6 NUMBER := 0-1962.0724
166: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
162: , p0_a3 DATE := fnd_api.g_miss_date
163: , p0_a4 NUMBER := 0-1962.0724
164: , p0_a5 NUMBER := 0-1962.0724
165: , p0_a6 NUMBER := 0-1962.0724
166: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
163: , p0_a4 NUMBER := 0-1962.0724
164: , p0_a5 NUMBER := 0-1962.0724
165: , p0_a6 NUMBER := 0-1962.0724
166: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
164: , p0_a5 NUMBER := 0-1962.0724
165: , p0_a6 NUMBER := 0-1962.0724
166: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
165: , p0_a6 NUMBER := 0-1962.0724
166: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a14 NUMBER := 0-1962.0724
166: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a14 NUMBER := 0-1962.0724
174: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a14 NUMBER := 0-1962.0724
174: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a16 NUMBER := 0-1962.0724
168: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a14 NUMBER := 0-1962.0724
174: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a16 NUMBER := 0-1962.0724
176: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a14 NUMBER := 0-1962.0724
174: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a16 NUMBER := 0-1962.0724
176: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a19 NUMBER := 0-1962.0724
172: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a14 NUMBER := 0-1962.0724
174: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a16 NUMBER := 0-1962.0724
176: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a19 NUMBER := 0-1962.0724
179: , p0_a20 NUMBER := 0-1962.0724
180: );
173: , p0_a14 NUMBER := 0-1962.0724
174: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a16 NUMBER := 0-1962.0724
176: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a19 NUMBER := 0-1962.0724
179: , p0_a20 NUMBER := 0-1962.0724
180: );
181: procedure validate_list_query_rec(p_api_version_number NUMBER
183: , x_return_status OUT NOCOPY VARCHAR2
184: , x_msg_count OUT NOCOPY NUMBER
185: , x_msg_data OUT NOCOPY VARCHAR2
186: , p5_a0 NUMBER := 0-1962.0724
187: , p5_a1 DATE := fnd_api.g_miss_date
188: , p5_a2 NUMBER := 0-1962.0724
189: , p5_a3 DATE := fnd_api.g_miss_date
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 NUMBER := 0-1962.0724
185: , x_msg_data OUT NOCOPY VARCHAR2
186: , p5_a0 NUMBER := 0-1962.0724
187: , p5_a1 DATE := fnd_api.g_miss_date
188: , p5_a2 NUMBER := 0-1962.0724
189: , p5_a3 DATE := fnd_api.g_miss_date
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 NUMBER := 0-1962.0724
192: , p5_a6 NUMBER := 0-1962.0724
193: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a3 DATE := fnd_api.g_miss_date
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 NUMBER := 0-1962.0724
192: , p5_a6 NUMBER := 0-1962.0724
193: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 NUMBER := 0-1962.0724
192: , p5_a6 NUMBER := 0-1962.0724
193: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a5 NUMBER := 0-1962.0724
192: , p5_a6 NUMBER := 0-1962.0724
193: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a6 NUMBER := 0-1962.0724
193: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a14 NUMBER := 0-1962.0724
193: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a14 NUMBER := 0-1962.0724
201: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a14 NUMBER := 0-1962.0724
201: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p5_a16 NUMBER := 0-1962.0724
195: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a14 NUMBER := 0-1962.0724
201: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p5_a16 NUMBER := 0-1962.0724
203: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a14 NUMBER := 0-1962.0724
201: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p5_a16 NUMBER := 0-1962.0724
203: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a19 NUMBER := 0-1962.0724
199: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a14 NUMBER := 0-1962.0724
201: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p5_a16 NUMBER := 0-1962.0724
203: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a19 NUMBER := 0-1962.0724
206: , p5_a20 NUMBER := 0-1962.0724
207: );
200: , p5_a14 NUMBER := 0-1962.0724
201: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p5_a16 NUMBER := 0-1962.0724
203: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a19 NUMBER := 0-1962.0724
206: , p5_a20 NUMBER := 0-1962.0724
207: );
208: end ams_list_query_pvt_w;