DBA Data[Home] [Help]

PACKAGE: APPS.QP_RUNTIME_SOURCE

Source


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;