[Home] [Help]
PACKAGE: APPS.FEM_DIM_SNAPSHOT_UTIL_PKG
Source
1 PACKAGE FEM_DIM_SNAPSHOT_UTIL_PKG AUTHID CURRENT_USER AS
2 --$Header: fem_dimsnap_utl.pls 120.0 2005/10/19 19:25:10 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_utl.pls
10 |
11 | NAME fem_dim_snapshot_utl_pkg
12 |
13 | DESCRIPTION
14 |
15 | Package Spec for fem_dim_snapshot_utl_pkg. This package provides functions
16 | and procedures that support the Dimension Snapshot data model.
17 |
18 | HISTORY
19 |
20 | 01-JUL-05 Created
21 |
22 |
23 +=========================================================================*/
24
25
26 ------------------------
27 -- Package Constants --
28 ------------------------
29
30 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
31 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
32 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35 c_api_version CONSTANT NUMBER := 1.0;
36
37 c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
38 c_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
39
40
41 PROCEDURE Add_Dimension (
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_api_version IN NUMBER DEFAULT c_api_version,
46 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
47 p_commit IN VARCHAR2 DEFAULT c_false,
48 p_encoded IN VARCHAR2 DEFAULT c_true,
49 p_dim_snapshot_obj_def_id IN NUMBER,
50 p_dimension_varchar_label IN VARCHAR2
51 );
52
53
54 PROCEDURE Remove_Dimension (
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_api_version IN NUMBER DEFAULT c_api_version,
59 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
60 p_commit IN VARCHAR2 DEFAULT c_false,
61 p_encoded IN VARCHAR2 DEFAULT c_true,
62 p_dim_snapshot_obj_def_id IN NUMBER,
63 p_dimension_varchar_label IN VARCHAR2
64 );
65
66 END fem_dim_snapshot_util_pkg;
67
68
69