DBA Data[Home] [Help]

APPS.OKL_PERD_STATUS_PVT_W dependencies on FND_API

Line 91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

87: , p6_a24 out nocopy JTF_NUMBER_TABLE
88: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date

Line 92: , p5_a3 DATE := fnd_api.g_miss_date

88: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date

Line 94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724

Line 95: , p5_a6 DATE := fnd_api.g_miss_date

91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724

Line 96: , p5_a7 DATE := fnd_api.g_miss_date

92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724

Line 97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 102: , p5_a13 DATE := fnd_api.g_miss_date

98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date

Line 108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date

Line 109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724

Line 110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 111: , p5_a22 DATE := fnd_api.g_miss_date

107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
115: );

Line 112: , p5_a23 DATE := fnd_api.g_miss_date

108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
115: );
116: procedure update_period_status(p_api_version NUMBER

Line 114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
115: );
116: procedure update_period_status(p_api_version NUMBER
117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2

Line 155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 NUMBER := 0-1962.0724
154: , p5_a1 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date

Line 156: , p5_a3 DATE := fnd_api.g_miss_date

152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 NUMBER := 0-1962.0724
154: , p5_a1 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date

Line 158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

154: , p5_a1 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724

Line 159: , p5_a6 DATE := fnd_api.g_miss_date

155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724

Line 160: , p5_a7 DATE := fnd_api.g_miss_date

156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724

Line 161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 166: , p5_a13 DATE := fnd_api.g_miss_date

162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date

Line 172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date

Line 173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724

Line 174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 175: , p5_a22 DATE := fnd_api.g_miss_date

171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
179: );

Line 176: , p5_a23 DATE := fnd_api.g_miss_date

172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
179: );
180: end okl_perd_status_pvt_w;

Line 178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
179: );
180: end okl_perd_status_pvt_w;