1 PACKAGE MSD_DEM_PUSH_SETUP_PARAMETERS AUTHID CURRENT_USER AS
2 /* $Header: msddempsps.pls 120.3 2011/06/02 06:44:50 mpmurali ship $ */
3
4
5 /*** PROCEDURES ***/
6
7 /*
8 * This procedure pushes the profile values, collection enabled orgs and
9 * the time data in the source instance, which will be used in the source
10 * views.
11 */
12 PROCEDURE PUSH_SETUP_PARAMETERS (
13 errbuf OUT NOCOPY VARCHAR2,
14 retcode OUT NOCOPY VARCHAR2,
15 p_sr_instance_id IN NUMBER,
16 p_collection_group IN VARCHAR2,
17 p_for_spf IN NUMBER DEFAULT 2);
18 /*
19 * This procedure updates profiles values configure for a particular legacy instance
20 * to the legacy profiles table - MSD_DEM_LEGACY_SETUP_PARAMS
21 */
22 PROCEDURE CONFIGURE_LEGACY_PROFILES (
23 errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY VARCHAR2,
25 p_legacy_instance_id IN NUMBER,
26 p_master_org IN NUMBER,
27 p_sr_category_set_id IN NUMBER);
28
29 /*
30 * This procedure pushes profiles values for a particular legacy instance
31 * from legacy profiles table - MSD_DEM_LEGACY_SETUP_PARAMS to setup parameters table - MSD_DEM_SETUP_PARAMETERS
32 */
33 PROCEDURE PUSH_LEGACY_SETUP_PARAMETERS (
34 errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY VARCHAR2,
36 p_legacy_instance_id IN NUMBER);
37
38
39
40 END MSD_DEM_PUSH_SETUP_PARAMETERS;