DBA Data[Home] [Help]

APPS.OKL_PDT_STYS_PUB_W dependencies on FND_API

Line 21: , p5_a1 DATE := fnd_api.g_miss_date

17: , p6_a9 out nocopy DATE
18: , p6_a10 out nocopy NUMBER
19: , p6_a11 out nocopy NUMBER
20: , p5_a0 NUMBER := 0-1962.0724
21: , p5_a1 DATE := fnd_api.g_miss_date
22: , p5_a2 DATE := fnd_api.g_miss_date
23: , p5_a3 NUMBER := 0-1962.0724
24: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
25: , p5_a5 NUMBER := 0-1962.0724

Line 22: , p5_a2 DATE := fnd_api.g_miss_date

18: , p6_a10 out nocopy NUMBER
19: , p6_a11 out nocopy NUMBER
20: , p5_a0 NUMBER := 0-1962.0724
21: , p5_a1 DATE := fnd_api.g_miss_date
22: , p5_a2 DATE := fnd_api.g_miss_date
23: , p5_a3 NUMBER := 0-1962.0724
24: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
25: , p5_a5 NUMBER := 0-1962.0724
26: , p5_a6 NUMBER := 0-1962.0724

Line 24: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 28: , p5_a8 DATE := fnd_api.g_miss_date

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

Line 29: , p5_a9 DATE := fnd_api.g_miss_date

25: , p5_a5 NUMBER := 0-1962.0724
26: , p5_a6 NUMBER := 0-1962.0724
27: , p5_a7 NUMBER := 0-1962.0724
28: , p5_a8 DATE := fnd_api.g_miss_date
29: , p5_a9 DATE := fnd_api.g_miss_date
30: , p5_a10 NUMBER := 0-1962.0724
31: , p5_a11 NUMBER := 0-1962.0724
32: );
33: procedure insert_pdt_stys(p_api_version NUMBER

Line 69: , p5_a1 DATE := fnd_api.g_miss_date

65: , x_return_status out nocopy VARCHAR2
66: , x_msg_count out nocopy NUMBER
67: , x_msg_data out nocopy VARCHAR2
68: , p5_a0 NUMBER := 0-1962.0724
69: , p5_a1 DATE := fnd_api.g_miss_date
70: , p5_a2 DATE := fnd_api.g_miss_date
71: , p5_a3 NUMBER := 0-1962.0724
72: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a5 NUMBER := 0-1962.0724

Line 70: , p5_a2 DATE := fnd_api.g_miss_date

66: , x_msg_count out nocopy NUMBER
67: , x_msg_data out nocopy VARCHAR2
68: , p5_a0 NUMBER := 0-1962.0724
69: , p5_a1 DATE := fnd_api.g_miss_date
70: , p5_a2 DATE := fnd_api.g_miss_date
71: , p5_a3 NUMBER := 0-1962.0724
72: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a5 NUMBER := 0-1962.0724
74: , p5_a6 NUMBER := 0-1962.0724

Line 72: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

68: , p5_a0 NUMBER := 0-1962.0724
69: , p5_a1 DATE := fnd_api.g_miss_date
70: , p5_a2 DATE := fnd_api.g_miss_date
71: , p5_a3 NUMBER := 0-1962.0724
72: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a5 NUMBER := 0-1962.0724
74: , p5_a6 NUMBER := 0-1962.0724
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date

Line 76: , p5_a8 DATE := fnd_api.g_miss_date

72: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a5 NUMBER := 0-1962.0724
74: , p5_a6 NUMBER := 0-1962.0724
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
77: , p5_a9 DATE := fnd_api.g_miss_date
78: , p5_a10 NUMBER := 0-1962.0724
79: , p5_a11 NUMBER := 0-1962.0724
80: );

Line 77: , p5_a9 DATE := fnd_api.g_miss_date

73: , p5_a5 NUMBER := 0-1962.0724
74: , p5_a6 NUMBER := 0-1962.0724
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
77: , p5_a9 DATE := fnd_api.g_miss_date
78: , p5_a10 NUMBER := 0-1962.0724
79: , p5_a11 NUMBER := 0-1962.0724
80: );
81: procedure lock_pdt_stys(p_api_version NUMBER

Line 117: , p5_a1 DATE := fnd_api.g_miss_date

113: , p6_a9 out nocopy DATE
114: , p6_a10 out nocopy NUMBER
115: , p6_a11 out nocopy NUMBER
116: , p5_a0 NUMBER := 0-1962.0724
117: , p5_a1 DATE := fnd_api.g_miss_date
118: , p5_a2 DATE := fnd_api.g_miss_date
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 NUMBER := 0-1962.0724

Line 118: , p5_a2 DATE := fnd_api.g_miss_date

114: , p6_a10 out nocopy NUMBER
115: , p6_a11 out nocopy NUMBER
116: , p5_a0 NUMBER := 0-1962.0724
117: , p5_a1 DATE := fnd_api.g_miss_date
118: , p5_a2 DATE := fnd_api.g_miss_date
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 NUMBER := 0-1962.0724
122: , p5_a6 NUMBER := 0-1962.0724

Line 120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

116: , p5_a0 NUMBER := 0-1962.0724
117: , p5_a1 DATE := fnd_api.g_miss_date
118: , p5_a2 DATE := fnd_api.g_miss_date
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 NUMBER := 0-1962.0724
122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date

Line 124: , p5_a8 DATE := fnd_api.g_miss_date

120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 NUMBER := 0-1962.0724
122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
125: , p5_a9 DATE := fnd_api.g_miss_date
126: , p5_a10 NUMBER := 0-1962.0724
127: , p5_a11 NUMBER := 0-1962.0724
128: );

Line 125: , p5_a9 DATE := fnd_api.g_miss_date

121: , p5_a5 NUMBER := 0-1962.0724
122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
125: , p5_a9 DATE := fnd_api.g_miss_date
126: , p5_a10 NUMBER := 0-1962.0724
127: , p5_a11 NUMBER := 0-1962.0724
128: );
129: procedure update_pdt_stys(p_api_version NUMBER

Line 165: , p5_a1 DATE := fnd_api.g_miss_date

161: , x_return_status out nocopy VARCHAR2
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 NUMBER := 0-1962.0724
165: , p5_a1 DATE := fnd_api.g_miss_date
166: , p5_a2 DATE := fnd_api.g_miss_date
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a5 NUMBER := 0-1962.0724

Line 166: , p5_a2 DATE := fnd_api.g_miss_date

162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 NUMBER := 0-1962.0724
165: , p5_a1 DATE := fnd_api.g_miss_date
166: , p5_a2 DATE := fnd_api.g_miss_date
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724

Line 168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

164: , p5_a0 NUMBER := 0-1962.0724
165: , p5_a1 DATE := fnd_api.g_miss_date
166: , p5_a2 DATE := fnd_api.g_miss_date
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date

Line 172: , p5_a8 DATE := fnd_api.g_miss_date

168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
173: , p5_a9 DATE := fnd_api.g_miss_date
174: , p5_a10 NUMBER := 0-1962.0724
175: , p5_a11 NUMBER := 0-1962.0724
176: );

Line 173: , p5_a9 DATE := fnd_api.g_miss_date

169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
173: , p5_a9 DATE := fnd_api.g_miss_date
174: , p5_a10 NUMBER := 0-1962.0724
175: , p5_a11 NUMBER := 0-1962.0724
176: );
177: procedure delete_pdt_stys(p_api_version NUMBER

Line 201: , p5_a1 DATE := fnd_api.g_miss_date

197: , x_return_status out nocopy VARCHAR2
198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 NUMBER := 0-1962.0724
201: , p5_a1 DATE := fnd_api.g_miss_date
202: , p5_a2 DATE := fnd_api.g_miss_date
203: , p5_a3 NUMBER := 0-1962.0724
204: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a5 NUMBER := 0-1962.0724

Line 202: , p5_a2 DATE := fnd_api.g_miss_date

198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 NUMBER := 0-1962.0724
201: , p5_a1 DATE := fnd_api.g_miss_date
202: , p5_a2 DATE := fnd_api.g_miss_date
203: , p5_a3 NUMBER := 0-1962.0724
204: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a5 NUMBER := 0-1962.0724
206: , p5_a6 NUMBER := 0-1962.0724

Line 204: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

200: , p5_a0 NUMBER := 0-1962.0724
201: , p5_a1 DATE := fnd_api.g_miss_date
202: , p5_a2 DATE := fnd_api.g_miss_date
203: , p5_a3 NUMBER := 0-1962.0724
204: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a5 NUMBER := 0-1962.0724
206: , p5_a6 NUMBER := 0-1962.0724
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date

Line 208: , p5_a8 DATE := fnd_api.g_miss_date

204: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a5 NUMBER := 0-1962.0724
206: , p5_a6 NUMBER := 0-1962.0724
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a9 DATE := fnd_api.g_miss_date
210: , p5_a10 NUMBER := 0-1962.0724
211: , p5_a11 NUMBER := 0-1962.0724
212: );

Line 209: , p5_a9 DATE := fnd_api.g_miss_date

205: , p5_a5 NUMBER := 0-1962.0724
206: , p5_a6 NUMBER := 0-1962.0724
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a9 DATE := fnd_api.g_miss_date
210: , p5_a10 NUMBER := 0-1962.0724
211: , p5_a11 NUMBER := 0-1962.0724
212: );
213: procedure validate_pdt_stys(p_api_version NUMBER