eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 1765: CURSOR c_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

1761: P_MSG_DATA OUT NOCOPY VARCHAR2
1762: ) IS
1763: l_message_name VARCHAR2(30);
1764: l_app VARCHAR2(50);
1765: CURSOR c_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1766: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1767: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1768: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1769: SELECT rowid, api_person_id_uf

Line 1766: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,

1762: ) IS
1763: l_message_name VARCHAR2(30);
1764: l_app VARCHAR2(50);
1765: CURSOR c_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1766: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1767: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1768: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1769: SELECT rowid, api_person_id_uf
1770: FROM igs_pe_alt_pers_id

Line 1767: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,

1763: l_message_name VARCHAR2(30);
1764: l_app VARCHAR2(50);
1765: CURSOR c_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1766: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1767: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1768: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1769: SELECT rowid, api_person_id_uf
1770: FROM igs_pe_alt_pers_id
1771: WHERE pe_person_id = cp_pe_person_id AND

Line 1768: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS

1764: l_app VARCHAR2(50);
1765: CURSOR c_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1766: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1767: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1768: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1769: SELECT rowid, api_person_id_uf
1770: FROM igs_pe_alt_pers_id
1771: WHERE pe_person_id = cp_pe_person_id AND
1772: api_person_id = cp_api_person_id AND

Line 1770: FROM igs_pe_alt_pers_id

1766: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1767: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1768: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1769: SELECT rowid, api_person_id_uf
1770: FROM igs_pe_alt_pers_id
1771: WHERE pe_person_id = cp_pe_person_id AND
1772: api_person_id = cp_api_person_id AND
1773: person_id_type = cp_person_id_type AND
1774: start_dt = cp_start_dt;

Line 1776: CURSOR c_ins_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

1772: api_person_id = cp_api_person_id AND
1773: person_id_type = cp_person_id_type AND
1774: start_dt = cp_start_dt;
1775:
1776: CURSOR c_ins_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1777: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1778: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1779: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1780: SELECT rowid

Line 1777: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,

1773: person_id_type = cp_person_id_type AND
1774: start_dt = cp_start_dt;
1775:
1776: CURSOR c_ins_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1777: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1778: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1779: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1780: SELECT rowid
1781: FROM IGS_PE_ALT_PERS_ID

Line 1778: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,

1774: start_dt = cp_start_dt;
1775:
1776: CURSOR c_ins_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1777: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1778: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1779: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1780: SELECT rowid
1781: FROM IGS_PE_ALT_PERS_ID
1782: where PE_PERSON_ID = cp_pe_person_id

Line 1779: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS

1775:
1776: CURSOR c_ins_row_id(cp_pe_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1777: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1778: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1779: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1780: SELECT rowid
1781: FROM IGS_PE_ALT_PERS_ID
1782: where PE_PERSON_ID = cp_pe_person_id
1783: and API_PERSON_ID = cp_api_person_id

Line 1781: FROM IGS_PE_ALT_PERS_ID

1777: cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
1778: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
1779: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE) IS
1780: SELECT rowid
1781: FROM IGS_PE_ALT_PERS_ID
1782: where PE_PERSON_ID = cp_pe_person_id
1783: and API_PERSON_ID = cp_api_person_id
1784: and PERSON_ID_TYPE = cp_person_id_type
1785: and start_dt = cp_start_dt

Line 1789: l_Api_Person_Id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;

1785: and start_dt = cp_start_dt
1786: and start_dt = end_dt;
1787:
1788: l_rowid VARCHAR2(25) := NULL;
1789: l_Api_Person_Id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
1790: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
1791:
1792: CURSOR c_alt_id_desc(cp_alt_id_type in VARCHAR) IS
1793: SELECT description

Line 1790: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;

1786: and start_dt = end_dt;
1787:
1788: l_rowid VARCHAR2(25) := NULL;
1789: l_Api_Person_Id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
1790: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
1791:
1792: CURSOR c_alt_id_desc(cp_alt_id_type in VARCHAR) IS
1793: SELECT description
1794: FROM igs_pe_person_id_typ

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,