[Home] [Help]
204: /* Function to Find Resource Cost */
205:
206: FUNCTION OPMCO_GET_RSRC_COST( p_ORGN_CODE IN SY_ORGN_MST.ORGN_CODE%TYPE,
207: p_RESOURCE IN CR_RSRC_MST.RESOURCES%TYPE,
208: p_Cost_mthd IN cm_rsrc_dtl.cost_mthd_code%TYPE DEFAULT NULL,
209: p_usage_uom IN cm_rsrc_dtl.USAGE_UM%TYPE,
210: p_Transaction_date IN DATE)
211: RETURN NUMBER
212: IS
205:
206: FUNCTION OPMCO_GET_RSRC_COST( p_ORGN_CODE IN SY_ORGN_MST.ORGN_CODE%TYPE,
207: p_RESOURCE IN CR_RSRC_MST.RESOURCES%TYPE,
208: p_Cost_mthd IN cm_rsrc_dtl.cost_mthd_code%TYPE DEFAULT NULL,
209: p_usage_uom IN cm_rsrc_dtl.USAGE_UM%TYPE,
210: p_Transaction_date IN DATE)
211: RETURN NUMBER
212: IS
213: CURSOR CUR_COST_MTHD(l_orgn_code IN sy_orgn_mst.orgn_code%TYPE)
220: /* Local Variable Declaration */
221: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
222: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
223: l_co_code sy_orgn_mst.orgn_code%TYPE;
224: l_calendar_code cm_rsrc_dtl.CALENDAR_CODE%TYPE;
225: l_period_code cm_rsrc_dtl.PERIOD_CODE%TYPE;
226: l_rsrc_cost NUMBER;
227: BEGIN
228: l_cost_mthd:=p_cost_mthd;
221: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
222: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
223: l_co_code sy_orgn_mst.orgn_code%TYPE;
224: l_calendar_code cm_rsrc_dtl.CALENDAR_CODE%TYPE;
225: l_period_code cm_rsrc_dtl.PERIOD_CODE%TYPE;
226: l_rsrc_cost NUMBER;
227: BEGIN
228: l_cost_mthd:=p_cost_mthd;
229: IF p_cost_mthd IS NULL THEN
236: FROM SY_ORGN_MST
237: WHERE ORGN_CODE=p_ORGN_CODE;
238: END IF;
239: SELECT NOMINAL_COST into l_rsrc_cost
240: FROM CM_RSRC_DTL a,CM_CLDR_DTL b,CM_CLDR_HDR c
241: WHERE a.ORGN_CODE=p_ORGN_CODE
242: AND a.CALENDAR_CODE=b.CALENDAR_CODE
243: AND a.PERIOD_CODE=b.PERIOD_CODE
244: AND a.COST_MTHD_CODE=l_cost_mthd