APPS.CZ_POPULATORS_PKG dependencies on CZ_LOCALIZED_TEXTS

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

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

Line 794: UPDATE CZ_LOCALIZED_TEXTS

790: -- and set source_lang to current language
791: -- for those localized texts wfor which language <> current language and
792: -- source language <> current language
793: --
794: UPDATE CZ_LOCALIZED_TEXTS
795: SET localized_str=var_desc_text,
796: source_lang=var_current_lang
797: WHERE intl_text_id=var_new_text_id;
798:

Line 1139: UPDATE CZ_LOCALIZED_TEXTS

1135: START WITH component_id=t_ps_node_id(i)
1136: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1137:
1138: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
1139: UPDATE CZ_LOCALIZED_TEXTS
1140: SET deleted_flag='1'
1141: WHERE intl_text_id=t_intl_text_id(i);
1142: END IF;
1143:

Line 1202: UPDATE CZ_LOCALIZED_TEXTS

1198: START WITH component_id=t_ps_node_id(i)
1199: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1200:
1201: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
1202: UPDATE CZ_LOCALIZED_TEXTS
1203: SET deleted_flag='1'
1204: WHERE intl_text_id=t_intl_text_id(i);
1205:
1206: END IF;