APPS.IBE_MSITE_INFORMATION_PKG dependencies on FND_API

Line 71: (x_msite_information_id = FND_API.G_MISS_NUM))

67:
68: -- Primary key validation check
69: x_msite_information_id := p_msite_information_id;
70: IF ((x_msite_information_id IS NULL) OR
71: (x_msite_information_id = FND_API.G_MISS_NUM))
72: THEN
73: OPEN c2;
74: FETCH c2 INTO x_msite_information_id;
75: CLOSE c2;

Line 133: decode(p_msite_information1,FND_API.G_MISS_CHAR,NULL,p_msite_information1),

129: x_msite_information_id,
130: p_object_version_number,
131: p_msite_id,
132: p_msite_information_context,
133: decode(p_msite_information1,FND_API.G_MISS_CHAR,NULL,p_msite_information1),
134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),
135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),

Line 134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),

130: p_object_version_number,
131: p_msite_id,
132: p_msite_information_context,
133: decode(p_msite_information1,FND_API.G_MISS_CHAR,NULL,p_msite_information1),
134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),
135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),

Line 135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),

131: p_msite_id,
132: p_msite_information_context,
133: decode(p_msite_information1,FND_API.G_MISS_CHAR,NULL,p_msite_information1),
134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),
135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),

Line 136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),

132: p_msite_information_context,
133: decode(p_msite_information1,FND_API.G_MISS_CHAR,NULL,p_msite_information1),
134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),
135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),

Line 137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),

133: decode(p_msite_information1,FND_API.G_MISS_CHAR,NULL,p_msite_information1),
134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),
135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),

Line 138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),

134: decode(p_msite_information2,FND_API.G_MISS_CHAR,NULL,p_msite_information2),
135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),
142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,

Line 139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),

135: decode(p_msite_information3,FND_API.G_MISS_CHAR,NULL,p_msite_information3),
136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),
142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,
143: p_msite_information10),

Line 140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),

136: decode(p_msite_information4,FND_API.G_MISS_CHAR,NULL,p_msite_information4),
137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),
142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,
143: p_msite_information10),
144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,

Line 141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),

137: decode(p_msite_information5,FND_API.G_MISS_CHAR,NULL,p_msite_information5),
138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),
142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,
143: p_msite_information10),
144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,
145: p_msite_information11),

Line 142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,

138: decode(p_msite_information6,FND_API.G_MISS_CHAR,NULL,p_msite_information6),
139: decode(p_msite_information7,FND_API.G_MISS_CHAR,NULL,p_msite_information7),
140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),
142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,
143: p_msite_information10),
144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,
145: p_msite_information11),
146: decode(p_msite_information12,FND_API.G_MISS_CHAR,NULL,

Line 144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,

140: decode(p_msite_information8,FND_API.G_MISS_CHAR,NULL,p_msite_information8),
141: decode(p_msite_information9,FND_API.G_MISS_CHAR,NULL,p_msite_information9),
142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,
143: p_msite_information10),
144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,
145: p_msite_information11),
146: decode(p_msite_information12,FND_API.G_MISS_CHAR,NULL,
147: p_msite_information12),
148: decode(p_msite_information13,FND_API.G_MISS_CHAR,NULL,

Line 146: decode(p_msite_information12,FND_API.G_MISS_CHAR,NULL,

142: decode(p_msite_information10,FND_API.G_MISS_CHAR,NULL,
143: p_msite_information10),
144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,
145: p_msite_information11),
146: decode(p_msite_information12,FND_API.G_MISS_CHAR,NULL,
147: p_msite_information12),
148: decode(p_msite_information13,FND_API.G_MISS_CHAR,NULL,
149: p_msite_information13),
150: decode(p_msite_information14,FND_API.G_MISS_CHAR,NULL,

Line 148: decode(p_msite_information13,FND_API.G_MISS_CHAR,NULL,

144: decode(p_msite_information11,FND_API.G_MISS_CHAR,NULL,
145: p_msite_information11),
146: decode(p_msite_information12,FND_API.G_MISS_CHAR,NULL,
147: p_msite_information12),
148: decode(p_msite_information13,FND_API.G_MISS_CHAR,NULL,
149: p_msite_information13),
150: decode(p_msite_information14,FND_API.G_MISS_CHAR,NULL,
151: p_msite_information14),
152: decode(p_msite_information15,FND_API.G_MISS_CHAR,NULL,

Line 150: decode(p_msite_information14,FND_API.G_MISS_CHAR,NULL,

146: decode(p_msite_information12,FND_API.G_MISS_CHAR,NULL,
147: p_msite_information12),
148: decode(p_msite_information13,FND_API.G_MISS_CHAR,NULL,
149: p_msite_information13),
150: decode(p_msite_information14,FND_API.G_MISS_CHAR,NULL,
151: p_msite_information14),
152: decode(p_msite_information15,FND_API.G_MISS_CHAR,NULL,
153: p_msite_information15),
154: decode(p_msite_information16,FND_API.G_MISS_CHAR,NULL,

Line 152: decode(p_msite_information15,FND_API.G_MISS_CHAR,NULL,

148: decode(p_msite_information13,FND_API.G_MISS_CHAR,NULL,
149: p_msite_information13),
150: decode(p_msite_information14,FND_API.G_MISS_CHAR,NULL,
151: p_msite_information14),
152: decode(p_msite_information15,FND_API.G_MISS_CHAR,NULL,
153: p_msite_information15),
154: decode(p_msite_information16,FND_API.G_MISS_CHAR,NULL,
155: p_msite_information16),
156: decode(p_msite_information17,FND_API.G_MISS_CHAR,NULL,

Line 154: decode(p_msite_information16,FND_API.G_MISS_CHAR,NULL,

150: decode(p_msite_information14,FND_API.G_MISS_CHAR,NULL,
151: p_msite_information14),
152: decode(p_msite_information15,FND_API.G_MISS_CHAR,NULL,
153: p_msite_information15),
154: decode(p_msite_information16,FND_API.G_MISS_CHAR,NULL,
155: p_msite_information16),
156: decode(p_msite_information17,FND_API.G_MISS_CHAR,NULL,
157: p_msite_information17),
158: decode(p_msite_information18,FND_API.G_MISS_CHAR,NULL,

Line 156: decode(p_msite_information17,FND_API.G_MISS_CHAR,NULL,

152: decode(p_msite_information15,FND_API.G_MISS_CHAR,NULL,
153: p_msite_information15),
154: decode(p_msite_information16,FND_API.G_MISS_CHAR,NULL,
155: p_msite_information16),
156: decode(p_msite_information17,FND_API.G_MISS_CHAR,NULL,
157: p_msite_information17),
158: decode(p_msite_information18,FND_API.G_MISS_CHAR,NULL,
159: p_msite_information18),
160: decode(p_msite_information19,FND_API.G_MISS_CHAR,NULL,

Line 158: decode(p_msite_information18,FND_API.G_MISS_CHAR,NULL,

154: decode(p_msite_information16,FND_API.G_MISS_CHAR,NULL,
155: p_msite_information16),
156: decode(p_msite_information17,FND_API.G_MISS_CHAR,NULL,
157: p_msite_information17),
158: decode(p_msite_information18,FND_API.G_MISS_CHAR,NULL,
159: p_msite_information18),
160: decode(p_msite_information19,FND_API.G_MISS_CHAR,NULL,
161: p_msite_information19),
162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,

Line 160: decode(p_msite_information19,FND_API.G_MISS_CHAR,NULL,

156: decode(p_msite_information17,FND_API.G_MISS_CHAR,NULL,
157: p_msite_information17),
158: decode(p_msite_information18,FND_API.G_MISS_CHAR,NULL,
159: p_msite_information18),
160: decode(p_msite_information19,FND_API.G_MISS_CHAR,NULL,
161: p_msite_information19),
162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,
163: p_msite_information20),
164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),

Line 162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,

158: decode(p_msite_information18,FND_API.G_MISS_CHAR,NULL,
159: p_msite_information18),
160: decode(p_msite_information19,FND_API.G_MISS_CHAR,NULL,
161: p_msite_information19),
162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,
163: p_msite_information20),
164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),
165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

Line 164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),

160: decode(p_msite_information19,FND_API.G_MISS_CHAR,NULL,
161: p_msite_information19),
162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,
163: p_msite_information20),
164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),
165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

Line 165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

161: p_msite_information19),
162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,
163: p_msite_information20),
164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),
165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

Line 166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

162: decode(p_msite_information20,FND_API.G_MISS_CHAR,NULL,
163: p_msite_information20),
164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),
165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

Line 167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

163: p_msite_information20),
164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),
165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

Line 168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

164: decode(p_attribute_category,FND_API.G_MISS_CHAR,NULL,p_attribute_category),
165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

Line 169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

165: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

Line 170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

166: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

Line 171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

167: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

Line 172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

168: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

Line 173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

169: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

Line 174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

170: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

Line 175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

171: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

Line 176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

172: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

173: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),

Line 178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

174: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

175: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),

Line 180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

176: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
177: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );

Line 188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:
192: OPEN c;

Line 206: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

202:
203: PROCEDURE update_row
204: (
205: p_msite_information_id IN NUMBER,
206: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
207: p_msite_information1 IN VARCHAR2,
208: p_msite_information2 IN VARCHAR2,
209: p_msite_information3 IN VARCHAR2,
210: p_msite_information4 IN VARCHAR2,

Line 253: msite_information1 = decode(p_msite_information1, FND_API.G_MISS_CHAR,

249:
250: -- update base
251: UPDATE ibe_msite_information SET
252: object_version_number = object_version_number + 1,
253: msite_information1 = decode(p_msite_information1, FND_API.G_MISS_CHAR,
254: msite_information1, p_msite_information1),
255: msite_information2 = decode(p_msite_information2, FND_API.G_MISS_CHAR,
256: msite_information2, p_msite_information2),
257: msite_information3 = decode(p_msite_information3, FND_API.G_MISS_CHAR,

Line 255: msite_information2 = decode(p_msite_information2, FND_API.G_MISS_CHAR,

251: UPDATE ibe_msite_information SET
252: object_version_number = object_version_number + 1,
253: msite_information1 = decode(p_msite_information1, FND_API.G_MISS_CHAR,
254: msite_information1, p_msite_information1),
255: msite_information2 = decode(p_msite_information2, FND_API.G_MISS_CHAR,
256: msite_information2, p_msite_information2),
257: msite_information3 = decode(p_msite_information3, FND_API.G_MISS_CHAR,
258: msite_information3, p_msite_information3),
259: msite_information4 = decode(p_msite_information4, FND_API.G_MISS_CHAR,

Line 257: msite_information3 = decode(p_msite_information3, FND_API.G_MISS_CHAR,

253: msite_information1 = decode(p_msite_information1, FND_API.G_MISS_CHAR,
254: msite_information1, p_msite_information1),
255: msite_information2 = decode(p_msite_information2, FND_API.G_MISS_CHAR,
256: msite_information2, p_msite_information2),
257: msite_information3 = decode(p_msite_information3, FND_API.G_MISS_CHAR,
258: msite_information3, p_msite_information3),
259: msite_information4 = decode(p_msite_information4, FND_API.G_MISS_CHAR,
260: msite_information4, p_msite_information4),
261: msite_information5 = decode(p_msite_information5, FND_API.G_MISS_CHAR,

Line 259: msite_information4 = decode(p_msite_information4, FND_API.G_MISS_CHAR,

255: msite_information2 = decode(p_msite_information2, FND_API.G_MISS_CHAR,
256: msite_information2, p_msite_information2),
257: msite_information3 = decode(p_msite_information3, FND_API.G_MISS_CHAR,
258: msite_information3, p_msite_information3),
259: msite_information4 = decode(p_msite_information4, FND_API.G_MISS_CHAR,
260: msite_information4, p_msite_information4),
261: msite_information5 = decode(p_msite_information5, FND_API.G_MISS_CHAR,
262: msite_information5, p_msite_information5),
263: msite_information6 = decode(p_msite_information6, FND_API.G_MISS_CHAR,

Line 261: msite_information5 = decode(p_msite_information5, FND_API.G_MISS_CHAR,

257: msite_information3 = decode(p_msite_information3, FND_API.G_MISS_CHAR,
258: msite_information3, p_msite_information3),
259: msite_information4 = decode(p_msite_information4, FND_API.G_MISS_CHAR,
260: msite_information4, p_msite_information4),
261: msite_information5 = decode(p_msite_information5, FND_API.G_MISS_CHAR,
262: msite_information5, p_msite_information5),
263: msite_information6 = decode(p_msite_information6, FND_API.G_MISS_CHAR,
264: msite_information6, p_msite_information6),
265: msite_information7 = decode(p_msite_information7, FND_API.G_MISS_CHAR,

Line 263: msite_information6 = decode(p_msite_information6, FND_API.G_MISS_CHAR,

259: msite_information4 = decode(p_msite_information4, FND_API.G_MISS_CHAR,
260: msite_information4, p_msite_information4),
261: msite_information5 = decode(p_msite_information5, FND_API.G_MISS_CHAR,
262: msite_information5, p_msite_information5),
263: msite_information6 = decode(p_msite_information6, FND_API.G_MISS_CHAR,
264: msite_information6, p_msite_information6),
265: msite_information7 = decode(p_msite_information7, FND_API.G_MISS_CHAR,
266: msite_information7, p_msite_information7),
267: msite_information8 = decode(p_msite_information8, FND_API.G_MISS_CHAR,

Line 265: msite_information7 = decode(p_msite_information7, FND_API.G_MISS_CHAR,

261: msite_information5 = decode(p_msite_information5, FND_API.G_MISS_CHAR,
262: msite_information5, p_msite_information5),
263: msite_information6 = decode(p_msite_information6, FND_API.G_MISS_CHAR,
264: msite_information6, p_msite_information6),
265: msite_information7 = decode(p_msite_information7, FND_API.G_MISS_CHAR,
266: msite_information7, p_msite_information7),
267: msite_information8 = decode(p_msite_information8, FND_API.G_MISS_CHAR,
268: msite_information8, p_msite_information8),
269: msite_information9 = decode(p_msite_information9, FND_API.G_MISS_CHAR,

Line 267: msite_information8 = decode(p_msite_information8, FND_API.G_MISS_CHAR,

263: msite_information6 = decode(p_msite_information6, FND_API.G_MISS_CHAR,
264: msite_information6, p_msite_information6),
265: msite_information7 = decode(p_msite_information7, FND_API.G_MISS_CHAR,
266: msite_information7, p_msite_information7),
267: msite_information8 = decode(p_msite_information8, FND_API.G_MISS_CHAR,
268: msite_information8, p_msite_information8),
269: msite_information9 = decode(p_msite_information9, FND_API.G_MISS_CHAR,
270: msite_information9, p_msite_information9),
271: msite_information10 = decode(p_msite_information10, FND_API.G_MISS_CHAR,

Line 269: msite_information9 = decode(p_msite_information9, FND_API.G_MISS_CHAR,

265: msite_information7 = decode(p_msite_information7, FND_API.G_MISS_CHAR,
266: msite_information7, p_msite_information7),
267: msite_information8 = decode(p_msite_information8, FND_API.G_MISS_CHAR,
268: msite_information8, p_msite_information8),
269: msite_information9 = decode(p_msite_information9, FND_API.G_MISS_CHAR,
270: msite_information9, p_msite_information9),
271: msite_information10 = decode(p_msite_information10, FND_API.G_MISS_CHAR,
272: msite_information10, p_msite_information10),
273: msite_information11 = decode(p_msite_information11, FND_API.G_MISS_CHAR,

Line 271: msite_information10 = decode(p_msite_information10, FND_API.G_MISS_CHAR,

267: msite_information8 = decode(p_msite_information8, FND_API.G_MISS_CHAR,
268: msite_information8, p_msite_information8),
269: msite_information9 = decode(p_msite_information9, FND_API.G_MISS_CHAR,
270: msite_information9, p_msite_information9),
271: msite_information10 = decode(p_msite_information10, FND_API.G_MISS_CHAR,
272: msite_information10, p_msite_information10),
273: msite_information11 = decode(p_msite_information11, FND_API.G_MISS_CHAR,
274: msite_information11, p_msite_information11),
275: msite_information12 = decode(p_msite_information12, FND_API.G_MISS_CHAR,

Line 273: msite_information11 = decode(p_msite_information11, FND_API.G_MISS_CHAR,

269: msite_information9 = decode(p_msite_information9, FND_API.G_MISS_CHAR,
270: msite_information9, p_msite_information9),
271: msite_information10 = decode(p_msite_information10, FND_API.G_MISS_CHAR,
272: msite_information10, p_msite_information10),
273: msite_information11 = decode(p_msite_information11, FND_API.G_MISS_CHAR,
274: msite_information11, p_msite_information11),
275: msite_information12 = decode(p_msite_information12, FND_API.G_MISS_CHAR,
276: msite_information12, p_msite_information12),
277: msite_information13 = decode(p_msite_information13, FND_API.G_MISS_CHAR,

Line 275: msite_information12 = decode(p_msite_information12, FND_API.G_MISS_CHAR,

271: msite_information10 = decode(p_msite_information10, FND_API.G_MISS_CHAR,
272: msite_information10, p_msite_information10),
273: msite_information11 = decode(p_msite_information11, FND_API.G_MISS_CHAR,
274: msite_information11, p_msite_information11),
275: msite_information12 = decode(p_msite_information12, FND_API.G_MISS_CHAR,
276: msite_information12, p_msite_information12),
277: msite_information13 = decode(p_msite_information13, FND_API.G_MISS_CHAR,
278: msite_information13, p_msite_information13),
279: msite_information14 = decode(p_msite_information14, FND_API.G_MISS_CHAR,

Line 277: msite_information13 = decode(p_msite_information13, FND_API.G_MISS_CHAR,

273: msite_information11 = decode(p_msite_information11, FND_API.G_MISS_CHAR,
274: msite_information11, p_msite_information11),
275: msite_information12 = decode(p_msite_information12, FND_API.G_MISS_CHAR,
276: msite_information12, p_msite_information12),
277: msite_information13 = decode(p_msite_information13, FND_API.G_MISS_CHAR,
278: msite_information13, p_msite_information13),
279: msite_information14 = decode(p_msite_information14, FND_API.G_MISS_CHAR,
280: msite_information14, p_msite_information14),
281: msite_information15 = decode(p_msite_information15, FND_API.G_MISS_CHAR,

Line 279: msite_information14 = decode(p_msite_information14, FND_API.G_MISS_CHAR,

275: msite_information12 = decode(p_msite_information12, FND_API.G_MISS_CHAR,
276: msite_information12, p_msite_information12),
277: msite_information13 = decode(p_msite_information13, FND_API.G_MISS_CHAR,
278: msite_information13, p_msite_information13),
279: msite_information14 = decode(p_msite_information14, FND_API.G_MISS_CHAR,
280: msite_information14, p_msite_information14),
281: msite_information15 = decode(p_msite_information15, FND_API.G_MISS_CHAR,
282: msite_information15, p_msite_information15),
283: msite_information16 = decode(p_msite_information16, FND_API.G_MISS_CHAR,

Line 281: msite_information15 = decode(p_msite_information15, FND_API.G_MISS_CHAR,

277: msite_information13 = decode(p_msite_information13, FND_API.G_MISS_CHAR,
278: msite_information13, p_msite_information13),
279: msite_information14 = decode(p_msite_information14, FND_API.G_MISS_CHAR,
280: msite_information14, p_msite_information14),
281: msite_information15 = decode(p_msite_information15, FND_API.G_MISS_CHAR,
282: msite_information15, p_msite_information15),
283: msite_information16 = decode(p_msite_information16, FND_API.G_MISS_CHAR,
284: msite_information16, p_msite_information16),
285: msite_information17 = decode(p_msite_information17, FND_API.G_MISS_CHAR,

Line 283: msite_information16 = decode(p_msite_information16, FND_API.G_MISS_CHAR,

279: msite_information14 = decode(p_msite_information14, FND_API.G_MISS_CHAR,
280: msite_information14, p_msite_information14),
281: msite_information15 = decode(p_msite_information15, FND_API.G_MISS_CHAR,
282: msite_information15, p_msite_information15),
283: msite_information16 = decode(p_msite_information16, FND_API.G_MISS_CHAR,
284: msite_information16, p_msite_information16),
285: msite_information17 = decode(p_msite_information17, FND_API.G_MISS_CHAR,
286: msite_information17, p_msite_information17),
287: msite_information18 = decode(p_msite_information18, FND_API.G_MISS_CHAR,

Line 285: msite_information17 = decode(p_msite_information17, FND_API.G_MISS_CHAR,

281: msite_information15 = decode(p_msite_information15, FND_API.G_MISS_CHAR,
282: msite_information15, p_msite_information15),
283: msite_information16 = decode(p_msite_information16, FND_API.G_MISS_CHAR,
284: msite_information16, p_msite_information16),
285: msite_information17 = decode(p_msite_information17, FND_API.G_MISS_CHAR,
286: msite_information17, p_msite_information17),
287: msite_information18 = decode(p_msite_information18, FND_API.G_MISS_CHAR,
288: msite_information18, p_msite_information18),
289: msite_information19 = decode(p_msite_information19, FND_API.G_MISS_CHAR,

Line 287: msite_information18 = decode(p_msite_information18, FND_API.G_MISS_CHAR,

283: msite_information16 = decode(p_msite_information16, FND_API.G_MISS_CHAR,
284: msite_information16, p_msite_information16),
285: msite_information17 = decode(p_msite_information17, FND_API.G_MISS_CHAR,
286: msite_information17, p_msite_information17),
287: msite_information18 = decode(p_msite_information18, FND_API.G_MISS_CHAR,
288: msite_information18, p_msite_information18),
289: msite_information19 = decode(p_msite_information19, FND_API.G_MISS_CHAR,
290: msite_information19, p_msite_information19),
291: msite_information20 = decode(p_msite_information20, FND_API.G_MISS_CHAR,

Line 289: msite_information19 = decode(p_msite_information19, FND_API.G_MISS_CHAR,

285: msite_information17 = decode(p_msite_information17, FND_API.G_MISS_CHAR,
286: msite_information17, p_msite_information17),
287: msite_information18 = decode(p_msite_information18, FND_API.G_MISS_CHAR,
288: msite_information18, p_msite_information18),
289: msite_information19 = decode(p_msite_information19, FND_API.G_MISS_CHAR,
290: msite_information19, p_msite_information19),
291: msite_information20 = decode(p_msite_information20, FND_API.G_MISS_CHAR,
292: msite_information20, p_msite_information20),
293: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,

Line 291: msite_information20 = decode(p_msite_information20, FND_API.G_MISS_CHAR,

287: msite_information18 = decode(p_msite_information18, FND_API.G_MISS_CHAR,
288: msite_information18, p_msite_information18),
289: msite_information19 = decode(p_msite_information19, FND_API.G_MISS_CHAR,
290: msite_information19, p_msite_information19),
291: msite_information20 = decode(p_msite_information20, FND_API.G_MISS_CHAR,
292: msite_information20, p_msite_information20),
293: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
294: attribute_category, p_attribute_category),
295: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,

Line 293: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,

289: msite_information19 = decode(p_msite_information19, FND_API.G_MISS_CHAR,
290: msite_information19, p_msite_information19),
291: msite_information20 = decode(p_msite_information20, FND_API.G_MISS_CHAR,
292: msite_information20, p_msite_information20),
293: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
294: attribute_category, p_attribute_category),
295: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
296: attribute1, p_attribute1),
297: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,

Line 295: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,

291: msite_information20 = decode(p_msite_information20, FND_API.G_MISS_CHAR,
292: msite_information20, p_msite_information20),
293: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
294: attribute_category, p_attribute_category),
295: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
296: attribute1, p_attribute1),
297: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
298: attribute2, p_attribute2),
299: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,

Line 297: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,

293: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
294: attribute_category, p_attribute_category),
295: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
296: attribute1, p_attribute1),
297: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
298: attribute2, p_attribute2),
299: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
300: attribute3, p_attribute3),
301: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,

Line 299: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,

295: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
296: attribute1, p_attribute1),
297: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
298: attribute2, p_attribute2),
299: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
300: attribute3, p_attribute3),
301: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
302: attribute4, p_attribute4),
303: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,

Line 301: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,

297: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
298: attribute2, p_attribute2),
299: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
300: attribute3, p_attribute3),
301: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
302: attribute4, p_attribute4),
303: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
304: attribute5, p_attribute5),
305: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,

Line 303: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,

299: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
300: attribute3, p_attribute3),
301: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
302: attribute4, p_attribute4),
303: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
304: attribute5, p_attribute5),
305: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
306: attribute6, p_attribute6),
307: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,

Line 305: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,

301: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
302: attribute4, p_attribute4),
303: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
304: attribute5, p_attribute5),
305: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
306: attribute6, p_attribute6),
307: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
308: attribute7, p_attribute7),
309: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,

Line 307: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,

303: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
304: attribute5, p_attribute5),
305: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
306: attribute6, p_attribute6),
307: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
308: attribute7, p_attribute7),
309: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
310: attribute8, p_attribute8),
311: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,

Line 309: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,

305: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
306: attribute6, p_attribute6),
307: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
308: attribute7, p_attribute7),
309: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
310: attribute8, p_attribute8),
311: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
312: attribute9, p_attribute9),
313: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,

Line 311: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,

307: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
308: attribute7, p_attribute7),
309: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
310: attribute8, p_attribute8),
311: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
312: attribute9, p_attribute9),
313: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
314: attribute10, p_attribute10),
315: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,

Line 313: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,

309: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
310: attribute8, p_attribute8),
311: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
312: attribute9, p_attribute9),
313: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
314: attribute10, p_attribute10),
315: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
316: attribute11, p_attribute11),
317: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,

Line 315: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,

311: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
312: attribute9, p_attribute9),
313: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
314: attribute10, p_attribute10),
315: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
316: attribute11, p_attribute11),
317: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
318: attribute12, p_attribute12),
319: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,

Line 317: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,

313: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
314: attribute10, p_attribute10),
315: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
316: attribute11, p_attribute11),
317: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
318: attribute12, p_attribute12),
319: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
320: attribute13, p_attribute13),
321: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,

Line 319: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,

315: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
316: attribute11, p_attribute11),
317: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
318: attribute12, p_attribute12),
319: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
320: attribute13, p_attribute13),
321: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
322: attribute14, p_attribute14),
323: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,

Line 321: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,

317: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
318: attribute12, p_attribute12),
319: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
320: attribute13, p_attribute13),
321: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
322: attribute14, p_attribute14),
323: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
324: attribute15, p_attribute15),
325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 323: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,

319: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
320: attribute13, p_attribute13),
321: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
322: attribute14, p_attribute14),
323: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
324: attribute15, p_attribute15),
325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
326: NULL, sysdate, p_last_update_date),
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

321: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
322: attribute14, p_attribute14),
323: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
324: attribute15, p_attribute15),
325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
326: NULL, sysdate, p_last_update_date),
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),

Line 327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

323: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
324: attribute15, p_attribute15),
325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
326: NULL, sysdate, p_last_update_date),
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),
330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

326: NULL, sysdate, p_last_update_date),
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),
330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
332: p_last_update_login)
333: WHERE msite_information_id = p_msite_information_id
334: AND object_version_number = decode(p_object_version_number,

Line 335: FND_API.G_MISS_NUM,

331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
332: p_last_update_login)
333: WHERE msite_information_id = p_msite_information_id
334: AND object_version_number = decode(p_object_version_number,
335: FND_API.G_MISS_NUM,
336: object_version_number,
337: p_object_version_number);
338: IF (sql%NOTFOUND) THEN
339: RAISE NO_DATA_FOUND;