1 PACKAGE QP_BUILD_SOURCING_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVATTS.pls 120.0 2005/06/02 00:52:33 appldev noship $ */
3
4 /*
5 * PLEASE DON'T ADD ANY VARIABLES TO THIS PACKAGE.
6 * ADDING VARIABLES TO THIS PACKAGE WILL MAKE THIS PACKAGE STATEFUL,
7 * MEANING SESSION MEMORY IMAGE OF THE PACKAGE BECOMES INVALID
8 * WHEN PACKAGE IS RECOMPILED.
9 * */
10
11 -- bug2892096 Added global variable to store request type code
12 -- Removed the global variable for the bug#3848849
13 --G_REQ_TYPE_CODE VARCHAR2(10);
14
15 PROCEDURE Get_Attribute_Values
16 ( p_req_type_code IN VARCHAR2
17 , p_pricing_type_code IN VARCHAR2
18 , x_qual_ctxts_result_tbl OUT NOCOPY QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE
19 , x_price_ctxts_result_tbl OUT NOCOPY QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE
20 );
21
22 FUNCTION Is_Attribute_Used(p_attribute_context IN VARCHAR2, p_attribute_code IN VARCHAR2) RETURN VARCHAR2;
23
24 END QP_BUILD_SOURCING_PVT;