[Home] [Help]
193: X_LAST_UPDATE_LOGIN,
194: X_TAX_PRODUCT_CATEGORY
195: );
196:
197: insert into AR_MEMO_LINES_ALL_TL (
198: ORG_ID,
199: MEMO_LINE_ID,
200: NAME,
201: DESCRIPTION,
221: from FND_LANGUAGES L
222: where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select NULL
225: from AR_MEMO_LINES_ALL_TL T
226: where T.MEMO_LINE_ID = X_MEMO_LINE_ID
227: and T.LANGUAGE = L.LANGUAGE_CODE
228: /* SSA changes anukumar
229: and NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),
362: cursor c1 is select
363: NAME,
364: DESCRIPTION,
365: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
366: from AR_MEMO_LINES_ALL_TL
367: where MEMO_LINE_ID = X_MEMO_LINE_ID
368: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
369: and NVL(ORG_ID,-99) = NVL(X_ORG_ID,-99) --SSA changes anukumar
370: /* SSA chnages anukumer
622: if (sql%notfound) then
623: raise no_data_found;
624: end if;
625:
626: update AR_MEMO_LINES_ALL_TL set
627: NAME = X_NAME,
628: DESCRIPTION = X_DESCRIPTION,
629: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
630: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
649: X_org_id in number default null, --SSA changes anukumar
650: X_MEMO_LINE_ID in NUMBER
651: ) is
652: begin
653: delete from AR_MEMO_LINES_ALL_TL
654: where MEMO_LINE_ID = X_MEMO_LINE_ID
655: /* SSA chnages anukumer
656: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
657: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
683: procedure ADD_LANGUAGE
684: is
685: begin
686:
687: delete from AR_MEMO_LINES_ALL_TL T
688: where not exists
689: (select NULL
690: from AR_MEMO_LINES_ALL_B B
691: where B.MEMO_LINE_ID = T.MEMO_LINE_ID
694: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
695: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
696: );
697:
698: update AR_MEMO_LINES_ALL_TL T set (
699: NAME,
700: DESCRIPTION
701: ) = (select
702: B.NAME,
700: DESCRIPTION
701: ) = (select
702: B.NAME,
703: B.DESCRIPTION
704: from AR_MEMO_LINES_ALL_TL B
705: where B.MEMO_LINE_ID = T.MEMO_LINE_ID
706: and B.LANGUAGE = T.SOURCE_LANG
707: and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
708: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
713: T.LANGUAGE
714: ) in (select
715: SUBT.MEMO_LINE_ID,
716: SUBT.LANGUAGE
717: from AR_MEMO_LINES_ALL_TL SUBB, AR_MEMO_LINES_ALL_TL SUBT
718: where SUBB.MEMO_LINE_ID = SUBT.MEMO_LINE_ID
719: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
720: and NVL(SUBB.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
721: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
728: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
729: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
730: ));
731:
732: insert into AR_MEMO_LINES_ALL_TL (
733: ORG_ID,
734: MEMO_LINE_ID,
735: NAME,
736: DESCRIPTION,
752: B.LAST_UPDATED_BY,
753: B.LAST_UPDATE_LOGIN,
754: L.LANGUAGE_CODE,
755: B.SOURCE_LANG
756: from AR_MEMO_LINES_ALL_TL B, FND_LANGUAGES L
757: where L.INSTALLED_FLAG in ('I', 'B')
758: and B.LANGUAGE = userenv('LANG')
759: and not exists
760: (select NULL
757: where L.INSTALLED_FLAG in ('I', 'B')
758: and B.LANGUAGE = userenv('LANG')
759: and not exists
760: (select NULL
761: from AR_MEMO_LINES_ALL_TL T
762: where T.MEMO_LINE_ID = B.MEMO_LINE_ID
763: and T.LANGUAGE = L.LANGUAGE_CODE
764: and NVL(T.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
765: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
966: -- note org_id is not used here because in NLS mode it is important
967: -- update a line id across all orgs because data will be translated
968: -- only once for a single org
969:
970: update AR_MEMO_LINES_ALL_TL
971: set name = X_NAME,
972: description = X_DESCRIPTION,
973: source_lang = userenv('LANG'),
974: last_update_date = sysdate,