APPS.IGS_AD_IMP_009 dependencies on IGS_PE_PERSON

Line 93: l_person_id igs_pe_person.person_id%TYPE;

89:
90: i NUMBER(3):=0;
91: l_rowid VARCHAR2(25);
92: l_pk NUMBER(15);
93: l_person_id igs_pe_person.person_id%TYPE;
94: l_errbuf VARCHAR2(10);
95: l_retcode NUMBER;
96:
97: l_cursor_id NUMBER(15);

Line 358: l_person_id igs_pe_person.person_id%TYPE;

354: x_lvcPartialSelectClause VARCHAR2(32000);
355: x_match_cnt NUMBER := 0;
356: l_errbuf VARCHAR2(10);
357: l_retcode NUMBER;
358: l_person_id igs_pe_person.person_id%TYPE;
359: i NUMBER(3):=0;
360: l_rowid VARCHAR2(25);
361: l_pk NUMBER(15);
362:

Line 637: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,

633: AND
634: ( addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y');
635:
636:
637: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
638: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS
639: SELECT PS.party_site_id
640: FROM hz_party_sites PS,hz_party_site_uses PSU
641: WHERE PS.party_site_id = PSU.party_site_id AND

Line 645: CURSOR prim_party_site_cur(cp_person_id igs_pe_person.person_id%TYPE) IS

641: WHERE PS.party_site_id = PSU.party_site_id AND
642: PS.party_id = cp_person_id AND
643: PSU.site_use_type = cp_addr_type;
644:
645: CURSOR prim_party_site_cur(cp_person_id igs_pe_person.person_id%TYPE) IS
646: SELECT PS.party_site_id
647: FROM hz_party_sites PS
648: WHERE PS.party_id = cp_person_id AND
649: PS.identifying_address_flag = 'Y';

Line 656: l_person_id igs_pe_person.person_id%TYPE;

652: x_lvcPartialSelectClause VARCHAR2(32000);
653: x_match_cnt NUMBER := 0;
654: l_errbuf VARCHAR2(10);
655: l_retcode NUMBER;
656: l_person_id igs_pe_person.person_id%TYPE;
657: i NUMBER(3):=0;
658: l_rowid VARCHAR2(25);
659: l_pk NUMBER(15);
660:

Line 988: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,

984: AND (addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y')
985: AND (person_id_type = cp_c_person_id_type OR person_id_type IS NULL);
986:
987:
988: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
989: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS
990: SELECT PS.party_site_id
991: FROM hz_party_sites PS,hz_party_site_uses PSU
992: WHERE PS.party_site_id = PSU.party_site_id AND

Line 996: CURSOR prim_party_site_cur(cp_person_id igs_pe_person.person_id%TYPE) IS

992: WHERE PS.party_site_id = PSU.party_site_id AND
993: PS.party_id = cp_person_id AND
994: PSU.site_use_type = cp_addr_type;
995:
996: CURSOR prim_party_site_cur(cp_person_id igs_pe_person.person_id%TYPE) IS
997: SELECT PS.party_site_id
998: FROM hz_party_sites PS
999: WHERE PS.party_id = cp_person_id AND
1000: PS.identifying_address_flag = 'Y';

Line 1007: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

1003: l_errbuf VARCHAR2(10);
1004: l_retcode NUMBER;
1005: x_lvcExactSelectClause VARCHAR2(32000);
1006: x_lvcPartialSelectClause VARCHAR2(32000);
1007: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
1008: i NUMBER(3):=0;
1009: l_rowid VARCHAR2(25);
1010: l_pk NUMBER(15);
1011: