PACKAGE: APPS.ITA_RECORD_CURR_STATUS_PKG

Source

1 package ITA_RECORD_CURR_STATUS_PKG as
2 /* $Header: itarcurs.pls 120.4 2006/11/09 01:16:10 cpetriuc noship $ */
3 
4 PROCEDURE enable_tracking(errbuf  OUT NOCOPY VARCHAR2,
5                       retcode OUT NOCOPY VARCHAR2, p_table_name IN VARCHAR2);
6 
7 FUNCTION enable_tracking_for_table
8 (p_application_id IN NUMBER,
9  p_table_name     IN VARCHAR2)
10 RETURN NUMBER;
11 
12 FUNCTION set_audit_start_date
13 (p_application_id IN NUMBER,
14  p_table_name     IN VARCHAR2)
15 RETURN NUMBER;
16 
17 FUNCTION get_shadow_table_prefix
18 (p_table_name     IN VARCHAR2)
19 RETURN VARCHAR2;
20 
21 FUNCTION create_shadow_trigger
22 (p_application_id IN NUMBER,
23  p_table_name     IN VARCHAR2)
24 RETURN NUMBER;
25 
26 FUNCTION record_current_state
27 (p_application_id IN NUMBER,
28  p_table_name     IN VARCHAR2)
29 RETURN NUMBER;
30 
31 FUNCTION record_profile_current_state
32 (p_application_id IN NUMBER,
33  p_table_name     IN VARCHAR2)
34 RETURN NUMBER;
35 
36 FUNCTION get_profile_value_meaning
37 (p_profile_sql        IN VARCHAR2,
38  p_profile_value_code IN VARCHAR2)
39 RETURN VARCHAR2;
40 
41 FUNCTION strip_profile_query
42 (p_profile_sql        IN VARCHAR2)
43 RETURN VARCHAR2;
44 
45 FUNCTION strip_double_quotes
46 (p_profile_sql        IN VARCHAR2)
47 RETURN VARCHAR2;
48 
49 FUNCTION strip_aliases
50 (p_profile_sql        IN VARCHAR2)
51 RETURN VARCHAR2;
52 
53 end ITA_RECORD_CURR_STATUS_PKG;