DBA Data[Home] [Help]

APPS.MSD_CS_DEFN_DIM_LOAD_DATA dependencies on MSD_CS_DEFN_DIM_DTLS_S

Line 128: update MSD_CS_DEFN_DIM_DTLS set

124: ((l_user = 0) and (db_luby = 1)) or
125: ((l_user = db_luby) and (f_ludate > db_ludate)))
126: then
127:
128: update MSD_CS_DEFN_DIM_DTLS set
129: collect_flag = p_collect_flag,
130: collect_level_id = l_level_id,
131: aggregation_type = p_aggregation_type,
132: allocation_type = p_allocation_type,

Line 207: select MSD_CS_DEFN_DIM_DTLS_S.nextval into l_pk_id from dual;

203:
204: -- Translate char last_update_date to date
205: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
206:
207: select MSD_CS_DEFN_DIM_DTLS_S.nextval into l_pk_id from dual;
208:
209: insert into MSD_CS_DEFN_DIM_DTLS(
210: cs_defn_dim_dtls_id,
211: cs_definition_id,