APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_K_PARTY_ROLES_V

Line 1253: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS

1249: FUNCTION get_kplv_rec (
1250: p_kplv_rec IN kplv_rec_type,
1251: x_no_data_found OUT NOCOPY BOOLEAN
1252: ) RETURN kplv_rec_type IS
1253: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS
1254: SELECT
1255: ID,
1256: OBJECT_VERSION_NUMBER,
1257: ATTRIBUTE_CATEGORY,

Line 1278: FROM Okl_K_Party_Roles_V

1274: CREATION_DATE,
1275: LAST_UPDATED_BY,
1276: LAST_UPDATE_DATE,
1277: LAST_UPDATE_LOGIN
1278: FROM Okl_K_Party_Roles_V
1279: WHERE okl_k_party_roles_v.id = p_id;
1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1281: l_kplv_rec kplv_rec_type;
1282: BEGIN

Line 1279: WHERE okl_k_party_roles_v.id = p_id;

1275: LAST_UPDATED_BY,
1276: LAST_UPDATE_DATE,
1277: LAST_UPDATE_LOGIN
1278: FROM Okl_K_Party_Roles_V
1279: WHERE okl_k_party_roles_v.id = p_id;
1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1281: l_kplv_rec kplv_rec_type;
1282: BEGIN
1283: x_no_data_found := TRUE;

Line 1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;

1276: LAST_UPDATE_DATE,
1277: LAST_UPDATE_LOGIN
1278: FROM Okl_K_Party_Roles_V
1279: WHERE okl_k_party_roles_v.id = p_id;
1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1281: l_kplv_rec kplv_rec_type;
1282: BEGIN
1283: x_no_data_found := TRUE;
1284: -- Get current database values

Line 1285: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);

1281: l_kplv_rec kplv_rec_type;
1282: BEGIN
1283: x_no_data_found := TRUE;
1284: -- Get current database values
1285: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1286: FETCH okl_k_party_roles_v_pk_csr INTO
1287: l_kplv_rec.id,
1288: l_kplv_rec.object_version_number,
1289: l_kplv_rec.attribute_category,

Line 1286: FETCH okl_k_party_roles_v_pk_csr INTO

1282: BEGIN
1283: x_no_data_found := TRUE;
1284: -- Get current database values
1285: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1286: FETCH okl_k_party_roles_v_pk_csr INTO
1287: l_kplv_rec.id,
1288: l_kplv_rec.object_version_number,
1289: l_kplv_rec.attribute_category,
1290: l_kplv_rec.attribute1,

Line 1310: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;

1306: l_kplv_rec.creation_date,
1307: l_kplv_rec.last_updated_by,
1308: l_kplv_rec.last_update_date,
1309: l_kplv_rec.last_update_login;
1310: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1311: CLOSE okl_k_party_roles_v_pk_csr;
1312: RETURN(l_kplv_rec);
1313: END get_kplv_rec;
1314: ------------------------------------------------------------------

Line 1311: CLOSE okl_k_party_roles_v_pk_csr;

1307: l_kplv_rec.last_updated_by,
1308: l_kplv_rec.last_update_date,
1309: l_kplv_rec.last_update_login;
1310: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1311: CLOSE okl_k_party_roles_v_pk_csr;
1312: RETURN(l_kplv_rec);
1313: END get_kplv_rec;
1314: ------------------------------------------------------------------
1315: -- This version of get_rec sets error messages if no data found --