APPS.CZ_POPULATORS_PKG dependencies on CZ_LOCALIZED_TEXTS

Line 556: var_current_lang CZ_LOCALIZED_TEXTS.language%TYPE := USERENV('LANG');

552: ps_node_already_exists BOOLEAN;
553: var_level_column VARCHAR2(20):='';
554: rcode VARCHAR2(4000);
555: var_counted_options_flag VARCHAR2(1);
556: var_current_lang CZ_LOCALIZED_TEXTS.language%TYPE := USERENV('LANG');
557: SKIP_IT EXCEPTION;
558: WRONG_SQL EXCEPTION;
559: WRONG_COLUMN_TYPE EXCEPTION;
560:

Line 788: UPDATE CZ_LOCALIZED_TEXTS

784: -- and set source_lang to current language
785: -- for those localized texts wfor which language <> current language and
786: -- source language <> current language
787: --
788: UPDATE CZ_LOCALIZED_TEXTS
789: SET localized_str=var_desc_text,
790: source_lang=var_current_lang
791: WHERE intl_text_id=var_new_text_id;
792:

Line 1127: UPDATE CZ_LOCALIZED_TEXTS

1123: START WITH component_id=t_ps_node_id(i)
1124: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1125:
1126: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
1127: UPDATE CZ_LOCALIZED_TEXTS
1128: SET deleted_flag='1'
1129: WHERE intl_text_id=t_intl_text_id(i);
1130: END IF;
1131:

Line 1188: UPDATE CZ_LOCALIZED_TEXTS

1184: START WITH component_id=t_ps_node_id(i)
1185: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1186:
1187: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
1188: UPDATE CZ_LOCALIZED_TEXTS
1189: SET deleted_flag='1'
1190: WHERE intl_text_id=t_intl_text_id(i);
1191:
1192: END IF;