521: -- | a table in a standard format, so future code generation can |
522: -- | simply loop through this table. |
523: -- +---------------------------------------------------------------------------+
524: TYPE g_param_rec_type is RECORD
525: (local_form pay_trigger_parameters.parameter_name%type,
526: usage_type pay_trigger_parameters.usage_type%type,
527: param_form pay_trigger_parameters.parameter_name%type,
528: value_name pay_trigger_parameters.value_name%type,
529: data_type dba_tab_columns.data_type%type); -- Bug 15882261
522: -- | simply loop through this table. |
523: -- +---------------------------------------------------------------------------+
524: TYPE g_param_rec_type is RECORD
525: (local_form pay_trigger_parameters.parameter_name%type,
526: usage_type pay_trigger_parameters.usage_type%type,
527: param_form pay_trigger_parameters.parameter_name%type,
528: value_name pay_trigger_parameters.value_name%type,
529: data_type dba_tab_columns.data_type%type); -- Bug 15882261
530: --
523: -- +---------------------------------------------------------------------------+
524: TYPE g_param_rec_type is RECORD
525: (local_form pay_trigger_parameters.parameter_name%type,
526: usage_type pay_trigger_parameters.usage_type%type,
527: param_form pay_trigger_parameters.parameter_name%type,
528: value_name pay_trigger_parameters.value_name%type,
529: data_type dba_tab_columns.data_type%type); -- Bug 15882261
530: --
531: TYPE g_params_tab_type is TABLE of g_param_rec_type
524: TYPE g_param_rec_type is RECORD
525: (local_form pay_trigger_parameters.parameter_name%type,
526: usage_type pay_trigger_parameters.usage_type%type,
527: param_form pay_trigger_parameters.parameter_name%type,
528: value_name pay_trigger_parameters.value_name%type,
529: data_type dba_tab_columns.data_type%type); -- Bug 15882261
530: --
531: TYPE g_params_tab_type is TABLE of g_param_rec_type
532: index by binary_integer;