APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_K_LINES_B

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

1093:
1094: --vthiruva start, 15-Sep-2004
1095: --code changes to enable business events
1096: --cursor to fetch line style of sub line and parent line id.
1097: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
1098: SELECT lse.lty_code lty_code,
1099: lines.id fee_line_id
1100: FROM okc_line_styles_b lse,
1101: okc_k_lines_b subline,

Line 1101: okc_k_lines_b subline,

1097: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
1098: SELECT lse.lty_code lty_code,
1099: lines.id fee_line_id
1100: FROM okc_line_styles_b lse,
1101: okc_k_lines_b subline,
1102: okc_k_lines_b lines
1103: WHERE subline.id = p_line_id
1104: AND lines.id = subline.cle_id
1105: AND lse.id = subline.lse_id;

Line 1102: okc_k_lines_b lines

1098: SELECT lse.lty_code lty_code,
1099: lines.id fee_line_id
1100: FROM okc_line_styles_b lse,
1101: okc_k_lines_b subline,
1102: okc_k_lines_b lines
1103: WHERE subline.id = p_line_id
1104: AND lines.id = subline.cle_id
1105: AND lse.id = subline.lse_id;
1106:

Line 1108: l_parent_line_id okc_k_lines_b.id%TYPE;

1104: AND lines.id = subline.cle_id
1105: AND lse.id = subline.lse_id;
1106:
1107: l_lty_code okc_line_styles_b.lty_code%TYPE;
1108: l_parent_line_id okc_k_lines_b.id%TYPE;
1109: l_parameter_list wf_parameter_list_t;
1110: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
1111: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;
1112: --vthiruva end, 15-Sep-2004

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

4417: CURSOR is_batch_process IS
4418: SELECT FND_GLOBAL.conc_request_id
4419: FROM dual;
4420:
4421: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
4422: SELECT lty_code
4423: FROM okc_k_lines_b line,
4424: okc_line_styles_b style
4425: WHERE line.lse_id = style.id

Line 4423: FROM okc_k_lines_b line,

4419: FROM dual;
4420:
4421: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
4422: SELECT lty_code
4423: FROM okc_k_lines_b line,
4424: okc_line_styles_b style
4425: WHERE line.lse_id = style.id
4426: AND line.id = p_line_id;
4427:

Line 4431: p_line_id okc_k_lines_b.id%TYPE) IS

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

Line 4439: l_service_top_line_id okc_k_lines_b.id%TYPE;

4435: AND rlobj.cle_id = p_line_id
4436: AND rlobj.rty_code = 'OKLSRV'
4437: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
4438:
4439: l_service_top_line_id okc_k_lines_b.id%TYPE;
4440:
4441: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
4442: SELECT dnz_chr_id
4443: FROM okc_k_lines_b

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

4437: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
4438:
4439: l_service_top_line_id okc_k_lines_b.id%TYPE;
4440:
4441: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
4442: SELECT dnz_chr_id
4443: FROM okc_k_lines_b
4444: WHERE id = p_serv_top_line_id;
4445:

Line 4443: FROM okc_k_lines_b

4439: l_service_top_line_id okc_k_lines_b.id%TYPE;
4440:
4441: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
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: