APPS.QP_QP_FORM_PRICING_ATTR SQL Statements

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

Line: 481

        l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 842

,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_PRICING_ATTR_rec            QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line: 894

        l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 934

    x_last_update_date             := l_x_PRICING_ATTR_rec.last_update_date;

Line: 935

    x_last_updated_by              := l_x_PRICING_ATTR_rec.last_updated_by;

Line: 936

    x_last_update_login            := l_x_PRICING_ATTR_rec.last_update_login;

Line: 1008

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_pricing_attribute_id          IN  NUMBER
)
IS
l_PRICING_ATTR_rec            QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line: 1028

oe_debug_pub.add('BEGIN Delete_Row in QPXFPRAB');

Line: 1054

    l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1066

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);

Line: 1071

          oe_debug_pub.add('failed in logging a delayed request in delete_row ');

Line: 1114

oe_debug_pub.add('END Delete_Row in QPXFPRAB');

Line: 1148

            ,   'Delete_Row'
            );

Line: 1159

END Delete_Row;

Line: 1307

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_list_line_id                  IN  NUMBER
,   p_pricing_attribute             IN  VARCHAR2
,   p_pricing_attribute_context     IN  VARCHAR2
,   p_pricing_attribute_id          IN  NUMBER
,   p_pricing_attr_value_from       IN  VARCHAR2
,   p_pricing_attr_value_to         IN  VARCHAR2
,   p_product_attribute             IN  VARCHAR2
,   p_product_attribute_context     IN  VARCHAR2
,   p_product_attr_value            IN  VARCHAR2
,   p_product_uom_code              IN  VARCHAR2
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_request_id                    IN  NUMBER
,   p_product_attribute_datatype    IN  VARCHAR2
,   p_pricing_attribute_datatype    IN  VARCHAR2
,   p_comparison_operator_code      IN  VARCHAR2
)
IS
l_return_status               VARCHAR2(1);

Line: 1367

    l_PRICING_ATTR_rec.last_updated_by := p_last_updated_by;

Line: 1368

    l_PRICING_ATTR_rec.last_update_date := p_last_update_date;

Line: 1369

    l_PRICING_ATTR_rec.last_update_login := p_last_update_login;

Line: 1382

    l_PRICING_ATTR_rec.program_update_date := p_program_update_date;

Line: 1587

select meaning into l_Meaning from qp_lookups where
lookup_code = p_lookup_code and lookup_type = p_lookup_type ;

Line: 1611

select name into l_Pricing_Phase from QP_Pricing_Phases where
Pricing_Phase_Id = p_Pricing_Phase_Id;

Line: 1653

                    SELECT name
                    INTO l_charge_name
                    FROM pon_cost_factors_vl
                    WHERE price_element_type_id > 0
                    AND NVL(enabled_flag,'Y') <> 'N'
                    AND TO_CHAR(price_element_type_id) =  p_charge_type_code;

Line: 1663

/* changes made in select statement by dhgupta for bug 2047030 */
/* LKP1 rewritten from qp_charge_lookup to fnd_lookup_values (plus additional
   where conditions of the qp_charge_lookup view definition) to get rid of
   non-mergable view, bug 4865226 */
SELECT nvl(DECODE(lkp1.lookup_type,'FREIGHT_COST_TYPE',lkp1.meaning,lkp2.meaning),lkp1.meaning)
	   INTO l_Charge_Name
	   FROM  fnd_lookup_values LKP1, QP_LOOKUPS LKP2
	   WHERE lkp1.language = userenv('LANG')
           and lkp1.security_group_id = 0
           and ((lkp1.view_application_id = 661 and
                 lkp1.lookup_type = 'FREIGHT_CHARGES_TYPE')
                or
                (lkp1.view_application_id = 665 and
                 lkp1.lookup_type = 'FREIGHT_COST_TYPE'))
           AND lkp1.lookup_code = lkp2.lookup_type(+)
	   AND lkp1.enabled_flag = 'Y'
	   AND sysdate BETWEEN NVL(lkp1.start_date_active,sysdate)
    	   AND NVL(lkp1.end_date_active,sysdate)
	   AND (lkp2.enabled_flag = 'Y' OR lkp2.enabled_flag IS NULL)
	   AND sysdate BETWEEN NVL(lkp2.start_date_active,sysdate)
	   AND NVL(lkp2.end_date_active,sysdate)
	   AND lkp1.lookup_code = p_Charge_Type_Code
	   AND DECODE(lkp1.lookup_type,'FREIGHT_COST_TYPE','0',NVL(lkp2.lookup_code,0))
	   = nvl(p_Charge_Subtype_Code, '0');

Line: 1717

select Name into l_Price_By_Formula from QP_Price_Formulas_Vl where
Price_Formula_ID = p_Price_By_Formula_ID;

Line: 1742

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Date,
Null) into l_Expiration_Date from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 1768

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_Start_Date,
Null) into l_Exp_Period_Start_Date from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 1794

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Number_Expiration_Periods,
Null) into l_Number_Expiration_Periods from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 1820

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_UOM,
Null) into l_Expiration_Period_UOM from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 1849

select decode(p_modifier_type_code, p_list_line_type_code,
qlook.meaning, Null) into
l_Rebate_Txn_Type from QP_LOOKUPS qlook where
qlook.lookup_type = 'REBATE_TRANSACTION_TYPE_CODE' and
qlook.lookup_code = p_rebate_transaction_type_code;

Line: 1856

select decode(p_modifier_type_code, ql.list_line_type_code,
qlook.meaning, Null) into
l_Rebate_Txn_Type from QP_LIST_LINES ql, QP_LOOKUPS qlook where
ql.list_line_id = p_list_line_id and
qlook.lookup_code = ql.rebate_transaction_type_code;

Line: 1885

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_Qty,
Null) into l_Benefit_Qty from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 1911

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_UOM_Code,
Null) into l_Benefit_UOM_Code from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 1953

select to_rltd_modifier_id,
	rltd_modifier_grp_type, rltd_modifier_grp_no, rltd_modifier_id
	into x_to_rltd_modifier_id,
	x_rltd_modifier_grp_type, x_rltd_modifier_grp_no, x_rltd_modifier_id
	from qp_rltd_modifiers
	where
	from_rltd_modifier_id = p_list_line_id;

Line: 2130

	select list_line_no into l_benefit_list_line_no from
		qp_list_lines where list_line_id = l_to_rltd_modifier_id;

Line: 2160

select decode(p_modifier_type_code, ql.list_line_type_code, ql.List_Line_No,
Null) into l_Benefit_List_Line_No from QP_LIST_LINES ql  where
ql.list_line_id = p_to_rltd_modifier_id;

Line: 2187

select decode(p_modifier_type_code, ql.list_line_type_code, ql.Accrual_Flag,
Null) into l_Accrual_Flag from QP_LIST_LINES ql where
ql.list_line_id = p_list_line_id;

Line: 2213

select decode(p_modifier_type_code, ql.list_line_type_code,
ql.Accrual_Conversion_Rate, Null) into l_Accrual_Conversion_Rate
from QP_LIST_LINES ql where ql.list_line_id = p_list_line_id;

Line: 2239

select decode(p_modifier_type_code, ql.list_line_type_code,
ql.Estim_Accrual_Rate, Null) into l_Estim_Accrual_Rate from
QP_LIST_LINES ql where ql.list_line_id = p_list_line_id;

Line: 2268

select ql.list_line_type_code into l_Break_Line_Type_Code
from QP_LIST_LINES ql
where ql.list_line_id = (select to_rltd_modifier_id from
qp_rltd_modifiers where from_rltd_modifier_id = p_list_line_id and
rownum < 2);

Line: 2306

select qlook.Meaning into l_Break_Line_Type
from qp_lookups qlook
where qlook.lookup_type = 'LIST_LINE_TYPE_CODE' and
qlook.lookup_code = p_break_line_type_code;

Line: 2313

select qlook.Meaning into l_Break_Line_Type
from QP_LIST_LINES ql, qp_lookups qlook
where qlook.lookup_code = ql.list_line_type_code and
ql.list_line_id = (select to_rltd_modifier_id from
qp_rltd_modifiers where from_rltd_modifier_id = p_list_line_id and
rownum < 2);

Line: 2382

THE ATTRIBUTE HAS BEEN DELETED.
CHANGES MADE BASED ON SWATI'S CHANGES TO QP_CON_ATTR_PACKAGE IN QPXCORE
-------------------------------------------------------------------------*/

PROCEDURE Get_Attribute_Code(p_FlexField_Name 	IN VARCHAR2
                            ,p_Context_Name   	IN VARCHAR2
				        ,p_attribute      	IN VARCHAR2
					   ,p_attribute_col_name IN VARCHAR2
					   ,x_attribute_code 	OUT NOCOPY /* file.sql.39 change */ VARCHAR2
					   ,x_segment_name   	OUT NOCOPY /* file.sql.39 change */ VARCHAR2
					   ) 	IS
/* commented for attribute manager change
  Flexfield FND_DFLEX.dflex_r;

Line: 2531

HAS BEEN DELETED FROM THE VALUE SET.
CHANGES MADE BASED ON SWATI'S CHANGES TO QP_CON_ATTR_PACKAGE IN QPXCORE
-------------------------------------------------------------------------*/


FUNCTION Get_Attribute_Value(p_FlexField_Name       IN VARCHAR2
                            ,p_Context_Name         IN VARCHAR2
		            	   ,p_attribute         	  IN VARCHAR2
			    		   ,p_attr_value IN VARCHAR2
                            ,p_attribute_val_col_name   IN VARCHAR2 := NULL
                            ,p_comparison_operator_code IN VARCHAR2 := NULL
			    		   ) RETURN VARCHAR2 IS

  Vset  FND_VSET.valueset_r;

Line: 2769

     QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
					p_entity_code  => QP_GLOBALS.G_ENTITY_PRICING_ATTR
					,p_entity_id    => p_list_line_id
				     ,x_return_status => l_return_status);