PACKAGE: APPS.GLXRVSUB_PKG

Source

1 PACKAGE GLXRVSUB_PKG AUTHID CURRENT_USER AS
2 /* $Header: glfcrrvs.pls 120.5 2005/05/05 02:05:13 kvora ship $ */
3 
4   FUNCTION get_unique_id
5     RETURN NUMBER;
6 
7   FUNCTION get_segment_num(
8       coa_id    IN   VARCHAR2,
9       segment   IN   VARCHAR2)
10     RETURN NUMBER;
11 
12   FUNCTION is_summary_account(
13       coa_id         IN   VARCHAR2,
14       segment_name   IN   VARCHAR2,
15       account_num    IN   VARCHAR2)
16     RETURN BOOLEAN;
17 
18   FUNCTION has_overlapping(
19       x_revaluation_id   NUMBER,
20       x_row_id           VARCHAR2,
21       x_segment1_low     VARCHAR2,
22       x_segment1_high    VARCHAR2,
23       x_segment2_low     VARCHAR2,
24       x_segment2_high    VARCHAR2,
25       x_segment3_low     VARCHAR2,
26       x_segment3_high    VARCHAR2,
27       x_segment4_low     VARCHAR2,
28       x_segment4_high    VARCHAR2,
29       x_segment5_low     VARCHAR2,
30       x_segment5_high    VARCHAR2,
31       x_segment6_low     VARCHAR2,
32       x_segment6_high    VARCHAR2,
33       x_segment7_low     VARCHAR2,
34       x_segment7_high    VARCHAR2,
35       x_segment8_low     VARCHAR2,
36       x_segment8_high    VARCHAR2,
37       x_segment9_low     VARCHAR2,
38       x_segment9_high    VARCHAR2,
39       x_segment10_low    VARCHAR2,
40       x_segment10_high   VARCHAR2,
41       x_segment11_low    VARCHAR2,
42       x_segment11_high   VARCHAR2,
43       x_segment12_low    VARCHAR2,
44       x_segment12_high   VARCHAR2,
45       x_segment13_low    VARCHAR2,
46       x_segment13_high   VARCHAR2,
47       x_segment14_low    VARCHAR2,
48       x_segment14_high   VARCHAR2,
49       x_segment15_low    VARCHAR2,
50       x_segment15_high   VARCHAR2,
51       x_segment16_low    VARCHAR2,
52       x_segment16_high   VARCHAR2,
53       x_segment17_low    VARCHAR2,
54       x_segment17_high   VARCHAR2,
55       x_segment18_low    VARCHAR2,
56       x_segment18_high   VARCHAR2,
57       x_segment19_low    VARCHAR2,
58       x_segment19_high   VARCHAR2,
59       x_segment20_low    VARCHAR2,
60       x_segment20_high   VARCHAR2,
61       x_segment21_low    VARCHAR2,
62       x_segment21_high   VARCHAR2,
63       x_segment22_low    VARCHAR2,
64       x_segment22_high   VARCHAR2,
65       x_segment23_low    VARCHAR2,
66       x_segment23_high   VARCHAR2,
67       x_segment24_low    VARCHAR2,
68       x_segment24_high   VARCHAR2,
69       x_segment25_low    VARCHAR2,
70       x_segment25_high   VARCHAR2,
71       x_segment26_low    VARCHAR2,
72       x_segment26_high   VARCHAR2,
73       x_segment27_low    VARCHAR2,
74       x_segment27_high   VARCHAR2,
75       x_segment28_low    VARCHAR2,
76       x_segment28_high   VARCHAR2,
77       x_segment29_low    VARCHAR2,
78       x_segment29_high   VARCHAR2,
79       x_segment30_low    VARCHAR2,
80       x_segment30_high   VARCHAR2)
81     RETURN BOOLEAN;
82 
83   PROCEDURE raise_exception(
84       err_type       NUMBER,
85       segment_name   VARCHAR2);
86 
87   FUNCTION name_existed(
88       reval_name   VARCHAR2,
89       reval_id     NUMBER,
90       coa_id       NUMBER)
91     RETURN BOOLEAN;
92 
93   FUNCTION range_found(
94       reval_id   NUMBER)
95     RETURN BOOLEAN;
96 
97 END glxrvsub_pkg;