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_HEADERS_B

Line 105: p_chr_id IN okc_k_headers_b.id%TYPE,

101: -- History : 30-AUG-2004 SJALASUT created
102: -- End of comments
103: PROCEDURE raise_business_event(p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2,
105: p_chr_id IN okc_k_headers_b.id%TYPE,
106: p_oks_chr_id IN okc_k_headers_b.id%TYPE,
107: p_okl_service_line_id IN okc_k_lines_b.id%TYPE,
108: p_oks_service_line_id IN okc_k_lines_b.id%TYPE,
109: p_event_name IN VARCHAR2,

Line 106: p_oks_chr_id IN okc_k_headers_b.id%TYPE,

102: -- End of comments
103: PROCEDURE raise_business_event(p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2,
105: p_chr_id IN okc_k_headers_b.id%TYPE,
106: p_oks_chr_id IN okc_k_headers_b.id%TYPE,
107: p_okl_service_line_id IN okc_k_lines_b.id%TYPE,
108: p_oks_service_line_id IN okc_k_lines_b.id%TYPE,
109: p_event_name IN VARCHAR2,
110: x_return_status OUT NOCOPY VARCHAR2,

Line 322: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

318: PROCEDURE get_bill_to(
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
323: x_bill_to_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE
324: ) IS
325:
326: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';

Line 323: x_bill_to_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE

319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
323: x_bill_to_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE
324: ) IS
325:
326: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';
327:

Line 328: CURSOR bill_to_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

324: ) IS
325:
326: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';
327:
328: CURSOR bill_to_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
329: SELECT bill_to_site_use_id
330: FROM okc_k_headers_b
331: WHERE id = p_chr_id;
332:

Line 330: FROM okc_k_headers_b

326: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';
327:
328: CURSOR bill_to_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
329: SELECT bill_to_site_use_id
330: FROM okc_k_headers_b
331: WHERE id = p_chr_id;
332:
333: bill_to_failed EXCEPTION;
334:

Line 453: CURSOR prev_link_csr (p_okl_chr_id OKC_K_HEADERS_B.ID%TYPE,

449: AND rgp.id = rule.rgp_id
450: AND rgp.rgd_code = 'LABILL'
451: AND rule.rule_information_category = 'BTO';
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

Line 454: p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

450: AND rgp.rgd_code = 'LABILL'
451: AND rule.rule_information_category = 'BTO';
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

Line 1432: l_serv_contract_hdr_id okc_k_headers_b.id%TYPE;

1428: /*
1429: * sjalsut: aug 18, 04 added variables to hold service contract header id and
1430: * service contract line id. BEGIN.
1431: */
1432: l_serv_contract_hdr_id okc_k_headers_b.id%TYPE;
1433: l_serv_contract_line_id okc_k_lines_b.id%TYPE;
1434:
1435: /*
1436: * sjalsut: aug 18, 04 added variables to hold service contract header id and

Line 1909: p_okl_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

1905: p_init_msg_list IN VARCHAR2,
1906: x_return_status OUT NOCOPY VARCHAR2,
1907: x_msg_count OUT NOCOPY NUMBER,
1908: x_msg_data OUT NOCOPY VARCHAR2,
1909: p_okl_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1910: p_oks_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1911: p_jtf_code IN VARCHAR2
1912: ) IS
1913:

Line 1910: p_oks_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

1906: x_return_status OUT NOCOPY VARCHAR2,
1907: x_msg_count OUT NOCOPY NUMBER,
1908: x_msg_data OUT NOCOPY VARCHAR2,
1909: p_okl_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1910: p_oks_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1911: p_jtf_code IN VARCHAR2
1912: ) IS
1913:
1914: l_api_name VARCHAR2(35) := 'update_jtf_code';

Line 1918: CURSOR k_rel_csr (p_okl_chr_id OKC_K_HEADERS_B.ID%TYPE,

1914: l_api_name VARCHAR2(35) := 'update_jtf_code';
1915: l_proc_name VARCHAR2(35) := 'UPDATE_JTF_CODE';
1916: l_api_version CONSTANT NUMBER := 1;
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

Line 1919: p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

1915: l_proc_name VARCHAR2(35) := 'UPDATE_JTF_CODE';
1916: l_api_version CONSTANT NUMBER := 1;
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

Line 2960: p_oks_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

2956: PROCEDURE update_oks_ar_intf(
2957: x_return_status OUT NOCOPY VARCHAR2,
2958: x_msg_count OUT NOCOPY NUMBER,
2959: x_msg_data OUT NOCOPY VARCHAR2,
2960: p_oks_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
2961: p_ar_intf_val IN VARCHAR2
2962: )IS
2963:
2964: l_api_name VARCHAR2(35) := 'update_oks_arintf';

Line 3045: p_okl_chr_id IN OKC_K_HEADERS_B.ID%TYPE

3041: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3042: x_return_status OUT NOCOPY VARCHAR2,
3043: x_msg_count OUT NOCOPY NUMBER,
3044: x_msg_data OUT NOCOPY VARCHAR2,
3045: p_okl_chr_id IN OKC_K_HEADERS_B.ID%TYPE
3046: ) IS
3047: l_api_name VARCHAR2(35) := 'initiate_service_booking';
3048: l_proc_name VARCHAR2(35) := 'INITIATE_SERVICE_BOOKING';
3049: l_api_version CONSTANT NUMBER := 1;

Line 3051: CURSOR ib_csr (p_okl_chr_id OKC_K_HEADERS_B.ID%TYPE,

3047: l_api_name VARCHAR2(35) := 'initiate_service_booking';
3048: l_proc_name VARCHAR2(35) := 'INITIATE_SERVICE_BOOKING';
3049: l_api_version CONSTANT NUMBER := 1;
3050:
3051: CURSOR ib_csr (p_okl_chr_id OKC_K_HEADERS_B.ID%TYPE,
3052: p_okl_cov_line_id OKC_K_LINES_B.ID%TYPE) IS
3053: SELECT ib_line.id,
3054: ib_item.id,
3055: ib_item.object1_id1,

Line 3085: CURSOR oks_ib_csr (p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE,

3081: AND rel.chr_id = p_okl_chr_id
3082: AND ib_item.object1_id1 IS NULL
3083: AND ROWNUM < 2; -- to ensure first line with null instance_id
3084:
3085: CURSOR oks_ib_csr (p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE,
3086: p_oks_cov_line_id OKC_K_LINES_B.ID%TYPE) IS
3087: SELECT object1_id1,
3088: object1_id2
3089: FROM okc_k_items

Line 3128: l_oks_chr_id OKC_K_HEADERS_B.ID%TYPE;

3124: FROM mtl_system_items
3125: WHERE inventory_item_id = p_inv_id
3126: AND organization_id = p_org_id;
3127:
3128: l_oks_chr_id OKC_K_HEADERS_B.ID%TYPE;
3129: l_link_line_tbl OKL_SERVICE_INTEGRATION_PUB.link_line_tbl_type;
3130: l_cimv_rec okc_contract_item_pub.cimv_rec_type;
3131: x_cimv_rec okc_contract_item_pub.cimv_rec_type;
3132: l_ib_line_id OKC_K_LINES_B.ID%TYPE;