1 PACKAGE gme_reservations_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVRSVS.pls 120.2.12010000.1 2008/07/25 10:31:52 appldev ship $ */
3 TYPE g_msca_resvns IS REF CURSOR;
4
5 PROCEDURE get_reservations_msca (
6 p_organization_id IN NUMBER
7 ,p_batch_id IN NUMBER
8 ,p_material_detail_id IN NUMBER
9 ,p_subinventory_code IN VARCHAR2
10 ,p_locator_id IN NUMBER
11 ,p_lot_number IN VARCHAR2
12 ,x_return_status OUT NOCOPY VARCHAR2
13 ,x_error_msg OUT NOCOPY VARCHAR2
14 ,x_rsrv_cursor OUT NOCOPY g_msca_resvns);
15
16 PROCEDURE create_batch_reservations (
17 p_batch_id IN NUMBER
18 ,p_timefence IN NUMBER DEFAULT 1000
19 ,x_return_status OUT NOCOPY VARCHAR2);
20
21 PROCEDURE create_material_reservation (
22 p_matl_dtl_rec IN gme_material_details%ROWTYPE
23 ,p_resv_qty IN NUMBER DEFAULT NULL
24 ,p_sec_resv_qty IN NUMBER DEFAULT NULL
25 ,p_resv_um IN VARCHAR2 DEFAULT NULL
26 ,p_subinventory IN VARCHAR2 DEFAULT NULL
27 ,p_locator_id IN NUMBER DEFAULT NULL
28 ,p_lot_number IN VARCHAR2 DEFAULT NULL
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31 PROCEDURE get_material_reservations (
32 p_organization_id IN NUMBER
33 ,p_batch_id IN NUMBER
34 ,p_material_detail_id IN NUMBER
35 ,p_dispense_ind IN VARCHAR2 DEFAULT 'N'
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_reservations_tbl OUT NOCOPY gme_common_pvt.reservations_tab);
38
39 FUNCTION reservation_fully_specified (
40 p_reservation_rec IN mtl_reservations%ROWTYPE
41 ,p_item_location_control IN NUMBER
42 ,p_item_restrict_locators IN NUMBER)
43 RETURN NUMBER;
44
45 PROCEDURE convert_partial_to_dlr (
46 p_reservation_rec IN mtl_reservations%ROWTYPE
47 ,p_material_dtl_rec IN gme_material_details%ROWTYPE
48 ,p_item_rec IN mtl_system_items%ROWTYPE
49 ,p_qty_check IN VARCHAR2 := fnd_api.g_false
50 ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
51 ,x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE delete_batch_reservations (
54 p_organization_id IN NUMBER
55 ,p_batch_id IN NUMBER
56 ,x_return_status OUT NOCOPY VARCHAR2);
57
58 PROCEDURE delete_material_reservations (
59 p_organization_id IN NUMBER
60 ,p_batch_id IN NUMBER
61 ,p_material_detail_id IN NUMBER
62 ,x_return_status OUT NOCOPY VARCHAR2);
63
64 PROCEDURE delete_reservation (
65 p_reservation_id IN NUMBER
66 ,x_return_status OUT NOCOPY VARCHAR2);
67
68 PROCEDURE get_reservation_dtl_qty (
69 p_reservation_rec IN mtl_reservations%ROWTYPE
70 ,p_uom_code IN VARCHAR2
71 ,x_qty OUT NOCOPY NUMBER
72 ,x_return_status OUT NOCOPY VARCHAR2);
73
74 PROCEDURE get_reserved_qty (
75 p_mtl_dtl_rec IN gme_material_details%ROWTYPE
76 ,p_supply_sub_only IN VARCHAR2 DEFAULT 'F'
77 ,x_reserved_qty OUT NOCOPY NUMBER
78 ,x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE relieve_reservation (
81 p_reservation_id IN NUMBER
82 ,p_prim_relieve_qty IN NUMBER
83 ,x_return_status OUT NOCOPY VARCHAR2);
84
85 PROCEDURE update_reservation (
86 p_reservation_id IN NUMBER
87 ,p_revision IN VARCHAR2 DEFAULT NULL
88 ,p_subinventory IN VARCHAR2 DEFAULT NULL
89 ,p_locator_id IN NUMBER DEFAULT NULL
90 ,p_lot_number IN VARCHAR2 DEFAULT NULL
91 ,p_new_qty IN NUMBER DEFAULT NULL
92 ,p_new_sec_qty IN NUMBER DEFAULT NULL
93 ,p_new_uom IN VARCHAR2 DEFAULT NULL
94 ,p_new_date IN DATE DEFAULT NULL
95 ,x_return_status OUT NOCOPY VARCHAR2);
96
97 PROCEDURE query_reservation (
98 p_reservation_id IN NUMBER
99 ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
100 ,x_return_status OUT NOCOPY VARCHAR2);
101
102 FUNCTION pending_reservations_exist (
103 p_organization_id IN NUMBER
104 ,p_batch_id IN NUMBER
105 ,p_material_detail_id IN NUMBER)
106 RETURN BOOLEAN;
107
108 PROCEDURE convert_dtl_reservation (
109 p_reservation_rec IN mtl_reservations%ROWTYPE
110 ,p_material_details_rec IN gme_material_details%ROWTYPE
111 ,p_qty_convert IN NUMBER := NULL
112 ,x_message_count OUT NOCOPY NUMBER
113 ,x_message_list OUT NOCOPY VARCHAR2
114 ,x_return_status OUT NOCOPY VARCHAR2);
115
116 PROCEDURE auto_detail_line (
117 p_material_details_rec IN gme_material_details%ROWTYPE
118 ,x_return_status OUT NOCOPY VARCHAR2);
119
120 PROCEDURE auto_detail_batch(
121 p_batch_rec IN GME_BATCH_HEADER%ROWTYPE,
122 p_timefence IN NUMBER DEFAULT 100000,
123 x_return_status OUT NOCOPY VARCHAR2);
124
125 --Bug#4604943 created new procedure to take care of validations
126 PROCEDURE validate_mtl_for_reservation(
127 p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE,
128 x_return_status OUT NOCOPY VARCHAR2);
129 END gme_reservations_pvt;