APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_K_LINES_B

Line 1150: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS

1146:
1147: --vthiruva start, 15-Sep-2004
1148: --code changes to enable business events
1149: --cursor to fetch line style of sub line and parent line id.
1150: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
1151: SELECT lse.lty_code lty_code,
1152: lines.id fee_line_id
1153: FROM okc_line_styles_b lse,
1154: okc_k_lines_b subline,

Line 1154: okc_k_lines_b subline,

1150: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
1151: SELECT lse.lty_code lty_code,
1152: lines.id fee_line_id
1153: FROM okc_line_styles_b lse,
1154: okc_k_lines_b subline,
1155: okc_k_lines_b lines
1156: WHERE subline.id = p_line_id
1157: AND lines.id = subline.cle_id
1158: AND lse.id = subline.lse_id;

Line 1155: okc_k_lines_b lines

1151: SELECT lse.lty_code lty_code,
1152: lines.id fee_line_id
1153: FROM okc_line_styles_b lse,
1154: okc_k_lines_b subline,
1155: okc_k_lines_b lines
1156: WHERE subline.id = p_line_id
1157: AND lines.id = subline.cle_id
1158: AND lse.id = subline.lse_id;
1159:

Line 1161: l_parent_line_id okc_k_lines_b.id%TYPE;

1157: AND lines.id = subline.cle_id
1158: AND lse.id = subline.lse_id;
1159:
1160: l_lty_code okc_line_styles_b.lty_code%TYPE;
1161: l_parent_line_id okc_k_lines_b.id%TYPE;
1162: l_parameter_list wf_parameter_list_t;
1163: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
1164: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;
1165: --vthiruva end, 15-Sep-2004

Line 4474: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS

4470: CURSOR is_batch_process IS
4471: SELECT FND_GLOBAL.conc_request_id
4472: FROM dual;
4473:
4474: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
4475: SELECT lty_code
4476: FROM okc_k_lines_b line,
4477: okc_line_styles_b style
4478: WHERE line.lse_id = style.id

Line 4476: FROM okc_k_lines_b line,

4472: FROM dual;
4473:
4474: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
4475: SELECT lty_code
4476: FROM okc_k_lines_b line,
4477: okc_line_styles_b style
4478: WHERE line.lse_id = style.id
4479: AND line.id = p_line_id;
4480:

Line 4484: p_line_id okc_k_lines_b.id%TYPE) IS

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
4488: AND rlobj.cle_id = p_line_id

Line 4492: l_service_top_line_id okc_k_lines_b.id%TYPE;

4488: AND rlobj.cle_id = p_line_id
4489: AND rlobj.rty_code = 'OKLSRV'
4490: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
4491:
4492: l_service_top_line_id okc_k_lines_b.id%TYPE;
4493:
4494: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
4495: SELECT dnz_chr_id
4496: FROM okc_k_lines_b

Line 4494: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS

4490: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
4491:
4492: l_service_top_line_id okc_k_lines_b.id%TYPE;
4493:
4494: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
4495: SELECT dnz_chr_id
4496: FROM okc_k_lines_b
4497: WHERE id = p_serv_top_line_id;
4498:

Line 4496: FROM okc_k_lines_b

4492: l_service_top_line_id okc_k_lines_b.id%TYPE;
4493:
4494: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
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: