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_COUPON_PVT dependencies on QP_COUPONS

Line 134: -- Procedure Insert_Coupon creates a record in QP_COUPONS table

130:
131:
132:
133:
134: -- Procedure Insert_Coupon creates a record in QP_COUPONS table
135: PROCEDURE Insert_Coupon(
136: p_issued_by_modifier_id IN NUMBER
137: , p_expiration_period_start_date IN DATE := NULL
138: , p_expiration_date IN DATE := NULL

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:

Line 214: QP_PREQ_GRP.engine_debug ('coupon_number going to QP_COUPONS table: '||x_coupon_number);

210:
211: x_coupon_number := p_user_def_coupon_number||l_generated_coupon_number;
212:
213: IF l_debug = FND_API.G_TRUE THEN
214: QP_PREQ_GRP.engine_debug ('coupon_number going to QP_COUPONS table: '||x_coupon_number);
215: END IF; -- END IF l_debug
216:
217: INSERT INTO QP_COUPONS(
218: COUPON_ID,

Line 217: INSERT INTO QP_COUPONS(

213: IF l_debug = FND_API.G_TRUE THEN
214: QP_PREQ_GRP.engine_debug ('coupon_number going to QP_COUPONS table: '||x_coupon_number);
215: END IF; -- END IF l_debug
216:
217: INSERT INTO QP_COUPONS(
218: COUPON_ID,
219: CREATION_DATE,
220: CREATED_BY,
221: LAST_UPDATE_DATE,

Line 472: UPDATE QP_COUPONS

468:
469: /*
470: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd1,-No Index Used-,NA,NA
471: */
472: UPDATE QP_COUPONS
473: SET redeemed_flag='Y'
474: WHERE coupon_number = p_coupon_number;
475:
476: IF SQL%NOTFOUND THEN

Line 489: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_sel1,QP_COUPONS_PK,COUPON_ID,1

485: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
486: */
487:
488: /*
489: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_sel1,QP_COUPONS_PK,COUPON_ID,1
490: */
491:
492: -- Bug 9210291 - Replacing query to improve performance
493: /* UPDATE qp_qualifiers

Line 499: (select coupon_id from qp_coupons where coupon_number=p_Coupon_number);*/

495: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
496: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
497: AND nvl(comparison_operator_code,'=') = '='
498: AND qualifier_attr_Value in
499: (select coupon_id from qp_coupons where coupon_number=p_Coupon_number);*/
500:
501: UPDATE /*+ INDEX(qpq QP_QUALIFIERS_N4) */ qp_qualifiers qpq
502: SET qpq.end_date_active = p_pricing_effective_date
503: WHERE qpq.qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT

Line 507: (select TO_CHAR(coupon_id) from qp_coupons where coupon_number=p_Coupon_number);

503: WHERE qpq.qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
504: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
505: AND nvl(qpq.comparison_operator_code,'=') = '='
506: AND qpq.qualifier_attr_Value in
507: (select TO_CHAR(coupon_id) from qp_coupons where coupon_number=p_Coupon_number);
508:
509: IF SQL%NOTFOUND THEN
510: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
511: END IF;

Line 551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,QP_COUPONS_PK,COUPON_ID,1

547:
548: --dbms_output.put_line('unredeem coupon id: '||p_coupon_ID);
549:
550: /*
551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,QP_COUPONS_PK,COUPON_ID,1
552: */
553: UPDATE QP_COUPONS
554: SET redeemed_flag='N'
555: WHERE coupon_id = p_coupon_id;

Line 553: UPDATE QP_COUPONS

549:
550: /*
551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,QP_COUPONS_PK,COUPON_ID,1
552: */
553: UPDATE QP_COUPONS
554: SET redeemed_flag='N'
555: WHERE coupon_id = p_coupon_id;
556:
557: -- Make Qualifier for the coupon Inactive

Line 604: UPDATE QP_COUPONS

600:
601: /*
602: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,-No Index Used-,NA,NA
603: */
604: UPDATE QP_COUPONS
605: SET redeemed_flag='N'
606: WHERE coupon_number = p_coupon_number;
607:
608: IF SQL%NOTFOUND THEN

Line 621: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_sel1,QP_COUPONS_PK,COUPON_ID,1

617: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
618: */
619:
620: /*
621: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_sel1,QP_COUPONS_PK,COUPON_ID,1
622: */
623:
624: -- Bug 9210291 - Replacing query to improve performance.
625: /*

Line 632: (select coupon_id from qp_coupons where coupon_number=p_Coupon_Number);

628: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
629: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
630: AND nvl(comparison_operator_code,'=') = '='
631: AND qualifier_attr_Value in
632: (select coupon_id from qp_coupons where coupon_number=p_Coupon_Number);
633: */
634:
635: UPDATE /*+ INDEX(qpq QP_QUALIFIERS_N4) */ qp_qualifiers qpq
636: SET qpq.end_date_active = NULL

Line 641: (select TO_CHAR(coupon_id) from qp_coupons where coupon_number=p_Coupon_Number);

637: WHERE qpq.qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
638: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
639: AND nvl(qpq.comparison_operator_code,'=') = '='
640: AND qpq.qualifier_attr_Value in
641: (select TO_CHAR(coupon_id) from qp_coupons where coupon_number=p_Coupon_Number);
642:
643: IF SQL%NOTFOUND THEN
644: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
645: END IF;

Line 683: DELETE FROM QP_COUPONS

679:
680: /*
681: INDX,QP_COUPON_PVT.Purge_Coupon.Purge_Coupon_del1,-No Index Used-,NA,NA
682: */
683: DELETE FROM QP_COUPONS
684: WHERE redeemed_flag='Y'
685: OR expiration_date < sysdate;
686:
687: EXCEPTION

Line 717: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_sel1,QP_COUPONS_PK,COUPON_ID,1

713: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
714: */
715:
716: /*
717: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_sel1,QP_COUPONS_PK,COUPON_ID,1
718: */
719: DELETE FROM qp_qualifiers
720: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
721: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

Line 724: (select coupon_id from qp_coupons where coupon_number=p_coupon_number);

720: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
721: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
722: AND nvl(comparison_operator_code,'=') = '='
723: AND qualifier_attr_Value in
724: (select coupon_id from qp_coupons where coupon_number=p_coupon_number);
725:
726: IF SQL%NOTFOUND THEN
727: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
728: END IF;

Line 733: DELETE FROM QP_COUPONS

729:
730: /*
731: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del2,-No Index Used-,NA,NA
732: */
733: DELETE FROM QP_COUPONS
734: WHERE Coupon_number = p_Coupon_number;
735:
736: IF SQL%NOTFOUND THEN
737: RAISE QP_COUPON_NOT_FOUND;

Line 1024: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,QP_COUPONS_PK,COUPON_ID,1

1020: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,LINE_INDEX,1
1021: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,ATTRIBUTE_TYPE,2
1022: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3
1023:
1024: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,QP_COUPONS_PK,COUPON_ID,1
1025:
1026: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_lines_tmp_U1,LINE_INDEX,1
1027: */
1028: CURSOR get_coupons_ldet IS

Line 1034: qp_coupons qpc

1030: qpl.pricing_effective_date
1031: FROM qp_npreq_line_attrs_tmp qplat,
1032: qp_npreq_ldets_tmp qpd,
1033: qp_npreq_lines_tmp qpl,
1034: qp_coupons qpc
1035: WHERE qplat.line_index = qpd.line_index
1036: and qpl.line_index = qpd.line_index
1037: and qplat.line_detail_index = qpd.line_detail_index
1038: and qplat.attribute_type= QP_PREQ_GRP.G_QUALIFIER_TYPE

Line 1055: qp_coupons qpc

1051: FROM qp_npreq_line_attrs_tmp qplat,
1052: qp_npreq_ldets_tmp qpd,
1053: qp_npreq_lines_tmp qpl,
1054: qp_qualifiers qpq,
1055: qp_coupons qpc
1056: WHERE qplat.line_index = qpl.line_index
1057: and qplat.line_detail_index is null
1058: and qplat.attribute_type = QP_PREQ_GRP.G_QUALIFIER_TYPE
1059: and qplat.context = QP_PREQ_GRP.G_LIST_HEADER_CONTEXT