DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on FND_PROFILE

Line 817: lv_hr_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

813: day_uom := true;
814: hour_uom := true;
815: lv_day_qty := p_quantity;
816: lv_uom_code := p_uom_code;
817: lv_hr_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
818: lv_day_uom_code := fnd_profile.value('MSC:DAY_UOM_CODE');
819:
820: /* If the UOM entered in UI is same as MSC:Day UOM return the same value
821: No conversion is neeeded */

Line 818: lv_day_uom_code := fnd_profile.value('MSC:DAY_UOM_CODE');

814: hour_uom := true;
815: lv_day_qty := p_quantity;
816: lv_uom_code := p_uom_code;
817: lv_hr_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
818: lv_day_uom_code := fnd_profile.value('MSC:DAY_UOM_CODE');
819:
820: /* If the UOM entered in UI is same as MSC:Day UOM return the same value
821: No conversion is neeeded */
822: IF lv_day_uom_code IS NOT NULL THEN

Line 1422: SELECT NVL(FND_PROFILE.VALUE('MSC_COST_TYPE'),

1418: RETURN NUMBER
1419: IS
1420:
1421: CURSOR COST_C IS
1422: SELECT NVL(FND_PROFILE.VALUE('MSC_COST_TYPE'),
1423: DECODE(cost_org.primary_cost_method,1,1,2,cost_org.AVG_RATES_COST_TYPE_ID,1))
1424: FROM mtl_parameters org, mtl_parameters cost_org
1425: WHERE org.cost_organization_id = cost_org.organization_id
1426: and org.organization_id = p_org_id;

Line 1429: SELECT NVL(FND_PROFILE.VALUE('MSC_COST_TYPE'),1)

1425: WHERE org.cost_organization_id = cost_org.organization_id
1426: and org.organization_id = p_org_id;
1427:
1428: CURSOR COST_C2 IS
1429: SELECT NVL(FND_PROFILE.VALUE('MSC_COST_TYPE'),1)
1430: FROM dual;
1431:
1432: l_cost_type_id NUMBER:= NULL;
1433:

Line 1682: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');

1678: * Should not we actually implement this in the Snap Shot?.
1679: */
1680:
1681: Begin
1682: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');
1683: v_cmro_customer_id := lv_customer_id;
1684:
1685: Exception
1686: When others then

Line 1701: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');

1697: lv_cmro_ship_to NUMBER;
1698: BEGIN
1699:
1700: Begin
1701: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');
1702:
1703: Exception
1704: When others then
1705: lv_customer_id := null;

Line 1748: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');

1744: BEGIN
1745:
1746:
1747: Begin
1748: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');
1749:
1750: Exception
1751: When others then
1752: lv_customer_id := null;