[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
568: ---Get the Operation Instance id
569: ------------------------------------------------------------------
570:
571: CURSOR oper_inst(p_target_id IN NUMBER) IS
572: SELECT id FROM okc_operation_instances
573: WHERE target_chr_id = p_target_id
574: AND cop_id = G_RENCON_CLASS_OPERATION_ID; -- Bug#5981381: Use cached class_operation_id
575: /*(SELECT ID FROM OKC_CLASS_OPERATIONS
576: WHERE OPN_CODE = 'REN_CON' AND CLS_CODE = 'SERVICE');
718: END IF;
719: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'valid_header_sources');
720: END;
721: ----------------------------------------------------------------------------
722: ---Create one record in OKC_OPERATION_INSTANCES_V if x_sources_tbl is not empty
723: ----------------------------------------------------------------------------
724: BEGIN
725: IF x_sources_tbl.COUNT > 0 THEN
726: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
782: END IF;
783: END GET_VALID_LINE_SOURCES;
784:
785: ----------------------------------------------------------------------------
786: ---Create OKC_OPERATION_INSTANCES_V
787: ----------------------------------------------------------------------------
788:
789: PROCEDURE CREATE_OPERATION_INSTANCES (p_target_chr_id IN NUMBER,
790: p_oie_id OUT NOCOPY NUMBER) IS
1744:
1745: --added for MOAC changes
1746: CURSOR c_org_id(cp_oie_id IN NUMBER) IS
1747: SELECT org_id FROM okc_k_headers_all_b WHERE
1748: id = (SELECT target_chr_id FROM okc_operation_instances WHERE id = cp_oie_id);
1749:
1750: req_id NUMBER;
1751: l_mode BOOLEAN;
1752: l_org_id NUMBER;
1912: and h.template_yn = 'N'
1913: and h.sts_code = st.code
1914: and st.ste_code = 'ENTERED'
1915: and h.id in
1916: (select target_chr_id from okc_operation_instances where id = p_oie_id);
1917:
1918:
1919: l_target_header_id NUMBER;
1920: l_source_header_id NUMBER;