eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_UPG_OE_PVT dependencies on OE_UPG_SO_NEW

Line 159: IF (OE_Upg_SO_NEW.g_line_rec.pricing_attribute1 IS NOT NULL) OR

155: v_err_msg varchar2(2000);
156:
157: begin
158:
159: IF (OE_Upg_SO_NEW.g_line_rec.pricing_attribute1 IS NOT NULL) OR
160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR
161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR

Line 160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR

156:
157: begin
158:
159: IF (OE_Upg_SO_NEW.g_line_rec.pricing_attribute1 IS NOT NULL) OR
160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR
161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR

Line 161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR

157: begin
158:
159: IF (OE_Upg_SO_NEW.g_line_rec.pricing_attribute1 IS NOT NULL) OR
160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR
161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR

Line 162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR

158:
159: IF (OE_Upg_SO_NEW.g_line_rec.pricing_attribute1 IS NOT NULL) OR
160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR
161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR

Line 163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR

159: IF (OE_Upg_SO_NEW.g_line_rec.pricing_attribute1 IS NOT NULL) OR
160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR
161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR

Line 164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR

160: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute2 IS NOT NULL) OR
161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR

Line 165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR

161: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute3 IS NOT NULL) OR
162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR

Line 166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR

162: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute4 IS NOT NULL) OR
163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR

Line 167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR

163: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute5 IS NOT NULL) OR
164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR

Line 168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR

164: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute6 IS NOT NULL) OR
165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR
172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR

Line 169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR

165: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute7 IS NOT NULL) OR
166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR
172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR
173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)

Line 170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR

166: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute8 IS NOT NULL) OR
167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR
172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR
173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)
174:

Line 171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR

167: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute9 IS NOT NULL) OR
168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR
172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR
173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)
174:
175: THEN

Line 172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR

168: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute10 IS NOT NULL) OR
169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR
172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR
173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)
174:
175: THEN
176: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval

Line 173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)

169: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute11 IS NOT NULL) OR
170: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute12 IS NOT NULL) OR
171: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute13 IS NOT NULL) OR
172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR
173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)
174:
175: THEN
176: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval
177: INTO v_order_price_attrib_id

Line 213: ( OE_Upg_SO_NEW.g_line_rec.header_id,

209: order_price_attrib_id,
210: override_flag ,
211: lock_control)
212: values
213: ( OE_Upg_SO_NEW.g_line_rec.header_id,
214: OE_Upg_SO_NEW.g_line_rec.line_id,
215: SYSDATE,
216: FND_GLOBAL.USER_ID,
217: SYSDATE,

Line 214: OE_Upg_SO_NEW.g_line_rec.line_id,

210: override_flag ,
211: lock_control)
212: values
213: ( OE_Upg_SO_NEW.g_line_rec.header_id,
214: OE_Upg_SO_NEW.g_line_rec.line_id,
215: SYSDATE,
216: FND_GLOBAL.USER_ID,
217: SYSDATE,
218: FND_GLOBAL.USER_ID,

Line 220: OE_Upg_SO_NEW.g_line_rec.program_application_id,

216: FND_GLOBAL.USER_ID,
217: SYSDATE,
218: FND_GLOBAL.USER_ID,
219: FND_GLOBAL.LOGIN_ID,
220: OE_Upg_SO_NEW.g_line_rec.program_application_id,
221: OE_Upg_SO_NEW.g_line_rec.program_id,
222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),

Line 221: OE_Upg_SO_NEW.g_line_rec.program_id,

217: SYSDATE,
218: FND_GLOBAL.USER_ID,
219: FND_GLOBAL.LOGIN_ID,
220: OE_Upg_SO_NEW.g_line_rec.program_application_id,
221: OE_Upg_SO_NEW.g_line_rec.program_id,
222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,

Line 222: OE_Upg_SO_NEW.g_line_rec.program_update_date,

218: FND_GLOBAL.USER_ID,
219: FND_GLOBAL.LOGIN_ID,
220: OE_Upg_SO_NEW.g_line_rec.program_application_id,
221: OE_Upg_SO_NEW.g_line_rec.program_id,
222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,

Line 223: OE_Upg_SO_NEW.g_line_rec.request_id,

219: FND_GLOBAL.LOGIN_ID,
220: OE_Upg_SO_NEW.g_line_rec.program_application_id,
221: OE_Upg_SO_NEW.g_line_rec.program_id,
222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,

Line 224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),

220: OE_Upg_SO_NEW.g_line_rec.program_application_id,
221: OE_Upg_SO_NEW.g_line_rec.program_id,
222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,

Line 225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,

221: OE_Upg_SO_NEW.g_line_rec.program_id,
222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,

Line 226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,

222: OE_Upg_SO_NEW.g_line_rec.program_update_date,
223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,

Line 227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,

223: OE_Upg_SO_NEW.g_line_rec.request_id,
224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,

Line 228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,

224: NVL(OE_Upg_SO_NEW.g_line_rec.pricing_context,'Upgrade Context'),
225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,

Line 229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,

225: OE_Upg_SO_NEW.g_line_rec.pricing_attribute1,
226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,

Line 230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,

226: OE_Upg_SO_NEW.g_line_rec.pricing_attribute2,
227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,

Line 231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,

227: OE_Upg_SO_NEW.g_line_rec.pricing_attribute3,
228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,

Line 232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,

228: OE_Upg_SO_NEW.g_line_rec.pricing_attribute4,
229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,

Line 233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,

229: OE_Upg_SO_NEW.g_line_rec.pricing_attribute5,
230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,

Line 234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,

230: OE_Upg_SO_NEW.g_line_rec.pricing_attribute6,
231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,
238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,

Line 235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,

231: OE_Upg_SO_NEW.g_line_rec.pricing_attribute7,
232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,
238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,
239: OE_Upg_SO_NEW.g_line_rec.pricing_attribute15,

Line 236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,

232: OE_Upg_SO_NEW.g_line_rec.pricing_attribute8,
233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,
238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,
239: OE_Upg_SO_NEW.g_line_rec.pricing_attribute15,
240: 'QP_ATTR_DEFNS_PRICING',

Line 237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,

233: OE_Upg_SO_NEW.g_line_rec.pricing_attribute9,
234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,
238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,
239: OE_Upg_SO_NEW.g_line_rec.pricing_attribute15,
240: 'QP_ATTR_DEFNS_PRICING',
241: v_order_price_attrib_id,

Line 238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,

234: OE_Upg_SO_NEW.g_line_rec.pricing_attribute10,
235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,
238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,
239: OE_Upg_SO_NEW.g_line_rec.pricing_attribute15,
240: 'QP_ATTR_DEFNS_PRICING',
241: v_order_price_attrib_id,
242: 'N',

Line 239: OE_Upg_SO_NEW.g_line_rec.pricing_attribute15,

235: OE_Upg_SO_NEW.g_line_rec.pricing_attribute11,
236: OE_Upg_SO_NEW.g_line_rec.pricing_attribute12,
237: OE_Upg_SO_NEW.g_line_rec.pricing_attribute13,
238: OE_Upg_SO_NEW.g_line_rec.pricing_attribute14,
239: OE_Upg_SO_NEW.g_line_rec.pricing_attribute15,
240: 'QP_ATTR_DEFNS_PRICING',
241: v_order_price_attrib_id,
242: 'N',
243: 1);

Line 277: (oe_upg_so_new.g_line_rec.pricing_attribute11 IS NOT NULL) OR

273: (p_line_rec.pricing_attribute7 IS NOT NULL) OR
274: (p_line_rec.pricing_attribute8 IS NOT NULL) OR
275: (p_line_rec.pricing_attribute9 IS NOT NULL) OR
276: (p_line_rec.pricing_attribute10 IS NOT NULL) OR
277: (oe_upg_so_new.g_line_rec.pricing_attribute11 IS NOT NULL) OR
278: (oe_upg_so_new.g_line_rec.pricing_attribute12 IS NOT NULL) OR
279: (oe_upg_so_new.g_line_rec.pricing_attribute13 IS NOT NULL) OR
280: (oe_upg_so_new.g_line_rec.pricing_attribute14 IS NOT NULL) OR
281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)

Line 278: (oe_upg_so_new.g_line_rec.pricing_attribute12 IS NOT NULL) OR

274: (p_line_rec.pricing_attribute8 IS NOT NULL) OR
275: (p_line_rec.pricing_attribute9 IS NOT NULL) OR
276: (p_line_rec.pricing_attribute10 IS NOT NULL) OR
277: (oe_upg_so_new.g_line_rec.pricing_attribute11 IS NOT NULL) OR
278: (oe_upg_so_new.g_line_rec.pricing_attribute12 IS NOT NULL) OR
279: (oe_upg_so_new.g_line_rec.pricing_attribute13 IS NOT NULL) OR
280: (oe_upg_so_new.g_line_rec.pricing_attribute14 IS NOT NULL) OR
281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)
282:

Line 279: (oe_upg_so_new.g_line_rec.pricing_attribute13 IS NOT NULL) OR

275: (p_line_rec.pricing_attribute9 IS NOT NULL) OR
276: (p_line_rec.pricing_attribute10 IS NOT NULL) OR
277: (oe_upg_so_new.g_line_rec.pricing_attribute11 IS NOT NULL) OR
278: (oe_upg_so_new.g_line_rec.pricing_attribute12 IS NOT NULL) OR
279: (oe_upg_so_new.g_line_rec.pricing_attribute13 IS NOT NULL) OR
280: (oe_upg_so_new.g_line_rec.pricing_attribute14 IS NOT NULL) OR
281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)
282:
283: THEN

Line 280: (oe_upg_so_new.g_line_rec.pricing_attribute14 IS NOT NULL) OR

276: (p_line_rec.pricing_attribute10 IS NOT NULL) OR
277: (oe_upg_so_new.g_line_rec.pricing_attribute11 IS NOT NULL) OR
278: (oe_upg_so_new.g_line_rec.pricing_attribute12 IS NOT NULL) OR
279: (oe_upg_so_new.g_line_rec.pricing_attribute13 IS NOT NULL) OR
280: (oe_upg_so_new.g_line_rec.pricing_attribute14 IS NOT NULL) OR
281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)
282:
283: THEN
284:

Line 281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)

277: (oe_upg_so_new.g_line_rec.pricing_attribute11 IS NOT NULL) OR
278: (oe_upg_so_new.g_line_rec.pricing_attribute12 IS NOT NULL) OR
279: (oe_upg_so_new.g_line_rec.pricing_attribute13 IS NOT NULL) OR
280: (oe_upg_so_new.g_line_rec.pricing_attribute14 IS NOT NULL) OR
281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)
282:
283: THEN
284:
285: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval

Line 344: oe_upg_so_new.g_line_rec.pricing_attribute11,

340: p_line_rec.pricing_attribute7,
341: p_line_rec.pricing_attribute8,
342: p_line_rec.pricing_attribute9,
343: p_line_rec.pricing_attribute10,
344: oe_upg_so_new.g_line_rec.pricing_attribute11,
345: oe_upg_so_new.g_line_rec.pricing_attribute12,
346: oe_upg_so_new.g_line_rec.pricing_attribute13,
347: oe_upg_so_new.g_line_rec.pricing_attribute14,
348: oe_upg_so_new.g_line_rec.pricing_attribute15,

Line 345: oe_upg_so_new.g_line_rec.pricing_attribute12,

341: p_line_rec.pricing_attribute8,
342: p_line_rec.pricing_attribute9,
343: p_line_rec.pricing_attribute10,
344: oe_upg_so_new.g_line_rec.pricing_attribute11,
345: oe_upg_so_new.g_line_rec.pricing_attribute12,
346: oe_upg_so_new.g_line_rec.pricing_attribute13,
347: oe_upg_so_new.g_line_rec.pricing_attribute14,
348: oe_upg_so_new.g_line_rec.pricing_attribute15,
349: 'QP_ATTR_DEFNS_PRICING',

Line 346: oe_upg_so_new.g_line_rec.pricing_attribute13,

342: p_line_rec.pricing_attribute9,
343: p_line_rec.pricing_attribute10,
344: oe_upg_so_new.g_line_rec.pricing_attribute11,
345: oe_upg_so_new.g_line_rec.pricing_attribute12,
346: oe_upg_so_new.g_line_rec.pricing_attribute13,
347: oe_upg_so_new.g_line_rec.pricing_attribute14,
348: oe_upg_so_new.g_line_rec.pricing_attribute15,
349: 'QP_ATTR_DEFNS_PRICING',
350: v_order_price_attrib_id,

Line 347: oe_upg_so_new.g_line_rec.pricing_attribute14,

343: p_line_rec.pricing_attribute10,
344: oe_upg_so_new.g_line_rec.pricing_attribute11,
345: oe_upg_so_new.g_line_rec.pricing_attribute12,
346: oe_upg_so_new.g_line_rec.pricing_attribute13,
347: oe_upg_so_new.g_line_rec.pricing_attribute14,
348: oe_upg_so_new.g_line_rec.pricing_attribute15,
349: 'QP_ATTR_DEFNS_PRICING',
350: v_order_price_attrib_id,
351: 'N',

Line 348: oe_upg_so_new.g_line_rec.pricing_attribute15,

344: oe_upg_so_new.g_line_rec.pricing_attribute11,
345: oe_upg_so_new.g_line_rec.pricing_attribute12,
346: oe_upg_so_new.g_line_rec.pricing_attribute13,
347: oe_upg_so_new.g_line_rec.pricing_attribute14,
348: oe_upg_so_new.g_line_rec.pricing_attribute15,
349: 'QP_ATTR_DEFNS_PRICING',
350: v_order_price_attrib_id,
351: 'N',
352: 1);

Line 370: PROCEDURE Upg_Pricing_Attribs (p_upg_line_rec IN OE_UPG_SO_NEW.LINE_REC_TYPE)

366: end Upg_Pricing_Attribs;
367:
368:
369:
370: PROCEDURE Upg_Pricing_Attribs (p_upg_line_rec IN OE_UPG_SO_NEW.LINE_REC_TYPE)
371: IS
372:
373: v_order_price_attrib_id NUMBER;
374: v_err_msg varchar2(2000);