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_QUALIFIERS

Line 26: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1

22: x_return_status OUT NOCOPY VARCHAR2,
23: x_return_text OUT NOCOPY VARCHAR2) IS
24:
25: /*
26: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
27: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
28: */
29: CURSOR l_qual_exists_cur(p_header_id NUMBER) IS
30: select 'X' qual_exists

Line 27: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2

23: x_return_text OUT NOCOPY VARCHAR2) IS
24:
25: /*
26: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
27: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
28: */
29: CURSOR l_qual_exists_cur(p_header_id NUMBER) IS
30: select 'X' qual_exists
31: from qp_qualifiers

Line 31: from qp_qualifiers

27: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
28: */
29: CURSOR l_qual_exists_cur(p_header_id NUMBER) IS
30: select 'X' qual_exists
31: from qp_qualifiers
32: where list_header_id=p_header_id
33: and list_line_id= -1;
34:
35: /*

Line 82: INDX,QP_COUPON_PVT.update_qual_ind.l_line_qual_exists_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1

78: x_return_status OUT NOCOPY VARCHAR2,
79: x_return_text OUT NOCOPY VARCHAR2) IS
80:
81: /*
82: INDX,QP_COUPON_PVT.update_qual_ind.l_line_qual_exists_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
83: INDX,QP_COUPON_PVT.update_qual_ind.l_line_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
84: */
85: CURSOR l_line_qual_exists_cur(p_line_id NUMBER
86: ,p_header_id NUMBER) IS

Line 83: INDX,QP_COUPON_PVT.update_qual_ind.l_line_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2

79: x_return_text OUT NOCOPY VARCHAR2) IS
80:
81: /*
82: INDX,QP_COUPON_PVT.update_qual_ind.l_line_qual_exists_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
83: INDX,QP_COUPON_PVT.update_qual_ind.l_line_qual_exists_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
84: */
85: CURSOR l_line_qual_exists_cur(p_line_id NUMBER
86: ,p_header_id NUMBER) IS
87: select 'Y'

Line 88: from qp_qualifiers q

84: */
85: CURSOR l_line_qual_exists_cur(p_line_id NUMBER
86: ,p_header_id NUMBER) IS
87: select 'Y'
88: from qp_qualifiers q
89: where q.list_header_id=p_header_id
90: and q.list_line_id=p_line_id;
91:
92:

Line 267: -- Procedure Create_Coupon_Qualifier creates a record in QP_QUALIFIERS table to say that

263: x_return_status := FND_API.G_RET_STS_ERROR;
264:
265: END Insert_Coupon;
266:
267: -- Procedure Create_Coupon_Qualifier creates a record in QP_QUALIFIERS table to say that
268: -- if your order quotes this coupon number, you can use the benefits in the coupon
269: PROCEDURE Create_Coupon_Qualifier(
270: p_list_line_id IN NUMBER
271: , p_coupon_id IN NUMBER

Line 343: INSERT INTO QP_QUALIFIERS (

339: qp_number.canonical_to_number(NULL);
340:
341:
342: /* Create a qualifier: "Coupon" = Coupon Number,context = 'Order'? */
343: INSERT INTO QP_QUALIFIERS (
344: QUALIFIER_ID,
345: CREATION_DATE,
346: CREATED_BY,
347: LAST_UPDATE_DATE,

Line 376: QP_QUALIFIERS_S.nextval,

372: ,ORIG_SYS_LINE_REF
373: ,ORIG_SYS_HEADER_REF
374: )
375: VALUES (
376: QP_QUALIFIERS_S.nextval,
377: sysdate,
378: fnd_global.user_id,
379: sysdate,
380: fnd_global.user_id,

Line 394: (select count(*) from qp_qualifiers where list_line_id = l_list_line_id and qualifier_grouping_no = -1)+1, --[julin/5416713] accounting for -1 qualifiers

390: 'N',
391: 1,
392: 1,
393: l_header_qual_exists_flag,
394: (select count(*) from qp_qualifiers where list_line_id = l_list_line_id and qualifier_grouping_no = -1)+1, --[julin/5416713] accounting for -1 qualifiers
395: l_active_flag,
396: l_list_type_code,
397: l_qual_attr_value_from_number,
398: l_qual_attr_value_to_number,

Line 401: ,to_char(QP_QUALIFIERS_S.currval)

397: l_qual_attr_value_from_number,
398: l_qual_attr_value_to_number,
399: 1
400: --ENH Upgrade BOAPI for orig_sys...ref RAVI
401: ,to_char(QP_QUALIFIERS_S.currval)
402: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_list_line_id)
403: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_list_header_id)
404: );
405:

Line 482: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1

478: END IF;
479:
480: -- Make Qualifier for the coupon Inactive
481: /*
482: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
483: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
484: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
485: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
486: */

Line 483: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2

479:
480: -- Make Qualifier for the coupon Inactive
481: /*
482: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
483: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
484: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
485: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
486: */
487:

Line 484: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3

480: -- Make Qualifier for the coupon Inactive
481: /*
482: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
483: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
484: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
485: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
486: */
487:
488: /*

Line 485: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4

481: /*
482: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
483: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
484: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
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

Line 493: /* UPDATE qp_qualifiers

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
494: SET end_date_active = p_pricing_effective_date
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,'=') = '='

Line 501: UPDATE /+ INDEX(qpq QP_QUALIFIERS_N4) / qp_qualifiers qpq

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
504: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
505: AND nvl(qpq.comparison_operator_code,'=') = '='

Line 559: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1

555: WHERE coupon_id = p_coupon_id;
556:
557: -- Make Qualifier for the coupon Inactive
558: /*
559: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
560: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
561: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
562: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
563: */

Line 560: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2

556:
557: -- Make Qualifier for the coupon Inactive
558: /*
559: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
560: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
561: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
562: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
563: */
564:

Line 561: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3

557: -- Make Qualifier for the coupon Inactive
558: /*
559: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
560: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
561: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
562: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
563: */
564:
565: -- Bug 9210291 - Replacing query to improve performance.

Line 562: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4

558: /*
559: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
560: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
561: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
562: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
563: */
564:
565: -- Bug 9210291 - Replacing query to improve performance.
566: /*

Line 567: UPDATE qp_qualifiers

563: */
564:
565: -- Bug 9210291 - Replacing query to improve performance.
566: /*
567: UPDATE qp_qualifiers
568: SET end_date_active = NULL
569: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
570: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
571: AND nvl(comparison_operator_code,'=') = '='

Line 575: UPDATE /+ INDEX(qpq QP_QUALIFIERS_N4) / qp_qualifiers qpq

571: AND nvl(comparison_operator_code,'=') = '='
572: AND qualifier_attr_Value=p_Coupon_ID;
573: */
574:
575: UPDATE /*+ INDEX(qpq QP_QUALIFIERS_N4) */ qp_qualifiers qpq
576: SET qpq.end_date_active = NULL
577: WHERE qpq.qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
578: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
579: AND nvl(qpq.comparison_operator_code,'=') = '='

Line 614: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1

610: END IF;
611:
612: -- Make Qualifier for the coupon Inactive
613: /*
614: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
615: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
616: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
617: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
618: */

Line 615: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2

611:
612: -- Make Qualifier for the coupon Inactive
613: /*
614: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
615: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
616: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
617: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
618: */
619:

Line 616: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3

612: -- Make Qualifier for the coupon Inactive
613: /*
614: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
615: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
616: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
617: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
618: */
619:
620: /*

Line 617: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4

613: /*
614: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
615: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
616: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
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

Line 626: UPDATE qp_qualifiers

622: */
623:
624: -- Bug 9210291 - Replacing query to improve performance.
625: /*
626: UPDATE qp_qualifiers
627: SET end_date_active = NULL
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,'=') = '='

Line 635: UPDATE /+ INDEX(qpq QP_QUALIFIERS_N4) / qp_qualifiers qpq

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
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,'=') = '='

Line 710: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1

706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: -- Delete Qualifier for the coupon
709: /*
710: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
711: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
712: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
713: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
714: */

Line 711: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2

707:
708: -- Delete Qualifier for the coupon
709: /*
710: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
711: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
712: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
713: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
714: */
715:

Line 712: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3

708: -- Delete Qualifier for the coupon
709: /*
710: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
711: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
712: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
713: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
714: */
715:
716: /*

Line 713: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4

709: /*
710: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
711: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
712: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
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

Line 719: DELETE FROM qp_qualifiers

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
722: AND nvl(comparison_operator_code,'=') = '='
723: AND qualifier_attr_Value in

Line 1054: qp_qualifiers qpq,

1050: qpl.pricing_effective_date
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