APPS.IGS_PE_GEN_004 dependencies on IGS_PE_CITIZENSHIPS_PKG

Line 351: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(

347: CLOSE ctzn_country_cur;
348:
349: IF ctzn_country_rec.citizenship_id IS NULL THEN
350:
351: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(
352: p_action => 'INSERT',
353: P_birth_or_selected => NULL,
354: P_country_code => l_fnd_country_code,
355: p_date_disowned => NULL,

Line 374: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(

370: ELSE -- citizenship_id is NULL
371:
372: IF ctzn_country_rec.end_date IS NOT NULL THEN
373:
374: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(
375: p_action => 'UPDATE',
376: P_birth_or_selected => NULL,
377: P_country_code => l_fnd_country_code,
378: p_date_disowned => NULL,

Line 399: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(

395:
396: IF l_return_status IS NULL OR l_return_status = 'S' THEN
397: FOR active_ctzn_rec IN active_ctzn_cur(p_person_id, l_fnd_country_code) LOOP
398:
399: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(
400: p_action => 'UPDATE',
401: P_birth_or_selected => active_ctzn_rec.birth_or_selected,
402: P_country_code => active_ctzn_rec.country_code,
403: p_date_disowned => NULL,

Line 458: igs_pe_citizenships_pkg.citizenship(

454: CLOSE ctzn_country_cur;
455:
456: IF ctzn_country_rec.citizenship_id IS NULL THEN
457:
458: igs_pe_citizenships_pkg.citizenship(
459: p_action => 'INSERT',
460: P_birth_or_selected => NULL,
461: P_country_code => p_citizen_country,
462: p_date_disowned => NULL,

Line 480: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(

476:
477: ELSE
478: IF ctzn_country_rec.end_date IS NOT NULL THEN
479:
480: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(
481: p_action => 'UPDATE',
482: P_birth_or_selected => NULL,
483: P_country_code => p_citizen_country,
484: p_date_disowned => NULL,

Line 507: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(

503: IF l_return_status IS NULL OR l_return_status = 'S' THEN
504:
505: FOR active_ctzn_rec IN active_ctzn_cur(p_person_id, p_citizen_country) LOOP
506:
507: IGS_PE_CITIZENSHIPS_PKG.CITIZENSHIP(
508: p_action => 'UPDATE',
509: P_birth_or_selected => active_ctzn_rec.birth_or_selected,
510: P_country_code => active_ctzn_rec.country_code,
511: p_date_disowned => NULL,