eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OE_VERSION_PRICE_ADJUST_COMP

Source


1 PACKAGE OE_VERSION_PRICE_ADJUST_COMP AUTHID CURRENT_USER 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;