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 1763: FROM okc_operation_instances op

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

Line 5579: FROM okc_operation_instances op,

5575: IS
5576: CURSOR get_object_line_csr
5577: IS
5578: SELECT object_cle_id, OBJECT_CHR_ID
5579: FROM okc_operation_instances op,
5580: okc_operation_lines ol,
5581: okc_class_operations cls,
5582: okc_subclasses_b sl
5583: WHERE ol.oie_id = op.ID

Line 5595: FROM okc_operation_instances op,

5591: p_line_id NUMBER
5592: )
5593: IS
5594: SELECT ol.subject_cle_id, ol.subject_chr_id
5595: FROM okc_operation_instances op,
5596: okc_operation_lines ol,
5597: okc_class_operations cls,
5598: okc_subclasses_b sl
5599: WHERE ol.oie_id = op.ID

Line 6507: FROM okc_operation_instances op,

6503: p_line_id NUMBER
6504: )
6505: IS
6506: SELECT subject_cle_id
6507: FROM okc_operation_instances op,
6508: okc_operation_lines ol
6509: WHERE ol.oie_id = op.ID
6510: AND op.cop_id = 41
6511: AND ol.subject_cle_id = p_line_id;