[Home] [Help]
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;