eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DB_MEASURE_GROUPS_PKG dependencies on BSC_DB_MEASURE_GROUPS_TL

Line 20: FROM bsc_db_measure_groups_tl

16: -- mdamle 07/25/2003 - Added check for duplicate name
17: FND_MSG_PUB.INITIALIZE;
18: SELECT COUNT(1)
19: INTO l_count
20: FROM bsc_db_measure_groups_tl
21: WHERE help = x_help;
22:
23: IF (l_count > 0) THEN
24: FND_MESSAGE.SET_NAME('BSC','BSC_D_SOURCE_EXIST');

Line 49: from BSC_DB_MEASURE_GROUPS_TL

45: ) is
46: cursor c1 is select
47: HELP,
48: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
49: from BSC_DB_MEASURE_GROUPS_TL
50: where MEASURE_GROUP_ID = X_MEASURE_GROUP_ID
51: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
52: for update of MEASURE_GROUP_ID nowait;
53: begin

Line 77: UPDATE bsc_db_measure_groups_tl

73: , X_SHORT_NAME IN VARCHAR2:= NULL
74: )IS
75: BEGIN
76:
77: UPDATE bsc_db_measure_groups_tl
78: SET help = X_HELP
79: , short_name = X_SHORT_NAME
80: , source_lang = USERENV('LANG')
81: WHERE measure_group_id = X_MEASURE_GROUP_ID

Line 95: update BSC_DB_MEASURE_GROUPS_TL set

91: X_MEASURE_GROUP_ID in NUMBER,
92: X_HELP in VARCHAR2
93: ) is
94: begin
95: update BSC_DB_MEASURE_GROUPS_TL set
96: HELP = nvl(X_HELP,HELP),
97: SOURCE_LANG = userenv('LANG')
98: where MEASURE_GROUP_ID = X_MEASURE_GROUP_ID
99: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 111: delete from BSC_DB_MEASURE_GROUPS_TL

107: procedure DELETE_ROW (
108: X_MEASURE_GROUP_ID in NUMBER
109: ) is
110: begin
111: delete from BSC_DB_MEASURE_GROUPS_TL
112: where MEASURE_GROUP_ID = X_MEASURE_GROUP_ID;
113:
114: if (sql%notfound) then
115: raise no_data_found;

Line 125: UPDATE bsc_db_measure_groups_tl t

121: PROCEDURE ADD_LANGUAGE
122: IS
123: BEGIN
124:
125: UPDATE bsc_db_measure_groups_tl t
126: SET (
127: help
128: ) = (
129: SELECT b.help

Line 130: FROM bsc_db_measure_groups_tl b

126: SET (
127: help
128: ) = (
129: SELECT b.help
130: FROM bsc_db_measure_groups_tl b
131: WHERE b.Measure_group_id = t.Measure_group_id
132: AND b.language = t.Source_lang)
133: WHERE (
134: t.Measure_group_id,

Line 139: FROM bsc_db_measure_groups_tl subb

135: t.language
136: ) IN (
137: SELECT subt.Measure_group_id
138: ,subt.language
139: FROM bsc_db_measure_groups_tl subb
140: , bsc_db_measure_groups_tl subt
141: WHERE subb.Measure_group_id = subt.Measure_group_id
142: AND subb.language = subt.Source_lang
143: AND (subb.help <> subt.help));

Line 140: , bsc_db_measure_groups_tl subt

136: ) IN (
137: SELECT subt.Measure_group_id
138: ,subt.language
139: FROM bsc_db_measure_groups_tl subb
140: , bsc_db_measure_groups_tl subt
141: WHERE subb.Measure_group_id = subt.Measure_group_id
142: AND subb.language = subt.Source_lang
143: AND (subb.help <> subt.help));
144:

Line 146: INSERT INTO bsc_db_measure_groups_tl

142: AND subb.language = subt.Source_lang
143: AND (subb.help <> subt.help));
144:
145:
146: INSERT INTO bsc_db_measure_groups_tl
147: ( help
148: , measure_group_id
149: , language
150: , source_lang

Line 157: FROM bsc_db_measure_groups_tl b

153: , b.Measure_group_id
154: , l.Language_code
155: , b.Source_lang
156: , b.Short_name
157: FROM bsc_db_measure_groups_tl b
158: , fnd_languages l
159: WHERE l.Installed_flag IN ('I', 'B')
160: AND b.language = USERENV('LANG')
161: AND NOT EXISTS (

Line 163: FROM bsc_db_measure_groups_tl t

159: WHERE l.Installed_flag IN ('I', 'B')
160: AND b.language = USERENV('LANG')
161: AND NOT EXISTS (
162: SELECT NULL
163: FROM bsc_db_measure_groups_tl t
164: WHERE t.Measure_group_id = b.Measure_group_id
165: AND t.language = l.language_code);
166:
167: END ADD_LANGUAGE;

Line 195: Description : This procedure insert values into bsc_db_measure_groups_tl table.

191: END Insert_Default_Meas_Row;
192:
193: /*************************************************************************************************
194: Procedure : Insert_Row_Values
195: Description : This procedure insert values into bsc_db_measure_groups_tl table.
196: Input : Measure group Id
197: : help
198: : short_name
199: Created BY : ashankar 27-JUL-2005

Line 201: Verified BIS ARU 4122391 it contains bsc_db_measure_groups_tl.xdf version 115.3

197: : help
198: : short_name
199: Created BY : ashankar 27-JUL-2005
200: Note : Removed the dynamic SQL because BSC 5.2 MD/DD xdf files are included with BIS 4.0.9
201: Verified BIS ARU 4122391 it contains bsc_db_measure_groups_tl.xdf version 115.3
202: So SHORT_NAME column will always be there.
203: /***************************************************************************************************/
204:
205: PROCEDURE Insert_Row_Values

Line 212: INSERT INTO bsc_db_measure_groups_tl

208: , x_Help IN VARCHAR2
209: , x_Short_name IN VARCHAR2
210: )IS
211: BEGIN
212: INSERT INTO bsc_db_measure_groups_tl
213: ( short_name
214: , help
215: , measure_group_id
216: ,language

Line 227: FROM bsc_db_measure_groups_tl t

223: FROM fnd_languages l
224: WHERE l.installed_flag IN ('I', 'B')
225: AND NOT EXISTS (
226: SELECT NULL
227: FROM bsc_db_measure_groups_tl t
228: WHERE t.measure_group_id = x_Measure_group_id
229: AND t.language = l.language_code);
230:
231: END Insert_Row_Values;