APPS.BSC_SYS_DIM_GROUPS_PKG dependencies on BSC_SYS_DIM_GROUPS_TL

Line 14: cursor C is select ROWID from BSC_SYS_DIM_GROUPS_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_SYS_DIM_GROUPS_TL
15: where DIM_GROUP_ID = X_DIM_GROUP_ID
16: and LANGUAGE = userenv('LANG')
17: ;
18: begin

Line 19: insert into BSC_SYS_DIM_GROUPS_TL (

15: where DIM_GROUP_ID = X_DIM_GROUP_ID
16: and LANGUAGE = userenv('LANG')
17: ;
18: begin
19: insert into BSC_SYS_DIM_GROUPS_TL (
20: DIM_GROUP_ID,
21: SHORT_NAME,
22: NAME,
23: LANGUAGE,

Line 45: from BSC_SYS_DIM_GROUPS_TL T

41: from FND_LANGUAGES L
42: where L.INSTALLED_FLAG in ('I', 'B')
43: and not exists
44: (select NULL
45: from BSC_SYS_DIM_GROUPS_TL T
46: where T.DIM_GROUP_ID = X_DIM_GROUP_ID
47: and T.LANGUAGE = L.LANGUAGE_CODE);
48:
49: open c;

Line 66: from BSC_SYS_DIM_GROUPS_TL

62: ) is
63: cursor c1 is select
64: NAME,
65: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
66: from BSC_SYS_DIM_GROUPS_TL
67: where DIM_GROUP_ID = X_DIM_GROUP_ID
68: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
69: for update of DIM_GROUP_ID nowait;
70: begin

Line 95: update BSC_SYS_DIM_GROUPS_TL set

91: X_LAST_UPDATED_BY in NUMBER,
92: X_LAST_UPDATE_LOGIN in NUMBER
93: ) is
94: begin
95: update BSC_SYS_DIM_GROUPS_TL set
96: NAME = X_NAME,
97: SOURCE_LANG = userenv('LANG'),
98: LAST_UPDATE_DATE = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATE_DATE,LAST_UPDATE_DATE),
99: LAST_UPDATED_BY = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATED_BY,LAST_UPDATED_BY),

Line 113: delete from BSC_SYS_DIM_GROUPS_TL

109: procedure DELETE_ROW (
110: X_DIM_GROUP_ID in NUMBER
111: ) is
112: begin
113: delete from BSC_SYS_DIM_GROUPS_TL
114: where DIM_GROUP_ID = X_DIM_GROUP_ID;
115:
116: if (sql%notfound) then
117: raise no_data_found;

Line 125: update BSC_SYS_DIM_GROUPS_TL T set (

121:
122: procedure ADD_LANGUAGE
123: is
124: begin
125: update BSC_SYS_DIM_GROUPS_TL T set (
126: NAME
127: ) = (select
128: B.NAME
129: from BSC_SYS_DIM_GROUPS_TL B

Line 129: from BSC_SYS_DIM_GROUPS_TL B

125: update BSC_SYS_DIM_GROUPS_TL T set (
126: NAME
127: ) = (select
128: B.NAME
129: from BSC_SYS_DIM_GROUPS_TL B
130: where B.DIM_GROUP_ID = T.DIM_GROUP_ID
131: and B.LANGUAGE = T.SOURCE_LANG)
132: where (
133: T.DIM_GROUP_ID,

Line 138: from BSC_SYS_DIM_GROUPS_TL SUBB, BSC_SYS_DIM_GROUPS_TL SUBT

134: T.LANGUAGE
135: ) in (select
136: SUBT.DIM_GROUP_ID,
137: SUBT.LANGUAGE
138: from BSC_SYS_DIM_GROUPS_TL SUBB, BSC_SYS_DIM_GROUPS_TL SUBT
139: where SUBB.DIM_GROUP_ID = SUBT.DIM_GROUP_ID
140: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
141: and (SUBB.NAME <> SUBT.NAME
142: ));

Line 144: insert into BSC_SYS_DIM_GROUPS_TL (

140: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
141: and (SUBB.NAME <> SUBT.NAME
142: ));
143:
144: insert into BSC_SYS_DIM_GROUPS_TL (
145: DIM_GROUP_ID,
146: SHORT_NAME,
147: NAME,
148: LANGUAGE,

Line 164: from BSC_SYS_DIM_GROUPS_TL B, FND_LANGUAGES L

160: B.CREATION_DATE ,
161: B.CREATED_BY,
162: B.LAST_UPDATE_DATE,
163: B.LAST_UPDATED_BY
164: from BSC_SYS_DIM_GROUPS_TL B, FND_LANGUAGES L
165: where L.INSTALLED_FLAG in ('I', 'B')
166: and B.LANGUAGE = userenv('LANG')
167: and not exists
168: (select NULL

Line 169: from BSC_SYS_DIM_GROUPS_TL T

165: where L.INSTALLED_FLAG in ('I', 'B')
166: and B.LANGUAGE = userenv('LANG')
167: and not exists
168: (select NULL
169: from BSC_SYS_DIM_GROUPS_TL T
170: where T.DIM_GROUP_ID = B.DIM_GROUP_ID
171: and T.LANGUAGE = L.LANGUAGE_CODE);
172: end ADD_LANGUAGE;
173: