APPS.PV_GE_BENEFITS_PKG dependencies on PV_GE_BENEFITS_TL

Line 103: insert into PV_GE_BENEFITS_TL (

99: X_LAST_UPDATED_BY,
100: X_LAST_UPDATE_LOGIN
101: );
102:
103: insert into PV_GE_BENEFITS_TL (
104: BENEFIT_ID,
105: BENEFIT_NAME,
106: DESCRIPTION,
107: CREATED_BY,

Line 129: from PV_GE_BENEFITS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from PV_GE_BENEFITS_TL T
130: where T.BENEFIT_ID = X_BENEFIT_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 204: from PV_GE_BENEFITS_TL

200: cursor c1 is select
201: BENEFIT_NAME,
202: DESCRIPTION,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from PV_GE_BENEFITS_TL
205: where BENEFIT_ID = X_BENEFIT_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of BENEFIT_ID nowait;
208: begin

Line 348: update PV_GE_BENEFITS_TL set

344: if (sql%notfound) then
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: end if;
347:
348: update PV_GE_BENEFITS_TL set
349: BENEFIT_NAME = X_BENEFIT_NAME,
350: DESCRIPTION = X_DESCRIPTION,
351: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
352: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 547: delete from PV_GE_BENEFITS_TL

543: procedure DELETE_ROW (
544: X_BENEFIT_ID in NUMBER
545: ) is
546: begin
547: delete from PV_GE_BENEFITS_TL
548: where BENEFIT_ID = X_BENEFIT_ID;
549:
550: if (sql%notfound) then
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 565: delete from PV_GE_BENEFITS_TL T

561:
562: procedure ADD_LANGUAGE
563: is
564: begin
565: delete from PV_GE_BENEFITS_TL T
566: where not exists
567: (select NULL
568: from PV_GE_BENEFITS_B B
569: where B.BENEFIT_ID = T.BENEFIT_ID

Line 572: update PV_GE_BENEFITS_TL T set (

568: from PV_GE_BENEFITS_B B
569: where B.BENEFIT_ID = T.BENEFIT_ID
570: );
571:
572: update PV_GE_BENEFITS_TL T set (
573: BENEFIT_NAME,
574: DESCRIPTION
575: ) = (select
576: B.BENEFIT_NAME,

Line 578: from PV_GE_BENEFITS_TL B

574: DESCRIPTION
575: ) = (select
576: B.BENEFIT_NAME,
577: B.DESCRIPTION
578: from PV_GE_BENEFITS_TL B
579: where B.BENEFIT_ID = T.BENEFIT_ID
580: and B.LANGUAGE = T.SOURCE_LANG)
581: where (
582: T.BENEFIT_ID,

Line 587: from PV_GE_BENEFITS_TL SUBB, PV_GE_BENEFITS_TL SUBT

583: T.LANGUAGE
584: ) in (select
585: SUBT.BENEFIT_ID,
586: SUBT.LANGUAGE
587: from PV_GE_BENEFITS_TL SUBB, PV_GE_BENEFITS_TL SUBT
588: where SUBB.BENEFIT_ID = SUBT.BENEFIT_ID
589: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
590: and (SUBB.BENEFIT_NAME <> SUBT.BENEFIT_NAME
591: or (SUBB.BENEFIT_NAME is null and SUBT.BENEFIT_NAME is not null)

Line 598: insert into PV_GE_BENEFITS_TL (

594: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
595: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
596: ));
597:
598: insert into PV_GE_BENEFITS_TL (
599: BENEFIT_ID,
600: BENEFIT_NAME,
601: DESCRIPTION,
602: CREATED_BY,

Line 620: from PV_GE_BENEFITS_TL B, FND_LANGUAGES L

616: B.LAST_UPDATE_DATE,
617: B.LAST_UPDATE_LOGIN,
618: L.LANGUAGE_CODE,
619: B.SOURCE_LANG
620: from PV_GE_BENEFITS_TL B, FND_LANGUAGES L
621: where L.INSTALLED_FLAG in ('I', 'B')
622: and B.LANGUAGE = userenv('LANG')
623: and not exists
624: (select NULL

Line 625: from PV_GE_BENEFITS_TL T

621: where L.INSTALLED_FLAG in ('I', 'B')
622: and B.LANGUAGE = userenv('LANG')
623: and not exists
624: (select NULL
625: from PV_GE_BENEFITS_TL T
626: where T.BENEFIT_ID = B.BENEFIT_ID
627: and T.LANGUAGE = L.LANGUAGE_CODE);
628: end ADD_LANGUAGE;
629:

Line 638: update PV_GE_BENEFITS_TL set

634: , p_description in VARCHAR2
635: , p_owner in VARCHAR2
636: ) is
637: begin
638: update PV_GE_BENEFITS_TL set
639: description = nvl(p_description, description),
640: benefit_name = nvl( p_benefit_name, benefit_name),
641: source_lang = userenv('LANG'),
642: last_update_date = sysdate,