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_HEADER_UTIL dependencies on OE_ORDER_CACHE

Line 4040: oe_order_cache.g_header_rec := p_header_rec;

4036: p_header_rec.lock_control := l_lock_control;
4037:
4038: -- aksingh update the operation to NULL and update the cache with
4039: -- record
4040: oe_order_cache.g_header_rec := p_header_rec;
4041: oe_order_cache.g_header_rec.operation := null;
4042:
4043: -- Below line commented because as g_header_rec is now global, no need
4044: -- to call below procedure to update, updated directly above

Line 4041: oe_order_cache.g_header_rec.operation := null;

4037:
4038: -- aksingh update the operation to NULL and update the cache with
4039: -- record
4040: oe_order_cache.g_header_rec := p_header_rec;
4041: oe_order_cache.g_header_rec.operation := null;
4042:
4043: -- Below line commented because as g_header_rec is now global, no need
4044: -- to call below procedure to update, updated directly above
4045:

Line 4046: -- OE_Order_Cache.Set_Order_Header(p_header_rec);

4042:
4043: -- Below line commented because as g_header_rec is now global, no need
4044: -- to call below procedure to update, updated directly above
4045:
4046: -- OE_Order_Cache.Set_Order_Header(p_header_rec);
4047:
4048: oe_debug_pub.add('Exiting OE_HEADER_UTIL.UPDATE_ROW', 1);
4049:
4050: EXCEPTION

Line 4466: oe_order_cache.g_header_rec := p_header_rec;

4462: p_header_rec.lock_control := l_lock_control;
4463:
4464: -- aksingh update the operation to NULL and update the cache with
4465: -- record
4466: oe_order_cache.g_header_rec := p_header_rec;
4467: oe_order_cache.g_header_rec.operation := null;
4468: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4469:
4470: -- calling notification framework to update global picture

Line 4467: oe_order_cache.g_header_rec.operation := null;

4463:
4464: -- aksingh update the operation to NULL and update the cache with
4465: -- record
4466: oe_order_cache.g_header_rec := p_header_rec;
4467: oe_order_cache.g_header_rec.operation := null;
4468: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4469:
4470: -- calling notification framework to update global picture
4471: -- check code release level first. Notification framework is at Pack H level

Line 4565: OE_Order_Cache.Load_Order_Header(p_header_id);

4561: -- notification framework end
4562:
4563: -- BUG 2670775 Reverse Limits Begin
4564: oe_debug_pub.add('log request to Reverse_Limits for HEADER level DELETE',1);
4565: OE_Order_Cache.Load_Order_Header(p_header_id);
4566: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;
4567: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;
4568:
4569: -- If price_request_code is not cached, retrieve it

Line 4566: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;

4562:
4563: -- BUG 2670775 Reverse Limits Begin
4564: oe_debug_pub.add('log request to Reverse_Limits for HEADER level DELETE',1);
4565: OE_Order_Cache.Load_Order_Header(p_header_id);
4566: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;
4567: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;
4568:
4569: -- If price_request_code is not cached, retrieve it
4570: IF l_price_request_code = FND_API.G_MISS_CHAR

Line 4567: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;

4563: -- BUG 2670775 Reverse Limits Begin
4564: oe_debug_pub.add('log request to Reverse_Limits for HEADER level DELETE',1);
4565: OE_Order_Cache.Load_Order_Header(p_header_id);
4566: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;
4567: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;
4568:
4569: -- If price_request_code is not cached, retrieve it
4570: IF l_price_request_code = FND_API.G_MISS_CHAR
4571: OR l_price_request_code is NULL THEN

Line 4869: IF oe_order_cache.g_header_rec.header_id = p_header_id

4865: l_org_id := OE_GLOBALS.G_ORG_ID;
4866: END IF;*/
4867: --Commented for MOAC end
4868: -- aksingh use global record if exists for header_id
4869: IF oe_order_cache.g_header_rec.header_id = p_header_id
4870: -- { Start of the fix 2436046
4871: AND x_header_rec.lock_control <> -1
4872: -- End of the fix 2436046 }
4873: THEN

Line 4875: x_header_rec := oe_order_cache.g_header_rec;

4871: AND x_header_rec.lock_control <> -1
4872: -- End of the fix 2436046 }
4873: THEN
4874: l_x_header_rec_oper := x_header_rec.operation;
4875: x_header_rec := oe_order_cache.g_header_rec;
4876: x_header_rec.operation := l_x_header_rec_oper;
4877: return;
4878: END IF;
4879:

Line 5285: oe_order_cache.g_header_rec := x_header_rec;

5281: if l_debug_level > 0 then
5282: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);
5283: end if;
5284:
5285: oe_order_cache.g_header_rec := x_header_rec;
5286: oe_order_cache.g_header_rec.operation := null;
5287:
5288: if l_debug_level > 0 then
5289: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);

Line 5286: oe_order_cache.g_header_rec.operation := null;

5282: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);
5283: end if;
5284:
5285: oe_order_cache.g_header_rec := x_header_rec;
5286: oe_order_cache.g_header_rec.operation := null;
5287:
5288: if l_debug_level > 0 then
5289: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);
5290: end if;

Line 7413: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

7409: X_doc_sequence_id NUMBER;
7410: X_set_Of_Books_id NUMBER;
7411: seqassid INTEGER;
7412: x_Trx_Date DATE;
7413: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
7414: l_dummy VARCHAR2(10);
7415: t VARCHAR2(1);
7416: X_db_sequence_name VARCHAR2(50);
7417: x_doc_sequence_type CHAR(1);

Line 7436: OE_Order_Cache.Load_Set_Of_Books;

7432: RETURN NULL;
7433: END IF;
7434:
7435: l_set_of_books_rec :=
7436: OE_Order_Cache.Load_Set_Of_Books;
7437:
7438: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7439:
7440: -- X_Doc_Category_Code := to_char(p_order_type_id);

Line 7613: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

7609: X_Msg_Flag VARCHAR2(240);
7610: X_set_Of_Books_id NUMBER;
7611: seqassid INTEGER;
7612: l_ord_num_src_id NUMBER := NULL;
7613: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
7614: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
7615: l_order_number_csr INTEGER;
7616: l_result INTEGER;
7617: l_select_stmt VARCHAR2(240);

Line 7614: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

7610: X_set_Of_Books_id NUMBER;
7611: seqassid INTEGER;
7612: l_ord_num_src_id NUMBER := NULL;
7613: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
7614: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
7615: l_order_number_csr INTEGER;
7616: l_result INTEGER;
7617: l_select_stmt VARCHAR2(240);
7618: l_column_name VARCHAR2(80);

Line 7642: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

7638: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_ORD_NUM_BOOKING');
7639: OE_MSG_PUB.Add;
7640: RAISE FND_API.G_EXC_ERROR;
7641: end if;
7642: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7643: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7644: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);
7645: oe_debug_pub.add('When Order Number has been changed :'||p_x_header_rec.transaction_phase_code);
7646: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN

Line 7644: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);

7640: RAISE FND_API.G_EXC_ERROR;
7641: end if;
7642: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7643: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7644: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);
7645: oe_debug_pub.add('When Order Number has been changed :'||p_x_header_rec.transaction_phase_code);
7646: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7647: X_Doc_Category_Code := to_char(p_x_header_rec.order_type_id);
7648: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN

Line 7687: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

7683: THEN
7684:
7685: oe_debug_pub.ADD('Ordertype is :' || to_char(p_x_header_rec.order_type_id),3);
7686:
7687: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7688: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7689:
7690: IF p_x_header_rec.order_type_id IS NOT NULL AND
7691: p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM

Line 7694: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);

7690: IF p_x_header_rec.order_type_id IS NOT NULL AND
7691: p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM
7692: THEN
7693:
7694: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);
7695:
7696: oe_debug_pub.add('transaction phase :'||p_x_header_rec.transaction_phase_code);
7697: -- Quoting Changes
7698: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN

Line 8847: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);

8843: -- Check if the lock_control has changed, it would if there
8844: -- were updates due to synchronous activities like booking in
8845: -- the header flow. If yes, refresh the header record
8846:
8847: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);
8848: oe_debug_pub.add('DB lock control :'||
8849: OE_Order_Cache.g_header_rec.lock_control);
8850:
8851: IF OE_Order_Cache.g_header_rec.lock_control

Line 8849: OE_Order_Cache.g_header_rec.lock_control);

8845: -- the header flow. If yes, refresh the header record
8846:
8847: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);
8848: oe_debug_pub.add('DB lock control :'||
8849: OE_Order_Cache.g_header_rec.lock_control);
8850:
8851: IF OE_Order_Cache.g_header_rec.lock_control
8852: <> p_x_header_rec.lock_control
8853: THEN

Line 8851: IF OE_Order_Cache.g_header_rec.lock_control

8847: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);
8848: oe_debug_pub.add('DB lock control :'||
8849: OE_Order_Cache.g_header_rec.lock_control);
8850:
8851: IF OE_Order_Cache.g_header_rec.lock_control
8852: <> p_x_header_rec.lock_control
8853: THEN
8854: l_operation := p_x_header_rec.operation;
8855: p_x_header_rec := OE_Order_Cache.g_header_rec;

Line 8855: p_x_header_rec := OE_Order_Cache.g_header_rec;

8851: IF OE_Order_Cache.g_header_rec.lock_control
8852: <> p_x_header_rec.lock_control
8853: THEN
8854: l_operation := p_x_header_rec.operation;
8855: p_x_header_rec := OE_Order_Cache.g_header_rec;
8856: p_x_header_rec.operation := l_operation;
8857: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
8858: END IF;
8859: