DBA Data[Home] [Help]

APPS.QP_COUPON_PVT dependencies on QP_COUPONS_S

Line 200: QP_COUPONS_S.nextval

196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198:
199: SELECT QP_GENERATED_COUPON_NO_S.nextval,
200: QP_COUPONS_S.nextval
201: INTO l_generated_coupon_number,
202: x_coupon_id
203: FROM dual;
204:

Line 206: QP_PREQ_GRP.engine_debug ('coupon_id going to QP_COUPONS table (QP_COUPONS_S.nextval): '||x_coupon_id);

202: x_coupon_id
203: FROM dual;
204:
205: IF l_debug = FND_API.G_TRUE THEN
206: QP_PREQ_GRP.engine_debug ('coupon_id going to QP_COUPONS table (QP_COUPONS_S.nextval): '||x_coupon_id);
207: QP_PREQ_GRP.engine_debug ('l_generated_coupon_number(QP_GENERATED_COUPON_NO_S.nextval): '||l_generated_coupon_number);
208: QP_PREQ_GRP.engine_debug ('p_user_def_coupon_number: '||p_user_def_coupon_number);
209: END IF; -- END IF l_debug
210: