APPS.GMI_QUANTITY_PUB dependencies on DUAL

Line 183: SELECT gem5_journal_id_s.nextval INTO l_journal_id FROM dual;

179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: -- Get the surrogate key (journal_id) for the journal
183: SELECT gem5_journal_id_s.nextval INTO l_journal_id FROM dual;
184: IF (l_journal_id <=0)
185: THEN
186: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
187: FND_MESSAGE.SET_TOKEN('SKEY','journal_id');

Line 222: SELECT gem5_doc_id_s.nextval INTO l_doc_id FROM dual;

218: END IF;
219:
220: -- Write transactions to ic_adjs_jnl
221: -- First get the surrogate key (doc_id) for the transaction.
222: SELECT gem5_doc_id_s.nextval INTO l_doc_id FROM dual;
223: IF (l_doc_id <=0)
224: THEN
225: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
226: FND_MESSAGE.SET_TOKEN('SKEY','doc_id');

Line 251: SELECT gem5_line_id_s.nextval INTO l_line_id FROM dual;

247: -- is duplicated.
248:
249: IF (l_loop_ctr = 1 OR l_trans_rec.trans_type = 3)
250: THEN
251: SELECT gem5_line_id_s.nextval INTO l_line_id FROM dual;
252: IF (l_line_id <=0)
253: THEN
254: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
255: FND_MESSAGE.SET_TOKEN('SKEY','line_id');