[Home] [Help]
1493:
1494: --san rencol
1495: SELECT l.id,l.object_version_number
1496: bulk collect into l_id_tbl,l_obj_tbl
1497: FROM okc_k_lines_b l, okc_operation_lines a
1498: where a.object_chr_id=p_chr_id and
1499: a.subject_chr_id=p_new_header and
1500: a.active_yn='Y'
1501: and l.id=a.object_cle_id and
2112: SELECT TO_DATE(TO_CHAR(l_cle_rec.start_date, 'dd/mm/yyYY') || TO_CHAR(start_date, 'hh24:mi:ss'), 'dd/mm/yyYYhh24:mi:ss'),
2113: decode(l_cle_rec.end_date, null, null, TO_DATE(TO_CHAR(l_cle_rec.end_date, 'dd/mm/yyYY') || TO_CHAR(end_date, 'hh24:mi:ss'), 'dd/mm/yyYYhh24:mi:ss'))
2114: INTO l_cle_rec.start_date, l_cle_rec.end_date
2115: FROM okc_k_lines_b
2116: WHERE id = (SELECT object_cle_id FROM okc_operation_lines WHERE subject_cle_id = l_cle_rec.id);
2117:
2118: okc_contract_pub.update_contract_line (
2119: p_api_version => 1,
2120: p_init_msg_list => OKC_API.G_FALSE,
3671: FUNCTION is_already_not_renewed(p_chr_id IN NUMBER, p_contract_number IN VARCHAR2, x_msg_name OUT NOCOPY VARCHAR2, p_renewal_called_from_ui IN VARCHAR2) RETURN VARCHAR2 IS
3672: Cursor cur_opn(p_chr_id number) is
3673: SELECT a.subject_chr_id,
3674: a.process_flag -- bugfix 2952330, selecting Process_flag to check the value 'A'
3675: FROM okc_operation_lines a,okc_operation_instances b, okc_class_operations c
3676: where a.object_chr_id=p_chr_id and
3677: c.id=b.cop_id and
3678: c.opn_code in ('RENEWAL', 'REN_CON')
3679: and b.id=a.oie_id and