APPS.JTF_PC_CATEGORIES_PKG dependencies on JTF_PC_CATEGORIES_TL

Line 94: insert into jtf_pc_categories_tl (

90: X_Last_Updated_By,
91: X_Last_Update_Date,
92: X_Last_Update_Login );
93:
94: insert into jtf_pc_categories_tl (
95: CATEGORY_ID,
96: CATEGORY_NAME,
97: CATEGORY_DESCRIPTION,
98: SOURCE_LANG,

Line 120: from JTF_PC_CATEGORIES_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from JTF_PC_CATEGORIES_TL T
121: where T.CATEGORY_ID = X_CATEGORY_ID
122: and T.LANGUAGE = L.LANGUAGE_CODE);
123:
124: open c;

Line 168: from jtf_pc_categories_tl

164: Recinfo C%ROWTYPE;
165:
166: cursor c1 is
167: select category_name, category_description, decode(language,userenv('LANG'),'Y','N') BASELANG
168: from jtf_pc_categories_tl
169: where category_id = x_category_id
170: and userenv('LANG') in (LANGUAGE,SOURCE_LANG)
171: for update of category_id nowait;
172:

Line 326: update JTF_PC_CATEGORIES_TL set

322: if (SQL%NOTFOUND) then
323: Raise NO_DATA_FOUND;
324: end if;
325:
326: update JTF_PC_CATEGORIES_TL set
327: CATEGORY_NAME = X_CATEGORY_NAME,
328: CATEGORY_DESCRIPTION = X_CATEGORY_DESCRIPTION,
329: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
330: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 356: delete from JTF_PC_CATEGORIES_TL

352: if (SQL%NOTFOUND) then
353: Raise NO_DATA_FOUND;
354: end if;
355:
356: delete from JTF_PC_CATEGORIES_TL
357: where CATEGORY_ID = X_Category_Id;
358:
359: if (sql%notfound) then
360: raise no_data_found;

Line 375: delete from JTF_PC_CATEGORIES_TL T

371:
372: BEGIN
373:
374: -- delete from tl table if same category doesn't exist in base table
375: delete from JTF_PC_CATEGORIES_TL T
376: where not exists
377: (select NULL
378: from JTF_PC_CATEGORIES_B B
379: where B.CATEGORY_ID = T.CATEGORY_ID

Line 383: update JTF_PC_CATEGORIES_TL T

379: where B.CATEGORY_ID = T.CATEGORY_ID
380: );
381:
382: -- repair description in tl table
383: update JTF_PC_CATEGORIES_TL T
384: set (CATEGORY_NAME, CATEGORY_DESCRIPTION) = (select B.CATEGORY_NAME, B.CATEGORY_DESCRIPTION
385: from JTF_PC_CATEGORIES_TL B
386: where B.CATEGORY_ID = T.CATEGORY_ID
387: and B.LANGUAGE = T.SOURCE_LANG)

Line 385: from JTF_PC_CATEGORIES_TL B

381:
382: -- repair description in tl table
383: update JTF_PC_CATEGORIES_TL T
384: set (CATEGORY_NAME, CATEGORY_DESCRIPTION) = (select B.CATEGORY_NAME, B.CATEGORY_DESCRIPTION
385: from JTF_PC_CATEGORIES_TL B
386: where B.CATEGORY_ID = T.CATEGORY_ID
387: and B.LANGUAGE = T.SOURCE_LANG)
388: where (T.CATEGORY_ID, T.LANGUAGE) in
389: (select

Line 392: from JTF_PC_CATEGORIES_TL SUBB, JTF_PC_CATEGORIES_TL SUBT

388: where (T.CATEGORY_ID, T.LANGUAGE) in
389: (select
390: SUBT.CATEGORY_ID,
391: SUBT.LANGUAGE
392: from JTF_PC_CATEGORIES_TL SUBB, JTF_PC_CATEGORIES_TL SUBT
393: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
394: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
395: and (SUBB.CATEGORY_NAME <> SUBT.CATEGORY_NAME
396: or SUBB.CATEGORY_DESCRIPTION <> SUBT.CATEGORY_DESCRIPTION

Line 401: insert into JTF_PC_CATEGORIES_TL (

397: or (SUBB.CATEGORY_DESCRIPTION is null and SUBT.CATEGORY_DESCRIPTION is not null)
398: or (SUBB.CATEGORY_DESCRIPTION is not null and SUBT.CATEGORY_DESCRIPTION is null)));
399:
400:
401: insert into JTF_PC_CATEGORIES_TL (
402: CATEGORY_ID,
403: CATEGORY_NAME,
404: CATEGORY_DESCRIPTION,
405: LANGUAGE,

Line 423: from JTF_PC_CATEGORIES_TL B, FND_LANGUAGES L

419: B.CREATION_DATE,
420: B.LAST_UPDATED_BY,
421: B.LAST_UPDATE_DATE,
422: B.LAST_UPDATE_LOGIN
423: from JTF_PC_CATEGORIES_TL B, FND_LANGUAGES L
424: where L.INSTALLED_FLAG in ('I', 'B')
425: and B.LANGUAGE = userenv('LANG')
426: and not exists
427: (select NULL

Line 428: from JTF_PC_CATEGORIES_TL T

424: where L.INSTALLED_FLAG in ('I', 'B')
425: and B.LANGUAGE = userenv('LANG')
426: and not exists
427: (select NULL
428: from JTF_PC_CATEGORIES_TL T
429: where T.CATEGORY_ID = B.CATEGORY_ID
430: and T.LANGUAGE = L.LANGUAGE_CODE);
431: end ADD_LANGUAGE;
432:

Line 555: update JTF_PC_CATEGORIES_TL set

551: ) IS
552:
553: begin
554:
555: update JTF_PC_CATEGORIES_TL set
556: CATEGORY_NAME = nvl(X_Category_Name, CATEGORY_NAME),
557: CATEGORY_DESCRIPTION = nvl(X_Category_Description, CATEGORY_DESCRIPTION),
558: LAST_UPDATE_DATE = sysdate,
559: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', -1, 0),