APPS.FND_SIF_UTILS dependencies on FND_SIF_DEFINITIONS_VL

Line 12: l_sif_defn_dname fnd_sif_definitions_vl.display_name%type;

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;
15: l_sif_operation fnd_sif_definitions.operation%type;
16: l_sif_wsdl fnd_sif_definitions.attr1%type;

Line 13: l_sif_description fnd_sif_definitions_vl.description%type;

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;
15: l_sif_operation fnd_sif_definitions.operation%type;
16: l_sif_wsdl fnd_sif_definitions.attr1%type;
17:

Line 51: FROM fnd_sif_definitions_vl d

47:
48: begin
49: SELECT display_name, description, attr1, service, operation
50: INTO l_sif_defn_dname, l_sif_description, l_sif_wsdl, l_sif_service, l_sif_operation
51: FROM fnd_sif_definitions_vl d
52: WHERE d.definition_name = l_sif_defn_name;
53: exception
54: when no_data_found then
55: l_sif_defn_dname := 'Not Found';