APPS.OKL_INDICES_PVT_W dependencies on FND_API

Line 71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

67: , p8_a13 out nocopy JTF_DATE_TABLE
68: , p8_a14 out nocopy JTF_NUMBER_TABLE
69: , p5_a0 NUMBER := 0-1962.0724
70: , p5_a1 NUMBER := 0-1962.0724
71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 73: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

70: , p5_a1 NUMBER := 0-1962.0724
71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

73: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

74: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

75: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

76: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

77: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

78: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

79: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

80: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

81: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

82: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

83: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a22 NUMBER := 0-1962.0724

Line 88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

84: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a22 NUMBER := 0-1962.0724
92: , p5_a23 NUMBER := 0-1962.0724

Line 89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

85: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a22 NUMBER := 0-1962.0724
92: , p5_a23 NUMBER := 0-1962.0724
93: , p5_a24 NUMBER := 0-1962.0724

Line 90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

86: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a22 NUMBER := 0-1962.0724
92: , p5_a23 NUMBER := 0-1962.0724
93: , p5_a24 NUMBER := 0-1962.0724
94: , p5_a25 DATE := fnd_api.g_miss_date

Line 94: , p5_a25 DATE := fnd_api.g_miss_date

90: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a22 NUMBER := 0-1962.0724
92: , p5_a23 NUMBER := 0-1962.0724
93: , p5_a24 NUMBER := 0-1962.0724
94: , p5_a25 DATE := fnd_api.g_miss_date
95: , p5_a26 NUMBER := 0-1962.0724
96: , p5_a27 DATE := fnd_api.g_miss_date
97: , p5_a28 NUMBER := 0-1962.0724
98: , p5_a29 DATE := fnd_api.g_miss_date

Line 96: , p5_a27 DATE := fnd_api.g_miss_date

92: , p5_a23 NUMBER := 0-1962.0724
93: , p5_a24 NUMBER := 0-1962.0724
94: , p5_a25 DATE := fnd_api.g_miss_date
95: , p5_a26 NUMBER := 0-1962.0724
96: , p5_a27 DATE := fnd_api.g_miss_date
97: , p5_a28 NUMBER := 0-1962.0724
98: , p5_a29 DATE := fnd_api.g_miss_date
99: , p5_a30 NUMBER := 0-1962.0724
100: );

Line 98: , p5_a29 DATE := fnd_api.g_miss_date

94: , p5_a25 DATE := fnd_api.g_miss_date
95: , p5_a26 NUMBER := 0-1962.0724
96: , p5_a27 DATE := fnd_api.g_miss_date
97: , p5_a28 NUMBER := 0-1962.0724
98: , p5_a29 DATE := fnd_api.g_miss_date
99: , p5_a30 NUMBER := 0-1962.0724
100: );
101: procedure update_indices(p_api_version NUMBER
102: , p_init_msg_list VARCHAR2

Line 169: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

165: , p8_a13 out nocopy JTF_DATE_TABLE
166: , p8_a14 out nocopy JTF_NUMBER_TABLE
167: , p5_a0 NUMBER := 0-1962.0724
168: , p5_a1 NUMBER := 0-1962.0724
169: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

166: , p8_a14 out nocopy JTF_NUMBER_TABLE
167: , p5_a0 NUMBER := 0-1962.0724
168: , p5_a1 NUMBER := 0-1962.0724
169: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

167: , p5_a0 NUMBER := 0-1962.0724
168: , p5_a1 NUMBER := 0-1962.0724
169: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

168: , p5_a1 NUMBER := 0-1962.0724
169: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

169: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

170: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

171: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

172: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

173: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

174: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

175: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

176: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

177: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

178: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

179: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

180: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

181: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a22 NUMBER := 0-1962.0724

Line 186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

182: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a22 NUMBER := 0-1962.0724
190: , p5_a23 NUMBER := 0-1962.0724

Line 187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

183: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a22 NUMBER := 0-1962.0724
190: , p5_a23 NUMBER := 0-1962.0724
191: , p5_a24 NUMBER := 0-1962.0724

Line 188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

184: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a22 NUMBER := 0-1962.0724
190: , p5_a23 NUMBER := 0-1962.0724
191: , p5_a24 NUMBER := 0-1962.0724
192: , p5_a25 DATE := fnd_api.g_miss_date

Line 192: , p5_a25 DATE := fnd_api.g_miss_date

188: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a22 NUMBER := 0-1962.0724
190: , p5_a23 NUMBER := 0-1962.0724
191: , p5_a24 NUMBER := 0-1962.0724
192: , p5_a25 DATE := fnd_api.g_miss_date
193: , p5_a26 NUMBER := 0-1962.0724
194: , p5_a27 DATE := fnd_api.g_miss_date
195: , p5_a28 NUMBER := 0-1962.0724
196: , p5_a29 DATE := fnd_api.g_miss_date

Line 194: , p5_a27 DATE := fnd_api.g_miss_date

190: , p5_a23 NUMBER := 0-1962.0724
191: , p5_a24 NUMBER := 0-1962.0724
192: , p5_a25 DATE := fnd_api.g_miss_date
193: , p5_a26 NUMBER := 0-1962.0724
194: , p5_a27 DATE := fnd_api.g_miss_date
195: , p5_a28 NUMBER := 0-1962.0724
196: , p5_a29 DATE := fnd_api.g_miss_date
197: , p5_a30 NUMBER := 0-1962.0724
198: );

Line 196: , p5_a29 DATE := fnd_api.g_miss_date

192: , p5_a25 DATE := fnd_api.g_miss_date
193: , p5_a26 NUMBER := 0-1962.0724
194: , p5_a27 DATE := fnd_api.g_miss_date
195: , p5_a28 NUMBER := 0-1962.0724
196: , p5_a29 DATE := fnd_api.g_miss_date
197: , p5_a30 NUMBER := 0-1962.0724
198: );
199: procedure validate_indices(p_api_version NUMBER
200: , p_init_msg_list VARCHAR2

Line 221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

217: , p6_a13 JTF_DATE_TABLE
218: , p6_a14 JTF_NUMBER_TABLE
219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

218: , p6_a14 JTF_NUMBER_TABLE
219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

228: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

229: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

230: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

231: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

232: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

233: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a22 NUMBER := 0-1962.0724

Line 238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

234: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a22 NUMBER := 0-1962.0724
242: , p5_a23 NUMBER := 0-1962.0724

Line 239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

235: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a22 NUMBER := 0-1962.0724
242: , p5_a23 NUMBER := 0-1962.0724
243: , p5_a24 NUMBER := 0-1962.0724

Line 240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

236: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a22 NUMBER := 0-1962.0724
242: , p5_a23 NUMBER := 0-1962.0724
243: , p5_a24 NUMBER := 0-1962.0724
244: , p5_a25 DATE := fnd_api.g_miss_date

Line 244: , p5_a25 DATE := fnd_api.g_miss_date

240: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a22 NUMBER := 0-1962.0724
242: , p5_a23 NUMBER := 0-1962.0724
243: , p5_a24 NUMBER := 0-1962.0724
244: , p5_a25 DATE := fnd_api.g_miss_date
245: , p5_a26 NUMBER := 0-1962.0724
246: , p5_a27 DATE := fnd_api.g_miss_date
247: , p5_a28 NUMBER := 0-1962.0724
248: , p5_a29 DATE := fnd_api.g_miss_date

Line 246: , p5_a27 DATE := fnd_api.g_miss_date

242: , p5_a23 NUMBER := 0-1962.0724
243: , p5_a24 NUMBER := 0-1962.0724
244: , p5_a25 DATE := fnd_api.g_miss_date
245: , p5_a26 NUMBER := 0-1962.0724
246: , p5_a27 DATE := fnd_api.g_miss_date
247: , p5_a28 NUMBER := 0-1962.0724
248: , p5_a29 DATE := fnd_api.g_miss_date
249: , p5_a30 NUMBER := 0-1962.0724
250: );

Line 248: , p5_a29 DATE := fnd_api.g_miss_date

244: , p5_a25 DATE := fnd_api.g_miss_date
245: , p5_a26 NUMBER := 0-1962.0724
246: , p5_a27 DATE := fnd_api.g_miss_date
247: , p5_a28 NUMBER := 0-1962.0724
248: , p5_a29 DATE := fnd_api.g_miss_date
249: , p5_a30 NUMBER := 0-1962.0724
250: );
251: procedure create_indices(p_api_version NUMBER
252: , p_init_msg_list VARCHAR2

Line 357: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

353: , p6_a29 out nocopy DATE
354: , p6_a30 out nocopy NUMBER
355: , p5_a0 NUMBER := 0-1962.0724
356: , p5_a1 NUMBER := 0-1962.0724
357: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

354: , p6_a30 out nocopy NUMBER
355: , p5_a0 NUMBER := 0-1962.0724
356: , p5_a1 NUMBER := 0-1962.0724
357: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

355: , p5_a0 NUMBER := 0-1962.0724
356: , p5_a1 NUMBER := 0-1962.0724
357: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

356: , p5_a1 NUMBER := 0-1962.0724
357: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

357: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

358: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

359: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

360: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

361: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

362: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

363: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

364: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

365: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

366: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

367: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

368: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

369: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a22 NUMBER := 0-1962.0724

Line 374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

370: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a22 NUMBER := 0-1962.0724
378: , p5_a23 NUMBER := 0-1962.0724

Line 375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

371: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a22 NUMBER := 0-1962.0724
378: , p5_a23 NUMBER := 0-1962.0724
379: , p5_a24 NUMBER := 0-1962.0724

Line 376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

372: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a22 NUMBER := 0-1962.0724
378: , p5_a23 NUMBER := 0-1962.0724
379: , p5_a24 NUMBER := 0-1962.0724
380: , p5_a25 DATE := fnd_api.g_miss_date

Line 380: , p5_a25 DATE := fnd_api.g_miss_date

376: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a22 NUMBER := 0-1962.0724
378: , p5_a23 NUMBER := 0-1962.0724
379: , p5_a24 NUMBER := 0-1962.0724
380: , p5_a25 DATE := fnd_api.g_miss_date
381: , p5_a26 NUMBER := 0-1962.0724
382: , p5_a27 DATE := fnd_api.g_miss_date
383: , p5_a28 NUMBER := 0-1962.0724
384: , p5_a29 DATE := fnd_api.g_miss_date

Line 382: , p5_a27 DATE := fnd_api.g_miss_date

378: , p5_a23 NUMBER := 0-1962.0724
379: , p5_a24 NUMBER := 0-1962.0724
380: , p5_a25 DATE := fnd_api.g_miss_date
381: , p5_a26 NUMBER := 0-1962.0724
382: , p5_a27 DATE := fnd_api.g_miss_date
383: , p5_a28 NUMBER := 0-1962.0724
384: , p5_a29 DATE := fnd_api.g_miss_date
385: , p5_a30 NUMBER := 0-1962.0724
386: );

Line 384: , p5_a29 DATE := fnd_api.g_miss_date

380: , p5_a25 DATE := fnd_api.g_miss_date
381: , p5_a26 NUMBER := 0-1962.0724
382: , p5_a27 DATE := fnd_api.g_miss_date
383: , p5_a28 NUMBER := 0-1962.0724
384: , p5_a29 DATE := fnd_api.g_miss_date
385: , p5_a30 NUMBER := 0-1962.0724
386: );
387: procedure lock_indices(p_api_version NUMBER
388: , p_init_msg_list VARCHAR2

Line 431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

427: , x_msg_count out nocopy NUMBER
428: , x_msg_data out nocopy VARCHAR2
429: , p5_a0 NUMBER := 0-1962.0724
430: , p5_a1 NUMBER := 0-1962.0724
431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

428: , x_msg_data out nocopy VARCHAR2
429: , p5_a0 NUMBER := 0-1962.0724
430: , p5_a1 NUMBER := 0-1962.0724
431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

429: , p5_a0 NUMBER := 0-1962.0724
430: , p5_a1 NUMBER := 0-1962.0724
431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

430: , p5_a1 NUMBER := 0-1962.0724
431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

432: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

436: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

437: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

441: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a22 NUMBER := 0-1962.0724

Line 448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a22 NUMBER := 0-1962.0724
452: , p5_a23 NUMBER := 0-1962.0724

Line 449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a22 NUMBER := 0-1962.0724
452: , p5_a23 NUMBER := 0-1962.0724
453: , p5_a24 NUMBER := 0-1962.0724

Line 450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a22 NUMBER := 0-1962.0724
452: , p5_a23 NUMBER := 0-1962.0724
453: , p5_a24 NUMBER := 0-1962.0724
454: , p5_a25 DATE := fnd_api.g_miss_date

Line 454: , p5_a25 DATE := fnd_api.g_miss_date

450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a22 NUMBER := 0-1962.0724
452: , p5_a23 NUMBER := 0-1962.0724
453: , p5_a24 NUMBER := 0-1962.0724
454: , p5_a25 DATE := fnd_api.g_miss_date
455: , p5_a26 NUMBER := 0-1962.0724
456: , p5_a27 DATE := fnd_api.g_miss_date
457: , p5_a28 NUMBER := 0-1962.0724
458: , p5_a29 DATE := fnd_api.g_miss_date

Line 456: , p5_a27 DATE := fnd_api.g_miss_date

452: , p5_a23 NUMBER := 0-1962.0724
453: , p5_a24 NUMBER := 0-1962.0724
454: , p5_a25 DATE := fnd_api.g_miss_date
455: , p5_a26 NUMBER := 0-1962.0724
456: , p5_a27 DATE := fnd_api.g_miss_date
457: , p5_a28 NUMBER := 0-1962.0724
458: , p5_a29 DATE := fnd_api.g_miss_date
459: , p5_a30 NUMBER := 0-1962.0724
460: );

Line 458: , p5_a29 DATE := fnd_api.g_miss_date

454: , p5_a25 DATE := fnd_api.g_miss_date
455: , p5_a26 NUMBER := 0-1962.0724
456: , p5_a27 DATE := fnd_api.g_miss_date
457: , p5_a28 NUMBER := 0-1962.0724
458: , p5_a29 DATE := fnd_api.g_miss_date
459: , p5_a30 NUMBER := 0-1962.0724
460: );
461: procedure update_indices(p_api_version NUMBER
462: , p_init_msg_list VARCHAR2

Line 567: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

563: , p6_a29 out nocopy DATE
564: , p6_a30 out nocopy NUMBER
565: , p5_a0 NUMBER := 0-1962.0724
566: , p5_a1 NUMBER := 0-1962.0724
567: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

564: , p6_a30 out nocopy NUMBER
565: , p5_a0 NUMBER := 0-1962.0724
566: , p5_a1 NUMBER := 0-1962.0724
567: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

565: , p5_a0 NUMBER := 0-1962.0724
566: , p5_a1 NUMBER := 0-1962.0724
567: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

566: , p5_a1 NUMBER := 0-1962.0724
567: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

567: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

568: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

569: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

570: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

571: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

572: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

573: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

574: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

575: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

576: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

577: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

578: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

579: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a22 NUMBER := 0-1962.0724

Line 584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

580: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a22 NUMBER := 0-1962.0724
588: , p5_a23 NUMBER := 0-1962.0724

Line 585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

581: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a22 NUMBER := 0-1962.0724
588: , p5_a23 NUMBER := 0-1962.0724
589: , p5_a24 NUMBER := 0-1962.0724

Line 586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

582: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a22 NUMBER := 0-1962.0724
588: , p5_a23 NUMBER := 0-1962.0724
589: , p5_a24 NUMBER := 0-1962.0724
590: , p5_a25 DATE := fnd_api.g_miss_date

Line 590: , p5_a25 DATE := fnd_api.g_miss_date

586: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a22 NUMBER := 0-1962.0724
588: , p5_a23 NUMBER := 0-1962.0724
589: , p5_a24 NUMBER := 0-1962.0724
590: , p5_a25 DATE := fnd_api.g_miss_date
591: , p5_a26 NUMBER := 0-1962.0724
592: , p5_a27 DATE := fnd_api.g_miss_date
593: , p5_a28 NUMBER := 0-1962.0724
594: , p5_a29 DATE := fnd_api.g_miss_date

Line 592: , p5_a27 DATE := fnd_api.g_miss_date

588: , p5_a23 NUMBER := 0-1962.0724
589: , p5_a24 NUMBER := 0-1962.0724
590: , p5_a25 DATE := fnd_api.g_miss_date
591: , p5_a26 NUMBER := 0-1962.0724
592: , p5_a27 DATE := fnd_api.g_miss_date
593: , p5_a28 NUMBER := 0-1962.0724
594: , p5_a29 DATE := fnd_api.g_miss_date
595: , p5_a30 NUMBER := 0-1962.0724
596: );

Line 594: , p5_a29 DATE := fnd_api.g_miss_date

590: , p5_a25 DATE := fnd_api.g_miss_date
591: , p5_a26 NUMBER := 0-1962.0724
592: , p5_a27 DATE := fnd_api.g_miss_date
593: , p5_a28 NUMBER := 0-1962.0724
594: , p5_a29 DATE := fnd_api.g_miss_date
595: , p5_a30 NUMBER := 0-1962.0724
596: );
597: procedure delete_indices(p_api_version NUMBER
598: , p_init_msg_list VARCHAR2

Line 641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

637: , x_msg_count out nocopy NUMBER
638: , x_msg_data out nocopy VARCHAR2
639: , p5_a0 NUMBER := 0-1962.0724
640: , p5_a1 NUMBER := 0-1962.0724
641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

638: , x_msg_data out nocopy VARCHAR2
639: , p5_a0 NUMBER := 0-1962.0724
640: , p5_a1 NUMBER := 0-1962.0724
641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

639: , p5_a0 NUMBER := 0-1962.0724
640: , p5_a1 NUMBER := 0-1962.0724
641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

640: , p5_a1 NUMBER := 0-1962.0724
641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

642: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

644: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

645: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

646: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

647: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 NUMBER := 0-1962.0724

Line 658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 NUMBER := 0-1962.0724
662: , p5_a23 NUMBER := 0-1962.0724

Line 659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 NUMBER := 0-1962.0724
662: , p5_a23 NUMBER := 0-1962.0724
663: , p5_a24 NUMBER := 0-1962.0724

Line 660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 NUMBER := 0-1962.0724
662: , p5_a23 NUMBER := 0-1962.0724
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 DATE := fnd_api.g_miss_date

Line 664: , p5_a25 DATE := fnd_api.g_miss_date

660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 NUMBER := 0-1962.0724
662: , p5_a23 NUMBER := 0-1962.0724
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 DATE := fnd_api.g_miss_date
665: , p5_a26 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
667: , p5_a28 NUMBER := 0-1962.0724
668: , p5_a29 DATE := fnd_api.g_miss_date

Line 666: , p5_a27 DATE := fnd_api.g_miss_date

662: , p5_a23 NUMBER := 0-1962.0724
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 DATE := fnd_api.g_miss_date
665: , p5_a26 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
667: , p5_a28 NUMBER := 0-1962.0724
668: , p5_a29 DATE := fnd_api.g_miss_date
669: , p5_a30 NUMBER := 0-1962.0724
670: );

Line 668: , p5_a29 DATE := fnd_api.g_miss_date

664: , p5_a25 DATE := fnd_api.g_miss_date
665: , p5_a26 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
667: , p5_a28 NUMBER := 0-1962.0724
668: , p5_a29 DATE := fnd_api.g_miss_date
669: , p5_a30 NUMBER := 0-1962.0724
670: );
671: procedure validate_indices(p_api_version NUMBER
672: , p_init_msg_list VARCHAR2

Line 715: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

711: , x_msg_count out nocopy NUMBER
712: , x_msg_data out nocopy VARCHAR2
713: , p5_a0 NUMBER := 0-1962.0724
714: , p5_a1 NUMBER := 0-1962.0724
715: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

712: , x_msg_data out nocopy VARCHAR2
713: , p5_a0 NUMBER := 0-1962.0724
714: , p5_a1 NUMBER := 0-1962.0724
715: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

713: , p5_a0 NUMBER := 0-1962.0724
714: , p5_a1 NUMBER := 0-1962.0724
715: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

714: , p5_a1 NUMBER := 0-1962.0724
715: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

715: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

716: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

717: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

718: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

719: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

720: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

721: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

722: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

723: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

724: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

725: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

726: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

727: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a22 NUMBER := 0-1962.0724

Line 732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

728: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a22 NUMBER := 0-1962.0724
736: , p5_a23 NUMBER := 0-1962.0724

Line 733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

729: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a22 NUMBER := 0-1962.0724
736: , p5_a23 NUMBER := 0-1962.0724
737: , p5_a24 NUMBER := 0-1962.0724

Line 734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

730: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a22 NUMBER := 0-1962.0724
736: , p5_a23 NUMBER := 0-1962.0724
737: , p5_a24 NUMBER := 0-1962.0724
738: , p5_a25 DATE := fnd_api.g_miss_date

Line 738: , p5_a25 DATE := fnd_api.g_miss_date

734: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a22 NUMBER := 0-1962.0724
736: , p5_a23 NUMBER := 0-1962.0724
737: , p5_a24 NUMBER := 0-1962.0724
738: , p5_a25 DATE := fnd_api.g_miss_date
739: , p5_a26 NUMBER := 0-1962.0724
740: , p5_a27 DATE := fnd_api.g_miss_date
741: , p5_a28 NUMBER := 0-1962.0724
742: , p5_a29 DATE := fnd_api.g_miss_date

Line 740: , p5_a27 DATE := fnd_api.g_miss_date

736: , p5_a23 NUMBER := 0-1962.0724
737: , p5_a24 NUMBER := 0-1962.0724
738: , p5_a25 DATE := fnd_api.g_miss_date
739: , p5_a26 NUMBER := 0-1962.0724
740: , p5_a27 DATE := fnd_api.g_miss_date
741: , p5_a28 NUMBER := 0-1962.0724
742: , p5_a29 DATE := fnd_api.g_miss_date
743: , p5_a30 NUMBER := 0-1962.0724
744: );

Line 742: , p5_a29 DATE := fnd_api.g_miss_date

738: , p5_a25 DATE := fnd_api.g_miss_date
739: , p5_a26 NUMBER := 0-1962.0724
740: , p5_a27 DATE := fnd_api.g_miss_date
741: , p5_a28 NUMBER := 0-1962.0724
742: , p5_a29 DATE := fnd_api.g_miss_date
743: , p5_a30 NUMBER := 0-1962.0724
744: );
745: procedure create_index_values(p_api_version NUMBER
746: , p_init_msg_list VARCHAR2

Line 805: , p5_a4 DATE := fnd_api.g_miss_date

801: , p5_a0 NUMBER := 0-1962.0724
802: , p5_a1 NUMBER := 0-1962.0724
803: , p5_a2 NUMBER := 0-1962.0724
804: , p5_a3 NUMBER := 0-1962.0724
805: , p5_a4 DATE := fnd_api.g_miss_date
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 NUMBER := 0-1962.0724
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 NUMBER := 0-1962.0724

Line 806: , p5_a5 DATE := fnd_api.g_miss_date

802: , p5_a1 NUMBER := 0-1962.0724
803: , p5_a2 NUMBER := 0-1962.0724
804: , p5_a3 NUMBER := 0-1962.0724
805: , p5_a4 DATE := fnd_api.g_miss_date
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 NUMBER := 0-1962.0724
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 NUMBER := 0-1962.0724
810: , p5_a9 DATE := fnd_api.g_miss_date

Line 810: , p5_a9 DATE := fnd_api.g_miss_date

806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 NUMBER := 0-1962.0724
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 NUMBER := 0-1962.0724
810: , p5_a9 DATE := fnd_api.g_miss_date
811: , p5_a10 NUMBER := 0-1962.0724
812: , p5_a11 DATE := fnd_api.g_miss_date
813: , p5_a12 NUMBER := 0-1962.0724
814: , p5_a13 DATE := fnd_api.g_miss_date

Line 812: , p5_a11 DATE := fnd_api.g_miss_date

808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 NUMBER := 0-1962.0724
810: , p5_a9 DATE := fnd_api.g_miss_date
811: , p5_a10 NUMBER := 0-1962.0724
812: , p5_a11 DATE := fnd_api.g_miss_date
813: , p5_a12 NUMBER := 0-1962.0724
814: , p5_a13 DATE := fnd_api.g_miss_date
815: , p5_a14 NUMBER := 0-1962.0724
816: );

Line 814: , p5_a13 DATE := fnd_api.g_miss_date

810: , p5_a9 DATE := fnd_api.g_miss_date
811: , p5_a10 NUMBER := 0-1962.0724
812: , p5_a11 DATE := fnd_api.g_miss_date
813: , p5_a12 NUMBER := 0-1962.0724
814: , p5_a13 DATE := fnd_api.g_miss_date
815: , p5_a14 NUMBER := 0-1962.0724
816: );
817: procedure lock_index_values(p_api_version NUMBER
818: , p_init_msg_list VARCHAR2

Line 847: , p5_a4 DATE := fnd_api.g_miss_date

843: , p5_a0 NUMBER := 0-1962.0724
844: , p5_a1 NUMBER := 0-1962.0724
845: , p5_a2 NUMBER := 0-1962.0724
846: , p5_a3 NUMBER := 0-1962.0724
847: , p5_a4 DATE := fnd_api.g_miss_date
848: , p5_a5 DATE := fnd_api.g_miss_date
849: , p5_a6 NUMBER := 0-1962.0724
850: , p5_a7 NUMBER := 0-1962.0724
851: , p5_a8 NUMBER := 0-1962.0724

Line 848: , p5_a5 DATE := fnd_api.g_miss_date

844: , p5_a1 NUMBER := 0-1962.0724
845: , p5_a2 NUMBER := 0-1962.0724
846: , p5_a3 NUMBER := 0-1962.0724
847: , p5_a4 DATE := fnd_api.g_miss_date
848: , p5_a5 DATE := fnd_api.g_miss_date
849: , p5_a6 NUMBER := 0-1962.0724
850: , p5_a7 NUMBER := 0-1962.0724
851: , p5_a8 NUMBER := 0-1962.0724
852: , p5_a9 DATE := fnd_api.g_miss_date

Line 852: , p5_a9 DATE := fnd_api.g_miss_date

848: , p5_a5 DATE := fnd_api.g_miss_date
849: , p5_a6 NUMBER := 0-1962.0724
850: , p5_a7 NUMBER := 0-1962.0724
851: , p5_a8 NUMBER := 0-1962.0724
852: , p5_a9 DATE := fnd_api.g_miss_date
853: , p5_a10 NUMBER := 0-1962.0724
854: , p5_a11 DATE := fnd_api.g_miss_date
855: , p5_a12 NUMBER := 0-1962.0724
856: , p5_a13 DATE := fnd_api.g_miss_date

Line 854: , p5_a11 DATE := fnd_api.g_miss_date

850: , p5_a7 NUMBER := 0-1962.0724
851: , p5_a8 NUMBER := 0-1962.0724
852: , p5_a9 DATE := fnd_api.g_miss_date
853: , p5_a10 NUMBER := 0-1962.0724
854: , p5_a11 DATE := fnd_api.g_miss_date
855: , p5_a12 NUMBER := 0-1962.0724
856: , p5_a13 DATE := fnd_api.g_miss_date
857: , p5_a14 NUMBER := 0-1962.0724
858: );

Line 856: , p5_a13 DATE := fnd_api.g_miss_date

852: , p5_a9 DATE := fnd_api.g_miss_date
853: , p5_a10 NUMBER := 0-1962.0724
854: , p5_a11 DATE := fnd_api.g_miss_date
855: , p5_a12 NUMBER := 0-1962.0724
856: , p5_a13 DATE := fnd_api.g_miss_date
857: , p5_a14 NUMBER := 0-1962.0724
858: );
859: procedure update_index_values(p_api_version NUMBER
860: , p_init_msg_list VARCHAR2

Line 919: , p5_a4 DATE := fnd_api.g_miss_date

915: , p5_a0 NUMBER := 0-1962.0724
916: , p5_a1 NUMBER := 0-1962.0724
917: , p5_a2 NUMBER := 0-1962.0724
918: , p5_a3 NUMBER := 0-1962.0724
919: , p5_a4 DATE := fnd_api.g_miss_date
920: , p5_a5 DATE := fnd_api.g_miss_date
921: , p5_a6 NUMBER := 0-1962.0724
922: , p5_a7 NUMBER := 0-1962.0724
923: , p5_a8 NUMBER := 0-1962.0724

Line 920: , p5_a5 DATE := fnd_api.g_miss_date

916: , p5_a1 NUMBER := 0-1962.0724
917: , p5_a2 NUMBER := 0-1962.0724
918: , p5_a3 NUMBER := 0-1962.0724
919: , p5_a4 DATE := fnd_api.g_miss_date
920: , p5_a5 DATE := fnd_api.g_miss_date
921: , p5_a6 NUMBER := 0-1962.0724
922: , p5_a7 NUMBER := 0-1962.0724
923: , p5_a8 NUMBER := 0-1962.0724
924: , p5_a9 DATE := fnd_api.g_miss_date

Line 924: , p5_a9 DATE := fnd_api.g_miss_date

920: , p5_a5 DATE := fnd_api.g_miss_date
921: , p5_a6 NUMBER := 0-1962.0724
922: , p5_a7 NUMBER := 0-1962.0724
923: , p5_a8 NUMBER := 0-1962.0724
924: , p5_a9 DATE := fnd_api.g_miss_date
925: , p5_a10 NUMBER := 0-1962.0724
926: , p5_a11 DATE := fnd_api.g_miss_date
927: , p5_a12 NUMBER := 0-1962.0724
928: , p5_a13 DATE := fnd_api.g_miss_date

Line 926: , p5_a11 DATE := fnd_api.g_miss_date

922: , p5_a7 NUMBER := 0-1962.0724
923: , p5_a8 NUMBER := 0-1962.0724
924: , p5_a9 DATE := fnd_api.g_miss_date
925: , p5_a10 NUMBER := 0-1962.0724
926: , p5_a11 DATE := fnd_api.g_miss_date
927: , p5_a12 NUMBER := 0-1962.0724
928: , p5_a13 DATE := fnd_api.g_miss_date
929: , p5_a14 NUMBER := 0-1962.0724
930: );

Line 928: , p5_a13 DATE := fnd_api.g_miss_date

924: , p5_a9 DATE := fnd_api.g_miss_date
925: , p5_a10 NUMBER := 0-1962.0724
926: , p5_a11 DATE := fnd_api.g_miss_date
927: , p5_a12 NUMBER := 0-1962.0724
928: , p5_a13 DATE := fnd_api.g_miss_date
929: , p5_a14 NUMBER := 0-1962.0724
930: );
931: procedure delete_index_values(p_api_version NUMBER
932: , p_init_msg_list VARCHAR2

Line 961: , p5_a4 DATE := fnd_api.g_miss_date

957: , p5_a0 NUMBER := 0-1962.0724
958: , p5_a1 NUMBER := 0-1962.0724
959: , p5_a2 NUMBER := 0-1962.0724
960: , p5_a3 NUMBER := 0-1962.0724
961: , p5_a4 DATE := fnd_api.g_miss_date
962: , p5_a5 DATE := fnd_api.g_miss_date
963: , p5_a6 NUMBER := 0-1962.0724
964: , p5_a7 NUMBER := 0-1962.0724
965: , p5_a8 NUMBER := 0-1962.0724

Line 962: , p5_a5 DATE := fnd_api.g_miss_date

958: , p5_a1 NUMBER := 0-1962.0724
959: , p5_a2 NUMBER := 0-1962.0724
960: , p5_a3 NUMBER := 0-1962.0724
961: , p5_a4 DATE := fnd_api.g_miss_date
962: , p5_a5 DATE := fnd_api.g_miss_date
963: , p5_a6 NUMBER := 0-1962.0724
964: , p5_a7 NUMBER := 0-1962.0724
965: , p5_a8 NUMBER := 0-1962.0724
966: , p5_a9 DATE := fnd_api.g_miss_date

Line 966: , p5_a9 DATE := fnd_api.g_miss_date

962: , p5_a5 DATE := fnd_api.g_miss_date
963: , p5_a6 NUMBER := 0-1962.0724
964: , p5_a7 NUMBER := 0-1962.0724
965: , p5_a8 NUMBER := 0-1962.0724
966: , p5_a9 DATE := fnd_api.g_miss_date
967: , p5_a10 NUMBER := 0-1962.0724
968: , p5_a11 DATE := fnd_api.g_miss_date
969: , p5_a12 NUMBER := 0-1962.0724
970: , p5_a13 DATE := fnd_api.g_miss_date

Line 968: , p5_a11 DATE := fnd_api.g_miss_date

964: , p5_a7 NUMBER := 0-1962.0724
965: , p5_a8 NUMBER := 0-1962.0724
966: , p5_a9 DATE := fnd_api.g_miss_date
967: , p5_a10 NUMBER := 0-1962.0724
968: , p5_a11 DATE := fnd_api.g_miss_date
969: , p5_a12 NUMBER := 0-1962.0724
970: , p5_a13 DATE := fnd_api.g_miss_date
971: , p5_a14 NUMBER := 0-1962.0724
972: );

Line 970: , p5_a13 DATE := fnd_api.g_miss_date

966: , p5_a9 DATE := fnd_api.g_miss_date
967: , p5_a10 NUMBER := 0-1962.0724
968: , p5_a11 DATE := fnd_api.g_miss_date
969: , p5_a12 NUMBER := 0-1962.0724
970: , p5_a13 DATE := fnd_api.g_miss_date
971: , p5_a14 NUMBER := 0-1962.0724
972: );
973: procedure validate_index_values(p_api_version NUMBER
974: , p_init_msg_list VARCHAR2

Line 1003: , p5_a4 DATE := fnd_api.g_miss_date

999: , p5_a0 NUMBER := 0-1962.0724
1000: , p5_a1 NUMBER := 0-1962.0724
1001: , p5_a2 NUMBER := 0-1962.0724
1002: , p5_a3 NUMBER := 0-1962.0724
1003: , p5_a4 DATE := fnd_api.g_miss_date
1004: , p5_a5 DATE := fnd_api.g_miss_date
1005: , p5_a6 NUMBER := 0-1962.0724
1006: , p5_a7 NUMBER := 0-1962.0724
1007: , p5_a8 NUMBER := 0-1962.0724

Line 1004: , p5_a5 DATE := fnd_api.g_miss_date

1000: , p5_a1 NUMBER := 0-1962.0724
1001: , p5_a2 NUMBER := 0-1962.0724
1002: , p5_a3 NUMBER := 0-1962.0724
1003: , p5_a4 DATE := fnd_api.g_miss_date
1004: , p5_a5 DATE := fnd_api.g_miss_date
1005: , p5_a6 NUMBER := 0-1962.0724
1006: , p5_a7 NUMBER := 0-1962.0724
1007: , p5_a8 NUMBER := 0-1962.0724
1008: , p5_a9 DATE := fnd_api.g_miss_date

Line 1008: , p5_a9 DATE := fnd_api.g_miss_date

1004: , p5_a5 DATE := fnd_api.g_miss_date
1005: , p5_a6 NUMBER := 0-1962.0724
1006: , p5_a7 NUMBER := 0-1962.0724
1007: , p5_a8 NUMBER := 0-1962.0724
1008: , p5_a9 DATE := fnd_api.g_miss_date
1009: , p5_a10 NUMBER := 0-1962.0724
1010: , p5_a11 DATE := fnd_api.g_miss_date
1011: , p5_a12 NUMBER := 0-1962.0724
1012: , p5_a13 DATE := fnd_api.g_miss_date

Line 1010: , p5_a11 DATE := fnd_api.g_miss_date

1006: , p5_a7 NUMBER := 0-1962.0724
1007: , p5_a8 NUMBER := 0-1962.0724
1008: , p5_a9 DATE := fnd_api.g_miss_date
1009: , p5_a10 NUMBER := 0-1962.0724
1010: , p5_a11 DATE := fnd_api.g_miss_date
1011: , p5_a12 NUMBER := 0-1962.0724
1012: , p5_a13 DATE := fnd_api.g_miss_date
1013: , p5_a14 NUMBER := 0-1962.0724
1014: );

Line 1012: , p5_a13 DATE := fnd_api.g_miss_date

1008: , p5_a9 DATE := fnd_api.g_miss_date
1009: , p5_a10 NUMBER := 0-1962.0724
1010: , p5_a11 DATE := fnd_api.g_miss_date
1011: , p5_a12 NUMBER := 0-1962.0724
1012: , p5_a13 DATE := fnd_api.g_miss_date
1013: , p5_a14 NUMBER := 0-1962.0724
1014: );
1015: end okl_indices_pvt_w;