[Home] [Help]
PACKAGE: APPS.OE_VERSION_COMP
Source
1 PACKAGE OE_VERSION_COMP AS
2 /* $Header: OEXSCOMS.pls 120.4.12010000.1 2008/07/25 07:54:15 appldev ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VERSION_COMP';
5
6 TYPE header_results_rec_type IS RECORD
7 (
8 header_id NUMBER,
9 attribute_name VARCHAR2(2000),
10 attribute_value VARCHAR2(2000),
11 current_id VARCHAR2(2000),
12 current_value VARCHAR2(2000),
13 prior_id VARCHAR2(2000),
14 prior_value VARCHAR2(2000),
15 next_id VARCHAR2(2000),
16 next_value VARCHAR2(2000)
17 );
18
19 TYPE line_results_rec_type IS RECORD
20 (
21 header_id NUMBER,
22 line_id NUMBER,
23 line_number VARCHAR2(30),
24 attribute_value VARCHAR2(2000),
25 attribute_name VARCHAR2(2000),
26 current_id VARCHAR2(2000),
27 current_value VARCHAR2(2000),
28 prior_id VARCHAR2(2000),
29 prior_value VARCHAR2(2000),
30 next_id VARCHAR2(2000),
31 next_value VARCHAR2(2000)
32 );
33
34
35 TYPE header_tbl_type IS TABLE OF header_results_rec_type
36 INDEX BY BINARY_INTEGER;
37
38 TYPE header_sc_tbl_type IS TABLE OF header_results_rec_type
39 INDEX BY BINARY_INTEGER;
40
41 TYPE line_tbl_type IS TABLE OF line_results_rec_type
42 INDEX BY BINARY_INTEGER;
43
44 TYPE line_sc_tbl_type IS TABLE OF line_results_rec_type
45 INDEX BY BINARY_INTEGER;
46
47 PROCEDURE QUERY_HEADER_ROW
48 (p_header_id NUMBER,
49 p_version NUMBER,
50 p_phase_change_flag VARCHAR2,
51 x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);
52
53 PROCEDURE QUERY_HEADER_TRANS_ROW
54 (p_header_id NUMBER,
55 p_version NUMBER,
56 x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);
57
58 PROCEDURE QUERY_HEADER_SC_ROW
59 (p_header_id NUMBER,
60 p_sales_credit_id NUMBER,
61 p_version NUMBER,
62 p_phase_change_flag VARCHAR2,
63 x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type);
64
65 PROCEDURE QUERY_HEADER_SC_TRANS_ROW
66 (p_header_id NUMBER,
67 p_sales_credit_id NUMBER,
68 p_version NUMBER,
69 x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type);
70
71 PROCEDURE QUERY_LINE_ROW
72 (p_header_id NUMBER,
73 p_line_id NUMBER,
74 p_version NUMBER,
75 p_phase_change_flag VARCHAR2,
76 x_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type);
77
78 PROCEDURE QUERY_LINE_TRANS_ROW
79 (p_header_id NUMBER,
80 p_line_id NUMBER,
81 p_version NUMBER,
82 x_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type);
83
84 PROCEDURE QUERY_LINE_SC_ROW
85 (p_header_id NUMBER,
86 p_sales_credit_id NUMBER,
87 p_version NUMBER,
88 p_phase_change_flag VARCHAR2,
89 x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type);
90
91 PROCEDURE QUERY_LINE_SC_TRANS_ROW
92 (p_header_id NUMBER,
93 p_sales_credit_id NUMBER,
94 p_version NUMBER,
95 x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type);
96
97 PROCEDURE COMPARE_HEADER_VERSIONS
98 (p_header_id NUMBER,
99 p_prior_version NUMBER,
100 p_current_version NUMBER,
101 p_next_version NUMBER,
102 g_max_version NUMBER,
103 g_trans_version NUMBER,
104 g_prior_phase_change_flag VARCHAR2,
105 g_curr_phase_change_flag VARCHAR2,
106 g_next_phase_change_flag VARCHAR2,
107 x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_tbl_type);
108
109 PROCEDURE COMPARE_HEADER_SC_VERSIONS
110 (p_header_id NUMBER,
111 p_prior_version NUMBER,
112 p_current_version NUMBER,
113 p_next_version NUMBER,
114 g_max_version NUMBER,
115 g_trans_version NUMBER,
116 g_prior_phase_change_flag VARCHAR2,
117 g_curr_phase_change_flag VARCHAR2,
118 g_next_phase_change_flag VARCHAR2,
119 x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type);
120
121 PROCEDURE COMPARE_HEADER_SC_ATTRIBUTES
122 (p_header_id NUMBER,
123 p_sales_credit_id NUMBER,
124 p_prior_version NUMBER,
125 p_current_version NUMBER,
126 p_next_version NUMBER,
127 g_max_version NUMBER,
128 g_trans_version NUMBER,
129 g_prior_phase_change_flag VARCHAR2,
130 g_curr_phase_change_flag VARCHAR2,
131 g_next_phase_change_flag VARCHAR2,
132 x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,
133 p_total_lines NUMBER);
134
135 PROCEDURE COMPARE_LINE_VERSIONS
136 (p_header_id NUMBER,
137 p_line_id NUMBER,
138 p_prior_version NUMBER,
139 p_current_version NUMBER,
140 p_next_version NUMBER,
141 g_max_version NUMBER,
142 g_trans_version NUMBER,
143 g_prior_phase_change_flag VARCHAR2,
144 g_curr_phase_change_flag VARCHAR2,
145 g_next_phase_change_flag VARCHAR2,
146 x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type);
147
148 PROCEDURE COMPARE_LINE_ATTRIBUTES
149 (p_header_id NUMBER,
150 p_line_id NUMBER,
151 p_prior_version NUMBER,
152 p_current_version NUMBER,
153 p_next_version NUMBER,
154 g_max_version NUMBER,
155 g_trans_version NUMBER,
156 g_prior_phase_change_flag VARCHAR2,
157 g_curr_phase_change_flag VARCHAR2,
158 g_next_phase_change_flag VARCHAR2,
159 x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type,
160 p_total_lines NUMBER,
161 x_line_number VARCHAR2);
162
163 PROCEDURE COMPARE_LINE_SC_VERSIONS
164 (p_header_id NUMBER,
165 p_prior_version NUMBER,
166 p_current_version NUMBER,
167 p_next_version NUMBER,
168 g_max_version NUMBER,
169 g_trans_version NUMBER,
170 g_prior_phase_change_flag VARCHAR2,
171 g_curr_phase_change_flag VARCHAR2,
172 g_next_phase_change_flag VARCHAR2,
173 x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type);
174
175 PROCEDURE COMPARE_LINE_SC_ATTRIBUTES
176 (p_header_id NUMBER,
177 p_sales_credit_id NUMBER,
178 p_prior_version NUMBER,
179 p_current_version NUMBER,
180 p_next_version NUMBER,
181 g_max_version NUMBER,
182 g_trans_version NUMBER,
183 g_prior_phase_change_flag VARCHAR2,
184 g_curr_phase_change_flag VARCHAR2,
185 g_next_phase_change_flag VARCHAR2,
186 x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type,
187 p_total_lines NUMBER,
188 x_line_number VARCHAR2);
189
190 FUNCTION line_status
191 ( p_line_status_code IN VARCHAR2
192 ) RETURN VARCHAR2;
193
194 PROCEDURE Card_Equal
195 ( p_instrument_id1 IN NUMBER
196 , p_instrument_id2 IN NUMBER
197 , p_attribute_name IN VARCHAR2
198 , p_is_card_history1 IN VARCHAR2
199 , p_is_card_history2 IN VARCHAR2
200 , x_is_equal OUT NOCOPY VARCHAR2
201 , x_value1 OUT NOCOPY VARCHAR2
202 , x_value2 OUT NOCOPY VARCHAR2
203 );
204
205 --{added for bug 4302049
206 FUNCTION get_dff_seg_prompt(p_application_id IN NUMBER,
207 p_descriptive_flexfield_name IN VARCHAR2,
208 p_descriptive_flex_context_cod IN VARCHAR2,
209 p_desc_flex_context_cod_prior IN VARCHAR2,
210 p_desc_flex_context_cod_next IN VARCHAR2,
211 p_application_column_name IN VARCHAR2)
212 RETURN VARCHAR2;
213 --bug 4302049}
214
215 END OE_VERSION_COMP;