917: write_log(DEBUG,l_sql_final );
918:
919:
920:
921: c_int := DBMS_SQL.OPEN_CURSOR;
922: DBMS_SQL.PARSE(c_int, l_sql_final , dbms_sql.native);
923: DBMS_SQL.BIND_VARIABLE(c_int, ':C_INTERFACE_RUN_ID', P_INTERFACE_RUN_ID);
924: DBMS_SQL.BIND_VARIABLE(c_int, ':C_ELEMENT_TYPE_ID', P_ELEMENT_TYPE_ID);
925: l_row_processed := dbms_sql.execute(c_int);
918:
919:
920:
921: c_int := DBMS_SQL.OPEN_CURSOR;
922: DBMS_SQL.PARSE(c_int, l_sql_final , dbms_sql.native);
923: DBMS_SQL.BIND_VARIABLE(c_int, ':C_INTERFACE_RUN_ID', P_INTERFACE_RUN_ID);
924: DBMS_SQL.BIND_VARIABLE(c_int, ':C_ELEMENT_TYPE_ID', P_ELEMENT_TYPE_ID);
925: l_row_processed := dbms_sql.execute(c_int);
926:
919:
920:
921: c_int := DBMS_SQL.OPEN_CURSOR;
922: DBMS_SQL.PARSE(c_int, l_sql_final , dbms_sql.native);
923: DBMS_SQL.BIND_VARIABLE(c_int, ':C_INTERFACE_RUN_ID', P_INTERFACE_RUN_ID);
924: DBMS_SQL.BIND_VARIABLE(c_int, ':C_ELEMENT_TYPE_ID', P_ELEMENT_TYPE_ID);
925: l_row_processed := dbms_sql.execute(c_int);
926:
927: write_log(Log,'P_INTERFACE_RUN_ID - ' || P_INTERFACE_RUN_ID || ' P_ELEMENT_TYPE_ID - '|| P_ELEMENT_TYPE_ID || 'Records processed- ' || l_row_processed );
920:
921: c_int := DBMS_SQL.OPEN_CURSOR;
922: DBMS_SQL.PARSE(c_int, l_sql_final , dbms_sql.native);
923: DBMS_SQL.BIND_VARIABLE(c_int, ':C_INTERFACE_RUN_ID', P_INTERFACE_RUN_ID);
924: DBMS_SQL.BIND_VARIABLE(c_int, ':C_ELEMENT_TYPE_ID', P_ELEMENT_TYPE_ID);
925: l_row_processed := dbms_sql.execute(c_int);
926:
927: write_log(Log,'P_INTERFACE_RUN_ID - ' || P_INTERFACE_RUN_ID || ' P_ELEMENT_TYPE_ID - '|| P_ELEMENT_TYPE_ID || 'Records processed- ' || l_row_processed );
928:
921: c_int := DBMS_SQL.OPEN_CURSOR;
922: DBMS_SQL.PARSE(c_int, l_sql_final , dbms_sql.native);
923: DBMS_SQL.BIND_VARIABLE(c_int, ':C_INTERFACE_RUN_ID', P_INTERFACE_RUN_ID);
924: DBMS_SQL.BIND_VARIABLE(c_int, ':C_ELEMENT_TYPE_ID', P_ELEMENT_TYPE_ID);
925: l_row_processed := dbms_sql.execute(c_int);
926:
927: write_log(Log,'P_INTERFACE_RUN_ID - ' || P_INTERFACE_RUN_ID || ' P_ELEMENT_TYPE_ID - '|| P_ELEMENT_TYPE_ID || 'Records processed- ' || l_row_processed );
928:
929: EXCEPTION