[Home] [Help]
198: FROM okc_operation_lines OPL,
199: okc_k_lines_b cle
200: WHERE OPL.subject_chr_id = p_target_id
201: AND EXISTS (SELECT 'X'
202: FROM okc_operation_instances OPI
203: WHERE OPI.id = OPL.oie_id
204: AND OPI.cop_id = G_RENCON_CLASS_OPERATION_ID -- Bug#5981381: Use cached class_operation_id
205: /* (SELECT ID
206: FROM OKC_CLASS_OPERATIONS
569: ---Get the Operation Instance id
570: ------------------------------------------------------------------
571:
572: CURSOR oper_inst(p_target_id IN NUMBER) IS
573: SELECT id FROM okc_operation_instances
574: WHERE target_chr_id = p_target_id
575: AND cop_id = G_RENCON_CLASS_OPERATION_ID; -- Bug#5981381: Use cached class_operation_id
576: /*(SELECT ID FROM OKC_CLASS_OPERATIONS
577: WHERE OPN_CODE = 'REN_CON' AND CLS_CODE = 'SERVICE');
719: END IF;
720: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'valid_header_sources');
721: END;
722: ----------------------------------------------------------------------------
723: ---Create one record in OKC_OPERATION_INSTANCES_V if x_sources_tbl is not empty
724: ----------------------------------------------------------------------------
725: BEGIN
726: IF x_sources_tbl.COUNT > 0 THEN
727: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
783: END IF;
784: END GET_VALID_LINE_SOURCES;
785:
786: ----------------------------------------------------------------------------
787: ---Create OKC_OPERATION_INSTANCES_V
788: ----------------------------------------------------------------------------
789:
790: PROCEDURE CREATE_OPERATION_INSTANCES (p_target_chr_id IN NUMBER,
791: p_oie_id OUT NOCOPY NUMBER) IS
1746:
1747: --added for MOAC changes
1748: CURSOR c_org_id(cp_oie_id IN NUMBER) IS
1749: SELECT org_id FROM okc_k_headers_all_b WHERE
1750: id = (SELECT target_chr_id FROM okc_operation_instances WHERE id = cp_oie_id);
1751:
1752: req_id NUMBER;
1753: l_mode BOOLEAN;
1754: l_org_id NUMBER;
1914: and h.template_yn = 'N'
1915: and h.sts_code = st.code
1916: and st.ste_code = 'ENTERED'
1917: and h.id in
1918: (select target_chr_id from okc_operation_instances where id = p_oie_id);
1919:
1920:
1921: l_target_header_id NUMBER;
1922: l_source_header_id NUMBER;