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: UPDATE qp_qualifiers
492: SET end_date_active = p_pricing_effective_date
493: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT

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

493: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
494: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
495: AND nvl(comparison_operator_code,'=') = '='
496: AND qualifier_attr_Value in
497: (select coupon_id from qp_coupons where coupon_number=p_Coupon_number);
498:
499: IF SQL%NOTFOUND THEN
500: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
501: END IF;

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

537:
538: --dbms_output.put_line('unredeem coupon id: '||p_coupon_ID);
539:
540: /*
541: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,QP_COUPONS_PK,COUPON_ID,1
542: */
543: UPDATE QP_COUPONS
544: SET redeemed_flag='N'
545: WHERE coupon_id = p_coupon_id;

Line 543: UPDATE QP_COUPONS

539:
540: /*
541: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,QP_COUPONS_PK,COUPON_ID,1
542: */
543: UPDATE QP_COUPONS
544: SET redeemed_flag='N'
545: WHERE coupon_id = p_coupon_id;
546:
547: -- Make Qualifier for the coupon Inactive

Line 583: UPDATE QP_COUPONS

579:
580: /*
581: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,-No Index Used-,NA,NA
582: */
583: UPDATE QP_COUPONS
584: SET redeemed_flag='N'
585: WHERE coupon_number = p_coupon_number;
586:
587: IF SQL%NOTFOUND THEN

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

596: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
597: */
598:
599: /*
600: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_sel1,QP_COUPONS_PK,COUPON_ID,1
601: */
602: UPDATE qp_qualifiers
603: SET end_date_active = NULL
604: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT

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

604: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
605: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
606: AND nvl(comparison_operator_code,'=') = '='
607: AND qualifier_attr_Value in
608: (select coupon_id from qp_coupons where coupon_number=p_Coupon_Number);
609:
610: IF SQL%NOTFOUND THEN
611: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
612: END IF;

Line 650: DELETE FROM QP_COUPONS

646:
647: /*
648: INDX,QP_COUPON_PVT.Purge_Coupon.Purge_Coupon_del1,-No Index Used-,NA,NA
649: */
650: DELETE FROM QP_COUPONS
651: WHERE redeemed_flag='Y'
652: OR expiration_date < sysdate;
653:
654: EXCEPTION

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

680: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
681: */
682:
683: /*
684: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_sel1,QP_COUPONS_PK,COUPON_ID,1
685: */
686: DELETE FROM qp_qualifiers
687: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
688: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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

687: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
688: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
689: AND nvl(comparison_operator_code,'=') = '='
690: AND qualifier_attr_Value in
691: (select coupon_id from qp_coupons where coupon_number=p_coupon_number);
692:
693: IF SQL%NOTFOUND THEN
694: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
695: END IF;

Line 700: DELETE FROM QP_COUPONS

696:
697: /*
698: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del2,-No Index Used-,NA,NA
699: */
700: DELETE FROM QP_COUPONS
701: WHERE Coupon_number = p_Coupon_number;
702:
703: IF SQL%NOTFOUND THEN
704: RAISE QP_COUPON_NOT_FOUND;

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

987: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,LINE_INDEX,1
988: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,ATTRIBUTE_TYPE,2
989: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3
990:
991: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,QP_COUPONS_PK,COUPON_ID,1
992:
993: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_lines_tmp_U1,LINE_INDEX,1
994: */
995: CURSOR get_coupons_ldet IS

Line 1001: qp_coupons qpc

997: qpl.pricing_effective_date
998: FROM qp_npreq_line_attrs_tmp qplat,
999: qp_npreq_ldets_tmp qpd,
1000: qp_npreq_lines_tmp qpl,
1001: qp_coupons qpc
1002: WHERE qplat.line_index = qpd.line_index
1003: and qpl.line_index = qpd.line_index
1004: and qplat.line_detail_index = qpd.line_detail_index
1005: and qplat.attribute_type= QP_PREQ_GRP.G_QUALIFIER_TYPE

Line 1022: qp_coupons qpc

1018: FROM qp_npreq_line_attrs_tmp qplat,
1019: qp_npreq_ldets_tmp qpd,
1020: qp_npreq_lines_tmp qpl,
1021: qp_qualifiers qpq,
1022: qp_coupons qpc
1023: WHERE qplat.line_index = qpl.line_index
1024: and qplat.line_detail_index is null
1025: and qplat.attribute_type = QP_PREQ_GRP.G_QUALIFIER_TYPE
1026: and qplat.context = QP_PREQ_GRP.G_LIST_HEADER_CONTEXT