[Home] [Help]
164: X_EXPANDED_SQL_QUERY_CODE,
165: X_DISPLAY_WIDTH
166: );
167:
168: insert into BNE_INTERFACE_COLS_TL (
169: CREATED_BY,
170: CREATION_DATE,
171: LAST_UPDATED_BY,
172: LAST_UPDATE_LOGIN,
198: from FND_LANGUAGES L
199: where L.INSTALLED_FLAG in ('I', 'B')
200: and not exists
201: (select NULL
202: from BNE_INTERFACE_COLS_TL T
203: where T.APPLICATION_ID = X_APPLICATION_ID
204: and T.INTERFACE_CODE = X_INTERFACE_CODE
205: and T.SEQUENCE_NUM = X_SEQUENCE_NUM
206: and T.LANGUAGE = L.LANGUAGE_CODE);
319: PROMPT_LEFT,
320: USER_HELP_TEXT,
321: PROMPT_ABOVE,
322: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
323: from BNE_INTERFACE_COLS_TL
324: where APPLICATION_ID = X_APPLICATION_ID
325: and INTERFACE_CODE = X_INTERFACE_CODE
326: and SEQUENCE_NUM = X_SEQUENCE_NUM
327: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
541: if (sql%notfound) then
542: raise no_data_found;
543: end if;
544:
545: update BNE_INTERFACE_COLS_TL set
546: USER_HINT = X_USER_HINT,
547: PROMPT_LEFT = X_PROMPT_LEFT,
548: USER_HELP_TEXT = X_USER_HELP_TEXT,
549: PROMPT_ABOVE = X_PROMPT_ABOVE,
566: X_INTERFACE_CODE in VARCHAR2,
567: X_SEQUENCE_NUM in NUMBER
568: ) is
569: begin
570: delete from BNE_INTERFACE_COLS_TL
571: where APPLICATION_ID = X_APPLICATION_ID
572: and INTERFACE_CODE = X_INTERFACE_CODE
573: and SEQUENCE_NUM = X_SEQUENCE_NUM;
574:
588:
589: procedure ADD_LANGUAGE
590: is
591: begin
592: delete from BNE_INTERFACE_COLS_TL T
593: where not exists
594: (select NULL
595: from BNE_INTERFACE_COLS_B B
596: where B.APPLICATION_ID = T.APPLICATION_ID
597: and B.INTERFACE_CODE = T.INTERFACE_CODE
598: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
599: );
600:
601: update BNE_INTERFACE_COLS_TL T set (
602: USER_HINT,
603: PROMPT_LEFT,
604: USER_HELP_TEXT,
605: PROMPT_ABOVE
607: B.USER_HINT,
608: B.PROMPT_LEFT,
609: B.USER_HELP_TEXT,
610: B.PROMPT_ABOVE
611: from BNE_INTERFACE_COLS_TL B
612: where B.APPLICATION_ID = T.APPLICATION_ID
613: and B.INTERFACE_CODE = T.INTERFACE_CODE
614: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
615: and B.LANGUAGE = T.SOURCE_LANG)
622: SUBT.APPLICATION_ID,
623: SUBT.INTERFACE_CODE,
624: SUBT.SEQUENCE_NUM,
625: SUBT.LANGUAGE
626: from BNE_INTERFACE_COLS_TL SUBB, BNE_INTERFACE_COLS_TL SUBT
627: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
628: and SUBB.INTERFACE_CODE = SUBT.INTERFACE_CODE
629: and SUBB.SEQUENCE_NUM = SUBT.SEQUENCE_NUM
630: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
641: or (SUBB.PROMPT_ABOVE is null and SUBT.PROMPT_ABOVE is not null)
642: or (SUBB.PROMPT_ABOVE is not null and SUBT.PROMPT_ABOVE is null)
643: ));
644:
645: insert into BNE_INTERFACE_COLS_TL (
646: CREATED_BY,
647: CREATION_DATE,
648: LAST_UPDATED_BY,
649: LAST_UPDATE_LOGIN,
671: B.SEQUENCE_NUM,
672: B.APPLICATION_ID,
673: L.LANGUAGE_CODE,
674: B.SOURCE_LANG
675: from BNE_INTERFACE_COLS_TL B, FND_LANGUAGES L
676: where L.INSTALLED_FLAG in ('I', 'B')
677: and B.LANGUAGE = userenv('LANG')
678: and not exists
679: (select NULL
676: where L.INSTALLED_FLAG in ('I', 'B')
677: and B.LANGUAGE = userenv('LANG')
678: and not exists
679: (select NULL
680: from BNE_INTERFACE_COLS_TL T
681: where T.APPLICATION_ID = B.APPLICATION_ID
682: and T.INTERFACE_CODE = B.INTERFACE_CODE
683: and T.SEQUENCE_NUM = B.SEQUENCE_NUM
684: and T.LANGUAGE = L.LANGUAGE_CODE);
726: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
727: begin
728: select LAST_UPDATED_BY, LAST_UPDATE_DATE
729: into db_luby, db_ludate
730: from BNE_INTERFACE_COLS_TL
731: where APPLICATION_ID = l_app_id
732: and INTERFACE_CODE = x_interface_code
733: and SEQUENCE_NUM = x_sequence_num
734: and LANGUAGE = userenv('LANG');
736: -- Test for customization and version
737: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
738: db_ludate, x_custom_mode)) then
739:
740: update BNE_INTERFACE_COLS_TL
741: set USER_HINT = x_user_hint,
742: PROMPT_LEFT = x_prompt_left,
743: PROMPT_ABOVE = x_prompt_above,
744: USER_HELP_TEXT = x_user_help_text,