1538: IS
1539:
1540:
1541: CURSOR get_object_vers is
1542: SELECT object_version_number FROM okc_contacts WHERE id = p_ctcv_rec.ID;
1543: l_obj_vers_num NUMBER;
1544: BEGIN
1545: INITIALIZE_RECORD_contact(l_ctcv_tbl_in);
1546:
1833: l_JTOT_OBJECT1_CODE VARCHAR2(40);
1834: l_ctcv_rec ctcv_rec_type;
1835:
1836: ---------------------------------------------------------------------------
1837: -- FUNCTION get_rec for: OKC_CONTACTS_V
1838: ---------------------------------------------------------------------------
1839: FUNCTION get_rec (
1840: p_ctcv_rec IN ctcv_rec_type,
1841: x_no_data_found OUT NOCOPY BOOLEAN
1876: LAST_UPDATE_DATE,
1877: LAST_UPDATE_LOGIN,
1878: START_DATE,
1879: END_DATE
1880: FROM Okc_Contacts
1881: WHERE okc_contacts.id = p_id;
1882: l_okc_ctcv_pk okc_ctcv_pk_csr%ROWTYPE;
1883: l_ctcv_rec ctcv_rec_type;
1884: BEGIN
1877: LAST_UPDATE_LOGIN,
1878: START_DATE,
1879: END_DATE
1880: FROM Okc_Contacts
1881: WHERE okc_contacts.id = p_id;
1882: l_okc_ctcv_pk okc_ctcv_pk_csr%ROWTYPE;
1883: l_ctcv_rec ctcv_rec_type;
1884: BEGIN
1885: