DBA Data[Home] [Help]

APPS.CZ_IMP_IM_XFR dependencies on DUAL

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

860: IF (p_xfr_property.DISPOSITION = 'I') THEN
861: BEGIN
862: IF p_xfr_property.DATA_TYPE = 8 THEN
863: --###1
864: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
865: FOR i IN(SELECT language_code FROM FND_LANGUAGES
866: WHERE installed_flag in( 'B', 'I'))
867: LOOP
868: INSERT INTO cz_localized_texts (intl_text_id, localized_str,

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

1058: END IF;
1059:
1060: IF p_xfr_property.DATA_TYPE = 8 THEN
1061: IF p_xfr_property.DEF_NUM_VALUE IS NULL THEN
1062: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
1063: FOR i IN(SELECT language_code FROM FND_LANGUAGES
1064: WHERE installed_flag in( 'B', 'I'))
1065: LOOP
1066: INSERT INTO cz_localized_texts (intl_text_id, localized_str,