1 PACKAGE QP_RUNTIME_SOURCE AUTHID CURRENT_USER AS
2 /* $Header: QPXRSRCS.pls 120.0 2005/06/01 23:56:23 appldev noship $ */
3
4 -- Global constant holding the package name
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_RUNTIME_SOURCE';
6
7 TYPE ACCUM_RECORD_TYPE IS RECORD (
8 p_request_type_code VARCHAR2(240),
9 context VARCHAR2(30),
10 attribute VARCHAR2(240)
11 );
12
13 TYPE accum_req_line_attrs_rec IS RECORD (
14 line_index NUMBER,
15 attribute_type VARCHAR2(30),
16 context VARCHAR2(30),
17 attribute VARCHAR2(30),
18 value VARCHAR2(240),
19 grouping_no NUMBER
20 );
21
22 TYPE accum_req_line_attrs_tbl IS TABLE OF accum_req_line_attrs_rec
23 INDEX BY BINARY_INTEGER;
24
25 FUNCTION Get_numeric_attribute_value(
26 p_list_line_id IN NUMBER,
27 p_list_line_no IN VARCHAR2,
28 p_order_header_id IN NUMBER,
29 p_order_line_id IN NUMBER,
30 p_price_effective_date IN DATE,
31 p_req_line_attrs_tbl IN ACCUM_REQ_LINE_ATTRS_TBL,
32 p_accum_rec IN ACCUM_RECORD_TYPE
33 ) RETURN NUMBER;
34
35 END QP_RUNTIME_SOURCE;