[Home] [Help]
PACKAGE: APPS.QP_MODIFIERS_ISETUP_IMP
Source
1 PACKAGE QP_MODIFIERS_ISETUP_IMP AS
2 /* $Header: QPMODIMS.pls 120.2 2006/07/07 19:29:37 rbagri noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- QPMODIMB.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Specifications of package QP_MODIFIERS_ISETUP_IMP
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 31-DEC-01 Anupam Jain Initial Creation
21 ***************************************************************************/
22 FUNCTION get_product_code (p_product_attr_context varchar2,
23 p_product_attr varchar2,
24 p_product_attr_val varchar2) RETURN VARCHAR2;
25
26
27 FUNCTION get_product_value (p_product_attr_context varchar2,
28 p_product_attr varchar2,
29 p_product_attr_val varchar2) RETURN VARCHAR2;
30
31
32 FUNCTION get_qualifier_code (p_qualifier_attr_context varchar2,
33 p_qualifier_attr varchar2,
34 p_qualifier_attr_val varchar2) RETURN VARCHAR2;
35
36 FUNCTION get_qualifier_value (p_qualifier_attr_context varchar2,
37 p_qualifier_attr varchar2,
38 p_qualifier_attr_val varchar2) RETURN VARCHAR2;
39
40 PROCEDURE Import_Modifiers
41 (P_debug IN VARCHAR2 := 'N',
42 P_output_dir IN VARCHAR2 := NULL,
43 P_debug_filename IN VARCHAR2 := 'QP_Modifiers_debug.log',
44 P_modifier_list_XML IN CLOB,
45 P_modifier_list_lines_XML IN CLOB,
46 P_pricing_attributes_XML IN CLOB,
47 P_Qualifiers_XML IN CLOB,
48 X_return_status OUT NOCOPY VARCHAR2,
49 X_msg_count OUT NOCOPY NUMBER,
50 X_G_MSG_DATA OUT NOCOPY Long);
51 END QP_MODIFIERS_ISETUP_IMP;