[Home] [Help]
PACKAGE: APPS.BSC_BIS_DIM_REL_PUB
Source
1 PACKAGE BSC_BIS_DIM_REL_PUB AS
2 /* $Header: BSCRPMDS.pls 120.1 2007/02/08 10:14:25 psomesul ship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BSCRPMDS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Wrapper for Dimension-Relationships, part of PMD APIs |
13 REM | |
14 REM | NOTES |
15 REM | 14-FEB-2003 PAJOHRI Created. |
16 REM | 04-NOV-2003 PAJOHRI Bug #3152258 |
17 REM | 08-DEC-2003 KYADAMAK Bug #3225685 |
18 REM | 05-NOV-2004 ashankar bug #3459282 |
19 REM | 16-12-2006 PSOMESUL E#5678943 MIGRATE COMMON DIMENSIONS AND DIMENSION FILTERS TO SCORECARD DESIGNER|
20 REM +=======================================================================+
21 */
22 /*********************************************************************************
23 ASSIGN DIMENSION-OBJECTS RELATIONSHIP
24 *********************************************************************************/
25 l_Child_Dim_Obj_Count NUMBER:=0;
26 l_child_dim_objs VARCHAR2(2000);
27
28 C_SELECT CONSTANT VARCHAR2(10) := ' SELECT ';
29 C_WHERE CONSTANT VARCHAR2(10) := ' WHERE ';
30 C_FROM CONSTANT VARCHAR2(10) := ' FROM ';
31
32 C_SELECT_CLAUSE CONSTANT VARCHAR2(30) := ' CODE, USER_CODE ,NAME ';
33 C_WHERE_CLAUSE CONSTANT VARCHAR2(20) := ' ROWNUM < 2 ';
34
35 PROCEDURE Assign_Dim_Obj_Rels
36 (
37 p_commit IN VARCHAR2 := FND_API.G_TRUE
38 , p_dim_obj_id IN NUMBER
39 , p_parent_ids IN VARCHAR2
40 , p_parent_rel_type IN VARCHAR2
41 , p_parent_rel_column IN VARCHAR2
42 , p_parent_data_type IN VARCHAR2
43 , p_parent_data_source IN VARCHAR2
44 , p_child_ids IN VARCHAR2
45 , p_child_rel_type IN VARCHAR2
46 , p_child_rel_column IN VARCHAR2
47 , p_child_data_type IN VARCHAR2
48 , p_child_data_source IN VARCHAR2
49 , p_time_stamp IN VARCHAR2 := NULL -- Granular Locking
50 , x_return_status OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 , x_msg_data OUT NOCOPY VARCHAR2
53 );
54 /*********************************************************************************
55 ASSIGN DIMENSION-OBJECTS RELATIONSHIPS
56 *********************************************************************************/
57 PROCEDURE Assign_New_Dim_Obj_Rels
58 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
59 , p_dim_obj_id IN NUMBER
60 , p_parent_ids IN VARCHAR2
61 , p_parent_rel_type IN VARCHAR2
62 , p_parent_rel_column IN VARCHAR2
63 , p_parent_data_type IN VARCHAR2
64 , p_parent_data_source IN VARCHAR2
65 , p_child_ids IN VARCHAR2
66 , p_child_rel_type IN VARCHAR2
67 , p_child_rel_column IN VARCHAR2
68 , p_child_data_type IN VARCHAR2
69 , p_child_data_source IN VARCHAR2
70 , p_time_stamp IN VARCHAR2 := NULL -- Granular Locking
71 , p_is_not_config IN BOOLEAN := TRUE
72 , x_return_status OUT NOCOPY VARCHAR2
73 , x_msg_count OUT NOCOPY NUMBER
74 , x_msg_data OUT NOCOPY VARCHAR2
75 );
76 /*********************************************************************************
77 UNASSIGN DIMENSION-OBJECTS RELATIONSHIPS
78 *********************************************************************************/
79 PROCEDURE UnAssign_Dim_Obj_Rels
80 (
81 p_commit IN VARCHAR2 := FND_API.G_TRUE
82 , p_dim_obj_id IN NUMBER
83 , p_parent_ids IN VARCHAR2
84 , p_child_ids IN VARCHAR2
85 , p_time_stamp IN VARCHAR2 := NULL -- Granular Locking
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 /*********************************************************************************
92 FUNCTION GET_PARENTS
93 *********************************************************************************/
94 FUNCTION get_parents
95 (
96 p_dim_obj_id IN NUMBER
97 )
98 RETURN VARCHAR2;
99
100 /*********************************************************************************
101 FUNCTION GET_CHILDS
102 *********************************************************************************/
103 FUNCTION get_children
104 (
105 p_dim_obj_id IN NUMBER
106 )
107 RETURN VARCHAR2;
108 /*********************************************************************************/
109 FUNCTION check_invalid_pmf_view_inrel
110 (
111 p_dim_obj_id IN NUMBER
112 , p_parent_ids IN VARCHAR2
113 , p_parent_rel_type IN VARCHAR2
114 , p_parent_rel_column IN VARCHAR2
115 , p_parent_data_type IN VARCHAR2
116 , p_parent_data_source IN VARCHAR2
117 , p_child_ids IN VARCHAR2
118 , p_child_rel_type IN VARCHAR2
119 , p_child_rel_column IN VARCHAR2
120 , p_child_data_type IN VARCHAR2
121 , p_child_data_source IN VARCHAR2
122 , p_time_stamp IN VARCHAR2 := NULL -- Granular Locking
123 ) RETURN VARCHAR2;
124
125 /*********************************************************************************/
126 FUNCTION is_KPI_Flag_For_Dim_Obj_Rels
127 ( p_dim_obj_id IN NUMBER
128 , p_parent_ids IN VARCHAR2
129 , p_parent_rel_type IN VARCHAR2
130 , p_child_ids IN VARCHAR2
131 , p_child_rel_type IN VARCHAR2
132 ) RETURN VARCHAR2;
133 /*********************************************************************************/
134 FUNCTION check_config_impact_rels
135 (
136 p_dim_obj_id IN NUMBER
137 , p_parent_ids IN VARCHAR2
138 , p_parent_rel_type IN VARCHAR2
139 , p_parent_rel_column IN VARCHAR2
140 , p_parent_data_type IN VARCHAR2
141 , p_parent_data_source IN VARCHAR2
142 , p_child_ids IN VARCHAR2
143 , p_child_rel_type IN VARCHAR2
144 , p_child_rel_column IN VARCHAR2
145 , p_child_data_type IN VARCHAR2
146 , p_child_data_source IN VARCHAR2
147 , p_time_stamp IN VARCHAR2 := NULL -- Granular Locking
148
149 ) RETURN VARCHAR2;
150
151
152 PROCEDURE Verify_Recreate_Filter_Views
153 (
154 p_source IN NUMBER
155 , p_level_view_name IN BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE
156 , p_dim_level_id IN BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE
157 , x_return_status OUT NOCOPY VARCHAR2
158 , x_msg_count OUT NOCOPY NUMBER
159 , x_msg_data OUT NOCOPY VARCHAR2
160 );
161
162 END BSC_BIS_DIM_REL_PUB;