eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_AUDIT_ATTR_HISTORY

Line 914: /* This flag will be true when the last record in oe_audit_attr_history

910: OPEN ref_attr FOR l_sql_stmt
911: USING min_hist_creation_date, max_hist_creation_date, l_header_id, l_entity_number;
912: i_counter := 1;
913: l_rec_counter := 1;
914: /* This flag will be true when the last record in oe_audit_attr_history
915: will be updated with the new attribute value column */
916: l_old_db_rec_upd_flag := false;
917: l_old_hist_creation_date := null;
918: l_old_reason_code := null;

Line 954: FROM oe_audit_attr_history

950:
951: -- Check if history records exist for this attribute
952: SELECT count(*)
953: INTO l_count_hist
954: FROM oe_audit_attr_history
955: WHERE hist_creation_date = l_hist_creation_date
956: AND entity_number = l_entity_number
957: AND attribute_id = c_attr_tbl(j).attribute_id
958: AND entity_id = c_ent_rec.entity_id

Line 1392: INSERT INTO OE_AUDIT_ATTR_HISTORY

1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add('Inserting history records for order number => '||oe_pc_attr_tbl(i).order_number,1);
1390:
1391: END IF;
1392: INSERT INTO OE_AUDIT_ATTR_HISTORY
1393: (entity_id,
1394: attribute_id,
1395: reason_code,
1396: hist_creation_date,