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 503: OE_Order_Cache.Load_Price_List ( p_header_rec.price_list_id );

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

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

601:
602: IF p_header_rec.agreement_id IS NOT NULL THEN
603: -- commented by Geresh
604: -- l_agreement_rec :=
605: -- OE_Order_Cache.Load_Agreement (p_header_rec.agreement_id);
606:
607: BEGIN
608: BEGIN
609: select list_type_code

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

656: raise FND_API.G_EXC_ERROR;
657: END;
658:
659: -- l_order_type_rec :=
660: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);
661:
662: END IF; -- Agreement is not null
663:
664: -- Ship to Org id depends on sold to org.