[Home] [Help]
PACKAGE: APPS.FEM_ALLOC_BR_UTIL_PKG
Source
1 PACKAGE fem_alloc_br_util_pkg as
2 --$Header: fem_alloc_br_utl.pls 120.7 2008/02/20 06:53:51 jcliving 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
12 PROCEDURE create_snapshot (
13 p_map_rule_obj_def_id IN NUMBER,
14 p_snapshot_obj_type_code IN VARCHAR2 DEFAULT 'MAPPING_EDIT_SNAPSHOT',
15 p_api_version IN NUMBER DEFAULT c_api_version,
16 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
17 p_commit IN VARCHAR2 DEFAULT c_false,
18 p_encoded IN VARCHAR2 DEFAULT c_true,
19 x_snapshot_object_id OUT NOCOPY NUMBER,
20 x_snapshot_objdef_id OUT NOCOPY NUMBER,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2);
24
25 PROCEDURE refresh_maprule_from_snapshot (
26 p_map_rule_obj_def_id IN NUMBER,
27 p_api_version IN NUMBER DEFAULT c_api_version,
28 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
29 p_commit IN VARCHAR2 DEFAULT c_false,
30 p_encoded IN VARCHAR2 DEFAULT c_true,
31 x_snapshot_objdef_id OUT NOCOPY NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35
36 PROCEDURE refresh_snapshot_from_maprule (
37 p_map_rule_obj_def_id IN NUMBER,
38 p_api_version IN NUMBER DEFAULT c_api_version,
39 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
40 p_commit IN VARCHAR2 DEFAULT c_false,
41 p_encoded IN VARCHAR2 DEFAULT c_true,
42 x_snapshot_objdef_id OUT NOCOPY NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46
47 PROCEDURE refresh_snapshot_from_defaults (
48 p_map_rule_obj_def_id IN NUMBER,
49 p_api_version IN NUMBER DEFAULT c_api_version,
50 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
51 p_commit IN VARCHAR2 DEFAULT c_false,
52 p_encoded IN VARCHAR2 DEFAULT c_true,
53 x_snapshot_objdef_id OUT NOCOPY NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2);
57
58 PROCEDURE create_new_ver_from_defaults (
59 p_map_rule_obj_id IN NUMBER,
60 p_api_version IN NUMBER DEFAULT c_api_version,
61 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
62 p_commit IN VARCHAR2 DEFAULT c_false,
63 p_encoded IN VARCHAR2 DEFAULT c_true,
64 x_map_rule_objdef_id OUT NOCOPY NUMBER,
65 x_snapshot_objdef_id OUT NOCOPY NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69
70 PROCEDURE generate_condition_summary (
71 p_condition_object_id IN NUMBER,
72 p_api_version IN NUMBER DEFAULT c_api_version,
73 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
74 p_commit IN VARCHAR2 DEFAULT c_false,
75 p_encoded IN VARCHAR2 DEFAULT c_true,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2);
79
80 PROCEDURE get_default_definition (
81 p_map_rule_type_code IN VARCHAR2,
82 p_target_folder_id IN VARCHAR2 DEFAULT NULL,
83 p_api_version IN NUMBER DEFAULT c_api_version,
84 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
85 p_commit IN VARCHAR2 DEFAULT c_false,
86 p_encoded IN VARCHAR2 DEFAULT c_true,
87 x_dflt_objdef_id OUT NOCOPY NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2);
91
92 PROCEDURE generate_fctr_summary (
93 p_fctr_object_id IN NUMBER,
94 p_api_version IN NUMBER DEFAULT c_api_version,
95 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
96 p_commit IN VARCHAR2 DEFAULT c_false,
97 p_encoded IN VARCHAR2 DEFAULT c_true,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2);
101
102 FUNCTION get_rule_dirty_flag (p_map_rule_obj_def_id IN NUMBER) RETURN VARCHAR2;
103
104 FUNCTION defaults_exist(p_map_rule_type_code IN VARCHAR2) RETURN VARCHAR2;
105
106
107
108 END fem_alloc_br_util_pkg;