APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_ORDER_CACHE

Line 21: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

17: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
18: , x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19: )
20: IS
21: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
22: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
23: BEGIN
24:
25: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

Line 22: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

18: , x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19: )
20: IS
21: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
22: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
23: BEGIN
24:
25: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
26:

Line 110: l_order_type_rec := OE_Order_Cache.Load_Order_Type

106:
107: -- Check for additional required fields based on flags set
108: -- at the order type: agreement, customer po number
109:
110: l_order_type_rec := OE_Order_Cache.Load_Order_Type
111: (p_header_rec.order_type_id);
112:
113: IF ( l_order_type_rec.agreement_required_flag = 'Y' AND
114: p_header_rec.agreement_id IS NULL)

Line 141: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

137: -- conversion type is required
138:
139: IF p_header_rec.conversion_type_code IS NULL
140: THEN
141: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
142:
143: IF ( l_set_of_books_rec.currency_code <>
144: p_header_rec.transactional_curr_code) THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;

Line 283: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;

279: )
280: IS
281: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
282: l_dummy VARCHAR2(10);
283: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
284: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
285: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
286:
287: l_agreement_name varchar2(240);

Line 284: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

280: IS
281: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
282: l_dummy VARCHAR2(10);
283: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
284: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
285: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
286:
287: l_agreement_name varchar2(240);
288: l_sold_to_org number;

Line 285: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;

281: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
282: l_dummy VARCHAR2(10);
283: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
284: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
285: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
286:
287: l_agreement_name varchar2(240);
288: l_sold_to_org number;
289: l_price_list_id number;

Line 504: OE_Order_Cache.Load_Price_List ( p_header_rec.price_list_id );

500: oe_debug_pub.add('New curr ' || p_header_rec.transactional_curr_code,2);
501: -- Validate currency
502:
503: l_price_list_rec :=
504: OE_Order_Cache.Load_Price_List ( p_header_rec.price_list_id );
505:
506:
507: oe_debug_pub.add('p_header_rec.price_list_id' || p_header_rec.price_list_id, 2);
508:

Line 636: -- OE_Order_Cache.Load_Agreement (p_header_rec.agreement_id);

632:
633: IF p_header_rec.agreement_id IS NOT NULL THEN
634: -- commented by Geresh
635: -- l_agreement_rec :=
636: -- OE_Order_Cache.Load_Agreement (p_header_rec.agreement_id);
637:
638: BEGIN
639: BEGIN
640: select list_type_code

Line 691: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);

687: raise FND_API.G_EXC_ERROR;
688: END;
689:
690: -- l_order_type_rec :=
691: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);
692:
693: END IF; -- Agreement is not null
694:
695: -- Ship to Org id depends on sold to org.