PACKAGE BODY: APPS.AMS_QP_INS_PVT

Source

1 PACKAGE BODY AMS_QP_INS_PVT as
2 /* $Header: amsvqisb.pls 115.5 2002/09/12 19:14:56 julou ship $ */
3 
4 --
5 -- NAME
6 --   AMS_QP_INS_PVT
7 --
8 -- HISTORY
9 --   11/19/1999		   ptendulk     Created
10 --
11 G_PKG_NAME      CONSTANT VARCHAR2(30):='AMS_QP_INS_PVT';
12 G_FILE_NAME     CONSTANT VARCHAR2(12):='amsvqisb.pls';
13 
14 --------------- start of comments --------------------------
15 -- NAME
16 --    Create_MappingRule
17 --
18 -- USAGE
19 --    This Procedure will map the Attributes by calling
20 --    different QP APIs
21 -- NOTES
22 --
23 -- HISTORY
24 --   01/26/2000        ptendulk            created
25 --   06/10/2002        aranka              This Package is not being used;
26 -- End of Comments
27 --
28 --------------- end of comments ----------------------------
29 PROCEDURE Create_MappingRule
30 IS
31 BEGIN
32 /*
33     QP_ATTR_MAPPING_PUB.Add_Attrib_Mapping_Rule
34     (	p_context_name		=> 'Market Segment' ,	     -- Context defined in Flexfield
35 	p_context_type		=> 'Q'		,	     -- For Qualifier
36 	p_condition_name	=> 'AMS Mkt Segment Context', -- Name of the Condition
37 	p_pricing_type		=> 'L'	,		     -- for Line Request
38 	p_src_sys_code		=> 'AMS',		     -- Confirm
39 	p_attribute_code	=> 'QUALIFIER_ATTRIBUTE1',    -- Map Attriburte1 to Market Segment
40 	p_src_type		=> 'API_MULTIREC',	     -- As we are returning Table
41 	p_src_api_pkg		=> 'AMS_MKS_QP_PVT'	,
42 	p_src_api_fn		=> 'AMS_MKS_QP_PVT.get_market_segment(AMS_MKS_QP_PVT.ams_tmp_gbl_str.party_id)'	,
43 	p_other_src		=> NULL
44 	) ;
45 
46     QP_ATTR_MAPPING_PUB.Delete_Attrib_Mapping_Rule
47     (	p_context_name		=> 'Market Segment' ,	     -- Context defined in Flexfield
48 	p_context_type		=> 'Q'		,	     -- For Qualifier
49 	p_condition_name	=> 'AMS Mkt Segment Context', -- Name of the Condition
50 	p_pricing_type		=> 'L'	,		     -- for Line Request
51 	p_src_sys_code		=> 'AMS',		     -- Confirm
52 	p_attribute_code	=> 'QUALIFIER_ATTRIBUTE1') ;
53 
54 
55 
56     QP_ATTR_MAPPING_PUB.Update_Attrib_Mapping_Rule
57     (	p_context_name		=> 'Market Segment' ,	     -- Context defined in Flexfield
58 	p_context_type		=> 'Q'		,	     -- For Qualifier
59 	p_condition_name	=> 'AMS Mkt Segment Context', -- Name of the Condition
60 	p_pricing_type		=> 'L'	,		     -- for Line Request
61 	p_src_sys_code		=> 'AMS',		     -- Confirm
62 	p_attribute_code	=> 'QUALIFIER_ATTRIBUTE1',    -- Map Attriburte1 to Market Segment
63 	p_src_type		=> 'API_MULTIREC',	     -- As we are returning Table
64 	p_src_api_pkg		=> 'AMS_MKS_QP_PVT'	,
65 	p_src_api_fn		=> 'AMS_MKS_QP_PVT.get_market_segment123(AMS_MKS_QP_PVT.ams_tmp_gbl_str.party_id)'	,
66 	p_other_src		=> NULL
67 	) ;
68 
69     QP_ATTR_MAPPING_PUB.Add_Condition
70    (	p_context_name		=> 'AMS ITEM '
71    ,	p_condition_name	=> 'Ams Item Cat'
72    ,  	p_condition_descr	=> 'Test Condi Fro AMS'
73    ,	p_context_type		=> 'Q'
74    ,	p_pricing_type		=> 'L'
75    ,	p_src_sys_code		=> 'AMS' ) ;
76 
77 
78    QP_ATTR_MAPPING_PUB.Delete_Condition
79    (	p_context_name		=> 'AMS ITEM '
80    ,	p_condition_name	=> 'Ams Item Cat'
81    ,	p_context_type		=> 'Q'
82    ,	p_pricing_type		=> 'L' ) ;
83 
84 
85 */
86         NULL;
87 END Create_MappingRule ;
88 
89 
90 
91 END AMS_QP_INS_PVT ;