[Home] [Help]
PACKAGE: APPS.PV_CONTEXT_VALUES
Source
1 package PV_CONTEXT_VALUES
2 /* $Header: pvxvcons.pls 120.3 2005/12/27 13:17:33 amaram noship $*/
3 AUTHID CURRENT_USER
4 AS
5
6 -- ----------------------------------------------------------------------------
7 -- Global Variables
8 -- ----------------------------------------------------------------------------
9 g_full_refresh CONSTANT VARCHAR2(30) := 'FULL';
10 g_incr_refresh CONSTANT VARCHAR2(30) := 'INCR';
11 g_incr_full_refresh CONSTANT VARCHAR2(30) := 'INCR-FULL';
12
13
14 -- ----------------------------------------------------------------------------
15 -- Public Procedures
16 -- ----------------------------------------------------------------------------
17 procedure Exec_Create_context_Val ( ERRBUF OUT NOCOPY VARCHAR2,
18 RETCODE OUT NOCOPY VARCHAR2,
19 p_new_partners_only IN VARCHAR2 := 'N',
20 p_log_to_file IN VARCHAR2 := 'Y');
21
22
23 PROCEDURE Pre_Processing (
24 p_refresh_type IN VARCHAR2 := g_full_refresh,
25 p_synonym_name IN VARCHAR2,
26 p_mirror_synonym_name IN VARCHAR2,
27 p_temp_synonym_name IN VARCHAR2,
28 p_partner_id_temp_table IN VARCHAR2 := null,
29 p_temp_table_processed IN BOOLEAN := FALSE,
30 p_last_incr_refresh_str IN VARCHAR2 := null,
31 p_log_to_file IN VARCHAR2 := 'Y',
32 p_module_name IN VARCHAR2,
33 p_pv_schema_name IN OUT NOCOPY VARCHAR2,
34 p_search_table OUT NOCOPY VARCHAR2,
35 p_mirror_table OUT NOCOPY VARCHAR2,
36 p_end_refresh_flag OUT NOCOPY BOOLEAN,
37 p_out_refresh_type OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE Post_Processing (
41 p_refresh_type IN VARCHAR2 := g_full_refresh,
42 p_synonym_name IN VARCHAR2,
43 p_mirror_synonym_name IN VARCHAR2,
44 p_temp_synonym_name IN VARCHAR2,
45 p_pv_schema_name IN VARCHAR2,
46 p_search_table IN VARCHAR2,
47 p_mirror_table IN VARCHAR2,
48 p_incr_timestamp IN VARCHAR2,
49 p_api_package_name IN VARCHAR2,
50 p_module_name IN VARCHAR2,
51 p_log_to_file IN VARCHAR2 := 'Y'
52 ) ;
53
54
55 PROCEDURE Disable_Drop_Indexes(
56 p_mirror_table IN VARCHAR2,
57 p_pv_schema_owner IN VARCHAR2
58 );
59
60 PROCEDURE Enable_Create_Indexes(
61 p_search_table IN VARCHAR2,
62 p_mirror_table IN VARCHAR2,
63 p_pv_schema_owner IN VARCHAR2
64 );
65
66 PROCEDURE Create_Indexes(
67 p_table1 IN VARCHAR2,
68 p_table2 IN VARCHAR2,
69 p_pv_schema_owner IN VARCHAR2
70 );
71
72
73 end PV_CONTEXT_VALUES;