APPS.FND_SIF_UTILS dependencies on FND_SOA_REQUEST

Line 10: l_sif_inst_id fnd_soa_request.message_id%type;

6: p_act_id in number,
7: p_func_mode in varchar2,
8: p_result_out out nocopy varchar2)
9: as
10: l_sif_inst_id fnd_soa_request.message_id%type;
11: l_sif_defn_name fnd_sif_definitions.definition_name%type;
12: l_sif_defn_dname fnd_sif_definitions_vl.display_name%type;
13: l_sif_description fnd_sif_definitions_vl.description%type;
14: l_sif_service fnd_sif_definitions.service%type;

Line 36: FROM fnd_soa_request

32: if (l_sif_defn_name is null) then
33: begin
34: SELECT irep_name
35: INTO l_sif_defn_name
36: FROM fnd_soa_request
37: WHERE message_id = l_sif_inst_id;
38: exception
39: when no_data_found then
40: l_error_msg := 'Service Invocation Instance ID '||l_sif_inst_id||' not found';