APPS.IGS_AD_GEN_002 dependencies on IGS_ST_GEN_003

Line 358: IGS_ST_GEN_003.stap_get_prsn_names(

354: FOR i IN 1..v_previous_name_records_cnt LOOP
355: r_previous_name_rec := t_previous_name(i);
356: FOR v_pe_rec IN c_pe(r_previous_name_rec.family_name) LOOP
357: -- Truncate name
358: IGS_ST_GEN_003.stap_get_prsn_names(
359: v_pe_rec.person_id,
360: v_db_given_name, -- out NOCOPY
361: v_other_names); -- out NOCOPY
362: IF (r_previous_name_rec.first_name IS NOT NULL OR

Line 418: IGS_ST_GEN_003.stap_get_prsn_names(

414: FOR v_pe_rec IN c_pe LOOP
415: -- We want to match the first given name from the database
416: -- against either given name provided in the file
417: -- Truncate name
418: IGS_ST_GEN_003.stap_get_prsn_names(
419: v_pe_rec.person_id,
420: v_db_given_name, -- out NOCOPY
421: v_other_names); -- out NOCOPY
422: IF (v_db_given_name = p_convert_first_name OR

Line 462: IGS_ST_GEN_003.stap_get_prsn_names(

458: FOR i IN 1..v_previous_name_records_cnt LOOP
459: r_previous_name_rec := t_previous_name(i);
460: FOR v_pe_rec IN c_pe(r_previous_name_rec.family_name) LOOP
461: -- Truncate name
462: IGS_ST_GEN_003.stap_get_prsn_names(
463: v_pe_rec.person_id,
464: v_db_given_name, -- out NOCOPY
465: v_other_names); -- out NOCOPY
466: IF (r_previous_name_rec.first_name IS NOT NULL OR

Line 524: IGS_ST_GEN_003.stap_get_prsn_names(

520: -- We want to match the first given name from
521: -- the database against either given name
522: -- provided in the file
523: -- Truncate name
524: IGS_ST_GEN_003.stap_get_prsn_names(
525: v_pe_rec.person_id,
526: v_db_given_name, -- out NOCOPY
527: v_other_names); -- out NOCOPY
528: IF (v_db_given_name = p_convert_first_name OR

Line 642: IGS_ST_GEN_003.stap_get_prsn_names(

638: FETCH c_pe INTO v_person_id;
639: IF (c_pe%FOUND) THEN
640: CLOSE c_pe;
641: -- Trancate name
642: IGS_ST_GEN_003.stap_get_prsn_names(
643: v_person_id,
644: v_db_given_name, -- out NOCOPY
645: v_other_names); -- out NOCOPY
646: IF (r_previous_name_rec.first_name IS NOT NULL OR

Line 711: IGS_ST_GEN_003.stap_get_prsn_names(

707: -- We want to match the first given name
708: -- from the database against either given
709: -- name provided in the file
710: -- Truncate given name
711: IGS_ST_GEN_003.stap_get_prsn_names(
712: v_person_id,
713: v_db_given_name, -- out NOCOPY
714: v_other_names); -- out NOCOPY
715: IF (v_db_given_name = p_convert_first_name OR

Line 764: IGS_ST_GEN_003.stap_get_prsn_names(

760: FETCH c_pe INTO v_person_id;
761: IF (c_pe%FOUND) THEN
762: CLOSE c_pe;
763: -- truncate name
764: IGS_ST_GEN_003.stap_get_prsn_names(
765: v_person_id,
766: v_db_given_name, -- out NOCOPY
767: v_other_names); -- out NOCOPY
768: IF (r_previous_name_rec.first_name IS NOT NULL OR

Line 834: IGS_ST_GEN_003.stap_get_prsn_names(

830: IF (c_pe%FOUND) THEN
831: CLOSE c_pe;
832: -- We want to match the first given name from the database
833: -- against either given name provided in the file
834: IGS_ST_GEN_003.stap_get_prsn_names(
835: v_person_id,
836: v_db_given_name, -- out NOCOPY
837: v_other_names); -- out NOCOPY
838: IF (v_db_given_name = p_convert_first_name OR