359: l_new_api varchar2(1) ;
360:
361: CURSOR c_new_api IS
362: SELECT 'Y'
363: FROM dual
364: WHERE EXISTS ( SELECT 1
365: FROM gl_bc_packets gl_pkt
366: WHERE gl_pkt.packet_id = x_packet_id
367: AND gl_pkt.template_id is NULL