APPS.POR_AUTOSOURCE_UTIL_PKG dependencies on FND_PROFILE

Line 54: IF fnd_profile.value('REQUISITION_TYPE') = 'INTERNAL' THEN

50: l_purchasable_flag VARCHAR(1) := 'N';
51:
52: BEGIN
53:
54: IF fnd_profile.value('REQUISITION_TYPE') = 'INTERNAL' THEN
55: RETURN 0;
56: END IF;
57:
58: select purchasing_enabled_flag

Line 271: AND 'Y' = (CASE WHEN Nvl(fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'),2) = 2

267: mtl_onhand_sub_v mos,
268: mtl_reservations mrs,
269: mtl_system_items msi
270: WHERE msub.organization_id = l_source_organization_id -- bug 5470125, do not bind p_source_organization_id
271: AND 'Y' = (CASE WHEN Nvl(fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'),2) = 2
272: AND msub.asset_inventory = 2
273: THEN 'N'
274: ELSE 'Y'
275: END)

Line 358: l_set_id := to_number(fnd_profile.value('MRP_DEFAULT_ASSIGNMENT_SET'));

354: l_procedure_name, 'Unit of Issue: ' || p_unit_of_issue);
355: END IF;
356:
357: -- first find the MRP: Assignment Set profile value
358: l_set_id := to_number(fnd_profile.value('MRP_DEFAULT_ASSIGNMENT_SET'));
359:
360: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
361: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME ||
362: l_procedure_name, 'Assignment Set ID: ' || to_char(l_set_id));

Line 487: IF (Nvl(FND_PROFILE.Value('POR_SRC_INT_STO_ITMS_NO_AVAIL'),'INTERNALLY') = 'INTERNALLY') THEN

483: END IF;
484: return true;
485: elsif l_avail_quantity = 0 then
486: --Bug 14842729 if there is no on hand quantity, source type depends on Profile POR_SRC_INT_STO_ITMS_NO_AVAIL
487: IF (Nvl(FND_PROFILE.Value('POR_SRC_INT_STO_ITMS_NO_AVAIL'),'INTERNALLY') = 'INTERNALLY') THEN
488: p_sourcing_type := 'INTERNAL';
489: p_source_organization_id := l_source_organization_id;
490: --p_source_subinventory := l_source_subinventory;
491: close c_sourcing;

Line 504: and (Nvl(FND_PROFILE.Value('POR_SRC_INT_STO_ITMS_NO_AVAIL'),'INTERNALLY') = 'INTERNALLY')) then

500: --save the first record so if the avail qty is 0 in all subinv do not
501: --populate the subinv and default the first source org if there is no error
502: --Bug 14842729 if there is no on hand quantity, source type depends on Profile POR_SRC_INT_STO_ITMS_NO_AVAIL
503: if ( (l_count = 0) and not (l_sourcing_rule_exist_err or l_is_item_assigned_err or l_is_ship_network_assigned_err or l_is_item_shippable_err)
504: and (Nvl(FND_PROFILE.Value('POR_SRC_INT_STO_ITMS_NO_AVAIL'),'INTERNALLY') = 'INTERNALLY')) then
505:
506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME ||
508: l_procedure_name, 'Count = 0');