APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_K_PARTY_ROLES_V

Line 1235: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS

1231: FUNCTION get_kplv_rec (
1232: p_kplv_rec IN kplv_rec_type,
1233: x_no_data_found OUT NOCOPY BOOLEAN
1234: ) RETURN kplv_rec_type IS
1235: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS
1236: SELECT
1237: ID,
1238: OBJECT_VERSION_NUMBER,
1239: ATTRIBUTE_CATEGORY,

Line 1260: FROM Okl_K_Party_Roles_V

1256: CREATION_DATE,
1257: LAST_UPDATED_BY,
1258: LAST_UPDATE_DATE,
1259: LAST_UPDATE_LOGIN
1260: FROM Okl_K_Party_Roles_V
1261: WHERE okl_k_party_roles_v.id = p_id;
1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1263: l_kplv_rec kplv_rec_type;
1264: BEGIN

Line 1261: WHERE okl_k_party_roles_v.id = p_id;

1257: LAST_UPDATED_BY,
1258: LAST_UPDATE_DATE,
1259: LAST_UPDATE_LOGIN
1260: FROM Okl_K_Party_Roles_V
1261: WHERE okl_k_party_roles_v.id = p_id;
1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1263: l_kplv_rec kplv_rec_type;
1264: BEGIN
1265: x_no_data_found := TRUE;

Line 1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;

1258: LAST_UPDATE_DATE,
1259: LAST_UPDATE_LOGIN
1260: FROM Okl_K_Party_Roles_V
1261: WHERE okl_k_party_roles_v.id = p_id;
1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1263: l_kplv_rec kplv_rec_type;
1264: BEGIN
1265: x_no_data_found := TRUE;
1266: -- Get current database values

Line 1267: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);

1263: l_kplv_rec kplv_rec_type;
1264: BEGIN
1265: x_no_data_found := TRUE;
1266: -- Get current database values
1267: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1268: FETCH okl_k_party_roles_v_pk_csr INTO
1269: l_kplv_rec.id,
1270: l_kplv_rec.object_version_number,
1271: l_kplv_rec.attribute_category,

Line 1268: FETCH okl_k_party_roles_v_pk_csr INTO

1264: BEGIN
1265: x_no_data_found := TRUE;
1266: -- Get current database values
1267: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1268: FETCH okl_k_party_roles_v_pk_csr INTO
1269: l_kplv_rec.id,
1270: l_kplv_rec.object_version_number,
1271: l_kplv_rec.attribute_category,
1272: l_kplv_rec.attribute1,

Line 1292: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;

1288: l_kplv_rec.creation_date,
1289: l_kplv_rec.last_updated_by,
1290: l_kplv_rec.last_update_date,
1291: l_kplv_rec.last_update_login;
1292: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1293: CLOSE okl_k_party_roles_v_pk_csr;
1294: RETURN(l_kplv_rec);
1295: END get_kplv_rec;
1296: ------------------------------------------------------------------

Line 1293: CLOSE okl_k_party_roles_v_pk_csr;

1289: l_kplv_rec.last_updated_by,
1290: l_kplv_rec.last_update_date,
1291: l_kplv_rec.last_update_login;
1292: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1293: CLOSE okl_k_party_roles_v_pk_csr;
1294: RETURN(l_kplv_rec);
1295: END get_kplv_rec;
1296: ------------------------------------------------------------------
1297: -- This version of get_rec sets error messages if no data found --