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.OKS_EXTWAR_UTIL_PUB dependencies on OKC_CONTRACT_PARTY_PUB

Line 570: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

566: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
567: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
568: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
569: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
570: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
571: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
572:
573: BEGIN
574:

Line 571: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

567: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
568: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
569: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
570: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
571: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
572:
573: BEGIN
574:
575: -- Get the contact details (if any)

Line 646: okc_contract_party_pub.delete_contact (

642:
643: */
644: l_ctcv_tbl_in(1).id := p_contact_id;
645:
646: okc_contract_party_pub.delete_contact (
647: p_api_version => l_api_version,
648: p_init_msg_list => l_init_msg_list,
649: x_return_status => l_return_status,
650: x_msg_count => l_msg_count,

Line 655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);

651: x_msg_data => l_msg_data,
652: p_ctcv_tbl => l_ctcv_tbl_in
653: );
654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
659: -- RAISE OKC_API.G_EXCEPTION_ERROR;

Line 658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);

654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
659: -- RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: x_return_status := l_return_status;
662: END DELETE_CONTACT;

Line 678: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

674: l_return_status VARCHAR2(1);
675: l_msg_count NUMBER;
676: l_msg_data VARCHAR2(2000);
677: l_msg_index_out NUMBER;
678: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
679: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
680:
681: BEGIN
682: null;

Line 679: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

675: l_msg_count NUMBER;
676: l_msg_data VARCHAR2(2000);
677: l_msg_index_out NUMBER;
678: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
679: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
680:
681: BEGIN
682: null;
683: l_ctcv_tbl_in(1).cpl_id := p_cpl_id;

Line 697: okc_contract_party_pub.create_contact (

693: l_ctcv_tbl_in(1).last_update_date := SYSDATE;
694: l_ctcv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
695: l_ctcv_tbl_in(1).sales_group_id := p_sales_group_id;
696:
697: okc_contract_party_pub.create_contact (
698: p_api_version => l_api_version,
699: p_init_msg_list => l_init_msg_list,
700: x_return_status => l_return_status,
701: x_msg_count => l_msg_count,

Line 708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);

704: x_ctcv_tbl => l_ctcv_tbl_out
705: );
706:
707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
712: -- RAISE OKC_API.G_EXCEPTION_ERROR;

Line 711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);

707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
712: -- RAISE OKC_API.G_EXCEPTION_ERROR;
713: END IF;
714:
715: x_return_status := l_return_status;

Line 1781: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

1777: SELECT contract_number, contract_number_modifier
1778: FROM okc_k_headers_b
1779: WHERE id = p_chr_id;
1780:
1781: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;
1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;
1784:
1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

Line 1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;

1778: FROM okc_k_headers_b
1779: WHERE id = p_chr_id;
1780:
1781: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;
1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;
1784:
1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;

Line 1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;

1779: WHERE id = p_chr_id;
1780:
1781: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;
1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;
1784:
1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;
1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;

Line 1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

1781: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;
1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;
1784:
1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;
1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;
1788:
1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;

Line 1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;

1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;
1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;
1784:
1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;
1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;
1788:
1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;
1790: l_ctcv_rec_out_ins okc_contract_party_pub.ctcv_rec_type;

Line 1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;

1783: l_ctcv_tbl_in_upd okc_contract_party_pub.ctcv_tbl_type;
1784:
1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;
1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;
1788:
1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;
1790: l_ctcv_rec_out_ins okc_contract_party_pub.ctcv_rec_type;
1791: l_ctcv_rec_out_del okc_contract_party_pub.ctcv_rec_type;

Line 1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;

1785: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;
1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;
1788:
1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;
1790: l_ctcv_rec_out_ins okc_contract_party_pub.ctcv_rec_type;
1791: l_ctcv_rec_out_del okc_contract_party_pub.ctcv_rec_type;
1792:
1793:

Line 1790: l_ctcv_rec_out_ins okc_contract_party_pub.ctcv_rec_type;

1786: l_ctcv_tbl_out_upd okc_contract_party_pub.ctcv_tbl_type;
1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;
1788:
1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;
1790: l_ctcv_rec_out_ins okc_contract_party_pub.ctcv_rec_type;
1791: l_ctcv_rec_out_del okc_contract_party_pub.ctcv_rec_type;
1792:
1793:
1794:

Line 1791: l_ctcv_rec_out_del okc_contract_party_pub.ctcv_rec_type;

1787: l_ctcv_tbl_out_del okc_contract_party_pub.ctcv_tbl_type;
1788:
1789: l_ctcv_rec_out_upd okc_contract_party_pub.ctcv_rec_type;
1790: l_ctcv_rec_out_ins okc_contract_party_pub.ctcv_rec_type;
1791: l_ctcv_rec_out_del okc_contract_party_pub.ctcv_rec_type;
1792:
1793:
1794:
1795:

Line 2588: okc_contract_party_pub.update_contact ( p_api_version => l_api_version,

2584: IF l_org_id IS NULL THEN
2585: OKC_CONTEXT.set_okc_org_context(l_ctcv_tbl_in_upd(idx5).attribute1,null);
2586: END IF;
2587: l_ctcv_tbl_in_upd(idx5).attribute1 := NULL;
2588: okc_contract_party_pub.update_contact ( p_api_version => l_api_version,
2589: p_init_msg_list => l_init_msg_list,
2590: x_return_status => l_return_status,
2591: x_msg_count => l_msg_count,
2592: x_msg_data => l_msg_data,

Line 2617: okc_contract_party_pub.delete_contact ( p_api_version => l_api_version,

2613: IF l_org_id IS NULL THEN
2614: OKC_CONTEXT.set_okc_org_context(l_ctcv_tbl_in_del(idx6).attribute1,null);
2615: END IF;
2616: l_ctcv_tbl_in_del(idx6).attribute1 := NULL;
2617: okc_contract_party_pub.delete_contact ( p_api_version => l_api_version,
2618: p_init_msg_list => l_init_msg_list,
2619: x_return_status => l_return_status,
2620: x_msg_count => l_msg_count,
2621: x_msg_data => l_msg_data,

Line 2645: okc_contract_party_pub.create_contact (p_api_version => l_api_version,

2641: IF l_org_id IS NULL THEN
2642: OKC_CONTEXT.set_okc_org_context(l_ctcv_tbl_in(idx3).attribute3,null);
2643: END IF;
2644: l_ctcv_tbl_in(idx3).attribute3 := NULL;
2645: okc_contract_party_pub.create_contact (p_api_version => l_api_version,
2646: p_init_msg_list => l_init_msg_list,
2647: x_return_status => l_return_status,
2648: x_msg_count => l_msg_count,
2649: x_msg_data => l_msg_data,