DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_K_HEADERS_B

Line 86: p_chr_id okc_k_headers_b.id%TYPE;

82: ,p_event_name IN WF_EVENTS.NAME%TYPE
83: ,p_event_param_list IN WF_PARAMETER_LIST_T
84: )IS
85: l_process VARCHAR2(20);
86: p_chr_id okc_k_headers_b.id%TYPE;
87: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
88: BEGIN
89: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
90: l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);

Line 4483: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,

4479: AND line.id = p_line_id;
4480:
4481: l_line_style okc_line_styles_b.lty_code%TYPE;
4482:
4483: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
4484: p_line_id okc_k_lines_b.id%TYPE) IS
4485: SELECT rlobj.object1_id1
4486: FROM okc_k_rel_objs_v rlobj
4487: WHERE rlobj.chr_id = p_chr_id

Line 4499: l_serv_contract_id okc_k_headers_b.id%TYPE;

4495: SELECT dnz_chr_id
4496: FROM okc_k_lines_b
4497: WHERE id = p_serv_top_line_id;
4498:
4499: l_serv_contract_id okc_k_headers_b.id%TYPE;
4500:
4501: l_process_type VARCHAR2(20);
4502: l_request_id NUMBER := -1;
4503: l_parameter_list wf_parameter_list_t;