1 PACKAGE CZ_OM_ATP_UTIL AUTHID CURRENT_USER AS
2 /* $Header: czomatps.pls 115.7 2002/11/27 17:07:31 askhacha ship $ */
3 -- Start of Comments
4 -- Package name: CZ_OM_ATP_UTIL
5 --
6 -- Function: Package contains all CZ ATP utilities to support
7 -- Order Management.
8 --
9 -- NOTES: 1. item quantities must always be provided in the item's
10 -- primary unit of measure
11 --
12 -- End Of Comments
13
14 -- Global constants holding return status values.
15
16 G_RET_STS_SUCCESS CONSTANT CHAR := 'S';
17 G_RET_STS_ERROR CONSTANT CHAR := 'E';
18 G_RET_STS_UNEXP_ERROR CONSTANT CHAR := 'U';
19
20 -- Procedure insert_atp_request
21 -- Description:
22 -- Inserts item data into the PLSQL record set of MRP_ATP_PUB.ATP_Rec_Typ records for an -- ATP check
23 -- on an item. The insert_atp_request procedure should be called for
24 -- each item visible in the Configurator window.
25 --
26 -- The p_atp_group_id parameter should be unique if a new group ID should
27 -- be created. Subsequent calls to insert_atp_request can use the group
28 -- ID returned from this first call. Note that p_sequence_number must
29 -- be different for each call for a particular ATP group ID.
30
31
32 PROCEDURE insert_atp_request (p_inventory_item_id IN NUMBER,
33 p_organization_id IN NUMBER,
34 p_quantity IN NUMBER,
35 p_atp_group_id IN OUT NOCOPY NUMBER,
36 p_sequence_number IN NUMBER,
37 p_item_type_code IN NUMBER,
38 p_session_id IN NUMBER,
39 p_return_status OUT NOCOPY VARCHAR2,
40 p_error_message OUT NOCOPY VARCHAR2);
41
42 -- Procedure run_atp_check
43 -- Usage:
44 -- Called from configurator screen to check ATP for a group of items
45 -- Description:
46 -- Calls MRP_ATP_PUB.Call_ATP for items in PLSQL record set identified by ATP group ID .
47 -- Updates records with ATP results for each item
48
49 PROCEDURE run_atp_check (p_return_status OUT NOCOPY VARCHAR2,
50 p_error_message OUT NOCOPY VARCHAR2,
51 p_atp_group_id IN NUMBER,
52 p_session_id IN NUMBER);
53
54 -- Procedure get_atp_result
55 -- Description:
56 -- Retrieves earliest ATP date result(ship_date) from PLSQL record set for the
57 -- item identified by ATP group ID sequence_number.
58
59 PROCEDURE get_atp_result (p_return_status OUT NOCOPY VARCHAR2,
60 p_error_message OUT NOCOPY VARCHAR2,
61 p_earliest_atp_date OUT NOCOPY DATE,
62 p_atp_group_id IN NUMBER,
63 p_session_id IN NUMBER,
64 p_sequence_number IN NUMBER DEFAULT 1);
65
66
67 -- Procedure clear_atp_data
68 -- Description:
69 -- Clears local package variables which hold data for an ATP group.
70
71 PROCEDURE clear_atp_data (p_return_status OUT NOCOPY VARCHAR2,
72 p_error_message OUT NOCOPY VARCHAR2,
73 p_atp_group_id IN NUMBER,
74 p_session_id IN NUMBER);
75
76 END CZ_OM_ATP_UTIL;