APPS.OKS_KTO_INSREL_PUB dependencies on OKC_K_HEADERS_B

Line 43: ,p_contract_id IN okc_k_headers_b.ID%TYPE

39:
40:
41: PROCEDURE create_instance_rel(ERRBUF OUT NOCOPY VARCHAR2
42: ,RETCODE OUT NOCOPY NUMBER
43: ,p_contract_id IN okc_k_headers_b.ID%TYPE
44: ) IS
45:
46: l_api_version CONSTANT NUMBER := 1;
47: lx_order_id okx_order_headers_v.id1%TYPE := NULL;

Line 95: ,p_contract_id IN okc_k_headers_b.ID%TYPE

91: ,p_commit IN VARCHAR2 DEFAULT NULL
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_msg_count OUT NOCOPY NUMBER
94: ,x_msg_data OUT NOCOPY VARCHAR2
95: ,p_contract_id IN okc_k_headers_b.ID%TYPE
96: ) IS
97:
98: l_api_name CONSTANT VARCHAR2(30) := 'OKS_KTO_INSREL_PUB_';
99: l_api_version CONSTANT NUMBER := 1;

Line 111: okc_k_headers_b hdr

107: ,osh.instance_id
108: ,osh.dnz_chr_id
109: from oks_subscr_elements ose,
110: oks_subscr_header_b osh,
111: okc_k_headers_b hdr
112: where ose.osh_id=osh.id
113: and osh.dnz_chr_id=hdr.id
114: and hdr.id= p_contract_id
115: and ose.order_header_id is not null;