APPS.AS_LEADS_AUDIT_PKG dependencies on AS_LEADS_LINES_LOG_PKG

Line 425: AS_LEADS_LINES_LOG_PKG.Insert_Row(p_new_lead_id ,

421: and last_update_date = p_old_last_update_date;
422:
423: IF ( p_trigger_mode = 'ON-INSERT' ) THEN
424: -- dbms_output.put_line('Lead_Lines_Trigger_Handler Trigger mode' || p_trigger_mode);
425: AS_LEADS_LINES_LOG_PKG.Insert_Row(p_new_lead_id ,
426: p_new_lead_line_id ,
427: p_new_last_update_date ,
428: p_new_last_updated_by ,
429: p_new_last_update_login ,

Line 462: AS_LEADS_LINES_LOG_PKG.Insert_Row(p_new_lead_id,

458: AND LEAD_LINE_ID = p_old_lead_line_id;
459:
460: IF (l_line_count = 0) THEN
461: -- dbms_output.put_line('Lead_Lines_Trigger_Handler I am in not exist state' || l_line_count);
462: AS_LEADS_LINES_LOG_PKG.Insert_Row(p_new_lead_id,
463: p_new_lead_line_id ,
464: p_new_last_update_date ,
465: p_new_last_updated_by ,
466: p_new_last_update_login ,

Line 510: AS_LEADS_LINES_LOG_PKG.Update_Row(p_new_lead_id ,

506: IF (IsInsert = 0) THEN
507: -- dbms_output.put_line('Lead_Lines_Trigger_Handler I am in changes same day state' || IsInsert);
508: -- dbms_output.put_line('Lead_Lines_Trigger_Handler I am in changes same day state old date' || to_char(p_old_last_update_date,'dd:mm:yyyy HH:MI:SS'));
509: -- dbms_output.put_line('Lead_Lines_Trigger_Handler I am in changes same day state new state' || to_char(p_new_last_update_date,'dd:mm:yyyy HH:MI:SS'));
510: AS_LEADS_LINES_LOG_PKG.Update_Row(p_new_lead_id ,
511: p_old_lead_line_id ,
512: p_old_last_update_date ,
513: p_new_last_update_date ,
514: p_new_last_updated_by ,

Line 538: AS_LEADS_LINES_LOG_PKG.Insert_Row(p_new_lead_id,

534: 'asxopadb: Update Log: Lead_line_id '||p_old_lead_line_id || ' and Last Update Date '|| p_old_last_update_date);
535: END IF;
536: ELSE
537: -- dbms_output.put_line('Lead_Lines_Trigger_Handler I am in changes diff day state' || IsInsert);
538: AS_LEADS_LINES_LOG_PKG.Insert_Row(p_new_lead_id,
539: p_new_lead_line_id ,
540: p_new_last_update_date ,
541: p_new_last_updated_by ,
542: p_new_last_update_login ,

Line 573: AS_LEADS_LINES_LOG_PKG.Delete_Row(p_old_lead_id,

569: END IF;
570: ELSIF( p_trigger_mode = 'ON-DELETE' ) THEN
571:
572: -- dbms_output.put_line('Lead_Lines_Trigger_Handler delte value');
573: AS_LEADS_LINES_LOG_PKG.Delete_Row(p_old_lead_id,
574: p_old_lead_line_id ,
575: p_old_last_update_date ,
576: p_old_last_updated_by ,
577: p_old_last_update_login ,