DBA Data[Home] [Help]

APPS.IGS_PE_GEN_004 dependencies on IGS_PE_EIT_PKG

Line 423: igs_pe_eit_pkg.update_row (

419:
420: IF l_return_status IS NULL OR l_return_status = 'S' THEN
421: FOR active_permres_rec IN active_permres_cur(p_person_id, l_per_country_code) LOOP
422:
423: igs_pe_eit_pkg.update_row (
424: X_ROWID => active_permres_rec.rowid,
425: X_PE_EIT_ID => active_permres_rec.pe_eit_id,
426: X_PERSON_ID => p_person_id,
427: X_INFORMATION_TYPE => 'PE_INT_PERM_RES',

Line 547: igs_pe_eit_pkg.insert_row (

543: CLOSE permres_cur;
544:
545: IF permres_rec.pe_eit_id IS NULL THEN
546:
547: igs_pe_eit_pkg.insert_row (
548: X_ROWID => l_rowid,
549: X_PE_EIT_ID => l_pe_eit_id,
550: X_PERSON_ID => p_person_id,
551: X_INFORMATION_TYPE => 'PE_INT_PERM_RES',

Line 562: igs_pe_eit_pkg.update_row (

558: X_END_DATE => NULL
559: );
560:
561: ELSE
562: igs_pe_eit_pkg.update_row (
563: X_ROWID => permres_rec.rowid,
564: X_PE_EIT_ID => permres_rec.pe_eit_id,
565: X_PERSON_ID => p_person_id,
566: X_INFORMATION_TYPE => 'PE_INT_PERM_RES',

Line 580: igs_pe_eit_pkg.update_row (

576: END IF;
577:
578: FOR oth_active_permres_rec IN oth_active_permres_cur(p_person_id, l_per_country_code) LOOP
579:
580: igs_pe_eit_pkg.update_row (
581: X_ROWID => oth_active_permres_rec.rowid,
582: X_PE_EIT_ID => oth_active_permres_rec.pe_eit_id,
583: X_PERSON_ID => p_person_id,
584: X_INFORMATION_TYPE => 'PE_INT_PERM_RES',

Line 605: igs_pe_eit_pkg.update_row (

601: ELSIF P_PERM_RES = 'N' THEN
602:
603: FOR active_permres_rec IN active_permres_cur(p_person_id, l_per_country_code) LOOP
604:
605: igs_pe_eit_pkg.update_row (
606: X_ROWID => active_permres_rec.rowid,
607: X_PE_EIT_ID => active_permres_rec.pe_eit_id,
608: X_PERSON_ID => p_person_id,
609: X_INFORMATION_TYPE => 'PE_INT_PERM_RES',