1: PACKAGE BODY CSD_REPAIR_ACTUALS_PVT as
2: /* $Header: csdvactb.pls 120.1 2008/02/09 01:02:32 takwong ship $ csdvactb.pls*/
3:
4: -- ---------------------------------------------------------
5: -- Define global variables
50: l_event_level number := FND_LOG.LEVEL_EVENT;
51: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
52: l_error_level number := FND_LOG.LEVEL_ERROR;
53: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
54: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.CREATE_REPAIR_ACTUALS';
55:
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REPAIR_ACTUALS';
57: l_api_version CONSTANT NUMBER := 1.0;
58: l_msg_count NUMBER;
301: l_event_level number := FND_LOG.LEVEL_EVENT;
302: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
303: l_error_level number := FND_LOG.LEVEL_ERROR;
304: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
305: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.UPDATE_REPAIR_ACTUALS';
306:
307: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REPAIR_ACTUALS';
308: l_api_version CONSTANT NUMBER := 1.0;
309: l_msg_count NUMBER;
566: l_event_level number := FND_LOG.LEVEL_EVENT;
567: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
568: l_error_level number := FND_LOG.LEVEL_ERROR;
569: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
570: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.DELETE_REPAIR_ACTUALS';
571:
572: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REPAIR_ACTUALS';
573: l_api_version CONSTANT NUMBER := 1.0;
574: l_msg_count NUMBER;
837: l_event_level number := FND_LOG.LEVEL_EVENT;
838: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
839: l_error_level number := FND_LOG.LEVEL_ERROR;
840: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
841: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.LOCK_REPAIR_ACTUALS';
842:
843: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_REPAIR_ACTUALS';
844: l_api_version CONSTANT NUMBER := 1.0;
845: l_msg_count NUMBER;
970: p_data => x_msg_data );
971:
972: END LOCK_REPAIR_ACTUALS;
973:
974: End CSD_REPAIR_ACTUALS_PVT;