DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on FND_PROFILE

Line 354: fnd_profile.value('INV_CTP') = '5'

350: END IF; -- Gop code level
351:
352: IF p_line_rec.ato_line_id(p_index) = p_line_rec.line_id(p_index) AND
353: p_line_rec.item_type_code(p_index) in ('STANDARD','OPTION','INCLUDED') AND --9775352
354: fnd_profile.value('INV_CTP') = '5'
355: THEN
356:
357: l_org_id := nvl(p_line_rec.ship_from_org_id(p_index), OE_BULK_ORDER_PVT.G_ITEM_ORG);
358: l_c_index := OE_BULK_CACHE.Load_Item

Line 835: oe_debug_pub.add( 'ENTITY: PROFILE EXPENSE_ASSET:' || FND_PROFILE.VALUE ( 'INV:EXPENSE_TO_ASSET_TRANSFER' ) , 5 ) ;

831: -- validate the subinv is allowed (expense/asset)
832: -- because defaulting can be defaulting an expense sub
833: -- and the INV profile is set to No.
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'ENTITY: PROFILE EXPENSE_ASSET:' || FND_PROFILE.VALUE ( 'INV:EXPENSE_TO_ASSET_TRANSFER' ) , 5 ) ;
836: END IF;
837: BEGIN
838:
839: select 'Y'

Line 844: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1

840: into l_dummy
841: from mtl_subinventories_trk_val_v sub
842: where sub.organization_id = p_ship_from_org_id
843: and sub.secondary_inventory_name = p_subinventory
844: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
845: OR
846: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
847: and nvl(p_order_source_id, -1) <> 10
848: )

Line 846: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

842: where sub.organization_id = p_ship_from_org_id
843: and sub.secondary_inventory_name = p_subinventory
844: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
845: OR
846: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
847: and nvl(p_order_source_id, -1) <> 10
848: )
849: OR
850: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

Line 850: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

846: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
847: and nvl(p_order_source_id, -1) <> 10
848: )
849: OR
850: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
851: and nvl(p_order_source_id, -1) = 10
852: and 'N' = (select inventory_asset_flag
853: from mtl_system_items
854: where inventory_item_id = p_inventory_item_id

Line 859: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

855: and organization_id = p_ship_from_org_id
856: )
857: )
858: OR
859: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
860: and nvl(p_order_source_id, -1) = 10
861: and 'Y' = (select inventory_asset_flag
862: from mtl_system_items
863: where inventory_item_id = p_inventory_item_id

Line 4426: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

4422:
4423: IF (p_line_rec.lock_control(l_index) = -99 ) THEN
4424:
4425: --ER 9060917
4426: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
4427:
4428: If p_line_rec.item_type_code(l_index) ='STANDARD' then
4429:
4430: UPDATE OE_LINES_IFACE_ALL

Line 5050: G_INV_TRN_TYPE_ID := FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');

5046: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
5047: -- Get info from profile value
5048:
5049: IF G_INV_TRN_TYPE_ID IS NULL THEN
5050: G_INV_TRN_TYPE_ID := FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
5051:
5052: SELECT tax_calculation_flag
5053: INTO G_INV_TAX_CALC_FLAG
5054: FROM ra_cust_trx_types