[Home] [Help]
1129: OPEN ref_attr FOR l_sql_stmt
1130: USING min_hist_creation_date, max_hist_creation_date, l_header_id, l_entity_number;
1131: i_counter := 1;
1132: l_rec_counter := 1;
1133: /* This flag will be true when the last record in oe_audit_attr_history
1134: will be updated with the new attribute value column */
1135: l_old_db_rec_upd_flag := false;
1136: l_old_hist_creation_date := null;
1137: l_old_reason_code := null;
1173:
1174: -- Check if history records exist for this attribute
1175: SELECT count(*)
1176: INTO l_count_hist
1177: FROM oe_audit_attr_history
1178: WHERE hist_creation_date = l_hist_creation_date
1179: AND entity_number = l_entity_number
1180: AND attribute_id = c_attr_tbl(j).attribute_id
1181: AND entity_id = c_ent_rec.entity_id
1741: oe_debug_pub.add('Inserting history records for order number => '||oe_pc_attr_tbl(i).order_number,1);
1742:
1743: END IF;
1744: BEGIN -- 16447475
1745: INSERT INTO OE_AUDIT_ATTR_HISTORY
1746: (entity_id,
1747: attribute_id,
1748: reason_code,
1749: hist_creation_date,
1779: oe_pc_attr_tbl(I).old_context_value, --Bug4324371
1780: oe_pc_attr_tbl(I).new_context_Value );
1781: -- 16447475 start
1782: EXCEPTION WHEN OTHERS THEN
1783: OE_DEBUG_PUB.add(' In EXCEPTION : After Insert in OE_AUDIT_ATTR_HISTORY ', 5);
1784: oe_pc_attr_tbl.delete(i);
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1799:
1800: EXCEPTION WHEN OTHERS THEN
1801: OE_DEBUG_PUB.add(' In EXCEPTION : deleting oe_pc_attr_tbl ', 5);
1802: oe_pc_attr_tbl.delete; -- bug# 9067627 : Delete these tables when above INSERT encounters some error(s)
1803: -- e.g. => ORA-00001: unique constraint (ONT.OE_AUDIT_ATTR_HISTORY_U1) violated
1804:
1805: IF l_debug_level > 0 THEN
1806: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1807: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);