APPS.AMS_QP_INS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

    QP_ATTR_MAPPING_PUB.Delete_Attrib_Mapping_Rule
    (	p_context_name		=> 'Market Segment' ,	     -- Context defined in Flexfield
	p_context_type		=> 'Q'		,	     -- For Qualifier
	p_condition_name	=> 'AMS Mkt Segment Context', -- Name of the Condition
	p_pricing_type		=> 'L'	,		     -- for Line Request
	p_src_sys_code		=> 'AMS',		     -- Confirm
	p_attribute_code	=> 'QUALIFIER_ATTRIBUTE1') ;

Line: 56

    QP_ATTR_MAPPING_PUB.Update_Attrib_Mapping_Rule
    (	p_context_name		=> 'Market Segment' ,	     -- Context defined in Flexfield
	p_context_type		=> 'Q'		,	     -- For Qualifier
	p_condition_name	=> 'AMS Mkt Segment Context', -- Name of the Condition
	p_pricing_type		=> 'L'	,		     -- for Line Request
	p_src_sys_code		=> 'AMS',		     -- Confirm
	p_attribute_code	=> 'QUALIFIER_ATTRIBUTE1',    -- Map Attriburte1 to Market Segment
	p_src_type		=> 'API_MULTIREC',	     -- As we are returning Table
	p_src_api_pkg		=> 'AMS_MKS_QP_PVT'	,
	p_src_api_fn		=> 'AMS_MKS_QP_PVT.get_market_segment123(AMS_MKS_QP_PVT.ams_tmp_gbl_str.party_id)'	,
	p_other_src		=> NULL
	) ;

Line: 78

   QP_ATTR_MAPPING_PUB.Delete_Condition
   (	p_context_name		=> 'AMS ITEM '
   ,	p_condition_name	=> 'Ams Item Cat'
   ,	p_context_type		=> 'Q'
   ,	p_pricing_type		=> 'L' ) ;