APPS.MSD_CS_DEFN_DIM_LOAD_DATA dependencies on MSD_CS_DEFN_DIM_DTLS

Line 74: from msd_cs_defn_dim_dtls

70: where level_name = p_collect_level_name;
71: */
72: cursor c3(p_cs_def_id in number, p_dim_code in varchar2) is
73: select last_updated_by, last_update_date
74: from msd_cs_defn_dim_dtls
75: where cs_definition_id = p_cs_def_id
76: and dimension_code = p_dim_code;
77:
78: Begin

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,

Line 209: insert into MSD_CS_DEFN_DIM_DTLS(

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,
212: dimension_code,
213: collect_flag,