DBA Data[Home] [Help]

APPS.CZ_IMP_IM_XFR dependencies on DUAL

Line 904: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;

900: IF (p_xfr_property.DISPOSITION = 'I') THEN
901: BEGIN
902: IF p_xfr_property.DATA_TYPE = 8 THEN
903: --###1
904: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
905: FOR i IN(SELECT language_code FROM FND_LANGUAGES
906: WHERE installed_flag in( 'B', 'I'))
907: LOOP
908: INSERT INTO cz_localized_texts (intl_text_id, localized_str,

Line 1110: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;

1106: END IF;
1107:
1108: IF p_xfr_property.DATA_TYPE = 8 THEN
1109: IF p_xfr_property.DEF_NUM_VALUE IS NULL THEN
1110: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
1111: FOR i IN(SELECT language_code FROM FND_LANGUAGES
1112: WHERE installed_flag in( 'B', 'I'))
1113: LOOP
1114: INSERT INTO cz_localized_texts (intl_text_id, localized_str,