DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_PVT dependencies on QP_UTIL

Line 2035: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);

2031: l_context varchar2(30);
2032: l_attribute varchar2(30);
2033: begin
2034:
2035: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);
2036:
2037: select list_header_id
2038: into l_sec_price_list_id
2039: from qp_qualifiers

Line 2066: QP_UTIL.Get_Context_Attribute('1001', l_context, l_attribute);

2062: l_context varchar2(30);
2063: l_attribute varchar2(30);
2064: begin
2065:
2066: QP_UTIL.Get_Context_Attribute('1001', l_context, l_attribute);
2067:
2068: select to_number(product_attr_value)
2069: into l_inventory_item_id
2070: from qp_pricing_attributes

Line 2091: QP_UTIL.Get_Context_Attribute('CUSTOMER_ITEM_ID', l_context, l_attribute);

2087: l_context varchar2(30);
2088: l_attribute varchar2(30);
2089: begin
2090:
2091: QP_UTIL.Get_Context_Attribute('CUSTOMER_ITEM_ID', l_context, l_attribute);
2092:
2093: select to_number(pricing_attr_value_from)
2094: into l_customer_item_id
2095: from qp_pricing_attributes

Line 2217: QP_UTIL.Get_Context_Attribute ( 'UNITS',l_context, l_attribute);

2213: l_pricing_attribute varchar2(240);
2214: l_price_break_high number;
2215: l_attribute varchar2(30);
2216: begin
2217: QP_UTIL.Get_Context_Attribute ( 'UNITS',l_context, l_attribute);
2218:
2219: select to_number(pricing_attr_value_to) into
2220: l_price_break_high
2221: from qp_pricing_attributes

Line 2239: QP_UTIL.Get_Context_Attribute ( 'UNITS',l_context, l_attribute);

2235: l_price_break_low number;
2236: l_attribute varchar2(30);
2237: begin
2238:
2239: QP_UTIL.Get_Context_Attribute ( 'UNITS',l_context, l_attribute);
2240:
2241: select to_number(pricing_attr_value_from) into
2242: l_price_break_low
2243: from qp_pricing_attributes

Line 2260: QP_UTIL.Get_Context_Attribute ( '1001',l_context, l_attribute);

2256: l_attribute varchar2(30);
2257: l_uom_code varchar2(3);
2258: begin
2259:
2260: QP_UTIL.Get_Context_Attribute ( '1001',l_context, l_attribute);
2261:
2262: select product_uom_code
2263: into l_uom_code
2264: from qp_pricing_attributes