APPS.PV_REFERRALS_PKG dependencies on PV_REFERRALS_TL

Line 259: insert into PV_REFERRALS_TL (

255: X_ATTRIBUTE23,
256: X_ATTRIBUTE24
257: );
258:
259: insert into PV_REFERRALS_TL (
260: CREATION_DATE,
261: CREATED_BY,
262: REFERRAL_ID,
263: LAST_UPDATE_DATE,

Line 287: from PV_REFERRALS_TL T

283: from FND_LANGUAGES L
284: where L.INSTALLED_FLAG in ('I', 'B')
285: and not exists
286: (select NULL
287: from PV_REFERRALS_TL T
288: where T.REFERRAL_ID = X_REFERRAL_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290:
291: open c;

Line 466: from PV_REFERRALS_TL

462: cursor c1 is select
463: REFERRAL_NAME,
464: DESCRIPTION,
465: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
466: from PV_REFERRALS_TL
467: where REFERRAL_ID = X_REFERRAL_ID
468: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
469: for update of REFERRAL_ID nowait;
470: begin

Line 809: update PV_REFERRALS_TL set

805: if (sql%notfound) then
806: raise no_data_found;
807: end if;
808:
809: update PV_REFERRALS_TL set
810: REFERRAL_NAME = X_REFERRAL_NAME,
811: DESCRIPTION = X_DESCRIPTION,
812: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
813: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 828: delete from PV_REFERRALS_TL

824: procedure DELETE_ROW (
825: X_REFERRAL_ID in NUMBER
826: ) is
827: begin
828: delete from PV_REFERRALS_TL
829: where REFERRAL_ID = X_REFERRAL_ID;
830:
831: if (sql%notfound) then
832: raise no_data_found;

Line 846: delete from PV_REFERRALS_TL T

842:
843: procedure ADD_LANGUAGE
844: is
845: begin
846: delete from PV_REFERRALS_TL T
847: where not exists
848: (select NULL
849: from PV_REFERRALS_B B
850: where B.REFERRAL_ID = T.REFERRAL_ID

Line 853: update PV_REFERRALS_TL T set (

849: from PV_REFERRALS_B B
850: where B.REFERRAL_ID = T.REFERRAL_ID
851: );
852:
853: update PV_REFERRALS_TL T set (
854: REFERRAL_NAME,
855: DESCRIPTION
856: ) = (select
857: B.REFERRAL_NAME,

Line 859: from PV_REFERRALS_TL B

855: DESCRIPTION
856: ) = (select
857: B.REFERRAL_NAME,
858: B.DESCRIPTION
859: from PV_REFERRALS_TL B
860: where B.REFERRAL_ID = T.REFERRAL_ID
861: and B.LANGUAGE = T.SOURCE_LANG)
862: where (
863: T.REFERRAL_ID,

Line 868: from PV_REFERRALS_TL SUBB, PV_REFERRALS_TL SUBT

864: T.LANGUAGE
865: ) in (select
866: SUBT.REFERRAL_ID,
867: SUBT.LANGUAGE
868: from PV_REFERRALS_TL SUBB, PV_REFERRALS_TL SUBT
869: where SUBB.REFERRAL_ID = SUBT.REFERRAL_ID
870: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
871: and (SUBB.REFERRAL_NAME <> SUBT.REFERRAL_NAME
872: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 875: insert into PV_REFERRALS_TL (

871: and (SUBB.REFERRAL_NAME <> SUBT.REFERRAL_NAME
872: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
873: ));
874:
875: insert into PV_REFERRALS_TL (
876: CREATION_DATE,
877: CREATED_BY,
878: REFERRAL_ID,
879: LAST_UPDATE_DATE,

Line 899: from PV_REFERRALS_TL B, FND_LANGUAGES L

895: B.REFERRAL_NAME,
896: B.DESCRIPTION,
897: L.LANGUAGE_CODE,
898: B.SOURCE_LANG
899: from PV_REFERRALS_TL B, FND_LANGUAGES L
900: where L.INSTALLED_FLAG in ('I', 'B')
901: and B.LANGUAGE = userenv('LANG')
902: and not exists
903: (select NULL

Line 904: from PV_REFERRALS_TL T

900: where L.INSTALLED_FLAG in ('I', 'B')
901: and B.LANGUAGE = userenv('LANG')
902: and not exists
903: (select NULL
904: from PV_REFERRALS_TL T
905: where T.REFERRAL_ID = B.REFERRAL_ID
906: and T.LANGUAGE = L.LANGUAGE_CODE);
907: end ADD_LANGUAGE;
908: