APPS.GMS_UTILITY dependencies on GMS_BC_PACKETS

Line 314: update gms_bc_packets

310:
311: -- Bug 3416571
312: -- Comment out ,fc_error_message to resolve 1153 compatibility.
313: -- bug 3425948 uncomment out fc_error_message
314: update gms_bc_packets
315: set status_code = 'T' ,
316: result_code = 'F89' , fc_error_message = x_gms_e_stage
317: where packet_id = x_packet_id;
318:

Line 369: from gms_bc_packets gms_pkt

365: FROM gl_bc_packets gl_pkt
366: WHERE gl_pkt.packet_id = x_packet_id
367: AND gl_pkt.template_id is NULL
368: AND exists (select 1
369: from gms_bc_packets gms_pkt
370: where gms_pkt.packet_id = x_packet_id
371: AND gms_pkt.document_type IN ('AP','PO','REQ')
372: AND gms_pkt.source_event_id = gl_pkt.event_id )
373: ) ;

Line 466: UPDATE gms_bc_packets gms

462:
463: -- Bug 3416571
464: -- Comment out ,fc_error_message to resolve 1153 compatibility.
465: --
466: UPDATE gms_bc_packets gms
467: SET gms.status_code = 'T',
468: gms.result_code = DECODE (NVL (SUBSTR (result_code, 1, 1), 'P'),
469: 'P', 'F68',result_code)
470: ,fc_error_message = gms_e_stage