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.AS_LEADS_AUDIT_PKG dependencies on AS_LEAD_LINES_LOG

Line 417: update as_lead_lines_log

413: IF p_trigger_mode = 'ON-DELETE' THEN
414: l_new_last_update_date := sysdate;
415: END IF;
416:
417: update as_lead_lines_log
418: set object_version_number = nvl(object_version_number,0) + 1,
419: endday_log_flag = decode (trunc(l_new_last_update_date), trunc (p_old_last_update_date), 'N', 'Y')
420: where lead_line_id = p_old_lead_line_id
421: and last_update_date = p_old_last_update_date;

Line 456: SELECT COUNT(*) INTO l_line_count FROM AS_LEAD_LINES_LOG

452: ELSIF ( p_trigger_mode = 'ON-UPDATE' ) THEN
453: GET_VALUE(p_old_last_update_date,p_new_last_update_date,IsInsert);
454: -- dbms_output.put_line('Lead_Lines_Trigger_Handler IF Isinsert value' || IsInsert);
455:
456: SELECT COUNT(*) INTO l_line_count FROM AS_LEAD_LINES_LOG
457: WHERE LEAD_ID = p_old_lead_id
458: AND LEAD_LINE_ID = p_old_lead_line_id;
459:
460: IF (l_line_count = 0) THEN