APPS.QP_LIMIT_TRANSACTIONS_PVT dependencies on QP_PREQ_GRP

Line 65: AND l.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW);

61: WHERE l.created_from_list_header_id = t.list_header_id
62: AND l.created_from_list_line_id = t.list_line_id
63: AND l.pricing_phase_id = t.pricing_phase_id
64: AND l.line_index = b.line_index
65: AND l.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW);
66:
67: BEGIN
68: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
69: IF l_debug = FND_API.G_TRUE THEN

Line 68: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

64: AND l.line_index = b.line_index
65: AND l.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW);
66:
67: BEGIN
68: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
69: IF l_debug = FND_API.G_TRUE THEN
70: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
71: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
72:

Line 70: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');

66:
67: BEGIN
68: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
69: IF l_debug = FND_API.G_TRUE THEN
70: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
71: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
72:
73: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
74: from qp_npreq_lines_tmp line, qp_limit_transactions trx

Line 71: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);

67: BEGIN
68: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
69: IF l_debug = FND_API.G_TRUE THEN
70: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
71: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
72:
73: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
74: from qp_npreq_lines_tmp line, qp_limit_transactions trx
75: where trx.price_request_code = line.price_request_code)

Line 77: QP_PREQ_GRP.engine_debug('Limit transactions for current lines '||cl.line_index||' price_reqCode '||cl.price_request_code||' listhdrid '||cl.list_header_id);

73: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
74: from qp_npreq_lines_tmp line, qp_limit_transactions trx
75: where trx.price_request_code = line.price_request_code)
76: LOOP
77: QP_PREQ_GRP.engine_debug('Limit transactions for current lines '||cl.line_index||' price_reqCode '||cl.price_request_code||' listhdrid '||cl.list_header_id);
78: for cl1 in (select ldet.created_from_list_header_id, ldet.pricing_status_code
79: from qp_npreq_ldets_tmp ldet
80: where ldet.created_from_list_header_id = cl.list_header_id
81: and ldet.line_index = cl.line_index

Line 86: QP_PREQ_GRP.engine_debug('adjustments for above transactions '||cl1.created_from_list_header_id||' status '||cl1.pricing_status_code);

82: and ldet.pricing_phase_id in (select pricing_phase_id
83: from qp_event_phases evt
84: where instr(p_pricing_event_code, evt.pricing_event_code || ',') > 0))
85: LOOP
86: QP_PREQ_GRP.engine_debug('adjustments for above transactions '||cl1.created_from_list_header_id||' status '||cl1.pricing_status_code);
87: END LOOP;
88: END LOOP;
89:
90: END IF;

Line 96: QP_PREQ_GRP.engine_debug('***Deleting LimitbalanceId: '||l_rec.limit_balance_id||' pricereqcode '||l_rec.price_request_code);

92:
93: FOR l_rec IN limit_trans_cur(p_pricing_event_code)
94: LOOP
95: IF l_debug = FND_API.G_TRUE THEN
96: QP_PREQ_GRP.engine_debug('***Deleting LimitbalanceId: '||l_rec.limit_balance_id||' pricereqcode '||l_rec.price_request_code);
97: END IF;
98:
99: --For each transaction record selected in the cursor increment the
100: --corresponding limit balance by the transaction amount

Line 120: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');

116:
117: END LOOP; --Loop over records in limit_trans_cur
118:
119: IF l_debug = FND_API.G_TRUE THEN
120: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');
121:
122: END IF;
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN