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 */
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
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;
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:
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
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;
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;