[Home] [Help]
PACKAGE: APPS.FUN_SEQ_UTILS
Source
1 PACKAGE fun_seq_utils AS
2 /* $Header: funsqrls.pls 120.13 2004/02/25 18:22:55 masada noship $ */
3
4 TYPE Table_Name_Rec IS RECORD(
5 application_id fnd_application.application_id%TYPE,
6 table_name fnd_tables.table_name%TYPE);
7
8 TYPE Table_Name_Tab IS TABLE OF Table_Name_Rec INDEX BY BINARY_INTEGER;
9
10 TYPE sequence_rec_type IS RECORD (
11 header_name fun_seq_headers.header_name%TYPE,
12 gapless fun_seq_headers.gapless_flag%TYPE,
13 description fun_seq_headers.description%TYPE);
14
15 TYPE version_rec_type IS RECORD (
16 version_name fun_seq_versions.version_name%TYPE,
17 initial_value fun_seq_versions.initial_value%TYPE,
18 current_value fun_seq_versions.current_value%TYPE,
19 start_date fun_seq_versions.start_date%TYPE,
20 end_date fun_seq_versions.end_date%TYPE);
21
22 TYPE context_rec_type IS RECORD (
23 application_id fun_seq_contexts.application_id%TYPE,
24 table_name fun_seq_contexts.table_name%TYPE,
25 context_type fun_seq_contexts.context_type%TYPE,
26 context_value fun_seq_contexts.context_value%TYPE,
27 event_code fun_seq_contexts.event_code%TYPE,
28 name fun_seq_contexts.name%TYPE,
29 require_assign_flag fun_seq_contexts.require_assign_flag%TYPE,
30 date_type fun_seq_contexts.date_type%TYPE);
31
32 TYPE assignment_rec_type IS RECORD (
33 control_attribute_structure fun_seq_assignments.control_attribute_structure%TYPE,
34 start_date fun_seq_assignments.start_date%TYPE,
35 end_date fun_seq_assignments.end_date%TYPE);
36
37
38 PROCEDURE show_exception (
39 p_routine IN VARCHAR2);
40
41 --
42 -- Standard Logging Procedures
43 -- To be dropped.
44 --
45 PROCEDURE Log(
46 p_level IN NUMBER,
47 p_module IN VARCHAR2,
48 p_message_text IN VARCHAR2);
49
50 PROCEDURE Log_Statement(
51 p_module IN VARCHAR2,
52 p_message_text IN VARCHAR2);
53
54 PROCEDURE Log_Procedure(
55 p_module IN VARCHAR2,
56 p_message_text IN VARCHAR2);
57
58 PROCEDURE Log_Event(
59 p_module IN VARCHAR2,
60 p_message_text IN VARCHAR2);
61
62 PROCEDURE Log_Exception(
63 p_module IN VARCHAR2,
64 p_message_text IN VARCHAR2);
65
66 PROCEDURE Log_Error(
67 p_module IN VARCHAR2,
68 p_message_text IN VARCHAR2);
69
70 PROCEDURE Log_Unexpected(
71 p_module IN VARCHAR2,
72 p_message_text IN VARCHAR2);
73 --
74 -- APIs to Create Sequencing Rules
75 --
76 PROCEDURE create_entity (
77 p_application_id IN NUMBER,
78 p_table_name IN VARCHAR2,
79 p_entity_name IN VARCHAR2);
80
81 PROCEDURE create_sequencing_rule (
82 p_application_id IN NUMBER,
83 p_table_name IN VARCHAR2,
84 p_context_type IN VARCHAR2,
85 p_event_code IN VARCHAR2,
86 p_date_type IN VARCHAR2,
87 p_flex_context_code IN VARCHAR2);
88
89 PROCEDURE delete_entity (
90 p_application_id IN NUMBER,
91 p_table_name IN VARCHAR2);
92
93 PROCEDURE delete_sequencing_rule (
94 p_application_id IN NUMBER,
95 p_table_name IN VARCHAR2,
96 p_context_type IN VARCHAR2,
97 p_event_code IN VARCHAR2,
98 p_date_type IN VARCHAR2);
99
100 PROCEDURE update_entity (
101 p_application_id IN NUMBER,
102 p_table_name IN VARCHAR2,
103 p_entity_name IN VARCHAR2);
104
105 FUNCTION is_context_type_valid (
106 p_context_type IN VARCHAR2) RETURN BOOLEAN;
107
108 FUNCTION is_event_valid (
109 p_event IN VARCHAR2) RETURN BOOLEAN;
110
111 FUNCTION is_date_type_valid (
112 p_date_type IN VARCHAR2) RETURN BOOLEAN;
113
114 FUNCTION is_lookup_valid (
115 p_lookup_type IN VARCHAR2,
116 p_lookup_code IN VARCHAR2) RETURN BOOLEAN;
117
118 FUNCTION is_table_name_valid (
119 p_application_id IN NUMBER,
120 p_table_name IN VARCHAR2) RETURN BOOLEAN;
121
122 FUNCTION find_table_name_in_cache (
123 p_table_name_rec IN Table_Name_Rec) RETURN BINARY_INTEGER;
124
125 FUNCTION find_table_name_in_db (
126 p_table_Name_rec IN Table_Name_Rec) RETURN BOOLEAN;
127
128 FUNCTION is_seq_entity_registered (
129 p_application_id IN NUMBER,
130 p_table_name IN VARCHAR2) RETURN BOOLEAN;
131
132 --
133 -- Create Sequencing Setup Data
134 --
135 -- PROCEDURE create_setup_data
136 --
137 PROCEDURE create_setup_data (
138 p_sequence_rec IN sequence_rec_type,
139 p_version_rec IN version_rec_type,
140 p_context_rec IN context_rec_type,
141 p_assignment_rec IN assignment_rec_type,
142 p_owner IN VARCHAR2,
143 p_last_update_date IN VARCHAR2,
144 p_custom_mode IN VARCHAR2);
145
146 PROCEDURE create_sequence (
147 p_sequence_rec IN sequence_rec_type,
148 p_owner IN VARCHAR2,
149 p_last_update_date IN VARCHAR2,
150 p_custom_mode IN VARCHAR2,
151 x_seq_header_id OUT NOCOPY NUMBER);
152
153 PROCEDURE create_version (
154 p_seq_header_id IN NUMBER,
155 p_header_name IN VARCHAR2,
156 p_version_rec IN version_rec_type,
157 p_owner IN VARCHAR2,
158 p_last_update_date IN VARCHAR2,
159 p_custom_mode IN VARCHAR2);
160
161 PROCEDURE recreate_version;
162
163 PROCEDURE create_db_sequence (
164 p_seq_version_id IN NUMBER,
165 p_initial_value IN NUMBER);
166
167 PROCEDURE create_context (
168 p_context_rec IN context_rec_type,
169 p_owner IN VARCHAR2,
170 p_last_update_date IN VARCHAR2,
171 p_custom_mode IN VARCHAR2,
172 x_seq_context_id OUT NOCOPY NUMBER);
173
174 PROCEDURE create_assignment (
175 p_seq_context_id IN NUMBER,
176 p_seq_header_id IN NUMBER,
177 p_assignment_rec IN assignment_rec_type,
178 p_owner IN VARCHAR2,
179 p_last_update_date IN VARCHAR2,
180 p_custom_mode IN VARCHAR2);
181
182 PROCEDURE delete_sequence (
183 p_header_name IN VARCHAR2);
184
185 PROCEDURE delete_context (
186 p_context_name IN VARCHAR2);
187
188 PROCEDURE obsolete_version (
189 p_seq_version_id IN NUMBER);
190
191 PROCEDURE get_active_version (
192 p_header_name IN VARCHAR2,
193 x_seq_header_id OUT NOCOPY NUMBER,
194 x_seq_version_id OUT NOCOPY NUMBER,
195 x_version_rec OUT NOCOPY version_rec_type);
196
197 FUNCTION get_max_number RETURN NUMBER;
198
199 END fun_seq_utils;