[Home] [Help]
1313: ------------------- Load Error Status -------------------------------
1314: --BEGIN HXT11i1
1315: /***************************************************************************
1316: ** Modify Load_Error_Status to select the Value stored in ERR_TYPE from **
1317: ** HXT_ERRORS rather then selecting a hard coded 'E' if the record exists. **
1318: ***************************************************************************/
1319: FUNCTION load_error_status (a_hrw_id IN NUMBER)
1320: RETURN VARCHAR2
1321: IS
1323:
1324: CURSOR error_status
1325: IS
1326: SELECT err_type
1327: FROM hxt_errors err
1328: WHERE err.hrw_id = a_hrw_id;
1329: BEGIN
1330: OPEN error_status;
1331: FETCH error_status INTO returned_status;
1523: * FUNCTION Load_Tim_Error_Status -- ER177 SDM 09-03-98 *
1524: * *
1525: * Purpose *
1526: * Select and return the value ERR_TYPE from the Table *
1527: * HXT_ERRORS where the tim_id passed in = HXT_ERRORS.TIM_ID. *
1528: * *
1529: * Returns *
1530: * returned_status - Value of ERR_TYPE where tim_id passed in *
1531: * equals HXT_ERRORS.TIM_ID.0 *
1527: * HXT_ERRORS where the tim_id passed in = HXT_ERRORS.TIM_ID. *
1528: * *
1529: * Returns *
1530: * returned_status - Value of ERR_TYPE where tim_id passed in *
1531: * equals HXT_ERRORS.TIM_ID.0 *
1532: * *
1533: * Arguments *
1534: * p_tim_id - Time Card ID *
1535: * *
1541:
1542: CURSOR error_status
1543: IS
1544: SELECT err_type
1545: FROM hxt_errors err
1546: WHERE err.tim_id = p_tim_id
1547: ORDER BY err_type; -- So that 'ERR' has precedence over 'WRN'
1548: BEGIN
1549: OPEN error_status;