10: ) IS
11: --PRAGMA AUTONOMOUS_TRANSACTION;
12: BEGIN
13: select jat.created_from into p_created_from
14: from JAI_AR_TRXS jat
15: where jat.customer_trx_id = p_header_id;
16: END;
17:
18: /*Bug 8371741 - End*/
579: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;
580:
581: CURSOR get_header_info_cur IS
582: SELECT organization_id, location_id, batch_source_id
583: FROM JAI_AR_TRXS
584: WHERE customer_trx_id = p_header_id;
585:
586: CURSOR get_register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_batch_source_id NUMBER) IS
587: SELECT register_code