[Home] [Help]
6918: omr.ATTRIBUTE_NAME attribute,
6919: omr.OLD_VALUE old_value,
6920: omr.NEW_VALUE new_value
6921: FROM okc_operation_instances_v oie,
6922: okc_masschange_req_dtls omr
6923: WHERE oie.id = omr.oie_id
6924: AND oie.id = p_oie_id;
6925:
6926: CURSOR Get_cgrp_id(p_chr_id IN Number, p_cgp_id IN Number) IS
7037: okh.billed_at_source
7038:
7039: FROM okc_k_headers_v okh,
7040: okc_operation_lines_v ole,
7041: okc_masschange_req_dtls_v mrd
7042: WHERE ole.select_yn = 'Y'
7043: AND ole.process_flag is NULL
7044: AND okh.id = ole.subject_chr_id
7045: AND ole.id = mrd.ole_id
12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12741:
12742: CURSOR Get_line_req(p_oie_id IN Number) IS
12743: SELECT id from okc_masschange_req_dtls_v
12744: WHERE oie_id = p_oie_id;
12745: BEGIN
12746: --dbms_output.put_line('Inside ..');
12747:
12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12847:
12848: -- CURSOR omrv_id is
12849: -- SELECT ID from OKC_MASSCHANGE_REQ_DTLS_V
12850: -- WHERE oie_id = p_oie_rec.oie_id;
12851: -- */
12852:
12853: BEGIN
13120: l_omrv_tbl_in OKC_OPER_INST_PUB.mrdv_tbl_type; --OPERATION LINES
13121:
13122: CURSOR Get_opn_lines IS
13123: SELECT ole.id ole_id,omr.id omr_id
13124: from OKC_OPERATION_LINES_V ole, OKC_MASSCHANGE_REQ_DTLS_V omr
13125: where ole.id = omr.ole_id
13126: AND omr.oie_id IS NULL
13127: AND ole.oie_id = p_oie_id;
13128: ------------------------------------------------------------------
13972: ,mrd.last_update_date
13973: ,mrd.last_update_login
13974: ,mrd.security_group_id
13975: ,okh.sts_code status_code
13976: FROM okc_masschange_req_dtls mrd,
13977: okc_operation_lines opn,
13978: okc_k_headers_b okh
13979: WHERE mrd.ole_id = opn.id(+)
13980: AND opn.subject_chr_id = okh.id(+) ;