APPS.OKC_STD_ARTICLE_PVT dependencies on OKC_STD_ART_INCMPTS

Line 459: select '1' from OKC_STD_ART_INCMPTS where sae_id=id;

455: select '1' from OKC_STD_ART_VERSIONS_B where sae_id=id;
456: Cursor l_set(id number) is
457: select '1' from OKC_STD_ART_SET_MEMS where sae_id=id;
458: Cursor l_incmpt(id number) is
459: select '1' from OKC_STD_ART_INCMPTS where sae_id=id;
460: l_count varchar2(1):='0';
461:
462: BEGIN
463: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1280: FROM okc_std_art_incmpts sai

1276:
1277: l_saiv_rec saiv_rec_type;
1278: CURSOR l_sai_csr IS
1279: SELECT '1'
1280: FROM okc_std_art_incmpts sai
1281: WHERE sai.sae_id = p_saiv_rec.sae_id_for and sai.sae_id_for = p_saiv_rec.sae_id;
1282: l_dummy_var VARCHAR2(1):='0';
1283: BEGIN
1284: --check if the opposite combination record exists

Line 1353: FROM okc_std_art_incmpts sai

1349: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1350: l_saiv_rec saiv_rec_type;
1351: CURSOR l_sai_csr IS
1352: SELECT '1'
1353: FROM okc_std_art_incmpts sai
1354: WHERE sai.sae_id = p_saiv_rec.sae_id_for and sai.sae_id_for = p_saiv_rec.sae_id;
1355:
1356: l_dummy_var VARCHAR2(1):='0';
1357: BEGIN

Line 1425: FROM okc_std_art_incmpts sai

1421:
1422: l_saiv_rec saiv_rec_type;
1423: CURSOR l_sai_csr IS
1424: SELECT '1'
1425: FROM okc_std_art_incmpts sai
1426: WHERE sai.sae_id = p_saiv_rec.sae_id_for and sai.sae_id_for = p_saiv_rec.sae_id;
1427: l_dummy_var VARCHAR2(1):='0';
1428: BEGIN
1429: --check if the opposite combination record exists

Line 1498: FROM okc_std_art_incmpts sai

1494: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1495: l_saiv_rec saiv_rec_type;
1496: CURSOR l_sai_csr IS
1497: SELECT '1'
1498: FROM okc_std_art_incmpts sai
1499: WHERE sai.sae_id = p_saiv_rec.sae_id_for and sai.sae_id_for = p_saiv_rec.sae_id;
1500:
1501: l_dummy_var VARCHAR2(1):='0';
1502: BEGIN