DBA Data[Home] [Help]

APPS.CZ_RULE_IMPORT dependencies on CZ_INTL_TEXTS_S

Line 1887: SELECT cz_intl_texts_s.NEXTVAL INTO last_id_allocated FROM dual;

1883:
1884: IF((last_id_allocated IS NULL) OR
1885: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
1886:
1887: SELECT cz_intl_texts_s.NEXTVAL INTO last_id_allocated FROM dual;
1888: next_id_to_use := last_id_allocated;
1889: END IF;
1890:
1891: id_to_return := next_id_to_use;

Line 2853: (t_last_update_login(i), t_text_str(i), cz_intl_texts_s.NEXTVAL, 0, t_model_id(i)) ;

2849: SAVEPOINT insert_msg_record;
2850: INSERT INTO cz_localized_texts_vl
2851: (last_update_login, text_str, intl_text_id, deleted_flag, model_id)
2852: VALUES
2853: (t_last_update_login(i), t_text_str(i), cz_intl_texts_s.NEXTVAL, 0, t_model_id(i)) ;
2854:
2855: UPDATE CZ_RULES
2856: SET reason_id = cz_intl_texts_s.currval
2857: WHERE devl_project_id = t_model_id(i)

Line 2856: SET reason_id = cz_intl_texts_s.currval

2852: VALUES
2853: (t_last_update_login(i), t_text_str(i), cz_intl_texts_s.NEXTVAL, 0, t_model_id(i)) ;
2854:
2855: UPDATE CZ_RULES
2856: SET reason_id = cz_intl_texts_s.currval
2857: WHERE devl_project_id = t_model_id(i)
2858: AND rule_id = t_rules_id(i);
2859:
2860: EXCEPTION