APPS.IEX_DISPUTE_PVT dependencies on DUAL

Line 163: from dual;

159: END IF;
160:
161: -- add this to avoid bug# 2166002
162: select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line
163: from dual;
164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
165: from dual;
166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight
167: from dual;

Line 165: from dual;

161: -- add this to avoid bug# 2166002
162: select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line
163: from dual;
164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
165: from dual;
166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight
167: from dual;
168:
169: if lp_disp_line_tbl is not null then

Line 167: from dual;

163: from dual;
164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
165: from dual;
166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight
167: from dual;
168:
169: if lp_disp_line_tbl is not null then
170: lines_count := lp_disp_line_tbl.count;
171: -- IF PG_DEBUG < 10 THEN

Line 236: SELECT iex_disputes_s.nextval INTO l_dis_id FROM dual;

232: p_dispute_date => p_dispute_date --Added for bug#6347547 by schekuri on 08-Nov-2007
233: );
234:
235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
236: SELECT iex_disputes_s.nextval INTO l_dis_id FROM dual;
237:
238: -- IF PG_DEBUG < 10 THEN
239: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
240: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Inserting a dispute row in IEX_DISPUTES');