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