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 60: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 343: OE_ORDER_CACHE.Load_Item

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

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

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

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

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

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

1394: ELSE
1395: l_parent_line_id := g_line_rec.top_model_line_id;
1396: END IF;
1397: --2605065 : commented. This has been added in procedure Attributes.
1398: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1399:
1400: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1401: (l_parent_line_id );
1402:

Line 1400: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line

1396: END IF;
1397: --2605065 : commented. This has been added in procedure Attributes.
1398: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1399:
1400: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1401: (l_parent_line_id );
1402:
1403:
1404: /* We are introducing a new procedure Default_Child_Line in oe_config_util

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

1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add( 'TOP MODEL LINE ID FOR TOP MODEL' || L_PARENT_LINE_ID , 1 ) ;
1497: END IF;
1498: -- 2605065 : Commented. This has been done in procedure Attributes.
1499: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1500: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1501: (l_parent_line_id );
1502:
1503: p_x_line_rec.ship_tolerance_above := l_top_model_line_rec.ship_tolerance_above;

Line 1500: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line

1496: oe_debug_pub.add( 'TOP MODEL LINE ID FOR TOP MODEL' || L_PARENT_LINE_ID , 1 ) ;
1497: END IF;
1498: -- 2605065 : Commented. This has been done in procedure Attributes.
1499: --OE_Order_Cache.clear_top_model_line(l_parent_line_id);
1500: l_top_model_line_rec := OE_Order_Cache.Load_Top_Model_Line
1501: (l_parent_line_id );
1502:
1503: p_x_line_rec.ship_tolerance_above := l_top_model_line_rec.ship_tolerance_above;
1504: p_x_line_rec.ship_tolerance_below := l_top_model_line_rec.ship_tolerance_below;

Line 1587: OE_ORDER_CACHE.Load_Item

1583: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
1584: RETURN NULL;
1585: END IF;
1586:
1587: OE_ORDER_CACHE.Load_Item
1588: (p_key1 => g_line_rec.inventory_item_id
1589: ,p_key2 => g_line_rec.ship_from_org_id);
1590:
1591: l_replenish_to_order_flag :=

Line 1592: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;

1588: (p_key1 => g_line_rec.inventory_item_id
1589: ,p_key2 => g_line_rec.ship_from_org_id);
1590:
1591: l_replenish_to_order_flag :=
1592: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;
1593: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;
1594: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1595:
1596: IF l_debug_level > 0 THEN

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

1589: ,p_key2 => g_line_rec.ship_from_org_id);
1590:
1591: l_replenish_to_order_flag :=
1592: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;
1593: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;
1594: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1595:
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add( 'GET_ATO_LINE: '||L_REPLENISH_TO_ORDER_FLAG||L_BUILD_IN_WIP_FLAG , 1 ) ;

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

1590:
1591: l_replenish_to_order_flag :=
1592: OE_ORDER_CACHE.g_item_rec.replenish_to_order_flag;
1593: l_build_in_wip_flag := OE_ORDER_CACHE.g_item_rec.build_in_wip_flag;
1594: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1595:
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add( 'GET_ATO_LINE: '||L_REPLENISH_TO_ORDER_FLAG||L_BUILD_IN_WIP_FLAG , 1 ) ;
1598: END IF;

Line 1626: OE_Order_Cache.Load_Top_Model_Line

1622: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1623: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1624: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1625:
1626: OE_Order_Cache.Load_Top_Model_Line
1627: (g_line_rec.top_model_line_id );
1628: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;
1629:
1630: IF l_ato_line_id is NULL THEN

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

1624: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1625:
1626: OE_Order_Cache.Load_Top_Model_Line
1627: (g_line_rec.top_model_line_id );
1628: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;
1629:
1630: IF l_ato_line_id is NULL THEN
1631:
1632: IF l_debug_level > 0 THEN

Line 1979: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id

1975: RETURN p_line_rec.item_type_code;
1976: END IF;
1977:
1978:
1979: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
1980: ,g_line_rec.ship_from_org_id);
1981: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1982: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
1983: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;

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

1977:
1978:
1979: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
1980: ,g_line_rec.ship_from_org_id);
1981: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1982: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
1983: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
1984:
1985: IF l_debug_level > 0 THEN

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

1978:
1979: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
1980: ,g_line_rec.ship_from_org_id);
1981: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1982: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
1983: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
1984:
1985: IF l_debug_level > 0 THEN
1986: oe_debug_pub.add( 'BOM ITEM TYPE IS ' || L_BOM_ITEM_TYPE ) ;

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

1979: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
1980: ,g_line_rec.ship_from_org_id);
1981: l_bom_item_type := OE_ORDER_CACHE.g_item_rec.bom_item_type;
1982: l_service_item_flag := OE_ORDER_CACHE.g_item_rec.service_item_flag;
1983: l_pick_components_flag := OE_ORDER_CACHE.g_item_rec.pick_components_flag;
1984:
1985: IF l_debug_level > 0 THEN
1986: oe_debug_pub.add( 'BOM ITEM TYPE IS ' || L_BOM_ITEM_TYPE ) ;
1987: END IF;

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

2139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2140: --
2141: BEGIN
2142:
2143: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2144: RETURN (OE_ORDER_CACHE.g_header_rec.Orig_Sys_Document_Ref);
2145:
2146: END Get_Orig_Sys_Doc_Ref;
2147:

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

2140: --
2141: BEGIN
2142:
2143: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2144: RETURN (OE_ORDER_CACHE.g_header_rec.Orig_Sys_Document_Ref);
2145:
2146: END Get_Orig_Sys_Doc_Ref;
2147:
2148:

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

2190: oe_debug_pub.add( 'AK IN DEFAULTING:' || P_LINE_REC.HEADER_ID , 1 ) ;
2191: END IF;
2192:
2193: /* Replaced with the following IF statement for 2421909
2194: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2195: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2196: */
2197:
2198: IF (p_line_rec.operation = oe_globals.g_opr_create)

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

2191: END IF;
2192:
2193: /* Replaced with the following IF statement for 2421909
2194: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2195: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2196: */
2197:
2198: IF (p_line_rec.operation = oe_globals.g_opr_create)
2199: THEN -- 2421909ND

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

2200:
2201: IF l_debug_level > 0 THEN
2202: oe_debug_pub.add( 'AK IN DEFAULTING: OPERATION IS CREATE' , 1 ) ;
2203: END IF;
2204: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2205: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2206: ELSE
2207: l_order_category := p_old_line_rec.line_category_code;
2208: END IF;

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

2201: IF l_debug_level > 0 THEN
2202: oe_debug_pub.add( 'AK IN DEFAULTING: OPERATION IS CREATE' , 1 ) ;
2203: END IF;
2204: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2205: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2206: ELSE
2207: l_order_category := p_old_line_rec.line_category_code;
2208: END IF;
2209:

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

2211:
2212: IF l_debug_level > 0 THEN
2213: oe_debug_pub.add( 'AK IN DEFAULTING: WHEN LINE_TYPE_ID IS NOT NULL' , 1 ) ;
2214: END IF;
2215: OE_ORDER_CACHE.Load_Line_Type(p_line_rec.line_type_id);
2216: l_order_category := OE_ORDER_CACHE.g_line_type_rec.ORDER_CATEGORY_CODE;
2217:
2218: END IF;
2219:

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

2212: IF l_debug_level > 0 THEN
2213: oe_debug_pub.add( 'AK IN DEFAULTING: WHEN LINE_TYPE_ID IS NOT NULL' , 1 ) ;
2214: END IF;
2215: OE_ORDER_CACHE.Load_Line_Type(p_line_rec.line_type_id);
2216: l_order_category := OE_ORDER_CACHE.g_line_type_rec.ORDER_CATEGORY_CODE;
2217:
2218: END IF;
2219:
2220: IF l_order_category = 'RETURN' THEN

Line 2352: OE_Order_Cache.Load_top_model_line

2348:
2349: IF l_debug_level > 0 THEN
2350: oe_debug_pub.add( 'LOADING TOP_MODEL_LINE_ID: ' || G_LINE_REC.TOP_MODEL_LINE_ID ) ;
2351: END IF;
2352: OE_Order_Cache.Load_top_model_line
2353: (g_line_rec.top_model_line_id );
2354: l_line_number := OE_Order_Cache.g_top_model_line_rec.line_number;
2355:
2356: RETURN (l_line_number);

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

2350: oe_debug_pub.add( 'LOADING TOP_MODEL_LINE_ID: ' || G_LINE_REC.TOP_MODEL_LINE_ID ) ;
2351: END IF;
2352: OE_Order_Cache.Load_top_model_line
2353: (g_line_rec.top_model_line_id );
2354: l_line_number := OE_Order_Cache.g_top_model_line_rec.line_number;
2355:
2356: RETURN (l_line_number);
2357:
2358: IF l_debug_level > 0 THEN

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

2385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2386: --
2387: BEGIN
2388:
2389: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2390:
2391: l_latest_acceptable_date := p_request_date +
2392: OE_ORDER_CACHE.g_header_rec.latest_schedule_limit;
2393:

Line 2392: OE_ORDER_CACHE.g_header_rec.latest_schedule_limit;

2388:
2389: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
2390:
2391: l_latest_acceptable_date := p_request_date +
2392: OE_ORDER_CACHE.g_header_rec.latest_schedule_limit;
2393:
2394: RETURN l_latest_acceptable_date;
2395:
2396: EXCEPTION

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

2475: RETURN l_ship_number;
2476:
2477: ELSE
2478:
2479: OE_Order_Cache.Load_Top_Model_Line(g_line_rec.top_model_line_id );
2480: l_ship_number := OE_ORDER_CACHE.g_top_model_line_rec.shipment_number;
2481: RETURN l_ship_number;
2482:
2483: END IF;

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

2476:
2477: ELSE
2478:
2479: OE_Order_Cache.Load_Top_Model_Line(g_line_rec.top_model_line_id );
2480: l_ship_number := OE_ORDER_CACHE.g_top_model_line_rec.shipment_number;
2481: RETURN l_ship_number;
2482:
2483: END IF;
2484:

Line 2532: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);

2528: p_line_type_id <> FND_API.G_MISS_NUM THEN
2529:
2530: BEGIN
2531:
2532: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);
2533: l_source_type := OE_ORDER_CACHE.g_line_type_rec.ship_source_type_code;
2534:
2535: IF l_source_type is null THEN
2536: RETURN p_source_type;

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

2529:
2530: BEGIN
2531:
2532: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);
2533: l_source_type := OE_ORDER_CACHE.g_line_type_rec.ship_source_type_code;
2534:
2535: IF l_source_type is null THEN
2536: RETURN p_source_type;
2537: END IF;

Line 2613: OE_Order_Cache.Load_Item (p_inventory_item_id

2609:
2610: END IF;
2611:
2612:
2613: OE_Order_Cache.Load_Item (p_inventory_item_id
2614: ,p_ship_from_org_id);
2615:
2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;

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

2613: OE_Order_Cache.Load_Item (p_inventory_item_id
2614: ,p_ship_from_org_id);
2615:
2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;
2618: END IF;
2619:
2620: RETURN OE_ORDER_CACHE.g_item_rec.shippable_item_flag;
2621:

Line 2620: RETURN OE_ORDER_CACHE.g_item_rec.shippable_item_flag;

2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add( 'SHIPPABLE FLAG: ' || OE_ORDER_CACHE.G_ITEM_REC.SHIPPABLE_ITEM_FLAG , 1 ) ;
2618: END IF;
2619:
2620: RETURN OE_ORDER_CACHE.g_item_rec.shippable_item_flag;
2621:
2622: END Get_Shippable;
2623:
2624:

Line 2655: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id

2651: -- SMC PTO flag is only for PTO's and Kits
2652:
2653: IF (g_line_rec.top_model_line_id = g_line_rec.line_id) AND
2654: (g_line_rec.top_model_line_id <> nvl(g_line_rec.ato_line_id,0)) THEN
2655: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2656: ,g_line_rec.ship_from_org_id);
2657:
2658: IF l_debug_level > 0 THEN
2659: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;

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

2655: OE_Order_Cache.Load_Item (g_line_rec.inventory_item_id
2656: ,g_line_rec.ship_from_org_id);
2657:
2658: IF l_debug_level > 0 THEN
2659: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;
2660: END IF;
2661: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;
2662:
2663: ELSIF

Line 2661: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;

2657:
2658: IF l_debug_level > 0 THEN
2659: oe_debug_pub.add( 'SMC FLAG ' || OE_ORDER_CACHE.G_ITEM_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;
2660: END IF;
2661: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;
2662:
2663: ELSIF
2664: g_line_rec.ship_model_complete_flag is not null AND
2665: g_line_rec.ship_model_complete_flag <> FND_API.G_MISS_CHAR AND

Line 3479: x_item_rec OE_Order_Cache.Item_Rec_Type;

3475: )
3476: IS
3477: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;
3478: l_revision_controlled VARCHAR2(1);
3479: x_item_rec OE_Order_Cache.Item_Rec_Type;
3480: --
3481: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3482: --
3483: l_overship_invoice_basis varchar2(30) := null; --- bug# 6617423

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

3769: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3770: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3771: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3772: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3773: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
3774: ,p_x_line_rec.ship_from_org_id);
3775: -- IF x_item_rec.ont_pricing_qty_source = 1 THEN INVCONV
3776: IF x_item_rec.ont_pricing_qty_source = 'S' THEN -- INVCONV
3777: -- x_item_rec.tracking_quantity_ind = 'P' AND -- INVCONV - TAKE OUT AS OPENED UP TO ANY ITEM AND ORG

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

4026: p_x_line_rec.request_date := l_line_rec.request_date;
4027:
4028: -- Quoting Changes Start
4029: -- Copy transaction phase from order header to return line
4030: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
4031: p_x_line_rec.transaction_phase_code :=
4032: OE_Order_Cache.g_header_rec.transaction_phase_code;
4033: -- Quoting Changes End
4034:

Line 4032: OE_Order_Cache.g_header_rec.transaction_phase_code;

4028: -- Quoting Changes Start
4029: -- Copy transaction phase from order header to return line
4030: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
4031: p_x_line_rec.transaction_phase_code :=
4032: OE_Order_Cache.g_header_rec.transaction_phase_code;
4033: -- Quoting Changes End
4034:
4035: /* Fix for the bug 1777243
4036: ** Copy the Ordered Quantity from the set value in

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

4248: p_old_line_rec.return_attribute2)
4249: THEN
4250:
4251: -- Get the values of l_currency_code and l_sold_to_org_id
4252: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4253: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;
4254: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
4255:
4256: IF l_debug_level > 0 THEN

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

4249: THEN
4250:
4251: -- Get the values of l_currency_code and l_sold_to_org_id
4252: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4253: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;
4254: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
4255:
4256: IF l_debug_level > 0 THEN
4257: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES 0' , 1 ) ;

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

4250:
4251: -- Get the values of l_currency_code and l_sold_to_org_id
4252: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4253: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;
4254: l_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
4255:
4256: IF l_debug_level > 0 THEN
4257: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES 0' , 1 ) ;
4258: oe_debug_pub.add('Sold To Org Id IS '|| l_sold_to_org_id , 1 ) ;

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

4510: g_line_rec.top_model_line_id := Get_Top_Model_Line;
4511: END IF;
4512: -- 2605065
4513: IF g_line_rec.top_model_line_id IS NOT NULL THEN
4514: OE_Order_Cache.clear_top_model_line(g_line_rec.top_model_line_id);
4515: END IF;
4516:
4517: IF l_debug_level > 0 THEN
4518: oe_debug_pub.add( 'BEFORE ITEM_TYPE' ) ;

Line 5522: l_item_rec OE_ORDER_CACHE.item_rec_type;

5518: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
5519: l_status VARCHAR2(1);
5520: l_msg_count NUMBER;
5521: l_msg_data VARCHAR2(2000);
5522: l_item_rec OE_ORDER_CACHE.item_rec_type;
5523:
5524: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5525:
5526: BEGIN

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

5604:
5605: IF ( ONT_Header_Def_Hdlr.g_record.header_id IS NULL OR
5606: ONT_Header_Def_Hdlr.g_record.header_id <> p_header_id)
5607: THEN
5608: if OE_ORDER_CACHE.g_header_rec.header_id = p_header_id then
5609: l_header_rec := OE_ORDER_CACHE.g_header_rec ;
5610: else
5611: OE_Header_Util.Query_Row
5612: ( p_header_id => p_header_id

Line 5609: l_header_rec := OE_ORDER_CACHE.g_header_rec ;

5605: IF ( ONT_Header_Def_Hdlr.g_record.header_id IS NULL OR
5606: ONT_Header_Def_Hdlr.g_record.header_id <> p_header_id)
5607: THEN
5608: if OE_ORDER_CACHE.g_header_rec.header_id = p_header_id then
5609: l_header_rec := OE_ORDER_CACHE.g_header_rec ;
5610: else
5611: OE_Header_Util.Query_Row
5612: ( p_header_id => p_header_id
5613: , x_header_rec => l_header_rec );