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

Line 62: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

58: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
59: --
60: BEGIN
61:
62: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
63: RETURN (OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID);
64:
65: EXCEPTION
66: WHEN OTHERS THEN

Line 63: RETURN (OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID);

59: --
60: BEGIN
61:
62: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
63: RETURN (OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID);
64:
65: EXCEPTION
66: WHEN OTHERS THEN
67: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 88: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

84: --For Bug#7592137
85: IF OE_GLOBALS.G_UI_FLAG then
86: RETURN 0;
87: ELSE
88: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'SOURCE ID ='||OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID ) ;
91: END IF;
92: RETURN (OE_ORDER_CACHE.g_header_rec.order_source_id);

Line 90: oe_debug_pub.add( 'SOURCE ID ='||OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID ) ;

86: RETURN 0;
87: ELSE
88: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'SOURCE ID ='||OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID ) ;
91: END IF;
92: RETURN (OE_ORDER_CACHE.g_header_rec.order_source_id);
93: END IF; --End of Bug#7592137
94:

Line 92: RETURN (OE_ORDER_CACHE.g_header_rec.order_source_id);

88: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'SOURCE ID ='||OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID ) ;
91: END IF;
92: RETURN (OE_ORDER_CACHE.g_header_rec.order_source_id);
93: END IF; --End of Bug#7592137
94:
95: EXCEPTION
96: WHEN OTHERS THEN

Line 218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM

214:
215: IF NOT oe_globals.G_HTML_FLAG THEN
216:
217: -- use order_header cache instead of sql : bug 4200055
218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else

Line 219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL

215: IF NOT oe_globals.G_HTML_FLAG THEN
216:
217: -- use order_header cache instead of sql : bug 4200055
218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else
223: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

Line 220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then

216:
217: -- use order_header cache instead of sql : bug 4200055
218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else
223: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
224: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

Line 221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

217: -- use order_header cache instead of sql : bug 4200055
218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else
223: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
224: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
225: end if ;

Line 223: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else
223: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
224: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
225: end if ;
226:
227: /*SELECT booked_flag

Line 224: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else
223: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
224: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
225: end if ;
226:
227: /*SELECT booked_flag
228: INTO l_booked_flag

Line 345: OE_ORDER_CACHE.Load_Item

341: END IF;
342:
343: END IF;
344:
345: OE_ORDER_CACHE.Load_Item
346: (p_key1 => g_line_rec.inventory_item_id
347: ,p_key2 => g_line_rec.ship_from_org_id);
348: l_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
349: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;

Line 348: l_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;

344:
345: OE_ORDER_CACHE.Load_Item
346: (p_key1 => g_line_rec.inventory_item_id
347: ,p_key2 => g_line_rec.ship_from_org_id);
348: l_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
349: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
350:
351: IF (l_item_type = 4 AND
352: l_pick_components_flag = 'Y') OR -- KIT

Line 349: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;

345: OE_ORDER_CACHE.Load_Item
346: (p_key1 => g_line_rec.inventory_item_id
347: ,p_key2 => g_line_rec.ship_from_org_id);
348: l_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
349: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
350:
351: IF (l_item_type = 4 AND
352: l_pick_components_flag = 'Y') OR -- KIT
353: l_item_type = 1 -- MODEL

Line 1460: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);

1456: ELSE
1457: l_parent_line_id := g_line_rec.top_model_line_id;
1458: END IF;
1459: --2605065 : commented. This has been added in procedure Attributes.
1460: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1461:
1462: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1463: (l_parent_line_id );
1464:

Line 1462: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line

1458: END IF;
1459: --2605065 : commented. This has been added in procedure Attributes.
1460: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1461:
1462: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1463: (l_parent_line_id );
1464:
1465:
1466: /* We are introducing a new procedure Default_Child_Line in oe_config_util

Line 1561: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);

1557: IF l_debug_level > 0 THEN
1558: oe_debug_pub.add( 'TOP MODEL LINE ID FOR TOP MODEL' || L_PARENT_LINE_ID , 1 ) ;
1559: END IF;
1560: -- 2605065 : Commented. This has been done in procedure Attributes.
1561: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1562: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1563: (l_parent_line_id );
1564:
1565: p_x_line_rec.ship_tolerance_above := l_top_model_line_rec.ship_tolerance_above;

Line 1562: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line

1558: oe_debug_pub.add( 'TOP MODEL LINE ID FOR TOP MODEL' || L_PARENT_LINE_ID , 1 ) ;
1559: END IF;
1560: -- 2605065 : Commented. This has been done in procedure Attributes.
1561: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1562: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1563: (l_parent_line_id );
1564:
1565: p_x_line_rec.ship_tolerance_above := l_top_model_line_rec.ship_tolerance_above;
1566: p_x_line_rec.ship_tolerance_below := l_top_model_line_rec.ship_tolerance_below;

Line 1649: OE_ORDER_CACHE.Load_Item

1645: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
1646: RETURN NULL;
1647: END IF;
1648:
1649: OE_ORDER_CACHE.Load_Item
1650: (p_key1 => g_line_rec.inventory_item_id
1651: ,p_key2 => g_line_rec.ship_from_org_id);
1652:
1653: l_replenish_to_order_flag :=

Line 1654: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;

1650: (p_key1 => g_line_rec.inventory_item_id
1651: ,p_key2 => g_line_rec.ship_from_org_id);
1652:
1653: l_replenish_to_order_flag :=
1654: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;
1655: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;
1656: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1657:
1658: IF l_debug_level > 0 THEN

Line 1655: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;

1651: ,p_key2 => g_line_rec.ship_from_org_id);
1652:
1653: l_replenish_to_order_flag :=
1654: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;
1655: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;
1656: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1657:
1658: IF l_debug_level > 0 THEN
1659: oe_debug_pub.add( 'GET_ATO_LINE: '||L_REPLENISH_TO_ORDER_FLAG||L_BUILD_IN_WIP_FLAG , 1 ) ;

Line 1656: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;

1652:
1653: l_replenish_to_order_flag :=
1654: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;
1655: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;
1656: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1657:
1658: IF l_debug_level > 0 THEN
1659: oe_debug_pub.add( 'GET_ATO_LINE: '||L_REPLENISH_TO_ORDER_FLAG||L_BUILD_IN_WIP_FLAG , 1 ) ;
1660: END IF;

Line 1692: OE_Order_Cache.Load_Top_Model_Line

1688: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1689: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1690: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1691:
1692: OE_Order_Cache.Load_Top_Model_Line
1693: (g_line_rec.top_model_line_id );
1694: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;
1695:
1696: IF l_ato_line_id is NULL THEN

Line 1694: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;

1690: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1691:
1692: OE_Order_Cache.Load_Top_Model_Line
1693: (g_line_rec.top_model_line_id );
1694: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;
1695:
1696: IF l_ato_line_id is NULL THEN
1697:
1698: IF l_debug_level > 0 THEN

Line 2049: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id

2045: RETURN p_line_rec.item_type_code;
2046: END IF;
2047:
2048:
2049: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2050: ,g_line_rec.ship_from_org_id);
2051: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
2052: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
2053: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;

Line 2051: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;

2047:
2048:
2049: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2050: ,g_line_rec.ship_from_org_id);
2051: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
2052: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
2053: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
2054:
2055: IF l_debug_level > 0 THEN

Line 2052: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;

2048:
2049: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2050: ,g_line_rec.ship_from_org_id);
2051: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
2052: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
2053: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
2054:
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'BOM ITEM TYPE IS ' || L_BOM_ITEM_TYPE ) ;

Line 2053: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;

2049: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2050: ,g_line_rec.ship_from_org_id);
2051: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
2052: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
2053: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
2054:
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'BOM ITEM TYPE IS ' || L_BOM_ITEM_TYPE ) ;
2057: END IF;

Line 2059: If(OE_ORDER_CACHE.g_item_rec.contract_item_type_code = OE_GLOBALS.G_ITEM_SUBSCRIPTION)

2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'BOM ITEM TYPE IS ' || L_BOM_ITEM_TYPE ) ;
2057: END IF;
2058: -- sol_ord_er #16014165
2059: If(OE_ORDER_CACHE.g_item_rec.contract_item_type_code = OE_GLOBALS.G_ITEM_SUBSCRIPTION)
2060: THEN
2061: /* If System Parameter is set to default behaviour of subscription Item as Service */
2062: If( OE_Sys_Parameters.VALUE('OM_DEF_SUBSCRIPTION_BEHAVIOUR',p_line_rec.org_id) = 'SUB')
2063: AND p_line_rec.subscription_enable_flag <> 'N' THEN

Line 2260: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

2256: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2257: --
2258: BEGIN
2259:
2260: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2261: RETURN (OE_ORDER_CACHE.g_header_rec.Orig_Sys_Document_Ref);
2262:
2263: END Get_Orig_Sys_Doc_Ref;
2264:

Line 2261: RETURN (OE_ORDER_CACHE.g_header_rec.Orig_Sys_Document_Ref);

2257: --
2258: BEGIN
2259:
2260: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2261: RETURN (OE_ORDER_CACHE.g_header_rec.Orig_Sys_Document_Ref);
2262:
2263: END Get_Orig_Sys_Doc_Ref;
2264:
2265:

Line 2311: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);

2307: oe_debug_pub.add( 'AK IN DEFAULTING:' || P_LINE_REC.HEADER_ID , 1 ) ;
2308: END IF;
2309:
2310: /* Replaced with the following IF statement for 2421909
2311: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2312: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2313: */
2314:
2315: IF (p_line_rec.operation = oe_globals.g_opr_create)

Line 2312: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;

2308: END IF;
2309:
2310: /* Replaced with the following IF statement for 2421909
2311: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2312: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2313: */
2314:
2315: IF (p_line_rec.operation = oe_globals.g_opr_create)
2316: THEN -- 2421909ND

Line 2321: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);

2317:
2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'AK IN DEFAULTING: OPERATION IS CREATE' , 1 ) ;
2320: END IF;
2321: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2322: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2323: ELSE
2324: l_order_category := p_old_line_rec.line_category_code;
2325: END IF;

Line 2322: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;

2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'AK IN DEFAULTING: OPERATION IS CREATE' , 1 ) ;
2320: END IF;
2321: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2322: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2323: ELSE
2324: l_order_category := p_old_line_rec.line_category_code;
2325: END IF;
2326:

Line 2332: OE_ORDER_CACHE.Load_Line_Type(p_line_rec.line_type_id);

2328:
2329: IF l_debug_level > 0 THEN
2330: oe_debug_pub.add( 'AK IN DEFAULTING: WHEN LINE_TYPE_ID IS NOT NULL' , 1 ) ;
2331: END IF;
2332: OE_ORDER_CACHE.Load_Line_Type(p_line_rec.line_type_id);
2333: l_order_category := OE_ORDER_CACHE.g_line_type_rec.ORDER_CATEGORY_CODE;
2334:
2335: END IF;
2336:

Line 2333: l_order_category := OE_ORDER_CACHE.g_line_type_rec.ORDER_CATEGORY_CODE;

2329: IF l_debug_level > 0 THEN
2330: oe_debug_pub.add( 'AK IN DEFAULTING: WHEN LINE_TYPE_ID IS NOT NULL' , 1 ) ;
2331: END IF;
2332: OE_ORDER_CACHE.Load_Line_Type(p_line_rec.line_type_id);
2333: l_order_category := OE_ORDER_CACHE.g_line_type_rec.ORDER_CATEGORY_CODE;
2334:
2335: END IF;
2336:
2337: IF l_order_category = 'RETURN' THEN

Line 2469: OE_Order_Cache.Load_top_model_line

2465:
2466: IF l_debug_level > 0 THEN
2467: oe_debug_pub.add( 'LOADING TOP_MODEL_LINE_ID: ' || G_LINE_REC.TOP_MODEL_LINE_ID ) ;
2468: END IF;
2469: OE_Order_Cache.Load_top_model_line
2470: (g_line_rec.top_model_line_id );
2471: l_line_number := OE_Order_Cache.g_top_model_line_rec.line_number;
2472:
2473: RETURN (l_line_number);

Line 2471: l_line_number := OE_Order_Cache.g_top_model_line_rec.line_number;

2467: oe_debug_pub.add( 'LOADING TOP_MODEL_LINE_ID: ' || G_LINE_REC.TOP_MODEL_LINE_ID ) ;
2468: END IF;
2469: OE_Order_Cache.Load_top_model_line
2470: (g_line_rec.top_model_line_id );
2471: l_line_number := OE_Order_Cache.g_top_model_line_rec.line_number;
2472:
2473: RETURN (l_line_number);
2474:
2475: IF l_debug_level > 0 THEN

Line 2506: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

2502: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2503: --
2504: BEGIN
2505:
2506: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2507:
2508: l_latest_acceptable_date := p_request_date +
2509: OE_ORDER_CACHE.g_header_rec.latest_schedule_limit;
2510:

Line 2509: OE_ORDER_CACHE.g_header_rec.latest_schedule_limit;

2505:
2506: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2507:
2508: l_latest_acceptable_date := p_request_date +
2509: OE_ORDER_CACHE.g_header_rec.latest_schedule_limit;
2510:
2511: RETURN l_latest_acceptable_date;
2512:
2513: EXCEPTION

Line 2596: OE_Order_Cache.Load_Top_Model_Line(g_line_rec.top_model_line_id );

2592: RETURN l_ship_number;
2593:
2594: ELSE
2595:
2596: OE_Order_Cache.Load_Top_Model_Line(g_line_rec.top_model_line_id );
2597: l_ship_number := OE_ORDER_CACHE.g_top_model_line_rec.shipment_number;
2598: RETURN l_ship_number;
2599:
2600: END IF;

Line 2597: l_ship_number := OE_ORDER_CACHE.g_top_model_line_rec.shipment_number;

2593:
2594: ELSE
2595:
2596: OE_Order_Cache.Load_Top_Model_Line(g_line_rec.top_model_line_id );
2597: l_ship_number := OE_ORDER_CACHE.g_top_model_line_rec.shipment_number;
2598: RETURN l_ship_number;
2599:
2600: END IF;
2601:

Line 2649: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);

2645: p_line_type_id <> FND_API.G_MISS_NUM THEN
2646:
2647: BEGIN
2648:
2649: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);
2650: l_source_type := OE_ORDER_CACHE.g_line_type_rec.ship_source_type_code;
2651:
2652: IF l_source_type is null THEN
2653: RETURN p_source_type;

Line 2650: l_source_type := OE_ORDER_CACHE.g_line_type_rec.ship_source_type_code;

2646:
2647: BEGIN
2648:
2649: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);
2650: l_source_type := OE_ORDER_CACHE.g_line_type_rec.ship_source_type_code;
2651:
2652: IF l_source_type is null THEN
2653: RETURN p_source_type;
2654: END IF;

Line 2732: OE_Order_Cache.Load_Item (p_inventory_item_id

2728:
2729: END IF;
2730:
2731:
2732: OE_Order_Cache.Load_Item (p_inventory_item_id
2733: ,p_ship_from_org_id);
2734:
2735: IF l_debug_level > 0 THEN
2736: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;

Line 2736: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;

2732: OE_Order_Cache.Load_Item (p_inventory_item_id
2733: ,p_ship_from_org_id);
2734:
2735: IF l_debug_level > 0 THEN
2736: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;
2737: END IF;
2738:
2739: RETURN OE_ORDER_CACHE.g_item_rec.shippable_item_flag;
2740:

Line 2739: RETURN OE_ORDER_CACHE.g_item_rec.shippable_item_flag;

2735: IF l_debug_level > 0 THEN
2736: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;
2737: END IF;
2738:
2739: RETURN OE_ORDER_CACHE.g_item_rec.shippable_item_flag;
2740:
2741: END Get_Shippable;
2742:
2743:

Line 2774: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id

2770: -- SMC PTO flag is only for PTO's and Kits
2771:
2772: IF (g_line_rec.top_model_line_id = g_line_rec.line_id) AND
2773: (g_line_rec.top_model_line_id <> nvl(g_line_rec.ato_line_id,0)) THEN
2774: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2775: ,g_line_rec.ship_from_org_id);
2776:
2777: IF l_debug_level > 0 THEN
2778: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;

Line 2778: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;

2774: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2775: ,g_line_rec.ship_from_org_id);
2776:
2777: IF l_debug_level > 0 THEN
2778: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;
2779: END IF;
2780: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;
2781:
2782: ELSIF

Line 2780: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;

2776:
2777: IF l_debug_level > 0 THEN
2778: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;
2779: END IF;
2780: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;
2781:
2782: ELSIF
2783: g_line_rec.ship_model_complete_flag is not null AND
2784: g_line_rec.ship_model_complete_flag <> FND_API.G_MISS_CHAR AND

Line 3598: x_item_rec OE_Order_Cache.Item_Rec_Type;

3594: )
3595: IS
3596: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;
3597: l_revision_controlled VARCHAR2(1);
3598: x_item_rec OE_Order_Cache.Item_Rec_Type;
3599: --
3600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3601: --
3602: l_overship_invoice_basis varchar2(30) := null; --- bug# 6617423

Line 3900: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id

3896: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3897: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3898: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3899: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3900: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
3901: ,p_x_line_rec.ship_from_org_id);
3902: -- IF x_item_rec.ont_pricing_qty_source = 1 THEN INVCONV
3903: IF x_item_rec.ont_pricing_qty_source = 'S' THEN -- INVCONV
3904: -- x_item_rec.tracking_quantity_ind = 'P' AND -- INVCONV - TAKE OUT AS OPENED UP TO ANY ITEM AND ORG

Line 4157: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

4153: p_x_line_rec.request_date := l_line_rec.request_date;
4154:
4155: -- Quoting Changes Start
4156: -- Copy transaction phase from order header to return line
4157: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
4158: p_x_line_rec.transaction_phase_code :=
4159: OE_Order_Cache.g_header_rec.transaction_phase_code;
4160: -- Quoting Changes End
4161:

Line 4159: OE_Order_Cache.g_header_rec.transaction_phase_code;

4155: -- Quoting Changes Start
4156: -- Copy transaction phase from order header to return line
4157: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
4158: p_x_line_rec.transaction_phase_code :=
4159: OE_Order_Cache.g_header_rec.transaction_phase_code;
4160: -- Quoting Changes End
4161:
4162: /* Fix for the bug 1777243
4163: ** Copy the Ordered Quantity from the set value in

Line 4381: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);

4377:
4378: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN
4379:
4380: -- Get the values of l_currency_code and l_sold_to_org_id
4381: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4382: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;
4383: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
4384:
4385: IF l_debug_level > 0 THEN

Line 4382: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;

4378: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN
4379:
4380: -- Get the values of l_currency_code and l_sold_to_org_id
4381: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4382: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;
4383: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
4384:
4385: IF l_debug_level > 0 THEN
4386: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES 0' , 1 ) ;

Line 4383: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;

4379:
4380: -- Get the values of l_currency_code and l_sold_to_org_id
4381: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4382: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;
4383: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
4384:
4385: IF l_debug_level > 0 THEN
4386: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES 0' , 1 ) ;
4387: oe_debug_pub.add('Sold To Org Id IS '|| l_sold_to_org_id , 1 ) ;

Line 4664: OE_Order_Cache.clear_top_model_line(g_line_rec.top_model_line_id);

4660: g_line_rec.top_model_line_id := Get_Top_Model_Line;
4661: END IF;
4662: -- 2605065
4663: IF g_line_rec.top_model_line_id IS NOT NULL THEN
4664: OE_Order_Cache.clear_top_model_line(g_line_rec.top_model_line_id);
4665: END IF;
4666:
4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add( 'BEFORE ITEM_TYPE' ) ;

Line 5798: l_item_rec OE_ORDER_CACHE.item_rec_type;

5794: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
5795: l_status VARCHAR2(1);
5796: l_msg_count NUMBER;
5797: l_msg_data VARCHAR2(2000);
5798: l_item_rec OE_ORDER_CACHE.item_rec_type;
5799:
5800: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5801:
5802: BEGIN

Line 5884: if OE_ORDER_CACHE.g_header_rec.header_id = p_header_id then

5880:
5881: IF ( ONT_Header_Def_Hdlr.g_record.header_id IS NULL OR
5882: ONT_Header_Def_Hdlr.g_record.header_id <> p_header_id)
5883: THEN
5884: if OE_ORDER_CACHE.g_header_rec.header_id = p_header_id then
5885: l_header_rec := OE_ORDER_CACHE.g_header_rec ;
5886: else
5887: OE_Header_Util.Query_Row
5888: ( p_header_id => p_header_id

Line 5885: l_header_rec := OE_ORDER_CACHE.g_header_rec ;

5881: IF ( ONT_Header_Def_Hdlr.g_record.header_id IS NULL OR
5882: ONT_Header_Def_Hdlr.g_record.header_id <> p_header_id)
5883: THEN
5884: if OE_ORDER_CACHE.g_header_rec.header_id = p_header_id then
5885: l_header_rec := OE_ORDER_CACHE.g_header_rec ;
5886: else
5887: OE_Header_Util.Query_Row
5888: ( p_header_id => p_header_id
5889: , x_header_rec => l_header_rec );