APPS.MSD_CS_CLMN_DIM_LOAD_DATA dependencies on MSD_CS_CLMN_DIM_DTLS

Line 57: from MSD_CS_CLMN_DIM_DTLS_V

53: cursor c1 is
54: select cs_clmn_dim_dtls_id,
55: last_updated_by,
56: last_update_date
57: from MSD_CS_CLMN_DIM_DTLS_V
58: where
59: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and
60: table_column = p_table_column and
61: dimension_code = p_dimension_code;

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,

Line 167: insert into MSD_CS_CLMN_DIM_DTLS(

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,
170: cs_column_dtls_id,
171: aggregation_type,