1 PACKAGE WMS_LMS_EXPECTED_RES AUTHID CURRENT_USER AS
2 /* $Header: WMSLMERS.pls 120.0 2005/06/16 03:58 viberry noship $ */
3
4
5 /**
6 * This is a Package that has procedures/functions that
7 * assists in estimating time/resource for various activities like
8 * inbound, outbound, Warehousing Activities
9 **/
10
11
12 G_PKG_NAME VARCHAR2(30) := 'WMS_LMS_EXPECTED_RES';
13
14
15 /** This program populates the WMS_ELS_EXP_RESOURCE table, which is the base requirement <br>
16 * for Expected Resource Requirements Analysis . WMS_ELS_EXP_RESOURCE table essentially <br>
17 * has all the information for all future work that is expected in a Warehouse whether <br>
18 * it is an Inbound, Outbound, Warehousing or Manufacturing activity. Based on this <br>
19 * information the expected resource requirement will be calculated. <br>
20 * The following is list if the inputs for populating this table. <br>
21 * 1. Receiving Inbound
22 * o Expected Purchase Order Receipts to be received in the given time frame <br>
23 * o Expected ASN material to be received in the given time frame <br>
24 * o Expected Internal Transfers to be received in the given time frame <br>
25 * o Expected RMAs to be received in the given time frame <br>
26 * 2. Receiving Inbound <br>
27 * o Material that is received, but needs to be putaway <br>
28 * 3. Inventory Accuracy <br>
29 * Cycle count tasks outstanding <br>
30 * 4. Outbound Shipping / Manufacturing <br>
31 * o Unreleased / pending / queued / dispatched tasks for Sales orders,<br>
32 * manufacturing component picks, and internal orders <br>
33 * 5. Manufacturing Putaways <br>
34 * 6. Pending and outstanding replenishment tasks <br>
35
36 * @param x_return_status return_status(OUT Parameter)
37 * @param x_msg_count Count of the recent message(OUT Parameter)
38 * @param x_msg_data Data of the message(OUT Parameter)
39 * @param p_org_id The organization Id
40 */
41
42
43 PROCEDURE POPULATE_EXPECTED_WORK
44 ( x_return_status OUT NOCOPY VARCHAR2
45 , x_msg_count OUT NOCOPY VARCHAR2
46 , x_msg_data OUT NOCOPY VARCHAR2
47 , p_org_id IN NUMBER
48 );
49
50
51
52 /* We would do the following in this procedure <br>
53
54 * Delete all the rows that are already populated in the WMS_ELS_EXP_RESOURCE for <br>
55 * that organization. This is done so that no old rows are left in the table and the <br>
56 * table can be freshly populated with expected work. This also ensures that all the <br>
57 * tasks and expected work that is already done is flushed out and is not accounted any more.<br>
58 *
59 * Populate the WMS_ELS_EXP_RESOURCE table with the fresh set of expected work for <br>
60 * the given data period(populated in the global setup).This will be done by calling <br>
61 * the program WMS_ELS_EXPECTED_RES. Populate_Expecetd_Work.<br>
62 *
63 * Do the matching of the rows in WMS_ELS_EXP_RESOURCE table with the setup rows <br>
64 * in WMS_ELS_INDIVIDUAL_TASKS_B using the where clause for that setup row(dynamic SQL), <br>
65 * starting with the setup row having the least sequence number. Once a match is found <br>
66 * stamp the Estimated_time column in WMS_ELS_EXP_RESOURCE table with the time required <br>
67 * to complete the transaction. Also stamp the Expecetd_Resource column based on the global <br>
68 * setup.<br>
69 *
70 * The parameters p_data_period_unit, p_data_period_value,<br>
71 * p_Num_work_hrs_day ,p_Utilization_rate will not be directly used in this <br>
72 * program. They are being passed in to retain the link that at the time of <br>
73 * running the concurrent what was the value of these global parameters <br>
74 *
75 * @param p_org_id The organization Id
76 * @param errbuf This is the out message having the buffer of the return message
77 * @param retcode This variable is a out variable having the return code of <br)
78 * the is program. Whether this program is a success,<br>
79 * warning or a failure <br>
80 * @parame p_data_period_unit This parameter signifies what is the unit of measure <br>
81 * of data period(days,weeks etc) <br>
82 * @param p_data_period_value This gives the value of data period example 2(days).<br>
83 * here 2 is data period value <br>
84 * @param p_Num_work_hrs_day Number of working hrs per day
85 * @param p_Utilization_rate What is the utilzation rate of the employees
86 */
87
88 PROCEDURE MATCH_RATE_EXP_RESOURCE (
89 errbuf OUT NOCOPY VARCHAR2
90 , retcode OUT NOCOPY NUMBER
91 , p_org_id IN NUMBER
92 , p_data_period_unit IN NUMBER
93 , p_data_period_value IN NUMBER
94 , p_Num_work_hrs_day IN NUMBER
95 , p_Utilization_rate IN NUMBER
96 );
97
98 END WMS_LMS_EXPECTED_RES;
99