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.IGS_PE_IDENTIFY_DUPS dependencies on IGS_PE_IDENTIFY_DUPS

Line 1: PACKAGE BODY Igs_Pe_Identify_Dups AS

1: PACKAGE BODY Igs_Pe_Identify_Dups AS
2: /* $Header: IGSPE03B.pls 120.0 2005/06/01 15:41:13 appldev noship $ */
3:
4: /*
5: || Created By : prabhat.patel

Line 209: IF Igs_Pe_Identify_Dups.g_exclude_inactive_ind = 'Y' THEN

205: fnd_dsql.add_bind(l_surname);
206: fnd_dsql.add_text(' AND UPPER(SUBSTR(given_names,1,1)) = ');
207: fnd_dsql.add_bind(l_given_name_1_char);
208:
209: IF Igs_Pe_Identify_Dups.g_exclude_inactive_ind = 'Y' THEN
210: fnd_dsql.add_text(' AND STATUS = ');
211: fnd_dsql.add_bind('A');
212: END IF;
213:

Line 558: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

554: ELSIF g_matchset_partial(i).data_element = 'CONC_ADDR_LINES' THEN
555: IF l_conct_address_lines IS NULL THEN
556: IF g_matchset_partial(i).drop_if_null = 'N' THEN
557: fnd_dsql.add_text(' OR (conct_address_lines IS NULL');
558: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
559: fnd_dsql.add_text(' AND addr_type = ');
560: fnd_dsql.add_bind(l_addr_type);
561: END IF;
562: fnd_dsql.add_text(')');

Line 567: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

563: END IF;
564: ELSE
565: fnd_dsql.add_text(' OR ( UPPER(conct_address_lines) = ');
566: fnd_dsql.add_bind(l_conct_address_lines);
567: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
568: fnd_dsql.add_text(' AND addr_type = ');
569: fnd_dsql.add_bind(l_addr_type);
570: END IF;
571: fnd_dsql.add_text(')');

Line 578: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

574: ELSIF g_matchset_partial(i).data_element = 'ADDR_LINE_1' THEN
575: IF x_addr_line_1 IS NULL THEN
576: IF g_matchset_partial(i).drop_if_null = 'N' THEN
577: fnd_dsql.add_text(' OR ( addr_line_1 IS NULL ');
578: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
579: fnd_dsql.add_text(' AND addr_type = ');
580: fnd_dsql.add_bind(l_addr_type);
581: END IF;
582: fnd_dsql.add_text(')');

Line 587: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

583: END IF;
584: ELSE
585: fnd_dsql.add_text(' OR ( UPPER(addr_line_1) = ');
586: fnd_dsql.add_bind(l_addr_line_1);
587: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
588: fnd_dsql.add_text(' AND addr_type = ');
589: fnd_dsql.add_bind(l_addr_type);
590: END IF;
591: fnd_dsql.add_text(')');

Line 598: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

594: ELSIF g_matchset_partial(i).data_element = 'ADDR_LINE_2' THEN
595: IF x_addr_line_2 IS NULL THEN
596: IF g_matchset_partial(i).drop_if_null = 'N' THEN
597: fnd_dsql.add_text(' OR ( addr_line_2 IS NULL');
598: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
599: fnd_dsql.add_text (' AND addr_type = ');
600: fnd_dsql.add_bind(l_addr_type);
601: END IF;
602: fnd_dsql.add_text (' ) ');

Line 607: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

603: END IF;
604: ELSE
605: fnd_dsql.add_text(' OR ( UPPER(addr_line_2) = ');
606: fnd_dsql.add_bind(l_addr_line_2);
607: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
608: fnd_dsql.add_text(' AND addr_type = ');
609: fnd_dsql.add_bind(l_addr_type);
610: END IF;
611: fnd_dsql.add_text(')');

Line 618: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

614: ELSIF g_matchset_partial(i).data_element = 'ADDR_LINE_3' THEN
615: IF x_addr_line_3 IS NULL THEN
616: IF g_matchset_partial(i).drop_if_null = 'N' THEN
617: fnd_dsql.add_text(' OR ( addr_line_3 IS NULL');
618: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
619: fnd_dsql.add_text (' AND addr_type = ');
620: fnd_dsql.add_bind(l_addr_type);
621: END IF;
622: fnd_dsql.add_text (' ) ');

Line 627: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

623: END IF;
624: ELSE
625: fnd_dsql.add_text(' OR ( UPPER(addr_line_3) = ');
626: fnd_dsql.add_bind(l_addr_line_3);
627: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
628: fnd_dsql.add_text(' AND addr_type = ');
629: fnd_dsql.add_bind(l_addr_type);
630: END IF;
631: fnd_dsql.add_text(')');

Line 638: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

634: ELSIF g_matchset_partial(i).data_element = 'ADDR_LINE_4' THEN
635: IF x_addr_line_4 IS NULL THEN
636: IF g_matchset_partial(i).drop_if_null = 'N' THEN
637: fnd_dsql.add_text(' OR ( addr_line_4 IS NULL');
638: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
639: fnd_dsql.add_text(' AND addr_type = ');
640: fnd_dsql.add_bind(l_addr_type);
641: END IF;
642: fnd_dsql.add_text(')');

Line 647: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

643: END IF;
644: ELSE
645: fnd_dsql.add_text(' OR ( UPPER(addr_line_4) = ');
646: fnd_dsql.add_bind(l_addr_line_4);
647: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
648: fnd_dsql.add_text(' AND addr_type = ');
649: fnd_dsql.add_bind(l_addr_type);
650: END IF;
651: fnd_dsql.add_text(')');

Line 658: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

654: ELSIF g_matchset_partial(i).data_element = 'CITY' THEN
655: IF x_city IS NULL THEN
656: IF g_matchset_partial(i).drop_if_null = 'N' THEN
657: fnd_dsql.add_text(' OR ( city IS NULL');
658: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
659: fnd_dsql.add_text(' AND addr_type = ');
660: fnd_dsql.add_bind(l_addr_type);
661: END IF;
662: fnd_dsql.add_text(')');

Line 667: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

663: END IF;
664: ELSE
665: fnd_dsql.add_text(' OR ( UPPER(city) = ');
666: fnd_dsql.add_bind(l_city);
667: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
668: fnd_dsql.add_text(' AND addr_type = ');
669: fnd_dsql.add_bind(l_addr_type);
670: END IF;
671: fnd_dsql.add_text(')');

Line 678: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

674: ELSIF g_matchset_partial(i).data_element = 'STATE' THEN
675: IF x_state IS NULL THEN
676: IF g_matchset_partial(i).drop_if_null = 'N' THEN
677: fnd_dsql.add_text(' OR ( state IS NULL');
678: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
679: fnd_dsql.add_text(' AND addr_type = ');
680: fnd_dsql.add_bind(l_addr_type);
681: END IF;
682: fnd_dsql.add_text(')');

Line 687: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

683: END IF;
684: ELSE
685: fnd_dsql.add_text(' OR ( UPPER(state) = ');
686: fnd_dsql.add_bind(l_state);
687: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
688: fnd_dsql.add_text(' AND addr_type = ');
689: fnd_dsql.add_bind(l_addr_type);
690: END IF;
691: fnd_dsql.add_text(')');

Line 698: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

694: ELSIF g_matchset_partial(i).data_element = 'PROVINCE' THEN
695: IF x_province IS NULL THEN
696: IF g_matchset_partial(i).drop_if_null = 'N' THEN
697: fnd_dsql.add_text(' OR ( province IS NULL');
698: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
699: fnd_dsql.add_text(' AND addr_type = ');
700: fnd_dsql.add_bind(l_addr_type);
701: END IF;
702: fnd_dsql.add_text(')');

Line 707: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

703: END IF;
704: ELSE
705: fnd_dsql.add_text(' OR ( UPPER(province) = ');
706: fnd_dsql.add_bind(l_province);
707: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
708: fnd_dsql.add_text(' AND addr_type = ');
709: fnd_dsql.add_bind(l_addr_type);
710: END IF;
711: fnd_dsql.add_text(')');

Line 718: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

714: ELSIF g_matchset_partial(i).data_element = 'COUNTY' THEN
715: IF x_county IS NULL THEN
716: IF g_matchset_partial(i).drop_if_null = 'N' THEN
717: fnd_dsql.add_text(' OR ( county IS NULL');
718: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
719: fnd_dsql.add_text(' AND addr_type = ');
720: fnd_dsql.add_bind(l_addr_type);
721: END IF;
722: fnd_dsql.add_text(')');

Line 727: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

723: END IF;
724: ELSE
725: fnd_dsql.add_text(' OR ( UPPER(county) = ');
726: fnd_dsql.add_bind(l_county);
727: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
728: fnd_dsql.add_text(' AND addr_type = ');
729: fnd_dsql.add_bind(l_addr_type);
730: END IF;
731: fnd_dsql.add_text(')');

Line 738: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

734: ELSIF g_matchset_partial(i).data_element = 'COUNTRY' THEN
735: IF x_country IS NULL THEN
736: IF g_matchset_partial(i).drop_if_null = 'N' THEN
737: fnd_dsql.add_text(' OR (country IS NULL');
738: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
739: fnd_dsql.add_text(' AND addr_type = ');
740: fnd_dsql.add_bind(l_addr_type);
741: END IF;
742: fnd_dsql.add_text(')');

Line 747: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

743: END IF;
744: ELSE
745: fnd_dsql.add_text(' OR ( UPPER(country) = ');
746: fnd_dsql.add_bind(l_country);
747: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
748: fnd_dsql.add_text(' AND addr_type = ');
749: fnd_dsql.add_bind(l_addr_type);
750: END IF;
751: fnd_dsql.add_text(')');

Line 758: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

754: ELSIF g_matchset_partial(i).data_element = 'POSTCODE' THEN
755: IF x_postcode IS NULL THEN
756: IF g_matchset_partial(i).drop_if_null = 'N' THEN
757: fnd_dsql.add_text(' OR ( postcode IS NULL');
758: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
759: fnd_dsql.add_text(' AND addr_type = ');
760: fnd_dsql.add_bind(l_addr_type);
761: END IF;
762: fnd_dsql.add_text(')');

Line 767: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN

763: END IF;
764: ELSE
765: fnd_dsql.add_text(' OR ( UPPER(postcode) = ');
766: fnd_dsql.add_bind(l_postcode);
767: IF Igs_Pe_Identify_Dups.g_primary_addr_flag = 'N' THEN
768: fnd_dsql.add_text(' AND addr_type = ');
769: fnd_dsql.add_bind(l_addr_type);
770: END IF;
771: fnd_dsql.add_text(')');

Line 792: FND_MESSAGE.SET_TOKEN('NAME','igs_pe_identify_dups.form_dup_whereclause'||'-'||SQLERRM);

788: EXCEPTION
789: WHEN OTHERS THEN
790: x_retcode := '2';
791: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
792: FND_MESSAGE.SET_TOKEN('NAME','igs_pe_identify_dups.form_dup_whereclause'||'-'||SQLERRM);
793: APP_EXCEPTION.RAISE_EXCEPTION;
794: END;
795:
796: PROCEDURE Find_dup_rel_per(

Line 912: END Igs_Pe_Identify_Dups;

908:
909:
910: END Find_dup_rel_per;
911:
912: END Igs_Pe_Identify_Dups;