[Home] [Help]
PACKAGE: APPS.FEM_DIM_GROUPS_UTIL_PKG
Source
1 PACKAGE FEM_DIM_GROUPS_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: fem_dimgrp_utl.pls 120.1 2005/07/20 14:41:05 appldev ship $ */
3 /*=======================================================================+
4 Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME
8 | fem_dimgrp_utl.pls
9 |
10 | DESCRIPTION
11 | Utility package for Dimension Groups (also known as "levels")
12 |
13 | MODIFICATION HISTORY
14 | Robert Flippo 06/03/2005 Created
15 | Robert Flippo 07/20/2005 Bug#4504983 Add dim_group_sequence as
16 | OUT parm; Add NULL default for
17 | p_dimension_group_seq
18 |
19 *=======================================================================*/
20 ------------------------
21 -- Package Constants --
22 ------------------------
23 pc_pkg_name CONSTANT VARCHAR2(30) := 'fem_dim_groups_util_pkg';
24
25 pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
26 pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
27 pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
28
29 pc_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
30 pc_last_update_login CONSTANT NUMBER := FND_GLOBAL.Login_Id;
31 pc_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
32
33 pc_object_version_number CONSTANT NUMBER := 1;
34
35 pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
36 pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
37 pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
38 pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
39 pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
40 pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
41
42 pc_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
43 pc_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
44
45 ------------------
46 -- Subprograms --
47 ------------------
48
49 PROCEDURE create_dim_group (x_dimension_group_id OUT NOCOPY NUMBER
50 ,x_dim_group_sequence OUT NOCOPY NUMBER
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,p_api_version IN NUMBER DEFAULT 1.0
55 ,p_init_msg_list IN VARCHAR2 DEFAULT pc_false
56 ,p_commit IN VARCHAR2 DEFAULT pc_false
57 ,p_encoded IN VARCHAR2 DEFAULT pc_true
58 ,p_dimension_varchar_label IN VARCHAR2
59 ,p_dim_group_display_code IN VARCHAR2
60 ,p_dim_group_name IN VARCHAR2
61 ,p_dim_group_description IN VARCHAR2
62 ,p_dim_group_sequence IN NUMBER DEFAULT NULL
63 ,p_time_group_type_code IN VARCHAR2 DEFAULT NULL);
64
65
66 END FEM_DIM_GROUPS_UTIL_PKG;
67