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_LIMIT_TRANSACTIONS_PVT dependencies on QP_PREQ_GRP

Line 67: AND l.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW))

63: WHERE l.created_from_list_header_id = t.list_header_id
64: AND l.created_from_list_line_id = t.list_line_id
65: AND l.pricing_phase_id = t.pricing_phase_id
66: AND l.line_index = b.line_index
67: AND l.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW))
68: OR (t.price_request_code = ( SELECT 'ASO-'|| asm.quote_header_id || '-' || asm.quote_line_id
69: FROM oe_order_lines_all oel, aso_shipments asm
70: WHERE oel.line_id = b.line_id
71: AND asm.order_line_id = oel.line_id

Line 75: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

71: AND asm.order_line_id = oel.line_id
72: ))); --bug#10130826;
73:
74: BEGIN
75: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
76: IF l_debug = FND_API.G_TRUE THEN
77: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
78: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
79:

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

73:
74: BEGIN
75: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
76: IF l_debug = FND_API.G_TRUE THEN
77: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
78: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
79:
80: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
81: from qp_npreq_lines_tmp line, qp_limit_transactions trx

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

74: BEGIN
75: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
76: IF l_debug = FND_API.G_TRUE THEN
77: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
78: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
79:
80: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
81: from qp_npreq_lines_tmp line, qp_limit_transactions trx
82: where trx.price_request_code = line.price_request_code)

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

80: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
81: from qp_npreq_lines_tmp line, qp_limit_transactions trx
82: where trx.price_request_code = line.price_request_code)
83: LOOP
84: QP_PREQ_GRP.engine_debug('Limit transactions for current lines '||cl.line_index||' price_reqCode '||cl.price_request_code||' listhdrid '||cl.list_header_id);
85: for cl1 in (select ldet.created_from_list_header_id, ldet.pricing_status_code
86: from qp_npreq_ldets_tmp ldet
87: where ldet.created_from_list_header_id = cl.list_header_id
88: and ldet.line_index = cl.line_index

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

89: and ldet.pricing_phase_id in (select pricing_phase_id
90: from qp_event_phases evt
91: where instr(p_pricing_event_code, evt.pricing_event_code || ',') > 0))
92: LOOP
93: QP_PREQ_GRP.engine_debug('adjustments for above transactions '||cl1.created_from_list_header_id||' status '||cl1.pricing_status_code);
94: END LOOP;
95: END LOOP;
96:
97: END IF;

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

99:
100: FOR l_rec IN limit_trans_cur(p_pricing_event_code)
101: LOOP
102: IF l_debug = FND_API.G_TRUE THEN
103: QP_PREQ_GRP.engine_debug('***Deleting LimitbalanceId: '||l_rec.limit_balance_id||' pricereqcode '||l_rec.price_request_code);
104: END IF;
105:
106: --For each transaction record selected in the cursor increment the
107: --corresponding limit balance by the transaction amount

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

123:
124: END LOOP; --Loop over records in limit_trans_cur
125:
126: IF l_debug = FND_API.G_TRUE THEN
127: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');
128:
129: END IF;
130: EXCEPTION
131: WHEN FND_API.G_EXC_ERROR THEN