DBA Data[Home] [Help]

APPS.AS_LEADS_AUDIT_PKG dependencies on AS_SALES_CREDITS_LOG_PKG

Line 666: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,

662: and last_update_date = p_old_last_update_date;
663:
664: IF ( p_trigger_mode = 'ON-INSERT' ) THEN
665: -- dbms_output.put_line('Sales_Credits_Trigger_Handler Trigger mode' || p_trigger_mode);
666: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,
667: p_new_lead_line_id ,
668: p_new_sales_credit_id ,
669: p_new_last_update_date ,
670: p_new_last_updated_by ,

Line 698: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,

694: FROM as_sales_credits_log
695: WHERE SALES_CREDIT_ID = p_old_sales_credit_id;
696:
697: IF (l_credit_count = 0) THEN
698: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,
699: p_new_lead_line_id ,
700: p_new_sales_credit_id ,
701: p_new_last_update_date ,
702: p_new_last_updated_by ,

Line 732: AS_SALES_CREDITS_LOG_PKG.Update_Row(p_new_lead_id ,

728: ( nvl(p_new_opp_frcst_amount, -10) <> nvl(p_old_opp_frcst_amount, -10) ) OR
729: ( nvl(p_new_opp_best_frcst_amount, -10) <> nvl(p_old_opp_best_frcst_amount, -10) ) )) THEN
730: IF( IsInsert = 0) THEN
731: -- dbms_output.put_line('Sales_Credits_Trigger_Handler ELSE Isinsert value' || IsInsert);
732: AS_SALES_CREDITS_LOG_PKG.Update_Row(p_new_lead_id ,
733: p_new_lead_line_id ,
734: p_old_sales_credit_id ,
735: p_old_last_update_date ,
736: p_new_last_update_date ,

Line 756: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,

752: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
753: 'asxopadb: Sales credit Update Log: Lead_line_id '||p_old_sales_credit_id || ' and Last Update Date '|| p_old_last_update_date);
754: END IF;
755: ELSE
756: AS_SALES_CREDITS_LOG_PKG.Insert_Row(p_new_lead_id ,
757: p_new_lead_line_id ,
758: p_new_sales_credit_id ,
759: p_new_last_update_date ,
760: p_new_last_updated_by ,

Line 785: AS_SALES_CREDITS_LOG_PKG.Delete_Row(p_old_lead_id ,

781:
782: ELSIF( p_trigger_mode = 'ON-DELETE' ) THEN
783:
784: -- dbms_output.put_line('Sales_Credits_Trigger_Handler delete value');
785: AS_SALES_CREDITS_LOG_PKG.Delete_Row(p_old_lead_id ,
786: p_old_lead_line_id ,
787: p_old_sales_credit_id ,
788: p_old_last_update_date ,
789: p_old_last_updated_by ,