1 PACKAGE QP_CUSTOM AUTHID CURRENT_USER AS
2 /* $Header: QPXCUSTS.pls 120.0 2005/06/02 01:12:22 appldev noship $ */
3 /*#
4 * This package contains the specification for the GET_CUSTOM_PRICE API. The
5 * package body/function body is not shipped with Oracle Advanced Pricing. The
6 * user must create the Package Body for QP_CUSTOM containing the function body
7 * for GET_CUSTOM_PRICE which must adhere to the Function specification provided
8 * in the QP_CUSTOM package specification.
9 *
10 * @rep:scope public
11 * @rep:product QP
12 * @rep:displayname Custom Pricing
13 * @rep:category BUSINESS_ENTITY QP_PRICE_FORMULA
14 */
15
16 --GLOBAL Constant holding the package name
17
18 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_CUSTOM';
19
20 /*Customizable Public Function*/
21
22 /*#
23 * The Get Custom Price API is a customizable function to which the user may add
24 * custom code. The API is called by the pricing engine while evaluating a
25 * formula that contains a formula line (step) of type Function. One or more
26 * formulas may be set up to contain a formula line of type Function and the
27 * same API is called each time. So the user must code the logic in the API
28 * based on the price_formula_id that is passed as an input parameter to the
29 * API.
30 *
31 * @param p_price_formula_id the formula ID
32 * @param p_list_price the list price when the formula step type is 'List Price'
33 * @param p_price_effective_date the date the price is effective
34 * @param p_req_line_attrs_tbl the input line attributes
35 *
36 * @return the calculated price
37 *
38 * @rep:displayname Get Custom Price
39 */
40 FUNCTION Get_Custom_Price (p_price_formula_id IN NUMBER,
41 p_list_price IN NUMBER,
42 p_price_effective_date IN DATE,
43 p_req_line_attrs_tbl IN QP_FORMULA_PRICE_CALC_PVT.REQ_LINE_ATTRS_TBL)
44 RETURN NUMBER;
45
46 END QP_CUSTOM;