DBA Data[Home] [Help]

APPS.ECX_ERRORLOG dependencies on ECX_INBOUND_LOGS

Line 102: from ecx_inbound_logs

98:
99: cursor get_curr_trigger_id(p_process_id raw)
100: is
101: select trigger_id
102: from ecx_inbound_logs
103: where process_id = p_process_id;
104:
105: PRAGMA AUTONOMOUS_TRANSACTION;
106: begin

Line 119: update ecx_inbound_logs

115: fetch c_ecx_errorno into i_error_no;
116: close c_ecx_errorno;
117: end if;
118:
119: update ecx_inbound_logs
120: set status = i_status,
121: error_id = i_error_no,
122: logfile = ecx_utils.g_logfile,
123: time_stamp = sysdate

Line 905: insert into ecx_inbound_logs

901: close c_ecx_errorno;
902: end if;
903:
904: begin
905: insert into ecx_inbound_logs
906: (
907: trigger_id,
908: process_id,
909: error_id,

Line 926: update ecx_inbound_logs

922: );
923: exception
924: /** Requires unique index on trigger_id **/
925: when dup_val_on_index then
926: update ecx_inbound_logs
927: set process_id = i_process_id,
928: msgid = i_msgid,
929: error_id = i_error_no,
930: status = i_status,