1 PACKAGE ec_execution_utils AUTHID CURRENT_USER as
2 -- $Header: ECXUTILS.pls 115.0 99/08/05 21:24:40 porting ship $
3
4 /**
5 Stack for List of Parameters for a stored procedure or function
6 **/
7 TYPE t_parameter is RECORD
8 (
9 procedure_name varchar2(80),
10 parameter_name varchar2(80),
11 data_type pls_integer,
12 in_out pls_integer,
13 value varchar2(32000)
14 );
15
16 /**
17 PL/SQL table for parameter List
18 **/
19 TYPE t_procparameters is table of t_parameter index by BINARY_INTEGER;
20
21
22 /**
23 Stack for List of Procedures/Functions to be executed.
24 Overloaded procedures name is listed once but the parameter stack will have
25 entries for all overloaded procedures.
26 **/
27
28 TYPE t_procedures is RECORD
29 (
30 procedure_name varchar2(80),
31 cursor_handle pls_integer,
32 execution_clause varchar2(32000),
33 stack_start_pos pls_integer,
34 stack_end_pos pls_integer
35 );
36
37 /**
38 PL/SQL table for list of procedures
39 **/
40 TYPE t_proclist is TABLE of t_procedures index by BINARY_INTEGER;
41
42 -- Generic mapping of a Stored Procedure / Function
43 TYPE t_procmapping is RECORD
44 (
45 transtage_id pls_integer,
46 procedure_name ece_tran_stage_data.custom_procedure_name%TYPE,
47 parameter_name ece_procedure_mappings.parameter_name%TYPE,
48 action_type pls_integer,
49 variable_level pls_integer,
50 variable_name ece_procedure_mappings.variable_name%TYPE
51 );
52
53 /**
54 Stack for Procedure and their mappings to the Data Stack variables.
55 **/
56 TYPE t_procedure_mappings is table of t_procmapping index by BINARY_INTEGER;
57
58 -- Executes a Given Stored Procedure / Function
59 procedure runproc
60 (
61 i_procedure_name in varchar2
62 );
63
64 procedure assign_values
65 (
66 i_transtage_id IN pls_integer,
67 i_procedure_name IN varchar2,
68 i_action_type IN pls_integer
69 );
70
71 procedure load_mappings
72 (
73 i_transaction_type in varchar2,
74 i_map_id in pls_integer
75 );
76
77 end ec_execution_utils;