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_EXTWARPRGM_PVT dependencies on OKC_K_REL_OBJS

Line 799: FROM okc_k_rel_objs

795: IS
796: CURSOR l_kexists_csr (p_jtf_id VARCHAR2)
797: IS
798: SELECT chr_id
799: FROM okc_k_rel_objs
800: WHERE object1_id1 = TO_CHAR (p_object_id)
801: AND jtot_object1_code = p_jtf_id;
802:
803: CURSOR l_wexists_csr (p_jtf_id VARCHAR2)

Line 806: FROM okc_k_rel_objs

802:
803: CURSOR l_wexists_csr (p_jtf_id VARCHAR2)
804: IS
805: SELECT chr_id
806: FROM okc_k_rel_objs
807: WHERE object1_id1 = TO_CHAR (p_object_id)
808: AND jtot_object1_code = p_jtf_id
809: AND rty_code = 'CONTRACTWARRANTYORDER';
810:

Line 1726: x_crjv_tbl_out OUT NOCOPY okc_k_rel_objs_pub.crjv_tbl_type

1722: p_orderlineid IN NUMBER,
1723: x_return_status OUT NOCOPY VARCHAR2,
1724: x_msg_count OUT NOCOPY NUMBER,
1725: x_msg_data OUT NOCOPY VARCHAR2,
1726: x_crjv_tbl_out OUT NOCOPY okc_k_rel_objs_pub.crjv_tbl_type
1727: )
1728: IS
1729: l_api_version CONSTANT NUMBER := 1.0;
1730: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';

Line 1732: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;

1728: IS
1729: l_api_version CONSTANT NUMBER := 1.0;
1730: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
1731: l_return_status VARCHAR2 (1) := 'S';
1732: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;
1733: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
1734: BEGIN
1735: x_return_status := l_return_status;
1736:

Line 1733: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;

1729: l_api_version CONSTANT NUMBER := 1.0;
1730: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
1731: l_return_status VARCHAR2 (1) := 'S';
1732: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;
1733: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
1734: BEGIN
1735: x_return_status := l_return_status;
1736:
1737: IF p_orderhdrid IS NOT NULL

Line 1745: okc_k_rel_objs_pub.create_row (p_api_version => l_api_version,

1741: l_crjv_tbl_in (1).object1_id2 := '#';
1742: l_crjv_tbl_in (1).jtot_object1_code := 'OKX_ORDERHEAD';
1743: --l_crjv_tbl_in( 1 ).rty_code := 'CONTRACTSERVICESORDER';
1744: l_crjv_tbl_in (1).rty_code := p_rty_code;
1745: okc_k_rel_objs_pub.create_row (p_api_version => l_api_version,
1746: p_init_msg_list => l_init_msg_list,
1747: x_return_status => l_return_status,
1748: x_msg_count => x_msg_count,
1749: x_msg_data => x_msg_data,

Line 1760: 'okc_k_rel_objs_pub.create_row(Return status = '

1756: fnd_log.STRING
1757: (fnd_log.level_event,
1758: g_module_current
1759: || '.Create_Obj_Rel.external_call_hdr.after',
1760: 'okc_k_rel_objs_pub.create_row(Return status = '
1761: || l_return_status
1762: || ')'
1763: );
1764: END IF;

Line 1781: okc_k_rel_objs_pub.create_row (p_api_version => l_api_version,

1777: l_crjv_tbl_in (1).object1_id2 := '#';
1778: l_crjv_tbl_in (1).jtot_object1_code := 'OKX_ORDERLINE';
1779: --l_crjv_tbl_in(1).rty_code := 'CONTRACTSERVICESORDER';
1780: l_crjv_tbl_in (1).rty_code := p_rty_code;
1781: okc_k_rel_objs_pub.create_row (p_api_version => l_api_version,
1782: p_init_msg_list => l_init_msg_list,
1783: x_return_status => l_return_status,
1784: x_msg_count => x_msg_count,
1785: x_msg_data => x_msg_data,

Line 1796: 'okc_k_rel_objs_pub.create_row(Return status = '

1792: fnd_log.STRING
1793: (fnd_log.level_event,
1794: g_module_current
1795: || '.Create_Obj_Rel.external_call_line.after',
1796: 'okc_k_rel_objs_pub.create_row(Return status = '
1797: || l_return_status
1798: || ')'
1799: );
1800: END IF;

Line 2383: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;

2379: --Approval WorkFlow
2380: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;
2381: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;
2382: --REL OBJS
2383: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
2384: --Return IDs
2385: l_chrid NUMBER;
2386: l_partyid NUMBER;
2387: l_partyid_v NUMBER;

Line 4834: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;

4830: l_line_status VARCHAR2 (3);
4831: l_priceattrib_id NUMBER;
4832: l_invoice_text VARCHAR2 (2000);
4833: --Obj Rel
4834: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
4835: l_msg_data VARCHAR2 (2000);
4836: l_ind NUMBER;
4837: l_ste_code VARCHAR2 (240);
4838: l_sts_code VARCHAR2 (240);

Line 6722: FROM okc_k_rel_objs

6718:
6719: CURSOR l_ordline_csr (p_line_id NUMBER)
6720: IS
6721: SELECT object1_id1
6722: FROM okc_k_rel_objs
6723: WHERE cle_id = p_line_id;
6724:
6725: CURSOR l_refnum_csr (p_cp_id NUMBER)
6726: IS

Line 7581: FROM okc_k_rel_objs

7577:
7578: CURSOR l_ordline_csr (p_line_id NUMBER)
7579: IS
7580: SELECT object1_id1
7581: FROM okc_k_rel_objs
7582: WHERE cle_id = p_line_id;
7583:
7584: CURSOR check_renewal_link (p_line_id NUMBER)
7585: IS