1 PACKAGE WMS_LMS_LABOR_PRODUCTIVITY AUTHID CURRENT_USER AS
2 /* $Header: WMSLMLPS.pls 120.1 2005/06/17 03:52 viberry noship $ */
3
4 --WMS_ELS_LABOR_PRODUCTIVITY Package
5 -- File : INV/WMS...B/S.pls
6 -- Content :
7 -- Description :
8 /**
9 * This is a Package that has procedures/functions that
10 * assists in estimating labor productivity
11 **/
12 -- Notes :
13 -- Modified : Fri Jul 30 13:28:37 GMT+05:30 2004
14
15 G_PKG_NAME VARCHAR2(30) := 'WMS_LMS_LABOR_PRODUCTIVITY';
16
17
18
19 /** This procedure will match all the transaction records in wms_els_trx_src <br>
20 * table with the setup rows in wms_els_individual_tasks_b and wms_els_grouped_tasks_b <br>
21 * It will DO the following <br>
22 *
23 * 1) do the matching of transaction data with els data. Start with the setup row <br>
24 * with least sequnce.Update the els_data_id column of WMS_ELS_TRX_SRC table <br>
25 * with the eld_data_id of the setup line with which the matching was found <br>
26 * update the zone and item category columns with zone_id's and item_category_id of the <br>
27 * els data row with which the match was found.<br>
28 * 2). Update the travel and the idle time in the for the transaction row by <br>
29 * considering the threshold value.<br>
30 * 3) update the ratings and the score <br>
31 * 4) Do the matching for groups based on grouped task identifier <br>
32
33 * @param p_org_id The organization Id
34 * @param errbuf This is the out message having the buffer of the return message
35 * @param retcode This variable is a out variable having the return code of the is program.
36 Whether this program is a success, warning or a failure
37 */
38
39 PROCEDURE MATCH_RATE_TRX_RECORDS (
40 errbuf OUT NOCOPY VARCHAR2
41 , retcode OUT NOCOPY NUMBER
42 , p_org_id IN NUMBER
43 );
44
45
46
47
48
49
50 END WMS_LMS_LABOR_PRODUCTIVITY;
51
52