PACKAGE: APPS.FEM_FACTOR_TABLES_UTIL_PKG

Source

1 PACKAGE fem_factor_tables_util_pkg AS
2 /* $Header: FEMFACTTABS.pls 120.1 2008/02/20 06:46:25 jcliving noship $ */
3 
4    g_log_level_1     CONSTANT  NUMBER      := fnd_log.level_statement;
5    g_log_level_2     CONSTANT  NUMBER      := fnd_log.level_procedure;
6    g_log_level_3     CONSTANT  NUMBER      := fnd_log.level_event;
7    g_log_level_4     CONSTANT  NUMBER      := fnd_log.level_exception;
8    g_log_level_5     CONSTANT  NUMBER      := fnd_log.level_error;
9    g_log_level_6     CONSTANT  NUMBER      := fnd_log.level_unexpected;
10    g_block         CONSTANT VARCHAR2(30) := 'FEM_FACTOR_TABLE_UTIL_PKG';
11 
12    c_false           CONSTANT  VARCHAR2(1) := FND_API.G_FALSE;
13    c_true            CONSTANT  VARCHAR2(1) := FND_API.G_TRUE;
14    c_success         CONSTANT  VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15    c_error           CONSTANT  VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
16    c_unexp           CONSTANT  VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
17    c_api_version     CONSTANT  NUMBER      := 1.0;
18 
19 
20 
21    FUNCTION is_matching_dimension_leaf (p_object_definition_id IN NUMBER,
22                                         p_level_num IN NUMBER) RETURN VARCHAR2;
23 
24    PROCEDURE delete_member (p_object_definition_id IN NUMBER,
25                             p_row_num IN NUMBER);
26 
27    PROCEDURE CopyObjectDefinition (p_source_obj_def_id  IN NUMBER,
28                                    p_target_obj_def_id  IN NUMBER,
29                                    p_created_by         IN NUMBER,
30                                    p_creation_date      IN DATE );
31 
32 
33    PROCEDURE DeleteObjectDefinition ( p_obj_def_id  IN NUMBER );
34 
35    PROCEDURE VALIDATE_HIERARCHY (x_valid_flag OUT NOCOPY VARCHAR2,p_hier_obj_id IN NUMBER,p_dimension_id IN NUMBER);
36 
37    PROCEDURE VALIDATE_GROUP (x_valid_flag OUT NOCOPY VARCHAR2,p_hier_obj_id IN NUMBER,p_group_id IN NUMBER);
38 
39    PROCEDURE VALIDATE_DIM_MEMBER(x_valid_flag OUT NOCOPY VARCHAR2,p_hier_object_id IN NUMBER,p_group_id IN NUMBER,p_dimension_id IN NUMBER,p_member_id IN NUMBER);
40 
41    PROCEDURE GET_HIER_OBJ_DEF_ID(x_hier_obj_def_id OUT NOCOPY VARCHAR2,p_hier_obj_id IN VARCHAR2,p_hier_name IN VARCHAR2);
42 
43 END fem_factor_tables_util_pkg;