DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on CSF_MAP_ACC_HRS_PKG

Line 1909: l_access_hours CSF_MAP_ACC_HRS_PKG.access_hours_rec;

1905: L_EXCEP_NO_COVER_TIME EXCEPTION;
1906:
1907: /*vgujarat - modified for access hour ER 9675504*/
1908:
1909: l_access_hours CSF_MAP_ACC_HRS_PKG.access_hours_rec;
1910:
1911: l_sw_first_start varchar2(4);
1912: l_sw_first_end varchar2(4);
1913: l_sw_second_start varchar2(4);

Line 2051: 1.Get the Access Hour information from the api CSF_MAP_ACC_HRS_PKG.Query_ROW

2047: Reg :The application should take the access hours into account when calculating SLAs on the SR.
2048:
2049: The Respond by and Resolve by dates should be pushed out when customer site is unavailable between the time the service request is logged and the Respond by time.
2050:
2051: 1.Get the Access Hour information from the api CSF_MAP_ACC_HRS_PKG.Query_ROW
2052: 2.For each and every day concatenate the hour and minute portion of first_start,first_end,second_start and second_end
2053: ex) if 09:30 = > 0930
2054: 3.Calculate the Service Window which is derived from the covered time and the access hours
2055: 4.Pass this calculated service window to the OUT variable X_BP_CovTimes

Line 2067: CSF_MAP_ACC_HRS_PKG.Query_ROW(

2063:
2064:
2065:
2066: -- Calling the Field Service API to get the Access Hours detail
2067: CSF_MAP_ACC_HRS_PKG.Query_ROW(
2068: p_customer_id => Lx_cust_id,
2069: p_customer_site_id => Lx_cust_site_id,
2070: p_customer_location_id => Lx_cust_loc_id,
2071: x_access_hours => l_access_hours