[Home] [Help]
PACKAGE: APPS.OE_VERSION_PRICE_ADJUST_COMP
Source
1 PACKAGE OE_VERSION_PRICE_ADJUST_COMP AS
2 /* $Header: OEXPCOMS.pls 120.1 2006/04/07 00:06:42 mbhoumik noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VERSION_PRICE_ADJUST_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 TYPE header_adj_tbl_type IS TABLE OF header_results_rec_type
35 INDEX BY BINARY_INTEGER;
36
37 TYPE line_adj_tbl_type IS TABLE OF line_results_rec_type
38 INDEX BY BINARY_INTEGER;
39
40
41 PROCEDURE QUERY_HEADER_ADJ_ROW
42 (p_header_id NUMBER,
43 p_price_adjustment_id NUMBER,
44 p_version NUMBER,
45 p_phase_change_flag VARCHAR2,
46 x_header_adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type);
47
48 PROCEDURE QUERY_HEADER_ADJ_TRANS_ROW
49 (p_header_id NUMBER,
50 p_price_adjustment_id NUMBER,
51 p_version NUMBER,
52 x_header_adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type);
53
54 PROCEDURE QUERY_LINE_ADJ_ROW
55 (p_header_id NUMBER,
56 p_price_adjustment_id NUMBER,
57 p_version NUMBER,
58 p_phase_change_flag VARCHAR2,
59 x_line_adj_rec IN OUT NOCOPY OE_Order_PUB.Line_adj_Rec_Type);
60
61 PROCEDURE QUERY_LINE_ADJ_TRANS_ROW
62 (p_header_id NUMBER,
63 p_price_adjustment_id NUMBER,
64 p_version NUMBER,
65 x_line_adj_rec IN OUT NOCOPY OE_Order_PUB.Line_adj_Rec_Type);
66
67 PROCEDURE COMPARE_HEADER_ADJ_VERSIONS
68 (p_header_id NUMBER,
69 p_prior_version NUMBER,
70 p_current_version NUMBER,
71 p_next_version NUMBER,
72 g_max_version NUMBER,
73 g_trans_version NUMBER,
74 g_prior_phase_change_flag VARCHAR2,
75 g_curr_phase_change_flag VARCHAR2,
76 g_next_phase_change_flag VARCHAR2,
77 x_header_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.header_adj_tbl_type);
78
79 PROCEDURE COMPARE_HEADER_ADJ_ATTRIBUTES
80 (p_header_id NUMBER,
81 p_price_adjustment_id NUMBER,
82 p_prior_version NUMBER,
83 p_current_version NUMBER,
84 p_next_version NUMBER,
85 g_max_version NUMBER,
86 g_trans_version NUMBER,
87 g_prior_phase_change_flag VARCHAR2,
88 g_curr_phase_change_flag VARCHAR2,
89 g_next_phase_change_flag VARCHAR2,
90 x_header_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.header_adj_tbl_type,
91 p_total_lines NUMBER);
92
93 PROCEDURE COMPARE_LINE_adj_ATTRIBUTES
94 (p_header_id NUMBER,
95 p_price_adjustment_id NUMBER,
96 p_prior_version NUMBER,
97 p_current_version NUMBER,
98 p_next_version NUMBER,
99 g_max_version NUMBER,
100 g_trans_version NUMBER,
101 g_prior_phase_change_flag VARCHAR2,
102 g_curr_phase_change_flag VARCHAR2,
103 g_next_phase_change_flag VARCHAR2,
104 x_line_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.line_adj_tbl_type,
105 p_total_lines NUMBER,
106 x_line_number VARCHAR2);
107
108 PROCEDURE COMPARE_LINE_ADJ_VERSIONS
109 (p_header_id NUMBER,
110 p_prior_version NUMBER,
111 p_current_version NUMBER,
112 p_next_version NUMBER,
113 g_max_version NUMBER,
114 g_trans_version NUMBER,
115 g_prior_phase_change_flag VARCHAR2,
116 g_curr_phase_change_flag VARCHAR2,
117 g_next_phase_change_flag VARCHAR2,
118 x_line_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.line_adj_tbl_type);
119
120 --{added for bug 4302049
121 FUNCTION get_dff_seg_prompt(p_application_id IN NUMBER,
122 p_descriptive_flexfield_name IN VARCHAR2,
123 p_descriptive_flex_context_cod IN VARCHAR2,
124 p_desc_flex_context_cod_prior IN VARCHAR2,
125 p_desc_flex_context_cod_next IN VARCHAR2,
126 p_application_column_name IN VARCHAR2)
127 RETURN VARCHAR2;
128 --bug 4302049}
129
130 END OE_VERSION_PRICE_ADJUST_COMP;