APPS.MSD_CS_CLMN_DIM_LOAD_DATA dependencies on MSD_CS_CLMN_DIM_DTLS_S

Line 95: update MSD_CS_CLMN_DIM_DTLS set

91: ((l_user = 0) and (db_luby = 1)) or
92: ((l_user = db_luby) and (f_ludate > db_ludate)))
93: then
94:
95: update MSD_CS_CLMN_DIM_DTLS set
96: aggregation_type = p_aggregation_type,
97: allocation_type = p_allocation_type,
98: last_updated_by = l_user,
99: last_update_date = f_ludate

Line 165: select MSD_CS_CLMN_DIM_DTLS_S.nextval into l_PK_id from dual;

161: if l_cs_id1 is null or l_cs_id2 is null then
162: raise NO_DATA_FOUND;
163: end if;
164: --
165: select MSD_CS_CLMN_DIM_DTLS_S.nextval into l_PK_id from dual;
166: --
167: insert into MSD_CS_CLMN_DIM_DTLS(
168: cs_clmn_dim_dtls_id,
169: cs_defn_dim_dtls_id,