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 1815: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');

1811: * Should not we actually implement this in the Snap Shot?.
1812: */
1813:
1814: Begin
1815: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');
1816: v_cmro_customer_id := lv_customer_id;
1817:
1818: Exception
1819: When others then

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

1830: lv_cmro_ship_to NUMBER;
1831: BEGIN
1832:
1833: Begin
1834: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');
1835:
1836: Exception
1837: When others then
1838: lv_customer_id := null;

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

1877: BEGIN
1878:
1879:
1880: Begin
1881: lv_customer_id := fnd_profile.value('AHL_APS_CUSTOMER_NAME');
1882:
1883: Exception
1884: When others then
1885: lv_customer_id := null;

Line 2109: --pwindow := NVL(fnd_profile.value('MSC_COLL_TIME_WINDOW_IBUC_HISTORY') ,0);

2105:
2106: BEGIN
2107:
2108: If (pREFRESH_TYPE = 'C' OR pREFRESH_TYPE = 'P') then
2109: --pwindow := NVL(fnd_profile.value('MSC_COLL_TIME_WINDOW_IBUC_HISTORY') ,0);
2110: lv_start_date := TRUNC(SYSTIMESTAMP-(pWINDOW*30+5));
2111: lv_purge_flag := 'Y';
2112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Value '|| pwindow );
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Start Date of the History window calculated based on profile '||lv_start_date);

Line 2248: prf_end_date := nvl(fnd_profile.value('MSC_FIXED_DATE_IBUC_HISTORY'),0) ;

2244: orig_st_date := trunc(pSTART_DATE);
2245: lv_purge_flag := pPURGE_FLAG;
2246:
2247: BEGIN
2248: prf_end_date := nvl(fnd_profile.value('MSC_FIXED_DATE_IBUC_HISTORY'),0) ;
2249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Profile value for Fixed Date '||prf_end_date);
2250: EXCEPTION
2251: WHEN OTHERS THEN
2252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Please enter the value of profile ' ||