[Home] [Help]
2002: nvl(p_instance_id,l_rec.instance) <> nvl(l_temp_instance_id,-99999999) ) THEN
2003: l_temp_designator := l_rec.designator;
2004: l_temp_instance_id := nvl(p_instance_id,l_rec.instance);
2005:
2006: /* DWK Populate MSD_CS_DATA_HEADERS table after inserting rows
2007: into FACT table */
2008: insert_update_Into_Headers ( p_cs_rec.cs_definition_id,
2009: l_rec.designator,
2010: nvl(p_instance_id,l_rec.instance), p_new_refresh_num);
2146: /*************************************************************************************************
2147: PROCEDURE Insert_update_Into_Headers
2148:
2149: This procedure will decide whether insert cs_definition_id, cs_name, and instance into
2150: msd_cs_data_headers table or not and insert row if necessary.
2151: **************************************************************************************************/
2152: Procedure insert_update_Into_Headers ( p_cs_definition_id in number,
2153: p_cs_name in varchar2,
2154: p_instance_id in number,
2158: p_count NUMBER:=0;
2159:
2160: BEGIN
2161:
2162: SELECT count(*) INTO p_count FROM msd_cs_data_headers_v1
2163: WHERE instance = p_instance_id AND
2164: cs_definition_id = p_cs_definition_id AND
2165: cs_name = p_cs_name;
2166:
2170: p_instance_id,
2171: p_refresh_num);
2172: ELSE
2173:
2174: update msd_cs_data_headers
2175: set last_refresh_num = p_refresh_num
2176: where cs_definition_id = p_cs_definition_id
2177: and instance = p_instance_id
2178: and cs_name = p_cs_name;
2191: /*************************************************************************************************
2192: PROCEDURE Insert_Data_Into_Headers
2193:
2194: This procedure will insert cs_definition_id, cs_name, and instance into
2195: msd_cs_data_headers table.
2196: **************************************************************************************************/
2197: Procedure Insert_Data_Into_Headers ( p_cs_definition_id in number,
2198: p_cs_name in varchar2,
2199: p_instance_id in number,
2201:
2202:
2203: BEGIN
2204:
2205: INSERT INTO msd_cs_data_headers
2206: ( CS_DATA_HEADER_ID,
2207: INSTANCE,
2208: CS_DEFINITION_ID,
2209: CS_NAME,
2213: CREATED_BY,
2214: LAST_UPDATE_LOGIN,
2215: LAST_REFRESH_NUM
2216: )
2217: VALUES ( msd_cs_data_headers_s.nextval,
2218: p_instance_id,
2219: p_cs_definition_id,
2220: p_cs_name,
2221: sysdate,
2229:
2230:
2231: Exception
2232: When others then
2233: show_line('Error in inserting into MSD_CS_DATA_HEADERS');
2234: show_line(sqlerrm);
2235: raise;
2236:
2237: END Insert_Data_Into_Headers;