1 PACKAGE cz_atp_callback_util AUTHID CURRENT_USER AS
2 /* $Header: czatpcus.pls 115.10 2003/09/22 21:48:58 qmao ship $ */
3
4 -- Global constants representing cz_atp_requests.item_key_type values
5 G_ITEM_KEY_BOM_NODE CONSTANT NUMBER := 1;
6 G_ITEM_KEY_PS_NODE CONSTANT NUMBER := 2;
7
8 TYPE char30_arr IS TABLE OF VARCHAR2(30);
9
10 PROCEDURE delete_atp_recs (p_config_session_key IN VARCHAR2);
11
12 PROCEDURE insert_atp_rec (p_config_session_key IN VARCHAR2,
13 p_seq_nbr IN NUMBER,
14 p_ps_node_id IN NUMBER,
15 p_item_key IN VARCHAR2,
16 p_quantity IN NUMBER,
17 p_uom_code IN VARCHAR2,
18 p_config_item_id IN NUMBER,
19 p_parent_config_item_id IN NUMBER,
20 p_ato_config_item_id IN NUMBER,
21 p_component_sequence_id IN NUMBER);
22
23 PROCEDURE run_atp_callback(p_pkg_name IN VARCHAR2,
24 p_proc_name IN VARCHAR2,
25 p_config_session_key IN VARCHAR2,
26 p_warehouse_id IN NUMBER,
27 p_ship_to_org_id IN NUMBER,
28 p_customer_id IN NUMBER,
29 p_customer_site_id IN NUMBER,
30 p_requested_date IN DATE,
31 p_ship_to_group_date OUT NOCOPY DATE);
32
33 FUNCTION inv_item_id_from_item_key(p_item_key IN VARCHAR2)
34 RETURN NUMBER;
35
36 FUNCTION component_code_from_item_key(p_item_key IN VARCHAR2)
37 RETURN VARCHAR2;
38
39 FUNCTION component_code_tokens(p_component_code IN VARCHAR2)
40 RETURN char30_arr;
41
42 FUNCTION item_key_tokens(p_item_key IN VARCHAR2)
43 RETURN char30_arr;
44
45 FUNCTION validation_org_for_cfg_model(p_config_session_key IN VARCHAR2)
46 RETURN NUMBER;
47
48 FUNCTION root_bom_config_item_id(p_config_session_key IN VARCHAR2)
49 RETURN NUMBER;
50
51 END cz_atp_callback_util;