[Home] [Help]
PACKAGE: APPS.FEM_COL_TMPLT_DEFN_API_PUB
Source
1 PACKAGE Fem_Col_Tmplt_Defn_Api_Pub AS
2 /* $Header: FEMCOLTMPLTS.pls 120.2 2006/06/01 13:40:27 ssthiaga noship $ */
3
4 -------------------------------
5 -- Declare package constants --
6 -------------------------------
7
8 g_object_version_number CONSTANT NUMBER := 1;
9 g_block CONSTANT VARCHAR2(30) := 'FEM_COL_TMPLT_DEFN_API_PUB';
10 g_pkg_name CONSTANT VARCHAR2(30) := 'FEM_COL_TMPLT_DEFN_API_PUB';
11 g_object_type_code CONSTANT VARCHAR2(30) := 'PPROF_COL_POP_TMPLT';
12
13 g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
14 g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
15 g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
16 g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
17 g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
18 g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
19
20
21 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
24 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
25 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
26 c_api_version CONSTANT NUMBER := 1.0;
27
28 G_CONDITION_PREDICATE_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_COND_PRED_ERR';
29 G_DS_WHERE_PREDICATE_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_DS_WHERE_CLAS_ERR';
30 G_NO_ATTR_VALUE_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_ENG_NO_ATT_VAL_ERR';
31 G_NO_ATTR_VER_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_ENG_NO_ATT_VER_ERR';
32 G_GENERATE_PREDICATES_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_GEN_PRED_ERR';
33 G_GENERATE_WHERE_CLAUSE_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_GEN_WHERE_CLAS_ERR';
34 G_INVALID_DATASET_GRP_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_INV_DSG_ERR';
35 G_INVALID_ACCT_OWNER_ID_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_NO_ACCT_OWNER_ID';
36 G_NO_EXCHG_RATE_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_NO_EXCHG_RATE';
37 G_INV_EXCHG_RATE_TYPE_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_NO_EXCHG_RATE_TYPE';
38 G_NO_FUNCTIONAL_CURR_ERR CONSTANT VARCHAR2(30) := 'FEM_COL_POP_NO_FUNC_CURR';
39
40 g_src_tab_name VARCHAR2(30);
41 g_src_alias VARCHAR2(10);
42
43 g_tgt_tab_name VARCHAR2(30);
44 g_tgt_alias VARCHAR2(10);
45
46 g_sec_alias VARCHAR2(10);
47
48 g_table_id NUMBER;
49
50 g_curr_conv_type VARCHAR2(30);
51 g_func_curr_code VARCHAR2(30);
52 g_exch_rate_date DATE;
53
54 -- Object def ID
55
56 g_object_id NUMBER;
57 g_obj_def_id NUMBER;
58 g_effective_date DATE;
59
60 g_col_pop_seed_del BOOLEAN := FALSE;
61
62
63 TYPE attr_list_rec IS RECORD
64 (
65 attribute_tab_name VARCHAR2(30),
66 attribute_tab_count NUMBER
67 );
68
69 TYPE attr_list_arr IS TABLE OF attr_list_rec INDEX BY BINARY_INTEGER;
70
71 -- attr_detail_rec attr_list_arr;
72
73 FUNCTION get_alias(p_tab_name IN VARCHAR2, p_alias IN VARCHAR2) RETURN VARCHAR2;
74
75 PROCEDURE get_alias(p_attr_detail_rec IN OUT NOCOPY attr_list_arr,
76 p_tab_name IN VARCHAR2,
77 p_alias OUT NOCOPY VARCHAR2);
78
79 FUNCTION get_param_value(p_column_name IN VARCHAR2,
80 p_param_val IN VARCHAR2) RETURN VARCHAR2 ;
81
82 PROCEDURE get_from_where_clause(p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2,
84 p_commit IN VARCHAR2,
85 p_encoded IN VARCHAR2,
86 p_object_def_id IN NUMBER,
87 p_load_sec_relns IN BOOLEAN,
88 p_dataset_grp_obj_def_id IN NUMBER,
89 p_cal_period_id IN NUMBER,
90 p_ledger_id IN NUMBER,
91 p_source_system_code IN NUMBER,
92 p_created_by_object_id IN NUMBER,
93 p_created_by_request_id IN NUMBER,
94 p_insert_list OUT NOCOPY LONG,
95 p_select_list OUT NOCOPY LONG,
96 p_from_clause OUT NOCOPY LONG,
97 p_where_clause OUT NOCOPY LONG,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_return_status OUT NOCOPY VARCHAR2);
101
102 FUNCTION is_aggregation_Present(p_object_def_id IN NUMBER) RETURN BOOLEAN;
103
104 PROCEDURE generate_predicates(p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2,
106 p_commit IN VARCHAR2,
107 p_encoded IN VARCHAR2,
108 p_object_def_id IN NUMBER,
109 p_selection_param IN NUMBER,
110 p_effective_date IN VARCHAR2,
111 p_condition_obj_id IN NUMBER,
112 p_condition_sel_param IN VARCHAR2,
113 p_load_sec_relns IN VARCHAR2,
114 p_dataset_grp_obj_def_id IN NUMBER,
115 p_cal_period_id IN NUMBER,
116 p_ledger_id IN NUMBER,
117 p_source_system_code IN NUMBER,
118 p_created_by_object_id IN NUMBER,
119 p_created_by_request_id IN NUMBER,
120 p_insert_list OUT NOCOPY LONG,
121 p_select_list OUT NOCOPY LONG,
122 p_from_clause OUT NOCOPY LONG,
123 p_where_clause OUT NOCOPY LONG,
124 p_con_where_clause OUT NOCOPY LONG,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2);
128
129
130 END Fem_Col_Tmplt_Defn_Api_Pub;