APPS.CSD_SC_RECOMMENDATIONS_PKG dependencies on CSD_SC_RECOMMENDATIONS_TL

Line 58: insert into CSD_SC_RECOMMENDATIONS_TL (

54: P_LAST_UPDATED_BY,
55: P_LAST_UPDATE_LOGIN
56: );
57:
58: insert into CSD_SC_RECOMMENDATIONS_TL (
59: SC_RECOMMENDATION_ID,
60: SC_RECOMMENDATION_NAME,
61: CREATED_BY,
62: CREATION_DATE,

Line 82: from CSD_SC_RECOMMENDATIONS_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from CSD_SC_RECOMMENDATIONS_TL T
83: where T.SC_RECOMMENDATION_ID = PX_SC_RECOMMENDATION_ID
84: and T.LANGUAGE = L.LANGUAGE_CODE);
85:
86: open c;

Line 172: update CSD_SC_RECOMMENDATIONS_TL set

168: if (sql%notfound) then
169: raise no_data_found;
170: end if;
171:
172: update CSD_SC_RECOMMENDATIONS_TL set
173: SC_RECOMMENDATION_NAME = P_SC_RECOMMENDATION_NAME,
174: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
175: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
176: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 190: delete from CSD_SC_RECOMMENDATIONS_TL

186: procedure DELETE_ROW (
187: P_SC_RECOMMENDATION_ID in NUMBER
188: ) is
189: begin
190: delete from CSD_SC_RECOMMENDATIONS_TL
191: where SC_RECOMMENDATION_ID = P_SC_RECOMMENDATION_ID;
192:
193: if (sql%notfound) then
194: raise no_data_found;

Line 208: delete from CSD_SC_RECOMMENDATIONS_TL T

204:
205: procedure ADD_LANGUAGE
206: is
207: begin
208: delete from CSD_SC_RECOMMENDATIONS_TL T
209: where not exists
210: (select NULL
211: from CSD_SC_RECOMMENDATIONS_B B
212: where B.SC_RECOMMENDATION_ID = T.SC_RECOMMENDATION_ID

Line 215: update CSD_SC_RECOMMENDATIONS_TL T set (

211: from CSD_SC_RECOMMENDATIONS_B B
212: where B.SC_RECOMMENDATION_ID = T.SC_RECOMMENDATION_ID
213: );
214:
215: update CSD_SC_RECOMMENDATIONS_TL T set (
216: SC_RECOMMENDATION_NAME
217: ) = (select
218: B.SC_RECOMMENDATION_NAME
219: from CSD_SC_RECOMMENDATIONS_TL B

Line 219: from CSD_SC_RECOMMENDATIONS_TL B

215: update CSD_SC_RECOMMENDATIONS_TL T set (
216: SC_RECOMMENDATION_NAME
217: ) = (select
218: B.SC_RECOMMENDATION_NAME
219: from CSD_SC_RECOMMENDATIONS_TL B
220: where B.SC_RECOMMENDATION_ID = T.SC_RECOMMENDATION_ID
221: and B.LANGUAGE = T.SOURCE_LANG)
222: where (
223: T.SC_RECOMMENDATION_ID,

Line 228: from CSD_SC_RECOMMENDATIONS_TL SUBB, CSD_SC_RECOMMENDATIONS_TL SUBT

224: T.LANGUAGE
225: ) in (select
226: SUBT.SC_RECOMMENDATION_ID,
227: SUBT.LANGUAGE
228: from CSD_SC_RECOMMENDATIONS_TL SUBB, CSD_SC_RECOMMENDATIONS_TL SUBT
229: where SUBB.SC_RECOMMENDATION_ID = SUBT.SC_RECOMMENDATION_ID
230: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
231: and (SUBB.SC_RECOMMENDATION_NAME <> SUBT.SC_RECOMMENDATION_NAME
232: or (SUBB.SC_RECOMMENDATION_NAME is null and SUBT.SC_RECOMMENDATION_NAME is not null)

Line 236: insert into CSD_SC_RECOMMENDATIONS_TL (

232: or (SUBB.SC_RECOMMENDATION_NAME is null and SUBT.SC_RECOMMENDATION_NAME is not null)
233: or (SUBB.SC_RECOMMENDATION_NAME is not null and SUBT.SC_RECOMMENDATION_NAME is null)
234: ));
235:
236: insert into CSD_SC_RECOMMENDATIONS_TL (
237: SC_RECOMMENDATION_ID,
238: SC_RECOMMENDATION_NAME,
239: CREATED_BY,
240: CREATION_DATE,

Line 256: from CSD_SC_RECOMMENDATIONS_TL B, FND_LANGUAGES L

252: B.LAST_UPDATE_DATE,
253: B.LAST_UPDATE_LOGIN,
254: L.LANGUAGE_CODE,
255: B.SOURCE_LANG
256: from CSD_SC_RECOMMENDATIONS_TL B, FND_LANGUAGES L
257: where L.INSTALLED_FLAG in ('I', 'B')
258: and B.LANGUAGE = userenv('LANG')
259: and not exists
260: (select NULL

Line 261: from CSD_SC_RECOMMENDATIONS_TL T

257: where L.INSTALLED_FLAG in ('I', 'B')
258: and B.LANGUAGE = userenv('LANG')
259: and not exists
260: (select NULL
261: from CSD_SC_RECOMMENDATIONS_TL T
262: where T.SC_RECOMMENDATION_ID = B.SC_RECOMMENDATION_ID
263: and T.LANGUAGE = L.LANGUAGE_CODE);
264: end ADD_LANGUAGE;
265: