APPS.OE_AGREEMENTS_PKG dependencies on OE_AGREEMENTS_TL

Line 208: insert into OE_AGREEMENTS_TL (

204: X_ORIG_SYSTEM_AGR_ID, --added by rchellam for OKC
205: X_INVOICE_TO_CUSTOMER_ID --Added for bug#4029589
206: );
207:
208: insert into OE_AGREEMENTS_TL (
209: CREATION_DATE,
210: CREATED_BY,
211: LAST_UPDATE_LOGIN,
212: NAME,

Line 236: from OE_AGREEMENTS_TL T

232: from FND_LANGUAGES L
233: where L.INSTALLED_FLAG in ('I', 'B')
234: and not exists
235: (select NULL
236: from OE_AGREEMENTS_TL T
237: where T.AGREEMENT_ID = X_AGREEMENT_ID
238: and T.LANGUAGE = L.LANGUAGE_CODE);
239:
240: open c;

Line 382: from OE_AGREEMENTS_TL

378:
379: cursor c1 is select
380: NAME,
381: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
382: from OE_AGREEMENTS_TL
383: where AGREEMENT_ID = X_AGREEMENT_ID
384: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
385: for update of AGREEMENT_ID nowait;
386: begin

Line 662: update OE_AGREEMENTS_TL set

658: if (sql%notfound) then
659: raise no_data_found;
660: end if;
661:
662: update OE_AGREEMENTS_TL set
663: NAME = X_NAME,
664: REVISION = X_REVISION,
665: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
666: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 682: delete from OE_AGREEMENTS_TL

678: procedure DELETE_ROW (
679: X_AGREEMENT_ID in NUMBER
680: ) is
681: begin
682: delete from OE_AGREEMENTS_TL
683: where AGREEMENT_ID = X_AGREEMENT_ID;
684:
685: if (sql%notfound) then
686: raise no_data_found;

Line 700: delete from OE_AGREEMENTS_TL T

696:
697: procedure ADD_LANGUAGE
698: is
699: begin
700: delete from OE_AGREEMENTS_TL T
701: where not exists
702: (select NULL
703: from OE_AGREEMENTS_B B
704: where B.AGREEMENT_ID = T.AGREEMENT_ID

Line 707: update OE_AGREEMENTS_TL T set (

703: from OE_AGREEMENTS_B B
704: where B.AGREEMENT_ID = T.AGREEMENT_ID
705: );
706:
707: update OE_AGREEMENTS_TL T set (
708: NAME
709: ) = (select
710: B.NAME
711: from OE_AGREEMENTS_TL B

Line 711: from OE_AGREEMENTS_TL B

707: update OE_AGREEMENTS_TL T set (
708: NAME
709: ) = (select
710: B.NAME
711: from OE_AGREEMENTS_TL B
712: where B.AGREEMENT_ID = T.AGREEMENT_ID
713: and B.LANGUAGE = T.SOURCE_LANG)
714: where (
715: T.AGREEMENT_ID,

Line 720: from OE_AGREEMENTS_TL SUBB, OE_AGREEMENTS_TL SUBT

716: T.LANGUAGE
717: ) in (select
718: SUBT.AGREEMENT_ID,
719: SUBT.LANGUAGE
720: from OE_AGREEMENTS_TL SUBB, OE_AGREEMENTS_TL SUBT
721: where SUBB.AGREEMENT_ID = SUBT.AGREEMENT_ID
722: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
723: and (SUBB.NAME <> SUBT.NAME
724: ));

Line 726: insert into OE_AGREEMENTS_TL (

722: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
723: and (SUBB.NAME <> SUBT.NAME
724: ));
725:
726: insert into OE_AGREEMENTS_TL (
727: CREATION_DATE,
728: CREATED_BY,
729: LAST_UPDATE_LOGIN,
730: NAME,

Line 750: from OE_AGREEMENTS_TL B, FND_LANGUAGES L

746: B.AGREEMENT_ID,
747: L.LANGUAGE_CODE,
748: B.SOURCE_LANG,
749: B.AGREEMENT_SOURCE_CODE --added by rchellam for OKC
750: from OE_AGREEMENTS_TL B, FND_LANGUAGES L
751: where L.INSTALLED_FLAG in ('I', 'B')
752: and B.LANGUAGE = userenv('LANG')
753: and not exists
754: (select NULL

Line 755: from OE_AGREEMENTS_TL T

751: where L.INSTALLED_FLAG in ('I', 'B')
752: and B.LANGUAGE = userenv('LANG')
753: and not exists
754: (select NULL
755: from OE_AGREEMENTS_TL T
756: where T.AGREEMENT_ID = B.AGREEMENT_ID
757: and T.LANGUAGE = L.LANGUAGE_CODE);
758: end ADD_LANGUAGE;
759: