DBA Data[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;