1 PACKAGE inv_reservation_util_pvt AUTHID CURRENT_USER AS
2 /* $Header: INVRSV2S.pls 120.1 2005/06/20 11:10:17 appldev ship $ */
3
4 PROCEDURE set_file_info
5 (
6 p_file_name IN VARCHAR2
7 );
8
9 PROCEDURE close_file;
10
11 PROCEDURE write_to_logfile
12 (
13 x_return_status OUT NOCOPY VARCHAR2
14 , p_msg_to_append IN VARCHAR2
15 , p_appl_short_name IN VARCHAR2
16 , p_file_name IN VARCHAR2
17 , p_program_name IN VARCHAR2
18 , p_new_or_append IN NUMBER
19 );
20
21 PROCEDURE search_item_cache
22 (
23 x_return_status OUT NOCOPY VARCHAR2
24 , p_inventory_item_id IN NUMBER
25 , p_organization_id IN NUMBER
26 , x_index OUT NOCOPY NUMBER
27 );
28
29 PROCEDURE add_item_cache
30 (
31 x_return_status OUT NOCOPY VARCHAR2
32 , p_item_record IN inv_reservation_global.item_record
33 , x_index OUT NOCOPY NUMBER
34 );
35
36 PROCEDURE search_organization_cache
37 (
38 x_return_status OUT NOCOPY VARCHAR2
39 , p_organization_id IN NUMBER
40 , x_index OUT NOCOPY NUMBER
41 );
42
43 PROCEDURE add_organization_cache
44 (
45 x_return_status OUT NOCOPY VARCHAR2
46 , p_organization_record IN inv_reservation_global.organization_record
47 , x_index OUT NOCOPY NUMBER
48 );
49
50 PROCEDURE search_demand_cache
51 (
52 x_return_status OUT NOCOPY VARCHAR2
53 , p_demand_source_type_id IN NUMBER
54 , p_demand_source_header_id IN NUMBER
55 , p_demand_source_line_id IN NUMBER
56 , p_demand_source_name IN VARCHAR2
57 , x_index OUT NOCOPY NUMBER
58 );
59
60 PROCEDURE add_demand_cache
61 (
62 x_return_status OUT NOCOPY VARCHAR2
63 , p_demand_record IN inv_reservation_global.demand_record
64 , x_index OUT NOCOPY NUMBER
65 );
66
67 PROCEDURE search_supply_cache
68 (
69 x_return_status OUT NOCOPY VARCHAR2
70 , p_supply_source_type_id IN NUMBER
71 , p_supply_source_header_id IN NUMBER
72 , p_supply_source_line_id IN NUMBER
73 , p_supply_source_name IN VARCHAR2
74 , x_index OUT NOCOPY NUMBER
75 );
76
77 PROCEDURE add_supply_cache
78 (
79 x_return_status OUT NOCOPY VARCHAR2
80 , p_supply_record IN inv_reservation_global.supply_record
81 , x_index OUT NOCOPY NUMBER
82 );
83
84 PROCEDURE search_sub_cache
85 (
86 x_return_status OUT NOCOPY VARCHAR2
87 , p_subinventory_code IN VARCHAR2
88 , p_organization_id IN NUMBER
89 , x_index OUT NOCOPY NUMBER
90 );
91
92 PROCEDURE add_sub_cache
93 (
94 x_return_status OUT NOCOPY VARCHAR2
95 , p_sub_record IN inv_reservation_global.sub_record
96 , x_index OUT NOCOPY NUMBER
97 );
98
99 -- Function
100 -- locator_control
101 -- Description
102 -- Determine whether locator control is on.
103 -- uses lookup code from mtl_location_controls.
104 -- see mtl_system_items in the TRM for more
105 -- information.
106 -- mtl_location_control lookup code
107 -- 1 no locator control
108 -- 2 prespecified locator control
109 -- 3 dynamic entry locator control
110 -- 4 locator control determined at subinventory level
111 -- 5 locator control determined at item level
112 -- Since this package is used by reservation only,
113 -- we will no have dynamic entry locator control at all
114 -- (if the input is 3, we treats it as 2);
115 -- also as create, update, delete, or transfer a reservation
116 -- has no impact on on hand quantity, we will not check
117 -- negative balance as we do in validation module for
118 -- cycle count transactions.
119 -- Return Value
120 -- a number in (1,2,4,5), as defined in mtl_location_control
121 -- lookup code
122 FUNCTION locator_control
123 (
124 p_org_control IN NUMBER
125 , p_sub_control IN NUMBER
126 , p_item_control IN NUMBER DEFAULT NULL
127 ) RETURN NUMBER;
128
129 /*** {{ R12 Enhanced reservations code changes ***/
130 -- add the wip record cache
131 PROCEDURE get_wip_cache
132 (
133 x_return_status OUT NOCOPY VARCHAR2
134 , p_wip_entity_id IN NUMBER
135 );
136
137
138 /*** End R12 }} ***/
139 END inv_reservation_util_pvt;