APPS.SO_AGREEMENTS_PKG dependencies on SO_AGREEMENTS_TL

Line 132: insert into SO_AGREEMENTS_TL (

128: X_LAST_UPDATED_BY,
129: X_LAST_UPDATE_LOGIN
130: );
131:
132: insert into SO_AGREEMENTS_TL (
133: AGREEMENT_ID,
134: NAME,
135: LAST_UPDATE_DATE,
136: LAST_UPDATED_BY,

Line 156: from SO_AGREEMENTS_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from SO_AGREEMENTS_TL T
157: where T.AGREEMENT_ID = X_AGREEMENT_ID
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: open c;

Line 249: from SO_AGREEMENTS_TL

245:
246: cursor c1 is select
247: NAME,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from SO_AGREEMENTS_TL
250: where AGREEMENT_ID = X_AGREEMENT_ID
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of AGREEMENT_ID nowait;
253: begin

Line 428: update SO_AGREEMENTS_TL set

424: if (sql%notfound) then
425: raise no_data_found;
426: end if;
427:
428: update SO_AGREEMENTS_TL set
429: NAME = X_NAME,
430: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
431: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
432: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 446: delete from SO_AGREEMENTS_TL

442: procedure DELETE_ROW (
443: X_AGREEMENT_ID in NUMBER
444: ) is
445: begin
446: delete from SO_AGREEMENTS_TL
447: where AGREEMENT_ID = X_AGREEMENT_ID;
448:
449: if (sql%notfound) then
450: raise no_data_found;

Line 464: delete from SO_AGREEMENTS_TL T

460:
461: procedure ADD_LANGUAGE
462: is
463: begin
464: delete from SO_AGREEMENTS_TL T
465: where not exists
466: (select NULL
467: from SO_AGREEMENTS_B B
468: where B.AGREEMENT_ID = T.AGREEMENT_ID

Line 471: update SO_AGREEMENTS_TL T set (

467: from SO_AGREEMENTS_B B
468: where B.AGREEMENT_ID = T.AGREEMENT_ID
469: );
470:
471: update SO_AGREEMENTS_TL T set (
472: NAME
473: ) = (select
474: B.NAME
475: from SO_AGREEMENTS_TL B

Line 475: from SO_AGREEMENTS_TL B

471: update SO_AGREEMENTS_TL T set (
472: NAME
473: ) = (select
474: B.NAME
475: from SO_AGREEMENTS_TL B
476: where B.AGREEMENT_ID = T.AGREEMENT_ID
477: and B.LANGUAGE = T.SOURCE_LANG)
478: where (
479: T.AGREEMENT_ID,

Line 484: from SO_AGREEMENTS_TL SUBB, SO_AGREEMENTS_TL SUBT

480: T.LANGUAGE
481: ) in (select
482: SUBT.AGREEMENT_ID,
483: SUBT.LANGUAGE
484: from SO_AGREEMENTS_TL SUBB, SO_AGREEMENTS_TL SUBT
485: where SUBB.AGREEMENT_ID = SUBT.AGREEMENT_ID
486: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
487: and (SUBB.NAME <> SUBT.NAME
488: ));

Line 490: insert into SO_AGREEMENTS_TL (

486: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
487: and (SUBB.NAME <> SUBT.NAME
488: ));
489:
490: insert into SO_AGREEMENTS_TL (
491: AGREEMENT_ID,
492: NAME,
493: LAST_UPDATE_DATE,
494: LAST_UPDATED_BY,

Line 510: from SO_AGREEMENTS_TL B, FND_LANGUAGES L

506: B.CREATED_BY,
507: B.LAST_UPDATE_LOGIN,
508: L.LANGUAGE_CODE,
509: B.SOURCE_LANG
510: from SO_AGREEMENTS_TL B, FND_LANGUAGES L
511: where L.INSTALLED_FLAG in ('I', 'B')
512: and B.LANGUAGE = userenv('LANG')
513: and not exists
514: (select NULL

Line 515: from SO_AGREEMENTS_TL T

511: where L.INSTALLED_FLAG in ('I', 'B')
512: and B.LANGUAGE = userenv('LANG')
513: and not exists
514: (select NULL
515: from SO_AGREEMENTS_TL T
516: where T.AGREEMENT_ID = B.AGREEMENT_ID
517: and T.LANGUAGE = L.LANGUAGE_CODE);
518: end ADD_LANGUAGE;
519: