[Home] [Help]
4259: SELECT distinct ol.object_chr_id
4260: FROM okc_operation_instances op
4261: , okc_class_operations cls
4262: , okc_subclasses_b sl
4263: , okc_operation_lines ol
4264: WHERE ol.subject_chr_id = p_target_chr_id
4265: And op.id = ol.oie_id
4266: AND op.cop_id = cls.id
4267: And cls.cls_code = sl.cls_code
4268: And sl.code = 'SERVICE'
4269: And cls.opn_code in ('RENEWAL','REN_CON');
4270:
4271: /*SELECT distinct object_chr_id
4272: FROM okc_operation_lines
4273: WHERE subject_chr_id = p_target_chr_id;
4274: --AND active_yn = 'Y';
4275: */
4276:
4276:
4277:
4278: Cursor ole_csr2(p_subject_chr_id NUMBER, p_object_chr_id NUMBER) Is
4279: SELECT count(*)
4280: FROM okc_operation_lines
4281: WHERE SUBJECT_CHR_ID = p_subject_chr_id
4282: AND OBJECT_CHR_ID = p_object_chr_id
4283: AND SUBJECT_CLE_ID is not null;
4284:
4285: Cursor cle_csr(p_subject_chr_id NUMBER, p_object_chr_id NUMBER) Is
4286: SELECT count(*)
4287: FROM okc_k_lines_b
4288: WHERE id IN (SELECT OBJECT_CLE_ID
4289: FROM okc_operation_lines
4290: WHERE SUBJECT_CHR_ID = p_subject_chr_id
4291: AND OBJECT_CHR_ID = p_object_chr_id)
4292: AND dnz_chr_id = p_object_chr_id;
4293:
4319: last_update_date = sysdate,
4320: last_update_login = FND_GLOBAL.LOGIN_ID
4321: WHERE id in (
4322: SELECT distinct object_chr_id
4323: FROM okc_operation_lines
4324: WHERE subject_chr_id = p_target_chr_id
4325: AND active_yn = 'Y');
4326: --
4327: -- Set date renewed on all source contracts if all lines are renewed
4355: -- set operation lines.active_yn = Y or N
4356: -- for the contract entry in operation lines table
4357: -- subject_chr_id is the child/renewed_to chr id
4358: --
4359: UPDATE okc_operation_lines ol
4360: SET active_yn = l_active_yn,
4361: object_version_number = object_version_number + 1,
4362: last_updated_by = FND_GLOBAL.USER_ID,
4363: last_update_date = sysdate,
4387: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4388: FROM okc_operation_instances op
4389: , okc_class_operations cls
4390: , okc_subclasses_b sl
4391: , okc_operation_lines ol
4392: WHERE ol.subject_chr_id = p_target_chr_id
4393: And ol.object_cle_id is not null
4394: And op.id = ol.oie_id
4395: AND op.cop_id = cls.id
4401: -- To set renewal link of contract lines,
4402: -- set operation lines.active_yn = Y or N
4403: -- for the contract line entries in operation lines table
4404: --
4405: UPDATE okc_operation_lines ol
4406: SET active_yn = l_active_yn,
4407: object_version_number = object_version_number + 1,
4408: last_updated_by = FND_GLOBAL.USER_ID,
4409: last_update_date = sysdate,
5079: --Fix Bug#4927824 18-JAN-2006 maanand
5080:
5081: cursor trn_source_code (p_target_line_id NUMBER) IS
5082: Select term_cancel_source, object_cle_id
5083: from okc_k_lines_b olb, okc_operation_lines opl
5084: where olb.id= p_target_line_id
5085: and ( ( opl.object_cle_id = olb.id )
5086:
5087: OR
5111:
5112: --Fix Bug#4927824 18-JAN-2006 maanand
5113: --Made changes to this query to make is semanitically correct
5114:
5115: UPDATE okc_operation_lines
5116: SET active_yn = l_active_yn,
5117: object_version_number = object_version_number + 1,
5118: last_updated_by = FND_GLOBAL.USER_ID,
5119: last_update_date = sysdate,
5137: last_update_date = sysdate,
5138: last_update_login = FND_GLOBAL.LOGIN_ID
5139: WHERE id in
5140: ( SELECT object_cle_id
5141: FROM okc_operation_lines ol1
5142: WHERE ol1.subject_cle_id = p_target_line_id );
5143:
5144:
5145: -- clear date_renewed only for those lines in target sub lines
5151: last_update_date = sysdate,
5152: last_update_login = FND_GLOBAL.LOGIN_ID
5153: WHERE cle_id in
5154: ( SELECT object_cle_id
5155: FROM okc_operation_lines ol1
5156: WHERE ol1.subject_cle_id = p_target_line_id );
5157:
5158:
5159: END IF;