611:
612: r_src_rec c_get_src_rec%rowtype;
613: r_dest_rec c_get_dest_rec%rowtype;
614:
615: cursor c_get_man_trx_rec (cp_trx_number jai_rgm_manual_trxs.transaction_number%type)
616: is
617: select party_type
618: , party_id
619: , transaction_date
618: , party_id
619: , transaction_date
620: , remarks
621: , invoice_number
622: from JAI_RGM_MANUAL_TRXS
623: where transaction_number = cp_trx_number;
624:
625: r_man_trx_rec c_get_man_trx_rec%rowtype;
626:
3204: and customer_trx_line_id = rec.document_line_id;
3205:
3206: elsif rec.transaction_source = 'MANUAL' then
3207:
3208: update jai_rgm_manual_trxs
3209: set service_type_code = rec.service_type_code
3210: , last_update_date = sysdate
3211: , last_updated_by = lv_user_id
3212: where transaction_number = rec.document_id;