PACKAGE: APPS.OE_VERSION_BLANKET_COMP

Source

1 PACKAGE OE_VERSION_BLANKET_COMP AS
2 /* $Header: OEXBCOMS.pls 120.1 2006/04/07 00:12:41 mbhoumik noship $ */
3 
4 G_PKG_NAME                    CONSTANT VARCHAR2(30) := 'OE_VERSION_BLANKET_COMP';
5 
6 TYPE header_results_rec_type IS RECORD
7 (
8 header_id            NUMBER,
9 attribute_name  VARCHAR2(2000),
10 current_id      VARCHAR2(2000),
11 current_value   VARCHAR2(2000),
12 prior_id        VARCHAR2(2000),
13 prior_value     VARCHAR2(2000),
14 next_id         VARCHAR2(2000),
15 next_value      VARCHAR2(2000)
16 );
17 
18 TYPE line_results_rec_type IS RECORD
19 (
20 header_id          NUMBER,
21 line_id            NUMBER,
22 line_number        VARCHAR2(30),
23 attribute_name     VARCHAR2(2000),
24 current_id         VARCHAR2(2000),
25 current_value      VARCHAR2(2000),
26 prior_id           VARCHAR2(2000),
27 prior_value        VARCHAR2(2000),
28 next_id            VARCHAR2(2000),
29 next_value         VARCHAR2(2000)
30 );
31 
32 
33 TYPE header_tbl_type IS TABLE OF header_results_rec_type
34 INDEX BY BINARY_INTEGER;
35 
36 TYPE line_tbl_type IS TABLE OF line_results_rec_type
37 INDEX BY BINARY_INTEGER;
38 
39 
40 PROCEDURE QUERY_HEADER_ROW
41 (p_header_id		NUMBER,
42 p_version		NUMBER,
43 p_phase_change_flag     VARCHAR2,
44 x_header_rec            IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type);
45 
46 PROCEDURE QUERY_HEADER_TRANS_ROW
47 (p_header_id		NUMBER,
48 p_version		NUMBER,
49 x_header_rec            IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type);
50 
51 PROCEDURE QUERY_LINE_ROW
52 (p_header_id		NUMBER,
53 p_line_id		NUMBER,
54 p_version		NUMBER,
55 p_phase_change_flag     VARCHAR2,
56 x_line_rec	        IN OUT NOCOPY OE_Blanket_PUB.line_rec_type);
57 
58 PROCEDURE QUERY_LINE_TRANS_ROW
59 (p_header_id		NUMBER,
60 p_line_id		NUMBER,
61 p_version		NUMBER,
62 x_line_rec	        IN OUT NOCOPY OE_Blanket_PUB.line_rec_type);
63 
64 PROCEDURE COMPARE_HEADER_VERSIONS
65 (p_header_id	                  NUMBER,
66  p_prior_version                  NUMBER,
67  p_current_version                NUMBER,
68  p_next_version                   NUMBER,
69  g_max_version                    NUMBER,
70  g_trans_version                  NUMBER,
71  g_prior_phase_change_flag        VARCHAR2,
72  g_curr_phase_change_flag         VARCHAR2,
73  g_next_phase_change_flag         VARCHAR2,
74  x_header_changed_attr_tbl        IN OUT NOCOPY OE_VERSION_BLANKET_COMP.header_tbl_type);
75 
76 PROCEDURE COMPARE_LINE_VERSIONS
77 (p_header_id                      NUMBER,
78  p_line_id                        NUMBER,
79  p_prior_version                  NUMBER,
80  p_current_version                NUMBER,
81  p_next_version                   NUMBER,
82  g_max_version                    NUMBER,
83  g_trans_version                  NUMBER,
84  g_prior_phase_change_flag        VARCHAR2,
85  g_curr_phase_change_flag         VARCHAR2,
86  g_next_phase_change_flag         VARCHAR2,
87  x_line_changed_attr_tbl          IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type);
88 
89 PROCEDURE COMPARE_ATTRIBUTES
90 (p_header_id                      NUMBER,
91  p_line_id                        NUMBER,
92  p_prior_version                  NUMBER,
93  p_current_version                NUMBER,
94  p_next_version                   NUMBER,
95  g_max_version                    NUMBER,
96  g_trans_version                  NUMBER,
97  g_prior_phase_change_flag        VARCHAR2,
98  g_curr_phase_change_flag         VARCHAR2,
99  g_next_phase_change_flag         VARCHAR2,
100  x_line_changed_attr_tbl          IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type,
101  p_total_lines                    NUMBER,
102  x_line_number                    NUMBER);
103 
104 FUNCTION line_status
105 (   p_line_status_code            IN  VARCHAR2
106 ) RETURN VARCHAR2;
107 
108  --{added for bug 4302049
109 FUNCTION get_dff_seg_prompt(p_application_id               IN NUMBER,
110 		     p_descriptive_flexfield_name	IN VARCHAR2,
111 		     p_descriptive_flex_context_cod	IN VARCHAR2,
112 		     p_desc_flex_context_cod_prior	IN VARCHAR2,
113 		     p_desc_flex_context_cod_next	IN VARCHAR2,
114 		     p_application_column_name		IN VARCHAR2)
115    RETURN VARCHAR2;
116  --bug 4302049}
117 
118 END OE_VERSION_BLANKET_COMP;