DBA Data[Home] [Help]

APPS.MSD_CS_DEFN_CLMN_LOAD_DATA dependencies on MSD_CS_DEFN_COLUMN_DTLS_S

Line 126: update MSD_CS_DEFN_COLUMN_DTLS set

122: if ((p_custom_mode = 'FORCE') or
123: ((l_user = 0) and (db_luby = 1)) or
124: ((l_user = db_luby) and (f_ludate > db_ludate)))
125: then
126: update MSD_CS_DEFN_COLUMN_DTLS set
127: source_view_column_name = p_source_view_column_name,
128: planning_view_column_name = p_planning_view_column_name,
129: column_identifier = p_column_identifier,
130: -- alt_key_flag = p_alt_key_flag,

Line 193: select MSD_CS_DEFN_COLUMN_DTLS_S.nextval into l_cs_column_dtls_id from dual;

189: end if;
190: -- Translate char last_update_date to date
191: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
192: --
193: select MSD_CS_DEFN_COLUMN_DTLS_S.nextval into l_cs_column_dtls_id from dual;
194: --
195: insert into MSD_CS_DEFN_COLUMN_DTLS(
196: cs_column_dtls_id,
197: cs_definition_id,