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.

[Home] [Help]

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.3.12000000.2 2007/04/28 14:11:35 dhgupta 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: UPDATE qp_qualifiers
492: SET end_date_active = p_pricing_effective_date
493: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT

Line 494: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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
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:

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

517: x_return_status := FND_API.G_RET_STS_ERROR;
518:
519: WHEN OTHERS THEN
520:
521: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Redeemed: '||SQLERRM;
522:
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: END Mark_Coupon_Redeemed;

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 549: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1

545: WHERE coupon_id = p_coupon_id;
546:
547: -- Make Qualifier for the coupon Inactive
548: /*
549: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
550: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
552: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
553: */

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

546:
547: -- Make Qualifier for the coupon Inactive
548: /*
549: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
550: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
552: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
553: */
554: UPDATE qp_qualifiers

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

547: -- Make Qualifier for the coupon Inactive
548: /*
549: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
550: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
552: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
553: */
554: UPDATE qp_qualifiers
555: SET end_date_active = NULL

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

548: /*
549: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
550: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
551: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
552: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
553: */
554: UPDATE qp_qualifiers
555: SET end_date_active = NULL
556: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT

Line 557: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

553: */
554: UPDATE qp_qualifiers
555: SET end_date_active = NULL
556: WHERE qualifier_context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
557: AND qualifier_attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
558: AND nvl(comparison_operator_code,'=') = '='
559: AND qualifier_attr_Value=p_Coupon_ID;
560:
561: EXCEPTION

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

561: EXCEPTION
562:
563: WHEN OTHERS THEN
564:
565: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Unredeemed: '||SQLERRM;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: End Mark_Coupon_Unredeemed;
569:

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

577:
578: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

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

589: END IF;
590:
591: -- Make Qualifier for the coupon Inactive
592: /*
593: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
594: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
595: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
596: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
597: */

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

590:
591: -- Make Qualifier for the coupon Inactive
592: /*
593: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
594: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
595: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
596: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
597: */
598:

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

591: -- Make Qualifier for the coupon Inactive
592: /*
593: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
594: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
595: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
596: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
597: */
598:
599: /*

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

592: /*
593: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
594: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
595: INDX,QP_COUPON_PVT.Mark_Coupon_Unredeemed.Mark_Coupon_Unredeemed_upd2,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
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

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

601: */
602: UPDATE qp_qualifiers
603: SET end_date_active = NULL
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:

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

628: x_return_status := FND_API.G_RET_STS_ERROR;
629:
630: WHEN OTHERS THEN
631:
632: x_return_status_txt := 'QP_COUPON_PVT.Mark_Coupon_Unredeemed: '||SQLERRM;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634:
635: END Mark_Coupon_Unredeemed;
636:

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

644:
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

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

654: EXCEPTION
655:
656: WHEN OTHERS THEN
657:
658: x_return_status_txt := 'QP_COUPON_PVT.Purge_Coupon: '||SQLERRM;
659:
660: x_return_status := FND_API.G_RET_STS_ERROR;
661:
662: END Purge_Coupon;

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

673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: -- Delete Qualifier for the coupon
676: /*
677: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
678: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
679: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
680: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
681: */

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

674:
675: -- Delete Qualifier for the coupon
676: /*
677: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
678: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
679: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
680: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
681: */
682:

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

675: -- Delete Qualifier for the coupon
676: /*
677: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
678: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
679: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
680: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
681: */
682:
683: /*

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

676: /*
677: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_CONTEXT,1
678: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTRIBUTE,2
679: INDX,QP_COUPON_PVT.Delete_Coupon.Delete_Coupon_del1,QP_QUALIFIERS_N4,QUALIFIER_ATTR_VALUE,3
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

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

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
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:

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

694: RAISE QP_COUPON_QUALIFIER_NOT_FOUND;
695: END IF;
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:

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

721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
723: WHEN OTHERS THEN
724:
725: x_return_status_txt := 'QP_COUPON_PVT.Delete_Coupon '||SQLERRM;
726:
727: x_return_status := FND_API.G_RET_STS_ERROR;
728:
729: END Delete_Coupon;

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

738: ) IS
739:
740: -- Get coupon issue line
741: /*
742: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
743:
744: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
745: */
746: CURSOR get_coupon_issue_lines IS

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

740: -- Get coupon issue line
741: /*
742: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
743:
744: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
745: */
746: CURSOR get_coupon_issue_lines IS
747: SELECT /*+ ORDERED USE_NL(b c) */
748: a.line_index,

Line 781: = QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE

777: WHERE a.LINE_INDEX = b.LINE_INDEX
778: AND b.LINE_DETAIL_INDEX = p_line_detail_index
779: AND b.CREATED_FROM_LIST_LINE_ID = c.LIST_LINE_ID
780: AND b.CREATED_FROM_LIST_LINE_TYPE
781: = QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE
782: AND b.PRICING_PHASE_ID = p_pricing_phase_id
783: AND b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
784:
785: l_number_of_coupons NUMBER := 1;

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

791: l_debug :=QP_PREQ_GRP.G_DEBUG_ENGINE;
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: IF l_debug = FND_API.G_TRUE THEN
795: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Process_Coupon_Issue...');
796: QP_PREQ_GRP.engine_debug ('p_line_quantity: '||p_line_quantity);
797: END IF; -- END IF l_debug
798:
799: FOR i IN get_coupon_issue_lines

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

880: IF (J = 1) THEN
881:
882: --DBMS_OUTPUT.PUT_LINE('Update Coupon No'||l_coupon_number);
883: /*
884: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
885: */
886: UPDATE qp_npreq_ldets_tmp
887: SET PROCESSED_FLAG = 'Y',
888: LIST_LINE_NO = l_coupon_number,

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

967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968:
969: WHEN OTHERS THEN
970:
971: x_return_status_txt := 'QP_COUPON_PVT.Process_Coupon_Issue: '||SQLERRM;
972:
973: x_return_status := FND_API.G_RET_STS_ERROR;
974:
975: END Process_Coupon_Issue;

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

981: )
982: IS
983:
984: /*
985: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
986:
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

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

983:
984: /*
985: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
986:
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

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

984: /*
985: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
986:
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:

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

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

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

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

Line 1007: and qplat.attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER

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
1006: and qplat.context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
1007: and qplat.attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
1008: and nvl(qplat.comparison_operator_type_code,'=') = '='
1009: and qplat.attribute_level = QP_PREQ_GRP.G_LINE_LEVEL
1010: and qpd.created_from_list_line_type <> QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE
1011: and qpd.APPLIED_FLAG = QP_PREQ_GRP.G_YES

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

1006: and qplat.context= QP_PREQ_GRP.G_LIST_HEADER_CONTEXT
1007: and qplat.attribute=QP_COUPON_PVT.G_COUPON_QUALIFIER
1008: and nvl(qplat.comparison_operator_type_code,'=') = '='
1009: and qplat.attribute_level = QP_PREQ_GRP.G_LINE_LEVEL
1010: and qpd.created_from_list_line_type <> QP_COUPON_PVT.G_COUPON_ISSUE_LINE_TYPE
1011: and qpd.APPLIED_FLAG = QP_PREQ_GRP.G_YES
1012: and qpd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1013: and qpc.coupon_id = to_number(qplat.value_from);
1014:

Line 1027: and qplat.attribute = QP_COUPON_PVT.G_COUPON_QUALIFIER

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
1027: and qplat.attribute = QP_COUPON_PVT.G_COUPON_QUALIFIER
1028: and nvl(qplat.comparison_operator_type_code,'=') = '='
1029: and qpq.qualifier_context = qplat.context
1030: and qpq.qualifier_attribute = qplat.attribute
1031: and qpq.QUALIFIER_ATTR_VALUE = qplat.value_from

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

1042: l_debug :=QP_PREQ_GRP.G_DEBUG_ENGINE;
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044:
1045: IF l_debug = FND_API.G_TRUE THEN
1046: QP_PREQ_GRP.engine_debug ('Entering QP_COUPON_PVT.Redeem_Coupons');
1047: END IF;
1048:
1049: --dbms_output.put_line('inside redeem coupon');
1050: IF (p_simulation_flag = 'N') THEN

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

1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1110:
1111: WHEN OTHERS THEN
1112:
1113: x_return_status_txt := 'QP_COUPON_PVT.Redeem_Coupons: '||SQLERRM;
1114:
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116:
1117: END Redeem_Coupons;

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

1160: EXCEPTION
1161:
1162: WHEN OTHERS THEN
1163:
1164: x_return_status_txt := 'QP_COUPON_PVT.Set_Expiration_Dates: '||SQLERRM;
1165:
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167:
1168: END Set_Expiration_Dates;

Line 1170: END QP_COUPON_PVT;

1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167:
1168: END Set_Expiration_Dates;
1169:
1170: END QP_COUPON_PVT;