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_COUPON_PVT

Line 1: PACKAGE BODY QP_COUPON_PVT AS

1: PACKAGE BODY QP_COUPON_PVT AS
2: /* $Header: QPXVCPNB.pls 120.4.12010000.2 2009/12/24 08:20:08 dnema ship $ */
3:
4: -- Global constant holding the package name
5:

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 36: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_list_hdr_dtls_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1

32: where list_header_id=p_header_id
33: and list_line_id= -1;
34:
35: /*
36: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_list_hdr_dtls_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
37: */
38: CURSOR l_list_hdr_dtls_cur(p_header_id NUMBER) IS
39: select active_flag
40: , list_type_code

Line 64: x_return_text := 'QP_COUPON_PVT.GET_DENORMALIZED_COLS SUCCESS';

60: FETCH l_list_hdr_dtls_cur INTO x_active_flag, x_list_type_code;
61: CLOSE l_list_hdr_dtls_cur;
62:
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: x_return_text := 'QP_COUPON_PVT.GET_DENORMALIZED_COLS SUCCESS';
65:
66:
67: EXCEPTION
68: When OTHERS THEN

Line 70: x_return_text := 'QP_COUPON_PVT.GET_DENORMALIZED_COLS: '||SQLERRM;

66:
67: EXCEPTION
68: When OTHERS THEN
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: x_return_text := 'QP_COUPON_PVT.GET_DENORMALIZED_COLS: '||SQLERRM;
71:
72:
73: END Get_denormalized_qual_cols;
74:

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 105: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd1,QP_LIST_LINES_PK,LIST_LINE_ID,1

101:
102: IF l_line_qual_exists <> 'Y' THEN
103:
104: /*
105: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd1,QP_LIST_LINES_PK,LIST_LINE_ID,1
106: */
107: update qp_list_lines qpl set
108: qpl.qualification_ind =
109: nvl(qpl.qualification_ind,0)+8

Line 114: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd2,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1

110: where qpl.list_line_id=p_list_line_id
111: returning qpl.qualification_ind into l_qual_ind;
112:
113: /*
114: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd2,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
115: */
116: update qp_pricing_attributes pra
117: set pra.qualification_ind = l_qual_ind
118: where pra.list_line_id = p_list_line_id;

Line 125: x_return_text := 'QP_COUPON_PVT.update_qual_ind : '||SQLERRM;

121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: x_return_text := 'QP_COUPON_PVT.update_qual_ind : '||SQLERRM;
126:
127: END update_qual_ind;
128:
129: -----------------------------------------------------------------------

Line 159: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Insertr_Coupon ...');

155: l_debug :=QP_PREQ_GRP.G_DEBUG_ENGINE;
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: IF l_debug = FND_API.G_TRUE THEN
159: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Insertr_Coupon ...');
160: QP_PREQ_GRP.engine_debug ('p_issued_by_modifier_id: '||p_issued_by_modifier_id);
161: END IF; -- END IF l_debug
162:
163: --DBMS_OUTPUT.PUT_LINE('Inside insert_coupon');

Line 183: QP_COUPON_PVT.Set_Expiration_Dates(

179: END IF;
180: */
181:
182: --DBMS_OUTPUT.PUT_LINE('before set expiration dates');
183: QP_COUPON_PVT.Set_Expiration_Dates(
184: l_expiration_period_start_date
185: , l_expiration_period_end_date
186: , p_number_expiration_periods
187: , p_expiration_period_uom_code

Line 261: x_return_status_txt := 'QP_COUPON_PVT.Insert_Coupon: '||SQLERRM;

257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258:
259: WHEN OTHERS THEN
260:
261: x_return_status_txt := 'QP_COUPON_PVT.Insert_Coupon: '||SQLERRM;
262:
263: x_return_status := FND_API.G_RET_STS_ERROR;
264:
265: END Insert_Coupon;

Line 293: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Create_Coupon_Qualifier ...');

289: l_debug :=QP_PREQ_GRP.G_DEBUG_ENGINE;
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: IF l_debug = FND_API.G_TRUE THEN
293: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Create_Coupon_Qualifier ...');
294: QP_PREQ_GRP.engine_debug ('p_list_line_id: '||p_list_line_id);
295: QP_PREQ_GRP.engine_debug ('p_coupon_id: '||p_coupon_id);
296: END IF; -- END IF l_debug
297:

Line 301: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1

297:
298:
299: BEGIN
300: /*
301: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1
302: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,RLTD_MODIFIER_GRP_TYPE,2
303:
304: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_LIST_LINES_PK,LIST_LINE_ID,1
305: */

Line 302: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,RLTD_MODIFIER_GRP_TYPE,2

298:
299: BEGIN
300: /*
301: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1
302: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,RLTD_MODIFIER_GRP_TYPE,2
303:
304: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_LIST_LINES_PK,LIST_LINE_ID,1
305: */
306: SELECT m.to_rltd_modifier_id list_line_id,

Line 304: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_LIST_LINES_PK,LIST_LINE_ID,1

300: /*
301: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1
302: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,RLTD_MODIFIER_GRP_TYPE,2
303:
304: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_LIST_LINES_PK,LIST_LINE_ID,1
305: */
306: SELECT m.to_rltd_modifier_id list_line_id,
307: l.list_header_id,
308: l.qualification_ind

Line 313: AND m.rltd_modifier_grp_type = QP_COUPON_PVT.G_COUPON_GRP_TYPE;

309: INTO l_list_line_id, l_list_header_id,l_qualification_ind
310: FROM qp_rltd_modifiers m, qp_list_lines l
311: WHERE from_rltd_modifier_id = p_list_line_id
312: AND m.to_rltd_modifier_id = l.list_line_id
313: AND m.rltd_modifier_grp_type = QP_COUPON_PVT.G_COUPON_GRP_TYPE;
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: RAISE QP_COUPON_MODIFIER_NOT_FOUND;
317: END;

Line 386: QP_COUPON_PVT.G_COUPON_QUALIFIER,

382: l_list_header_id,
383: l_list_line_id,
384: '=',
385: QP_PREQ_GRP.G_LIST_HEADER_CONTEXT,
386: QP_COUPON_PVT.G_COUPON_QUALIFIER,
387: to_char(p_coupon_id),
388: NULL,
389: qp_qualifier_group_no_s.nextval,
390: 'N',

Line 435: x_return_status_txt := 'QP_COUPON_PVT.Create_Coupon_Qualifier: '||l_return_text;

431:
432: EXCEPTION
433:
434: WHEN COUP_DENORMALIZED_COL_EXP THEN
435: x_return_status_txt := 'QP_COUPON_PVT.Create_Coupon_Qualifier: '||l_return_text;
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: WHEN QP_COUPON_MODIFIER_NOT_FOUND THEN

Line 450: x_return_status_txt := 'QP_COUPON_PVT.Create_Coupon_Qualifier: '||SQLERRM;

446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
448: WHEN OTHERS THEN
449:
450: x_return_status_txt := 'QP_COUPON_PVT.Create_Coupon_Qualifier: '||SQLERRM;
451:
452: x_return_status := FND_API.G_RET_STS_ERROR;
453:
454: END Create_Coupon_Qualifier;

Line 470: INDX,QP_COUPON_PVT.Mark_Coupon_Redeemed.Mark_Coupon_Redeemed_upd1,-No Index Used-,NA,NA

466:
467: --dbms_output.put_line('passed in coupon number '||p_coupon_number);
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;

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 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 496: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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,'=') = '='
498: AND qualifier_attr_Value in
499: (select coupon_id from qp_coupons where coupon_number=p_Coupon_number);*/
500:

Line 504: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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,'=') = '='
506: AND qpq.qualifier_attr_Value in
507: (select TO_CHAR(coupon_id) from qp_coupons where coupon_number=p_Coupon_number);
508:

Line 531: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Redeemed: '||SQLERRM;

527: x_return_status := FND_API.G_RET_STS_ERROR;
528:
529: WHEN OTHERS THEN
530:
531: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Redeemed: '||SQLERRM;
532:
533: x_return_status := FND_API.G_RET_STS_ERROR;
534:
535: END Mark_Coupon_Redeemed;

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 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 570: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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,'=') = '='
572: AND qualifier_attr_Value=p_Coupon_ID;
573: */
574:

Line 578: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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,'=') = '='
580: AND qpq.qualifier_attr_Value=TO_CHAR(p_Coupon_ID);
581:
582: EXCEPTION

Line 586: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Unredeemed: '||SQLERRM;

582: EXCEPTION
583:
584: WHEN OTHERS THEN
585:
586: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Unredeemed: '||SQLERRM;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588:
589: End Mark_Coupon_Unredeemed;
590:

Line 602: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd1,-No Index Used-,NA,NA

598:
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

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 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 629: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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,'=') = '='
631: AND qualifier_attr_Value in
632: (select coupon_id from qp_coupons where coupon_number=p_Coupon_Number);
633: */

Line 638: AND qpq.qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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,'=') = '='
640: AND qpq.qualifier_attr_Value in
641: (select TO_CHAR(coupon_id) from qp_coupons where coupon_number=p_Coupon_Number);
642:

Line 665: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Unredeemed: '||SQLERRM;

661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: WHEN OTHERS THEN
664:
665: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Unredeemed: '||SQLERRM;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: END Mark_Coupon_Unredeemed;
669:

Line 681: INDX,QP_COUPON_PVT.Purge_Coupon.Purge_Coupon_del1,-No Index Used-,NA,NA

677:
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 691: x_return_status_txt := 'QP_COUPON_PVT.Purge_Coupon: '||SQLERRM;

687: EXCEPTION
688:
689: WHEN OTHERS THEN
690:
691: x_return_status_txt := 'QP_COUPON_PVT.Purge_Coupon: '||SQLERRM;
692:
693: x_return_status := FND_API.G_RET_STS_ERROR;
694:
695: END Purge_Coupon;

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 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 721: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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
724: (select coupon_id from qp_coupons where coupon_number=p_coupon_number);
725:

Line 731: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del2,-No Index Used-,NA,NA

727: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
728: END IF;
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:

Line 758: x_return_status_txt := 'QP_COUPON_PVT.Delete_Coupon '||SQLERRM;

754: x_return_status := FND_API.G_RET_STS_ERROR;
755:
756: WHEN OTHERS THEN
757:
758: x_return_status_txt := 'QP_COUPON_PVT.Delete_Coupon '||SQLERRM;
759:
760: x_return_status := FND_API.G_RET_STS_ERROR;
761:
762: END Delete_Coupon;

Line 775: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1

771: ) IS
772:
773: -- Get coupon issue line
774: /*
775: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
776:
777: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
778: */
779: CURSOR get_coupon_issue_lines IS

Line 777: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1

773: -- Get coupon issue line
774: /*
775: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
776:
777: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
778: */
779: CURSOR get_coupon_issue_lines IS
780: SELECT /*+ ORDERED USE_NL(b c) */
781: a.line_index,

Line 814: = QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE

810: WHERE a.LINE_INDEX = b.LINE_INDEX
811: AND b.LINE_DETAIL_INDEX = p_line_detail_index
812: AND b.CREATED_FROM_LIST_LINE_ID = c.LIST_LINE_ID
813: AND b.CREATED_FROM_LIST_LINE_TYPE
814: = QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE
815: AND b.PRICING_PHASE_ID = p_pricing_phase_id
816: AND b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
817:
818: l_number_of_coupons NUMBER := 1;

Line 828: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Process_Coupon_Issue...');

824: l_debug :=QP_PREQ_GRP.G_DEBUG_ENGINE;
825: x_return_status := FND_API.G_RET_STS_SUCCESS;
826:
827: IF l_debug = FND_API.G_TRUE THEN
828: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Process_Coupon_Issue...');
829: QP_PREQ_GRP.engine_debug ('p_line_quantity: '||p_line_quantity);
830: END IF; -- END IF l_debug
831:
832: FOR i IN get_coupon_issue_lines

Line 917: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1

913: IF (J = 1) THEN
914:
915: --DBMS_OUTPUT.PUT_LINE('Update Coupon No'||l_coupon_number);
916: /*
917: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
918: */
919: UPDATE qp_npreq_ldets_tmp
920: SET PROCESSED_FLAG = 'Y',
921: LIST_LINE_NO = l_coupon_number,

Line 1004: x_return_status_txt := 'QP_COUPON_PVT.Process_Coupon_Issue: '||SQLERRM;

1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001:
1002: WHEN OTHERS THEN
1003:
1004: x_return_status_txt := 'QP_COUPON_PVT.Process_Coupon_Issue: '||SQLERRM;
1005:
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007:
1008: END Process_Coupon_Issue;

Line 1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1

1014: )
1015: IS
1016:
1017: /*
1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
1019:
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

Line 1020: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,LINE_INDEX,1

1016:
1017: /*
1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
1019:
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

Line 1021: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,ATTRIBUTE_TYPE,2

1017: /*
1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
1019:
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:

Line 1022: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3

1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
1019:
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

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 1026: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_lines_tmp_U1,LINE_INDEX,1

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
1029: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
1030: qpl.pricing_effective_date

Line 1040: and qplat.attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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
1039: and qplat.context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
1040: and qplat.attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
1041: and nvl(qplat.comparison_operator_type_code,'=') = '='
1042: and qplat.attribute_level = QP_PREQ_GRP.G_LINE_LEVEL
1043: and qpd.created_from_list_line_type <> QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE
1044: and qpd.APPLIED_FLAG = QP_PREQ_GRP.G_YES

Line 1043: and qpd.created_from_list_line_type <> QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE

1039: and qplat.context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
1040: and qplat.attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
1041: and nvl(qplat.comparison_operator_type_code,'=') = '='
1042: and qplat.attribute_level = QP_PREQ_GRP.G_LINE_LEVEL
1043: and qpd.created_from_list_line_type <> QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE
1044: and qpd.APPLIED_FLAG = QP_PREQ_GRP.G_YES
1045: and qpd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1046: and qpc.coupon_id = to_number(qplat.value_from);
1047:

Line 1060: and qplat.attribute = QP_COUPON_PVT.G_COUPON_QUALIFIER

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
1060: and qplat.attribute = QP_COUPON_PVT.G_COUPON_QUALIFIER
1061: and nvl(qplat.comparison_operator_type_code,'=') = '='
1062: and qpq.qualifier_context = qplat.context
1063: and qpq.qualifier_attribute = qplat.attribute
1064: and qpq.QUALIFIER_ATTR_VALUE = qplat.value_from

Line 1079: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Redeem_Coupons');

1075: l_debug :=QP_PREQ_GRP.G_DEBUG_ENGINE;
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077:
1078: IF l_debug = FND_API.G_TRUE THEN
1079: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Redeem_Coupons');
1080: END IF;
1081:
1082: --dbms_output.put_line('inside redeem coupon');
1083: IF (p_simulation_flag = 'N') THEN

Line 1146: x_return_status_txt := 'QP_COUPON_PVT.Redeem_Coupons: '||SQLERRM;

1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143:
1144: WHEN OTHERS THEN
1145:
1146: x_return_status_txt := 'QP_COUPON_PVT.Redeem_Coupons: '||SQLERRM;
1147:
1148: x_return_status := FND_API.G_RET_STS_ERROR;
1149:
1150: END Redeem_Coupons;

Line 1197: x_return_status_txt := 'QP_COUPON_PVT.Set_Expiration_Dates: '||SQLERRM;

1193: EXCEPTION
1194:
1195: WHEN OTHERS THEN
1196:
1197: x_return_status_txt := 'QP_COUPON_PVT.Set_Expiration_Dates: '||SQLERRM;
1198:
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200:
1201: END Set_Expiration_Dates;

Line 1203: END QP_COUPON_PVT;

1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200:
1201: END Set_Expiration_Dates;
1202:
1203: END QP_COUPON_PVT;