DBA Data[Home] [Help]

APPS.OKL_TXD_ASSETS_PVT dependencies on OKC_K_HEADERS_B

Line 43: p_chr_id IN okc_k_headers_b.id%TYPE,

39: -- End of comments
40:
41: PROCEDURE raise_business_event(p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2,
43: p_chr_id IN okc_k_headers_b.id%TYPE,
44: p_asset_id IN okc_k_lines_b.id%TYPE,
45: p_event_name IN VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,

Line 140: l_chr_id okc_k_headers_b.id%TYPE;

136: AND tal.id = txd.tal_id
137: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')
138: AND txd.tal_id = p_tal_id;
139:
140: l_chr_id okc_k_headers_b.id%TYPE;
141: l_cle_id okc_k_lines_b.id%TYPE;
142:
143: /*
144: * sjalasut added cursor to derive the contract header id and contract line id. END

Line 922: l_chr_id okc_k_headers_b.id%TYPE;

918: AND tal.id = txd.tal_id
919: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')
920: AND txd.id = p_id;
921:
922: l_chr_id okc_k_headers_b.id%TYPE;
923: l_cle_id okc_k_lines_b.id%TYPE;
924:
925: /*
926: * sjalasut added cursor to derive the contract header id and contract line id. END