APPS.HR_WINDOW_PROPERTIES_PKG dependencies on HR_WINDOW_PROPERTIES_TL

Line 117: update HR_WINDOW_PROPERTIES_TL set

113: where WINDOW_PROPERTY_ID = l_copy.WINDOW_PROPERTY_ID;
114: if (sql%notfound) then
115: raise no_data_found;
116: end if;
117: update HR_WINDOW_PROPERTIES_TL set
118: TITLE = decode(nvl(TITLE,hr_api.g_varchar2),nvl(l_original.TITLE,hr_api.g_varchar2),X_TITLE,TITLE),
119: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
120: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
121: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 296: insert into HR_WINDOW_PROPERTIES_TL (

292: X_LAST_UPDATED_BY,
293: X_LAST_UPDATE_LOGIN
294: );
295:
296: insert into HR_WINDOW_PROPERTIES_TL (
297: WINDOW_PROPERTY_ID,
298: TITLE,
299: LAST_UPDATE_DATE,
300: LAST_UPDATED_BY,

Line 320: from HR_WINDOW_PROPERTIES_TL T

316: from FND_LANGUAGES L
317: where L.INSTALLED_FLAG in ('I', 'B')
318: and not exists
319: (select NULL
320: from HR_WINDOW_PROPERTIES_TL T
321: where T.WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
322: and T.LANGUAGE = L.LANGUAGE_CODE);
323:
324: open c;

Line 421: from HR_WINDOW_PROPERTIES_TL

417:
418: cursor c1 is select
419: TITLE,
420: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
421: from HR_WINDOW_PROPERTIES_TL
422: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
423: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
424: for update of WINDOW_PROPERTY_ID nowait;
425: begin

Line 622: update HR_WINDOW_PROPERTIES_TL set

618: if (sql%notfound) then
619: raise no_data_found;
620: end if;
621:
622: update HR_WINDOW_PROPERTIES_TL set
623: TITLE = X_TITLE,
624: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
625: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
626: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 640: delete from HR_WINDOW_PROPERTIES_TL

636: procedure DELETE_ROW (
637: X_WINDOW_PROPERTY_ID in NUMBER
638: ) is
639: begin
640: delete from HR_WINDOW_PROPERTIES_TL
641: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID;
642:
643: if (sql%notfound) then
644: raise no_data_found;

Line 658: delete from HR_WINDOW_PROPERTIES_TL T

654:
655: procedure ADD_LANGUAGE
656: is
657: begin
658: delete from HR_WINDOW_PROPERTIES_TL T
659: where not exists
660: (select NULL
661: from HR_WINDOW_PROPERTIES_B B
662: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID

Line 665: update HR_WINDOW_PROPERTIES_TL T set (

661: from HR_WINDOW_PROPERTIES_B B
662: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID
663: );
664:
665: update HR_WINDOW_PROPERTIES_TL T set (
666: TITLE
667: ) = (select
668: B.TITLE
669: from HR_WINDOW_PROPERTIES_TL B

Line 669: from HR_WINDOW_PROPERTIES_TL B

665: update HR_WINDOW_PROPERTIES_TL T set (
666: TITLE
667: ) = (select
668: B.TITLE
669: from HR_WINDOW_PROPERTIES_TL B
670: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID
671: and B.LANGUAGE = T.SOURCE_LANG)
672: where (
673: T.WINDOW_PROPERTY_ID,

Line 678: from HR_WINDOW_PROPERTIES_TL SUBB, HR_WINDOW_PROPERTIES_TL SUBT

674: T.LANGUAGE
675: ) in (select
676: SUBT.WINDOW_PROPERTY_ID,
677: SUBT.LANGUAGE
678: from HR_WINDOW_PROPERTIES_TL SUBB, HR_WINDOW_PROPERTIES_TL SUBT
679: where SUBB.WINDOW_PROPERTY_ID = SUBT.WINDOW_PROPERTY_ID
680: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
681: and (SUBB.TITLE <> SUBT.TITLE
682: or (SUBB.TITLE is null and SUBT.TITLE is not null)

Line 686: insert into HR_WINDOW_PROPERTIES_TL (

682: or (SUBB.TITLE is null and SUBT.TITLE is not null)
683: or (SUBB.TITLE is not null and SUBT.TITLE is null)
684: ));
685:
686: insert into HR_WINDOW_PROPERTIES_TL (
687: WINDOW_PROPERTY_ID,
688: TITLE,
689: LAST_UPDATE_DATE,
690: LAST_UPDATED_BY,

Line 706: from HR_WINDOW_PROPERTIES_TL B, FND_LANGUAGES L

702: B.CREATED_BY,
703: B.CREATION_DATE,
704: L.LANGUAGE_CODE,
705: B.SOURCE_LANG
706: from HR_WINDOW_PROPERTIES_TL B, FND_LANGUAGES L
707: where L.INSTALLED_FLAG in ('I', 'B')
708: and B.LANGUAGE = userenv('LANG')
709: and not exists
710: (select NULL

Line 711: from HR_WINDOW_PROPERTIES_TL T

707: where L.INSTALLED_FLAG in ('I', 'B')
708: and B.LANGUAGE = userenv('LANG')
709: and not exists
710: (select NULL
711: from HR_WINDOW_PROPERTIES_TL T
712: where T.WINDOW_PROPERTY_ID = B.WINDOW_PROPERTY_ID
713: and T.LANGUAGE = L.LANGUAGE_CODE);
714: end ADD_LANGUAGE;
715:

Line 790: update HR_WINDOW_PROPERTIES_TL set

786: from hr_window_properties_b
787: where nvl(form_window_id,hr_api.g_number) = nvl(x_form_window_id,hr_api.g_number)
788: and nvl(template_window_id,hr_api.g_number) = nvl(x_template_window_id,hr_api.g_number);
789:
790: update HR_WINDOW_PROPERTIES_TL set
791: TITLE = X_TITLE,
792: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
793: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
794: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,