[Home] [Help]
PACKAGE: APPS.OKC_QUERY
Source
1 PACKAGE OKC_QUERY AS
2 /*$Header: OKCQURYS.pls 120.0 2005/05/26 09:39:22 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
64 FUNCTION GetKid (p_notification_id IN NUMBER,
65 p_att_name IN VARCHAR2)
66 RETURN NUMBER;
67
68 --
69 --
70
71 FUNCTION GetKnumber (p_notification_id IN NUMBER,
72 p_att_name IN VARCHAR2)
73 RETURN VARCHAR2;
74
75 --
76 --
77 --MMadhavi added GetKmodifier
78 --
79 --
80
81 FUNCTION GetKmodifier (p_notification_id IN NUMBER,
82 p_att_name IN VARCHAR2)
83 RETURN VARCHAR2;
84
85 --
86 --
87
88 FUNCTION GetParentLineNumber ( p_line_id IN NUMBER)
89 RETURN VARCHAR2;
90
91 --
92 --
93 FUNCTION GetAuthorFormName (p_class_code IN VARCHAR2)
94 RETURN VARCHAR2;
95
96
97 --
98 --
99 FUNCTION GetContractVersion (p_contract_id IN NUMBER)
100 RETURN VARCHAR2;
101
102 FUNCTION GetGroupName (p_contract_id IN NUMBER)
103 RETURN VARCHAR2;
104
105 FUNCTION GET_NUMBER(p_string IN VARCHAR2) RETURN NUMBER;
106
107
108 FUNCTION GET_K_ROLE_PARTY(p_contract_id IN NUMBER
109 ,p_party_role IN VARCHAR2
110 ,p_party_name IN VARCHAR2 := OKC_API.G_MISS_CHAR) RETURN BOOLEAN;
111
112 FUNCTION Get_Contract_Number(p_rtv_id IN NUMBER )
113 RETURN VARCHAR2;
114
115 FUNCTION Get_Source_Doc_Number( p_coe_id IN NUMBER ) RETURN VARCHAR2;
116
117 --
118 --
119 FUNCTION GetFormFunctionName (p_subclass_code IN VARCHAR2,
120 p_operation IN VARCHAR2)
121 RETURN VARCHAR2;
122
123 --
124 --
125 --PROCEDURE GetEbizLinkName(x_function_name out varchar2);
126 FUNCTION GetEbizLinkName
127 --(p_col_name IN VARCHAR2)
128 RETURN VARCHAR2;
129
130 /* Added new function for Bug#2323327 */
131
132 FUNCTION GetClassFunctionName ( p_cls_code IN VARCHAR2,
133 p_operation IN VARCHAR2)
134 RETURN VARCHAR2 ;
135
136 --
137 -- function get_contact (moved here from OKC_RULE_PUB)
138 --
139 -- returns HZ_PARTIES related contacts points
140 -- otherwise (or if not found) returns contact description
141 -- through jtf_objects_vl
142 --
143 -- all parameters are regular jtf_objects related
144 --
145
146 function get_contact(
147 p_object_code in varchar2,
148 p_object_id1 in varchar2,
149 p_object_id2 in varchar2
150 )
151 return varchar2;
152
153 FUNCTION GET_ADDRESS(
154 p_object_code IN VARCHAR2,
155 p_object_id1 in varchar2,
156 p_object_id2 in varchar2,
157 ADR_TYPE VARCHAR2 := 'MAIN' -- ADDRESS TYPE : 'MAIN', 'BILL', 'SHIP'
158 ) RETURN VARCHAR2;
159
160 FUNCTION GET_EMAIL_FROM_JTFV(
161 p_object_code IN VARCHAR2,
162 p_object_id1 in varchar2,
163 p_object_id2 in varchar2
164 ) RETURN VARCHAR2;
165
166 function get_contact_info(
167 p_object_code in varchar2,
168 p_object_id1 in varchar2,
169 p_object_id2 in varchar2,
170 p_info_type in varchar2 -- 'EMAIL', 'PHONE', 'FAX'
171 ) return varchar2;
172
173 END OKC_QUERY;
174