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.HZ_DUP_PVT dependencies on HZ_UTILITY_V2PUB

Line 521: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

517: ,p_score => l_score
518: ,p_merge_seq_id => l_merge_seq_id
519: ,p_merge_batch_id => l_merge_batch_id
520: ,p_merge_batch_name => l_merge_batch_name
521: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
522: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
523: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
524: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
525: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 522: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

518: ,p_merge_seq_id => l_merge_seq_id
519: ,p_merge_batch_id => l_merge_batch_id
520: ,p_merge_batch_name => l_merge_batch_name
521: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
522: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
523: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
524: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
525: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
526: );

Line 523: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

519: ,p_merge_batch_id => l_merge_batch_id
520: ,p_merge_batch_name => l_merge_batch_name
521: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
522: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
523: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
524: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
525: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
526: );
527:

Line 524: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

520: ,p_merge_batch_name => l_merge_batch_name
521: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
522: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
523: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
524: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
525: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
526: );
527:
528: EXCEPTION

Line 525: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

521: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
522: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
523: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
524: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
525: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
526: );
527:
528: EXCEPTION
529:

Line 645: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

641: ,p_dup_batch_name => p_dup_batch_rec.dup_batch_name
642: ,p_match_rule_id => p_dup_batch_rec.match_rule_id
643: ,p_application_id => p_dup_batch_rec.application_id
644: ,p_request_type => p_dup_batch_rec.request_type
645: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
646: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
647: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
648: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
649: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 646: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

642: ,p_match_rule_id => p_dup_batch_rec.match_rule_id
643: ,p_application_id => p_dup_batch_rec.application_id
644: ,p_request_type => p_dup_batch_rec.request_type
645: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
646: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
647: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
648: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
649: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
650: );

Line 647: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

643: ,p_application_id => p_dup_batch_rec.application_id
644: ,p_request_type => p_dup_batch_rec.request_type
645: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
646: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
647: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
648: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
649: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
650: );
651:

Line 648: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

644: ,p_request_type => p_dup_batch_rec.request_type
645: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
646: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
647: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
648: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
649: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
650: );
651:
652: x_dup_batch_id := l_dup_batch_id;

Line 649: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

645: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
646: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
647: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
648: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
649: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
650: );
651:
652: x_dup_batch_id := l_dup_batch_id;
653:

Line 662: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

658: ,p_status => 'SYSBATCH'
659: ,p_assigned_to_user_id => p_dup_set_rec.assigned_to_user_id
660: ,p_merge_type => p_dup_set_rec.merge_type
661: ,p_object_version_number => 1
662: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
663: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
664: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
665: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
666: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 663: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

659: ,p_assigned_to_user_id => p_dup_set_rec.assigned_to_user_id
660: ,p_merge_type => p_dup_set_rec.merge_type
661: ,p_object_version_number => 1
662: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
663: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
664: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
665: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
666: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
667: );

Line 664: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

660: ,p_merge_type => p_dup_set_rec.merge_type
661: ,p_object_version_number => 1
662: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
663: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
664: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
665: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
666: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
667: );
668:

Line 665: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

661: ,p_object_version_number => 1
662: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
663: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
664: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
665: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
666: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
667: );
668:
669: x_dup_set_id := l_dup_set_id;

Line 666: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

662: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
663: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
664: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
665: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
666: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
667: );
668:
669: x_dup_set_id := l_dup_set_id;
670:

Line 682: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

678: ,p_score => p_dup_party_tbl(i).score
679: ,p_merge_seq_id => p_dup_party_tbl(i).merge_seq_id
680: ,p_merge_batch_id => p_dup_party_tbl(i).merge_batch_id
681: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
682: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
683: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
684: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
685: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
686: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 683: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

679: ,p_merge_seq_id => p_dup_party_tbl(i).merge_seq_id
680: ,p_merge_batch_id => p_dup_party_tbl(i).merge_batch_id
681: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
682: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
683: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
684: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
685: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
686: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
687: );

Line 684: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

680: ,p_merge_batch_id => p_dup_party_tbl(i).merge_batch_id
681: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
682: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
683: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
684: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
685: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
686: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
687: );
688: END LOOP;

Line 685: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

681: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
682: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
683: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
684: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
685: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
686: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
687: );
688: END LOOP;
689:

Line 686: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

682: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
683: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
684: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
685: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
686: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
687: );
688: END LOOP;
689:
690: EXCEPTION

Line 781: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

777: ,p_status => 'SYSBATCH'
778: ,p_assigned_to_user_id => p_dup_set_rec.assigned_to_user_id
779: ,p_merge_type => p_dup_set_rec.merge_type
780: ,p_object_version_number => 1
781: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
782: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
783: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
784: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
785: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 782: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

778: ,p_assigned_to_user_id => p_dup_set_rec.assigned_to_user_id
779: ,p_merge_type => p_dup_set_rec.merge_type
780: ,p_object_version_number => 1
781: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
782: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
783: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
784: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
785: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
786: );

Line 783: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

779: ,p_merge_type => p_dup_set_rec.merge_type
780: ,p_object_version_number => 1
781: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
782: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
783: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
784: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
785: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
786: );
787:

Line 784: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

780: ,p_object_version_number => 1
781: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
782: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
783: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
784: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
785: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
786: );
787:
788: x_dup_set_id := l_dup_set_id;

Line 785: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

781: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
782: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
783: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
784: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
785: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
786: );
787:
788: x_dup_set_id := l_dup_set_id;
789:

Line 801: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

797: ,p_score => p_dup_party_tbl(i).score
798: ,p_merge_seq_id => p_dup_party_tbl(i).merge_seq_id
799: ,p_merge_batch_id => p_dup_party_tbl(i).merge_batch_id
800: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
801: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
802: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
803: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
804: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
805: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 802: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

798: ,p_merge_seq_id => p_dup_party_tbl(i).merge_seq_id
799: ,p_merge_batch_id => p_dup_party_tbl(i).merge_batch_id
800: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
801: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
802: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
803: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
804: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
805: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
806: );

Line 803: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

799: ,p_merge_batch_id => p_dup_party_tbl(i).merge_batch_id
800: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
801: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
802: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
803: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
804: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
805: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
806: );
807: END LOOP;

Line 804: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

800: ,p_merge_batch_name => p_dup_party_tbl(i).merge_batch_name
801: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
802: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
803: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
804: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
805: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
806: );
807: END LOOP;
808:

Line 805: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

801: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
802: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
803: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
804: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
805: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
806: );
807: END LOOP;
808:
809: EXCEPTION

Line 916: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

912:
913: -- Update old winner party. Set merge_flag = 'Y'
914: UPDATE HZ_DUP_SET_PARTIES
915: SET merge_flag = 'Y'
916: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
917: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
918: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
919: WHERE dup_party_id = l_old_winner_party_id
920: AND dup_set_id = p_dup_set_id;

Line 917: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

913: -- Update old winner party. Set merge_flag = 'Y'
914: UPDATE HZ_DUP_SET_PARTIES
915: SET merge_flag = 'Y'
916: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
917: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
918: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
919: WHERE dup_party_id = l_old_winner_party_id
920: AND dup_set_id = p_dup_set_id;
921:

Line 918: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

914: UPDATE HZ_DUP_SET_PARTIES
915: SET merge_flag = 'Y'
916: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
917: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
918: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
919: WHERE dup_party_id = l_old_winner_party_id
920: AND dup_set_id = p_dup_set_id;
921:
922: -- no need to set the merge flag back to NULL for master party

Line 924: SET last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

920: AND dup_set_id = p_dup_set_id;
921:
922: -- no need to set the merge flag back to NULL for master party
923: UPDATE HZ_DUP_SET_PARTIES
924: SET last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
925: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
926: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
927: WHERE dup_party_id = p_winner_party_id
928: AND dup_set_id = p_dup_set_id;

Line 925: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

921:
922: -- no need to set the merge flag back to NULL for master party
923: UPDATE HZ_DUP_SET_PARTIES
924: SET last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
925: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
926: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
927: WHERE dup_party_id = p_winner_party_id
928: AND dup_set_id = p_dup_set_id;
929:

Line 926: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

922: -- no need to set the merge flag back to NULL for master party
923: UPDATE HZ_DUP_SET_PARTIES
924: SET last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
925: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
926: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
927: WHERE dup_party_id = p_winner_party_id
928: AND dup_set_id = p_dup_set_id;
929:
930: BEGIN

Line 953: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

949: -- status to 'PREPROCESS' when successfully call conc request
950:
951: UPDATE HZ_DUP_SETS
952: SET winner_party_id = p_winner_party_id
953: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
954: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
955: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
956: , object_version_number = px_set_obj_version_number
957: WHERE dup_set_id = p_dup_set_id;

Line 954: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

950:
951: UPDATE HZ_DUP_SETS
952: SET winner_party_id = p_winner_party_id
953: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
954: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
955: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
956: , object_version_number = px_set_obj_version_number
957: WHERE dup_set_id = p_dup_set_id;
958:

Line 955: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

951: UPDATE HZ_DUP_SETS
952: SET winner_party_id = p_winner_party_id
953: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
954: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
955: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
956: , object_version_number = px_set_obj_version_number
957: WHERE dup_set_id = p_dup_set_id;
958:
959: EXCEPTION

Line 1067: , last_update_date = hz_utility_v2pub.last_update_date

1063: CLOSE check_winner_party;
1064:
1065: UPDATE HZ_DUP_SETS
1066: set object_version_number = px_set_obj_version_number
1067: , last_update_date = hz_utility_v2pub.last_update_date
1068: , last_updated_by = hz_utility_v2pub.last_updated_by
1069: , last_update_login = hz_utility_v2pub.last_update_login
1070: where dup_set_id = p_dup_set_id;
1071:

Line 1068: , last_updated_by = hz_utility_v2pub.last_updated_by

1064:
1065: UPDATE HZ_DUP_SETS
1066: set object_version_number = px_set_obj_version_number
1067: , last_update_date = hz_utility_v2pub.last_update_date
1068: , last_updated_by = hz_utility_v2pub.last_updated_by
1069: , last_update_login = hz_utility_v2pub.last_update_login
1070: where dup_set_id = p_dup_set_id;
1071:
1072: -- remove dup party

Line 1069: , last_update_login = hz_utility_v2pub.last_update_login

1065: UPDATE HZ_DUP_SETS
1066: set object_version_number = px_set_obj_version_number
1067: , last_update_date = hz_utility_v2pub.last_update_date
1068: , last_updated_by = hz_utility_v2pub.last_updated_by
1069: , last_update_login = hz_utility_v2pub.last_update_login
1070: where dup_set_id = p_dup_set_id;
1071:
1072: -- remove dup party
1073: UPDATE HZ_DUP_SET_PARTIES

Line 1075: , last_update_date = hz_utility_v2pub.last_update_date

1071:
1072: -- remove dup party
1073: UPDATE HZ_DUP_SET_PARTIES
1074: SET merge_flag = 'N'
1075: , last_update_date = hz_utility_v2pub.last_update_date
1076: , last_updated_by = hz_utility_v2pub.last_updated_by
1077: , last_update_login = hz_utility_v2pub.last_update_login
1078: WHERE dup_set_id = p_dup_set_id
1079: AND dup_party_id = p_dup_party_id;

Line 1076: , last_updated_by = hz_utility_v2pub.last_updated_by

1072: -- remove dup party
1073: UPDATE HZ_DUP_SET_PARTIES
1074: SET merge_flag = 'N'
1075: , last_update_date = hz_utility_v2pub.last_update_date
1076: , last_updated_by = hz_utility_v2pub.last_updated_by
1077: , last_update_login = hz_utility_v2pub.last_update_login
1078: WHERE dup_set_id = p_dup_set_id
1079: AND dup_party_id = p_dup_party_id;
1080:

Line 1077: , last_update_login = hz_utility_v2pub.last_update_login

1073: UPDATE HZ_DUP_SET_PARTIES
1074: SET merge_flag = 'N'
1075: , last_update_date = hz_utility_v2pub.last_update_date
1076: , last_updated_by = hz_utility_v2pub.last_updated_by
1077: , last_update_login = hz_utility_v2pub.last_update_login
1078: WHERE dup_set_id = p_dup_set_id
1079: AND dup_party_id = p_dup_party_id;
1080:
1081: ELSE

Line 1110: , last_update_date = hz_utility_v2pub.last_update_date

1106:
1107: UPDATE HZ_DUP_SETS
1108: set winner_party_id = p_new_winner_party_id
1109: , object_version_number = px_set_obj_version_number
1110: , last_update_date = hz_utility_v2pub.last_update_date
1111: , last_updated_by = hz_utility_v2pub.last_updated_by
1112: , last_update_login = hz_utility_v2pub.last_update_login
1113: where dup_set_id = p_dup_set_id;
1114:

Line 1111: , last_updated_by = hz_utility_v2pub.last_updated_by

1107: UPDATE HZ_DUP_SETS
1108: set winner_party_id = p_new_winner_party_id
1109: , object_version_number = px_set_obj_version_number
1110: , last_update_date = hz_utility_v2pub.last_update_date
1111: , last_updated_by = hz_utility_v2pub.last_updated_by
1112: , last_update_login = hz_utility_v2pub.last_update_login
1113: where dup_set_id = p_dup_set_id;
1114:
1115: UPDATE HZ_DUP_SET_PARTIES

Line 1112: , last_update_login = hz_utility_v2pub.last_update_login

1108: set winner_party_id = p_new_winner_party_id
1109: , object_version_number = px_set_obj_version_number
1110: , last_update_date = hz_utility_v2pub.last_update_date
1111: , last_updated_by = hz_utility_v2pub.last_updated_by
1112: , last_update_login = hz_utility_v2pub.last_update_login
1113: where dup_set_id = p_dup_set_id;
1114:
1115: UPDATE HZ_DUP_SET_PARTIES
1116: SET merge_flag = 'N'

Line 1117: , last_update_date = hz_utility_v2pub.last_update_date

1113: where dup_set_id = p_dup_set_id;
1114:
1115: UPDATE HZ_DUP_SET_PARTIES
1116: SET merge_flag = 'N'
1117: , last_update_date = hz_utility_v2pub.last_update_date
1118: , last_updated_by = hz_utility_v2pub.last_updated_by
1119: , last_update_login = hz_utility_v2pub.last_update_login
1120: WHERE dup_set_id = p_dup_set_id
1121: AND dup_party_id = p_dup_party_id;

Line 1118: , last_updated_by = hz_utility_v2pub.last_updated_by

1114:
1115: UPDATE HZ_DUP_SET_PARTIES
1116: SET merge_flag = 'N'
1117: , last_update_date = hz_utility_v2pub.last_update_date
1118: , last_updated_by = hz_utility_v2pub.last_updated_by
1119: , last_update_login = hz_utility_v2pub.last_update_login
1120: WHERE dup_set_id = p_dup_set_id
1121: AND dup_party_id = p_dup_party_id;
1122:

Line 1119: , last_update_login = hz_utility_v2pub.last_update_login

1115: UPDATE HZ_DUP_SET_PARTIES
1116: SET merge_flag = 'N'
1117: , last_update_date = hz_utility_v2pub.last_update_date
1118: , last_updated_by = hz_utility_v2pub.last_updated_by
1119: , last_update_login = hz_utility_v2pub.last_update_login
1120: WHERE dup_set_id = p_dup_set_id
1121: AND dup_party_id = p_dup_party_id;
1122:
1123: END IF;

Line 1261: , last_update_date = hz_utility_v2pub.last_update_date

1257: BEGIN
1258: UPDATE HZ_DUP_SETS
1259: set merge_type = 'SAME_PARTY_MERGE'
1260: , object_version_number = px_set_obj_version_number
1261: , last_update_date = hz_utility_v2pub.last_update_date
1262: , last_updated_by = hz_utility_v2pub.last_updated_by
1263: , last_update_login = hz_utility_v2pub.last_update_login
1264: where dup_set_id = p_dup_set_id;
1265:

Line 1262: , last_updated_by = hz_utility_v2pub.last_updated_by

1258: UPDATE HZ_DUP_SETS
1259: set merge_type = 'SAME_PARTY_MERGE'
1260: , object_version_number = px_set_obj_version_number
1261: , last_update_date = hz_utility_v2pub.last_update_date
1262: , last_updated_by = hz_utility_v2pub.last_updated_by
1263: , last_update_login = hz_utility_v2pub.last_update_login
1264: where dup_set_id = p_dup_set_id;
1265:
1266: DELETE HZ_DUP_SET_PARTIES

Line 1263: , last_update_login = hz_utility_v2pub.last_update_login

1259: set merge_type = 'SAME_PARTY_MERGE'
1260: , object_version_number = px_set_obj_version_number
1261: , last_update_date = hz_utility_v2pub.last_update_date
1262: , last_updated_by = hz_utility_v2pub.last_updated_by
1263: , last_update_login = hz_utility_v2pub.last_update_login
1264: where dup_set_id = p_dup_set_id;
1265:
1266: DELETE HZ_DUP_SET_PARTIES
1267: where dup_party_id not in

Line 1375: , last_update_date = hz_utility_v2pub.last_update_date

1371:
1372: UPDATE HZ_DUP_SETS
1373: set status = 'REJECTED'
1374: , object_version_number = px_set_obj_version_number
1375: , last_update_date = hz_utility_v2pub.last_update_date
1376: , last_updated_by = hz_utility_v2pub.last_updated_by
1377: , last_update_login = hz_utility_v2pub.last_update_login
1378: where dup_set_id = p_dup_set_id;
1379:

Line 1376: , last_updated_by = hz_utility_v2pub.last_updated_by

1372: UPDATE HZ_DUP_SETS
1373: set status = 'REJECTED'
1374: , object_version_number = px_set_obj_version_number
1375: , last_update_date = hz_utility_v2pub.last_update_date
1376: , last_updated_by = hz_utility_v2pub.last_updated_by
1377: , last_update_login = hz_utility_v2pub.last_update_login
1378: where dup_set_id = p_dup_set_id;
1379:
1380: EXCEPTION

Line 1377: , last_update_login = hz_utility_v2pub.last_update_login

1373: set status = 'REJECTED'
1374: , object_version_number = px_set_obj_version_number
1375: , last_update_date = hz_utility_v2pub.last_update_date
1376: , last_updated_by = hz_utility_v2pub.last_updated_by
1377: , last_update_login = hz_utility_v2pub.last_update_login
1378: where dup_set_id = p_dup_set_id;
1379:
1380: EXCEPTION
1381:

Line 1443: and u.user_id = HZ_UTILITY_V2PUB.CREATED_BY

1439: and r.menu_id = mp.menu_id
1440: and mp.sub_menu_id = m.menu_id
1441: and m.sub_menu_id = mv.menu_id
1442: and mv.menu_name = 'IMC_NG_DATA_QUALITY'
1443: and u.user_id = HZ_UTILITY_V2PUB.CREATED_BY
1444: and not exists (
1445: select 'X'
1446: from FND_RESP_FUNCTIONS rf, FND_MENUS m
1447: where rf.action_id = m.menu_id

Line 1465: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

1461: then
1462:
1463: UPDATE HZ_DUP_SETS
1464: SET assigned_to_user_id = l_user_id
1465: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1466: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1467: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1468: , object_version_number = object_version_number+1
1469: WHERE dup_set_id = p_dup_set_id;

Line 1466: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

1462:
1463: UPDATE HZ_DUP_SETS
1464: SET assigned_to_user_id = l_user_id
1465: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1466: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1467: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1468: , object_version_number = object_version_number+1
1469: WHERE dup_set_id = p_dup_set_id;
1470: end if;

Line 1467: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1463: UPDATE HZ_DUP_SETS
1464: SET assigned_to_user_id = l_user_id
1465: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1466: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1467: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1468: , object_version_number = object_version_number+1
1469: WHERE dup_set_id = p_dup_set_id;
1470: end if;
1471:

Line 1536: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1532: IF l_request_id is not null Then
1533: UPDATE HZ_DUP_SETS
1534: SET status = 'PREPROCESS',
1535: request_id = l_request_id,
1536: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1538: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1539: WHERE dup_set_id = p_dup_set_id;
1540: END IF;

Line 1537: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1533: UPDATE HZ_DUP_SETS
1534: SET status = 'PREPROCESS',
1535: request_id = l_request_id,
1536: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1538: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1539: WHERE dup_set_id = p_dup_set_id;
1540: END IF;
1541:

Line 1538: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1534: SET status = 'PREPROCESS',
1535: request_id = l_request_id,
1536: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1538: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1539: WHERE dup_set_id = p_dup_set_id;
1540: END IF;
1541:
1542: ELSE --if completed normally

Line 1562: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1558: IF l_request_id is not null Then
1559: UPDATE HZ_DUP_SETS
1560: SET status = 'PREPROCESS',
1561: request_id = l_request_id,
1562: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1563: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1564: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1565: WHERE dup_set_id = p_dup_set_id;
1566: END IF;

Line 1563: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1559: UPDATE HZ_DUP_SETS
1560: SET status = 'PREPROCESS',
1561: request_id = l_request_id,
1562: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1563: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1564: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1565: WHERE dup_set_id = p_dup_set_id;
1566: END IF;
1567: END IF; ---last_request_id

Line 1564: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1560: SET status = 'PREPROCESS',
1561: request_id = l_request_id,
1562: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1563: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1564: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1565: WHERE dup_set_id = p_dup_set_id;
1566: END IF;
1567: END IF; ---last_request_id
1568:

Line 1642: SET REQUEST_ID = hz_utility_v2pub.request_id

1638: BEGIN
1639:
1640: -- Stamp concurrent request id to dup sets
1641: UPDATE HZ_DUP_SETS
1642: SET REQUEST_ID = hz_utility_v2pub.request_id
1643: WHERE dup_set_id = p_dup_set_id;
1644: COMMIT;
1645:
1646: savepoint create_merge_pvt;

Line 1744: , last_update_date = hz_utility_v2pub.last_update_date

1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF (l_return_status = 'S') THEN
1742: UPDATE HZ_DUP_SETS
1743: set status = 'REQUESTED'
1744: , last_update_date = hz_utility_v2pub.last_update_date
1745: , last_updated_by = hz_utility_v2pub.last_updated_by
1746: , last_update_login = hz_utility_v2pub.last_update_login
1747: where dup_set_id = l_dup_set_id;
1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 1745: , last_updated_by = hz_utility_v2pub.last_updated_by

1741: ELSIF (l_return_status = 'S') THEN
1742: UPDATE HZ_DUP_SETS
1743: set status = 'REQUESTED'
1744: , last_update_date = hz_utility_v2pub.last_update_date
1745: , last_updated_by = hz_utility_v2pub.last_updated_by
1746: , last_update_login = hz_utility_v2pub.last_update_login
1747: where dup_set_id = l_dup_set_id;
1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1749: FND_FILE.PUT_LINE (FND_FILE.LOG, 'call create_merge_batch without error. ');

Line 1746: , last_update_login = hz_utility_v2pub.last_update_login

1742: UPDATE HZ_DUP_SETS
1743: set status = 'REQUESTED'
1744: , last_update_date = hz_utility_v2pub.last_update_date
1745: , last_updated_by = hz_utility_v2pub.last_updated_by
1746: , last_update_login = hz_utility_v2pub.last_update_login
1747: where dup_set_id = l_dup_set_id;
1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1749: FND_FILE.PUT_LINE (FND_FILE.LOG, 'call create_merge_batch without error. ');
1750: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');