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 4189: oe_order_cache.g_header_rec := p_header_rec;

4185: p_header_rec.lock_control := l_lock_control;
4186:
4187: -- aksingh update the operation to NULL and update the cache with
4188: -- record
4189: oe_order_cache.g_header_rec := p_header_rec;
4190: oe_order_cache.g_header_rec.operation := null;
4191:
4192: -- Below line commented because as g_header_rec is now global, no need
4193: -- to call below procedure to update, updated directly above

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

4186:
4187: -- aksingh update the operation to NULL and update the cache with
4188: -- record
4189: oe_order_cache.g_header_rec := p_header_rec;
4190: oe_order_cache.g_header_rec.operation := null;
4191:
4192: -- Below line commented because as g_header_rec is now global, no need
4193: -- to call below procedure to update, updated directly above
4194:

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

4191:
4192: -- Below line commented because as g_header_rec is now global, no need
4193: -- to call below procedure to update, updated directly above
4194:
4195: -- OE_Order_Cache.Set_Order_Header(p_header_rec);
4196:
4197: oe_debug_pub.add('Exiting OE_HEADER_UTIL.UPDATE_ROW', 1);
4198:
4199: EXCEPTION

Line 4615: oe_order_cache.g_header_rec := p_header_rec;

4611: p_header_rec.lock_control := l_lock_control;
4612:
4613: -- aksingh update the operation to NULL and update the cache with
4614: -- record
4615: oe_order_cache.g_header_rec := p_header_rec;
4616: oe_order_cache.g_header_rec.operation := null;
4617: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4618:
4619: -- calling notification framework to update global picture

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

4612:
4613: -- aksingh update the operation to NULL and update the cache with
4614: -- record
4615: oe_order_cache.g_header_rec := p_header_rec;
4616: oe_order_cache.g_header_rec.operation := null;
4617: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4618:
4619: -- calling notification framework to update global picture
4620: -- check code release level first. Notification framework is at Pack H level

Line 4714: OE_Order_Cache.Load_Order_Header(p_header_id);

4710: -- notification framework end
4711:
4712: -- BUG 2670775 Reverse Limits Begin
4713: oe_debug_pub.add('log request to Reverse_Limits for HEADER level DELETE',1);
4714: OE_Order_Cache.Load_Order_Header(p_header_id);
4715: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;
4716: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;
4717:
4718: -- If price_request_code is not cached, retrieve it

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

4711:
4712: -- BUG 2670775 Reverse Limits Begin
4713: oe_debug_pub.add('log request to Reverse_Limits for HEADER level DELETE',1);
4714: OE_Order_Cache.Load_Order_Header(p_header_id);
4715: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;
4716: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;
4717:
4718: -- If price_request_code is not cached, retrieve it
4719: IF l_price_request_code = FND_API.G_MISS_CHAR

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

4712: -- BUG 2670775 Reverse Limits Begin
4713: oe_debug_pub.add('log request to Reverse_Limits for HEADER level DELETE',1);
4714: OE_Order_Cache.Load_Order_Header(p_header_id);
4715: l_price_request_code := OE_ORDER_CACHE.g_header_rec.price_request_code;
4716: l_transaction_phase_code := OE_ORDER_CACHE.g_header_rec.transaction_phase_code;
4717:
4718: -- If price_request_code is not cached, retrieve it
4719: IF l_price_request_code = FND_API.G_MISS_CHAR
4720: OR l_price_request_code is NULL THEN

Line 5019: IF oe_order_cache.g_header_rec.header_id = p_header_id

5015: l_org_id := OE_GLOBALS.G_ORG_ID;
5016: END IF;*/
5017: --Commented for MOAC end
5018: -- aksingh use global record if exists for header_id
5019: IF oe_order_cache.g_header_rec.header_id = p_header_id
5020: -- { Start of the fix 2436046
5021: AND x_header_rec.lock_control <> -1
5022: -- End of the fix 2436046 }
5023: THEN

Line 5025: x_header_rec := oe_order_cache.g_header_rec;

5021: AND x_header_rec.lock_control <> -1
5022: -- End of the fix 2436046 }
5023: THEN
5024: l_x_header_rec_oper := x_header_rec.operation;
5025: x_header_rec := oe_order_cache.g_header_rec;
5026: x_header_rec.operation := l_x_header_rec_oper;
5027: return;
5028: END IF;
5029:

Line 5435: oe_order_cache.g_header_rec := x_header_rec;

5431: if l_debug_level > 0 then
5432: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);
5433: end if;
5434:
5435: oe_order_cache.g_header_rec := x_header_rec;
5436: oe_order_cache.g_header_rec.operation := null;
5437:
5438: if l_debug_level > 0 then
5439: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);

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

5432: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);
5433: end if;
5434:
5435: oe_order_cache.g_header_rec := x_header_rec;
5436: oe_order_cache.g_header_rec.operation := null;
5437:
5438: if l_debug_level > 0 then
5439: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);
5440: end if;

Line 7565: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

7561: X_doc_sequence_id NUMBER;
7562: X_set_Of_Books_id NUMBER;
7563: seqassid INTEGER;
7564: x_Trx_Date DATE;
7565: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
7566: l_dummy VARCHAR2(10);
7567: t VARCHAR2(1);
7568: X_db_sequence_name VARCHAR2(50);
7569: x_doc_sequence_type CHAR(1);

Line 7588: OE_Order_Cache.Load_Set_Of_Books;

7584: RETURN NULL;
7585: END IF;
7586:
7587: l_set_of_books_rec :=
7588: OE_Order_Cache.Load_Set_Of_Books;
7589:
7590: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7591:
7592: -- X_Doc_Category_Code := to_char(p_order_type_id);

Line 7765: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

7761: X_Msg_Flag VARCHAR2(240);
7762: X_set_Of_Books_id NUMBER;
7763: seqassid INTEGER;
7764: l_ord_num_src_id NUMBER := NULL;
7765: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
7766: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
7767: l_order_number_csr INTEGER;
7768: l_result INTEGER;
7769: l_select_stmt VARCHAR2(240);

Line 7766: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

7762: X_set_Of_Books_id NUMBER;
7763: seqassid INTEGER;
7764: l_ord_num_src_id NUMBER := NULL;
7765: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
7766: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
7767: l_order_number_csr INTEGER;
7768: l_result INTEGER;
7769: l_select_stmt VARCHAR2(240);
7770: l_column_name VARCHAR2(80);

Line 7794: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

7790: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_ORD_NUM_BOOKING');
7791: OE_MSG_PUB.Add;
7792: RAISE FND_API.G_EXC_ERROR;
7793: end if;
7794: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7795: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7796: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);
7797: oe_debug_pub.add('When Order Number has been changed :'||p_x_header_rec.transaction_phase_code);
7798: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN

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

7792: RAISE FND_API.G_EXC_ERROR;
7793: end if;
7794: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7795: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7796: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);
7797: oe_debug_pub.add('When Order Number has been changed :'||p_x_header_rec.transaction_phase_code);
7798: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7799: X_Doc_Category_Code := to_char(p_x_header_rec.order_type_id);
7800: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN

Line 7839: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

7835: THEN
7836:
7837: oe_debug_pub.ADD('Ordertype is :' || to_char(p_x_header_rec.order_type_id),3);
7838:
7839: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7840: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
7841:
7842: IF p_x_header_rec.order_type_id IS NOT NULL AND
7843: p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM

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

7842: IF p_x_header_rec.order_type_id IS NOT NULL AND
7843: p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM
7844: THEN
7845:
7846: l_order_type_rec := OE_Order_Cache.Load_Order_Type (p_x_header_rec.order_type_id);
7847:
7848: oe_debug_pub.add('transaction phase :'||p_x_header_rec.transaction_phase_code);
7849: -- Quoting Changes
7850: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN

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

9036: -- Check if the lock_control has changed, it would if there
9037: -- were updates due to synchronous activities like booking in
9038: -- the header flow. If yes, refresh the header record
9039:
9040: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);
9041: oe_debug_pub.add('DB lock control :'||
9042: OE_Order_Cache.g_header_rec.lock_control);
9043:
9044: IF OE_Order_Cache.g_header_rec.lock_control

Line 9042: OE_Order_Cache.g_header_rec.lock_control);

9038: -- the header flow. If yes, refresh the header record
9039:
9040: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);
9041: oe_debug_pub.add('DB lock control :'||
9042: OE_Order_Cache.g_header_rec.lock_control);
9043:
9044: IF OE_Order_Cache.g_header_rec.lock_control
9045: <> p_x_header_rec.lock_control
9046: THEN

Line 9044: IF OE_Order_Cache.g_header_rec.lock_control

9040: OE_Order_Cache.Load_Order_Header(p_x_header_rec.header_id);
9041: oe_debug_pub.add('DB lock control :'||
9042: OE_Order_Cache.g_header_rec.lock_control);
9043:
9044: IF OE_Order_Cache.g_header_rec.lock_control
9045: <> p_x_header_rec.lock_control
9046: THEN
9047: l_operation := p_x_header_rec.operation;
9048: p_x_header_rec := OE_Order_Cache.g_header_rec;

Line 9048: p_x_header_rec := OE_Order_Cache.g_header_rec;

9044: IF OE_Order_Cache.g_header_rec.lock_control
9045: <> p_x_header_rec.lock_control
9046: THEN
9047: l_operation := p_x_header_rec.operation;
9048: p_x_header_rec := OE_Order_Cache.g_header_rec;
9049: p_x_header_rec.operation := l_operation;
9050: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
9051: END IF;
9052: