[Home] [Help]
Skip to content
PACKAGE: APPS.FEM_SETUP_PKG
Source
1 PACKAGE fem_setup_pkg AS
2 /* $Header: fem_setup_pkg.pls 120.2 2006/05/18 04:43:27 sshanmug noship $ */
3
4 c_false CONSTANT VARCHAR2(1) := fnd_api.g_false;
5 c_true CONSTANT VARCHAR2(1) := fnd_api.g_true;
6 c_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
7 c_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
8 c_unexp CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
9 c_api_version CONSTANT NUMBER := 1.0;
10
11 g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
12 g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
13 g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
14 g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
15 g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
16 g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
17
18 g_block CONSTANT VARCHAR2(80) := 'FEM.PLSQL.FEM_SETUP_PKG';
19
20 -- TYPE col_list_arr IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
21
22 PROCEDURE register_activity_ff(p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2,
24 p_commit IN VARCHAR2,
25 p_encoded IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2);
29
30 PROCEDURE register_cost_ff(p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2,
32 p_commit IN VARCHAR2,
33 p_encoded IN VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2);
37
38 PROCEDURE compile_ff(p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2,
40 p_commit IN VARCHAR2,
41 p_encoded IN VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_ff_name IN VARCHAR2,
46 p_comdim_ff_rec IN fnd_flex_key_api.flexfield_type,
47 p_comdim_str_rec IN fnd_flex_key_api.structure_type);
48 /*
49 PROCEDURE validate_proc_key(p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2,
51 p_commit IN VARCHAR2,
52 p_encoded IN VARCHAR2,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_col_list_rec IN fem_col_list_arr_typ,
57 p_table_name IN VARCHAR2);
58 */
59 PROCEDURE validate_proc_key(p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2,
61 p_commit IN VARCHAR2,
62 p_encoded IN VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_dimension_varchar_label IN VARCHAR2,
67 p_table_name IN VARCHAR2);
68
69
70 PROCEDURE delete_flexfield (p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2,
72 p_commit IN VARCHAR2,
73 p_encoded IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_dimension_varchar_label IN VARCHAR2);
78
79
80
81 END fem_setup_pkg;