APPS.OE_BULK_PROCESS_LINE dependencies on FND_PROFILE

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

324: END IF; -- Gop code level
325:
326: IF p_line_rec.ato_line_id(p_index) = p_line_rec.line_id(p_index) AND
327: p_line_rec.item_type_code(p_index) in ('STANDARD','OPTION') AND
328: fnd_profile.value('INV_CTP') = '5'
329: THEN
330:
331: l_org_id := nvl(p_line_rec.ship_from_org_id(p_index), OE_BULK_ORDER_PVT.G_ITEM_ORG);
332: l_c_index := OE_BULK_CACHE.Load_Item

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

805: -- validate the subinv is allowed (expense/asset)
806: -- because defaulting can be defaulting an expense sub
807: -- and the INV profile is set to No.
808: IF l_debug_level > 0 THEN
809: oe_debug_pub.add( 'ENTITY: PROFILE EXPENSE_ASSET:' || FND_PROFILE.VALUE ( 'INV:EXPENSE_TO_ASSET_TRANSFER' ) , 5 ) ;
810: END IF;
811: BEGIN
812:
813: select 'Y'

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

814: into l_dummy
815: from mtl_subinventories_trk_val_v sub
816: where sub.organization_id = p_ship_from_org_id
817: and sub.secondary_inventory_name = p_subinventory
818: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
819: OR
820: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
821: and nvl(p_order_source_id, -1) <> 10
822: )

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

816: where sub.organization_id = p_ship_from_org_id
817: and sub.secondary_inventory_name = p_subinventory
818: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
819: OR
820: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
821: and nvl(p_order_source_id, -1) <> 10
822: )
823: OR
824: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

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

820: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
821: and nvl(p_order_source_id, -1) <> 10
822: )
823: OR
824: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
825: and nvl(p_order_source_id, -1) = 10
826: and 'N' = (select inventory_asset_flag
827: from mtl_system_items
828: where inventory_item_id = p_inventory_item_id

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

829: and organization_id = p_ship_from_org_id
830: )
831: )
832: OR
833: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
834: and nvl(p_order_source_id, -1) = 10
835: and 'Y' = (select inventory_asset_flag
836: from mtl_system_items
837: where inventory_item_id = p_inventory_item_id

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

4941: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
4942: -- Get info from profile value
4943:
4944: IF G_INV_TRN_TYPE_ID IS NULL THEN
4945: G_INV_TRN_TYPE_ID := FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
4946:
4947: SELECT tax_calculation_flag
4948: INTO G_INV_TAX_CALC_FLAG
4949: FROM ra_cust_trx_types