DBA Data[Home] [Help]

PACKAGE: APPS.WMS_RULE_11

Source


1 PACKAGE WMS_RULE_11 AS
2                    procedure open_curs (
3                    p_cursor                     IN OUT NOCOPY WMS_RULE_PVT.CV_PUT_TYPE,
4                    p_organization_id            IN NUMBER,
5                    p_inventory_item_id          IN NUMBER,
6        p_transaction_type_id        IN NUMBER,
7                    p_subinventory_code          IN VARCHAR2,
8                    p_locator_id                 IN NUMBER,
9                    p_pp_transaction_temp_id     IN NUMBER,
10        p_restrict_subs_code   IN NUMBER,
11        p_restrict_locs_code   IN NUMBER,
12        p_project_id     IN NUMBER,
13        p_task_id      IN NUMBER,
14                    x_result                     OUT NOCOPY NUMBER);
15 
16                    PROCEDURE fetch_one_row  (
17                       p_cursor              IN  WMS_RULE_PVT.CV_PUT_TYPE,
18                       x_subinventory_code   OUT NOCOPY VARCHAR2,
19                       x_locator_id          OUT NOCOPY NUMBER,
20                       x_project_id          OUT NOCOPY NUMBER,
21                       x_task_id             OUT NOCOPY NUMBER,
22                       x_return_status       OUT NOCOPY NUMBER);
23 
24                    PROCEDURE close_curs(p_cursor IN  WMS_RULE_PVT.CV_PUT_TYPE );
25 
26     end WMS_RULE_11;