DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on STANDARD

Line 1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1038: IF ( p_x_line_rec.sold_to_org_id IS NOT NULL
1039: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1040: AND p_x_line_rec.inventory_item_id IS NOT NULL
1041: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1043: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1044: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id))) THEN
1045:
1046: Default_Blanket_Values

Line 1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1124: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1125: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1126: AND p_x_line_rec.inventory_item_id IS NOT NULL
1127: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1129: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1130: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1131: )
1132: -- Bug 2769562 => If blanket line number is being cleared by user

Line 1411: * and STANDARD */

1407:
1408:
1409: /* After getting ato_line_id, for top level parents and ato items,
1410: * we don't default any other columns for lines with item_type MODEL
1411: * and STANDARD */
1412:
1413: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1414: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1415: THEN

Line 1414: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1410: * we don't default any other columns for lines with item_type MODEL
1411: * and STANDARD */
1412:
1413: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1414: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1415: THEN
1416: --{ bug3601544 starts
1417: IF l_debug_level > 0 THEN
1418: OE_DEBUG_PUB.Add('IB Owner: '||g_line_rec.ib_owner,3);

Line 1443: oe_debug_pub.add( 'RETURNING FOR ITEM TYPE MODEL AND STANDARD' , 1 ) ;

1439: END IF;
1440: -- bug3601544 ends }
1441:
1442: IF l_debug_level > 0 THEN
1443: oe_debug_pub.add( 'RETURNING FOR ITEM TYPE MODEL AND STANDARD' , 1 ) ;
1444: END IF;
1445: RETURN;
1446: END IF;
1447:

Line 1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

1535: /* These updates are valid only for Options/clasees/included items */
1536:
1537: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1538: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1540: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1541: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1542: THEN
1543:

Line 1545: oe_debug_pub.add( 'RETURNING FOR ITEM TYPE SERVICE , MODEL , STANDARD AND TOP LEVEL KITS' , 1 ) ;

1541: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1542: THEN
1543:
1544: IF l_debug_level > 0 THEN
1545: oe_debug_pub.add( 'RETURNING FOR ITEM TYPE SERVICE , MODEL , STANDARD AND TOP LEVEL KITS' , 1 ) ;
1546: END IF;
1547:
1548: RETURN;
1549: END IF;

Line 1667: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND

1663: -- build in wip flag, see if req?
1664:
1665: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
1666: l_replenish_to_order_flag = 'Y') OR
1667: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1668: l_replenish_to_order_flag = 'Y' AND
1669: l_build_in_wip_flag = 'Y')OR
1670: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND
1671: l_replenish_to_order_flag = 'Y' AND --9775352

Line 2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;

2028:
2029:
2030: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
2031: g_line_rec.subscription_enable_flag := 'N'; -- sol_ord_er #16014165
2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2033: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
2034: ELSIF p_line_rec.line_category_code = 'ORDER'
2035: and p_line_rec.retrobill_request_id is NOT NULL
2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN

Line 2033: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)

2029:
2030: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
2031: g_line_rec.subscription_enable_flag := 'N'; -- sol_ord_er #16014165
2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2033: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
2034: ELSIF p_line_rec.line_category_code = 'ORDER'
2035: and p_line_rec.retrobill_request_id is NOT NULL
2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
2037:

Line 2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;

2034: ELSIF p_line_rec.line_category_code = 'ORDER'
2035: and p_line_rec.retrobill_request_id is NOT NULL
2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
2037:
2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2039: --- BUG#6933507
2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
2041: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN*/
2042: -- sol_ord_er #16014165 commented above as Included Item can be Subscription Service */

Line 2069: /* If default system parameter is NULL or Standard but via PO API value passed is Y then store Y */

2065: IF l_debug_level > 0 THEN
2066: oe_debug_pub.add('SK OEXDLINB.pls SUBSCRIPTION1 Y');
2067: END IF;
2068: Else
2069: /* If default system parameter is NULL or Standard but via PO API value passed is Y then store Y */
2070: If p_line_rec.subscription_enable_flag = 'Y' then
2071: IF l_debug_level > 0 THEN
2072: oe_debug_pub.add('SK OEXDLINB.pls SUBSCRIPTION2 Y');
2073: End If;

Line 2143: -- STANDARD item, OPTION item and a KIT

2139: IF l_debug_level > 0 THEN
2140: oe_debug_pub.add( 'BOM 4 AND FLAG = N' ) ;
2141: END IF;
2142: -- Following 3 items can have bom_item_type = 4 :
2143: -- STANDARD item, OPTION item and a KIT
2144: -- We will distinguish an item to be a kit by seeing if
2145: -- it has a record in bom_bill_of_materials.
2146: -- All options MUST have the top_model_line_id populated
2147: -- before they come to defaulting. Thus we use it to distinguish

Line 2148: -- between a standard and an option item.

2144: -- We will distinguish an item to be a kit by seeing if
2145: -- it has a record in bom_bill_of_materials.
2146: -- All options MUST have the top_model_line_id populated
2147: -- before they come to defaulting. Thus we use it to distinguish
2148: -- between a standard and an option item.
2149: -- ato_item's item_type_code will be standard
2150:
2151: IF l_pick_components_flag = 'Y'
2152: --16559475 start commented below part of code from IF statement

Line 2149: -- ato_item's item_type_code will be standard

2145: -- it has a record in bom_bill_of_materials.
2146: -- All options MUST have the top_model_line_id populated
2147: -- before they come to defaulting. Thus we use it to distinguish
2148: -- between a standard and an option item.
2149: -- ato_item's item_type_code will be standard
2150:
2151: IF l_pick_components_flag = 'Y'
2152: --16559475 start commented below part of code from IF statement
2153: THEN

Line 2172: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

2168: End If;
2169: l_item_type_code := OE_GLOBALS.G_ITEM_SERVICE;
2170: -- sol_ord_er #16014165 end
2171: ELSE
2172: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2173: END IF;
2174:
2175: IF l_debug_level > 0 THEN
2176: oe_debug_pub.add( ' BEFORE CALLING CHECK 1' ) ;

Line 2210: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

2206: WHEN NO_DATA_FOUND THEN
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( ' BEFORE CALLING CHECK 4' ) ;
2209: END IF;
2210: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2211: --Procedure to check change in item_type_code
2212: Check_Item_Type(p_line_rec,
2213: p_old_line_rec,
2214: l_item_type_code);

Line 2715: OE_GLOBALS.G_ITEM_STANDARD) AND

2711: THEN
2712:
2713: -- ##1820608, ato_item can be under a pto model.
2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2715: OE_GLOBALS.G_ITEM_STANDARD) AND
2716: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2717: p_line_id = p_ato_line_id )AND
2718: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND -- 9775352
2719: p_line_id = p_ato_line_id )

Line 3629: p_x_line_rec.item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

3625: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3626: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;
3627: p_x_line_rec.item_identifier_type := l_ref_line_rec.item_identifier_type;
3628: p_x_line_rec.ordered_item_id := l_ref_line_rec.ordered_item_id;
3629: p_x_line_rec.item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
3630: ELSE
3631: NULL;
3632: END IF;
3633:

Line 5584: -- It is possible to default the Subsscription Item as Standard and then change to Subscription

5580:
5581: -- get shippable is dependent on model_option_defaulting.
5582: -- ## bug fix: 1609895, shippable flag from warehouse
5583: -- sol_ord_er #16014165
5584: -- It is possible to default the Subsscription Item as Standard and then change to Subscription
5585: IF l_debug_level > 0 THEN
5586: oe_debug_pub.add( 'SK OEXDLINB.pls 2255 Subscription= '||p_x_line_rec.subscription_enable_flag
5587: ||' Old Subscription= '||p_old_line_rec.subscription_enable_flag,5 );
5588: oe_debug_pub.add( ' Shippable= '|| p_x_line_rec.shippable_flag

Line 5619: -- This is only required if the Item Type changes to Standard but with the old flag value as Y(where it cant be Standard)

5615: ,p_item_type_code => p_x_line_rec.item_type_code );
5616: end if; --sol_ord_er #16014165
5617: END IF;
5618: -- When a Subscription Service Line is converted into Return Line, Dependent Fields on flag has to be cleared
5619: -- This is only required if the Item Type changes to Standard but with the old flag value as Y(where it cant be Standard)
5620: If NVL(p_old_line_rec.subscription_enable_flag,'N')='Y' and p_x_line_rec.item_type_code = 'STANDARD'
5621: THEN
5622: IF l_debug_level > 0 THEN
5623: oe_debug_pub.add(' SK OEXDLINB.pls 2255.1 Clearing Dependency for Subscription Service');

Line 5620: If NVL(p_old_line_rec.subscription_enable_flag,'N')='Y' and p_x_line_rec.item_type_code = 'STANDARD'

5616: end if; --sol_ord_er #16014165
5617: END IF;
5618: -- When a Subscription Service Line is converted into Return Line, Dependent Fields on flag has to be cleared
5619: -- This is only required if the Item Type changes to Standard but with the old flag value as Y(where it cant be Standard)
5620: If NVL(p_old_line_rec.subscription_enable_flag,'N')='Y' and p_x_line_rec.item_type_code = 'STANDARD'
5621: THEN
5622: IF l_debug_level > 0 THEN
5623: oe_debug_pub.add(' SK OEXDLINB.pls 2255.1 Clearing Dependency for Subscription Service');
5624: End If;