eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_REL_OBJS

Line 35: SUBTYPE crjv_rec_type IS OKC_K_REL_OBJS_PUB.crjv_rec_type;

31: * sjalasut: aug 18, 04 added constants used in raising business event. END
32: */
33:
34:
35: SUBTYPE crjv_rec_type IS OKC_K_REL_OBJS_PUB.crjv_rec_type;
36: SUBTYPE crjv_tbl_type IS OKC_K_REL_OBJS_PUB.crjv_tbl_type;
37: --SUBTYPE clev_rec_type IS OKL_CREATE_KLE_PUB.clev_rec_type;
38: --SUBTYPE clev_tbl_type IS OKL_CREATE_KLE_PUB.clev_tbl_type;
39: --SUBTYPE klev_rec_type IS OKL_CREATE_KLE_PUB.klev_rec_type;

Line 36: SUBTYPE crjv_tbl_type IS OKC_K_REL_OBJS_PUB.crjv_tbl_type;

32: */
33:
34:
35: SUBTYPE crjv_rec_type IS OKC_K_REL_OBJS_PUB.crjv_rec_type;
36: SUBTYPE crjv_tbl_type IS OKC_K_REL_OBJS_PUB.crjv_tbl_type;
37: --SUBTYPE clev_rec_type IS OKL_CREATE_KLE_PUB.clev_rec_type;
38: --SUBTYPE clev_tbl_type IS OKL_CREATE_KLE_PUB.clev_tbl_type;
39: --SUBTYPE klev_rec_type IS OKL_CREATE_KLE_PUB.klev_rec_type;
40: SUBTYPE cimv_rec_type IS OKL_CREATE_KLE_PUB.cimv_rec_type;

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 1267: OKC_K_REL_OBJS_PUB.create_row (

1263:
1264: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1265: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling 1'||':'||x_return_status);
1266: END IF;
1267: OKC_K_REL_OBJS_PUB.create_row (
1268: p_api_version => 1.0,
1269: p_init_msg_list => OKC_API.G_FALSE,
1270: x_return_status => x_return_status,
1271: x_msg_count => x_msg_count,

Line 1303: OKC_K_REL_OBJS_PUB.create_row (

1299: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL Line ID: '|| p_okl_service_line_id);
1300: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKS Line ID: '|| p_oks_service_line_id);
1301: END IF;
1302:
1303: OKC_K_REL_OBJS_PUB.create_row (
1304: p_api_version => 1.0,
1305: p_init_msg_list => OKC_API.G_FALSE,
1306: x_return_status => x_return_status,
1307: x_msg_count => x_msg_count,

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 1391: FROM okc_k_rel_objs t2

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
1392: WHERE t2.cle_id IS NOT NULL
1393: AND t2.chr_id = t1.chr_id
1394: AND t2.rty_code = 'OKLSRV'
1395: AND t2.jtot_object1_code = 'OKL_SERVICE_LINE'

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 1478: OKC_K_REL_OBJS_PUB.delete_row (

1474: CLOSE line_link_csr;
1475:
1476: IF (l_line_rel_id IS NOT NULL) THEN -- Link exists, delete it
1477: l_crjv_rec.id := l_line_rel_id;
1478: OKC_K_REL_OBJS_PUB.delete_row (
1479: p_api_version => p_api_version,
1480: p_init_msg_list => OKL_API.G_FALSE,
1481: x_return_status => x_return_status,
1482: x_msg_count => x_msg_count,

Line 1510: OKC_K_REL_OBJS_PUB.delete_row (

1506: CLOSE any_more_link_csr;
1507:
1508: IF (l_header_rel_id IS NOT NULL) THEN
1509: l_crjv_rec.id := l_header_rel_id;
1510: OKC_K_REL_OBJS_PUB.delete_row (
1511: p_api_version => p_api_version,
1512: p_init_msg_list => OKL_API.G_FALSE,
1513: x_return_status => x_return_status,
1514: x_msg_count => x_msg_count,

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 1974: OKC_K_REL_OBJS_PUB.DELETE_ROW(

1970: l_crjv_rec := NULL;
1971: l_crjv_rec.id := l_rel_id;
1972: --l_crjv_rec.jtot_object1_code := p_jtf_code;
1973:
1974: OKC_K_REL_OBJS_PUB.DELETE_ROW(
1975: p_api_version => p_api_version,
1976: p_init_msg_list => OKL_API.G_FALSE,
1977: x_return_status => x_return_status,
1978: x_msg_count => x_msg_count,

Line 1997: OKC_K_REL_OBJS_PUB.create_row (

1993: l_crjv_rec.object1_id2 := '#';
1994: l_crjv_rec.jtot_object1_code := 'OKL_SERVICE';
1995:
1996:
1997: OKC_K_REL_OBJS_PUB.create_row (
1998: p_api_version => p_api_version,
1999: p_init_msg_list => OKC_API.G_FALSE,
2000: x_return_status => x_return_status,
2001: x_msg_count => x_msg_count,

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 2535: OKC_K_REL_OBJS_PUB.create_row (

2531: l_crjv_rec.object1_id1 := p_oks_cov_line_id;
2532: l_crjv_rec.object1_id2 := '#';
2533: l_crjv_rec.jtot_object1_code := 'OKL_COV_PROD';
2534:
2535: OKC_K_REL_OBJS_PUB.create_row (
2536: p_api_version => 1.0,
2537: p_init_msg_list => OKC_API.G_FALSE,
2538: x_return_status => x_return_status,
2539: x_msg_count => x_msg_count,

Line 2551: OKC_K_REL_OBJS_PUB.delete_row (

2547: END IF;
2548: ELSE
2549: -- update the link, i.e. delete and create the link
2550: l_crjv_rec.id := l_link_id;
2551: OKC_K_REL_OBJS_PUB.delete_row (
2552: p_api_version => 1.0,
2553: p_init_msg_list => OKL_API.G_FALSE,
2554: x_return_status => x_return_status,
2555: x_msg_count => x_msg_count,

Line 2571: OKC_K_REL_OBJS_PUB.create_row (

2567: l_crjv_rec.object1_id1 := p_oks_cov_line_id;
2568: l_crjv_rec.object1_id2 := '#';
2569: l_crjv_rec.jtot_object1_code := 'OKL_COV_PROD';
2570:
2571: OKC_K_REL_OBJS_PUB.create_row (
2572: p_api_version => 1.0,
2573: p_init_msg_list => OKC_API.G_FALSE,
2574: x_return_status => x_return_status,
2575: x_msg_count => x_msg_count,

Line 3064: okc_k_rel_objs rel

3060: okc_k_lines_b cov_line,
3061: okc_k_items cov_item,
3062: okc_k_lines_b inst_line,
3063: okc_line_styles_b inst_style,
3064: okc_k_rel_objs rel
3065: WHERE rel.cle_id = cov_line.id
3066: AND rel.chr_id = cov_line.dnz_chr_id
3067: AND cov_line.id = cov_item.cle_id
3068: AND cov_line.dnz_chr_id = rel.chr_id

Line 3103: FROM okc_k_rel_objs krel,

3099: csi.inv_master_organization_id,
3100: csi.install_location_id location_id,
3101: csi.install_location_type_code location_type_code,
3102: csi.instance_number
3103: FROM okc_k_rel_objs krel,
3104: okc_k_items kitem,
3105: csi_item_instances csi,
3106: okc_k_lines_b line,
3107: okc_line_styles_b style,

Line 3587: FROM okc_k_rel_objs rel

3583: WHERE line.lse_id = style.id
3584: AND cle_id = p_oks_serv_id
3585: AND lty_code = 'COVER_PROD'
3586: AND NOT EXISTS (SELECT 'Y'
3587: FROM okc_k_rel_objs rel
3588: WHERE TO_CHAR(line.id) = rel.object1_id1
3589: AND jtot_object1_code = 'OKL_COV_PROD'
3590: AND rty_code = 'OKLSRV'); -- to pickup only non-linked lines
3591:

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;

Line 4144: OKC_K_REL_OBJS_PUB.delete_row (

4140: END IF;
4141:
4142: END IF;
4143:
4144: OKC_K_REL_OBJS_PUB.delete_row (
4145: p_api_version => p_api_version,
4146: p_init_msg_list => OKL_API.G_FALSE,
4147: x_return_status => x_return_status,
4148: x_msg_count => x_msg_count,

Line 4338: FROM okc_k_rel_objs rel,

4334: l_api_version CONSTANT NUMBER := 1;
4335:
4336: CURSOR link_asset_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4337: SELECT kitem.object1_id1
4338: FROM okc_k_rel_objs rel,
4339: okc_k_items kitem
4340: WHERE rel.cle_id = kitem.cle_id
4341: AND rel.rty_code = 'OKLSRV'
4342: AND rel.jtot_object1_code = 'OKL_COV_PROD'