DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_K_HEADERS_B

Line 77: p_chr_id okc_k_headers_b.id%TYPE;

73: ,p_event_name IN WF_EVENTS.NAME%TYPE
74: ,p_event_param_list IN WF_PARAMETER_LIST_T
75: )IS
76: l_process VARCHAR2(20);
77: p_chr_id okc_k_headers_b.id%TYPE;
78: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
79: BEGIN
80: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
81: l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);

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

4426: AND line.id = p_line_id;
4427:
4428: l_line_style okc_line_styles_b.lty_code%TYPE;
4429:
4430: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
4431: p_line_id okc_k_lines_b.id%TYPE) IS
4432: SELECT rlobj.object1_id1
4433: FROM okc_k_rel_objs_v rlobj
4434: WHERE rlobj.chr_id = p_chr_id

Line 4446: l_serv_contract_id okc_k_headers_b.id%TYPE;

4442: SELECT dnz_chr_id
4443: FROM okc_k_lines_b
4444: WHERE id = p_serv_top_line_id;
4445:
4446: l_serv_contract_id okc_k_headers_b.id%TYPE;
4447:
4448: l_process_type VARCHAR2(20);
4449: l_request_id NUMBER := -1;
4450: l_parameter_list wf_parameter_list_t;