APPS.BSC_KPI_DIM_SETS_PKG dependencies on BSC_KPI_DIM_SETS_TL

Line 14: cursor C is select ROWID from BSC_KPI_DIM_SETS_TL

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from BSC_KPI_DIM_SETS_TL
15: where INDICATOR = X_INDICATOR
16: and DIM_SET_ID = X_DIM_SET_ID
17: and LANGUAGE = userenv('LANG')
18: ;

Line 20: insert into BSC_KPI_DIM_SETS_TL (

16: and DIM_SET_ID = X_DIM_SET_ID
17: and LANGUAGE = userenv('LANG')
18: ;
19: begin
20: insert into BSC_KPI_DIM_SETS_TL (
21: INDICATOR,
22: DIM_SET_ID,
23: NAME,
24: LANGUAGE,

Line 46: from BSC_KPI_DIM_SETS_TL T

42: from FND_LANGUAGES L
43: where L.INSTALLED_FLAG in ('I', 'B')
44: and not exists
45: (select NULL
46: from BSC_KPI_DIM_SETS_TL T
47: where T.INDICATOR = X_INDICATOR
48: and T.DIM_SET_ID = X_DIM_SET_ID
49: and T.LANGUAGE = L.LANGUAGE_CODE);
50:

Line 69: from BSC_KPI_DIM_SETS_TL

65: ) is
66: cursor c1 is select
67: NAME,
68: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
69: from BSC_KPI_DIM_SETS_TL
70: where INDICATOR = X_INDICATOR
71: and DIM_SET_ID = X_DIM_SET_ID
72: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
73: for update of INDICATOR nowait;

Line 100: update BSC_KPI_DIM_SETS_TL set

96: X_LAST_UPDATED_BY in NUMBER,
97: X_LAST_UPDATE_LOGIN in NUMBER
98: ) is
99: begin
100: update BSC_KPI_DIM_SETS_TL set
101: NAME = X_NAME,
102: SOURCE_LANG = userenv('LANG'),
103: LAST_UPDATE_DATE = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATE_DATE,LAST_UPDATE_DATE),
104: LAST_UPDATED_BY = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATED_BY,LAST_UPDATED_BY),

Line 120: delete from BSC_KPI_DIM_SETS_TL

116: X_INDICATOR in NUMBER,
117: X_DIM_SET_ID in NUMBER
118: ) is
119: begin
120: delete from BSC_KPI_DIM_SETS_TL
121: where INDICATOR = X_INDICATOR
122: and DIM_SET_ID = X_DIM_SET_ID;
123:
124: if (sql%notfound) then

Line 133: update BSC_KPI_DIM_SETS_TL T set (

129:
130: procedure ADD_LANGUAGE
131: is
132: begin
133: update BSC_KPI_DIM_SETS_TL T set (
134: NAME
135: ) = (select
136: B.NAME
137: from BSC_KPI_DIM_SETS_TL B

Line 137: from BSC_KPI_DIM_SETS_TL B

133: update BSC_KPI_DIM_SETS_TL T set (
134: NAME
135: ) = (select
136: B.NAME
137: from BSC_KPI_DIM_SETS_TL B
138: where B.INDICATOR = T.INDICATOR
139: and B.DIM_SET_ID = T.DIM_SET_ID
140: and B.LANGUAGE = T.SOURCE_LANG)
141: where (

Line 149: from BSC_KPI_DIM_SETS_TL SUBB, BSC_KPI_DIM_SETS_TL SUBT

145: ) in (select
146: SUBT.INDICATOR,
147: SUBT.DIM_SET_ID,
148: SUBT.LANGUAGE
149: from BSC_KPI_DIM_SETS_TL SUBB, BSC_KPI_DIM_SETS_TL SUBT
150: where SUBB.INDICATOR = SUBT.INDICATOR
151: and SUBB.DIM_SET_ID = SUBT.DIM_SET_ID
152: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
153: and (SUBB.NAME <> SUBT.NAME

Line 156: insert into BSC_KPI_DIM_SETS_TL (

152: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
153: and (SUBB.NAME <> SUBT.NAME
154: ));
155:
156: insert into BSC_KPI_DIM_SETS_TL (
157: INDICATOR,
158: DIM_SET_ID,
159: NAME,
160: LANGUAGE,

Line 176: from BSC_KPI_DIM_SETS_TL B, FND_LANGUAGES L

172: B.CREATION_DATE ,
173: B.CREATED_BY,
174: B.LAST_UPDATE_DATE,
175: B.LAST_UPDATED_BY
176: from BSC_KPI_DIM_SETS_TL B, FND_LANGUAGES L
177: where L.INSTALLED_FLAG in ('I', 'B')
178: and B.LANGUAGE = userenv('LANG')
179: and not exists
180: (select NULL

Line 181: from BSC_KPI_DIM_SETS_TL T

177: where L.INSTALLED_FLAG in ('I', 'B')
178: and B.LANGUAGE = userenv('LANG')
179: and not exists
180: (select NULL
181: from BSC_KPI_DIM_SETS_TL T
182: where T.INDICATOR = B.INDICATOR
183: and T.DIM_SET_ID = B.DIM_SET_ID
184: and T.LANGUAGE = L.LANGUAGE_CODE);
185: end ADD_LANGUAGE;