APPS.JTF_RS_RESOURCE_EXTNS_PKG dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 263: insert into JTF_RS_RESOURCE_EXTNS_TL (

259: X_SOURCE_MOBILE_PHONE,
260: X_SOURCE_PAGER
261: );
262:
263: insert into JTF_RS_RESOURCE_EXTNS_TL (
264: RESOURCE_ID,
265: CATEGORY,
266: CREATED_BY,
267: CREATION_DATE,

Line 289: from JTF_RS_RESOURCE_EXTNS_TL T

285: from FND_LANGUAGES L
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and not exists
288: (select NULL
289: from JTF_RS_RESOURCE_EXTNS_TL T
290: where T.RESOURCE_ID = X_RESOURCE_ID
291: and T.LANGUAGE = L.LANGUAGE_CODE);
292:
293: open c;

Line 507: update JTF_RS_RESOURCE_EXTNS_TL set

503: if (sql%notfound) then
504: raise no_data_found;
505: end if;
506:
507: update JTF_RS_RESOURCE_EXTNS_TL set
508: RESOURCE_NAME = X_RESOURCE_NAME,
509: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
510: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
511: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 526: delete from JTF_RS_RESOURCE_EXTNS_TL

522: X_RESOURCE_ID in NUMBER
523: ) is
524: begin
525:
526: delete from JTF_RS_RESOURCE_EXTNS_TL
527: where RESOURCE_ID = X_RESOURCE_ID;
528:
529: if (sql%notfound) then
530: raise no_data_found;

Line 545: delete from JTF_RS_RESOURCE_EXTNS_TL T

541:
542: procedure ADD_LANGUAGE
543: is
544: begin
545: delete from JTF_RS_RESOURCE_EXTNS_TL T
546: where not exists
547: (select NULL
548: from JTF_RS_RESOURCE_EXTNS B
549: where B.RESOURCE_ID = T.RESOURCE_ID

Line 552: update JTF_RS_RESOURCE_EXTNS_TL T set (

548: from JTF_RS_RESOURCE_EXTNS B
549: where B.RESOURCE_ID = T.RESOURCE_ID
550: );
551:
552: update JTF_RS_RESOURCE_EXTNS_TL T set (
553: RESOURCE_NAME
554: ) = (select
555: B.RESOURCE_NAME
556: from JTF_RS_RESOURCE_EXTNS_TL B

Line 556: from JTF_RS_RESOURCE_EXTNS_TL B

552: update JTF_RS_RESOURCE_EXTNS_TL T set (
553: RESOURCE_NAME
554: ) = (select
555: B.RESOURCE_NAME
556: from JTF_RS_RESOURCE_EXTNS_TL B
557: where B.RESOURCE_ID = T.RESOURCE_ID
558: and B.LANGUAGE = T.SOURCE_LANG)
559: where (
560: T.RESOURCE_ID,

Line 565: from JTF_RS_RESOURCE_EXTNS_TL SUBB, JTF_RS_RESOURCE_EXTNS_TL SUBT

561: T.LANGUAGE
562: ) in (select
563: SUBT.RESOURCE_ID,
564: SUBT.LANGUAGE
565: from JTF_RS_RESOURCE_EXTNS_TL SUBB, JTF_RS_RESOURCE_EXTNS_TL SUBT
566: where SUBB.RESOURCE_ID = SUBT.RESOURCE_ID
567: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
568: and (SUBB.RESOURCE_NAME <> SUBT.RESOURCE_NAME
569: or (SUBB.RESOURCE_NAME is null and SUBT.RESOURCE_NAME is not null)

Line 573: insert into JTF_RS_RESOURCE_EXTNS_TL (

569: or (SUBB.RESOURCE_NAME is null and SUBT.RESOURCE_NAME is not null)
570: or (SUBB.RESOURCE_NAME is not null and SUBT.RESOURCE_NAME is null)
571: ));
572:
573: insert into JTF_RS_RESOURCE_EXTNS_TL (
574: RESOURCE_ID,
575: CREATED_BY,
576: CREATION_DATE,
577: LAST_UPDATED_BY,

Line 595: from JTF_RS_RESOURCE_EXTNS_TL B, FND_LANGUAGES L

591: B.RESOURCE_NAME,
592: B.CATEGORY,
593: L.LANGUAGE_CODE,
594: B.SOURCE_LANG
595: from JTF_RS_RESOURCE_EXTNS_TL B, FND_LANGUAGES L
596: where L.INSTALLED_FLAG in ('I', 'B')
597: and B.LANGUAGE = userenv('LANG')
598: and not exists
599: (select NULL

Line 600: from JTF_RS_RESOURCE_EXTNS_TL T

596: where L.INSTALLED_FLAG in ('I', 'B')
597: and B.LANGUAGE = userenv('LANG')
598: and not exists
599: (select NULL
600: from JTF_RS_RESOURCE_EXTNS_TL T
601: where T.RESOURCE_ID = B.RESOURCE_ID
602: and T.LANGUAGE = L.LANGUAGE_CODE);
603: end ADD_LANGUAGE;
604:

Line 615: Update jtf_rs_resource_extns_tl set

611: x_last_update_login in number)
612: is
613: begin
614:
615: Update jtf_rs_resource_extns_tl set
616: resource_name = nvl(x_resource_name,resource_name),
617: last_update_date = nvl(x_last_update_date,sysdate),
618: last_updated_by = x_last_updated_by,
619: last_update_login = 0,