1 PACKAGE FEM_Dim_Hier_Util_Pkg AS
2 --$Header: fem_dimhier_pkh.pls 120.0 2005/06/06 19:02:40 appldev noship $
3
4 ------------------------
5 -- Package Constants --
6 ------------------------
7
8 c_fem_ledger CONSTANT VARCHAR2(30) := 'FEM_LEDGER';
9 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
10 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
11 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14 c_api_version CONSTANT NUMBER := 1.0;
15
16 ------------------
17 -- Subprograms --
18 ------------------
19 PROCEDURE New_Hier_Object (
20 p_api_version IN NUMBER DEFAULT c_api_version,
21 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
22 p_commit IN VARCHAR2 DEFAULT c_false,
23 p_encoded IN VARCHAR2 DEFAULT c_true,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 x_hier_obj_id OUT NOCOPY NUMBER,
28 x_hier_obj_def_id OUT NOCOPY NUMBER,
29 p_folder_id IN NUMBER,
30 p_global_vs_combo_id IN NUMBER,
31 p_object_access_code IN VARCHAR2,
32 p_object_origin_code IN VARCHAR2,
33 p_object_name IN VARCHAR2,
34 p_description IN VARCHAR2,
35 p_effective_start_date IN DATE DEFAULT sysdate,
36 p_effective_end_date IN DATE DEFAULT to_date
37 ('9999/01/01','YYYY/MM/DD'),
38 p_obj_def_name IN VARCHAR2,
39 p_dimension_id IN NUMBER,
40 p_hier_type_code IN VARCHAR2,
41 p_grp_seq_code IN VARCHAR2,
42 p_multi_top_flg IN VARCHAR2,
43 p_fin_ctg_flg IN VARCHAR2,
44 p_multi_vs_flg IN VARCHAR2,
45 p_hier_usage_code IN VARCHAR2,
46 p_flat_rows_flag IN VARCHAR2 DEFAULT 'N',
47 p_gl_period_type IN VARCHAR2 DEFAULT NULL,
48 p_calendar_id IN NUMBER DEFAULT NULL,
49 p_val_set_id1 IN NUMBER DEFAULT NULL,
50 p_val_set_id2 IN NUMBER DEFAULT NULL,
51 p_val_set_id3 IN NUMBER DEFAULT NULL,
52 p_val_set_id4 IN NUMBER DEFAULT NULL,
53 p_val_set_id5 IN NUMBER DEFAULT NULL,
54 p_val_set_id6 IN NUMBER DEFAULT NULL,
55 p_val_set_id7 IN NUMBER DEFAULT NULL,
56 p_val_set_id8 IN NUMBER DEFAULT NULL,
57 p_val_set_id9 IN NUMBER DEFAULT NULL,
58 p_dim_grp_id1 IN NUMBER DEFAULT NULL,
59 p_dim_grp_id2 IN NUMBER DEFAULT NULL,
60 p_dim_grp_id3 IN NUMBER DEFAULT NULL,
61 p_dim_grp_id4 IN NUMBER DEFAULT NULL,
62 p_dim_grp_id5 IN NUMBER DEFAULT NULL,
63 p_dim_grp_id6 IN NUMBER DEFAULT NULL,
64 p_dim_grp_id7 IN NUMBER DEFAULT NULL,
65 p_dim_grp_id8 IN NUMBER DEFAULT NULL,
66 p_dim_grp_id9 IN NUMBER DEFAULT NULL
67 );
68
69 PROCEDURE New_Hier_Object_Def (
70 p_api_version IN NUMBER DEFAULT c_api_version,
71 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
72 p_commit IN VARCHAR2 DEFAULT c_false,
73 p_encoded IN VARCHAR2 DEFAULT c_true,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 x_hier_obj_def_id OUT NOCOPY NUMBER,
78 p_hier_obj_id IN NUMBER,
79 p_obj_def_name IN VARCHAR2,
80 p_effective_start_date IN DATE,
81 p_effective_end_date IN DATE,
82 p_object_origin_code IN VARCHAR2
83 );
84
85 PROCEDURE New_GL_Cal_Period_Hier (
86 p_api_version IN NUMBER DEFAULT c_api_version,
87 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
88 p_commit IN VARCHAR2 DEFAULT c_false,
89 p_encoded IN VARCHAR2 DEFAULT c_true,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_hier_obj_id OUT NOCOPY NUMBER,
94 x_hier_obj_def_id OUT NOCOPY NUMBER,
95 p_folder_id IN NUMBER,
96 p_object_access_code IN VARCHAR2,
97 p_object_origin_code IN VARCHAR2,
98 p_object_name IN VARCHAR2,
99 p_description IN VARCHAR2,
100 p_effective_start_date IN DATE DEFAULT sysdate,
101 p_effective_end_date IN DATE DEFAULT to_date
102 ('9999/01/01','YYYY/MM/DD'),
103 p_obj_def_name IN VARCHAR2,
104 p_grp_seq_code IN VARCHAR2,
105 p_multi_top_flg IN VARCHAR2,
106 p_gl_period_type IN VARCHAR2,
107 p_dim_grp_id IN NUMBER,
108 p_calendar_id IN NUMBER
109 );
110
111 END FEM_Dim_Hier_Util_Pkg;
112