APPS.FND_SIF_UTILS dependencies on FND_SIF_DEFINITIONS

Line 11: l_sif_defn_name fnd_sif_definitions.definition_name%type;

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

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 14: l_sif_service fnd_sif_definitions.service%type;

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:
18: l_erorr_code fnd_soa_runtime_error.error_code%type;

Line 15: l_sif_operation fnd_sif_definitions.operation%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:
18: l_erorr_code fnd_soa_runtime_error.error_code%type;
19: l_error_msg fnd_soa_runtime_error.error_code%type;

Line 16: l_sif_wsdl fnd_sif_definitions.attr1%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:
18: l_erorr_code fnd_soa_runtime_error.error_code%type;
19: l_error_msg fnd_soa_runtime_error.error_code%type;
20: l_error_stack fnd_soa_runtime_error.error_detail%type;

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';