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.OE_ADV_PRICE_PVT dependencies on OE_ORDER_CACHE

Line 275: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id

271: --amy: revert to original item if the IUE is deleted
272: Cursor revert_back_items IS
273: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id
274: FROM OE_PRICE_ADJUSTMENTS adj
275: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id
276: AND list_line_Type_code = 'IUE'
277: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
278: where instr(p_pricing_events||',', pricing_event_code||',') >0)
279: AND LINE_ID IN (select line_id

Line 287: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and line_index=adj.line_id+oe_order_cache.g_header_rec.header_id)*/

283: and process_status <> 'NOT_VALID'
284: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
285: /* AND list_line_id NOT IN (SELECT list_line_id
286: from qp_ldets_v where process_code
287: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and line_index=adj.line_id+oe_order_cache.g_header_rec.header_id)*/
288: AND list_line_id NOT IN (SELECT list_line_id
289: from qp_ldets_v ld, qp_preq_lines_tmp l
290: where ld.process_code
291: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index

Line 297: l_header_id number := oe_order_cache.g_header_rec.header_id;

293:
294:
295:
296: i number;
297: l_header_id number := oe_order_cache.g_header_rec.header_id;
298:
299: --
300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
301: --

Line 305: IF oe_order_cache.g_header_rec.booked_flag = 'Y' THEN

301: --
302: BEGIN
303:
304:
305: IF oe_order_cache.g_header_rec.booked_flag = 'Y' THEN
306: RETURN;
307: END IF;
308:
309: -- AmyIUE: let's revert back the following way

Line 611: l_header_id number := oe_order_cache.g_header_rec.header_id;

607: AND ldets.Line_index = lines.Line_index
608: order by ldets.line_index ASC;
609:
610: i number;
611: l_header_id number := oe_order_cache.g_header_rec.header_id;
612: j number;
613: k number;
614: l number;
615: vcount number;

Line 617: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;

613: k number;
614: l number;
615: vcount number;
616: m number;
617: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;
618: --bug 4190357
619: l_count NUMBER;
620: --bug 4190357
621: l_old_shipping_method_code Varchar2(30); --bug 4190357

Line 1413: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;

1409: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN
1410: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
1411: l_line_rec.cancelled_quantity := 0;
1412: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1413: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;
1414: l_line_rec.line_id := OE_DEFAULT_LINE.get_line;
1415: --for Bug 3350425. To Prevent Blanket feilds being defaulting from Header.
1416: l_line_rec.blanket_number:=NULL;
1417: l_line_rec.blanket_line_number:=NULL;

Line 1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;

1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
1633: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
1634: AND ldets.line_index = lines.line_index;
1635: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
1637:
1638: l_TRANSACTION_PHASE_CODE varchar2(30) := oe_order_cache.g_header_rec.TRANSACTION_PHASE_CODE;
1639:
1640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1638: l_TRANSACTION_PHASE_CODE varchar2(30) := oe_order_cache.g_header_rec.TRANSACTION_PHASE_CODE;

1634: AND ldets.line_index = lines.line_index;
1635: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
1637:
1638: l_TRANSACTION_PHASE_CODE varchar2(30) := oe_order_cache.g_header_rec.TRANSACTION_PHASE_CODE;
1639:
1640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1641:
1642: l_order_source_id NUMBER;

Line 1707: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref

1703: ( p_entity_code => 'HEADER'
1704: ,p_entity_id => l_header_id
1705: ,p_header_id =>l_header_id
1706: ,p_line_id => NULL
1707: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref
1708: ,p_orig_sys_document_line_ref => NULL
1709: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
1710: ,p_source_document_line_id => NULL
1711: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence

Line 1709: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id

1705: ,p_header_id =>l_header_id
1706: ,p_line_id => NULL
1707: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref
1708: ,p_orig_sys_document_line_ref => NULL
1709: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
1710: ,p_source_document_line_id => NULL
1711: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
1712: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
1713: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);

Line 1711: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence

1707: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref
1708: ,p_orig_sys_document_line_ref => NULL
1709: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
1710: ,p_source_document_line_id => NULL
1711: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
1712: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
1713: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);
1714: ELSE
1715: l_line_id := i.line_id;

Line 1712: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id

1708: ,p_orig_sys_document_line_ref => NULL
1709: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
1710: ,p_source_document_line_id => NULL
1711: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
1712: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
1713: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);
1714: ELSE
1715: l_line_id := i.line_id;
1716: IF l_line_id IS NOT NULL AND l_line_id <> 0 AND

Line 1713: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);

1709: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
1710: ,p_source_document_line_id => NULL
1711: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
1712: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
1713: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);
1714: ELSE
1715: l_line_id := i.line_id;
1716: IF l_line_id IS NOT NULL AND l_line_id <> 0 AND
1717: l_line_id <> FND_API.G_MISS_NUM THEN

Line 1755: oe_order_cache.g_header_rec.orig_sys_document_ref)

1751: ,p_entity_id => i.line_id
1752: ,p_header_id =>l_header_id
1753: ,p_line_id => i.line_id
1754: ,p_orig_sys_document_ref => nvl(l_orig_sys_document_ref,
1755: oe_order_cache.g_header_rec.orig_sys_document_ref)
1756: ,p_orig_sys_document_line_ref => l_orig_sys_line_ref
1757: ,p_orig_sys_shipment_ref => l_orig_sys_shipment_ref
1758: ,p_change_sequence => nvl(l_change_sequence,
1759: oe_order_cache.g_header_rec.change_sequence)

Line 1759: oe_order_cache.g_header_rec.change_sequence)

1755: oe_order_cache.g_header_rec.orig_sys_document_ref)
1756: ,p_orig_sys_document_line_ref => l_orig_sys_line_ref
1757: ,p_orig_sys_shipment_ref => l_orig_sys_shipment_ref
1758: ,p_change_sequence => nvl(l_change_sequence,
1759: oe_order_cache.g_header_rec.change_sequence)
1760: ,p_source_document_id => nvl(l_source_document_id,
1761: oe_order_cache.g_header_rec.source_document_id)
1762: ,p_source_document_line_id => l_source_document_line_id
1763: ,p_order_source_id =>nvl(l_order_source_id,

Line 1761: oe_order_cache.g_header_rec.source_document_id)

1757: ,p_orig_sys_shipment_ref => l_orig_sys_shipment_ref
1758: ,p_change_sequence => nvl(l_change_sequence,
1759: oe_order_cache.g_header_rec.change_sequence)
1760: ,p_source_document_id => nvl(l_source_document_id,
1761: oe_order_cache.g_header_rec.source_document_id)
1762: ,p_source_document_line_id => l_source_document_line_id
1763: ,p_order_source_id =>nvl(l_order_source_id,
1764: oe_order_cache.g_header_rec.order_source_id)
1765: ,p_source_document_type_id => nvl(l_source_document_type_id,

Line 1764: oe_order_cache.g_header_rec.order_source_id)

1760: ,p_source_document_id => nvl(l_source_document_id,
1761: oe_order_cache.g_header_rec.source_document_id)
1762: ,p_source_document_line_id => l_source_document_line_id
1763: ,p_order_source_id =>nvl(l_order_source_id,
1764: oe_order_cache.g_header_rec.order_source_id)
1765: ,p_source_document_type_id => nvl(l_source_document_type_id,
1766: oe_order_cache.g_header_rec.source_document_type_id));
1767: END IF;
1768:

Line 1766: oe_order_cache.g_header_rec.source_document_type_id));

1762: ,p_source_document_line_id => l_source_document_line_id
1763: ,p_order_source_id =>nvl(l_order_source_id,
1764: oe_order_cache.g_header_rec.order_source_id)
1765: ,p_source_document_type_id => nvl(l_source_document_type_id,
1766: oe_order_cache.g_header_rec.source_document_type_id));
1767: END IF;
1768:
1769: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
1770: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);

Line 1788: l_source_document_type_id number := oe_order_cache.g_header_rec.source_document_type_id;

1784:
1785: function check_notify_OC
1786: return boolean
1787: is
1788: l_source_document_type_id number := oe_order_cache.g_header_rec.source_document_type_id;
1789: l_header_id number := oe_order_cache.g_header_rec.header_id;
1790: l_source_system_code number := 0;
1791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1792: begin

Line 1789: l_header_id number := oe_order_cache.g_header_rec.header_id;

1785: function check_notify_OC
1786: return boolean
1787: is
1788: l_source_document_type_id number := oe_order_cache.g_header_rec.source_document_type_id;
1789: l_header_id number := oe_order_cache.g_header_rec.header_id;
1790: l_source_system_code number := 0;
1791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1792: begin
1793:

Line 1831: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

1827:
1828:
1829: procedure new_and_updated_notify is
1830:
1831: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
1832: cursor insert_adj_cur is
1833: select price_adjustment_id, ldets.automatic_flag auto_flag,line_id,
1834: modifier_level_code, ldets.LIST_HEADER_ID list_header_id,
1835: LIST_LINE_ID, LIST_LINE_TYPE_CODE,inventory_item_id,

Line 2131: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

2127:
2128: l_control_rec OE_GLOBALS.Control_Rec_Type;
2129: lx_new_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
2130: l_notify_flag BOOLEAN;
2131: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2132:
2133:
2134: --
2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2191: oe_debug_pub.add('oe_order_cache.g_header_rec.booked_flag = '||oe_order_cache.g_header_rec.booked_flag);

2187: x_return_status);
2188:
2189: IF l_debug_level > 0 THEN
2190: oe_debug_pub.add('l_booked_flag = '||l_booked_flag);
2191: oe_debug_pub.add('oe_order_cache.g_header_rec.booked_flag = '||oe_order_cache.g_header_rec.booked_flag);
2192: END IF;
2193:
2194: END IF; -- <> Calculate_Only
2195:

Line 2202: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

2198: END process_adv_modifiers;
2199:
2200: Procedure Insert_Adj(p_header_id in Number default null)
2201: IS
2202: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2203: --
2204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2205: --
2206: BEGIN