165: -- The following record structure added as part of shipping parameter form
166: -- changes for 11.5.12
167: TYPE parameter_value_rec_Typ IS RECORD(
168: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
169: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
170: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
166: -- changes for 11.5.12
167: TYPE parameter_value_rec_Typ IS RECORD(
168: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
169: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
170: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
174: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
167: TYPE parameter_value_rec_Typ IS RECORD(
168: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
169: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
170: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
174: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
175:
168: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
169: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
170: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
174: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
175:
176: type row_id_tbl is table of varchar2(50) index by binary_integer;
169: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
170: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
174: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
175:
176: type row_id_tbl is table of varchar2(50) index by binary_integer;
177:
170: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
174: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
175:
176: type row_id_tbl is table of varchar2(50) index by binary_integer;
177:
178: /* Procedure to get the Template Names */