1 PACKAGE GMO_SWORKBENCH_PVT AS
2 /* $Header: GMOVSWBS.pls 120.2 2007/08/06 06:09:10 rvsingh noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(40) := 'GMO_SWORKBENCH_PVT';
4 PROCEDURE UPDATE_PLANNING_STATUS
5 (
6 P_API_VERSION IN NUMBER,
7 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9 X_MSG_COUNT OUT NOCOPY NUMBER,
10 X_MSG_DATA OUT NOCOPY VARCHAR2,
11 P_RESERVATION_ID IN NUMBER,
12 P_DISPENSE_ID IN NUMBER,
13 P_DISPENSED_DATE IN DATE,
14 P_DISPENSE_TYPE IN VARCHAR2,
15 P_DISPENSE_AREA_ID IN NUMBER,
16 P_DISP_ORG_ID IN NUMBER
17 );
18 FUNCTION GET_TASK_PERCENTAGE(area_id number,max_no_of_tasks number,date_value Date) RETURN Number;
19 FUNCTION GET_TASK_PERCENTAGE(area_id number,max_no_of_tasks number,date_value Date,oper NUMBER) RETURN Number;
20 FUNCTION GET_WEEKLY_TASK_PERCENTAGE(area_id number,max_no_of_tasks number,week_start_date Date,week_end_date Date) RETURN Number;
21 FUNCTION GET_WEEKLY_TASK_PERCENTAGE(area_id number,max_no_of_tasks number,week_start_date Date,week_end_date Date,oper NUMBER) RETURN Number;
22
23 FUNCTION GET_HOURS(timevalue varchar2)return number;
24 FUNCTION get_MINUTES(timevalue varchar2)return number;
25 function get_days(timevalue varchar2)return number;
26
27
28 procedure create_material_reservation(
29 p_org_id IN NUMBER
30 ,p_material_detail_id IN NUMBER
31 ,p_resv_qty IN NUMBER DEFAULT NULL
32 ,p_sec_resv_qty IN NUMBER DEFAULT NULL
33 ,p_resv_um IN VARCHAR2 DEFAULT NULL
34 ,p_subinventory IN VARCHAR2 DEFAULT NULL
35 ,p_locator_id IN NUMBER DEFAULT NULL
36 ,p_lot_number IN VARCHAR2 DEFAULT NULL
37 ,x_res_id OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 , x_msg_count OUT NOCOPY NUMBER
40 ,x_return_status OUT NOCOPY VARCHAR2
41 );
42 PROCEDURE create_material_reservation (
43 p_matl_dtl_rec IN gme_material_details%ROWTYPE
44 ,p_resv_qty IN NUMBER DEFAULT NULL
45 ,p_sec_resv_qty IN NUMBER DEFAULT NULL
46 ,p_resv_um IN VARCHAR2 DEFAULT NULL
47 ,p_subinventory IN VARCHAR2 DEFAULT NULL
48 ,p_locator_id IN NUMBER DEFAULT NULL
49 ,p_lot_number IN VARCHAR2 DEFAULT NULL
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 ,x_return_status OUT NOCOPY VARCHAR2);
53 PROCEDURE validate_mtl_for_reservation(
54 p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 , x_msg_count OUT NOCOPY NUMBER
57 ,x_return_status OUT NOCOPY VARCHAR2);
58 PROCEDURE update_reservation (
59 p_reservation_id IN NUMBER
60 ,p_revision IN VARCHAR2 DEFAULT NULL
61 ,p_subinventory IN VARCHAR2 DEFAULT NULL
62 ,p_locator_id IN NUMBER DEFAULT NULL
63 ,p_lot_number IN VARCHAR2 DEFAULT NULL
64 ,p_new_qty IN NUMBER DEFAULT NULL
65 ,p_new_sec_qty IN NUMBER DEFAULT NULL
66 ,p_new_uom IN VARCHAR2 DEFAULT NULL
67 ,p_new_date IN DATE DEFAULT NULL
68 ,x_return_status OUT NOCOPY VARCHAR2);
69 PROCEDURE query_reservation (
70 p_reservation_id IN NUMBER
71 ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
72 ,x_return_status OUT NOCOPY VARCHAR2);
73
74 END;
75