APPS.CS_SR_LINK_TYPES_PKG dependencies on CS_SR_LINK_TYPES_TL

Line 76: INSERT INTO CS_SR_LINK_TYPES_TL (

72: P_ATTRIBUTE13, P_ATTRIBUTE14, P_ATTRIBUTE15,
73: P_OBJECT_VERSION_NUMBER, P_SECURITY_GROUP_ID, P_ATTRIBUTE_CONTEXT );
74:
75:
76: INSERT INTO CS_SR_LINK_TYPES_TL (
77: LINK_TYPE_ID, NAME, DESCRIPTION,
78: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
79: CREATED_BY, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID,
80: LANGUAGE, SOURCE_LANG)

Line 89: FROM CS_SR_LINK_TYPES_TL T

85: L.LANGUAGE_CODE, userenv('LANG')
86: FROM FND_LANGUAGES L
87: WHERE L.INSTALLED_FLAG in ('I', 'B')
88: AND NOT EXISTS ( SELECT NULL
89: FROM CS_SR_LINK_TYPES_TL T
90: WHERE T.LINK_TYPE_ID = PX_LINK_TYPE_ID
91: AND T.LANGUAGE = L.LANGUAGE_CODE);
92: END INSERT_ROW;
93:

Line 192: update CS_SR_LINK_TYPES_TL set

188: if (sql%notfound) then
189: raise no_data_found;
190: end if;
191:
192: update CS_SR_LINK_TYPES_TL set
193: NAME = P_NAME,
194: DESCRIPTION = P_DESCRIPTION,
195: LAST_UPDATE_DATE = SYSDATE,
196: LAST_UPDATED_BY = P_USER_ID,

Line 212: delete from cs_sr_link_types_tl

208: PROCEDURE DELETE_ROW (
209: P_LINK_TYPE_ID in NUMBER)
210: IS
211: BEGIN
212: delete from cs_sr_link_types_tl
213: where link_type_id = p_link_type_id;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 231: delete from cs_sr_link_types_tl T

227:
228: PROCEDURE ADD_LANGUAGE
229: IS
230: BEGIN
231: delete from cs_sr_link_types_tl T
232: where not exists ( select NULL
233: from CS_SR_LINK_TYPES_B B
234: where B.LINK_TYPE_ID = T.LINK_TYPE_ID );
235:

Line 236: update CS_SR_LINK_TYPES_TL T

232: where not exists ( select NULL
233: from CS_SR_LINK_TYPES_B B
234: where B.LINK_TYPE_ID = T.LINK_TYPE_ID );
235:
236: update CS_SR_LINK_TYPES_TL T
237: set ( NAME, DESCRIPTION ) = ( select B.NAME, B.DESCRIPTION
238: from CS_SR_LINK_TYPES_TL B
239: where B.LINK_TYPE_ID = T.LINK_TYPE_ID
240: and B.LANGUAGE = T.SOURCE_LANG)

Line 238: from CS_SR_LINK_TYPES_TL B

234: where B.LINK_TYPE_ID = T.LINK_TYPE_ID );
235:
236: update CS_SR_LINK_TYPES_TL T
237: set ( NAME, DESCRIPTION ) = ( select B.NAME, B.DESCRIPTION
238: from CS_SR_LINK_TYPES_TL B
239: where B.LINK_TYPE_ID = T.LINK_TYPE_ID
240: and B.LANGUAGE = T.SOURCE_LANG)
241: where (T.LINK_TYPE_ID, T.LANGUAGE) in ( select SUBT.LINK_TYPE_ID, SUBT.LANGUAGE
242: from CS_SR_LINK_TYPES_TL SUBB,

Line 242: from CS_SR_LINK_TYPES_TL SUBB,

238: from CS_SR_LINK_TYPES_TL B
239: where B.LINK_TYPE_ID = T.LINK_TYPE_ID
240: and B.LANGUAGE = T.SOURCE_LANG)
241: where (T.LINK_TYPE_ID, T.LANGUAGE) in ( select SUBT.LINK_TYPE_ID, SUBT.LANGUAGE
242: from CS_SR_LINK_TYPES_TL SUBB,
243: CS_SR_LINK_TYPES_TL SUBT
244: where SUBB.LINK_TYPE_ID = SUBT.LINK_TYPE_ID
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and ( SUBB.NAME <> SUBT.NAME

Line 243: CS_SR_LINK_TYPES_TL SUBT

239: where B.LINK_TYPE_ID = T.LINK_TYPE_ID
240: and B.LANGUAGE = T.SOURCE_LANG)
241: where (T.LINK_TYPE_ID, T.LANGUAGE) in ( select SUBT.LINK_TYPE_ID, SUBT.LANGUAGE
242: from CS_SR_LINK_TYPES_TL SUBB,
243: CS_SR_LINK_TYPES_TL SUBT
244: where SUBB.LINK_TYPE_ID = SUBT.LINK_TYPE_ID
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and ( SUBB.NAME <> SUBT.NAME
247: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION)

Line 250: insert into CS_SR_LINK_TYPES_TL (

246: and ( SUBB.NAME <> SUBT.NAME
247: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION)
248: );
249:
250: insert into CS_SR_LINK_TYPES_TL (
251: LINK_TYPE_ID, NAME, DESCRIPTION,
252: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
253: CREATED_BY, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID,
254: LANGUAGE, SOURCE_LANG )

Line 260: from CS_SR_LINK_TYPES_TL B,

256: B.LINK_TYPE_ID, B.NAME, B.DESCRIPTION,
257: B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE,
258: B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.SECURITY_GROUP_ID,
259: L.LANGUAGE_CODE, B.SOURCE_LANG
260: from CS_SR_LINK_TYPES_TL B,
261: FND_LANGUAGES L
262: where L.INSTALLED_FLAG in ('I', 'B')
263: and B.LANGUAGE = userenv('LANG')
264: and not exists ( select NULL

Line 265: from CS_SR_LINK_TYPES_TL T

261: FND_LANGUAGES L
262: where L.INSTALLED_FLAG in ('I', 'B')
263: and B.LANGUAGE = userenv('LANG')
264: and not exists ( select NULL
265: from CS_SR_LINK_TYPES_TL T
266: where T.LINK_TYPE_ID = B.LINK_TYPE_ID
267: and T.LANGUAGE = L.LANGUAGE_CODE);
268: END ADD_LANGUAGE;
269:

Line 278: UPDATE cs_sr_link_types_tl

274: P_DESCRIPTION IN VARCHAR2,
275: P_OWNER IN VARCHAR2 )
276: IS
277: BEGIN
278: UPDATE cs_sr_link_types_tl
279: SET name = p_name,
280: description = NVL(p_description,description),
281: last_update_date = sysdate,
282: last_updated_by = DECODE(p_owner, 'SEED', 1, 0),