APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_OPERATION_INSTANCES

Line 99: --| OKC_OPERATION_INSTANCES | X | | | | | |

95: --| OKC_K_HEADERS_B_S | X | | | | | |
96: --+---------------------------------+---+---+---+---+---+----------------------+
97: --| OKC_OPERATION_LINES | X | | | | | |
98: --+---------------------------------+---+---+---+---+---+----------------------+
99: --| OKC_OPERATION_INSTANCES | X | | | | | |
100: --+---------------------------------+---+---+---+---+---+----------------------+
101: --| OKC_K_ITEMS_V | X | | | | | |
102: --+---------------------------------+---+---+---+---+---+----------------------+
103: --| OKC_K_LINES_V | X | | | | | |

Line 187: FROM okc_operation_instances

183: p_batch_id NUMBER
184: )
185: IS
186: SELECT ID
187: FROM okc_operation_instances
188: WHERE cop_id = p_cop_id
189: AND target_chr_id = p_chr_id
190: AND batch_id = p_batch_id
191: AND status_code = 'PROCESSED';

Line 196: ,okc_operation_instances Ins

192:
193: Cursor check_rec_exists(P_Id Number) Is
194: Select 'X'
195: From Okc_operation_lines ol
196: ,okc_operation_instances Ins
197: Where ol.subject_chr_id = P_target_chr_id
198: And ol.object_chr_id = p_source_chr_id
199: And ol.subject_cle_id Is Null
200: And ol.object_cle_id Is Null

Line 234: INSERT INTO OKC_OPERATION_INSTANCES(

230: l_oper_instance_id := l_oie_id;
231:
232: ELSE
233: l_oper_instance_id := okc_p_util.raw_to_number (SYS_GUID ());
234: INSERT INTO OKC_OPERATION_INSTANCES(
235: id,
236: cop_id,
237: status_code,
238: object_version_number,

Line 1767: FROM okc_operation_instances op

1763:
1764: Function get_modifier(Contract_id Number) return varchar2 Is
1765: Cursor l_renewal_csr Is
1766: SELECT object_chr_id
1767: FROM okc_operation_instances op
1768: , okc_class_operations cls
1769: , okc_subclasses_b sl
1770: , okc_operation_lines ol
1771: WHERE ol.subject_chr_id = contract_id

Line 5596: FROM okc_operation_instances op,

5592: IS
5593: CURSOR get_object_line_csr
5594: IS
5595: SELECT object_cle_id, OBJECT_CHR_ID
5596: FROM okc_operation_instances op,
5597: okc_operation_lines ol,
5598: okc_class_operations cls,
5599: okc_subclasses_b sl
5600: WHERE ol.oie_id = op.ID

Line 5612: FROM okc_operation_instances op,

5608: p_line_id NUMBER
5609: )
5610: IS
5611: SELECT ol.subject_cle_id, ol.subject_chr_id
5612: FROM okc_operation_instances op,
5613: okc_operation_lines ol,
5614: okc_class_operations cls,
5615: okc_subclasses_b sl
5616: WHERE ol.oie_id = op.ID

Line 6524: FROM okc_operation_instances op,

6520: p_line_id NUMBER
6521: )
6522: IS
6523: SELECT subject_cle_id
6524: FROM okc_operation_instances op,
6525: okc_operation_lines ol
6526: WHERE ol.oie_id = op.ID
6527: AND op.cop_id = 41
6528: AND ol.subject_cle_id = p_line_id;