APPS.CSP_PARTS_LOOPS_PKG dependencies on CSP_PARTS_LOOPS_TL

Line 110: insert into CSP_PARTS_LOOPS_TL (

106: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
107: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
108: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
109:
110: insert into CSP_PARTS_LOOPS_TL (
111: LAST_UPDATE_DATE,
112: LAST_UPDATE_LOGIN,
113: DESCRIPTION,
114: PARTS_LOOP_ID,

Line 134: from CSP_PARTS_LOOPS_TL T

130: from FND_LANGUAGES L
131: where L.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from CSP_PARTS_LOOPS_TL T
135: where T.PARTS_LOOP_ID = px_PARTS_LOOP_ID
136: and T.LANGUAGE = L.LANGUAGE_CODE);
137:
138: End Insert_Row;

Line 206: update CSP_PARTS_LOOPS_TL set

202: If (SQL%NOTFOUND) then
203: RAISE NO_DATA_FOUND;
204: End If;
205:
206: update CSP_PARTS_LOOPS_TL set
207: DESCRIPTION = P_DESCRIPTION,
208: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
209: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
210: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 231: delete from CSP_PARTS_LOOPS_TL

227: If (SQL%NOTFOUND) then
228: RAISE NO_DATA_FOUND;
229: End If;
230:
231: delete from CSP_PARTS_LOOPS_TL
232: where PARTS_LOOP_ID = p_PARTS_LOOP_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 289: from CSP_PARTS_LOOPS_TL

285:
286: cursor c1 is select
287: DESCRIPTION,
288: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
289: from CSP_PARTS_LOOPS_TL
290: where PARTS_LOOP_ID = p_PARTS_LOOP_ID
291: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
292: for update of PARTS_LOOP_ID nowait;
293:

Line 409: delete from csp_parts_loops_tl T

405:
406: procedure ADD_LANGUAGE
407: is
408: begin
409: delete from csp_parts_loops_tl T
410: where not exists
411: (select NULL
412: from csp_parts_loops_b B
413: where B.parts_loop_id = T.parts_loop_id

Line 416: update csp_parts_loops_tl T set (

412: from csp_parts_loops_b B
413: where B.parts_loop_id = T.parts_loop_id
414: );
415:
416: update csp_parts_loops_tl T set (
417: DESCRIPTION
418: ) = (select
419: B.DESCRIPTION
420: from csp_parts_loops_tl B

Line 420: from csp_parts_loops_tl B

416: update csp_parts_loops_tl T set (
417: DESCRIPTION
418: ) = (select
419: B.DESCRIPTION
420: from csp_parts_loops_tl B
421: where B.parts_loop_id = T.parts_loop_id
422: and B.LANGUAGE = T.SOURCE_LANG)
423: where (
424: T.parts_loop_id,

Line 429: from csp_parts_loops_tl SUBB, csp_parts_loops_tl SUBT

425: T.LANGUAGE
426: ) in (select
427: SUBT.parts_loop_id,
428: SUBT.LANGUAGE
429: from csp_parts_loops_tl SUBB, csp_parts_loops_tl SUBT
430: where SUBB.parts_loop_id = SUBT.parts_loop_id
431: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
432: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
433: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 437: insert into csp_parts_loops_tl (

433: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
434: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
435: ));
436:
437: insert into csp_parts_loops_tl (
438: parts_loop_id,
439: CREATED_BY,
440: CREATION_DATE,
441: LAST_UPDATED_BY,

Line 457: from csp_parts_loops_tl B, FND_LANGUAGES L

453: B.LAST_UPDATE_LOGIN,
454: B.DESCRIPTION,
455: L.LANGUAGE_CODE,
456: B.SOURCE_LANG
457: from csp_parts_loops_tl B, FND_LANGUAGES L
458: where L.INSTALLED_FLAG in ('I', 'B')
459: and B.LANGUAGE = userenv('LANG')
460: and not exists
461: (select NULL

Line 462: from csp_parts_loops_tl T

458: where L.INSTALLED_FLAG in ('I', 'B')
459: and B.LANGUAGE = userenv('LANG')
460: and not exists
461: (select NULL
462: from csp_parts_loops_tl T
463: where T.parts_loop_id = B.parts_loop_id
464: and T.LANGUAGE = L.LANGUAGE_CODE);
465: end ADD_LANGUAGE;
466:

Line 480: UPDATE csp_parts_loops_tl

476: if p_owner = 'SEED' then
477: l_user_id := 1;
478: end if;
479:
480: UPDATE csp_parts_loops_tl
481: SET description = p_description
482: , last_update_date = SYSDATE
483: , last_updated_by = l_user_id
484: , last_update_login = 0