DBA Data[Home] [Help]

APPS.OKL_FNCTN_PRMTRS_PUB_W dependencies on FND_API

Line 24: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

20: , p6_a12 out nocopy DATE
21: , p6_a13 out nocopy NUMBER
22: , p5_a0 NUMBER := 0-1962.0724
23: , p5_a1 NUMBER := 0-1962.0724
24: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
25: , p5_a3 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

24: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
25: , p5_a3 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date

Line 29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

25: , p5_a3 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724

Line 30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
34: , p5_a12 DATE := fnd_api.g_miss_date

Line 32: , p5_a10 DATE := fnd_api.g_miss_date

28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
34: , p5_a12 DATE := fnd_api.g_miss_date
35: , p5_a13 NUMBER := 0-1962.0724
36: );

Line 34: , p5_a12 DATE := fnd_api.g_miss_date

30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
34: , p5_a12 DATE := fnd_api.g_miss_date
35: , p5_a13 NUMBER := 0-1962.0724
36: );
37: procedure insert_fnctn_prmtrs(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2

Line 78: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p5_a0 NUMBER := 0-1962.0724
77: , p5_a1 NUMBER := 0-1962.0724
78: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a3 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

78: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a3 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date

Line 83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

79: , p5_a3 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724

Line 84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
88: , p5_a12 DATE := fnd_api.g_miss_date

Line 86: , p5_a10 DATE := fnd_api.g_miss_date

82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
88: , p5_a12 DATE := fnd_api.g_miss_date
89: , p5_a13 NUMBER := 0-1962.0724
90: );

Line 88: , p5_a12 DATE := fnd_api.g_miss_date

84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
88: , p5_a12 DATE := fnd_api.g_miss_date
89: , p5_a13 NUMBER := 0-1962.0724
90: );
91: procedure lock_fnctn_prmtrs(p_api_version NUMBER
92: , p_init_msg_list VARCHAR2

Line 132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

128: , p6_a12 out nocopy DATE
129: , p6_a13 out nocopy NUMBER
130: , p5_a0 NUMBER := 0-1962.0724
131: , p5_a1 NUMBER := 0-1962.0724
132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a3 NUMBER := 0-1962.0724
134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 NUMBER := 0-1962.0724
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a3 NUMBER := 0-1962.0724
134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 NUMBER := 0-1962.0724
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date

Line 137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

133: , p5_a3 NUMBER := 0-1962.0724
134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 NUMBER := 0-1962.0724
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724

Line 138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 NUMBER := 0-1962.0724
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
142: , p5_a12 DATE := fnd_api.g_miss_date

Line 140: , p5_a10 DATE := fnd_api.g_miss_date

136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
142: , p5_a12 DATE := fnd_api.g_miss_date
143: , p5_a13 NUMBER := 0-1962.0724
144: );

Line 142: , p5_a12 DATE := fnd_api.g_miss_date

138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
142: , p5_a12 DATE := fnd_api.g_miss_date
143: , p5_a13 NUMBER := 0-1962.0724
144: );
145: procedure update_fnctn_prmtrs(p_api_version NUMBER
146: , p_init_msg_list VARCHAR2

Line 186: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 NUMBER := 0-1962.0724
185: , p5_a1 NUMBER := 0-1962.0724
186: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a3 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

186: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a3 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date

Line 191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

187: , p5_a3 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724

Line 192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
196: , p5_a12 DATE := fnd_api.g_miss_date

Line 194: , p5_a10 DATE := fnd_api.g_miss_date

190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
196: , p5_a12 DATE := fnd_api.g_miss_date
197: , p5_a13 NUMBER := 0-1962.0724
198: );

Line 196: , p5_a12 DATE := fnd_api.g_miss_date

192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
196: , p5_a12 DATE := fnd_api.g_miss_date
197: , p5_a13 NUMBER := 0-1962.0724
198: );
199: procedure delete_fnctn_prmtrs(p_api_version NUMBER
200: , p_init_msg_list VARCHAR2

Line 226: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 NUMBER := 0-1962.0724
225: , p5_a1 NUMBER := 0-1962.0724
226: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a3 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

226: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a3 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date

Line 231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

227: , p5_a3 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724

Line 232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
236: , p5_a12 DATE := fnd_api.g_miss_date

Line 234: , p5_a10 DATE := fnd_api.g_miss_date

230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
236: , p5_a12 DATE := fnd_api.g_miss_date
237: , p5_a13 NUMBER := 0-1962.0724
238: );

Line 236: , p5_a12 DATE := fnd_api.g_miss_date

232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
236: , p5_a12 DATE := fnd_api.g_miss_date
237: , p5_a13 NUMBER := 0-1962.0724
238: );
239: procedure validate_fnctn_prmtrs(p_api_version NUMBER
240: , p_init_msg_list VARCHAR2