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_SALES_CREDITS

Line 605: p_new_lead_id IN as_sales_credits.lead_id%type,

601: END IF;
602: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
603: END Lead_Lines_Trigger_Handler;
604: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
605: p_new_lead_id IN as_sales_credits.lead_id%type,
606: p_old_lead_id IN as_sales_credits.lead_id%type,
607:
608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,

Line 606: p_old_lead_id IN as_sales_credits.lead_id%type,

602: FND_MSG_PUB.Add_Exc_Msg('AS_LEADS_AUDIT_PKG', 'Lead_Lines_Trigger_Handler');
603: END Lead_Lines_Trigger_Handler;
604: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
605: p_new_lead_id IN as_sales_credits.lead_id%type,
606: p_old_lead_id IN as_sales_credits.lead_id%type,
607:
608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
610:

Line 608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,

604: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
605: p_new_lead_id IN as_sales_credits.lead_id%type,
606: p_old_lead_id IN as_sales_credits.lead_id%type,
607:
608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
610:
611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,

Line 609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,

605: p_new_lead_id IN as_sales_credits.lead_id%type,
606: p_old_lead_id IN as_sales_credits.lead_id%type,
607:
608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
610:
611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
613:

Line 611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,

607:
608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
610:
611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
613:
614: p_new_last_update_date IN as_sales_credits.last_update_date%type,
615: p_old_last_update_date IN as_sales_credits.last_update_date%type,

Line 612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,

608: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
609: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
610:
611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
613:
614: p_new_last_update_date IN as_sales_credits.last_update_date%type,
615: p_old_last_update_date IN as_sales_credits.last_update_date%type,
616:

Line 614: p_new_last_update_date IN as_sales_credits.last_update_date%type,

610:
611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
613:
614: p_new_last_update_date IN as_sales_credits.last_update_date%type,
615: p_old_last_update_date IN as_sales_credits.last_update_date%type,
616:
617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,

Line 615: p_old_last_update_date IN as_sales_credits.last_update_date%type,

611: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
612: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
613:
614: p_new_last_update_date IN as_sales_credits.last_update_date%type,
615: p_old_last_update_date IN as_sales_credits.last_update_date%type,
616:
617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
619:

Line 617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,

613:
614: p_new_last_update_date IN as_sales_credits.last_update_date%type,
615: p_old_last_update_date IN as_sales_credits.last_update_date%type,
616:
617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
619:
620: p_new_last_update_login IN as_sales_credits.last_update_login%type,
621: p_old_last_update_login IN as_sales_credits.last_update_login%type,

Line 618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,

614: p_new_last_update_date IN as_sales_credits.last_update_date%type,
615: p_old_last_update_date IN as_sales_credits.last_update_date%type,
616:
617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
619:
620: p_new_last_update_login IN as_sales_credits.last_update_login%type,
621: p_old_last_update_login IN as_sales_credits.last_update_login%type,
622:

Line 620: p_new_last_update_login IN as_sales_credits.last_update_login%type,

616:
617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
619:
620: p_new_last_update_login IN as_sales_credits.last_update_login%type,
621: p_old_last_update_login IN as_sales_credits.last_update_login%type,
622:
623: p_new_creation_date IN as_sales_credits.creation_date%type,
624: p_old_creation_date IN as_sales_credits.creation_date%type,

Line 621: p_old_last_update_login IN as_sales_credits.last_update_login%type,

617: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
618: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
619:
620: p_new_last_update_login IN as_sales_credits.last_update_login%type,
621: p_old_last_update_login IN as_sales_credits.last_update_login%type,
622:
623: p_new_creation_date IN as_sales_credits.creation_date%type,
624: p_old_creation_date IN as_sales_credits.creation_date%type,
625:

Line 623: p_new_creation_date IN as_sales_credits.creation_date%type,

619:
620: p_new_last_update_login IN as_sales_credits.last_update_login%type,
621: p_old_last_update_login IN as_sales_credits.last_update_login%type,
622:
623: p_new_creation_date IN as_sales_credits.creation_date%type,
624: p_old_creation_date IN as_sales_credits.creation_date%type,
625:
626: p_new_created_by IN as_sales_credits.created_by%type,
627: p_old_created_by IN as_sales_credits.created_by%type,

Line 624: p_old_creation_date IN as_sales_credits.creation_date%type,

620: p_new_last_update_login IN as_sales_credits.last_update_login%type,
621: p_old_last_update_login IN as_sales_credits.last_update_login%type,
622:
623: p_new_creation_date IN as_sales_credits.creation_date%type,
624: p_old_creation_date IN as_sales_credits.creation_date%type,
625:
626: p_new_created_by IN as_sales_credits.created_by%type,
627: p_old_created_by IN as_sales_credits.created_by%type,
628:

Line 626: p_new_created_by IN as_sales_credits.created_by%type,

622:
623: p_new_creation_date IN as_sales_credits.creation_date%type,
624: p_old_creation_date IN as_sales_credits.creation_date%type,
625:
626: p_new_created_by IN as_sales_credits.created_by%type,
627: p_old_created_by IN as_sales_credits.created_by%type,
628:
629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,

Line 627: p_old_created_by IN as_sales_credits.created_by%type,

623: p_new_creation_date IN as_sales_credits.creation_date%type,
624: p_old_creation_date IN as_sales_credits.creation_date%type,
625:
626: p_new_created_by IN as_sales_credits.created_by%type,
627: p_old_created_by IN as_sales_credits.created_by%type,
628:
629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,

Line 629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,

625:
626: p_new_created_by IN as_sales_credits.created_by%type,
627: p_old_created_by IN as_sales_credits.created_by%type,
628:
629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,

Line 630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,

626: p_new_created_by IN as_sales_credits.created_by%type,
627: p_old_created_by IN as_sales_credits.created_by%type,
628:
629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,

Line 631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,

627: p_old_created_by IN as_sales_credits.created_by%type,
628:
629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,

Line 632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,

628:
629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,

Line 633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,

629: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,

Line 634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,

630: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,

Line 635: p_new_credit_percent IN as_sales_credits.credit_percent%type,

631: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

Line 636: p_old_credit_percent IN as_sales_credits.credit_percent%type,

632: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

Line 637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,

633: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

Line 638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,

634: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

Line 639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

635: p_new_credit_percent IN as_sales_credits.credit_percent%type,
636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,

Line 640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

636: p_old_credit_percent IN as_sales_credits.credit_percent%type,
637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)

Line 641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

637: p_new_credit_amount IN as_sales_credits.credit_amount%type ,
638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)
645: IS

Line 642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

638: p_old_credit_amount IN as_sales_credits.credit_amount%type ,
639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)
645: IS
646: today_date Date;

Line 643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,

639: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)
645: IS
646: today_date Date;
647: IsInsert NUMBER :=0;

Line 644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)

640: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
641: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
642: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
643: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
644: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type)
645: IS
646: today_date Date;
647: IsInsert NUMBER :=0;
648: l_debug CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 658: update as_sales_credits_log

654: l_new_last_update_date := sysdate;
655: END IF;
656:
657: -- dbms_output.put_line('After calling Sales_Credits_Trigger_Handler');
658: update as_sales_credits_log
659: set object_version_number = nvl(object_version_number,0) + 1,
660: endday_log_flag = decode (trunc(l_new_last_update_date), trunc (p_old_last_update_date), 'N', 'Y')
661: where sales_credit_id = p_old_sales_credit_id
662: and last_update_date = p_old_last_update_date;

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 694: FROM as_sales_credits_log

690: GET_VALUE(p_old_last_update_date, p_new_last_update_date,IsInsert);
691: -- dbms_output.put_line('Sales_Credits_Trigger_Handler IF Isinsert value' || IsInsert);
692:
693: SELECT COUNT(*) INTO l_credit_count
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 ,

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 ,