APPS.MSD_CS_DEFN_CLMN_LOAD_DATA dependencies on MSD_CS_DEFN_COLUMN_DTLS

Line 85: from msd_cs_defn_column_dtls

81:
82: cursor c2 (p_id in number, p_column in varchar2) is
83: select last_updated_by,
84: last_update_date
85: from msd_cs_defn_column_dtls
86: where cs_definition_id = p_id
87: and table_column = p_column;
88:
89: Begin

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,

Line 195: insert into MSD_CS_DEFN_COLUMN_DTLS(

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,
198: source_view_column_name,
199: planning_view_column_name,