DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE dependencies on OE_ORDER_CACHE

Line 22: l_line_type_rec OE_Order_Cache.Line_Type_Rec_Type;

18: IS
19: l_proj_ref_enabled NUMBER;
20: l_proj_control_level NUMBER;
21: l_calculate_tax_flag VARCHAR2(1) := 'N';
22: l_line_type_rec OE_Order_Cache.Line_Type_Rec_Type;
23: l_item_type_code VARCHAR2(30);
24: BEGIN
25:
26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);

Line 188: l_line_type_rec := OE_Order_Cache.Load_Line_Type(p_line_rec.line_type_id);

184: -- type is set to Yes.
185:
186: oe_debug_pub.add('calc tax flag 2 : ' || l_line_type_rec.calculate_tax_flag );
187:
188: l_line_type_rec := OE_Order_Cache.Load_Line_Type(p_line_rec.line_type_id);
189:
190: -- fix for bug 1701388 - commented the following code
191: /*
192:

Line 1154: --l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM INVCONV

1150: AND inventory_item_id = discrete_item_id;
1151:
1152: /*OPM 02/JUN/00 BEGIN
1153: ====================*/
1154: --l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM INVCONV
1155: --l_OPM_UOM VARCHAR2(4); --OPM 06/22
1156: --l_status VARCHAR2(1); --OPM 06/22
1157: l_msg_count NUMBER;
1158: l_msg_data VARCHAR2(2000);

Line 3860: l_item_rec OE_ORDER_CACHE.item_rec_type;

3856:
3857: RETURN VARCHAR2
3858: IS
3859: l_item_type_code VARCHAR2(30) := NULL;
3860: l_item_rec OE_ORDER_CACHE.item_rec_type;
3861: BEGIN
3862:
3863: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);

Line 3875: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id

3871: END IF;
3872:
3873:
3874: l_item_rec :=
3875: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
3876: ,p_line_rec.ship_from_org_id);
3877:
3878: oe_debug_pub.add('Bom Item Type is ' || l_item_rec.bom_item_type);
3879: