APPS.GMI_CMP_TRAN_PVT dependencies on DUAL

Line 77: SELECT gem5_trans_id_s.nextval INTO l_cmp_tran_rec.trans_id FROM dual;

73:
74: -- If trans_id not supplied then get it
75: IF (l_cmp_tran_rec.trans_id = 0)
76: THEN
77: SELECT gem5_trans_id_s.nextval INTO l_cmp_tran_rec.trans_id FROM dual;
78: IF (l_cmp_tran_rec.trans_id <= 0)
79: THEN
80: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
81: FND_MESSAGE.SET_TOKEN('SKEY','trans_id');

Line 751: SELECT gem5_summ_inv_id_s.nextval INTO l_summ_inv_id FROM dual;

747: FETCH summary_inv INTO l_ic_summ_inv;
748:
749: IF (summary_inv%NOTFOUND)
750: THEN
751: SELECT gem5_summ_inv_id_s.nextval INTO l_summ_inv_id FROM dual;
752: IF (l_summ_inv_id <= 0)
753: THEN
754: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
755: FND_MESSAGE.SET_TOKEN('SKEY','summ_inv_id');