APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_REL_OBJS_V

Line 456: FROM okc_k_rel_objs_v

452:
453: CURSOR prev_link_csr (p_okl_chr_id OKC_K_HEADERS_B.ID%TYPE,
454: p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
455: SELECT chr_id
456: FROM okc_k_rel_objs_v
457: WHERE chr_id <> p_okl_chr_id
458: AND object1_id1 = p_oks_chr_id
459: AND rty_code = 'OKLSRV';
460:

Line 1380: FROM okc_k_rel_objs_v

1376: l_api_version CONSTANT NUMBER := 1;
1377:
1378: CURSOR line_link_csr (p_okl_service_line_id OKC_K_LINES_V.ID%TYPE) IS
1379: SELECT id
1380: FROM okc_k_rel_objs_v
1381: WHERE cle_id = p_okl_service_line_id
1382: AND rty_code = 'OKLSRV' -- ???
1383: AND jtot_object1_code = 'OKL_SERVICE_LINE';
1384:

Line 1387: FROM okc_k_rel_objs_v t1

1383: AND jtot_object1_code = 'OKL_SERVICE_LINE';
1384:
1385: CURSOR any_more_link_csr(p_okl_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1386: SELECT id
1387: FROM okc_k_rel_objs_v t1
1388: WHERE chr_id = p_okl_chr_id
1389: AND cle_id IS NULL
1390: AND NOT EXISTS (SELECT 'Y'
1391: FROM okc_k_rel_objs t2

Line 1407: FROM okc_k_rel_objs_v rlobj

1403: */
1404:
1405: CURSOR get_service_top_line IS
1406: SELECT rlobj.object1_id1
1407: FROM okc_k_rel_objs_v rlobj
1408: WHERE rlobj.chr_id = p_clev_rec.dnz_chr_id
1409: AND rlobj.cle_id = p_clev_rec.id
1410: AND rlobj.rty_code = 'OKLSRV'
1411: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';

Line 1425: l_header_rel_id okc_k_rel_objs_v.id%type;

1421: */
1422:
1423:
1424: l_crjv_rec crjv_rec_type;
1425: l_header_rel_id okc_k_rel_objs_v.id%type;
1426: l_line_rel_id okc_k_rel_objs_v.id%type;
1427:
1428: /*
1429: * sjalsut: aug 18, 04 added variables to hold service contract header id and

Line 1426: l_line_rel_id okc_k_rel_objs_v.id%type;

1422:
1423:
1424: l_crjv_rec crjv_rec_type;
1425: l_header_rel_id okc_k_rel_objs_v.id%type;
1426: l_line_rel_id okc_k_rel_objs_v.id%type;
1427:
1428: /*
1429: * sjalsut: aug 18, 04 added variables to hold service contract header id and
1430: * service contract line id. BEGIN.

Line 1788: FROM okc_k_rel_objs_v

1784:
1785:
1786: CURSOR link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1787: SELECT object1_id1
1788: FROM okc_k_rel_objs_v
1789: WHERE chr_id = p_chr_id
1790: AND cle_id IS NULL
1791: AND rty_code = 'OKLSRV'; -- ???
1792:

Line 1796: FROM okc_k_rel_objs_v

1792:
1793: CURSOR line_link_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1794: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1795: SELECT 'Y' answer
1796: FROM okc_k_rel_objs_v
1797: WHERE chr_id = p_chr_id
1798: AND object1_id1 = p_line_id
1799: AND jtot_object1_code = 'OKL_SERVICE_LINE';
1800:

Line 1921: FROM okc_k_rel_objs_v

1917:
1918: CURSOR k_rel_csr (p_okl_chr_id OKC_K_HEADERS_B.ID%TYPE,
1919: p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1920: SELECT id
1921: FROM okc_k_rel_objs_v
1922: WHERE chr_id = p_okl_chr_id
1923: AND object1_id1 = p_oks_chr_id
1924: AND rty_code = 'OKLSRV'
1925: AND jtot_object1_code = 'OKL_SERVICE_CONNECTOR';

Line 1927: l_rel_id OKC_K_REL_OBJS_V.ID%TYPE;

1923: AND object1_id1 = p_oks_chr_id
1924: AND rty_code = 'OKLSRV'
1925: AND jtot_object1_code = 'OKL_SERVICE_CONNECTOR';
1926:
1927: l_rel_id OKC_K_REL_OBJS_V.ID%TYPE;
1928:
1929: l_crjv_rec crjv_rec_type;
1930: x_crjv_rec crjv_rec_type;
1931:

Line 2077: FROM okc_k_rel_objs_v

2073:
2074:
2075: CURSOR link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2076: SELECT object1_id1
2077: FROM okc_k_rel_objs_v
2078: WHERE chr_id = p_chr_id
2079: AND cle_id IS NULL
2080: AND rty_code = 'OKLSRV'; -- ???
2081:

Line 2185: FROM okc_k_rel_objs_v

2181: CURSOR link_csr (p_okl_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2182:
2183: SELECT cle_id,
2184: object1_id1
2185: FROM okc_k_rel_objs_v
2186: WHERE chr_id = p_okl_chr_id
2187: AND cle_id IS NOT NULL
2188: AND rty_code = 'OKLSRV'
2189: AND jtot_object1_code = 'OKL_COV_PROD';

Line 2501: FROM okc_k_rel_objs_v

2497:
2498: CURSOR cov_link_csr (p_okl_line_id OKC_K_LINES_V.ID%TYPE,
2499: p_oks_line_id OKC_K_LINES_V.ID%TYPE) IS
2500: SELECT ID
2501: FROM okc_k_rel_objs_v
2502: WHERE cle_id = p_okl_line_id
2503: AND object1_id1 = p_oks_line_id
2504: AND jtot_object1_code = 'OKL_COV_PROD'
2505: AND rty_code = 'OKLSRV';

Line 2507: l_link_id OKC_K_REL_OBJS_V.ID%TYPE;

2503: AND object1_id1 = p_oks_line_id
2504: AND jtot_object1_code = 'OKL_COV_PROD'
2505: AND rty_code = 'OKLSRV';
2506:
2507: l_link_id OKC_K_REL_OBJS_V.ID%TYPE;
2508: l_crjv_rec crjv_rec_type;
2509: x_crjv_rec crjv_rec_type;
2510: cov_link_error EXCEPTION;
2511:

Line 4044: FROM okc_k_rel_objs_v

4040: CURSOR rel_link_csr(p_okl_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4041: SELECT id,
4042: object1_id1,
4043: cle_id
4044: FROM okc_k_rel_objs_v
4045: WHERE chr_id = p_okl_chr_id
4046: AND rty_code = 'OKLSRV';
4047:
4048: l_service_contract_id OKC_K_HEADERS_V.ID%TYPE;