DBA Data[Home] [Help]

APPS.OKL_QPY_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 259: FROM OKC_K_PARTY_ROLES_V

255: p_qpyv_rec IN qpyv_rec_type) IS
256:
257: CURSOR l_cpl_csr IS
258: SELECT 'x'
259: FROM OKC_K_PARTY_ROLES_V
260: WHERE ID = p_qpyv_rec.cpl_id;
261:
262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
263: l_dummy_var VARCHAR2(1) := '?';

Line 305: p_token3_value => 'OKC_K_PARTY_ROLES_V');

301: p_token1_value => 'cpl_id',
302: p_token2 => G_CHILD_TABLE_TOKEN,
303: p_token2_value => 'OKL_QUOTE_PARTIES_V',
304: p_token3 => G_PARENT_TABLE_TOKEN,
305: p_token3_value => 'OKC_K_PARTY_ROLES_V');
306:
307: -- notify caller of an error
308: x_return_status := OKC_API.G_RET_STS_ERROR;
309: END IF;

Line 1158: FROM Okc_K_Party_Roles_V

1154: CREATION_DATE,
1155: LAST_UPDATED_BY,
1156: LAST_UPDATE_DATE,
1157: LAST_UPDATE_LOGIN
1158: FROM Okc_K_Party_Roles_V
1159: WHERE okc_k_party_roles_v.id = p_id;
1160: l_okc_cplv_pk okc_cplv_pk_csr%ROWTYPE;
1161: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1162: l_row_notfound BOOLEAN := TRUE;

Line 1159: WHERE okc_k_party_roles_v.id = p_id;

1155: LAST_UPDATED_BY,
1156: LAST_UPDATE_DATE,
1157: LAST_UPDATE_LOGIN
1158: FROM Okc_K_Party_Roles_V
1159: WHERE okc_k_party_roles_v.id = p_id;
1160: l_okc_cplv_pk okc_cplv_pk_csr%ROWTYPE;
1161: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1162: l_row_notfound BOOLEAN := TRUE;
1163: BEGIN