DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_ALT_PERS_ID_PKG

Line 1819: igs_pe_alt_pers_id_pkg.delete_row(l_rowid,'R');

1815: FETCH c_ins_row_id INTO l_rowid;
1816: CLOSE c_ins_row_id;
1817:
1818: IF l_rowid IS NOT NULL THEN
1819: igs_pe_alt_pers_id_pkg.delete_row(l_rowid,'R');
1820: END IF;
1821:
1822: l_rowid := NULL;
1823:

Line 1824: igs_pe_alt_pers_id_pkg.insert_row(

1820: END IF;
1821:
1822: l_rowid := NULL;
1823:
1824: igs_pe_alt_pers_id_pkg.insert_row(
1825: X_ROWID => l_rowid,
1826: X_PE_PERSON_ID => P_PE_PERSON_ID,
1827: X_API_PERSON_ID => l_api_person_id,
1828: X_API_PERSON_ID_UF => NULL,

Line 1862: IGS_PE_ALT_PERS_ID_PKG.UPDATE_ROW(

1858: OPEN c_row_id(p_pe_person_id, l_api_person_id, p_person_id_type, p_start_dt);
1859: FETCH c_row_id INTO l_rowid, l_Api_Person_Id_uf;
1860: CLOSE c_row_id;
1861:
1862: IGS_PE_ALT_PERS_ID_PKG.UPDATE_ROW(
1863: X_ROWID => l_rowid,
1864: X_PE_PERSON_ID => P_PE_PERSON_ID,
1865: X_API_PERSON_ID => l_api_person_id,
1866: X_API_PERSON_ID_UF => NULL,

Line 1900: IGS_PE_ALT_PERS_ID_Pkg.Lock_Row (

1896: OPEN c_row_id(p_pe_person_id, l_api_person_id, p_person_id_type, p_start_dt);
1897: FETCH c_row_id INTO l_rowid, l_Api_Person_Id_uf;
1898: CLOSE c_row_id;
1899:
1900: IGS_PE_ALT_PERS_ID_Pkg.Lock_Row (
1901: X_RowId => l_rowid,
1902: X_Pe_Person_Id => p_pe_person_id,
1903: X_Api_Person_Id => l_api_person_id,
1904: X_Api_Person_Id_uf => l_Api_Person_Id_uf,