1 PACKAGE FEM_DIM_SNAPSHOT_ENG_PKG AUTHID CURRENT_USER AS
2 --$Header: fem_dimsnap_eng.pls 120.0 2005/10/19 19:22:43 appldev noship $
3 /*==========================================================================+
4 | Copyright (c) 1997 Oracle Corporation, Redwood Shores, CA, USA |
5 | All rights reserved. |
6 +==========================================================================+
7 | FILENAME
8 |
9 | fem_dim_snapshot_eng.pls
10 |
11 | NAME fem_dim_snapshot_eng_pkg
12 |
13 | DESCRIPTION
14 |
15 | Package Spec for fem_dim_snapshot_eng_pkg. This package provides functions
16 | and procedures required for creating Dimension Snapshots. A Dimension
17 | Snapshot is a capture of the member "state" of a set of designated
18 | dimensions. Only information for "shared" members is captured - information
19 | for personal members is ignored. Information for each member (such as the
20 | attribute assignments) is copied into the Dimension Snapshot
21 | repository so that they can be accessed by applications (such as EPB)
22 | while the dimension state information in FEM continues to evolve.
23 |
24 | Currently the engine only captures the following information:
25 | -- version translatable names and descriptions
26 | -- attribute assignments
27 |
28 | The engine captures the above information for each dimension
29 | specified in the Dimension Snapshot rule. The attribute information is
30 | copied into a seperate DNSP ATTR table for each specified attributed
31 | dimension while the version information is copied into a single
32 | shared table FEM_DSNP_DIM_ATTR_VRS_TL.
33 |
34 | In both cases, the engine only captures those versions designated as the
35 | "default" version for each attribute of that dimension.
36 |
37 | HISTORY
38 |
39 | 29-JUN-05 Created
40 |
41 |
42 +=========================================================================*/
43
44
45 ------------------------
46 -- Package Constants --
47 ------------------------
48
49 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
50 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
51 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
52 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
53 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
54 c_api_version CONSTANT NUMBER := 1.0;
55
56 c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
57 c_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
58
59
60 PROCEDURE Main (
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_api_version IN NUMBER DEFAULT c_api_version,
65 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
66 p_commit IN VARCHAR2 DEFAULT c_true,
67 p_encoded IN VARCHAR2 DEFAULT c_true,
68 p_dim_snapshot_obj_def_id IN NUMBER
69 );
70
71 END fem_dim_snapshot_eng_pkg;
72