PACKAGE: APPS.CZ_PRC_CALLBACK_UTIL

Source

1 PACKAGE cz_prc_callback_util AUTHID CURRENT_USER AS
2 /* $Header: czprcbus.pls 115.15 2004/03/02 15:42:22 askhacha ship $ */
3 
4   -- Global constants representing cz_pricing_structures.item_key_type values
5   G_ITEM_KEY_BOM_NODE CONSTANT NUMBER := 1;
6   G_ITEM_KEY_PS_NODE CONSTANT NUMBER := 2;
7 
8   -- Global constants representing available pricing types
9   G_PRC_TYPE_LIST CONSTANT VARCHAR2(10) := 'LIST';
10   G_PRC_TYPE_SELLING CONSTANT VARCHAR2(10) := 'SELLING';
11   G_PRC_TYPE_BOTH CONSTANT VARCHAR2(10) := 'BOTH';
12 
13   PROCEDURE insert_pricing_table (p_pricing_tbl IN system.cz_price_tbl_type);
14 
15   PROCEDURE insert_pricing_rec (p_config_session_key IN VARCHAR2,
16                                 p_seq_nbr IN NUMBER,
17                                 p_ps_node_id IN NUMBER,
18                                 p_item_key IN VARCHAR2,
19                                 p_quantity IN NUMBER,
20                                 p_uom_code IN VARCHAR2,
21                                 p_config_item_id IN NUMBER,
22                                 p_parent_config_item_id IN NUMBER);
23 
24   PROCEDURE delete_pricing_recs (p_config_session_key IN VARCHAR2);
25 
26   PROCEDURE run_pricing_callback(p_pkg_name IN VARCHAR2,
27                                  p_proc_name IN VARCHAR2,
28                                  p_config_session_key IN VARCHAR2,
29                                  p_price_type IN VARCHAR2,
30                                  p_total_price OUT NOCOPY NUMBER);
31 
32   PROCEDURE run_mls_pricing_callback(p_pkg_name IN VARCHAR2,
33 				     p_proc_name IN VARCHAR2,
34 				     p_config_session_key IN VARCHAR2,
35 				     p_price_type IN VARCHAR2,
36 				     p_total_price OUT NOCOPY NUMBER,
37 				     p_currency_code OUT NOCOPY VARCHAR2);
38 
39   FUNCTION root_bom_config_item_id(p_config_session_key IN VARCHAR2)
40   RETURN NUMBER;
41 
42 END cz_prc_callback_util;