[Home] [Help]
PACKAGE: APPS.OKC_QUERY_PVT
Source
1 PACKAGE OKC_QUERY_PVT AS
2 /*$Header: OKCPLCHS.pls 120.0 2005/05/25 22:31:14 appldev noship $*/
3
4 --===================
5 -- TYPES
6 --===================
7 -- add your type declarations here if any
8 --
9
10
11
12 --===================
13 -- PACKAGE CONSTANTS
14 --===================
15 --
16 x_msg_count NUMBER;
17 x_msg_data VARCHAR2(2000);
18 x_return_status VARCHAR2(1);
19
20 --===================
21 -- LOCAL PROCEDURES AND FUNCTIONS
22 --===================
23 --
24
25
26 --===================
27 -- PACKAGE PROCEDURES AND FUNCTIONS
28 --===================
29 --
30
31 --
32 --
33 FUNCTION GetContractPartyName ( p_contract_id IN NUMBER,
34 p_class_code IN VARCHAR2)
35 RETURN VARCHAR2;
36
37 --
38 --
39 FUNCTION GetContractDisplayAmount ( p_contract_id IN NUMBER,
40 p_class_code IN VARCHAR2)
41 RETURN VARCHAR2;
42
43 --
44 --
45 FUNCTION SetSublineIndent ( p_contract_id IN NUMBER,
46 p_line_id IN NUMBER,
47 p_line_descr IN VARCHAR2)
48 RETURN VARCHAR2;
49
50 --
51 --
52 FUNCTION GetLinePartyName ( p_contract_id IN NUMBER,
53 p_line_id IN NUMBER)
54 RETURN VARCHAR2;
55
56 --
57 --
58 FUNCTION GetChildCount (p_group_id IN NUMBER)
59 RETURN NUMBER;
60
61 --
62 --
63 FUNCTION GetParentLineNumber ( p_line_id IN NUMBER)
64 RETURN VARCHAR2;
65
66 END OKC_QUERY_PVT;