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 321: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id

317: Cursor revert_back_items IS
318: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id
319: ,adj.modifier_level_code --Bug 13573144
320: FROM OE_PRICE_ADJUSTMENTS adj
321: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id
322: AND list_line_Type_code = 'IUE'
323: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
324: where instr(p_pricing_events||',', pricing_event_code||',') >0)
325: AND LINE_ID IN (select line_id

Line 333: 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)*/

329: and process_status <> 'NOT_VALID'
330: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
331: /* AND list_line_id NOT IN (SELECT list_line_id
332: from qp_ldets_v where process_code
333: 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)*/
334: AND list_line_id NOT IN (SELECT list_line_id
335: from qp_ldets_v ld, qp_preq_lines_tmp l
336: where ld.process_code
337: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index

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

339:
340:
341:
342: i number;
343: l_header_id number := oe_order_cache.g_header_rec.header_id;
344: l_mod_line_id NUMBER;
345:
346: --
347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

348: --
349: BEGIN
350:
351:
352: IF oe_order_cache.g_header_rec.booked_flag = 'Y' THEN
353: RETURN;
354: END IF;
355:
356: -- AmyIUE: let's revert back the following way

Line 686: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id

682: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id,
683: adj.SUBSTITUTION_ATTRIBUTE, adj.MODIFIER_LEVEL_CODE,
684: adj.header_id
685: FROM OE_PRICE_ADJUSTMENTS adj
686: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id
687: AND adj.list_line_Type_code = 'TSN'
688: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
689: where instr(p_pricing_events||',', pricing_event_code||',')>0)
690: AND adj.LINE_ID IN (select line_id

Line 707: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id

703: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id,
704: adj.SUBSTITUTION_ATTRIBUTE, adj.MODIFIER_LEVEL_CODE,
705: adj.header_id
706: FROM OE_PRICE_ADJUSTMENTS adj
707: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id
708: AND adj.list_line_Type_code = 'TSN'
709: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
710: where instr(p_pricing_events||',', pricing_event_code||',')>0)
711: AND adj.line_id IS NULL

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

727: where header_id = p_header_id and line_id is null
728: and list_line_type_code = 'TSN';
729: --End of Bug 13573144
730: i number;
731: l_header_id number := oe_order_cache.g_header_rec.header_id;
732: l_mod_line_id NUMBER;
733: j number;
734: k number;
735: l number;

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

735: l number;
736: --vcount number; --Bug 13573144
737: vcount number := 0; --Bug 13573144
738: m number;
739: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;
740: --Bug 13573144
741: /*
742: --bug 4190357
743: l_count NUMBER;

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

1782: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN
1783: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
1784: l_line_rec.cancelled_quantity := 0;
1785: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1786: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;
1787: l_line_rec.line_id := OE_DEFAULT_LINE.get_line;
1788: --for Bug 3350425. To Prevent Blanket feilds being defaulting from Header.
1789: l_line_rec.blanket_number:=NULL;
1790: l_line_rec.blanket_line_number:=NULL;

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

2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
2060: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
2061: AND ldets.line_index = lines.line_index;
2062: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
2063: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
2064:
2065: l_TRANSACTION_PHASE_CODE varchar2(30) := oe_order_cache.g_header_rec.TRANSACTION_PHASE_CODE;
2066:
2067: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

2061: AND ldets.line_index = lines.line_index;
2062: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
2063: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
2064:
2065: l_TRANSACTION_PHASE_CODE varchar2(30) := oe_order_cache.g_header_rec.TRANSACTION_PHASE_CODE;
2066:
2067: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2068:
2069: l_order_source_id NUMBER;

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

2130: ( p_entity_code => 'HEADER'
2131: ,p_entity_id => l_header_id
2132: ,p_header_id =>l_header_id
2133: ,p_line_id => NULL
2134: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref
2135: ,p_orig_sys_document_line_ref => NULL
2136: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
2137: ,p_source_document_line_id => NULL
2138: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence

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

2132: ,p_header_id =>l_header_id
2133: ,p_line_id => NULL
2134: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref
2135: ,p_orig_sys_document_line_ref => NULL
2136: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
2137: ,p_source_document_line_id => NULL
2138: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
2139: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
2140: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);

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

2134: ,p_orig_sys_document_ref => oe_order_cache.g_header_rec.orig_sys_document_ref
2135: ,p_orig_sys_document_line_ref => NULL
2136: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
2137: ,p_source_document_line_id => NULL
2138: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
2139: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
2140: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);
2141: ELSE
2142: l_line_id := i.line_id;

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

2135: ,p_orig_sys_document_line_ref => NULL
2136: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
2137: ,p_source_document_line_id => NULL
2138: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
2139: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
2140: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);
2141: ELSE
2142: l_line_id := i.line_id;
2143: IF l_line_id IS NOT NULL AND l_line_id <> 0 AND

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

2136: ,p_source_document_id => oe_order_cache.g_header_rec.source_document_id
2137: ,p_source_document_line_id => NULL
2138: ,p_change_sequence => oe_order_cache.g_header_rec.change_sequence
2139: ,p_order_source_id => oe_order_cache.g_header_rec.order_source_id
2140: ,p_source_document_type_id => oe_order_cache.g_header_rec.source_document_type_id);
2141: ELSE
2142: l_line_id := i.line_id;
2143: IF l_line_id IS NOT NULL AND l_line_id <> 0 AND
2144: l_line_id <> FND_API.G_MISS_NUM THEN

Line 2182: oe_order_cache.g_header_rec.orig_sys_document_ref)

2178: ,p_entity_id => i.line_id
2179: ,p_header_id =>l_header_id
2180: ,p_line_id => i.line_id
2181: ,p_orig_sys_document_ref => nvl(l_orig_sys_document_ref,
2182: oe_order_cache.g_header_rec.orig_sys_document_ref)
2183: ,p_orig_sys_document_line_ref => l_orig_sys_line_ref
2184: ,p_orig_sys_shipment_ref => l_orig_sys_shipment_ref
2185: ,p_change_sequence => nvl(l_change_sequence,
2186: oe_order_cache.g_header_rec.change_sequence)

Line 2186: oe_order_cache.g_header_rec.change_sequence)

2182: oe_order_cache.g_header_rec.orig_sys_document_ref)
2183: ,p_orig_sys_document_line_ref => l_orig_sys_line_ref
2184: ,p_orig_sys_shipment_ref => l_orig_sys_shipment_ref
2185: ,p_change_sequence => nvl(l_change_sequence,
2186: oe_order_cache.g_header_rec.change_sequence)
2187: ,p_source_document_id => nvl(l_source_document_id,
2188: oe_order_cache.g_header_rec.source_document_id)
2189: ,p_source_document_line_id => l_source_document_line_id
2190: ,p_order_source_id =>nvl(l_order_source_id,

Line 2188: oe_order_cache.g_header_rec.source_document_id)

2184: ,p_orig_sys_shipment_ref => l_orig_sys_shipment_ref
2185: ,p_change_sequence => nvl(l_change_sequence,
2186: oe_order_cache.g_header_rec.change_sequence)
2187: ,p_source_document_id => nvl(l_source_document_id,
2188: oe_order_cache.g_header_rec.source_document_id)
2189: ,p_source_document_line_id => l_source_document_line_id
2190: ,p_order_source_id =>nvl(l_order_source_id,
2191: oe_order_cache.g_header_rec.order_source_id)
2192: ,p_source_document_type_id => nvl(l_source_document_type_id,

Line 2191: oe_order_cache.g_header_rec.order_source_id)

2187: ,p_source_document_id => nvl(l_source_document_id,
2188: oe_order_cache.g_header_rec.source_document_id)
2189: ,p_source_document_line_id => l_source_document_line_id
2190: ,p_order_source_id =>nvl(l_order_source_id,
2191: oe_order_cache.g_header_rec.order_source_id)
2192: ,p_source_document_type_id => nvl(l_source_document_type_id,
2193: oe_order_cache.g_header_rec.source_document_type_id));
2194: END IF;
2195:

Line 2193: oe_order_cache.g_header_rec.source_document_type_id));

2189: ,p_source_document_line_id => l_source_document_line_id
2190: ,p_order_source_id =>nvl(l_order_source_id,
2191: oe_order_cache.g_header_rec.order_source_id)
2192: ,p_source_document_type_id => nvl(l_source_document_type_id,
2193: oe_order_cache.g_header_rec.source_document_type_id));
2194: END IF;
2195:
2196: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
2197: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);

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

2211:
2212: function check_notify_OC
2213: return boolean
2214: is
2215: l_source_document_type_id number := oe_order_cache.g_header_rec.source_document_type_id;
2216: l_header_id number := oe_order_cache.g_header_rec.header_id;
2217: l_source_system_code number := 0;
2218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2219: begin

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

2212: function check_notify_OC
2213: return boolean
2214: is
2215: l_source_document_type_id number := oe_order_cache.g_header_rec.source_document_type_id;
2216: l_header_id number := oe_order_cache.g_header_rec.header_id;
2217: l_source_system_code number := 0;
2218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2219: begin
2220:

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

2254:
2255:
2256: procedure new_and_updated_notify is
2257:
2258: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2259: cursor insert_adj_cur is
2260: select price_adjustment_id, ldets.automatic_flag auto_flag,line_id,
2261: modifier_level_code, ldets.LIST_HEADER_ID list_header_id,
2262: LIST_LINE_ID, LIST_LINE_TYPE_CODE,inventory_item_id,

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

2594:
2595: l_control_rec OE_GLOBALS.Control_Rec_Type;
2596: lx_new_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
2597: l_notify_flag BOOLEAN;
2598: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2599:
2600:
2601: --
2602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

2655: x_return_status);
2656:
2657: IF l_debug_level > 0 THEN
2658: oe_debug_pub.add('l_booked_flag = '||l_booked_flag);
2659: oe_debug_pub.add('oe_order_cache.g_header_rec.booked_flag = '||oe_order_cache.g_header_rec.booked_flag);
2660: END IF;
2661:
2662: END IF; -- <> Calculate_Only
2663:

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

2666: END process_adv_modifiers;
2667:
2668: Procedure Insert_Adj(p_header_id in Number default null)
2669: IS
2670: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2671: --
2672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2673: --
2674: BEGIN