APPS.OKL_POOLCONC_PVT_W dependencies on FND_API

Line 11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;

7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:

Line 12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;

8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as

Line 17: a number := fnd_api.g_miss_num;

13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;

Line 77: , p6_a1 VARCHAR2 := fnd_api.g_miss_char

73: , p_sty_id2 NUMBER
74: , p_stream_type_subclass VARCHAR2
75: , p_multi_org VARCHAR2
76: , p6_a0 NUMBER := 0-1962.0724
77: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a3 NUMBER := 0-1962.0724
80: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p6_a5 NUMBER := 0-1962.0724

Line 78: , p6_a2 VARCHAR2 := fnd_api.g_miss_char

74: , p_stream_type_subclass VARCHAR2
75: , p_multi_org VARCHAR2
76: , p6_a0 NUMBER := 0-1962.0724
77: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a3 NUMBER := 0-1962.0724
80: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p6_a5 NUMBER := 0-1962.0724
82: , p6_a6 NUMBER := 0-1962.0724

Line 80: , p6_a4 VARCHAR2 := fnd_api.g_miss_char

76: , p6_a0 NUMBER := 0-1962.0724
77: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a3 NUMBER := 0-1962.0724
80: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p6_a5 NUMBER := 0-1962.0724
82: , p6_a6 NUMBER := 0-1962.0724
83: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a8 NUMBER := 0-1962.0724

Line 83: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

79: , p6_a3 NUMBER := 0-1962.0724
80: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p6_a5 NUMBER := 0-1962.0724
82: , p6_a6 NUMBER := 0-1962.0724
83: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a8 NUMBER := 0-1962.0724
85: , p6_a9 DATE := fnd_api.g_miss_date
86: , p6_a10 DATE := fnd_api.g_miss_date
87: , p6_a11 DATE := fnd_api.g_miss_date

Line 85: , p6_a9 DATE := fnd_api.g_miss_date

81: , p6_a5 NUMBER := 0-1962.0724
82: , p6_a6 NUMBER := 0-1962.0724
83: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a8 NUMBER := 0-1962.0724
85: , p6_a9 DATE := fnd_api.g_miss_date
86: , p6_a10 DATE := fnd_api.g_miss_date
87: , p6_a11 DATE := fnd_api.g_miss_date
88: , p6_a12 DATE := fnd_api.g_miss_date
89: , p6_a13 NUMBER := 0-1962.0724

Line 86: , p6_a10 DATE := fnd_api.g_miss_date

82: , p6_a6 NUMBER := 0-1962.0724
83: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a8 NUMBER := 0-1962.0724
85: , p6_a9 DATE := fnd_api.g_miss_date
86: , p6_a10 DATE := fnd_api.g_miss_date
87: , p6_a11 DATE := fnd_api.g_miss_date
88: , p6_a12 DATE := fnd_api.g_miss_date
89: , p6_a13 NUMBER := 0-1962.0724
90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

Line 87: , p6_a11 DATE := fnd_api.g_miss_date

83: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a8 NUMBER := 0-1962.0724
85: , p6_a9 DATE := fnd_api.g_miss_date
86: , p6_a10 DATE := fnd_api.g_miss_date
87: , p6_a11 DATE := fnd_api.g_miss_date
88: , p6_a12 DATE := fnd_api.g_miss_date
89: , p6_a13 NUMBER := 0-1962.0724
90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

Line 88: , p6_a12 DATE := fnd_api.g_miss_date

84: , p6_a8 NUMBER := 0-1962.0724
85: , p6_a9 DATE := fnd_api.g_miss_date
86: , p6_a10 DATE := fnd_api.g_miss_date
87: , p6_a11 DATE := fnd_api.g_miss_date
88: , p6_a12 DATE := fnd_api.g_miss_date
89: , p6_a13 NUMBER := 0-1962.0724
90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
92: , p6_a16 NUMBER := 0-1962.0724

Line 90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

86: , p6_a10 DATE := fnd_api.g_miss_date
87: , p6_a11 DATE := fnd_api.g_miss_date
88: , p6_a12 DATE := fnd_api.g_miss_date
89: , p6_a13 NUMBER := 0-1962.0724
90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
92: , p6_a16 NUMBER := 0-1962.0724
93: , p6_a17 NUMBER := 0-1962.0724
94: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

Line 91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

87: , p6_a11 DATE := fnd_api.g_miss_date
88: , p6_a12 DATE := fnd_api.g_miss_date
89: , p6_a13 NUMBER := 0-1962.0724
90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
92: , p6_a16 NUMBER := 0-1962.0724
93: , p6_a17 NUMBER := 0-1962.0724
94: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
95: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

Line 94: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

90: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
92: , p6_a16 NUMBER := 0-1962.0724
93: , p6_a17 NUMBER := 0-1962.0724
94: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
95: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
96: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
97: , p6_a21 NUMBER := 0-1962.0724
98: , p6_a22 NUMBER := 0-1962.0724

Line 95: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

91: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
92: , p6_a16 NUMBER := 0-1962.0724
93: , p6_a17 NUMBER := 0-1962.0724
94: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
95: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
96: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
97: , p6_a21 NUMBER := 0-1962.0724
98: , p6_a22 NUMBER := 0-1962.0724
99: , p6_a23 NUMBER := 0-1962.0724

Line 96: , p6_a20 VARCHAR2 := fnd_api.g_miss_char

92: , p6_a16 NUMBER := 0-1962.0724
93: , p6_a17 NUMBER := 0-1962.0724
94: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
95: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
96: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
97: , p6_a21 NUMBER := 0-1962.0724
98: , p6_a22 NUMBER := 0-1962.0724
99: , p6_a23 NUMBER := 0-1962.0724
100: , p6_a24 NUMBER := 0-1962.0724

Line 104: , p6_a28 VARCHAR2 := fnd_api.g_miss_char

100: , p6_a24 NUMBER := 0-1962.0724
101: , p6_a25 NUMBER := 0-1962.0724
102: , p6_a26 NUMBER := 0-1962.0724
103: , p6_a27 NUMBER := 0-1962.0724
104: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a32 DATE := fnd_api.g_miss_date

Line 105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char

101: , p6_a25 NUMBER := 0-1962.0724
102: , p6_a26 NUMBER := 0-1962.0724
103: , p6_a27 NUMBER := 0-1962.0724
104: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a32 DATE := fnd_api.g_miss_date
109: , p6_a33 DATE := fnd_api.g_miss_date

Line 106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char

102: , p6_a26 NUMBER := 0-1962.0724
103: , p6_a27 NUMBER := 0-1962.0724
104: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a32 DATE := fnd_api.g_miss_date
109: , p6_a33 DATE := fnd_api.g_miss_date
110: , p6_a34 NUMBER := 0-1962.0724

Line 107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char

103: , p6_a27 NUMBER := 0-1962.0724
104: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a32 DATE := fnd_api.g_miss_date
109: , p6_a33 DATE := fnd_api.g_miss_date
110: , p6_a34 NUMBER := 0-1962.0724
111: , p6_a35 NUMBER := 0-1962.0724

Line 108: , p6_a32 DATE := fnd_api.g_miss_date

104: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a32 DATE := fnd_api.g_miss_date
109: , p6_a33 DATE := fnd_api.g_miss_date
110: , p6_a34 NUMBER := 0-1962.0724
111: , p6_a35 NUMBER := 0-1962.0724
112: , p6_a36 DATE := fnd_api.g_miss_date

Line 109: , p6_a33 DATE := fnd_api.g_miss_date

105: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a32 DATE := fnd_api.g_miss_date
109: , p6_a33 DATE := fnd_api.g_miss_date
110: , p6_a34 NUMBER := 0-1962.0724
111: , p6_a35 NUMBER := 0-1962.0724
112: , p6_a36 DATE := fnd_api.g_miss_date
113: , p6_a37 DATE := fnd_api.g_miss_date

Line 112: , p6_a36 DATE := fnd_api.g_miss_date

108: , p6_a32 DATE := fnd_api.g_miss_date
109: , p6_a33 DATE := fnd_api.g_miss_date
110: , p6_a34 NUMBER := 0-1962.0724
111: , p6_a35 NUMBER := 0-1962.0724
112: , p6_a36 DATE := fnd_api.g_miss_date
113: , p6_a37 DATE := fnd_api.g_miss_date
114: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
116: )

Line 113: , p6_a37 DATE := fnd_api.g_miss_date

109: , p6_a33 DATE := fnd_api.g_miss_date
110: , p6_a34 NUMBER := 0-1962.0724
111: , p6_a35 NUMBER := 0-1962.0724
112: , p6_a36 DATE := fnd_api.g_miss_date
113: , p6_a37 DATE := fnd_api.g_miss_date
114: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
116: )
117:

Line 114: , p6_a38 VARCHAR2 := fnd_api.g_miss_char

110: , p6_a34 NUMBER := 0-1962.0724
111: , p6_a35 NUMBER := 0-1962.0724
112: , p6_a36 DATE := fnd_api.g_miss_date
113: , p6_a37 DATE := fnd_api.g_miss_date
114: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
116: )
117:
118: as

Line 115: , p6_a39 VARCHAR2 := fnd_api.g_miss_char

111: , p6_a35 NUMBER := 0-1962.0724
112: , p6_a36 DATE := fnd_api.g_miss_date
113: , p6_a37 DATE := fnd_api.g_miss_date
114: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
116: )
117:
118: as
119: ddp_polsrch_rec okl_poolconc_pvt.polsrch_rec_type;

Line 211: , p6_a1 VARCHAR2 := fnd_api.g_miss_char

207: , p_stream_type_subclass VARCHAR2
208: , p_multi_org VARCHAR2
209: , p_action_code VARCHAR2
210: , p6_a0 NUMBER := 0-1962.0724
211: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a3 NUMBER := 0-1962.0724
214: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a5 NUMBER := 0-1962.0724

Line 212: , p6_a2 VARCHAR2 := fnd_api.g_miss_char

208: , p_multi_org VARCHAR2
209: , p_action_code VARCHAR2
210: , p6_a0 NUMBER := 0-1962.0724
211: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a3 NUMBER := 0-1962.0724
214: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a5 NUMBER := 0-1962.0724
216: , p6_a6 NUMBER := 0-1962.0724

Line 214: , p6_a4 VARCHAR2 := fnd_api.g_miss_char

210: , p6_a0 NUMBER := 0-1962.0724
211: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a3 NUMBER := 0-1962.0724
214: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a5 NUMBER := 0-1962.0724
216: , p6_a6 NUMBER := 0-1962.0724
217: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a8 NUMBER := 0-1962.0724

Line 217: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

213: , p6_a3 NUMBER := 0-1962.0724
214: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a5 NUMBER := 0-1962.0724
216: , p6_a6 NUMBER := 0-1962.0724
217: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a8 NUMBER := 0-1962.0724
219: , p6_a9 DATE := fnd_api.g_miss_date
220: , p6_a10 DATE := fnd_api.g_miss_date
221: , p6_a11 DATE := fnd_api.g_miss_date

Line 219: , p6_a9 DATE := fnd_api.g_miss_date

215: , p6_a5 NUMBER := 0-1962.0724
216: , p6_a6 NUMBER := 0-1962.0724
217: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a8 NUMBER := 0-1962.0724
219: , p6_a9 DATE := fnd_api.g_miss_date
220: , p6_a10 DATE := fnd_api.g_miss_date
221: , p6_a11 DATE := fnd_api.g_miss_date
222: , p6_a12 DATE := fnd_api.g_miss_date
223: , p6_a13 NUMBER := 0-1962.0724

Line 220: , p6_a10 DATE := fnd_api.g_miss_date

216: , p6_a6 NUMBER := 0-1962.0724
217: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a8 NUMBER := 0-1962.0724
219: , p6_a9 DATE := fnd_api.g_miss_date
220: , p6_a10 DATE := fnd_api.g_miss_date
221: , p6_a11 DATE := fnd_api.g_miss_date
222: , p6_a12 DATE := fnd_api.g_miss_date
223: , p6_a13 NUMBER := 0-1962.0724
224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

Line 221: , p6_a11 DATE := fnd_api.g_miss_date

217: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a8 NUMBER := 0-1962.0724
219: , p6_a9 DATE := fnd_api.g_miss_date
220: , p6_a10 DATE := fnd_api.g_miss_date
221: , p6_a11 DATE := fnd_api.g_miss_date
222: , p6_a12 DATE := fnd_api.g_miss_date
223: , p6_a13 NUMBER := 0-1962.0724
224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

Line 222: , p6_a12 DATE := fnd_api.g_miss_date

218: , p6_a8 NUMBER := 0-1962.0724
219: , p6_a9 DATE := fnd_api.g_miss_date
220: , p6_a10 DATE := fnd_api.g_miss_date
221: , p6_a11 DATE := fnd_api.g_miss_date
222: , p6_a12 DATE := fnd_api.g_miss_date
223: , p6_a13 NUMBER := 0-1962.0724
224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a16 NUMBER := 0-1962.0724

Line 224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

220: , p6_a10 DATE := fnd_api.g_miss_date
221: , p6_a11 DATE := fnd_api.g_miss_date
222: , p6_a12 DATE := fnd_api.g_miss_date
223: , p6_a13 NUMBER := 0-1962.0724
224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a16 NUMBER := 0-1962.0724
227: , p6_a17 NUMBER := 0-1962.0724
228: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

Line 225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

221: , p6_a11 DATE := fnd_api.g_miss_date
222: , p6_a12 DATE := fnd_api.g_miss_date
223: , p6_a13 NUMBER := 0-1962.0724
224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a16 NUMBER := 0-1962.0724
227: , p6_a17 NUMBER := 0-1962.0724
228: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
229: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

Line 228: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

224: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a16 NUMBER := 0-1962.0724
227: , p6_a17 NUMBER := 0-1962.0724
228: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
229: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
230: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
231: , p6_a21 NUMBER := 0-1962.0724
232: , p6_a22 NUMBER := 0-1962.0724

Line 229: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

225: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a16 NUMBER := 0-1962.0724
227: , p6_a17 NUMBER := 0-1962.0724
228: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
229: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
230: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
231: , p6_a21 NUMBER := 0-1962.0724
232: , p6_a22 NUMBER := 0-1962.0724
233: , p6_a23 NUMBER := 0-1962.0724

Line 230: , p6_a20 VARCHAR2 := fnd_api.g_miss_char

226: , p6_a16 NUMBER := 0-1962.0724
227: , p6_a17 NUMBER := 0-1962.0724
228: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
229: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
230: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
231: , p6_a21 NUMBER := 0-1962.0724
232: , p6_a22 NUMBER := 0-1962.0724
233: , p6_a23 NUMBER := 0-1962.0724
234: , p6_a24 NUMBER := 0-1962.0724

Line 238: , p6_a28 VARCHAR2 := fnd_api.g_miss_char

234: , p6_a24 NUMBER := 0-1962.0724
235: , p6_a25 NUMBER := 0-1962.0724
236: , p6_a26 NUMBER := 0-1962.0724
237: , p6_a27 NUMBER := 0-1962.0724
238: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a32 DATE := fnd_api.g_miss_date

Line 239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char

235: , p6_a25 NUMBER := 0-1962.0724
236: , p6_a26 NUMBER := 0-1962.0724
237: , p6_a27 NUMBER := 0-1962.0724
238: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a32 DATE := fnd_api.g_miss_date
243: , p6_a33 DATE := fnd_api.g_miss_date

Line 240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char

236: , p6_a26 NUMBER := 0-1962.0724
237: , p6_a27 NUMBER := 0-1962.0724
238: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a32 DATE := fnd_api.g_miss_date
243: , p6_a33 DATE := fnd_api.g_miss_date
244: , p6_a34 NUMBER := 0-1962.0724

Line 241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char

237: , p6_a27 NUMBER := 0-1962.0724
238: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a32 DATE := fnd_api.g_miss_date
243: , p6_a33 DATE := fnd_api.g_miss_date
244: , p6_a34 NUMBER := 0-1962.0724
245: , p6_a35 NUMBER := 0-1962.0724

Line 242: , p6_a32 DATE := fnd_api.g_miss_date

238: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a32 DATE := fnd_api.g_miss_date
243: , p6_a33 DATE := fnd_api.g_miss_date
244: , p6_a34 NUMBER := 0-1962.0724
245: , p6_a35 NUMBER := 0-1962.0724
246: , p6_a36 DATE := fnd_api.g_miss_date

Line 243: , p6_a33 DATE := fnd_api.g_miss_date

239: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a32 DATE := fnd_api.g_miss_date
243: , p6_a33 DATE := fnd_api.g_miss_date
244: , p6_a34 NUMBER := 0-1962.0724
245: , p6_a35 NUMBER := 0-1962.0724
246: , p6_a36 DATE := fnd_api.g_miss_date
247: , p6_a37 DATE := fnd_api.g_miss_date

Line 246: , p6_a36 DATE := fnd_api.g_miss_date

242: , p6_a32 DATE := fnd_api.g_miss_date
243: , p6_a33 DATE := fnd_api.g_miss_date
244: , p6_a34 NUMBER := 0-1962.0724
245: , p6_a35 NUMBER := 0-1962.0724
246: , p6_a36 DATE := fnd_api.g_miss_date
247: , p6_a37 DATE := fnd_api.g_miss_date
248: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
250: )

Line 247: , p6_a37 DATE := fnd_api.g_miss_date

243: , p6_a33 DATE := fnd_api.g_miss_date
244: , p6_a34 NUMBER := 0-1962.0724
245: , p6_a35 NUMBER := 0-1962.0724
246: , p6_a36 DATE := fnd_api.g_miss_date
247: , p6_a37 DATE := fnd_api.g_miss_date
248: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
250: )
251:

Line 248: , p6_a38 VARCHAR2 := fnd_api.g_miss_char

244: , p6_a34 NUMBER := 0-1962.0724
245: , p6_a35 NUMBER := 0-1962.0724
246: , p6_a36 DATE := fnd_api.g_miss_date
247: , p6_a37 DATE := fnd_api.g_miss_date
248: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as

Line 249: , p6_a39 VARCHAR2 := fnd_api.g_miss_char

245: , p6_a35 NUMBER := 0-1962.0724
246: , p6_a36 DATE := fnd_api.g_miss_date
247: , p6_a37 DATE := fnd_api.g_miss_date
248: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as
253: ddp_polsrch_rec okl_poolconc_pvt.polsrch_rec_type;