APPS.GMS_UTILITY dependencies on GL_BC_PACKETS

Line 103: 'update gl_bc_packets '||

99: ':GMS_USER_ID, :GMS_USER_RESP_ID,:GMS_FLAG,'||
100: ':GMS_CODE_LOCAL'||','||
101: ':GMS_E_CODE'||','||
102: ':GMS_E_STAGE'||') then '||
103: 'update gl_bc_packets '||
104: 'set status_code = ''T'''||
105: ' where packet_id = :GMS_PACKET_ID '||'; '||
106: 'commit; '||
107: 'end if; end;';

Line 141: update gl_bc_packets gl

137:
138: dbms_sql.close_cursor(cursor_name);
139: if l_gms_return_code in ('F','T') then
140: if l_gms_return_code in ('F') then
141: update gl_bc_packets gl
142: set gl.status_code = 'R'
143: where gl.packet_id = x_packet_id;
144: end if;
145: if l_gms_return_code in ('T') then

Line 146: update gl_bc_packets gl

142: set gl.status_code = 'R'
143: where gl.packet_id = x_packet_id;
144: end if;
145: if l_gms_return_code in ('T') then
146: update gl_bc_packets gl
147: set gl.status_code = 'T'
148: where gl.packet_id = x_packet_id;
149: end if;
150: l_gl_return_code := 'F';

Line 326: UPDATE gl_bc_packets SET

322: where packet_id = x_packet_id;
323:
324: End if;
325: x_gms_return_code := l_gms_return_code ;
326: UPDATE gl_bc_packets SET
327: result_code = DECODE (NVL (SUBSTR (result_code, 1, 1), 'P'),'P', 'F71',result_code)
328: WHERE packet_id = x_packet_id;
329:
330: --

Line 365: FROM gl_bc_packets gl_pkt

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
368: AND exists (select 1
369: from gms_bc_packets gms_pkt

Line 457: UPDATE gl_bc_packets gl

453: gms_e_stage := substr('gms_utility.gms_util_gl_return_code:'||SQLCODE||':'||SQLERRM,1,2000);
454:
455: -- Bug : 2557041 - Changed F00 to F71 , F00 was a generic code, F71 result code is for unexpected error
456:
457: UPDATE gl_bc_packets gl
458: SET gl.result_code = DECODE ( NVL (SUBSTR (result_code, 1, 1), 'P'),
459: 'P', 'F71',result_code
460: )
461: WHERE gl.packet_id = x_packet_id;